User Tools

Site Tools


glossary:d:drill_down_up
  • Bookmark "Drill Down and Drill Up" at del.icio.us
  • Bookmark "Drill Down and Drill Up" at Digg
  • Bookmark "Drill Down and Drill Up" at Furl
  • Bookmark "Drill Down and Drill Up" at Reddit
  • Bookmark "Drill Down and Drill Up" at Ask
  • Bookmark "Drill Down and Drill Up" at Google
  • Bookmark "Drill Down and Drill Up" at Netscape
  • Bookmark "Drill Down and Drill Up" at StumbleUpon
  • Bookmark "Drill Down and Drill Up" at Technorati
  • Bookmark "Drill Down and Drill Up" at Live Bookmarks
  • Bookmark "Drill Down and Drill Up" at Yahoo! Myweb
  • Bookmark "Drill Down and Drill Up" at Facebook
  • Bookmark "Drill Down and Drill Up" at Newsvine
  • Bookmark "Drill Down and Drill Up" at Yahoo! Bookmarks
  • Bookmark "Drill Down and Drill Up" at Twitter
  • Bookmark "Drill Down and Drill Up" at myAOL
  • Bookmark "Drill Down and Drill Up" at Slashdot
  • Bookmark "Drill Down and Drill Up" at Mister Wong

Drill Down and Drill Up

Drill Down and Drill Up (also known as Data Drilling) means to navigate in hierarchical dimensions of data stored in Data Warehouses. There are two opposite ways of data drilling:

  • Drill Down is used within Online Analytical Processing (OLAP) to zoom in to more detailed data by Changing Dimensions
  • Drill Up means to zoom out stepwise (also known as roll up)

Example

If you have catalogue data about used cars stored in a database, first dimension could be the type of cars (limousine, SUV, etc.). Second dimension could be the manufacturer, third the production year. So you can drill down from type over manufacturer to year of production, reducing the amount of found data in every step.

  • Bookmark "Drill Down and Drill Up" at del.icio.us
  • Bookmark "Drill Down and Drill Up" at Digg
  • Bookmark "Drill Down and Drill Up" at Furl
  • Bookmark "Drill Down and Drill Up" at Reddit
  • Bookmark "Drill Down and Drill Up" at Ask
  • Bookmark "Drill Down and Drill Up" at Google
  • Bookmark "Drill Down and Drill Up" at Netscape
  • Bookmark "Drill Down and Drill Up" at StumbleUpon
  • Bookmark "Drill Down and Drill Up" at Technorati
  • Bookmark "Drill Down and Drill Up" at Live Bookmarks
  • Bookmark "Drill Down and Drill Up" at Yahoo! Myweb
  • Bookmark "Drill Down and Drill Up" at Facebook
  • Bookmark "Drill Down and Drill Up" at Newsvine
  • Bookmark "Drill Down and Drill Up" at Yahoo! Bookmarks
  • Bookmark "Drill Down and Drill Up" at Twitter
  • Bookmark "Drill Down and Drill Up" at myAOL
  • Bookmark "Drill Down and Drill Up" at Slashdot
  • Bookmark "Drill Down and Drill Up" at Mister Wong
glossary/d/drill_down_up.txt · Last modified: 2014/10/19 13:38 (external edit)