Data query method and device in data warehouse

Abstract

The application provides a data query method in a data warehouse. The data warehouse is equipped with a metadata model; the metadata model includes service metadata; a service data table in the data warehouse is configured as a plurality of service entities; and the service metadata includes the plurality of service entities and a mapping relationship between physical storage information of the related service data table and the plurality of service entities. The method includes: outputting the plurality of pre-configured service entities to a user through a visualization interface; obtaininga target service entity selected by the user in the visualization interface, and querying, in the service metadata, physical storage information that has a mapping relationship with the target serviceentity; constructing a query instruction based on the queried physical storage information; and executing the query instruction to query the corresponding service data table from the data warehouse,and outputting a query result to the user through the visualization interface. This application can reduce the threshold for data usage in the data warehouse.

Description

technical field [0001] This application relates to the field of computer applications, in particular to a data query method and device in a data warehouse. Background technique [0002] Traditional data warehouses are usually modeled based on mature modeling methods such as paradigm modeling or dimensional modeling. The data in the data warehouse are all stored in the server or database in the form of two-dimensional data tables. When users need to use the data in the data warehouse, they can query the relevant two-dimensional data tables from the data warehouse by manually editing relevant SQL query statements. [0003] However, data is stored in the form of two-dimensional data tables, so that when users query data from the data warehouse, they must not only master the SQL language, but also be very familiar with the physical storage information related to each two-dimensional data table in the data warehouse ( Such as table structure, etc.), so the data usage threshold ...

AI Technical Summary

Problems solved by technology

[0003] However, data is stored in the form of two-dimensional data tables, so that when users query data from the data warehouse, they must not only master the SQL language, but also be very familiar with the physical storage information related to each two-dimensional data table in the data warehouse ( Such as table structure, etc.), so the data usage threshold in the data warehouse will be very high

Images