Abstract: This paper explores the issue of group integrity of tuple subsets regarding corporate integrity constraints in relational databases. A solution may be found by applying the finite-state machine theory to guarantee group integrity of data. We present a practical guide to coding such an automaton. After creating SQL queries to manipulate data and control its integrity for real data domains, we study the issue of query performance, determine the level of transaction isolation, and generate query plans.
DOI: *As the DOI is a unique identifier, it is already available in the pdf version. **The DOI link will be activated in the first midst of January 2026.
WSEAS Transactions on Information Science and Applications, ISSN / E-ISSN: 1790-0832 / 2224-3402, Volume 14, 2017, Art. #28
Andrey Malikov, Vladimir Voronkin, Nikolay Shiryaev, "Employing Finite-State Machines in Data Integrity Problems," WSEAS Transactions on Information Science and Applications, vol. 14, pp. 287-295, 2017, DOI:
Andrey Malikov, Vladimir Voronkin, Nikolay Shiryaev. Employing Finite-State Machines in Data Integrity Problems.
WSEAS Transactions on Information Science and Applications. 2017;14:287-295.