January 13, 2008

want to know the best database software for a medium sized company?


1. Please can you tell me what are the different software available databases in the world.
2. Advantages and disadvantages of each of them
3. Where do I get the software and price details.
4. How to make a backup of database access
5. Can we have access for multiple users, and if so how to go about it.
6. How integerate a database for a good Web site
7. What are the various tools available site.
8. What are the security issues should be kept in mind to have a comprehensive database and a secure website.

9. Is it advisable to buy a software or predefined employ some good programmer and do so only for the company.

Please help me do what I have to submit a report on these issues in my business. I would be very grateful if i get a very detailed answer.

1 comment:

backup guy said...

(From old blog's comments)
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 - Mighty, the high cost means for the large-scale
MSSQL -> Try to catch up oracle, a little further down on the cost, medium and large enterprise
MYSQL -> Cost efficient, medium-sized enterprises
3. You need to find a supplier for databases, you can search on Yahoo to find the one nearest you.
4. You can use query and then transfer them to another database or access, it is enough to make a copy of it
5. You can have access to multiple users longer than those whose access to multiple users simultaneously the data, you can make it available on a network and to connect it to your system. Not very well advised.
6. To find out first the site of the database and what you want, PHP goes well with the database MYSQL,. NET (aspx) pages is fine with the database MSSQL, Oracle goes well with Web sites based on Java because they can be implemented on unix systems. But dont get wrong, they can be interchanged. PHP can be used to the oracle, and so forth. It's up to you and knowledge of the client, and what is required by a client.
7. There are many, I can only mention a few, Visual studio.NET
ASPX pages, NETBEANS for java based. You can use Dreamweaver he can do just about everything. But it would be advisable to use something that is really built for this page.
8. SQL Injection. Users can change the address bar, and he could use some SQL scripts to destroy your data. It would be advisable to convert to a different parameters such as integer data type to avoid strings. Do not use cookies to store information. Sessions used instead. Using secure socket layer (SSL) will be your https: / / instead of http:// what it does is encrypt data so that when you send or receive requests, it will not be intercepted. Verising is a good example of SSL certificate provider. Secure your database, create different patterns (users) for operations such as updating, inserting
Do not use "its" or sysdba users for access to databases. And of course, the use of firewalls
9. The purchase of a predefined software is good. But if you really want to monitor, you might need to employ programmers and database administrators. You have more control over your own system. You will be able to know what is not immediately whether the system will crash, support and maintennance is in the house and if you decide to create a new program, you can have your programmers to do so.


I hope that will help.