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

What is PowerPoint?

PowerPoint is a complete presentation graphics package. It gives you everything you need to produce a professional-looking presentation. PowerPoint offers word processing, outlining, drawing, graphing,...

ITech Analytic Solutions

0 0

What is a SQL join?

A SQL join is a Structured Query Language (SQL) instruction to combine data from two sets of data (e.g. two tables). Before we dive into the details of a SQL join, let’s briefly discuss what SQL...

ITech Analytic Solutions

0 0

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

5 Tips For Improving Your Documentation Immediately.

Tip 1) Quit it with the Passive Voice The passive voice is a plague on effective documentation. It reduces its clarity, its consistency, and the efficiency and tightness of the writing. The passive voice...

ITech Analytic Solutions

0 0

Mail Merge In Word

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more user information stored in a list, database, or spreadsheet. Mail Merge is most often used...

ITech Analytic Solutions

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.