Data query method, system and device and computer readable storage medium

A data query and data table technology, applied in the field of data query, can solve the problems of complex process, error-prone, large task of modifying data table, etc.
CN110413634AActive Publication Date: 2019-11-05BEIJING QIYI CENTURY SCI & TECH CO LTD
6 Cites 13 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
BEIJING QIYI CENTURY SCI & TECH CO LTD
Publication Date
2019-11-05

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The embodiment of the invention provides a data query method, system and device and a computer readable storage medium. The data query method comprises the following steps: receiving a query request,wherein the query request comprises an identifier of a target data source and an identifier of a first dimension; according to the configuration information stored in the server, determining an identifier of a target data table associated with the identifier of the target data source and associated with the identifier of the first dimension, and a second dimension associated with the first dimension, wherein the first dimension does not belong to the dimension in the target data table, and the second dimension belongs to the dimension in the target data table; according to the identifier and the second dimension of the target data table, generating an SQL instruction, obtaining a target query result from the target data table by utilizing the SQL instruction; and sending the target query result to the terminal device. The data table can be conveniently queried on the premise that the first dimension does not belong to the data table, the data table does not need to be modified as in the prior art, the operation process is simplified, and manpower can be saved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present invention relates to the technical field of data query, in particular to a data query method, system, device and computer-readable storage medium. Background technique

[0002] In the data query system currently used in the industry, the dimension of data query must be limited to the dimensions included in the data table. For example, if a data table contains 10 dimensions, users can only query these 10 dimensions.

[0003] If the data query system is to be able to query derived dimensions other than these 10 dimensions (derived dimensions refer to dimensions that do not belong to the data table, but are related to existing dimensions in the data table), manual intervention is required , first add the derived dimension in the data table, that is, the data table must be manually modified to query the data related to the added derived dimension. Therefore, when the number of data tables to be modified is large, the task of modifying the dat...

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