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

Method and device for querying data

A data query and data source technology, applied in the field of big data, can solve problems such as inability to provide cross-platform, achieve the effect of lowering the learning threshold and improving the efficiency of data query

Inactive Publication Date: 2018-09-14
NAT COMP NETWORK & INFORMATION SECURITY MANAGEMENT CENT
View PDF7 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical problem to be solved by the present invention is a data query method and device to solve the problem that the existing technology cannot provide cross-platform joint query

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
  • Method and device for querying data
  • Method and device for querying data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0023] This embodiment provides a data query method. Such as figure 1 Shown is a flow chart of the data query method according to the first embodiment of the present invention.

[0024] Step S110, obtaining a query plan.

[0025] The query plan serves as the basis for data query, and data query is performed by executing the query plan.

[0026] In the query plan, include: data source information and query conditions.

[0027] The data source information includes but not limited to: the path of the data source. Further, the data source information is in one-to-one correspondence with the data source. Data source information can be one or more, so that data can be queried from multiple data sources.

[0028] The query conditions include, but are not limited to: keywords, index information, query scope, query operations, and the number of query results. Among them, query operations include but are not limited to: table union (combining multiple data tables into one data tab...

Embodiment 2

[0077] This embodiment provides a data query device. Such as figure 2 Shown is a structural diagram of a data query device according to the second embodiment of the present invention.

[0078] The data query device includes:

[0079] An acquisition module 210, configured to acquire a query plan;

[0080] A determining module 220, configured to determine the data source information contained in the query plan;

[0081] An escape module 230, configured to perform an escape operation on the query plan according to the data source information;

[0082] The query module 240 is configured to query data from the data source corresponding to the data source information and display the query results according to the query plan after the escape.

[0083] Optionally, the obtaining module 210 is further configured to: obtain the query statement described in the structured query language SQL before determining the data source information contained in the query plan; parse out the data...

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 method and a device for querying data. The method includes acquiring query plans; determining data source information in the query plans; executing meaning transferring operation on the query plans according to the data source information; querying the data in data sources according to query plans with transferred meaning and demonstrating query results. The data sourcescorrespond to the data source information. The method and the device have the advantages that the meaning transferring operation is carried out on the query plans, the meaning of the query plans is transferred into language capable of being identified by databases required to be queried, the different databases can be simultaneously queried by the aid of each single query plan by the aid of the operation, cross-platform union query can be implemented, accordingly, the data query efficiency can be enhanced, technical barriers between the different databases can be broken through, and the learning threshold can be lowered for developers.

Description

technical field [0001] The invention relates to the technical field of big data, in particular to a data query method and device. Background technique [0002] With the continuous development of data science, various data storage systems are emerging in the field of big data. Data are stored in different data storage systems according to their types and usage characteristics. [0003] In the field of big data, in order to enable developers to quickly use related systems, SQL (Structured Query Language, Structured Query Language) is usually provided. SQL language is a common technical means to meet the needs of database query, analysis, mining and so on. However, in the big data system, only data warehouses like Hive have the ability to use the SQL language. However, in the big data system, in addition to Hive, there are data storage systems such as ElasticSearch, HBase (HadoopDatabase), which makes it impossible for developers to pass The SQL language will perform queries...

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
IPC IPC(8): G06F17/30
Inventor 惠榛张鸿刘欣然郭东东吕雁飞马秉楠兰钢临
Owner NAT COMP NETWORK & INFORMATION SECURITY MANAGEMENT CENT
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