Method and device for performing query in database

A database and equipment technology, applied in the database field, can solve the problems of consuming database resources, occupying database connections, affecting database performance of database operations, etc., to optimize performance, improve efficiency, and avoid time and resource consumption.

Active Publication Date: 2016-04-06
CAINIAO SMART LOGISTICS HLDG LTD
View PDF5 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, when the amount of data in each sub-table is still large, the multi-table joint query will occupy the database connection for a long time, causing other threads to wait, which greatly consumes database resources and seriously affects the execution of database operations and database performance.

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
  • Method and device for performing query in database
  • Method and device for performing query in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The application will be described in further detail below in conjunction with the accompanying drawings.

[0021] In a typical configuration of the present application, the terminal, the device serving the network and the trusted party all include one or more processors (CPUs), input / output interfaces, network interfaces and memory.

[0022] Memory may include non-permanent storage in computer-readable media, in the form of random access memory (RAM) and / or nonvolatile memory, such as read-only memory (ROM) or flash memory (flashRAM). Memory is an example of computer readable media.

[0023] Computer-readable media, including both permanent and non-permanent, removable and non-removable media, can be implemented by any method or technology for storage of information. Information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), sta...

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 application intends to provide a method and device for performing a query in a database. The method comprises: acquiring query records, in a plurality of sub-tables obtained by dividing a table in a database, of first query information; determining page record location information corresponding to a request page, wherein the page record location information comprises the record location information, in the plurality of sub-tables, of each query record in the request page; according to the page record location information, acquiring corresponding records from the plurality of sub-tables to generate the request page; and according to a mapping relationship between the first query information and the page record location information, updating a corresponding cache. Compared with the prior art, according to the method and device, the page record location information corresponding to the request page is acquired, and a corresponding database record in each corresponding table is read quickly, thereby avoiding resource consumption caused by joint query of the data of each table; and moreover, the query information and the corresponding page record location information are cached, thereby further improving database operation efficiency.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a technology for querying in databases. Background technique [0002] When operating on the database, if the amount of data in one table of the database is too large, the execution rate will be reduced. If a table is divided into several sub-tables, the pressure on the database will be shared and reduced. [0003] At present, the scheme adopted in this field is: use database technology to jointly query the several sub-tables: first obtain the sum of the number of records in multiple sub-tables that meet the query conditions through joint query; The data record of the query condition. However, when the amount of data in each sub-table is still large, the multi-table joint query will occupy the database connection for a long time, causing other threads to wait, which greatly consumes database resources and seriously affects the execution of database operations and data...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 李晶
Owner CAINIAO SMART LOGISTICS HLDG LTD
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