Database technology

        Database technology has improved over the issues of organizing data with traditional file systems. Rather than storing data in separate files for each application, data are stored physically to appear to the user as being stored in only one location. A database is a collection of data organized to serve many applications efficiently by centralizing the data and minimizing redundant data. A single database services multiple applications. For example, instead of a corporation storing employee data in separate information systems and separate files for personnel, payroll, and benefits, the organization could create a single common Human Resources database to integrate all of those functions and processes. A database management system (DBMS) is the software that allows the organization to centralize data, manage them efficiently, and provide access to the stored data by application programs. The DBMS acts as the interface between application programs the physical data tables. A database management system has three components: a data definition language, a data manipulation language, and a data dictionary.