Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Data Vault

    Uploaded by

    sumrun sahab

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Data Vault

    Uploaded by

    sumrun sahab
    8 views26 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    8 views26 pages

    Data Vault

    Uploaded by

    sumrun sahab

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 26

    DATA VAULT

    INTRODUCTION

    • Data Vault 2.0” is a system of business intelligence that includes modeling,


    methodology, architecture, and implementation best practices. The
    components also known as pillars of Data Vault 2.0 are identified as follows:
    • Data Vault 2.0 modeling—focused on process and data models
    • Data Vault 2.0 methodology—following Scrum ( is broken down into shorter sprints
    and smaller deliverables) and agile (everything is delivered at the end
    of the project) ways of working

    • Data Vault 2.0 architecture—includes NoSQL and big data systems


    • Data Vault 2.0 implementation—pattern-based automation and
    generation
    DATA VAULT ORIGINS AND
    BACKGROUND
    • Data vault was originally designed for use within Lockheed Martin, the US Department of Defense, National
    Security Agency, and NASA. The process started in 1990 and was completed in circa 2000. The entire system is
    composed of 10 years of research and development and over 30,000 test cases. The system is built to
    overcome the following issues:
    • Integrate data from 250 + source systems from ADABAS (adaptable database system), to PeopleSoft, to Windchill, to
    Oracle Financials, to mainframes and midranges, to SAP
    • Provide an auditable and accountable data store and process engine
    • Ingestion and query parsing of tagged image drawings (unstructured data)
    • Rocket data fed in real time from the NASA launch pads
    • Multilayered security—including classified data sets
    • Subsecond query response times over 15 terabytes of live data
    • Four hour turnaround from requirement to “hands-on” data in development for the report writers
    DATA VAULT MODEL DEFINED

    • A DVM is a detail-
    oriented, historical
    tracking and uniquely
    linked set of normalized
    tables that support one
    or more functional areas
    of business. In DV2, the
    model entities are keyed
    by hashes.
    HUB
    HUBS

    In business terms, the hubs represent the actual business keys or master key sets that
    exist across the enterprise in a horizontal fashion.
    HUBS

    • Business keys are the drivers in


    business. They tie the data set to the
    business processes and the business
    processes to the business
    requirements. Without business keys,
    the data set has no value. Business
    keys are the sole source of tracking
    the data through the business
    processes and across lines of
    business.

    You might also like