Unlock instant, AI-driven research and patent intelligence for your innovation.

An Integrated Query Method for Multi-structure Database

A query method and database technology, applied in structured data retrieval, database models, relational databases, etc., can solve the problems of waste of SQL storage space and low query efficiency, and achieve the effects of improving efficiency and reducing development costs

Active Publication Date: 2018-01-05
SOUTHEAST UNIV
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0019] For the query of NoSQL database, in order to overcome the problems of waste of SQL storage space and low query efficiency caused by NoSQL data conversion redundancy and low efficiency of query mode conversion algorithm in the existing architecture scheme, the present invention provides a multi-structure database integrated query method , the present invention adopts the query language pre-analysis scheme and the query mode conversion adopts the algorithm of pre-filtering and then internal connection, reduces the amount of data returned by NoSQL conversion and the number of table connection operations, improves the efficiency of algorithm execution, thereby reducing the utilization rate of SQL storage space and improve query efficiency

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
  • An Integrated Query Method for Multi-structure Database
  • An Integrated Query Method for Multi-structure Database
  • An Integrated Query Method for Multi-structure Database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] The present invention will be further described below in conjunction with the accompanying drawings.

[0057] For the conversion of NoSQL query mode, the unified query model based on compound query language SQL and NoSQL database adopts the algorithm of first cross-joining and then filtering data sets, and performs cross-joining operations on all triple data tables; this algorithm will return a large number of redundant records, and the connection operation between a large number of data tables will lead to a decrease in the efficiency of the entire query. In order to improve the efficiency of the query conversion algorithm, the present invention proposes a NoSQL query mode conversion method for pre-screening inner connections. Pre-screening includes: ①according to the data table dictionary, identify whether the query belongs to SQL type or NoSQL type, and process it by type; ②extract the pre-query condition of NoSQL data from the query statement of the user query, that...

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 an integrated query method for a multi-structure database. The integrated query method is characterized in that a query language pre-analysis program and query mode conversion which adopts pre-screening firstly and then in-connection are adopted, therefore, the volume of data returned by NoSQL conversion and the frequency of table join operation are reduced, and the algorithm execution efficiency is improved, and further the use rate of an SQL (Structured Query Language) storage space is reduced, and the query efficiency is improved.

Description

technical field [0001] The invention relates to a multi-structure database integrated query method. Background technique [0002] The read / write performance and horizontal scalability of traditional relational databases face severe challenges in the context of big data, while NoSQL databases make up for the unsatisfied characteristics of relational databases with flexible data models and good horizontal scalability. Today, the integrated storage of SQL and NoSQL has become a new research direction of database architecture. Then, how to transparently access heterogeneous data sources for upper-layer applications has become an urgent problem to be solved. [0003] At present, most existing technologies can only access specific NoSQL databases. For example, various APIs of Hbase can only enable applications to access Hbase databases, and do not take into account the transparent access to heterogeneous data sources when SQL and NoSQL are integrated for storage. question. Howe...

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
CPCG06F16/24534G06F16/284
Inventor 徐平平董海玲董龑
Owner SOUTHEAST UNIV