Thursday, April 2, 2009

DBMS ARCHITECTURE

There are a number of tasks that database architecture must handle. One of them is selecting which DBMS would best fit a newly developed application. Selecting the proper DBMS is not a simple task for there are different types of each DBMS for different architectures and purposes.A team consisting of business and IT experts will decide on the final architecture which will be based on the business needs of the organization.
These are the four basic needs:
-entreprise
-departmental
-personal
-website

DBMS SOFTWARE EXAMPLES
-Oracle
Oracle is one of the world's most widely used DBMS. It is usually selected for large database projects and for high traffic websites. When it comes to efficiency data storing capability and reliability: database administrators swear by it.
-MySQL
The SQL Server DBMS runs on Windows Systems and is usually less expensive than competing DBMS. It is the most most popular open source database.
-Microsoft Access
Microsoft Access is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is included in the higher versions for Windows, a member of the Microsoft Office suite of application and it is also sold seperatly.

Resources:
http://en.wikipedia.org/wiki/Database_management_system#Examples_of_Database_Management_Systems http://www.edumax.com/database-basics-understanding-dbms.html www.is.fsksm.utm.my/taib/upload_files/SCK2413/DBMS%20Architecture.ppt

No comments:

Post a Comment