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
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
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...
PUM
![No PUM](https://static-eureka.patsnap.com/ssr/23.2.0/_nuxt/noPUMSmall.5c5f49c7.png)
Abstract
Description
Claims
Application Information
![application no application](https://static-eureka.patsnap.com/ssr/23.2.0/_nuxt/application.06fe782c.png)
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
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