Database (or database, and English database or DB abbreviation)
It is a means used to store neat data on a computer, there
Retrieving and processing them. A database is stored on a data storage device,
Usually a hard disk, which allows direct access to data. The approach
The database is made using dedicated software – a management system
Database Management System (DBMS). Base
The data is built according to a model for storing the data, such as internal sorting mechanisms
And for searching.
Database Types (Common):
Hierarchical database model
It is the oldest model for organizing databases. Old databases
Many are still based and working according to this model. According to this model the data
Organized in a tree structure according to their role hierarchy and relationship
Including. Data can be accessed from the root and through the tree branches, from above
down. Each record can be used as a “parent” for a record or level entries
Below it (boys). In the same way each son may have his own sons.
Relational database:
In this model, the database is built from tables, with each table containing
Information about a particular entity (for example, banking system customers). And for all
An entry in the table has an ID field that uniquely identifies the entry.
The connections between the records in the various tables are made through a field
This special is called a key field. Retrieving baseline information and update operations
Tabular data is done using SQL language, which is an interface
Allowing access to data without regard to how it is stored at the base
The data.
Common databases:
Database | Developer | License | Written in |
Oracle | Oracle Corporation | Proprietary | Assembly language, C, C++ |
MySQL | Oracle Corporation | GPL (version 2) or proprietary | C, C++ |
Microsoft SQL Server | Microsoft Corporation | Proprietary | C, C++ |
PostgreSQL | PostgreSQL Global Development Group | PostgreSQL License (free and open-source, permissive) | C |
MongoDB | MongoDB Inc. | Various | C++, C, JavaScript |
DB2 | IBM | Proprietary EULA | Assembly language, C, C++ |
Redis | Salvatore Sanfilippo | BSD | ANSI C |