Dimensional modeling is one of the key concepts in data warehouse design. In its essence, it is a collection of techniques used to structure database tables. The primary benefit of…
5 Best RDBMSs – A Comparison of Strengths and Weaknesses
It wouldn’t be far fetched to claim that relational database management systems (RDBMS) are the operational backbone of every modern business nowadays. Storing business-critical data, its speedy retrieval when required,…
Multidimensional Data Modeling – OLAP Cubes
OLAP (short for Online Analytical Processing cubes) refers to multidimensional databases optimized for data warehouse requirements and specific OLAP applications. The OLAP cube is a technique of storing data (or…
Best Practices for Ensuring Impenetrable Data Warehouse Security
In today’s world ‘data’ is the driving force behind any business. Storage of that data in a place where it’s secure from unauthorized access, be it physical or online, is…
Data warehouse and Business Intelligence – Do Both Technologies Complement One Another?
If technicalities were to be put aside and the subject matter of this article was put in layman’s term, it would be “can the cookie cutter exist without the dough?”…
Cloud Technology Making its Way in Data Warehouse Architecture
A data warehouse creates a centralized source of data which facilitates business intelligence, strategy, and decision-making. Thus, having an effective and efficient data warehousing solution is extremely important for any…
SQL Vs. NoSQL: Which Database Approach is Better?
When it comes to database technology, there are two common categories: SQL and NoSQL or relational and non-relational database respectively. They are called SQL and NoSQL referring to whether they…
Traditional vs. Cloud – Comparing the Shift in Data Warehouse Architecture
Data warehouse architecture is changing, and it has been changing for some time now. The traditional on-premise deployment model was succeeded by cloud deployment. However, cloud-based data warehouses are different…