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…
4 Data Warehouse Optimization Mistakes to Avoid | Data Warehouse Info Center
[…] manner. The ever-growing data complexity and the endless user needs are difficult to ...
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…
[…] a sense of where and how your data is being stored allows you to have a better unders...
[…] data process and access rights for end users based on legal restrictions and data sec...
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?”…
[…] a short few years, data warehouse has become an indispensable and integral part of al...
[…] which make life easier, and data more comprehensive and readable. If you want to buil...
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…
[…] forced enterprises to rethink their data warehousing strategy. Among the emerging alt...
[…] project. The purpose of having business people in the governance body is to ensure th...
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…
Iqbal Ahmed Alvi
Thank you....
kumari
Thanks for the informative blog...
Metadata Repositories: The Managers of a Data Warehouse
Metadata helps with data management and serves as a descriptor for an object that holds some data or information. In data warehouses, it is collectively organized in a catalog called…