Database inquiry method and device

The technology of a query method and a query device, which is applied in the field of database query methods and devices, can solve the problems of low efficiency of query data, etc.

Active Publication Date: 2015-03-04
BEIJING GRIDSUM TECH CO LTD
View PDF3 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The main purpose of the present invention is to provide a database query method and device to solve the problem of low efficiency of querying data in the database in the prior art

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
  • Database inquiry method and device
  • Database inquiry method and device
  • Database inquiry method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] First of all, some nouns or terms appearing in the process of describing the embodiments of the present invention are applicable to the following explanations:

[0028] SQL is Structured Query Language, that is, structured query language. SQL is a database query and programming language for accessing data and querying, updating and managing relational database systems.

[0029] Dimension tables are entity tables in the application system, such as advertisements, projects, and advertisers in the advertising delivery system are all dimension tables.

[0030] The indicator table is a table used by the application system to store the detected or calculated indicators. The indicator table generally has foreign keys associated with one or more dimension tables to represent the indicator performance on the dimension. For example, in the advertisement performance table in the advertising delivery system, the indicator The table contains index columns such as click, exposure, an...

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 database inquiry method and a database inquiry device. The database inquiry method comprises the following steps: acquiring a first dimension table, a second dimension table and an index table, which correspond to target data to be inquired, in a database; performing internal connection processing on the first dimension table and the second dimension table with the index table to obtain first data; acquiring a first primary key column of the first dimension table and a second primary key column of the second dimension table; combining first primary keys of the first primary key column with second primary keys of the second primary key column to obtain a third primary key column; performing internal connection processing on the third primary key column with the first dimension table and the second dimension table to obtain second data; combining the first data with the second data to obtain the target data. According to the database inquiry method and the database inquiry device, the problem of low data inquiry efficiency of the database in the prior art is solved, and the effect of improving the target data inquiry efficiency is achieved.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a database query method and device. Background technique [0002] When querying in an SQL database, if x and y represent two dimension tables, and z represents an index table, where the foreign key in the index table z is associated with the primary key of x and the primary key of y, then when querying data, you need to use x, Based on y and z, query the index performance of each row in x based on z on each row of y. In the prior art, x and y need to be cross-joined first, and then left-joined with z, and based on the joined results of x, y and z, dimension grouping and index aggregation are performed to obtain the final target query result. [0003] Among them, SQL is Structured Query Language, that is, structured query language. SQL is a database query and programming language for accessing data, querying, updating and managing relational database systems; dimension tables are e...

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/2264G06F16/2453
Inventor 廖小利
Owner BEIJING GRIDSUM 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