Datawarehouse: Bill Inmon Vs. Ralph Kimball

Kriti

31/08/2017 2 0

In the data warehousing field, we often hear about discussions on where a person / organization's philosophy falls into Bill Inmon's camp or into Ralph Kimball's camp. We describe below the difference between the two.

Bill Inmon's paradigm: Data warehouse is one part of the overall business intelligence system. An enterprise has one data warehouse, and data marts source their information from the data warehouse. In the data warehouse, information is stored in 3rd normal form.

Ralph Kimball's paradigm: Data warehouse is the conglomerate of all data marts within the enterprise. Information is always stored in the dimensional model.

2 Like 0 Dislike

Follow 3

Other Lessons for You

Will Big Data clean up ETL

The fuss in the Datawarehousing world is will Big Data kill the existing ETL tools. The answer is a big "NO". Big Data with the combination of ETL will pave the way for easy reporting and data maintenance....

Sharad

0 0

Learning a BI Tool

Before learning a BI Tool, make sure that you have good understanding of Oralce(SQL Language) Database and ETL Concepts. So that you will be able to grasp/Learn it fast and easy. Top 10 BI Tools : Informatica...

Trainingp - training and placement

1 0

An Introduction to Business Intelligence Concepts

Looking for a Business Intelligence (BI) solution for your company can be intimidating. BI uses its own special terminology and the database design concepts can be difficult to grasp. So where do you...

ITech

0 0

What Are Macros?

i. Macros are little programs that run within Excel and help automate common repetitive tasks. Macros are one of Excel's most powerful, yet underutilized feature. Using macros, you can save hours and boost...

ITech

0 0

What is a VBA Module?

VBA code is stored and typed in the VBA Editor in what are called modules As stated on the VBA Editor page, a collection of modules is what is called a VBA project Every major Microsoft Office product...

ITech

0 0

Find Data Warehouse Training near you

Looking for Data Warehouse Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Data Warehouse Questions

My daughter 3rd year IT Hyderabad , interested career in database side. What is best way to go about...

9 Answers

Looking for Data Warehouse Classes?

The best tutors for Data Warehouse Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Data Warehouse with the Best Tutors

The best Tutors for Data Warehouse Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.