C
Cip
Greetings,
I have come to the realisation that a lot of my problems could be
easily solved by storing data in "multidimensional" tables in
databases. Instead of the traditional 2-D "Table", using a 3-D "Cube"
would greatly simplify a lot of the pivoting/cross tabular/slicing and
dicing querying my applications are required to perform.
Doing some *preliminary* research, it seems the solution is "OLAP".
- I have MSDE, (MS OLAP is not included), does anyone know of any FREE
databases with some OLAP capabilites? (MSDE, SQLite, Firebird, etc.)
- I have searched sourceforge.net and found "Mondrian". I am going to
try this opensource software and see what I can do with it. Anyone
have any thoughts/experience using Mondrian ??
- Mondrian is Java... are there any .NET efforts currently underway
complete with ADO.NET Providers?
- any recommended links for newbies to OLAP?
Thanks again,
Cip
I have come to the realisation that a lot of my problems could be
easily solved by storing data in "multidimensional" tables in
databases. Instead of the traditional 2-D "Table", using a 3-D "Cube"
would greatly simplify a lot of the pivoting/cross tabular/slicing and
dicing querying my applications are required to perform.
Doing some *preliminary* research, it seems the solution is "OLAP".
- I have MSDE, (MS OLAP is not included), does anyone know of any FREE
databases with some OLAP capabilites? (MSDE, SQLite, Firebird, etc.)
- I have searched sourceforge.net and found "Mondrian". I am going to
try this opensource software and see what I can do with it. Anyone
have any thoughts/experience using Mondrian ??
- Mondrian is Java... are there any .NET efforts currently underway
complete with ADO.NET Providers?
- any recommended links for newbies to OLAP?
Thanks again,
Cip