Data operation management device and data operation management method

Abstract

The invention provides a data operation management device and a data operation management method. The data operation management device comprises a mapping relationship management module, a service operation fragment management module, an object change management module and a database table processing module, wherein the mapping relationship management module acquires mapping relationship between a service object and a database table corresponding to the service object in the database; the service operation fragment management module sets a service operation fragment, wherein the service operation fragment comprises one or more service operations; the object change management module records the operating state of the operated service object when carrying out service operation on any service object in the service operation segment; and when all the service operations in the service operation fragment are completed, the database table processing module processes all the database tables corresponding to all the service objects in the database according to the operating states and mapping relationships of all the service objects in the service operation fragment. By using the invention, the operating states of the service objects can be centrally recorded; and after executing the database connection once, the operation on the data tables corresponding to the service objects can be completed.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a data operation management device and a data operation management method. Background technique [0002] In software information systems, especially ERP systems, data is stored in databases. In the early software development, SQL was directly written to realize the operation of the database. Later, it developed into object-oriented programming. All operations on data were performed on the object first, and then the database operation was performed according to the object. In this way, SQL generation based on the object appeared. Technology. [0003] In the prior art, in one case, the method for generating SQL statements is that developers with certain writing experience use codes to construct the relationship between tables in the database according to database entities, and then write SQL statements. This method of manually writing SQL statements has relatively high ...

AI Technical Summary

Problems solved by technology

Based on the existing technology, each object operation will eventually generate and execute a SQL. A business operation may need to generate tens of thousands of SQL statements, and may also require multiple database connections. This will undoubtedly increase the burden on the database and waste precious database resources. Resources, also affect the execution efficiency of the program, timeout occurs, and may even cause the system to crash

Images