Unlock instant, AI-driven research and patent intelligence for your innovation.

A method and apparatus for querying a data table

A data table and data technology, applied in the field of query data table, can solve the problems of not reducing the occupation of system resources and excessive occupation of system resources, so as to reduce the occupation of system resources and overcome the effect of excessive occupation of system resources

Inactive Publication Date: 2019-02-26
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF6 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the process of realizing the present invention, the inventor found that there are at least the following problems in the prior art: although the prior art puts the small data table into the memory, it still needs to combine the records in the large data table with the small data table when querying. The records are compared one by one, so the system resource occupation of the query process is not substantially reduced, and there is still the problem of excessive system resource occupation

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 method and apparatus for querying a data table
  • A method and apparatus for querying a data table
  • A method and apparatus for querying a data table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0052] figure 1 is a schematic diagram of main steps of a method for querying a data table according to an embodiment of the present invention.

[0053] Such as figure 1 As shown, a method for querying a data table provided according to an embodiment of the present invention includes:

[0054] S10, saving the data of the data table as relational items based on key-value...

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 method and a device for querying a data table, which relates to the computer technical field. One embodiment of the method includes: storing data of a data table as relational terms based on key-value pairs; According to the acquired keyword, querying data corresponding to the keyword in the relation item. This embodiment can reduce the amount of system resources consumedwhen querying a data table.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a method and device for querying data tables. Background technique [0002] In the database, there are usually more than one data tables. These data tables are not independent of each other. Relationships need to be established between different data tables, and the data tables are associated according to the relationship, so that the corresponding data can be queried according to specific business needs. . In the database, there are often scenarios where data tables are associated, and the data in the data tables needs to be queried. Developers need to perform special processing on such scenarios to achieve performance optimization. [0003] In the prior art, the speed of querying data tables is usually optimized by putting small data tables into memory first and then associating them. [0004] In the process of realizing the present invention, the inventor found that there ...

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): G06F16/2453G06F9/50G06F16/242
CPCG06F9/5005
Inventor 陈飞
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD