USING THE SQL QUERY LANGUAGE WHEN DESIGNING INFORMATION SYSTEMS
As one of the priority directions at the moment, the development and operation of banks and databases in information systems, as well as the development of applications based on database management systems (DBMS) are the basis of practical implementation that reflects the current understanding of the processes of transformation and consumption of information in the information society. However, this direction has not found its full application in all applied areas, in particular in the oil and gas industry. This article discusses issues in the field of information systems implementation related to the use of information technologies in creating a database using the structured query language SQL, with emphasis on the development of an information system for automating the analysis and accounting of fuel and lubricants consumption data. The SQL language allows you to accept SQL queries from other DBMS components and user applications. SQL is a powerful tool that provides users, programs, and computing systems with access to information contained in relational databases. At the same time, we should note a number of disadvantages inherent in the SQL language: inconsistency of the relational data model, complexity, and deviations from standards.