Data warehouse with a domain fact table
作者： Allan Michael Gonsalves
DOI:
关键词:
摘要: A data warehouse includes a plurality of master tables. The tables include surrogate identifiers. Each identifier (SID) identifies table domain inside from the dimension use identifiers to link domains within fact stores (DIM IDs) that provide links aggregated stored in is accessible using identifiers, without DIM IDs table.
lens.org 参考文章(12)
Hasso Plattner, Jan Schaffner, Jens Krueger, Anja Bog, Alexander Zeier, ETL-Less Zero-Redundancy System and Method for Reporting OLTP Data ,(2008)
Jian Le, Daniel DeKimpe, Method, apparatus and program storage device for optimizing a data warehouse model and operation ,(2005)
Masaya Higuchi, Method and apparatus for processing a dimension table and deriving a hierarchy therefrom ,(2006)
Craig Reginald Tomlyn, William Earl Malloy, Attribute-based access for multi-dimensional databases ,(1997)
Alexander Berger, Amir Netz, Mosha Pasumansky, Path compression for records of multidimensional database ,(2000)
Craig Reginald Tomlyn, Gary Robinson, Simon Edward Moore, William Earl Malloy, Relational emulation of a multi-dimensional database ,(1997)
Chung-Sheng Li, Vittorio Castelli, John Timothy Robinson, Anant Deep Jhingran, System and method for generating multi-representations of a data cube ,(1997)
Raymond Roccaforte, Storing multidimensional data in a relational database management system ,(2002)
Murali Vajjiravel, Paul D. Clark, Kevin Paul Kornelson, Brian Burdick, Tarek Najm, Rajeev Prasad, Data transformation to maintain detailed user information in a data warehouse ,(2006)
Reuven Bakalash, Joseph Caspi, Guy Shaked, Enterprise-wide data-warehouse with integrated data aggregation engine ,(2002)