Data deletion method, system and graph database server based on oltp

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

Active Publication Date: 2016-08-03
BEIJING 21VIANET DATA CENT
View PDF4 Cites 0 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 deletion method, system, and graph database server to solve the problems of data rewriting and out-of-synchronization easily caused by data deletion 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
  • Data deletion method, system and graph database server based on oltp
  • Data deletion method, system and graph database server based on oltp
  • Data deletion method, system and graph database server based on oltp

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

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

[0255] The graph database server includes: a receiving unit 910 , a searching unit 920 , an obtaining unit 930 and a deleting unit 940 .

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

[0257] 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;

[0258] 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;

[0259] A deleting unit 940, configured to delete th...

no. 2 example

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

[0261] The graph 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 Delete cell 1010 .

[0262] The receiving unit 1001 is configured to receive the transaction creation command transmitted by the client by calling the API;

[0263] 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;

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

[0265] The receiving unit 1...

no. 3 example

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

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

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

[0279] 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;

[0280] 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 attribute state information table;

...

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 present application discloses a data deletion method, system, and graph database server based on an online transaction processing system OLTP. The method includes: receiving a data deletion command transmitted by a client by calling an application programming interface API, and the data deletion command Contain transaction identification, node name and filter condition in; Search transaction record according to described transaction identification, and add described node name in the effective transaction record found; Search node attribute state information table according to node name, from described node Obtain the data records that meet the filter conditions from the attribute status information table; delete the data records that meet the filter conditions one by one. Applying the embodiment of this application can realize the deletion of data records on multiple nodes involved in a transaction, ensuring the synchronization and integrity of data deletion; and when the transaction fails, data recovery can be performed through a rollback operation to ensure the integrity of the database. integrity.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to a data deletion 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 systems....

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 陈升于洪方井卫军蒋建平姚福源刘健
Owner BEIJING 21VIANET DATA CENT
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products