📄 16.txt
字号:
发信人: sn (小龙), 信区: DataMining
标 题: Re: 国内有没有人做过Olap analysis engine?
发信站: 南京大学小百合站 (Wed Mar 20 11:57:15 2002), 站内信件
I am in a corporation, my aim is to build a system that can be used in my
project implementtation, you know that Olap server is expensive, and I often
do some small project, the customer don't want to spend that much, but they
want to own the olap analysis.
So I want to do an olap analysis engine , which I will store meta data in re
lational
database, and access data over OLE DB interface, and I don't want to organize
data
myself, it 's the matter of relational db, and of course customer should buy
a relational database at least.
Do you think it feasible?
【 在 fervvac (高远) 的大作中提到: 】
: His two sentences covers two architectural choices for an OLAP engine: the
: ROLAP and MOLAP approaches.
: By storing the fact table or the cube in MOLAP format, it means data are
: treated as multidimensional points and the table (relation) is treated as
: multidimensional array.
: Both ROLAP and MOLAP implementation have some trickly places and not that
: straightforward, :p. For example, I am still wondering if there are any
: tricks to enable the MOLAP approach to scale up, for example, 10 dim with 1000
: cardinalities.
: 【 在 coffeemart (构思中) 的大作中提到: 】
: : 哦,那我做过,
: : 满足你的第一条,
: : 我的理解就是以网格表或交叉表的形式将各个dimension以及measure展示出来.
: : 第二条不是太清楚,以多维模式存储数据不就是将fact table,dimension table存在..
: : 里么,当然也可以存在一个大表里,那样查询起来就不要连表啦.
: : 不时是否还有其他深意?
--
※ 来源:.南京大学小百合站 bbs.nju.edu.cn.[FROM: 61.154.244.8]
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -