Structured query language for data management of vehicles and road traffic accidents

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.