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

Data query method and apparatus

A data query and data technology, applied in the database field, can solve problems that affect the performance of database data query, occupy the memory of the query terminal, and slow query speed, etc.

Inactive Publication Date: 2017-11-03
HANGZHOU HIKVISION DIGITAL TECH
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When table A and table X reach a certain scale, the result of this Cartesian product operation will be a huge result set, which will occupy a large amount of memory in the query terminal, thereby affecting the data query performance of the database, and the query speed is slow

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
  • Data query method and apparatus
  • Data query method and apparatus
  • Data query method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0063] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0064] The present invention will be described in detail below through specific examples.

[0065] refer to figure 1 , figure 1 A schematic flowchart of a data query method provided by an embodiment of the present invention, the method includes the following steps:

[0066] S101: Receive a data query request;

[0067] Wherein, the data query request may include query conditions, and understandable query conditions generally include elements such as operators and...

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

Embodiments of the invention disclose a data query method and apparatus. The method comprises the steps of receiving a data query request, wherein the data query request contains a query condition; judging whether the query condition contains a preset operator or not; if yes, converting the query condition into at least two sub-query conditions free of the preset operator according to a preset query condition optimization rule; according to the sub-query conditions, querying data in a preset table; and according to the queried data, generating a data query result. By applying the data query method and apparatus, the data query performance of a database is improved and the data query speed is increased.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data query method and device. Background technique [0002] There are currently many SQL (Structured Query Language, Structured Query Language) optimization methods, such as: predicate pushdown, constant folding, and so on. However, these methods are very general optimization methods, and tend to be conservative optimization methods. Most of them only make minor adjustments in the execution plan to achieve the purpose of optimizing data queries. [0003] However, in practical applications, data query often contains some specific features. For this type of data query, the above optimization method cannot optimize it, and only conservative methods can be used for data query, such as the following SQL statement: [0004] select* [0005] from A,X [0006] where [0007] (A.a='a0' and X.x='x0') [0008] or [0009] (A.a='a1' and X.x='x1') [0010] During the execution proc...

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
CPCG06F16/24534
Inventor 邓长春
Owner HANGZHOU HIKVISION DIGITAL TECH
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