Preview

Battle Of The Giants Comparing Kimbal

Powerful Essays
Open Document
Open Document
8368 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Battle Of The Giants Comparing Kimbal
DW MODELS

Data Warehousing
Battle of the Giants:
Comparing the Basics of the
Kimball and Inmon Models
Mary Breslin
Many organizations today need to create data warehouses— massive data stores of time-series data used for decision support.
These organizations face a range of choices, both in terms software tools and development approaches. Making good choices requires an understanding of the two main data warehousing models—
Inmon’s and Kimball’s.
Bill Inmon advocates a top-down development approach that adapts

Mary Breslin has worked in both user and IT roles and she is currently exploring Capella University’s data warehouse from the user side. marybreslin@earthlink.net

traditional relational database tools to the development needs of an enterprisewide data warehouse. From this enterprisewide data store, individual departmental databases are developed to serve most decision support needs.
Ralph Kimball, on the other hand, suggests a bottom-up approach that uses dimensional modeling, a data modeling approach unique to data warehousing. Rather than building a single enterprisewide database,
Kimball suggests creating one database (or data mart) per major business process. Enterprisewide cohesion is accomplished by using another Kimball innovation, a data bus standard.
Understanding how these two models are similar and how they differ gives the reader a foundational knowledge of the most basic data warehouse concepts. We will also explore which organizational characteristics are best suited to each approach.

6

BUSINESS INTELLIGENCE JOURNAL • WINTER 2004

DW MODELS

Introduction and Context
We begin our discussion by defining the data warehouse.
We will introduce the Inmon-Kimball debate, and provide a brief history of the evolution of the two models.
We also provide a brief explanation of the nature of the data warehouse, and conclude with a discussion of the scope of the article.

Context of the Inmon-Kimball Debate
A data warehouse contains massive amounts of



References: Albert, G. The Importance of Data Warehousing (May 03, 2000), BusinessLine, Internet edition, division of The Hindu Business Line. Retrieved August 12, 2003, from http://www.blonnet.com/businessline/2000/05/03/stories/ (April 2003), TDWI Web site. Retrieved August 11, 2003, from http://www.dw-institute.com/research/. Inmon, W.H. Building the Data Warehouse (Third Edition), New York: John Wiley & Sons, (2002). Inmon, W.H. and C. Imhoff. Corporate Information Factory Components, (2002), Inmon Associates Inc site. Retrieved September 9, 2003 from http://www.billinmon.com/library/articles/artcifco.asp. Inmon, W.H. Accelerating the Development of the Enterprise Data Warehouse, (2000), Inmon Associates Inc. Web site. Retrieved September 10, 2003 from http://www.billinmon.com/library/presents/present.asp. Wells, D., Choosing the Right Data Warehousing Approach, (January 3, 2003),TDWI FlashPoint, TDWI Web site. Retrieved July 24, 2003, from http://www.dwinstitute.com/research/. Wells, D. Making Sense of the Methodology Debate, (August 27, 2003a), TDWI FlashPoint, TDWI Web site. Retrieved September 7, 2003, from http://www.dw-institute.com/research/. Whiting, R. Startup Netezza Pushes Discount Data Warehouse Products, (September 23, 2002), CommWeb,

You May Also Find These Documents Helpful

  • Good Essays

    In Sherman Alexie’s fiction, “The Lone Ranger and Tonto Fistfight in Heaven,” Alexie narrates some story presented by some unreal events that happened in the reservation, but he conveyed these stories with real elements such as emotions, facts from history, or even what he remembers from his memory as to what he claims as “reservation realism”.…

    • 369 Words
    • 2 Pages
    Good Essays
  • Better Essays

    In chapter 15, the narrator comes across a coin bank when leaving Mary's house. The coin bank is a figurine is of a grinning black man, who when a coin is placed in its hand and a lever is pushed, tosses the coin into his mouth. This is not only derrogative on how society viewed the african americans but also symbolic in how the narrator has experienced the race being not only treated negatively, but regarded in terms of unequality and in a sense, bottom feeders. More specifically, this can relate to the Battle Royal where the young black boys scavvanged up their winnings on the electrified carpet infront of an audiance that was mainly wealthy white people. To the white men, this exemplified the black men's despair to grab up any money they could, in a humiliating mannor, which was supplied by the white man himself. I think this symbol is significant because it symbolizes the reoccuring issue of black men being lesser equals of the white man, and it doesn't allow the narrator to forget about his "place" in society,…

    • 1568 Words
    • 7 Pages
    Better Essays
  • Satisfactory Essays

    Although the movie Smoke Signals and the book The Lone Ranger and Tonto Fistfight in Heaven share stories and scenes they differ in many way.…

    • 365 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The W.B.C. may order a rematch between their highest ranked Welterweights. According to the W.B.C rankings, Ranked #1 Amir “King” Kahn v's Ranked #2 Danny “Swift” Garcia 2 may happen sooner than later. This fight will be for Floyd Mayweather’s vacant WBC welterweight title.…

    • 582 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Lebron James and Michael Jordan are both considered to be amazing athletes in the game…

    • 765 Words
    • 4 Pages
    Good Essays
  • Good Essays

    “Life is Beautiful” compared to growing “Up in Germany, after the war, After Hitler, afterwards”…

    • 533 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The film “Gods and Generals” is about the first year of Civil War. Many people wondered why the film is called “Gods and Generals.” During the film, many times they mentioned the name “God”, or “Lord”; in this paper, I will explain why I think this film is named so by giving examples from this film to support my idea.…

    • 834 Words
    • 4 Pages
    Good Essays
  • Good Essays

    orders a drink for Annie, and is then asked by Annie to come over and sit by her.…

    • 1744 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    When a streak of light ran across the sky and crashed into the earth the…

    • 277 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    The Battle of Ia Drang Valley was a series of engagements between the U.S 1st Cavalry Division and the B-3 front, North Vietnamese Army. It was a battle between one US division and three NVA regiments. This was the first and last battle between NVA forces and U.S forces of similar size. This battle took place from 11-14-1965, thru 11-18-1965.…

    • 1569 Words
    • 7 Pages
    Better Essays
  • Good Essays

    Antigone Vs Creon

    • 397 Words
    • 2 Pages

    In differentiating between the protagonist and the secondary characters in Greek drama, four characteristics of a traditional Greek hero should be kept in mind: undying loyalty, strong convictions, a single character flaw, and a lesson learned. In the play, Antigone, by Sophocles, two characters, Antigone and Creon, have thee of these four. The possession of the fourth quality is what sets one apart as the main character. Even though the title of the play is Antigone, the main character-the protagonist- is Creon.…

    • 397 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Antigone Vs Creon

    • 917 Words
    • 4 Pages

    “My belt holds my pants up, but the belt loops hold the belt up. So which one’s the real hero?” --- Mitch Hedberg…

    • 917 Words
    • 4 Pages
    Good Essays
  • Better Essays

    The Jungle Book Comparison

    • 1621 Words
    • 7 Pages

    The Jungle by Upton Sinclair is a novel about the harsh conditions and hard lives of working immigrants during the early 1900s. The story follows a Lithuanian man named Jurgis Rudkus and all the hardship and tragedy he endures. Cinderella Man directed by Ron Howard is a film about the famous boxer James J. Braddock. The film shows the hardship James and his family suffer during the Great Depression. Jurgis Rudkus and James J. Braddock show similarities from the beginning, middle, and end in their physical traits, relationships and emotional traits.…

    • 1621 Words
    • 7 Pages
    Better Essays
  • Good Essays

    The main character of the novel is D’Artagnan was raised in the French province of Gascony, an area known for its courageous and brave men, but he also has a hot head, which means if he get assaulted in any kind of way he is ready to fight to the death. For him to have a hot head in the story, that's got him in a situation that is very hard to get himself out of. D’Artagnan has good looks, his honesty and integrity, his loyalty to the king and his expert swordsmanship. On his journey he quickly makes friends with the three musketeers, and later he finds himself in a position to do a great service for the queen of France…

    • 1062 Words
    • 5 Pages
    Good Essays
  • Good Essays

    A hero is one who can look fear in the eyes and laugh. He can tackle any obstacle and come through on top. There are few who can live up to these heroic expectations. Though it may seem silly, a lion from an animated movie is the first character that comes to my mind that depicts the qualities of a hero. This is no ordinary lion though; he is a lion that triumphs over many barriers, his name is Simba. Simba's life is full of much pain because he believes he is the cause of his father's death. He overcomes these hurdles and grows up to be a powerful lion king, after realizing his father's death was not his fault. Simba shows what I think are the three main characteristics of a hero: bravery, determination, and strength.…

    • 965 Words
    • 3 Pages
    Good Essays

Related Topics