Data Vault 2.0 includes an agile methodology and offers best practices and high-quality standards that are perfect for automation. While completed Data Vaults deliver many benefits, designing and developing them by hand requires significant time, effort and money. Data Vault Automation helps data warehousing teams deliver Data Vaults into production faster and with less risk.
Data Vault Automation leverages metadata and templates designed for the best practice use of the Data Vault 2.0 methodology in order to automate a data warehousing team’s work within the Data Vault lifecycle. From design and development to deployment, documentation and operation, data vault automation takes advantage of the patterns within the data vault lifecycle to automatically generate code, tables, objects, documentation and more.
Data Vault Automation additionally serves as a set of guardrails for teams new to Data Vault and data vault modeling ensuring they adopt the Data Vault 2.0 principles appropriately. Data Vault 2.0 automation can greatly accelerate an organization’s ability to implement a data vault architecture and incorporate flexibility, scalability and change within its data infrastructure.
Data Vault 2.0 is a system of business that extends beyond the enterprise data warehouse to offer a data model capable of dealing with cross-platform data persistence, multi-latency and multi-structured data, and massively parallel platforms. The Data Vault 2.0 model, invented by Dan Linstedt, simplifies data integration from multiple sources, makes it easy to evolve or add new data sources without disruption, and increases scalability and consistency in enterprise data infrastructure.
A Data Vault 2.0 model consists of Hubs, Links and Satellites. A Hub is a unique business key, a Link is a relationship or association, and a Satellite is descriptive data. The combination of these categories come together to comprise a Data Vault network or data vault model – connecting an organization’s data and data streams in a flexible, repeatable way. A more in-depth description of Data Vault 2.0 can be found in this WhereScape blog or on www.datavaultalliance.com.
WhereScape Data Vault Express™ automates the entire Data Vault lifecycle, helping you to deliver analytics solutions to the business far more quickly, at a much lower cost, and with better success than do-it-yourself approaches.
– Steve Taylor, Director of Enterprise Architecture, Micron Technology