Database management system (DBMS)
A DBMS is a software complex for creating, modifying, searching and processing information in databases, ensuring security, integrity and access control.
What is a DBMS
A DBMS (database management system) is a software complex for creating, modifying, searching and processing information in databases. The DBMS acts as a link between the database and applications, ensuring security, integrity, backup and access control.
DBMS are the foundation of most corporate systems, including the Electronic Budget GIS, document flow systems, BPMS and low-code platforms.
Types of DBMS
- Relational (SQL) — PostgreSQL, Oracle, MySQL.
- Non-relational (NoSQL) — MongoDB, Redis, Cassandra.
- Object — for CAD/CAM systems.
- Graph — Neo4j.
Main DBMS functions
CRUD operations, integrity, security, backup and recovery, indexing.
Russian DBMS: import substitution
- Postgres Pro — FSTEC certified.
- Tantor.
- Red Database.
- LINTER.
Frequently asked questions
How is a DBMS different from a database?
A database is the data itself. A DBMS is the program that manages it. PostgreSQL is a DBMS; the data it stores is a database.
Which DBMS are used in Russia for import substitution?
Postgres Pro, Tantor, Red Database and LINTER, included in the Register of Russian Software.
What is a relational DBMS and when is it used?
Data organized as linked tables, using SQL, providing ACID transactions. Used in banks and document flow.
What is NoSQL and when is it used?
NoSQL does not use traditional relational models. Used for unstructured data and high loads: MongoDB, Redis, Cassandra, Neo4j.
How do I choose a DBMS for a project?
Consider data structure, transaction requirements, volume, load, scaling and certification requirements.
How is security ensured in DBMS for government systems?
What skills are needed to work with a DBMS?
SQL knowledge, database normalization, query optimization. Administrator skills include performance tuning and backup management.
Other terms in «Import substitution»
Was this information helpful?
Switch to Russian software with us
Switch to domestic software without losing functionality. We will run an audit, select analogues and perform migration.