Unlock instant, AI-driven research and patent intelligence for your innovation.
Data query method and device
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
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
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
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
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to View More 
Login to View More