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

A way to support unified sql query for nested documents

A document and nesting technology, applied in the field of adaptive storage and unified query, can solve the problems of difficult database system, complex structure of distributed database, integration, etc., and achieve the effect of improving usability

Active Publication Date: 2019-07-23
DONGHUA UNIV
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The structure of the traditional distributed database is complicated, the distributed management is integrated in the database itself, it is difficult to integrate the existing database system, and the distributed database middleware provides a good way to solve the above problems with its flexibility and scalability

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 way to support unified sql query for nested documents
  • A way to support unified sql query for nested documents

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] In order to make the present invention more comprehensible, preferred embodiments are described in detail as follows.

[0041]The invention provides a method for supporting uniform SQL query for nested documents, and the invention can address the situation that the nested documents cannot be correctly SQL-queried when multiple databases coexist under distributed middleware. By rewriting the original SQL parsing and SQL push modules of the middleware, and adding the SQL interception module, the purpose of using SQL to perform unified query on nested documents is achieved, which improves the flexibility of the distributed database middleware and provides common users with It provides a good platform for manipulating non-relational data in a relational manner. The specific operation steps are:

[0042] Step 1. Build the database environment (only MongoDB is considered here) and the distributed middleware Mycat environment, and add the underlying database nodes to the midd...

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 provides a method for supporting uniform SQL (Structured Query Language) query of an embedded document. The method is characterized in that an upper-layer interface continues to use an SQL query language which is familiar to a user, and query of a non-structured embedded document is realized functionally. By adopting the method, unified SQL operation can be performed on relational data and an embedded document in NoSQL database MongDB through distributed database middleware specific to the characteristics of big-data multi-source heterogeneity, data in a bottom-layer database are acquired, and operation is correct; meanwhile, no matter data in the bottom-layer database exist in which form, the data can be operated in a relational way at a front end, and a result can be presented to a user in a relational form, so that the usability of the middleware is enhanced.

Description

technical field [0001] The invention relates to a method for realizing adaptive storage and unified query of nested documents through distributed middleware. Background technique [0002] With the advent of the era of big data, along with the rapid growth of data scale, data management has become a trend towards distributed development. Traditional distributed databases are complex in structure, and distributed management is integrated in the database itself, making it difficult to integrate existing database systems. Distributed database middleware provides a good way to solve the above problems with its flexibility and scalability. The distributed database middleware builds a bridge between the application and the underlying database. The query generated by the upper-layer application is parsed into an independent query plan by the database middleware and sent to each data node. Each data node returns the query result, and then the database The middleware integrates the r...

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): G06F16/25G06F16/28G06F16/2452
CPCG06F16/24522G06F16/258G06F16/284
Inventor 薛皓黄晓虎王杰王梅
Owner DONGHUA UNIV
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