Data indexing method and device

A data indexing and indexing technology, which is applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of reduced query efficiency and long time for querying data, and achieve the effect of improving query speed and query efficiency

Inactive Publication Date: 2017-05-31
李天 +1
View PDF4 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a data indexing method and device, aiming to solve the problem that the query method

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 indexing method and device
  • Data indexing method and device
  • Data indexing method and device

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0013] In order to make the purpose, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. The embodiments described above are only a part of the embodiments of the present invention, but not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative efforts shall fall within the protection scope of the present invention.

[0014] see figure 1 , figure 1 The first embodiment of the present invention provides a schematic diagram of the implementation flow of the data indexing method, which can be applied to a terminal with a data processing function, such as a computer, figure 1 The data indexing method shown mainly includes the following steps:

[0015] S1...

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 data indexing method and device. The method comprises the following steps: judging whether a repeatedly stored index field exists in a database or not, judging whether the number of storage repetitions of the repeatedly stored index field is more than a preset numerical value or not, if YES, determining the index field in a preset storage time granularity and the preset storage time granularity as index information from a preset starting time, and caching the index information and a primary key value of a row corresponding to the index information in a memory; after completing caching, generating a batch index record for the index information and the primary key value of the row corresponding to the index information according to a preset data storage format, and writing the batch index record into the database for finding target data through the batch index record during query. In such a manner, for an index field with a large number of storage repetitions, mass data can be queried at one time by virtue of a generated batch index record, so that the query speed is increased, and the query efficiency is further improved.

Description

technical field [0001] The invention belongs to the field of data storage, in particular to a data indexing method and device. Background technique [0002] With the development of society, the amount of data in various industries and fields will continue to grow, especially in the telecommunications and Internet industries. When conditions such as server hardware and database configuration are fixed, the increase in the amount of stored data will lead to excessive resource occupation, which will affect the efficiency of data query. Using the traditional query method, the query efficiency will continue to decrease as the amount of data continues to increase. The response time of user queries will become slower and slower, and even the database may become unusable due to too many query visits. [0003] In the prior art, a Hadoop database (HBase, Hadoop Database) is generally used to store data. HBase is a distributed, column-oriented open source database. The existing que...

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 李天
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap