A data retrieval method and server

A data retrieval and server technology, applied in the field of data retrieval, can solve the problems of slowing down the overall running speed of the system, high CPU and IO resource overhead, and huge amount of tasks, so as to achieve the effect of improving efficiency and reducing the number of IOs.

Active Publication Date: 2021-03-23
中国移动通信集团内蒙古有限公司 +1
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The data tables in the database are composed of many query statements. In order to ensure the optimization of each query statement, the existing technology generally adopts to build an index for each query statement, and the system executes each query statement according to the constructed index, so as to realize Retrieval of data, but when there are a lot of query statement data in the database, the system executes a huge amount of tasks, resulting in a large overhead of CPU and IO resources of the system, resulting in a decrease in the overall operating speed of the 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
  • A data retrieval method and server
  • A data retrieval method and server
  • A data retrieval method and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. 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.

[0022] figure 1 It is a schematic flow chart of the data retrieval method of the embodiment of the present invention, such as figure 1 As shown, a data retrieval method provided by an embodiment of the present invention includes the following steps:

[0023] S1: Obtain the core data table in the data table of the database.

[0024] Specifically...

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 provides a data retrieval method and a server. The method comprises the steps: obtaining a core data table in data tables in a database; parsing a query sentence of thecore data table; obtaining a grouping reference column according to a first preset rule and the parsing result; and according to a second preset rule and the grouping reference column, obtaining an index constructed based on the core data table, and performing data retrieval according to the index. The server performs the method described above. The data retrieval method and the server provided by the embodiment of the invention can greatly reduce the IO quantity of the database and the storage space, thereby remarkably improving the efficiency of the overall operation of the system.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of data retrieval, and in particular to a data retrieval method and server. Background technique [0002] Relational databases, the current mainstream products include ORACLE, SQLSERVER, DB2, INFORMIX, MYSQL, etc., are used in almost all large-scale software systems and projects, and are at the core of these large-scale systems and projects. Indexing is one of the most important technologies in relational databases, and it guarantees the efficiency and speed of relational databases. [0003] The data tables in the database are composed of many query statements. In order to ensure the optimization of each query statement, the existing technology generally adopts to build an index for each query statement, and the system executes each query statement according to the constructed index, so as to realize Retrieval of data, but when there are a lot of query statements in the database, t...

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 Patents(China)
IPC IPC(8): G06F16/2453G06F16/28
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