Preview

Multidimensional Data Model

Good Essays
Open Document
Open Document
1086 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Multidimensional Data Model
A MULTIDIMENSIONAL DATA MODEL
Data warehouses and OLAP tools are based on a multidimensional data model. This model views data in the form of a data cube.
FROM TABLES TO DATA CUBES
What is a data cube?
A data cube allows data to be modeled and viewed in multiple dimensions. It is defined by dimensions and facts.
In general terms, dimensions are the perspectives or entities with respect to which an organization wants to keep records. Each dimension may have a table associated with it, called a dimension table, which further describes the dimension.
Facts are numerical measures. The fact table contains the names of the facts, or measures, as well as keys to each of the related dimension tables.
Example:
2-D representation, the sales for Vancouver are shown with respect to the time dimension (organized in quarters) and the item dimension (organized according to the types of items sold). The fact, or measure displayed is dollars sold.

Now, suppose that we would like to view the sales data with a third dimension. For instance, suppose we would like to view the data according to time, item, as well as location. The above tables show the data at different degrees of summarization. In the data warehousing research literature, a data cube such as each of the above is referred to as a cuboid. Given a set of dimensions, we can construct a lattice of cuboids, each showing the data at a different level of summarization, or group by (i.e., summarized by a different subset of the dimensions). The lattice of cuboids is then referred to as a data cube. The following figure shows a lattice of cuboids forming a data cube for the dimensions time, item, location, and supplier.

The cuboid which holds the lowest level of summarization is called the base cuboid.
The 0-D cuboid which holds the highest level of summarization is called the apex cuboid. The apex cuboid is typically denoted by all.

STARS, SNOW FLAKES, AND FACT

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Qut Ayb225

    • 461 Words
    • 2 Pages

    * Measures that could be added to the list that relate to the other two dimensions are customer…

    • 461 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Cigarette Butt

    • 643 Words
    • 3 Pages

    Most objects in the world today are created in 3 dimensions, they display height, width, and length hence the term 3D (Three dimensional). Most Orthographic drawings are drawn showing these three dimensions…

    • 643 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Johnson and Johnson

    • 617 Words
    • 3 Pages

    The third dimension I found was the Brand dimension, which is defined as “a company’s symbols, words or marks through which a company communicates a promise to their customers” (Sawhney, Mohanbir, Wolcott, Scott & Arroniz, Inigo, 2006). Johnson & Johnson has a Credo, which is a statement of promises and responsibilities to their customers, employees, communities and stakeholders.…

    • 617 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Week 3

    • 754 Words
    • 4 Pages

    6. The type of logical database model that treats data as if they were stored in two-dimensional tables is the (Points : 1)…

    • 754 Words
    • 4 Pages
    Satisfactory Essays
  • Best Essays

    Historically, a manual file system was composed of a system of file folders and filing cabinets.…

    • 2439 Words
    • 17 Pages
    Best Essays
  • Best Essays

    References: 1KeyData. (2012). Data Warehousing > Concepts > Conceptual, Logical, And Physical Data Models . Retrieved May 23 2012, from Conceptual, Logical, And Physical Data Models: http://www.1keydata.com/datawarehousing/data-modeling-levels.html…

    • 3587 Words
    • 15 Pages
    Best Essays
  • Good Essays

    Closing Case Study One

    • 1065 Words
    • 5 Pages

    To redesign Ben & Jerry’s data warehouse the dimensions of information include frozen yogurt, ice cream, merchandise, locations, sales and shipping. This company should track all the different types of ice cream and yogurt flavors. They should also monitor these areas with the highest and lowest sales to make adjustments to save money. There should be information gathered on the merchandise being sold by Ben & Jerry. Ben & Jerry will monitor sales from stores in other locations ensuring the right merchandise is being shipped to the right location. The different dimensions are merchandise and locations.…

    • 1065 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Data Warehousing Failures

    • 5385 Words
    • 22 Pages

    At first, the planner for the data warehouse wanted to use a dimensional model for tabular information. But political pressure forced the system’s early use. Consequently, mainframe data was largely replicated and these tables did not work well with the managed query environment tools that were acquired. The number of tables and joins, and subsequent catalog growth, prevented Auto Guys from using data as it was intended in a concise and coherent business format.…

    • 5385 Words
    • 22 Pages
    Powerful Essays
  • Good Essays

    Augmented Product

    • 1204 Words
    • 5 Pages

    The tangible dimension which is sometimes referred to as the service dimension focuses on aspects such as pre and after-sales service, installation and delivery, warranty and advice.…

    • 1204 Words
    • 5 Pages
    Good Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    A data warehouse is a “subject-oriented, integrated, time varying, non-volatile collection of data that is used primarily in organizational…

    • 2507 Words
    • 11 Pages
    Best Essays
  • Good Essays

    Math Portfolio

    • 2167 Words
    • 9 Pages

    The first dimension is best and the easiest to start with. Lets us take an…

    • 2167 Words
    • 9 Pages
    Good Essays
  • Powerful Essays

    Data Modeling by Example

    • 8185 Words
    • 33 Pages

    This book adopts a unique approach which is based on using existing Data Models as the basis for designing new ones to meet specific requirements.…

    • 8185 Words
    • 33 Pages
    Powerful Essays
  • Powerful Essays

    Dimension—a feature that can be focused on individually or separately, but can only be understood in relation to other…

    • 1793 Words
    • 22 Pages
    Powerful Essays
  • Better Essays

    6. Dimensions should be given in views where the shapes are presented in profile and/or contour.…

    • 1118 Words
    • 5 Pages
    Better Essays