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

OLTP(on-line transaction processing)-based data modifying method and system as well as graphic database server

A data modification and server technology, applied in the field of data processing, can solve problems such as data rewriting and out-of-sync

Active Publication Date: 2011-09-21
BEIJING 21VIANET DATA CENT
View PDF3 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present application provides an OLTP-based data modification method, system, and graph database server to solve the problems of data rewriting and out-of-synchronization easily caused by data modification in existing distributed OLTP

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
  • OLTP(on-line transaction processing)-based data modifying method and system as well as graphic database server
  • OLTP(on-line transaction processing)-based data modifying method and system as well as graphic database server
  • OLTP(on-line transaction processing)-based data modifying method and system as well as graphic database server

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0253] see Figure 9 , is the block diagram of the first embodiment of the graph database server of the present application:

[0254] The image database server includes: a receiving unit 910 , a searching unit 920 , an acquiring unit 930 and a modifying unit 940 .

[0255] Wherein, the receiving unit 910 is configured to receive a data modification command transmitted by the client by calling an application programming interface API, the data modification command includes a transaction identifier, a node name, a filter condition, and data to be updated;

[0256] A search unit 920, configured to search for a transaction record according to the transaction identifier, and add the node name to the found valid transaction record;

[0257] An acquisition unit 930, configured to search a node attribute state information table according to the node name, and obtain data records meeting the filter condition from the node attribute state information table;

[0258] The modifying unit...

no. 2 example

[0259] see Figure 10 , which is a block diagram of the second embodiment of the graph database server of the present application:

[0260] The image database server includes: a receiving unit 1001, a generating unit 1002, a setting unit 1003, a searching unit 1004, a first judging unit 1005, a first executing unit 1006, an acquiring unit 1007, a second judging unit 1008, a second executing unit 1009 and Modify unit 1010.

[0261] Wherein, the receiving unit 1001 is configured to receive the transaction creation command transmitted by the client by calling the API;

[0262] A generating unit 1002, configured to generate a new transaction record in the transaction attribute status information table according to the transaction creation command, and assign a unique transaction identifier to the new transaction record;

[0263] A setting unit 1003, configured to set the commit attribute and the rollback attribute of the transaction record as non-executed;

[0264] The receivin...

no. 3 example

[0275] see Figure 11 , which is a block diagram of the third embodiment of the graph database server of the present application:

[0276] The image database server includes: a receiving unit 1110 , a searching unit 1120 , an obtaining unit 1130 , a modifying unit 1140 , a submitting unit 1150 and a rollback unit 1160 .

[0277] Wherein, the receiving unit 1110 is configured to receive a data modification command transmitted by the client by calling an application programming interface API, the data modification command includes a transaction identifier, a node name, a filter condition, and data to be updated;

[0278] A search unit 1120, configured to search for a transaction record according to the transaction identifier, and add the node name to the found valid transaction record;

[0279] The obtaining unit 1130 is configured to search a node attribute state information table according to the node name, and obtain data records meeting the filter condition from the node at...

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 an OLTP((on-line transaction processing)-based data modifying method and system as well as a graphic database server. The method comprises the steps that of: receiving a data modification command transmitted by a client side through calling an API (application programming interface). wherein the data modification command comprises a transaction identifier, a node name, a filtering condition and data to be updated; searching transaction records according to the transaction identifier, and adding the node name to the searched effective transaction record; searching a node attribute status information table according to the node name, and acquiring the data records meeting the filtering condition from the node attribute status information table; and updating the data records one by one by the data to be updated. By applying the data modifying and system as well as the graphic database server disclosed by the embodiment of the invention, the data record modification on multiple nodes related to one transaction can be realized, so as to guarantee the synchronism and the integrity of data modification; and when the transaction fails, data can be recovered through rollback operation so as to guarantee the integrity of a database.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to a data modification method, system and graph database server based on OLTP (On-Line Transaction Processing, online transaction processing system). Background technique [0002] OLTP is a system that collects and processes data associated with transactions in real time, as well as changes between shared databases and other files. When performing online transaction processing, the raw data to be processed can be immediately transmitted to the computing center for processing, and the processing results will be given in a very short time, so as to realize instant processing and instant response to the data. [0003] In an OLTP system based on a distributed environment, the integrity of the database needs to be maintained. In the prior art, due to the operational complexity of OLTP and the demand for fast input / output, most OLTP are implemented on large computer syst...

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
IPC IPC(8): G06F17/30
Inventor 陈升于洪方井卫军蒋建平姚福源刘健
Owner BEIJING 21VIANET DATA CENT
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