DE
/
EN
Data Vault header image

Data Vault Modeling Approach

Benefit from Data Vault as a modeling technique for Data Warehouses that provides fast data understanding, more flexibility, historization and parallel data loading processes.Contact us now

Challenges of classic Data Warehouses

In the Data Warehouse environment, there are two well-known modeling approaches according to Kimball and Inmon that have been used for countless years when it comes to storing data. However, these have to face more and more growing challenges:

New requirements

Requirements for technologies, concepts and best practices in the work environment have constantly evolved.

Larger amounts of data

Often, larger data volumes and the flexibility required of today's systems pose major problems for these approaches.

Growing IT costs

One of the main advantages of this modeling approach is its flexibility to changes, which of course also has an impact on costs.

It is therefore questionable whether these approaches are still appropriate for all the modern issues and requirements of today. This consideration gave rise to the Data Vault modeling approach.

What is Data Vault?

Data Vault is a modeling technique that is particularly suitable for agile Data Warehouses. It offers a high flexibility for extensions, a complete historization of the data and allows a parallelization of the data loading processes.

This hybrid approach combines all the advantages of the third normal form with the star schema. Especially in today's world, companies need to transform their businesses in ever shorter cycles and map these transformations in the Data Warehouse. Data Vault supports exactly these requirements without significantly increasing the complexity of the Data Warehouse over time. Unlike Kimball and Inmon, this eliminates the ever-increasing IT costs associated with extensive implementation and testing cycles and a long list of potential dependencies.

Request a non-binding exchange

Procedure for Data Vault

The Data Integration Architecture of the Data Vault approach has robust standards and definition methods that bring information together to use them in a way that makes sense. The model consists of three basic table types:

Diagram illustrating the data integration architecture of the Data Vault approach.

      Advantages of Data Vault

      Due to the structure and the defined standards, there are many advantages for the Data Vault approach:

      • Massive reduction in development time when implementing business requirements
      • Earlier return on investment (ROI)
      • Scalable Data Warehouse
      • Traceability of all data back to the source system
      • Near-real-time loading (in addition to classic batch run)
      • Big Data Processing (>Terabytes)
      • Iterative, agile development cycles with incremental expansion of the DWH
      • Few, automatable ETL patterns

      Contact us now!

      We would be happy to advise you in a non-binding meeting and show you the potential and possibilities of Data Vault. Just leave your contact details and we will get back to you as soon as possible.

      * required

      We use the information you send to us only to contact you in context of your request. For this purpose, we store your data in our CRM for up to 6 months. You can find all further information in our Privacy Policy.

      TIMETOACT
      Service
      Header Konnzeption individueller Business Intelligence Lösungen
      Service

      Conception of individual Analytics and Big Data solutions

      We determine the best approach to develop an individual solution from the professional, role-specific requirements – suitable for the respective situation!

      TIMETOACT
      Service
      Navigationsbild zu Business Intelligence
      Service

      Business Intelligence

      Business Intelligence (BI) is a technology-driven process for analyzing data and presenting usable information. On this basis, sound decisions can be made.

      TIMETOACT
      Service
      Headerbild zu Data Governance Consulting
      Service

      Data Governance

      Data Governance describes all processes that aim to ensure the traceability, quality and protection of data. The need for documentation and traceability increases exponentially as more and more data from different sources is used for decision-making and as a result of the technical possibilities of integration in Data Warehouses or Data Lakes.

      TIMETOACT
      Service
      Teaserbild zu Data Integration Service und Consulting
      Service

      Data Integration, ETL and Data Virtualization

      While the term "ETL" (Extract - Transform - Load / or ELT) usually described the classic batch-driven process, today the term "Data Integration" extends to all methods of integration: whether batch, real-time, inside or outside a database, or between any systems.

      TIMETOACT
      Service
      Headerbild zu Big Data, Data Lake und Data Warehouse
      Service

      Big Data, Data Lake & Data Warehousing

      For the optimal solution – with special consideration of the business requirements – we combine different functionalities.

      TIMETOACT
      Service
      Headerbild zu Dashboards und Reports
      Service

      Dashboards & Reports

      The discipline of Business Intelligence provides the necessary means for accessing data. In addition, various methods have developed that help to transport information to the end user through various technologies.

      TIMETOACT
      Technologie
      Headerbild IBM Cloud Pak for Data
      Technologie

      IBM Cloud Pak for Data

      The Cloud Pak for Data acts as a central, modular platform for analytical use cases. It integrates functions for the physical and virtual integration of data into a central data pool - a data lake or a data warehouse, a comprehensive data catalogue and numerous possibilities for (AI) analysis up to the operational use of the same.

      TIMETOACT
      Technologie
      Headerbild zu IBM Netezza Performance Server
      Technologie

      IBM Netezza Performance Server

      IBM offers Database technology for specific purposes in the form of appliance solutions. In the Data Warehouse environment, the Netezza technology, later marketed under the name "IBM PureData for Analytics", is particularly well known.

      TIMETOACT
      Technologie
      Headerbild zu IBM DB2
      Technologie

      IBM Db2

      The IBM Db2database has been established on the market for many years as the leading data warehouse database in addition to its classic use in operations.

      TIMETOACT
      Technologie
      Headerbild zu IBM Cloud Pak for Automation
      Technologie

      IBM Cloud Pak for Automation

      The IBM Cloud Pak for Automation helps you automate manual steps on a uniform platform with standardised interfaces. With the Cloud Pak for Business Automation, the entire life cycle of a document or process can be mapped in the company.

      TIMETOACT
      Technologie
      Haderbild zu IBM Cloud Pak for Application
      Technologie

      IBM Cloud Pak for Application

      The IBM Cloud Pak for Application provides a solid foundation for developing, deploying and modernising cloud-native applications. Since agile working is essential for a faster release cycle, ready-made DevOps processes are used, among other things.

      TIMETOACT
      Referenz
      Referenz

      Standardized data management creates basis for reporting

      TIMETOACT implements a higher-level data model in a data warehouse for TRUMPF Photonic Components and provides the necessary data integration connection with Talend. With this standardized data management, TRUMPF will receive reports based on reliable data in the future and can also transfer the model to other departments.

      TIMETOACT
      Service
      Headerbild zu Operationalisierung von Data Science (MLOps)
      Service

      Operationalization of Data Science (MLOps)

      Data and Artificial Intelligence (AI) can support almost any business process based on facts. Many companies are in the phase of professional assessment of the algorithms and technical testing of the respective technologies.

      TIMETOACT
      Technologie
      Headerbild zu IBM Planning Analytics mit Watson
      Technologie

      IBM Planning Analytics mit Watson

      IBM Planning Analytics with Watsons enables the automation of planning, budgeting, forecasting and analysis processes using IBM TM1.

      TIMETOACT
      Technologie
      Headerbild zu IBM Cognos Analytics 11
      Technologie

      IBM Cognos Analytics 11

      IBM Cognos Analytics is a central platform for the provision of dispositive information in the company. With the reporting and analysis functions of IBM Cognos, the relevant information can be prepared and used throughout the company.

      TIMETOACT
      Service
      Headerbild zu Application Modernization
      Service

      Application Modernization

      Application Modernization focuses on modernizing existing applications. The key to success in Application Modernization is the strategy and selection of projects.

      TIMETOACT
      Service
      Navigationsbilc zu Application Development
      Service

      Application Development

      Application Development refers to the process of modifying, designing and/or developing one or more applications. Gaps in the software landscape can be closed by tailoring applications individually to the customer.

      TIMETOACT
      Service
      Navigationsbild zu Data Science
      Service

      Data Science, Artificial Intelligence and Machine Learning

      For some time, Data Science has been considered the supreme discipline in the recognition of valuable information in large amounts of data. It promises to extract hidden, valuable information from data of any structure.

      TIMETOACT
      Service
      Enterprise Architecture Management Consulting Header
      Service

      Enterprise Architecture – Synchronising Business and IT

      With pragmatic approaches and based on industry standards (TOGAF), we support clients in the introduction of an effective EAM.

      TIMETOACT
      Referenz
      Referenz

      Talend migration in record time

      TIMETOACT migrated the Talend Data Integration Suite, including all workflows and processes, to the internal system environment of the municipal utility (with a subscription license) within a very short period of time and will continue to provide support as a support partner in the future if required.

      TIMETOACT
      Service
      Headerbild zu Digitale Planung, Forecasting und Optimierung
      Service

      Demand Planning, Forecasting and Optimization

      After the data has been prepared and visualized via dashboards and reports, the task is now to use the data obtained accordingly. Digital planning, forecasting and optimization describes all the capabilities of an IT-supported solution in the company to support users in digital analysis and planning.

      TIMETOACT
      Technologie
      Headerbild für IBM SPSS
      Technologie

      IBM SPSS Modeler

      IBM SPSS Modeler is a tool that can be used to model and execute tasks, for example in the field of Data Science and Data Mining, via a graphical user interface.

      TIMETOACT
      Technologie
      Headerbild zu IBM Watson Studio
      Technologie

      IBM Watson Studio

      IBM Watson Studio is an integrated solution for implementing a data science landscape. It helps companies to structure and simplify the process from exploratory analysis to the implementation and operationalisation of the analysis processes.

      TIMETOACT
      Technologie
      Headerbild Talend Data Integration
      Technologie

      Talend Data Integration

      Talend Data Integration offers a highly scalable architecture for almost any application and any data source - with well over 900 connectors from cloud solutions like Salesforce to classic on-premises systems.

      TIMETOACT
      Technologie
      Headerbild zu Talend Real-Time Big Data Platform
      Technologie

      Talend Real-Time Big Data Platform

      Talend Big Data Platform simplifies complex integrations so you can successfully use Big Data with Apache Spark, Databricks, AWS, IBM Watson, Microsoft Azure, Snowflake, Google Cloud Platform and NoSQL.

      TIMETOACT
      Technologie
      Headerbild zu Talend Data Fabric
      Technologie

      Talend Data Fabric

      The ultimate solution for your data needs – Talend Data Fabric includes everything your (Data Integration) heart desires and serves all integration needs relating to applications, systems and data.

      TIMETOACT
      Technologie
      Headerbild IBM Cloud Pak for Data System
      Technologie

      IBM Cloud Pak for Data System

      With the Cloud Pak for Data System (CP4DS), IBM provides the optimal hardware for the use of all Cloud Pak for Data functions industry-wide and thus continues the series of ready-configured systems ("Appliance" or "Hyperconverged System").

      TIMETOACT
      Technologie
      Headerbild zu IBM DataStage
      Technologie

      IBM InfoSphere Information Server

      IBM Information Server is a central platform for enterprise-wide information integration. With IBM Information Server, business information can be extracted, consolidated and merged from a wide variety of sources.

      TIMETOACT
      Technologie
      Headerbild Talend Application Integration
      Technologie

      Talend Application Integration / ESB

      With Talend Application Integration, you create a service-oriented architecture and connect, broker & manage your services and APIs in real time.

      TIMETOACT
      Technologie
      Headerbild zu IBM Watson® Knowledge Catalog
      Technologie

      IBM Watson® Knowledge Catalog/Information Governance Catalog

      Today, "IGC" is a proprietary enterprise cataloging and metadata management solution that is the foundation of all an organization's efforts to comply with rules and regulations or document analytical assets.

      TIMETOACT
      Referenz
      Referenz

      vdek introduces new Data Warehouse solution

      The TIMETOACT GROUP supports the Verband der Ersatzkassen e. V. in the switch from a system environment to the latest IBM technology.

      TIMETOACT
      Technologie
      Technologie

      Microsoft Azure Synapse Analytics

      With Synapse, Microsoft has provided a platform for all aspects of analytics in the Azure Cloud. Within the platform, Synapse includes services for data integration, data storage of any size and big data analytics. Together with existing architecture templates, a solution for every analytical use case is created in a short time.

      TIMETOACT
      Service
      IT Demand Management Teaser
      Service

      Demand Management – Clarity on IT needs

      We help to determine your effective IT needs, e.g. for workstations with Microsoft Office 365. Save money by only buying what you really need.

      TIMETOACT
      Service
      Headerbild zu Microsoft FinOps
      Service

      FinOps Microsoft - Microsoft Cloud Cost Optimization

      TIMETOACT offers license management and compliance consulting in the Microsoft area, as well as technical consulting (e.g. on the use of Azure Services).

      TIMETOACT
      Technologie
      Logo Jira Service Management
      Technologie

      Jira Service Management from Atlassian

      Enable developers, operators, and other teams from different departments to collaborate and improve their service management responsiveness. Respond quickly to incidents, requests, and changes, and provide your customers with an optimized service experience.

      TIMETOACT
      Service
      Headerbild IT Controlling
      Service

      IT Controlling – Determination and allocation of IT costs

      We help to make IT controlling processes efficient and effective and to introduce suitable procedures for the internal allocation of IT costs.

      TIMETOACT
      Service
      Headerbild IT Asset Management
      Service

      IT Asset Management – Reducing Costs and Risks Sustainably

      We help customers to increase the transparency of IT assets in use, identify potential savings for hardware and software, and avoid compliance risks at the same time.

      TIMETOACT
      Technologie
      Atlassian Logo
      Technologie

      Bamboo, Bitbucket, Sourcetree

      Continuous Integration and a Continuous Delivery Pipeline with Bamboo, Bitbucket and Sourcetree. We can help you with our years of experience as a user as well as a solution partner of Atlassian products in many areas.

      TIMETOACT
      Service
      Headerbild zur FinOps Consulting
      Service

      FinOps Consulting

      We advise you both commercially and technically on how to gain transparency over your cloud costs and how to reduce them sustainably.

      TIMETOACT
      Service
      Headerbild zu FinOps
      Service

      FinOps

      Gain visibility into your cloud costs and sustainably reduce them by applying best practices from FinOps.

      TIMETOACT
      Service
      Header zu Requirement Engineering
      Service

      Requirement Engineering

      Requirement Engineering, also known as Requirements Analysis, is a central component of the Software Development process. In this process, the requirements for the system to be developed are defined using a systematic procedure.

      TIMETOACT
      Technologie
      HCL Digital Xperience
      Technologie

      HCL Digital Xperience

      A portal server is particularly suitable for companies that operate many online services and applications. Several portal pages can be placed and wired together via the "portlet wiring".

      TIMETOACT
      Referenz
      Referenz

      TIMETOACT simplifies reporting in IBM Cognos

      In the course of modernizing the application for Bette GmbH & Co. KG, TIMETOACT individually expanded the filter and selection options in IBM Cognos to include important customer-specific functions. The family-owned company particularly benefits from the search and grouping function.

      TIMETOACT
      Technologie
      Headerbild zu IBM Cloud Pak for Data Accelerator
      Technologie

      IBM Cloud Pak for Data Accelerator

      For a quick start in certain use cases, specifically for certain business areas or industries, IBM offers so-called accelerators based on the "Cloud Pak for Data" solution, which serve as a template for project development and can thus significantly accelerate the implementation of these use cases. The platform itself provides all the necessary functions for all types of analytics projects, and the accelerators provide the respective content.

      TIMETOACT
      Service
      Headerbild zu Agile Softwareentwicklung
      Service

      Agile Software Development

      A project rarely turns out as it was initially planned. Agility does not only apply to Project Management, but also to methods and processes of Software Development in order to avoid risks and undesirable developments during the process.

      TIMETOACT
      Service
      Teaserbild Enterprise Content Management (ECM) Beratung
      Service

      Enterprise Content Management (ECM) & Archiving

      With Enterprise Content Management (ECM), all data, information and documents are stored, archived and managed in a context-related manner on a single platform. ECM systems offer numerous advantages for managing the increasing number of (un)structured electronic documents and data.

      TIMETOACT
      Technologie
      Headerbild zu IBM Decision Optimization
      Technologie

      Decision Optimization

      Mathematical algorithms enable fast and efficient improvement of partially contradictory specifications. As an integral part of the IBM Data Science platform "Cloud Pak for Data" or "IBM Watson Studio", decision optimisation has been decisively expanded and embedded in the Data Science process.

      TIMETOACT
      Technologie
      Headerbild zu Incident Kommunikation Management
      Technologie

      Incident communication management

      Statuspage allows you to keep track of the status of individual system-relevant components as well as a history of past incidents. Our self-created solution also allows you to connect various monitoring tools and query them in specific cycles. The component failure automatically generates an e-mail to your ticket system.

      TIMETOACT
      Service
      Service

      Enterprise Content Management (ECM) & Archiving

      With Enterprise Content Management (ECM), all data, information and documents are stored, archived and managed in a context-related manner on a single platform. ECM systems offer numerous advantages for managing the increasing number of (un)structured electronic documents and data.

      TIMETOACT
      Service
      Headerbild zu Datenbank Consulting
      Service

      Database technologies

      Flexible, secure and fast database systems form the stable basis of your daily work. We manage your databases optimally.

      TIMETOACT
      Referenz
      Referenz

      Interactive online portal identifies suitable employees

      TIMETOACT digitizes several test procedures for KI.TEST to determine professional intelligence and personality.

      TIMETOACT
      Service
      Teaserbild zu IT-Strategie Beratung
      Service

      IT strategy – A clear goal and the way to achieve it

      The IT strategy provides you with the plan for the long-term development of your IT organisation, necessary technologies, processes and digital culture.

      TIMETOACT
      Service
      Teaserbild IT Service Management Beratung
      Service

      IT Service Management – Optimal support for IT processes

      IT should be customer and service oriented. We help you implement effective and efficient IT service management

      TIMETOACT
      Service
      Headerbild IT Security
      Service

      IT security – protection against cyber attacks

      IT security is becoming more and more important. We help organizations to implement appropriate and effective security structures, processes and controls.

      TIMETOACT
      Referenz
      Referenz

      TIMETOACT implements integrated insurance software

      Less than one year from project start to system implementation: TIMETOACT developed the integrated, browser-based insurance software "HERMES" for the VOV D&O insurance association. The cross-departmental individual software completely covers all core processes of the insurance company. Users particularly appreciate the intuitive user interface and the high performance of HERMES.

      TIMETOACT
      Service
      Headerbild zu Cloud Migration
      Service

      Cloud Migration | Atlassian

      The TIMETOACT team has been able to develop best practices as a result of a large number of migrations in recent years. These form the foundation of our standards, templates, scripts, and checklists and help you to move securely into the Cloud.

      TIMETOACT
      Service
      Headerbild zu Projektmanagement standardisieren und optimieren
      Service

      Standardize and optimize project management | Atlassian

      With defined standard templates, you can easily optimize your project management and use BigPicture to keep track of the status of your project, dependencies between tasks, and the planning and workload of your team.

      TIMETOACT
      Service
      Headerbild zu Anwendungsmöglichkeiten von Atlassian
      Service

      Anwendungsmöglichkeiten

      Learn how you can integrate Atlassian products into your daily business to make your processes more efficient.

      TIMETOACT
      Service
      Headerbild von Enterprise Service Management
      Service

      Enterprise Service Management

      Our Enterprise Service Management Solution offers you a way to make Service Management accessible to all participants via an easy-to-use service portal. You can map your processes in this portal according to defined procedures and connect them to other systems. In addition, you relieve the process participants through automation.

      TIMETOACT
      Technologie
      Headerbild zu Microsoft Azure
      Technologie

      Microsoft Azure

      Azure is the cloud offering from Microsoft. Numerous services are provided in Azure, not only for analytical requirements. Particularly worth mentioning from an analytical perspective are services for data storage (relational, NoSQL and in-memory / with Microsoft or OpenSource technology), Azure Data Factory for data integration, numerous services including AI and, of course, services for BI, such as Power BI or Analysis Services.

      TIMETOACT
      Technologie
      HCL Connections Engagement Center
      Technologie

      HCL Connections

      HCL Connections is a leading social networking platform that lets you get your work done quickly and easily.

      TIMETOACT
      Referenz
      Referenz

      Introduction of Jira to Hamburger Hochbahn

      The Hamburger Hochbahn AG controls the development of its new mobility platform "Switchh" via the Atlassian project management tool Jira – introduced, administered and hosted by the TIMETOACT GROUP.

      TIMETOACT
      Service
      IT Vendor Management Teaserbild
      Service

      IT Sourcing & Vendor Management – Managing IT Partners

      We ensure the application of best practice methods for the selection and evaluation of IT vendors and service providers and for cost-optimized supplier management.

      TIMETOACT
      Referenz
      Referenz

      Mix of IASP & ILMT support for optimal license management

      To minimize financial risk and personnel time, UTA resorts to proactive management of the license inventory (IASP) by TIMETOACT. In this way, not only will IBM license audits be avoided in the future, but TIMETOACT will also ensure compliance-compliant use of the ILMT as part of license management.

      TIMETOACT
      Produkt
      Produkt

      Atlassian Crucible

      Atlassian Crucible offers the opportunity to benefit from digital code reviews. Reviews, discussions and comments are possible independently of location and time.

      TIMETOACT
      Produkt
      Produkt

      Atlassian Fisheye

      Atlassian Fischeye ensures that all changes to the source code are easily traceable. Fisheye is especially helpful for source codes with a lot of important information

      TIMETOACT
      Produkt
      Logo von Atlassian Crowd.
      Produkt

      Atlassian Crowd

      Authentication authorizations and user management in one place thanks to Single Sign-On (SSO) and centralized login procedure.

      TIMETOACT
      Technologie
      Headerbild zu Cloud Pak for Data – Test-Drive
      Technologie

      IBM Cloud Pak for Data – Test-Drive

      By making our comprehensive demo and customer data platform available, we want to offer these customers a way to get a very quick and pragmatic impression of the technology with their data.

      TIMETOACT
      Technologie
      Headerbild zu Datenbanken mit Open Source
      Technologie

      Databases with Open Source

      Every dynamic application needs some form of database to store its data logically and sorted. However, there is no one-size-fits-all solution, but it should always be looked at the use case to make the appropriate choice.

      TIMETOACT
      Webcast
      Webcast

      Expedition zum Identity Management

      Webcast: "Expedition zum Identity Management"

      Service
      Service

      Application Integration & Process Automation

      Digitizing and improving business processes and responding agilely to change – more and more companies are facing these kind of challenges. This makes it all the more important to take new business opportunities through integrated and optimized processes based on intelligent, digitally networked systems.