Modeling Theory and Method for Constructing Fact Table of Data Warehouse

Abstract

Abstract: Based on importing the concept of database space, this paper analyzes the characteristic of detail database dimension of data warehouse, abstracts to three logical dimensions from its statistic space: universal dimension, object dimension and main dimension, introduces a suit of modeling theory and method for constructing fact table of data warehouse, creates all potential fact table. This modeling process can be assisted by computer.

摘要： 该文在引入数据库空间概念的基础上，分析了数据仓库明细数据库的维度特性，抽象出其统计空间的通用、对象和主体3种逻辑维度，提出了一套构造数据仓库事实表的建模理论与方法，生成了所有可能的事实表，并辅之以计算机建模。

关键词: 数据仓库, 数据库空间, 统计数据库, 建模

CLC Number:

TP311.13

WAN Nanyang. Modeling Theory and Method for Constructing Fact Table of Data Warehouse[J]. , 2002, 28(11): 261-263.

万南洋. 数据仓库事实表的建模理论与方法[J]. , 2002, 28(11): 261-263.

/ Recommend / Download Citations

URL: https://www.ecice06.com/EN/Y2002/V28/I11/261

[1]	DING Lin, YANG Yang, GUO Caili, GUO Jianzhang, LI Zheng. A Text-to-SQL Method Based on Fine-Tuning Large Language Models with Table Creation Information [J]. Computer Engineering, 2026, 52(11): 402-411.
[2]	LIN Xiaoqing,ZHANG Fu,CHENG Jingwei. SPARQL Query Optimization Based on Longest Property Path Filtering [J]. Computer Engineering, 2018, 44(11): 7-13.
[3]	YANG Xiujuan,DONG Jun,LI Huihui,YUAN Yanzhong,CHEN Xiaodan. Reverse Furthest Neighbor Query Method Based on Improved Metric Index [J]. Computer Engineering, 2017, 43(4): 234-238.
[4]	YUE Guohua,CHEN Peng. Fast Output Algorithm of Embedded Electronic Map Based on MapInfo Data [J]. Computer Engineering, 2017, 43(1): 93-97.
[5]	GAO Jun,HAO Zhongxiao. Credible Nearest Neighbor Query in Constraint Fuzzy Network [J]. Computer Engineering, 2015, 41(1): 54-60.
[6]	SUN Hailong,WANG Nihong,WANG Chunyan. CKNN Query Based on Constraint of Directional Relation in Road Network [J]. Computer Engineering, 2014, 40(12): 50-56.
[7]	HAO Xiao-hong, ZHANG Li-ping, ZHAO Ling-qiang, LI Song. 3DR39-3d Orientation Relation Model and Reverse Orientation Relation [J]. Computer Engineering, 2014, 40(7): 258-262.
[8]	SUN Hai-long, WANG Ni-hong. CKNN Query Based on RRN-Tree in Road Network [J]. Computer Engineering, 2014, 40(6): 306-311.
[9]	DI Liang, DU Yong-ping. Application of LDA Model in Microblog User Recommendation [J]. Computer Engineering, 2014, 40(5): 1-6,11.
[10]	LU Ti-guang, LIU Xin, LIU Ren-ren. Universal Crawling Algorithm for Microblogging Data [J]. Computer Engineering, 2014, 40(5): 12-16,20.
[11]	GAI Wei-lin, XIN Dan, WANG Lu, LIU Xin, HU Jian-bin. Review of Date Fusion and Decision-making Methods in Situation Awareness [J]. Computer Engineering, 2014, 40(5): 21-25,30.
[12]	GAO Jun, HAO Zhong-xiao. Nearest Neighbor Query for Fuzzy Object in Constraint Network [J]. Computer Engineering, 2014, 40(3): 39-45.
[13]	YIN Shao-hong, FAN Gui-dan. Top-k Frequent Itemsets Mining Algorithm over Data Streams Based on Matrix [J]. Computer Engineering, 2014, 40(3): 55-58,75.
[14]	FENG Jia-jun, WANG Xiao-lin, TIAN Qing. Text Retrieval Model Based on Counting Bloom Filter [J]. Computer Engineering, 2014, 40(2): 58-61.
[15]	SUN Tao, SUN Hong-feng, CHEN Wei-heng, LIANG Sai-ting. Skyline Query in Dataset with Normally Distributed Attributes [J]. Computer Engineering, 2014, 40(1): 45-48.

Please choose a citation manager

Content to export