|
Structures of small database management systems
|
| bet | 2/3 | | Sana | 12.01.2024 | | Hajmi | 29 Kb. | | #135504 |
Bog'liq Ma\'qola yanvar №4 engDBMM classification . By type of model received:
1) Hierarchical - relationships between database objects form an inverted tree, ie each main element of the hierarchy is connected with one element above it.
2) Network - communication between data objects can be established in any order
3) Schema - each piece of information in the database is identified by a table name, defined identifier and field name
4) There are object-oriented mechanisms for constructing data in the form of language extensions and software addresses across the core of objects that contain object-specific information.
5) object-oriented - based on a combination of three principles: Short model, standards for describing objects and principles, object-oriented programming
By architecture:
local databases (all data and objects on the same computer) and distribution (data and objects on different computers)
By accessing the database:
1) Film-Server - on each client's computer, and access to data is carried out through the local network.
2 ) client-server - providing coverage of access between user and network and use between machines.
3) installed - refers to the program library. Data is accessed by querying the SQL language or by calling application functions from the application
In terms of processing speed:
Operational (high speed to retrieve and provide information) and data warehouses (takes a lot of time because there are a lot of data bases)
The DBMS performs the following functions:
1) Data abstracts, dictionary management to search for the necessary data structures and their DBMS relations uses a data dictionary, avoiding coding of such complex relations in each program.
2) Data storage management - DBMS creates the complex structures required for data storage, freeing programmers from defining physical data properties and software
3) Data transformation and tariff - DBMS includes the task of transforming them into a form convenient for storage, inputting them to form and forming them. Ensuring data independence, the DBMS transforms logical queries into commands that specify their physical location and extraction
4) Security management - DBMS creates a security system in the database that ensures user protection and data privacy
5) Manage multiplayer access - DBMS creates complex structures that provide access to multiple users at the same time
6) Backup and recovery management - DBMS has a backup and data recovery procedure that ensures their safety and integrity.
7) Data integrity management - DBMS provides information that ensures data integrity, which allows data transfer and ensuring their consistency
8) Support for data entry and exit programs - DBMS provides access to data using a query language (necrotic language, ie).
9) database - the interface of interactions with the current generation, the database provides special collaboration programs that allow you to provide records in a network environment
It should be noted that modern database servers are often provided with a modeling tool for the "object-relationship" model or other means of creating data schemas.
|
| |
