Thursday April 27th 2017

Categories

Insider

Archives

‘Operational Databases Vrs Business Intelligence’ Archives

Star Schema – Fact table a closer look

Star Schema – Fact table a closer look

In this post we are writing more on factt table in star schema because we believe that clear concept of fact table and its creation is critical to understand the difference between OLTP Relational Database’s logical model and then its de-normalization to create Star schema, which have fact table in the centre. We found some useful writings [...]

Process From OLTP datamodel to Olap DataModel

Process From OLTP datamodel to Olap DataModel

This present s an example showing the process to denormalization for dataware house or data mart Star schema. We researched on this topic in various books and even Microsoft examples they only give sample, but we think it is more important to know how oltp data model is converted in Star schema or olap. We used Microsoft’s Northwind data [...]

Difference between operational databases and Business Intelligence

Difference between operational databases and Business Intelligence

          1-     Operational databases are design to remove redundancy, accurate updates and removal of repetitive   operations for example deposits, flight reservation. Business intelligence has the goal of business reporting and data analyses.   2-     Operational data bases are highly normalized in relational database [...]