Data query method and device in data warehouse

Abstract

This application provides a data query method in a data warehouse, the data warehouse is equipped with a metadata model; the metadata model includes business metadata; wherein, the business data tables in the data warehouse are configured as several business entities; the business metadata The data includes the mapping relationship between the several business entities and the physical storage information of the business data tables related to the several business entities; including: outputting the pre-configured several business entities to the user through a visual interface; Select the target business entity in the visual interface, and query the physical storage information that has a mapping relationship with the target business entity in the business metadata; construct a query instruction based on the queried physical storage information; execute the The query instruction queries the corresponding business data table from the data warehouse, and outputs the query result to the user through the visual interface. This application can lower the data usage threshold 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