Methods for generating cube metadata and query statements on basis of enhanced star schema

A star schema and cube technology, applied in the field of data processing, can solve problems such as increasing query processing time

Active Publication Date: 2014-05-14
IBM CORP
View PDF2 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the conversion of non-factual fact tables using these methods causes some problems, such as the need to introduce more manual work in the conversion, and rely

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
  • Methods for generating cube metadata and query statements on basis of enhanced star schema
  • Methods for generating cube metadata and query statements on basis of enhanced star schema
  • Methods for generating cube metadata and query statements on basis of enhanced star schema

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] Preferred embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although preferred embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0030] Those skilled in the art know that the present invention can be implemented as a system, method or computer program product. Therefore, the present disclosure can be specifically implemented in the following forms, namely: it can be complete hardware, it can also be complete software (including firmware, resident software, microcode, etc.), and it can also be a combination of hardware and software. Called a "circuit", "module" or "sy...

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 methods and devices for generating cube metadata and query statements on the basis of an enhanced star schema. The method for generating the cube metadata on the basis of the enhanced star schema includes extracting dimensional reference from non-factual fact tables of the enhanced star schema comprising fact tables, a plurality of dimension tables of the fact tables and the non-factual fact tables; constructing hierarchical structure reference according to the dimension reference; combining the hierarchical structure reference with measure and hierarchical structures to generate the cube metadata. The measure is acquired from the fact tables and the dimension tables. The methods and the devices have the advantage that the non-factual fact tables are directly used with the fact tables and the dimension tables without being converted when the metadata are generated, and accordingly manual operation, storage spaces, dependency on knowledge of IT (information technology)/business modeling personnel and the like which are required when non-factual fact tables are converted in the prior art can be omitted.

Description

technical field [0001] The invention relates to the field of data processing, and in particular to a method and a device for generating cube metadata and query statements based on an enhanced star schema. Background technique [0002] In the field of data processing, online analytical processing (OLAP) is a solution for rapidly answering multi-dimensional analytical (MDA) queries. OLAP is a broad classification of business intelligence, which also includes relational reporting and data collection. Databases configured for OLAP use a multidimensional data model that allows complex analyzes and ad-hoc queries with fast execution speeds. [0003] At the heart of any OLAP system is the OLAP cube metadata model. Such as Figure 13 As shown, the OLAP cube metadata model is generally created according to the star schema or snowflake schema of the tables in the relational database, wherein the measures are extracted from the records in the fact table, and the dimensions are extrac...

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
IPC IPC(8): G06F17/30
CPCG06F16/283
Inventor 邵兵何苗王芹华任常锐陈峰王伟
Owner IBM CORP
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