OLTP-based data deletion method, system and graphic database sever

A server and data technology, applied in the field of data processing, which can solve problems such as asynchronous and data rewriting

Active Publication Date: 2011-06-22
BEIJING 21VIANET DATA CENT
View PDF4 Cites 18 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
  • OLTP-based data deletion method, system and graphic database sever
  • OLTP-based data deletion method, system and graphic database sever
  • OLTP-based data deletion method, system and graphic database sever

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 invention discloses an on-line transaction processing (OLTP)-based data deletion method, an OLTP-based data deletion system and a graphic database sever. The method comprises the following steps of: receiving a data deletion command transmitted by calling an application programming interface (API) through a client, wherein the data deletion command contains transaction identification, node name and filter condition; searching transaction record according to the transaction identification, and adding the node name into the searched valid transaction record; searching a node attribute state information table according to the node name, and acquiring data records in accordance with the filter condition from the node attribute state information table; and deleting the data records in accordance with the filter condition item by item. By using the embodiment of the invention, deletion of the data records of one transaction on multiple nodes can be realized, and synchronism and integrity of data deletion can be ensured; and when the transaction is invalid, data recovery can be performed by rollback operation, and the integrity of the database is ensured.

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 Applications(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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap