Data query method and device

A data query and data table technology, applied in the field of Internet communication, can solve the problem of low query efficiency, achieve the effect of solving low query efficiency and improving query efficiency

Active Publication Date: 2019-06-07
SHENZHEN TENCENT COMP SYST CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Embodiments of the present invention provide a data query method and device to at least solve the technical problem of low query efficiency in existing data query methods

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 1

[0037] According to an embodiment of the present invention, a data query method is provided, such as figure 1 As shown, the method includes:

[0038] S102: Obtain a query instruction for querying target data records satisfying preset query conditions in the data table;

[0039] S104: According to the preset query condition, determine the one with lower query cost in the row storage file and the column storage file as the query object, wherein, the data records in the data table in the row storage file are stored by row, and in the column storage file The data records in the data table are saved by column or column group;

[0040] S106: Query the target data record in the determined query object, and return the queried target data record.

[0041] It should be clear that one of the technical problems to be solved by the present invention is to provide a method to respond to the query command. Specifically, according to this method, the target that satisfies the preset query c...

Embodiment 2

[0144] According to an embodiment of the present invention, a data query device for implementing the above data query method is also provided, such as Figure 10 As shown, the device may include:

[0145] 1) An acquisition unit 1002, configured to acquire a query instruction for querying a target data record satisfying a preset query condition in a data table;

[0146] 2) Judgment unit 1004, configured to determine the one with the lower query cost from the row storage file and the column storage file according to the preset query conditions as the query object, wherein the data records in the data table in the row storage file are stored by row , the data records in the data table in the column store file are saved by column or column group;

[0147] 3) The query unit 1006 is configured to query the target data record in the determined query object, and return the query target data record.

[0148] It should be clear that one of the technical problems to be solved by the pr...

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 query method and a query device for data. The method comprises the following steps: obtaining the query command recorded by the target data meeting the preset query condition in a data table; judging the query object with lower query cost from the row storage file and the list storage file according to the preset query condition, wherein the data record in the data table in the row storage file is stored in rows while the data record in the data table in the list storage file is stored in lists; querying the target data record from the judged query object, recording and returning the queried target data. The technical problem of lower query efficiency of the existing data query method can be solved by the query method and the query device for the data, and the data query efficiency can be raised.

Description

technical field [0001] The invention relates to the field of Internet communication, in particular to a data query method and device. Background technique [0002] In the field of Internet communication, a data warehouse is a structured data environment of data sources for decision support systems and online analysis applications. The data warehouse research and solving the problem of obtaining information from the database are generated in order to further mine data resources and make decisions when there are already a large number of databases. The distributed data warehouse based on MapReduce plays an important role in ultra-large-scale data analysis. For typical Internet service providers, these analyzes help them quickly understand dynamic user behavior and changing user needs. [0003] Distributed data warehouses involve multiple systems, especially data warehouses deployed on hundreds or even thousands of servers. Any component may fail, and hardware errors are norma...

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): G06F16/245G06F16/22
CPCG06F16/242
Inventor 蔡斌李勇肖磊薛伟刘大鹏言艳花姜磊郭伟昭胡少锋柳金晶张书彬黄丕培王洋徐妙罗川江
Owner SHENZHEN TENCENT COMP SYST 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