Hello, At my work we are looking for new technologies for an Analysis Engine, and we are evaluating differents technologies one of them is Cassandra as our Data repository.
Now we can execute query analysis agains an OLAP Cube and RDBMS, using MSSQL as our data repository. Cube is obsolete and SQL server engine is slow as data repository. I don't know much about cassandra, I read some books, and looks to fit well on what we are needing, but there are some things that looks like a problem for us. Our engine is designed to be scalable, flexible and dynamic, any user can add new dimensions or measures from any source, all the data is stored on Cube(this is fixed data) and MSSQL(dynamic data) so we have decoupled tables with the dimension values. Ok, with the context given I'll like to clear some doubts - I able to flat the table with all the possible dimension values to cassandra, creating the pk against the dimension columns? this will give me the "sensation" of data pivot over the PK columns? If correct, what if I want to select the order of the columns, or add another or reduce them? - It's possible to extend the values of a row dynamically? What we do often is join row against a value of a mapped external data value to extend the dimensions hierarchical value structure (ie state->Country->Continent) I know we can do some of this things in the core of our engine, like the dimension extension of the values or reduce columns, but as we are evaluating differents technologies is good to know. Regards!! -- Ing. Ivaldi Andres
