Data warehouse model and application thereof

A data warehouse and model technology, which is applied in the field of data warehouse models, can solve problems such as high performance and complex operation, and achieve the effects of improving efficiency, flexible data association logic, and promoting design and development status migration check functions

Pending Publication Date: 2021-03-30
景超
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The snowflake model is more in line with the database paradigm and reduces data redundancy, but when analyzing data, the operation is more complicated, and there are more tables that need to be joined, so its performance is not necessarily higher than that of the star model

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 warehouse model and application thereof
  • Data warehouse model and application thereof
  • Data warehouse model and application thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The specific implementation manners of the present invention will be further described in detail below in conjunction with the accompanying drawings.

[0028] Slowly changing dimensions have three types of gradual changes. In many cases, in order to preserve historical versions, the TYPE2 form of slowly changing dimensions is used to organize dimension data, that is, new versions are stored in the form of new records, and historical version records are still retained. Generally, three new fields will be added - surrogate key (used to distinguish version records), state start time (used to record the start time of the state), state end time (used to record the end time of the state, if the state has not ended , the record is null). When a new state is generated, the state end time field of the previous state will be set to that time, and the new state will be stored in the form of a new record, thus forming a zipper list with each state record.

[0029] At this point, e...

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 relates to a data warehouse model and application thereof. The model is based on each business field, a newly added agent key, an operation moment, an operation type, a pre-recording field and a state automatic end moment field, is specifically designed and applied to various data warehouse data use scenes, and has the beneficial effects that: 1, a data organization form is unified;2, the model can be compatible with more storage engines; 3, more direct single-table analysis capability and more flexible data association logic are provided; 4, data integration work with higher cohesion can be helped to be realized; 5, the continuous integration of the new data source is more convenient; 6, a more effective continuous integrated modeling thought is provided; and 7, according to a predefined state machine, a state migration checking function is promoted to be designed and developed, the accuracy of data is checked in real time, and an alarm is given in time.

Description

technical field [0001] The invention relates to a data warehouse model and its application, and belongs to the technical field of data warehouse models. Background technique [0002] A star schema is a multidimensional data relationship, which consists of a fact table (Fact Table) and a set of dimension tables (Dimension Table) to form a topic. Each dimension table has a dimension as the primary key, and the primary keys of all these dimensions are combined into the primary key of the fact table. The non-primary key attributes of the fact table are called facts (Fact), which are generally numerical or other data that can be calculated; while the dimensions are all types of data such as text and time. In this way, we can organize the data according to different dimension (part or all of the primary key of the fact table) to aggregate these fact data (summary), average (average), count (count), percentage (percent), and even do 20-80 analysis, In this way, the situation of t...

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): G06F16/28G06F16/25
CPCG06F16/254G06F16/283
Inventor 景超
Owner 景超
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