Synchronized method for not only structured query language (NOSQL) and relational database management system (RDBMS) database and system thereof

A technology for synchronizing systems and databases, applied in the database field, can solve the problems that RDBMS databases cannot achieve high concurrent read and write massive data, efficient storage, poor scalability and availability of RDBMS databases, and achieve data integrity assurance and high performance.

Inactive Publication Date: 2013-03-20
融创天下(上海)科技发展有限公司
View PDF4 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The purpose of the embodiments of the present invention is to propose a database synchronization method between NOSQL and RDBMS, which aims to solve the technical problem that RDBMS databases cannot achieve high concurrent reading and writing and efficient storage of massive data in the prior art, and is also used to solve RDBMS database scalability. and technical issues with poor usability

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
  • Synchronized method for not only structured query language (NOSQL) and relational database management system (RDBMS) database and system thereof
  • Synchronized method for not only structured query language (NOSQL) and relational database management system (RDBMS) database and system thereof
  • Synchronized method for not only structured query language (NOSQL) and relational database management system (RDBMS) database and system thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0033] figure 1 It is a flow chart of the first preferred embodiment of the method for synchronizing the NOSQL database and the RDBMS database of the present invention.

[0034] S101, obtaining a request for invoking a data operation method;

[0035] The data operation method includes a modification method and a deletion method, and may also include a new addition method, etc.;

[0036] S102. Convert the first entity instance object required to be saved by the data operation method into a second entity instance object according to the request, and store the second entity instance object in a NOSQL database;

[0037] The first entity instance object is an entity instance object in java format;

[0038] The second entity instance object is an entity instance object in JSON (JavaScript Object Notation, a lightweight data exchange format) format;

[0039] You can use Google's JSON open source component Gson for format conversion;

[0040] S103, acquiring the changed second ent...

Embodiment 2

[0047] figure 2 It is a flow chart of the second preferred embodiment of the method for synchronizing the NOSQL database and the RDBMS database of the present invention.

[0048] S201, obtaining a request for invoking a data operation method;

[0049] S202, judging whether the data operation method to be invoked by the request has public authority and is preset with an intercept annotation flag, if so, proceed to step S203; otherwise, proceed to step S208;

[0050] The public authority refers to public authority;

[0051] The interception annotation identification is the identification information that is preset in the data operation method that needs to be intercepted;

[0052] This step can be used to preset the data operation method that needs to be intercepted and the processing logic after interception through the Spring AOP processing method, and the unintercepted data operation method is used to process the request according to the known process of the prior art;

[0...

Embodiment 3

[0061] image 3 It is a flow chart of the third preferred embodiment of the method for synchronizing the NOSQL database and the RDBMS database of the present invention.

[0062] S301, obtaining a request for invoking a data operation method;

[0063] S302, judging whether the data operation method to be invoked by the request has public authority and is preset with an intercept annotation flag, if so, proceed to step S303; otherwise, proceed to step S313;

[0064] S303. Obtain the first entity instance object that needs to be saved by the data operation method;

[0065] S304. Obtain the hash value of the first entity instance object;

[0066] S305, storing the corresponding relationship between the hash value and the data operation method;

[0067] The corresponding relationship can be stored in the method registry;

[0068] The method registry is in the form of key (keyword) and value (value corresponding to the keyword), that is, saving or reading the corresponding relat...

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 invention discloses a synchronized method for not only structured query language (NOSQL) and a relational database management system (RDBMS) database and a system with the synchronized method. The synchronized method for not only structured query language (NOSQL) and a relational database management system (RDBMS) database and the system through changing a java form entity instance object which needs to be stored by a data operation method into a JavaScript Object Notation (JSON) form entity instance object changes the JSON from entity instance object is stored into a NOSQL database. When an update record of the NOSQL database is detected in the NOSQL database, the JSON form entity instance object is changed into the JAVA form entity instance object, and the JAVA form entity instance object is stored into the RDBMS database through the corresponding data operating method of the JAVA entity instance object. The synchronized method for not only structured query language (NOSQL) and a relational database management system (RDBMS) database and the system provides a favorable transition for an existing system from a RDBMS storage mode to a NOSQL saving mode, and enables the existing system to experience the good performance brought by NOSQL through only simply modifying a data storage layer. Service codes do not need to be modified, RDBMS storage support is remained, and therefore a good security of the integrity of data is achieved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a database synchronization method and system for NOSQL and RDBMS. Background technique [0002] A typical application architecture is to receive the user request processing layer through the Action layer, such as the user clicking the "Save" button on the interactive interface. Inserting user data through the Service layer (business operation / transaction processing layer) involves multiple data atomic operations. It also passes through the Dao layer (data atomic operation processing layer) such as inserting a piece of data. Its operational performance and processing time depend on the RDBMS database. [0003] With the rise of web2.0 websites on the Internet, traditional RDBMS databases (relational database management system, relational databases) have been unable to cope with web2.0 websites, especially ultra-large-scale and high-concurrency purely dynamic web2.0 websites. Many insurm...

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 融创天下(上海)科技发展有限公司
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