UDC 681.3.06
RELATION DATABASE SCHEME COMPARISON ALGORITHM BASED ON SUBJECT AREA SEMANTICS ANALYSIS
A. I. Baranchikov, Dr. Sc. (Tech.), full professor, RSREU, Ryazan, Russia; This email address is being protected from spambots. You need JavaScript enabled to view it.
N. Z. Nguyen, post-graduate student, RSREU, Ryazan, Russia; This email address is being protected from spambots. You need JavaScript enabled to view it.
The task of comparing database schemes obtained in two ways is considered: experimental analysis and research of existing databases. The aim of this article is to use an algorithm for comparing the equivalence of a database scheme obtained in two ways: experimental analysis and research of existing databases. An algorithm is proposed for comparing two sets of functional dependencies for equivalence. The results of applying this algorithm are given. The scientific novelty of this article is to use comparative results to identify inconsistencies in data bases. This allows you to reduce the time in designing databases that use old data base, containing in its structure information about subject area semantics. The practical application of this work can be used to design a relational database with a low probability of errors.
Key words: comparative analysis, databases, key, experimental analysis, database research, functional dependency, relational database, database scheme.