Generic database manipulator

Abstract

A middle layer in business applications is provided to wrap all the database management operations generically, to store changed data temporarily, to validate and lock the data before updating the database, and to synchronize the data change and unlock it as a whole when a commit method is called. In embodiments, only six generic methods are needed for all data interactions. Transaction, isolation level, exception format, and performance tuning operations can be performed centrally in the six generic methods. A buffer section may be created in the middle layer. Operations such as insert, update, delete, and select are performed on data stored in the buffer. Buffered data may then be stored in a data storage device.

Description

Background technique [0001] The present invention relates to a data management system for a database that responds to data manipulation requests initiated by a number of users. Such databases are particularly useful in business management systems, computer networks that facilitate common business tasks such as placing purchase orders, preparing quotations, scheduling product shipments, and the like. In such systems, the database stores various data records known as "business objects" that are used to store data about these business tasks, as well as information about customers, manufacturers, suppliers, and ”) information on other business records. An enterprise management system may provide support to several operators who may issue concurrent and possibly conflicting requests addressing the same data record. Data consistency errors may arise if multiple requests to the database (referred to herein as "transactions") are performed without mutual consideration. [0002] Cur...

AI Technical Summary

Problems solved by technology

Some databases or platforms may not support primary key and foreign key checks

Images