[hemmerling] Data Processing 6/7 - Data Warehouse Modeling

Modern Data Modeling Methologies of 2018

  1. Anchor
  2. Data Vault.
  3. Focal Point.
  4. Hyper Agility.

Education

Genesee Academy, LLC

    • “Our mission is to provide world class training and certification for data warehousing, data vault, ensemble modeling, data integration and business intelligence professionals”.
    • Hans Hultgren is one of the lecturers :-).

Experts

Hans Hultgren

Bill Inmon

Dan Linstedt & Michael Olschimke - Data Vault Modeling 2.0

Dan Linstedt - Data Vault Modeling

Michael Olschimke

Visual Data Vault, a Graphical Modeling Language

  • “In collaboration with Dan Linstedt, we have developed a visual modeling language that facilitates to represent a Data Vault model graphically: Visual Data Vault. It’s a logical modeling language with which you can model hubs, links, satellites, and other Data Vault entities. All icons are standardized and easy to learn. A simple model can be depicted with a few symbols”.
  • “To make this notation easily available to members of any Data Vault project team, we have developed a 2010+ stencil for Microsoft Visio. This can be requested via the form on this page. It can be used in projects free of charge”.

Literature

Hans Michiels

Len Silverston

Cathrine Wilhelmsen

Commercial Data Warehouse Automation Tools, ( also ) for use with Data Vault, with free ( limited ) Editions

Javlin a.s. "CloverETL Rapid Data Integration"

Varigence

BimlStudio, BimlExpress

BimlScript

BI Developer Extensions ( formerly: BIDS Helper )

  • The OpenSource framework for SQL server CodePlex "BIDS Helper" - “A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI)”.
  • The legacy OpenSource framework for SQL server CodePlex "Vulcan" - “Vulcan is a Business Intelligence Framework built on top of Sql Server Integration Services and Sql Server Analysis Services for quickly creating BI solutions”.
  • GitHub.io "BI Developer Extensions", GitHub "BI Developer Extensions" - “A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI)”.
    • “BI Developer Extensions (formerly BIDS Helper) is an extension for BIDS / SSDT that includes numerous enhancements for SQL Server BI projects”.
    • “A Visual Studio add-in that enhances development functionality in SQL Server Data Tools (SSDT)”.

BimlFlex

    • “A flexible, extensible, and completely customizable data warehouse framework”.
    • “BimlFlex is a collection of templates, metadata definitions, and tooling that enables you to build

an end-to-end data solution without ever writing a single line of code”.

Resources

OpenSource Data Warehouse Automation Tools, for use with Data Vault

BI Builder

Optimal Data Engine ( ODE )

Qosqo "Quipu Software"

Commercial

OpenSource

  • “Quipu is an open source data warehouse generation system that creates and monitors data warehouses. With Quipu you can implement a data warehouse much quicker and easier”.
  • “In 2015, the software company Qosqo who supported the development of Quipu decided to abandon the open source project as it was. The latest open source release (version 2.x) is what you'll find here”.

Topics and Projects with the Name "Quipu", not related to the Data Warehouse Automation

Quipu Resources

Rapid Architectural Consolidation Enablement ( RapidACE )

The Tool

Resources

Resources

Commercial Data Warehouse Automation Tools, ( also ) for use with Data Vault

Ajilius

AnalytiX DS

Attunity Compose Data Warehouse Automation ( formerly: BiReady )

BI Builders "Xpert BI"

  • BI Builders "Xpert BI" - “Xpert BI is a Microsoft SQL server based tool that is designed to automate and improve all aspects of data warehousing and Business Intelligence – especially in the areas of extraction- and transformation processes, also known as ELT”.
  • Experts told me “Methodology: Dimensional”.

Birst

Centennium

Datavault Builder

    • “Data Warehousing. Simply Visual”.
    • “Next Generation Software for Visual Data Integration”.
  • Experts told me “Methodology: Data Vault”.

Dimodelo Solutions Pty "Dimodelo Architect"

Gamma Systems, Inc. "Data Warehouse Studio"

Halo Business Intelligence ( Halo BI )

Insource Ltd. "Enterprise Data Management Platform Data Academy"

LeapFrogBI Platform

  • LeapFrogBI - “The LeapFrogBI Platform. Hyper-fast SQL Server ETL development”.
  • Experts told me “Methodology: Dimensional”.

Magnitude Software, Inc. "Magnitude Master Data Management 10" ( MDM 10, formerly: Kalido MDM )

OceanBI "DDM Studio"

TimeXtender

  • TimeXtender – “Enabling instant access to data through Discovery Hub”.
  • Experts told me “Methodology: Dimensional”.

Trivadis "biGenius"

WhereScape

    • WhereScape "WhereScape RED" - “Deliver data infrastructure more quickly with less hassle. Automate to develop, deploy, and operate data infrastructure and big data integration projects the fast, easy way”.
    • WhereScape "WhereScape Data Vault Express" - “Automate the entire Data Vault life cycle for faster time to production, lower cost, and greater success”.
  • I joined the free 3-hours hand-on workshop “WhereScape RED Test Drive” at the conference TDWI Konferenz 2018 ( 2018-06-25 - 2018-06-27 ) in München, Germany.
  • Experts told me “Methodology: Dimensional, Data Vault(?)”.

Resources

Literature

Resources

Data Vault

General Data Warehouse Modeling

 
en/datawarehouse.html.txt · Last modified: 2018/12/11 23:50 (external edit) · []
Recent changes RSS feed Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki