数据仓库 [英] Datawarehouse

问题描述

我想为我的数据库生成数据仓库.在那方面，我有30多个表，其中包括模块明智的表.每个表都包含差异主题.
在这30个表中，所有模块(5个模块)中通常使用10个表.

现在，我应该如何设计数据仓库?我将要使用多少事实和维度表?

请帮忙.

Hi,

I want to generate datawarehouse for my database. In that I have more than 30 tables that includes modules wise tables. Each table include diff subject.
From those 30 tables, 10 tables are used commanly in all modules(5 modules).

Now, how should I design data warehouse? How many facts and dimension tables I will have to use?

Please help.

推荐答案

我们无法为您回答这个问题，因为只有您知道您的架构需要什么样.

There''s no way we can answer this for you, because only YOU know what your schema needs to look like.

这篇关于数据仓库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！