Why
Use a Database?
There are a many uses for databases. It might be easy to imagine all of the uses for a database on a commercial website, such as an online store for a business. These databases can store visitor information for logging in, purchase information, order logs, bookkeeping information, company reports, pricing structures, account information - the list goes on!
On the other hand, for business and personal purposes - including those that are not website-based - databases offer an excellent way to store, organize, and sort large sets of information.
What Types of Databases are There?
DBMSs (Data Base Management Systems) come in many different types; however, there are two basic types: Enterprise and Personal.
Enterprise DBMSs are designed primarily for use with databases that need to handle large amounts of data/information, both coming in and out, and are commonly used by corporations and government organizations. These types of databases are also highly scalable. Scalability refers to how well the database handles multiple, simultaneous transactions. For example, a high scalability would mean that the database could handle thousands of transactions or more at the same time.
A few examples of Enterprise DBMSs include Microsoft's SQL Server, Oracle, and IBM's DB2.
Personal DBMSs are generally not highly scalable. These databases are intended for use as learning tools or in low demand situations.
A few examples of Personal DBMSs include Microsoft's Access, MySQL, and a personal-version of Oracle.
How Do I Know Which One is Best for Me?
You should consider both your present needs and reasonable future expectations. The best way to determine which database system fits your needs would be to consult a professional in this field.
Here are some DBMSs Website Shapers can help you with:
Microsoft's SQL Server - Click here for the SQL Server home page on Microsoft's web site.
Microsoft's Access - Click here to check out this very popular personal/small business DBMS.
MySQL - Click here to check out this very popular personal/small business Open Source DBMS.
PostSQL - Click here to check out this sophisticated Object-Relational DBMS.
Oracle - Click here to view the Oracle website.
|