want to know the best database software for a medium sized company?
1. Can you please tell me what are the various database software available in the world.
2. merits and demerits of each of them
3. where to get those softwares and price details.
4. how to backup access database
5. Can we have an access for multiple user, and if yes how to go about it.
6. how to integerate a database to a good website
7. what are the various website tools available.
8. what are the security issues should be kept in mind to have a very secure database and a website.
9. Is it advisable to purchase a predesigned software or employ some good programmer aand do it solely for the company.
Please do help me in this as I have to submit a report on this issues to my company. i would be very greatful if i get a very detailed answer.
i hope i will be able to answer your questions, I am a novice developer myself but here goes
1. Oracle, MYSQL, MSSQL
2. Oracle - Powerfull, high cost, for Medium to large scale businesses
MSSQL -> Trying to catch up to oracle, a little lower on cost, for medium to large scale business
MYSQL -> Cost efficient, for medium scale business
3. You have to find a provider for those databases, you can search them on yahoo to find out which one’s nearest you.
4. You can use queries then transfer them to another access database or, just make a copy of it
5. You can have access for multiple user as long as those multiple users dont access the data simultaneously, You can make it available on a network and link it to your system. Not very adviseable though.
6. Find out first what database and what website you want, PHP goes well with MYSQL database, .NET(aspx) pages goes well with MSSQL database, Oracle goes well with java-based websites because they can be implemented on unix systems too. but dont get mistaken, they can be interchanged too. PHP can be used for oracle and so on. it is up to you and up to the knowledge of the developer and what is needed by a client.
7. there are a lot I can only mention a few, Visual studio.NET
for ASPX pages, NETBEANS for java based. you can use dreamweaver it can make just about anything. but it would be adviseable to use something that is really built for that page.
8. SQL injection. users can modify the address bar and it could use sql scripts to destroy your data. It would be adviseable to convert parameters to another data type like integer to avoid strings. Do not use cookies to store valuable information. use Sessions instead. use secure socket layer(SSL) your address will be instead of what it does is encrypt data so when you send or recieve requests, it will not be intercepted. Verising is a good example of SSL certificate provider. Secure your database, create different schemas(users) for different transactions like update, insert
do not use “sa” or sysdba users in accessing databases. and of course, use firewall
9. Purchasing a predesigned software is good. but if you really want control, you might need to employ programmers and database administrators. You have more control over your own system. you will be able to know what’s wrong immediately if the system will crash, support and maintennance is in-house and if you decide to create a new software, you can have your programmers do it.
I hope this would help.
Comment by Johann J — 12-08-2008 @ 14:47