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

Database query method and device

A query method and database technology, applied in the field of database query, can solve the problems of frequent addition, deletion and modification

Inactive Publication Date: 2016-11-23
ZTE CORP
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If a full-text index is established on this field, although the query efficiency can be improved, if the field is added, deleted, and modified, it will be more frequent

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
  • Database query method and device
  • Database query method and device
  • Database query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention.

[0037] The basic idea of ​​the embodiment of the present invention is: split according to the structural rules satisfied by the data to be processed, and save the split sub-data and the corresponding primary key, the primary key is used to represent the sub-data in the data to be processed position; so that when the database query is performed on the data to be queried, the sub-data after splitting can be queried, and the position of the data to be queried in the data to be processed can be obtained according to the primary key corresponding to the sub-data obtained from the query. It not only improves query performance, but also has high stability, and can ensure real-time synchronization of indexes and data.

[0038] Based on the above basic idea, see figure 1 , which shows...

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 database query method and device. The database query method can comprise the steps that a database splits data to be processed according to the structural rule to which the data to be processed confirms to obtain subdata and positions of the subdata in the data to be processed; the database receives data to be queried; the database obtains the positions of the data to be queried in the data to be processed from the subdata and the positions of the subdata in the data to be processed.

Description

technical field [0001] The invention relates to a database query technology, in particular to a database query method and device. Background technique [0002] Databases have been used in many fields, and the performance of database queries is directly related to the response speed and user experience. At present, when designing a database, in order to maintain the integrity of the data, the content is usually organized and stored in a field according to the business, resulting in a large amount of data in the field, resulting in low efficiency for querying the field. Expenses are high. [0003] Currently, a full-text index is usually used to improve the query performance of the database. However, the full-text index will take up a lot of space, and the support for the full-text index by different database engines is not ideal, and real-time synchronization of the index and data cannot be guaranteed. For example, there is a large data field in a table that stores an artic...

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/00G06F16/24535
Inventor 尹久元
Owner ZTE CORP
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