iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

  • Facebook
  • Instagram
  • LinkedIn
  • Phone
  • Twitter
  • YouTube

Copyright © 2023 · iT Synergy·

Have Data warehouse and Data mart got the same meaning?
Have Data warehouse and Data mart got the same meaning? avatar

October 12, 2011 By Ana María Orozco Zuluaga Leave a Comment

In my previous blog I exposed something about dimensions such as important part of BI. Now I am going to expose another essential part of BI: Data Mart and/or Data Warehouse making emphasis in the differences that Ralph Kimball and Bill Inmon have between those two definitions.

Gartner Group is an information technology research; it has a Business Intelligence definition that I particularly like: “Set of tools that provide the capacity to business users to analyze a huge amount of data and extract valuable information, which they can use to support fast decision in a highly competitive market”. There is a part that they doesn’t mention and I would like to add something to that definition, with BI we can create knowledge through the data analysis that exist in organizations and companies, that is call Data Mining (It will be my next blog).
Business Intelligence helps to resolve some paradigms existent:

• Users don’t have the correct information in the right time.
• They don’t have a unique true of the information.
• It is difficult to find, consolidate or have a specific detail of the information.

Then, when all those paradigms are resolved the organization gain competitiveness because of the decisions can be taken faster, making decision is much better in all organizations levels and they can make coordinated decisions alignedto all company processes. In the same way the value of BI consists on integration of data from multiple sources, share analyzes with different users, create a scalable infrastructure, so on.
The previous information is a general view about BI. Now I am going to focus the rest of the blog in the design phase because of my main interest is talk about Data Mart and Data Warehouse.

In the pictures below, we can notice easily the main differences between Ralph and Inmon definition.

 

 

 

 

Ralph’s definition says:  Data Warehouse is the result of the union of all small Data Marts inside the organization. For that reason the information is always store in dimensional models.

Bill’s definition instead says: Data Warehouse is only a part of all organization Business Intelligence system. An organization has a Data Warehouse and additionally has a Data Marts that take information from Data Warehouse. In the Data Warehouse the information is in third normal form. However the information in the Data Marts is non-normalized and multidimensional.

In this point I will introduce the two implementation strategies that the authors created, its advantages and disadvantages:

  • Top down by Bill Inmon
    • The first step is to build the Data Warehouse and then extract information needed to generate the Data Marts.
    • The Data marts are dimensional models
    • Advantages:
      • More flexibility
    • Disadvantages:
      • More time in building up
      • The cost is higher
  • Bottom up by Ralph Kimball
    • Data marts are built progressively align with the business priority, and like this you are building the Data warehouse. “Think global, act Local”
    • Advantages:
      • Solutions smaller and faster to build
      • Solutions easier to understand
    • Disadvantages
      • Complex maintenance
      • Synchronizing problems

 

Filed Under: Windows 8 Tagged With: Business Intelligence, Data Mart, Data warehouse

Team


Marco
Antonio Hernández

Jaime
Alonso Páez

Luis
Carlos Bernal

Ana
María Orozco

Juan
Camilo Zapata

Carlos
Alberto Rueda

Sonia
Elizabeth Soriano

Diana
Díaz Grijalba

Bernardo
Enrique Cardales

Alexandra
Bravo Restrepo

Juan
Alberto Vélez

Diana
Paola Padilla

Jhon
Jairo Rodriguez

Yully
Arias Castillo

Carlos
Andrés Vélez

Brayan
Ruiz

Jesús
Javier Hernández

Alejandro
Garcia Forero

Gustavo
Adolfo Echeverry

Josué
Leonardo Bohórquez

Oscar
Alberto Urrea

Odahir
Rolando Salcedo

Jimmy
Quejada Meneses

Natalia
Zartha Suárez

Mario
Andrés Cortés

Eric
Yovanny Martinez

Carolina
Torres Rodríguez

Juan
Mauricio García

Tag Cloud

.NET (9) 940px (1) Analysis Services mdx (1) An attempt was made to load a program with an incorrect format. (1) ASP.NET MVC (1) Azure (3) Backup (1) BAM (7) BAM API (1) BAMTraceException (2) BI (3) BizTalk (24) Business Intelligence (6) C# (2) caracteristicas de publicacion (2) Content Editor (3) ESB (15) ESB Toolkit (3) General (4) habilitar caracteristicas (3) indexes (2) Integration Services (2) Master Page (3) MDX (2) MSE (11) net.tcp (2) Office 365 (2) Oracle (2) Performance Point (2) Public Website (2) Receive Location (2) SDK (2) Servicio Web (2) Sharepoint 2010 (2) SharePoint 2013 (4) SharePoint Online (2) SOA (8) Soap Fault (2) Sort Months MDX (2) SQL Server (2) Visual (2) Visual Studio 2010 (2) WCF (19) Windows (3) Windows 8 (17)

Categories

  • .NET (33)
  • Analysis Services (1)
  • ASP.NET MVC (2)
  • Azure (7)
  • BAM (9)
  • BAM PrimaryImport (3)
  • BigData (1)
  • BizTalk (77)
  • BizTalk 2010 configurations (57)
  • BizTalk Application (60)
  • BizTalk Services (13)
  • Business Intelligence (4)
  • Cloud (3)
  • CMD (1)
  • CodeSmith – NetTiers (2)
  • CommandPrompt (1)
  • CRM OptionSet mapping component (1)
  • Desarrollo de software (6)
  • develop (6)
  • developers (3)
  • DropBox (1)
  • Dynamics (1)
  • Enterprise Architect (1)
  • Entity Framework (1)
  • Errores BizTalk (2)
  • ESB (27)
  • ETL (1)
  • Event Viewer (1)
  • Excel Services (1)
  • Foreach loop container (1)
  • General (4)
  • Gerencia de Proyectos (2)
  • Google (1)
  • Grouped Slices (1)
  • Human Talent (1)
  • IIS (4)
  • Integración (6)
  • Integration Services (3)
  • KingswaySoft (1)
  • Lync (1)
  • MSE (13)
  • Office 365 (2)
  • Oracle Data Adapter (2)
  • Performance Point (4)
  • Picklist (1)
  • Pivot Table (1)
  • Procesos (1)
  • Pruebas (1)
  • Public Website (2)
  • Reports (1)
  • SCRUM (1)
  • SDK (2)
  • SEO (1)
  • Servicios (2)
  • Sharepoint (9)
  • SharePoint 2010 (10)
  • SharePoint 2013 (4)
  • SharePoint Online (2)
  • SharpBox (1)
  • Shortcuts (1)
  • Sin categoría (1)
  • SOA (50)
  • SQL (5)
  • SQL Server (3)
  • SQL Server Management Studio (1)
  • SSIS (3)
  • SSL (1)
  • SSO (1)
  • Tracking Profile Editor (2)
  • Twitter (1)
  • Uncategorized (1)
  • Virtual Network (2)
  • Visual Studio 11 (1)
  • Visual Studio 2010 (2)
  • Visual Studio Online (1)
  • VMware (2)
  • WCF (24)
  • Web (1)
  • Web Api (1)
  • Windows (5)
  • Windows 8 (11)
  • Windows Azure (2)
  • Windows Live Write (1)
  • Windows Phone (7)
  • Windows Phone 8 (1)
  • Windows Scheduler (1)
  • windows8 (2)
  • WindowsRT (3)
  • WP7 SDK (1)

Manage

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org