Securing Executive Support Through Business Sponsorship Business Sponsorship: Is there appropriate executive sponsorship, i.e., an identified and engaged steering committee and commensurate funding? DW/BI projects require strong executive sponsorship. Defining …
OLAP – ROLAP, MOLAP and HOLAP
How OLAP, ROLAP, MOLAP, and HOLAP Work OLAP – Online Analytical Processing It is a technology used to organize large business databases and supports performing complex and multidimensional analysis, at …
Data Warehouse, Data Lake & Data Vault
Understanding Data Lake vs Data Warehouse Data Lake and Data Warehouse both act as repositories, but they are designed for very different purposes. Data Warehouses work best for specific projects …
Data Modeling – Conceptual, Logical and Physical Model – CDM, LDM and PDM
What is Data Modeling? Data Modeling is the process of creating an illustrative and visual representation of either a whole information/database system or parts of it to show the relationships …
NoSQL Column-Oriented Database – Columnar Database – Column Store Database – C-Store
Introduction to NoSQL Column-Oriented Database NoSQL Column-Oriented Database is also known/called Columnar Database, Column Store Database, and C-Store. OLTP and OLAP in Column-Oriented Systems Column-oriented systems have been developed as …