Data management method and system as well as database system

Abstract

The embodiment of the invention discloses a data management method and a system as well as a database system. The method comprises the following steps of: transmitting a data request message to the database system, wherein the data request message contains a user data identification sent by a client; receiving user data and a first version of information of the user data, which are transmitted by the database system; transmitting the user data to the client; receiving and storing the user data which is submitted by the client and is modified, and locking the user data in the database system; comparing whether the first version of information is the same as that the current version of information of the user data in the database system or not; and if so, writing the modified user data into the database system.

Description

technical field [0001] The invention relates to the field of communication technology, in particular to a data management method and system, and a database system. Background technique [0002] Regional Health Information Network (RHIN) is an individual-centered regional electronic medical record (Electronic Medical Record, EMR) and electronic health record (Electronic Health Record, EHR) storage and sharing platform, the business of various medical institutions The information system (Point of Service, POS) is connected to RHIN in the form of a client, and can upload or share a resident's electronic health record. EMR and EHR can be shared among various medical information systems (Hospital Information System, HIS) through RHIN. [0003] EMR and EHR are stored in relational databases. In relational databases, the contextual consistency of data (that is, the modification of a piece of data by a certain person will not overwrite the modification of the data by others) and co...

AI Technical Summary

Problems solved by technology

[0004] There are at least the following problems in the prior art: start a transaction when a user reads data, and add an exclusive lock to the data in the database, which can control the concurrent access to the data and ensure the consistency of the data, but at the same time lock time Excessive length reduces the performance of concurrent access to data, resulting in a decrease in system access throughput, and the maintenance of the exclusive lock mechanism requires the central processor to broadcast or query the data exclusive locks of each node in the entire database system, and the management overhead is large; When the user submits the modified data, the transaction is started, and an exclusive lock is added to the data in the database, which has little impact on the performance of concurrent access to the data, but the consistency of the data cannot be strictly guaranteed

That is, the current transaction control method cannot guarantee the consistency of data and the performance of concurrent access to data at the same time.

Images