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

Storage medium-oriented query method and device, medium, equipment and system

A storage medium and query method technology, which is applied in the fields of storage medium-oriented query methods, media, devices, equipment and systems, and can solve problems such as inconvenience in data query work.

Pending Publication Date: 2022-01-07
ZHEJIANG UNIVIEW TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Some of the storage media may support the SQL query language, and some may not support it, which brings great inconvenience to the data query work inside the data system

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
  • Storage medium-oriented query method and device, medium, equipment and system
  • Storage medium-oriented query method and device, medium, equipment and system
  • Storage medium-oriented query method and device, medium, equipment and system

Examples

Experimental program
Comparison scheme
Effect test

specific example

[0062] The SQL statement issued by the user is as follows:

[0063]

[0064]

[0065] Then the processing flow of this program is:

[0066] The SQL statement first enters the SQL processing layer, and after the SQL optimization module optimizes the SQL, the optimized SQL is:

[0067]

[0068] The optimized SQL is parsed into a JSON string by the data exchange module, as follows:

[0069]

[0070]

[0071]

[0072]

[0073] Through the above two steps 1) and 2), the process of simplifying the processing of SQL query statements and converting them into JSON strings can be realized. Among them, it is known that there is an index named vehicle in the full-text search engine elasticsearch, and the field information contained in the index is shown in the following table:

[0074] Field Name Description record_id ID of this record vehicle_color vehicle color plate_code License plate number plate_color license plate color ...

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 embodiment of the invention discloses a storage medium-oriented query method and device, a medium, equipment and a system. The method comprises the steps of receiving an SQL query statement, simpliying the SQL query statement, and obtaining an optimized query statement; determining a target storage medium of the optimized query statement according to the optimized query statement; calling a data interface of the target storage medium, identifying the optimized query statement, determining a query target, and packaging the query target into a data query structure supported by the target storage medium; and performing information query of the query target for a target storage medium. By executing the scheme, the effect that any data storage medium in the data system supports the SQL query language can be achieved.

Description

technical field [0001] The embodiments of the present application relate to the technical field of video processing, and in particular to a storage medium-oriented query method, device, medium, equipment, and system. Background technique [0002] With the rapid development of science and technology and the rapid development of big data, the types of data systems are gradually increasing. Due to the different types of databases, the language forms supported by the databases are also different. For developers, due to the widespread popularity of relational databases, most software developers are quite familiar with SQL (Structured Query Language, Structured Query Language). For a big data system, it may include various types of data storage media. Some of the storage media may support the SQL query language, and some may not, which brings great inconvenience to the data query work inside the data system. Therefore, how to unify the query mode of the data system has become a...

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): G06F16/242G06F16/2453
CPCG06F16/2433G06F16/2453
Inventor 王修梓徐陇浙
Owner ZHEJIANG UNIVIEW TECH CO LTD
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