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

A fusion method and system of a relational geological database and NoSQL

A fusion method and relational technology, applied in the field of big data management, can solve problems such as no solution, and achieve the effect of convenient management, good support and service, and flexible and free management

Inactive Publication Date: 2018-12-11
CHINA UNIV OF GEOSCIENCES (WUHAN)
View PDF2 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, there is currently no mature solution for how to effectively integrate or integrate these two databases.

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
  • A fusion method and system of a relational geological database and NoSQL
  • A fusion method and system of a relational geological database and NoSQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] In order to have a clearer understanding of the technical features, purposes and effects of the present invention, the specific implementation manners of the present invention will now be described in detail with reference to the accompanying drawings.

[0041] refer to figure 1 , which is a flow chart of the integration method of relational geological database and NoSQL in the present invention, the method includes the following steps of structure acquisition, data storage and data retrieval.

[0042] Among them, the structure acquisition steps include:

[0043] S11. Obtain the designed NoSQL storage structure of the unstructured data;

[0044] S12. Establish an index information connection table structure of internal elements of the unstructured data according to the storage structure to form a relational connection table.

[0045] For example, according to the storage characteristics of geological map primitives in NoSQL, a structured data table (relational type c...

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 relates to a fusion method and system of a relational geological database and an NoSQL, the method comprising a structure obtaining step, a data storing step and a data retrieving step.Firstly, the NoSQL storage structure of the designed unstructured data is obtained, and the relational connection table is designed according to the storage structure. Secondly, the unstructured datais stored in NoSQL according to the storage structure of the designed unstructured data, the index information of the internal elements of the unstructured data is obtained, and the index informationof the internal elements of the unstructured data is stored in a relational join table. SQL is used to retrieve the index information of the corresponding unstructured data from the relational join table, and the element information of the unstructured data or the corresponding unstructured data is obtained according to the index information. According to the invention, the flexible and free management function of NoSQL to the unstructured data is utilized, and the powerful retrieval function of the relational database is also utilized, so that the geological data which contains not only a large amount of structured data but also a large amount of unstructured data is more convenient and efficient in management.

Description

technical field [0001] The invention belongs to the field of big data management, especially database management technology, and more specifically relates to a fusion method and system of a relational geological database and NoSQL. Background technique [0002] A relational database is a database based on a relational model, and is a database composed of multiple two-dimensional row lists with certain relationships. Because the relational model of the two-dimensional table structure is logically easy to understand, has a solid mathematical foundation, and can maintain data consistency; the general SQL language makes the operation and maintenance of relational databases and the realization of various complex queries very convenient ; The SQL of the relational model connects the computer and human cognition well, and is a convenient data interaction language. Therefore, relational databases are currently the mainstream databases for data management, especially for structured ...

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 CHINA UNIV OF GEOSCIENCES (WUHAN)
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com