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

CN106156197AInactive Publication Date: 2016-11-23ZTE CORP
4 Cites 4 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
Publication Date
2016-11-23
Estimated Expiration
Not applicable · inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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...

Examples

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...