Preview

BDW

Satisfactory Essays
Open Document
Open Document
669 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
BDW
1. Define, and illustrate using a diagram, the following: Primary Data Warehouse and Data Mart. In this connection, explain the difference between ROLAP and MOLAP.
A Primary Data Warehouse is a central repository of a database of a complete organization. It holds multiple subject areas and very detailed information. A Data Mart is a subset or an aggregation of the data stored to a primary data warehouse. It often holds only one subject area – for example, a specific department, finance or sales. It may hold more summaried data, and is typically smaller than a warehouse because of its employment on a different grain. Figure 1.1 illustrates the difference between data mart and a primary data warehouse. Since the data mart typically holds one subject area, it is much smaller than a primary data warehouse. These data marts can be viewed as small, local data warehouses replicating the part of primary data warehouse which is required by a specific domain or department.

Figure 1.1 A data warehouse does not necessarily use a dimensional model, since it is partly normalized RDBMS, but data marts are multidimensional cubes. This connection gives arise to two concepts, ROLAP and MOLAP. ROLAP is an implementation based on a relational database, in our case which is a primary data warehouse, and MOLAP is an implementation based on a multidimensional database which are data marts. ROLAP tools use the relational database to access the data and generate SQL queries to calculate information, whereas MOLAP tools are designed to allow data analysis through the use of multidimensional data model, but it differs significantly from ROLAP because it requires storage of information in the cubes, which are known as data marts.
2. Compare one-, two-, and three-layer DW architectures. What benefit does the reconciled layer provide in the thee-layer architecture?

One Layer Architecture: The goal of a single layer architecture is to minimize the amount of data stored, which is



References: Textbook ‘Data Warehouse Design’ By Matteo Golfarelli and Stefano Rizzi

You May Also Find These Documents Helpful

  • Satisfactory Essays

    nt1210

    • 831 Words
    • 4 Pages

    Define each layer of the OSI model in your own words and state what each layer provides. Use your textbook or internet research to support your answer.…

    • 831 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    NT1210 Lab 3.1 Review

    • 505 Words
    • 3 Pages

    The layers are all about how the application handles data, not the network, which is what the model demonstrates. They could be combined or separated.…

    • 505 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    MIS 563 COURSE PROJECT

    • 2795 Words
    • 12 Pages

    This finding has ABC University seeking a streamlined way to manage their data and for users to access the data that is clean. With this, the University has proposed the creation and implementation of a data warehouse to house all the data from each one of these operational databases into one central location where all students, staff and faculty can access the data using a self service tool such as a report or a data connection to Microsoft Excel to pull data into pivot tables.…

    • 2795 Words
    • 12 Pages
    Powerful Essays
  • Good Essays

    Chapter 5 Quiz

    • 334 Words
    • 5 Pages

    A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:…

    • 334 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Ibm 211 Week 3

    • 4383 Words
    • 18 Pages

    IBM Telecommunications Data Warehouse V8.4 and IBM Health Plan Data Model V8.4 help accelerate development of cost-efficient industry data warehouse solutions…

    • 4383 Words
    • 18 Pages
    Powerful Essays
  • Good Essays

    8. What types of capabilities does the Internet provide businesses and what Internet protocols or technologies support these? Which have proven the most valuable to businesses thus far?…

    • 3113 Words
    • 11 Pages
    Good Essays
  • Satisfactory Essays

    4. What layer of the OSI model ensures that information sent by the application layer will be formatted properly so that the application layer of another system can read the data?…

    • 256 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Science

    • 419 Words
    • 2 Pages

    2. List the seven layers of the OSI model, including both layer number and name for each.…

    • 419 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    | * The data warehouse of St George bank supports the integrated data among different departments * Data from different departments can be accessed freely * Integrated data from the data warehouse is more beneficial and creates more opportunities and BI for all departments (1+1=3) * “Most departments extract what they need from the warehouse using customer relationship management and BI applications without intervention.” * “They have access to all the data, can create their own filters, their own campaigns.”…

    • 341 Words
    • 1 Page
    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
  • Powerful Essays

    Osi Model

    • 2118 Words
    • 9 Pages

    seven layers. Each layer both performs specific functions to support the layers above it and offers…

    • 2118 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    3. The core layer of the hierarchical design is the high-speed backbone of the internetwork. The core layer is critical for interconnectivity between distribution layer devices, so it is important for the core to be highly available and redundant.…

    • 1870 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    In a database system, the data is managed by the DBMS and all access to the data is through the DBMS providing a key to effective data processing. This contrasts with conventional data processing systems where each application program has direct access to the data it reads or manipulates. In a conventional DP system, an organization is likely to have several files of related data that are processed by several different application programs.…

    • 470 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Adasdsad

    • 6159 Words
    • 25 Pages

    8. At which layer of the hierarchical network design are you least likely to find redundancy?…

    • 6159 Words
    • 25 Pages
    Powerful Essays
  • Satisfactory Essays

    NT1210 Labs 3.1-3.4

    • 1882 Words
    • 9 Pages

    1. Why would a three-layer model of communication that has the layers physical, network, and application be insufficient to adequately describe network communication?…

    • 1882 Words
    • 9 Pages
    Satisfactory Essays