Database Management System Essay Example | Topics and Well Written Essays - 1500 words

Database Management System - Essay Example It is essential or the organization to develop an effective database system. Database is defines as a system, used to record and maintains data. The most important point to understand database is that database contains data and not necessarily information. The database is a collection of interrelated data, which can be used by one or more applications that it can be integrated and is stored in a shared and organized way so that it has a controlled redundancy, consistency and integrity with a provision of data independence. The database is used to store and process data for providing useful organization. The database must have the following basic objectives i.e., centrally controlled which facilitates data can be stored, processed, modified or accessed in a organized way. Database must be organized in such a way that the redundancy and inconsistency can be avoided as much as possible. Database must be centrally controlled so that its integrity, security and privacy can be maintained d atabase must be logically organized, integrated, designed to multi used application and provision for data independence whether physical or logical. So a database system is a system, which defines, interprets, manipulates and maintains a collection of database, which is entirely separate in structure. Database management system (DBMS) is the major component of the database system. The DBMS is the foundation of almost every modern business information system. Database management system is defined as a system so software that organizes and maintains the data in a database for providing the information. A DBMS is a very complex piece of system software. A single DBMS can manage multiple databases each one usually consisting of many different tables full of data. The DBMS includes mechanism for application programs to store, retrieve and modify this data and also allows people to query it interactivity to answer specific questions. DBMS can be divided into four major components i.e. Database, Database administrator (DBA), Database users and database programs specialists known as DBA's control the operation of the DBMS and are respon sible for the creation of new data bases and the definition of the table structures used to store data. One of the most important features of the DBMS is its ability to shield the people and programs using the data from the details of its physical storage. Because all access to stored data is mediated through the DBMS, a database can be restructured or moved to a different computer without disrupting the programs written to use it. The DBMS polices access to the stored data, giving access only to tables and records for which a given user has been authorized. The DBMS evolved from a more humble class of programs known as file management systems, created within the unglamorous world of corporate data processing to simplify the creation of programs for routine administration. The database management system conflated the managerial concept of the database with the specific technology of the file management system. In practice, the DBMS worked well as technical system to aid application programmers but disappointed as a managerial panacea (Haigh, 2006). The corporate database has originally been conceived as a repository of all-important managerial information; actual DBMS technology supported only the kind of highly structured regular records with which earlier file management s