Increase Efficiency of Relational Databases Using Instruments of Second Normal Form
Oleksandr Rolik, Kseniia Ulianytska, Maryna Khmeliuk, Volodymyr Khmeliuk, Uliana Kolomiiets · 2021
Supporting and administrating relational databases is one of the important stages of application lifecycle. This article explains the difference between Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems and, basically, represents one more method to increase efficiency of storing data and changing logical model for improving executing SQL (Structured Query Language) constructions. Not only the task of designing relational databases is the subject of scientific research, because there are many problems appears till application is in use. The article focuses on the normalization of databases and to use Normal Form in area of efficiency OLTP based application.