Database Development and Management Tools
Many companies create various multi-functional applications to facilitate the management, development and administration of databases.
Most relational databases consist of two separate components: a “back-end” where data is stored and a “front-end” —a user interface for interacting with data. This type of design is smart enough, as it parallels a two-level programming model that separates the data layer from the user interface and allows you to concentrate the software market directly on improving its products. This model opens doors for third parties who create their own applications for interacting with various databases.
Database development tools can be used to create varieties of the following programs:
- client programs;
- database servers and their individual components;
- custom applications.
The programs of the first and second types are rather small since they are intended mainly for system programmers. The third type packages are much larger, but smaller than full-featured DBMS.
The development tools for custom applications include programming systems, various program libraries for various programming languages, and development automation packages (including client-server systems).
Database management system, abbr. DBMS (Eng. Database Management System, abbr. DBMS) - a set of software and linguistic tools for general or special purposes, providing management of the creation and use of databases.
DBMS - a set of programs that allow you to create a database (DB) and manipulate data (insert, update, delete and select). The system ensures the safety, reliability of storage and data integrity, as well as provides the means to administer the database.
F.A.Q. about Database Development and Management Tools
The main functions of the DBMS:
- data management in external memory (on disk);
- data management in RAM using disk cache;
- change logging, backup and recovery of databases after failures;
- support for database languages (data definition language, data manipulation language).
The composition of the DBMS:
Usually, a modern DBMS contains the following components:
- the core, which is responsible for managing data in external and RAM and logging;
- database language processor, which provides the optimization of requests for the extraction and modification of data and the creation, as a rule, of a machine-independent executable internal code;
- a run-time support subsystem that interprets data manipulation programs that create a user interface with a DBMS;
service programs (external utilities) that provide a number of additional capabilities for maintaining an information system.