JAN 25, 2011 12:26pm ET

Related Links

Collaboration Important to Big Data Analytics Success
April 9, 2014
Analytics: Needing to Know or Wanting to Know?
April 9, 2014
Many Utilities Yet to Understand Full Potential for Big Data Analytics
April 7, 2014

Web Seminars

April 29: Create a data protection strategy with open, software-defined storage
April 29, 2014
New Best Practices To Manage Customer Information
May 7, 2014
May 13: Cost-effective, scale-out backup in 1 solution
May 13, 2014

When ROLAP is Not a ROLAP

Print
Reprints
Email

I get many inquiries on the differences and pros and cons of MOLAP vs. ROLAP architectures for analytics and BI.

Get access to this article and thousands more...

All Information Management articles are archived after 7 days. REGISTER NOW for unlimited access to all recently archived articles, as well as thousands of searchable stories. Registered Members also gain access to:

  • Full access to information-management.com including all searchable archived content
  • Exclusive E-Newsletters delivering the latest headlines to your inbox
  • Access to White Papers, Web Seminars, and Blog Discussions
  • Discounts to upcoming conferences & events
  • Uninterrupted access to all sponsored content, and MORE!

Already Registered?

Advertisement

Comments (4)
Hi Boris,

A very interesting area of investigation. When you are looking at Teradata, make sure you consider TBIO (Teradata Business Intelligence Optimizer). We have a case study on our website at: www.simba.com/docs/Teradata-Case-Study.pdf. If you have more questions, would love to chat.

Best wishes, Amyn

Posted by Amyn R | Wednesday, January 26 2011 at 2:16PM ET
Hi Brian

Your observations are spot on.

You may consider adding "Operational scheme support" if the OLAP tool is supposed to be able to work directly on top of ERP systems. This is an obvious use of a ROLAP tool. ERP systems often contain special design details such as partitioned tables (logical and physical), compound keys, enumerated types (identifiers without descriptions in the database; the texts only exits in the application) etc.

Acinta Intelligence Technology (acinta.dk) develops a ROLAP tool with exactly the above specifications, except perhaps that we have downplayed "multi-source support" (you call it "heterogenous joins"), which was not in high demand.

I look forward to see your final document. Feel free to contact me for more information/input to your document.

nikolaj@acinta.dk

Cheers, Nikolaj Henrichsen

Posted by Nikolaj H | Wednesday, January 26 2011 at 4:55PM ET
Add Your Comments:
You must be registered to post a comment.
Not Registered?
You must be registered to post a comment. Click here to register.
Already registered? Log in here
Please note you must now log in with your email address and password.

Are you actively evaluating master data management technologies and their ability to scale and support emerging trends around big data, social and mobile?

Yes 61%
No 23%
Don't Know 9%
Not Applicable 6%

 

Twitter
Facebook
LinkedIn
Login  |  My Account  |  White Papers  |  Web Seminars  |  Events |  Newsletters |  eBooks
FOLLOW US
Please note you must now log in with your email address and password.