Problem of Choosing a DBMS in Modern Information System
Pavel V. Openko, Spartak Y. Hohoniants, Olena V. Starkova, Kostiantyn Herasymenko, Mykola Yastrebov, Andrii O. Prudchenko · 2019 IEEE International Conference on Advanced Trends in Information Theory (ATIT) · 2019
This work is devoted to choosing a DBMS in modern information systems. DBMS (Database Management System) is a software package designed to define, manipulate, retrieve and manage data in a database; OLTP (Online Transactional Processing) is a category of data processing that is focused on transaction-oriented tasks and typically involves inserting, updating, and/or deleting small amounts of data in a database; OLAP (Online Analytical Processing) is a computing method that enables users to easily and selectively extract and query data in order to analyze it from different points of view; ACID (an acronym for Atomicity, Consistency, Isolation, Durability) is a concept that Database professionals generally use when evaluating databases and application architectures; SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them.