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

An integrated data query method and system for non-relational and relational databases

A data query, non-relational technology, applied in the field of electronic information, can solve problems such as inconsistent data access interfaces, heterogeneous tables cannot be connected and queried, and achieve the effect of improving performance

Active Publication Date: 2019-07-19
SHANGHAI MUNICIPAL ELECTRIC POWER CO +1
View PDF2 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] One of the objectives of the present invention is to provide an integrated data query method and system for non-relational and relational databases, so as to solve the problem of inconsistent data access interfaces between non-relational and relational databases and inability to access heterogeneous tables in existing hybrid database scenarios. Problems making connection queries

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 data query method and system for non-relational and relational databases
  • An integrated data query method and system for non-relational and relational databases
  • An integrated data query method and system for non-relational and relational databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0069] A non-relational and relational database integrated data query method includes the following steps:

[0070] Step (1): The application program inputs the SQL query statement to the query statement parsing module 2 and the data table management module 7 through the unified query interface 1 .

[0071] Step (2): After receiving the SQL query statement, the data table management module 7 sends the data table storage information in the underlying storage module 5 to the query statement analysis module 2 .

[0072] Step (3): The query statement parsing module 2 analyzes the received SQL query statement according to the information stored in the data table in the underlying storage module 5, obtains the SQL query statement fragment, and sends the SQL query statement fragment to the query statement execution module 3 .

[0073] The query statement parsing module 2 can analyze which specific data tables are processed by each SQL query statement fragment and which database thes...

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 non-relation type database and relation type database integrated data query method and system. The method comprises steps as follows: S1: a query sentence is input into a query sentence analysis module through a uniform query interface; S2: the query sentence analysis module analyzes the query sentence and then sends the query sentence to a query sentence execution module; S3: the query sentence execution module sends the query sentence to an in-memory database for data query, and if query data exist, the step S5 is performed; if query data don't exist, the next step is performed; S4: a query result obtained in a bottom-layer storage module is processed by a model transformation and data migration module and sent to the in-memory database to be saved, and the step S3 is performed again; S5: the query sentence execution module sends the query result to an application program through a uniform query interface. The bottom-layer complicated environment can be shielded for an upper-layer application program, and a uniform data access interface is obtained.

Description

technical field [0001] The invention belongs to the technical field of electronic information, and in particular relates to an integrated data query method and system of non-relational and relational databases. Background technique [0002] Due to the advent of the big data era, traditional relational databases have performance bottlenecks in many application scenarios, so non-relational databases have attracted more and more attention. In this case, many enterprises began to choose to use non-relational databases, but relational databases are still irreplaceable due to their powerful relationship and semantic expression capabilities, so enterprises are faced with the scene of hybrid databases. In terms of data access, relational and non-relational databases provide different data access interfaces, which is very inconvenient for technical personnel. Although there are already some SQL statement translation software on the market that support users to access non-relational ...

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/25
CPCG06F16/25G06F16/256
Inventor 夏仕俊谷众源李天宇钱晓真顾荣斌葛胜斌冯秀庆
Owner SHANGHAI MUNICIPAL ELECTRIC POWER CO
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