Datawarehouse: Bill Inmon Vs. Ralph Kimball

Kriti C.

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

Chart

A chart is a set of coordinates When you make a chart you start with an empty, two-dimensional space, a vertical dimension (y) and a horizontal dimension (x) . You also have a data source. Your job is...

ITech Analytic Solutions

0 0

Tableau Hands on

This video explains about Parameters, Grouping, Top N parameter, Playing with Filters, Donut charts, Bullet Graphs, Gantt Charts and Box and Whisker charts in Tableau. This video will be very beneficial...

Cognitior

0 0

SQL Join Types

There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all...

ITech Analytic Solutions

0 0

Beware Of Trainers Of Data Science.

Most of the trainers in the market are teaching DATA SCIENCE as 1) Some software tools like R/Python/SAS/Hadoop etc 2)They are spending less amount of time on Mathematics and Statistics(Mostly 10 hrs...

Data Labs Training and Consulting Services

2 1

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

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.