AnalyticBridge
Data Intelligence, Business Analytics
OLAP or not OLAP ?
Hello everybody,
In my department, we are about to modelize a OLAP database, but at the moment we are not sure of the kind of logical model. Maybe OLAP is not well suited, and a traditional relational database would be enough.
The point is that we have collections of documents, each one represented by a notice. Have you ever heard of a OLAP DB on documents' notices ?
Best regards,
Jean-Charles.
In my department, we are about to modelize a OLAP database, but at the moment we are not sure of the kind of logical model. Maybe OLAP is not well suited, and a traditional relational database would be enough.
The point is that we have collections of documents, each one represented by a notice. Have you ever heard of a OLAP DB on documents' notices ?
Best regards,
Jean-Charles.
Views: 51
Replies to This Discussion
-
Permalink Reply by Theodore Omtzigt on -
Jean-Charles:
Wow, nobody has picked up on this request: that is too bad. Let me give this a try.
I have started to work with a company called OpenBI (www.openbi.com) which is a services company that helps folks evaluate if an OLAP database is the right vehicle to support your information needs. I have several experiences of OLAP efforts failing miserably and their approach is more goal oriented, which I believe is more pragmatic. OLAP is just a means and a very expensive means at that. If all you need is information access, or consolidation of document notices there are more effective means to get you the data.
If you contact them, let them know that I pointed you to them.
Good luck,
Theo -
-
Permalink Reply by jean-charles on -
Ok, Thank you theo for answering...
I keep this link and it gives me a few ideas for organizing the outsourcing...
Jean-Charles. -
-
Permalink Reply by Theodore Omtzigt on
-
Jean-Charles:
Please do and don't hesitate to drop me a line when you have questions. I am getting pretty deep into this domain so I will be able to help you. The work we are exploring with OpenBI is pretty advanced statistical modeling with operational data validation. We are also working on predictive models for California's corporate tax revenue: again a mixture of advanced a-priori models validated with operational data.
Theo -
-
Permalink Reply by Tom Wolfer on -
Jean-Charles; I know it is a little late to respond to this, however, can you explain more about what the collections of documents are? Off the top of my head, though, OLAP is not restricted by the type of data it can store; model the data properly and OLAP will help you to better report on it. How much data do you have (eg. documents) and what are these documents for? Answering these questions might help you determine how much time, effort, and money to put into OLAP given your objectives.
-
-
Permalink Reply by Pat Murray on -
Jean-Charles,
I just saw your posting today, March 17, 2009.
Yes, depending on the details of your requirement, OLAP might just be the best interface to your collection. If you still need a sounding board, please feel free to contact me at: patmurray12@juno.com
Best regards,
Pat Murray -
Top Content
Follow us
© 2013 AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC
