Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data query method and device

A data query device and data query technology, applied in the database field, can solve the problems of query timeout, query speed bottleneck, inability to realize multi-table and multi-database combined query, etc., and achieve the effect of overcoming the query speed bottleneck.

Active Publication Date: 2021-02-26
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, with the substantial increase in business volume, the method of multi-table association query through multiple databases will cause query timeout due to the large amount of data to be queried, and encounter bottlenecks in query speed
In addition, considering the stability of the system, logistics companies usually split each business system, and the relevant logistics information data will also be stored in different databases or other storage media. The existing data query methods are here When the degree of data aggregation is not high, complex multi-table and multi-database combined queries cannot be realized

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided in order to give a thorough understanding of embodiments of the present disclosure. However, those skilled in the art will appreciate that the technical solutions of the present disclosure may be practiced without one or more of the specific details being omitted, or other methods, components, devices, steps, etc. may be adopted. In other instances, well-known technical solution...

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 disclosure provides a data query method and device. The data query method includes: continuously receiving operation data from multiple databases, the operation data including multiple data elements of multiple data objects; temporarily storing and processing the operation data, so that each operation data in the operation data The value has a unique code; when all the data elements of a data object are acquired, a data record about the data object is added to one of the multiple wide tables; the multiple wide tables are stored for display and query. The data query method provided by the disclosure can solve the speed bottleneck problem of multi-table associated query and improve the query speed.

Description

technical field [0001] The present disclosure relates to the technical field of databases, in particular, to a data query method and device. Background technique [0002] The logistics industry generates a large amount of logistics information every day. Therefore, effective management and query of these logistics information has become a necessary and urgent task. [0003] In the prior art, the method of querying logistics information usually includes establishing a monitoring report composed of complex SQL statements. However, this method cannot realize multi-node real-time monitoring of logistics information data. In other ways of querying logistics information, it also includes developing data reports based on multiple database multi-table associated query + WEB page display. However, with the substantial increase in business volume, the method of multi-table association query through multiple databases will cause query timeout due to the large amount of data to be quer...

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): G06Q10/08G06F16/2453G06F16/22G06F16/23
CPCG06Q10/083G06Q10/087G06Q50/28G06F16/2282G06F16/2365G06F16/2453
Inventor 武磊磊
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products