Data query method and device

A data query and data technology, applied in the computer field, can solve problems such as single processing method and inflexibility

Inactive Publication Date: 2016-10-05
HUAWEI TECH CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] This application provides a data query method and device to solve the technical problem that the processing method of cross-database association in the prior art is too single and not flexible enough

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

[0054] The embodiment of the present application provides a data query method and device, which are used to solve the technical problem that the processing method of cross-database association in the prior art is too single and not flexible enough.

[0055] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of this application.

[0056] Please refer to figure 2 As shown, it is a system architecture diagram provided by the embodiment of ...

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 provides a data query method and device. The method comprises the following steps: receiving a query request, wherein the query request comprises a query condition, and the query condition relates to N different databases; calculating the query cost of each cross-database associated processing way in M types of cross-database associated processing ways, wherein the query cost of each cross-database associated processing way is the cost for carrying out data query corresponding to the query condition in N different databases through each cross-database associated processing way, and M is an integer greater than or equal to 2; according to the query cost of each cross-database associated processing way, determining the cross-database associated processing way which is used at the current time in the M types of cross-database associated processing ways; and through the cross-database associated processing way which is used at the current time, carrying out the data query corresponding to the query condition in the N different databases.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to a data query method and device. Background technique [0002] The basic idea of ​​Data Sharding is to divide a database into multiple parts and put them on different databases, so as to alleviate the performance problem of a single database. Generally speaking, for a database with massive data, if there are many tables and a lot of data, it is suitable to use vertical segmentation at this time, that is, to divide closely related tables (such as the same module) and put them on one server. If there are not many tables, but each table has a lot of data, it is suitable for horizontal segmentation at this time, that is, the data of the table is divided into multiple databases according to certain rules (such as hashing by ID). Of course, in reality, these two situations are more mixed together. At this time, a choice needs to be made according to the actual situation. It...

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
CPCG06F16/24544G06F16/2456G06F16/2471
Inventor 朱文琦杨宜东张庆姚理朱仲楚
Owner HUAWEI TECH CO 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