Method for automatically creating database and dynamically recording data on the basis of configuration file

Abstract

The invention belongs to the category of data management and data application, and relates to the improvement of a database creating process and a data recording and displaying process. The invention provides a method for automatically creating a database and dynamically recording data on the basis of a configuration file by aiming at an application scene that a relational database is used for recording and managing data. The method clearly defines the general format of the configuration file, compiles the configuration file according to a practical data structure, can automatically create the database and generates a data table on the basis of data configuration information. In a data recording process, a SQL (Structured Query Language) statement is dynamically generated according to the configuration information to store the data into the database. In a data analysis process, required data can be extracted from the database according to the configuration information and is visually displayed. The method can effectively adapt to data structure change and augmentation, and a new configuration file can be updated or complied to automatically generate a new database and a corresponding data recording and displaying function.

Description

technical field [0001] The invention belongs to the category of database management and application, and relates to an improvement to the process of database creation and data dynamic recording. Background technique [0002] In some application scenarios that process and analyze large amounts of data, such as business data processing, simulation data recording, and information management systems, these application scenarios all have application characteristics that require creating data record formats and persisting data. In order to meet these application characteristics, it is more common to use relational databases to store and manage data in the actual implementation process. With the increase in the amount of data and the diversification of data structures, it is necessary to write data recording and display programs for specific data structures by manually creating databases and data tables, which is highly coupled with data structures. When the original data structur...

AI Technical Summary

Problems solved by technology

With the increase in the amount of data and the diversification of data structures, it is necessary to write data recording and display programs for specific data structures by manually creating databases and data tables, which is highly coupled with data structures

When the original data structure changes or a new data structure needs to be added, it is necessary to manually change the style of the corresponding data table in the database, update the data record and display program, the scalability is limited, and the later maintenance cost is high

Images