Data warehouse basics

EXPERT TECHNICAL ADVICE: 1 - 3 of 6

	What is the difference between a logical and physical warehouse design? 07 Oct 2009 EXPERT ANSWER - What's the difference between logical design and physical design? Get an expert's take, plus lean about three data warehouse models — the user model, physical model and logical model — and how they differ.

	Definition of primary, super, foreign and candidate key in the DBMS 07 Oct 2009 EXPERT ANSWER - Get the definition of primary key, super key, foreign key and candidate key in the DBMS and learn which key to avoid.

	Data warehousing, data mining and data querying: Terms and definitions 07 May 2008 EXPERT ANSWER - Learn the difference between data warehousing, data mining and data querying.

	VIEW ALL EXPERT TECHNICAL ADVICE ON DATA WAREHOUSE BASICS

REFERENCE & LEARNING: 1 - 3 of 5

	Similarities and differences between ROLAP, MOLAP and HOLAP by Matteo Golfarelli and Stefano Rizzi | 11 Jun 2009 CHAPTER DOWNLOAD - Find out the differences between ROLP, MOLAP and HOLAP and their advantages and disadvantages. Learn about data warehouse quality and the evolution of data warehouse applications.

	Best practices for data warehouse access and reports by Matteo Golfarelli and Stefano Rizzi | 11 Jun 2009 CHAPTER DOWNLOAD - Get best practices techniques for accessing data warehouses with reports, OLAP and dashboards. Learn about common OLAP operators including roll-up, drill-down, and slice-and-dice.

	Advantages of the multidimensional database model and cube modeling by Matteo Golfarelli and Stefano Rizzi | 10 Jun 2009 CHAPTER DOWNLOAD - Discover the advantages of multidimensional databases and find out how data warehouse cube modeling, data restricting and data slicing works.

	VIEW ALL REFERENCE & LEARNING ON DATA WAREHOUSE BASICS

	SEE ALSO - Topics Related to Data warehouse basics:  Data warehouse software, Data warehouse strategy