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 Framework Manager.
Could you not build some summary tables to present the data in an aggregated manner so the cube has to do less work? MySQL does support partitioned tables and it works fairly well depending on your hardware. Regards John > 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, i > found > that mysql surpport partition table since 5.1, i wanna know is it work > well > ? I mean that is it more efficace than table with-out partitions? > I don't want to transformer the data again, as it takes too much time, is > it > possible to just alter my orignal table to add the partitions by years, > > excuse my poor english writing and thank you for your answers > -- > ------------------------- > Lin Chun > > > ______________________________________________ > This email has been scanned by Netintelligence > http://www.netintelligence.com/email > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
