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

Database Management System - Essay ExampleIt is essential or the boldness 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 assembling of interrelated data, which can be used by one or more coverings that it can be integrated and is stored in a shared and organised 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 down 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, trade protection and privacy can be maintained database 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 forethought system (DBMS) is the major component of the database system. The DBMS is the alkali 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 from each one one usually consisting of many opposite 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 swear out specific quest ions. DBMS can be divided into four major components i.e. Database, Database administrator (DBA), Database users and database programs specialists known as DBAs control the operation of the DBMS and are prudent 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 necrose 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 true DBMS technology supported only the kind of highly structured regular records with which earlier file management s