Sunday January 21st 2018

Categories

Insider

Archives

A Better Way to Model Data

Screen shot 2015-04-21 at 12.51.49 AMOver the last three decades ERP, CRM, and Analytical systems have evolved. However the way in which those systems store that data has not. In fact in those 3 decades there has been no change in the way that ERP, CRM, and Analytical systems store data.

Generally speaking, modern day ERP and CRM systems are based upon data that has been modeled into a 30 + year old data model called OLTP (RDS – 3rd Normal Form). OTLP stands for On Line Transactional Processing.

Generally speaking, modern day Analytical Systems are based upon data that has been modeled into a 30 + year old data model called OLAP (Star and Snowflake Schemas). OLAP stands for On Line Analytical Processing.

Read More