Data generation method and device

Abstract

The invention discloses a data generation method and device. The method comprises the steps that multi-table joint configuration information is read; analyzing the multi-table joint configuration information to generate a new table data model; and analyzing the multi-table joint configuration information to generate new table data updating logic. According to the data generation method provided by the invention, the multi-table joint query logic does not need to be developed, the source table data does not need to be regularly traversed to generate the new table data, and the new table data can be automatically generated and updated only by configuring the structural definition of the new table data, so that the complexity of data joint query is reduced, and the query efficiency is improved; and meanwhile, the data generation logic and the new table data use logic of multi-table joint query are decoupled, so that the maintainability of the system is improved while the real-time performance and the system performance are ensured.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a method and device for generating data. Background technique [0002] The database (DB) of a software system usually refers to the database structure generated by the database management program and the data stored in the database structure. The database is the basis of the software system. In the process of software development, the database structure is usually defined as multiple independent substructures, which are called data tables or data collections (here we collectively refer to them as data tables). Some system functions can complete the corresponding work by calling one or more data tables independently, but some system functions need to combine the data in multiple data tables to complete the corresponding work. Although a good database structure design can reduce the coupling between database tables to a certain extent and reduce the complexity of multi-t...

AI Technical Summary

Problems solved by technology

Although a good database structure design can reduce the coupling between database tables to a certain extent and reduce the complexity of multi-table joint query, multi-table joint query is inevitable

[0003] In order to deal with the multi-table joint query, software developers currently have two main methods: one is the runtime joint query, that is, when the data needs to be queried, the data in multiple data tables is combined, and real-time processing is performed by filtering, sorting, data processing, etc. Obtaining the required data from multiple data tables, this method has good real-time performance, but the complexity of joint query is high, and when modifying the joint mode of multiple tables, it is necessary to modify the joint query statement in the code, which has poor maintainability; the second is By transferring the data in multiple required data tables (referred to as source tables here) to a new data table (referred to as new tables here), the system does not need to combine multi-table queries when running, only It is only necessary to perform a single-table query in the new table according to specific conditions. This method reduces the complexity of the joint query, but because the data is usually updated from the source table to the new table at regular intervals, it is difficult to take into account real-time performance and system performance. And when modifying the joint method of multiple tables, it is necessary to modify the rule code generated by the new table, which has poor maintainability

Images