Database Management / DBM 502
June 25, 2006
This paper will discuss the implementation, use of an enterprise DBMS, the advantages and disadvantages of an enterprise DBMS. A database management system , or DBMS, gives the user access to their data and helps them transform the raw data into information. The DBMS is just a collection of programs that manages the database structure and controls access to the data stored in the database. These systems allow users to create, update, and extract information from their databases. When the mainframes dominated enterprise computing, the DBMS architecture was simpler concern. Mostly everything ran on the mainframe and that was that. Even for a mainframe DBMS implementation, the overall architecture will likely consist of multiple platforms and interpreting pieces of system software. Information technology experts should include database resource management representatives including data administrators, database administrators, and system administrators. However, you always want to be sure that the DBMS you select is appropriate for the nature of business and type of processing you plan to implement. There are four level of DBMS architecture that you can chose or selected from: enterprise, departmental, personal, and mobile.
Levels of DBMS Architecture
An enterprise DBMS is designed for salability and high performance. It must be capable of supporting very large databases, a large number of concurrent users, and multiple types of applications. The enterprise DBMS will run on a large-scale machine, typically a mainframe or a high-end UNIX, Linux, or Windows NT machine. Furthermore, an enterprise DBMS offers all of the "bells and whistles" available from the DBMS vendor. Mulit-processor support, support for parallel queries, clustering, and other advanced DBMS features will be core components of an...