Tag: data warehouse

What is Dimensional Model in Data Warehouse?

What is Dimensional Model in Data Warehouse?

What is Dimensional Model? A dimensional model is a data structure technique optimized for Data warehousing tools. The concept of Dimensional Modelling was developed by Ralph Kimball and is comprised of "fact" and "dimension" tables. A Dimensional model is designed to read, summarize, analyze numeric information like values, balances, counts, weights, etc. in a data … Continue reading What is Dimensional Model in Data Warehouse?

Advertisements
Database vs Data Warehouse: Key Differences

Database vs Data Warehouse: Key Differences

What is Database? A database is a collection of related data which represents some elements of the real world. It is designed to be built and populated with data for a specific task. It is also a building block of your data solution. What is a Data Warehouse? A data warehouse is an information system … Continue reading Database vs Data Warehouse: Key Differences

Difference between Data Mining and Data Warehouse

Difference between Data Mining and Data Warehouse

What is Data warehouse? A data warehouse is a technique for collecting and managing data from varied sources to provide meaningful business insights. It is a blend of technologies and components which allows the strategic use of data. Data Warehouse is electronic storage of a large amount of information by a business which is designed … Continue reading Difference between Data Mining and Data Warehouse

Can Hadoop Replace a Data Warehouse?

Can Hadoop Replace a Data Warehouse?

The users I spoke with ranged from seasoned data warehouse professionals to professionals who are better described as application developers who have limited data experience. Given the diversity of users (who come from diverse organizations with diverse requirements), I got diverse ideas about what a warehouse is (and is not), plus whether or not Hadoop … Continue reading Can Hadoop Replace a Data Warehouse?