Data query method and device in data warehouse

A data warehouse and data table technology, applied in the field of data query methods and devices in data warehouses, can solve the problem of high threshold for data use in data warehouses, achieve the effects of quick query and use, lower use thresholds, and lower query difficulty

Active Publication Date: 2018-11-02
ADVANCED NEW TECH CO LTD
View PDF5 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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
  • Data query method and device in data warehouse
  • Data query method and device in data warehouse
  • Data query method and device in data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0061] This application aims to propose an entity-based modeling method to model the data warehouse, abstract the business data tables maintained in the data warehouse into several business entities, and combine these business entities and the business data related to these business entities The mapping relationship between the physical storage information of tables, as business metadata, is centrally maintained in the metadata model of the data warehouse, thereby reducing the threshold for using data in the data warehouse and shielding the diversity of the underlying storage of the data warehouse A technical solution that minimizes the impact on data query.

[0062] During implementation, the pre-configured business entities can be output to the user through the visual interface; when the user needs to query and use the data stored in the data warehouse, the target business entity selected by the user in the above-mentioned visual interface can be obtained and used in the abov...

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 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 ...

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
Inventor 吴勇军
Owner ADVANCED NEW 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