Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data management method and system as well as database system

A data management system and data management technology, applied in data processing applications, electrical digital data processing, special data processing applications, etc., can solve problems such as high management overhead, reduced access throughput, and reduced locking time for concurrent access to data performance. , to ensure consistency, improve performance, and reduce lock time

Inactive Publication Date: 2012-05-02
HUAWEI TECH CO LTD
View PDF3 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data management method and system as well as database system
  • Data management method and system as well as database system
  • Data management method and system as well as database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0041] This embodiment provides a data management method, such as figure 1 As shown, the method includes:

[0042] 101. Send a data request message to the database system, where the data request message includes the user data identifier sent by the client.

[0043] 102. Receive user data and first version information of the user data sent by the database system.

[0044] 103. Send the user data to the client.

[0045] 104. After receiving and saving the modified user data submitted by the client, lock the user data in the database system.

[0046] 105. Compare whether the first version information is the same as the current version information of the user data in the database system.

[0047] 106. If the first version information is the same as the current version information, write the modified user data into the database system.

[0048] Further, if the first version information is different from the current version information, cancel writing the modified user data into...

Embodiment 2

[0061] This embodiment provides a data management method, such as figure 2 As shown, the method includes:

[0062] 201. Receive a data request message sent by a data management system, where the data request message includes a user data identifier sent by a client.

[0063] 202. Acquire user data corresponding to the user identifier and first version information of the user data.

[0064] 203. Send the user data and first version information of the user data to the data management system.

[0065] 204. After the data management system locks the user data and when the first version information is the same as the current version information of the user data, receive and store the modified data written by the data management system user data.

[0066] Further, it also includes:

[0067] The second version information of the modified user data written by the data management system is received and stored.

[0068] Further, after receiving and storing the modified user data wr...

Embodiment 3

[0072] This embodiment provides a data management method, such as image 3 As shown, the method includes:

[0073] 301. The data management system sends a data request message to the database system, where the data request message includes the user data identifier sent by the client.

[0074] 302. The database system acquires user data corresponding to the user identifier and first version information of the user data.

[0075] 303. The database system sends the user data and the first version information of the user data to the data management system.

[0076] 304. The data management system saves the first version information of the user data.

[0077] 305. The data management system sends the user data to the client.

[0078] 306. The data management system receives and saves the modified user data submitted by the client.

[0079] 307. The data management system locks the user data in the database system.

[0080] 308. The data management system acquires the current v...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06Q50/24G06F17/30G16H10/60
Inventor 许金川温长城李华荣
Owner HUAWEI TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products