Enterprise Database Management System Paper

Enterprise Database Management System Paper

Tania Hillard

Database Management / DBM 502

Pamela Hurd

June 25, 2006

Introduction

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

Enterprise DBMS

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 enterprise DBMS.

Departmental DBMS

A departmental DBMS, sometimes referred to as a work group DBMS, supports small to medium sized work groups within an organization, and typically runs on a UNIX, Linux, or Windows 2000(or NT) server. Hardware and software upgrades often can allow a departmental DBMS to tackle tasks that previously could only be performed by an enterprise DBMS.

Personal DBMS

A personal DBMS is designed to be used by a single user, typically on a low-to-medium powered PC platform. Microsoft Access and dBase are examples of personal database software. Of course, the major DBMS vendors also market personal versions of their more high-powered solutions, personal Oracle and DB2 are everyplace for example. Sometimes the low cost of a personal DBMS causes misguided attempts to choose a personal DBMS for a departmental or enterprise solution. A personal DBMS product is suited only for small-scale projects and should not be used to deploy multi-user applications.

Mobile DBMS

The mobile DBMS is a specialized version of a departmental or enterprise