How to approach differs from traditional concepts of the database file system

How to approach differs from traditional concepts of the database file system A database is a collection of interrelated data stored in a database server, the data will be stored in tabular form. The main purpose of the database is to provide a way to store and retrieve information from databases quickly and efficiently. There are several characteristics that differ from traditional file system. In file system approach, each user defines and implements the files needed to run a particular application. For example, in the sales department of a company, you will keep the details of the number of sales personnel in the department of sales and quality, such data will be archived and stored in a separate file. Another user will be to maintain the salary details seller in an effort to work, how salary is stored and maintained in a separate file. Even if both users are interested in data from sellers who have their data in separate files and programs that need to manipulate files. This results in waste of space and duplication and data redundancy, which can lead to confusion, the exchange of data between different users is not possible, data inconsistencies may occur. These files have no relationship between the data recorded in these files. Therefore, in the processing of files of all users will be the definition of constraints and the implementation of the necessary files for applications. Focus on the database, a single repository of data remains to be defined once and then access to many users. The key feature of the database is that the database system contains not only data, but contains a complete description or definition of the database structure and constraints. These definitions are stored in a system catalog, which contains information on the structure and definitions of the database. The information stored in the catalog is called metadata, which describes the main database. Therefore, this approach to work in any type of database, for example, the database of insurance companies, airlines, databases, financial arrangements, the Company and information from the database. But in the traditional system of processing of the application file is developed for a specific purpose and will have access to a specific database only. The other main feature of the database is to allow multiple users to simultaneously access the database and data exchange is possible. The database should include competition control software to ensure that more users try to update the same data at the same time it must maintain a controlled manner. In file system approach, many programmers will be the creation of files for a long time and several file format, application in different languages. As a result, you may obtain copies of this redundancy is storing the data multiple times leads to high costs and a waste of space. This can lead to data inconsistency in the application, this must be done to update some files and not all the files. In addition to focusing on the basis of data from multiple points of view can be created. Vista is a representation of the information contained in one or more tables. See also known as "virtual table", because the records do not contain physically stored and do not occupy space. Multi-user database, which users have variety of applications must provide facilities for defining multiple views. In traditional file system, if you make changes to the structure of the file, if will affect all programs in order to change the structure of a file may request to change any programs that access the file. But in the case of the database for the structure of the database is stored separately in the system catalog for access by application programs. This property is known as a program of independence of data. Database can be used to provide storage for program objects and data structures that gave rise to object-oriented database approach. Experienced the traditional impedance mismatch problem and difficulty of access to data, which is avoided in the database system object oriented. Database can be used to represent the complex relations between the data and to retrieve and update data in a simple and efficient. You can define and enforce integrity constraints of the data stored in the database. The database also provides facilities for recovering from hardware failures and software. Backup and recovery subsystem is responsible for recovery. This significantly reduces the development time of applications when compared with the approach of the file system and the availability of updated information for all users. It also provides for the security of data stored in the database system.