People Analytics Design Company

Learning

“Make everything simpler, but not simple” - Albert Einstein

Operational Data Stores and Analytical Data Stores

Operational data stores consist of a method of storing transactional data that is built for the integrity and efficiency of the operational application where the data stemmed from — normalized tables, for example. In contrast to operational data stores, analytical data stores use methods of storing data that are built for the integrity and efficiency of reporting and analysis — through de-normalized columnar design, for example. In the case of statistical analysis, the data must be put in a specific columnar format dictated by the statistical procedure. In other cases, the design of the dataset is for faster query performance.