Does NothingDoes NothingDoes NothingDoes Nothing NowtAdminCase Studiesmodule1Module2Module3Module4Module5Module6Glossary  
nowtPolicy / StrategySoftware evaluationDatabase managementDistributed SystemsNetwork security and accountingHuman Computer InteractionHuman Computer InterfaceSoftware DevelopmentSoftware reliabilityPortability of Datanowt
NowtManaging DatabasesThe database administratorEntities and AtributesRelational DatabasesNormalisationClient - Server DatabasesQuestions 1Questions 2Nowt
 

Database Management Concepts

When computers were first used for data processing each application would have its own data file. Thus in a company selling goods by mail order the customer accounts program, the stock control program, the payroll program would each have its own file. This leads to duplication of data in different files. The accounts file would contain data about customers and stock, which would be duplicated in the customer and stock files respectively. When this happens we say that there is data redundancy in the system. Application specific files can be represented as two-dimensional tables and are therefore called flat files .

Data redundancy creates the following problems:

  1. Storage space is not being used efficiently.
  2. If the same data is in a number of locations then a change that data requires a number of different files to be updated. This might not be possible at a particular time leading to inconsistency of data where the same data item has different values in different parts of the system.
  3. Data redundancy can also lead to data inconsistency because the same item of data may need to be entered manually in the different files. This could lead to an account number or name being typed wrongly or perhaps data being shortened or abbreviated in different ways and so appearing as different values in the different files. If each of the different files needs to be updated manually then it will almost certainly be the case that some files contain the latest values while others do not.

A database attempts to reduce data redundancy by integrating the data in the different files. The database in managed by a Database Management System. Application programs access the data through the database management system, which is a layer of software between the data and the application. All access to the data and all editing will be through the DBMS. In addition to providing logical record data to application programs the DBMS will also be responsible for the following system functions:

  1. Maintaining data by adding new records, deleting old records and amending the data stored in a record.
  2. Providing data security by protecting it against unauthorised access and corruption.
  3. Handling error situations and recovering from them - e.g. loss of power.
  4. Maintaining access statistics for billing purposes.

The Database Approach aims to achieve the following:

Avoid data redundancy By replacing redundant data by link fields pointing to the appropriate record in another file.
Maintain data consistency By reducing data redundancy.
Provide data independence Ensure that the way that the data is stored does not depend on the needs of any one application. This is achieved by the DBMS collecting data together from the physical records to form a logical record that is then presented to a particular application program. A logical record may be composed of fields from several different physical records in different files. The DBMS provides the application with a view of the data that makes it look as though the record structure is exactly as required for that application. Each application that uses the data sees logical records that exactly match its needs. The underlying data structure is however independent of any one application's specific needs
   

©LEV