Year: 2026
Type: article
Abstract: The article studies implementation of the structured query language (SQL) in systematizing data on vehicles, their owners, and road traffic accidents (RTAs) within an integrated information environment. The paper aims to develop and validate a method for designing a relational database that ensures accounting integrity and financially precise automated calculation of insurance payments. The work structures table with vehicle registration plates data using DDL scripts, which include constraints for data compliance with state standards. The authors perform the key business logic with an SQL query that applies conditional logic and aggregation for the accurate accounting of liability limits under the compulsory motor third party liability insurance. The study contains a comparison of the relational approach with non-relational (NoSQL) and scalable relational (NewSQL) methods. It is concluded that standard SQL systems are most efficient for accounting tasks requiring strong consistency with ACID properties and calculation transparency.
Source: Vestnik kibernetiki
Authors: D. Yu. Zorkin, N. V. Asanova
Institution: Volgograd State Technical University
Language: English
Subfield: Information Systems
Field: Computer Science
Domain: Physical Sciences
Open Access status: green
OpenAlex ID: W7154393003