At 09:49 AM 4/29/2009, you wrote:
Hi
I have a table that stores huge rows in 15 years, now we have to do some
analysis about these row in Time dimension.To gain performance,at begining,
i've extrait the data according to years from my DB to build my fact table.
But since I have 15 fact tables,
om
Subject: Partition of Mysql
Hi
I have a table that stores huge rows in 15 years, now we have to do some
analysis about these row in Time dimension.To gain performance,at begining,
i've extrait the data according to years from my DB to build my fact table.
But since I have 15 fact tables, tha
Hello Lin
What tools are you using to model your data and build your OLAP cube? If I
were building a cube which required data from 15 fact tables which only
differed in that they contained a different years data, I would model the
15 tables so they appeared as one using something like Cognos Frame
Hi
I have a table that stores huge rows in 15 years, now we have to do some
analysis about these row in Time dimension.To gain performance,at begining,
i've extrait the data according to years from my DB to build my fact table.
But since I have 15 fact tables, that complicate my olap cube.Today,
