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

Data query method and apparatus

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

Active Publication Date: 2018-07-03
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF4 Cites 1 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 apparatus
  • Data query method and apparatus
  • Data query method and apparatus

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 apparatus. The data query method comprises: operation data from a plurality of databases are received continuously, wherein the operation databases include a plurality of data elements of a plurality of data objects; the operation data are stored temporarily and processed, so that all operation data have unique codes; when all data elements of one data object are obtained, one data record related to the data object is added into one of multiple wide tables; and the multiple wide tables are stored for displaying and query. With the data query method provided by the disclosure, a problem of a speed bottleneck problem of the multi-table association query can be solved, so that the query speed is increased.

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 Applications(China)
IPC IPC(8): G06Q10/08G06Q50/28G06F17/30
CPCG06F16/2282G06F16/2365G06F16/2453G06Q10/083G06Q10/087G06Q10/08
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com