How Database Approach Differs from Traditional File System

The database is a mutually data collection, stored in the database server; format of these data is stored in the table. The main purpose of the database is to provide a way to store and retrieve database information quickly and efficiently.

There are many different characteristics of traditional file management system. Approach to the file system, each user is defined as necessary to implement the file, to perform a specific application. For example, sales in the enterprise sector, is one of many users to maintain sales for more information about how the sales department of personnel and the magnitude of these details, other files stored and maintained in. .

Another user's salary is more work to maintain a salesman, concern and the salary detailed report will be stored and maintained in separate files. However, both data users interested in the details of their clerks they will file another, separate program to manipulate the necessary files. This will lead to a waste of space and data redundancy and duplication, which may lead to confusion, among users of various data sharing is not possible, data inconsistencies can occur. These files can not be any relationship between the data in the files have been stored. Therefore, the conventional file processed by all users to implement their own definitions of constraints and the need applications.

Database approach is to maintain a single repository of data has been defined many users at once, and then accessed by. Database basic approach is characterized by the following data only includes specific data, however, it is a complete definition and description of the database structure and constraints. These definitions are stored in the system catalog, which include information about the database structure is defined. Catalog that are stored information is called metadata, which describes the PURAIMARIDETABESU. Therefore this approach has worked on all types of databases, for example, a database of insurance, airline, banking database, financial details, and company information database. However, traditional file processing system, applications are developed for specific purposes in SAKA had access only to specific databases.

Other major features of the database is that it allows multiple users to access the database in the same time and data can be shared. Database software to include parallel processing control, but multiple users to ensure the same data and update them at the same time, it must maintain proper control. File system approach to many programmers and file will be created over a long period in various file formats are different from the language used in various applications.

It is a potential for duplication of information to get the redundancy of the same data more than once, leading to higher costs and waste storage space. As a result, the data may be inconsistencies in the application, it is a complete update of some files, not only all the files. The database approach, several Views can be. View the presentation of information together, one or more included in the table. And also called as a "virtual table" display is not included in the physical SUTOADOREKODO can occupy any space.

MARUCHIYUZADETABESU users in a variety of application services must be defined to provide multiple views. Traditional file system, if any changes are made to the structure of the files, programs that affect all of the files changes to the structure of all the changes that are required to file program Access. However, the database approach is the case, the structure of the database stored separately in the system catalog to access the application program. This property is called data independence program.

Database to provide a persistent storage of the program used the resulting data objects and object-oriented database structure approach. Impedance mismatch suffering from the traditional system problems and difficulties in accessing the data, which is avoided by object-oriented database. Complex database that can be used to describe relations between data acquisition, as well as update the relevant data quickly and efficiently.

It is possible to define the force and consistency of the data stored in a database constraints. They also offer facilities, hardware and software to recover the database to fail. Backup and recovery subsystem is responsible for recovery. Application development time is greatly reduced compared to the file system approach and availability of the latest information to all users. In addition, to provide security data, stored in the database.

Source : Free Article