We’re excited to connect you with one of our experts! Please fill out this form with your contact information and a brief overview of the topics you’d like to discuss during your free consultation. This will ensure we match you with the best expert to address your specific needs.
Enterprise Data Warehouses with Data Vault 2.0 While Enterprise Data Warehouses (EDWs) are traditionally used for reporting and dashboarding, with Data Vault, their true potential lies far beyond these basic…
Read MoreREQUIREMENTS FOR HASHING Traditional data warehouses often use sequence numbers to identify records in other tables. By using sequences, this method comes with some drawbacks. One of the biggest drawbacks…
Read MoreNaming Conventions in Data Warehousing An initial decision of critical importance within Data Vault development relates to the definition of naming conventions for database objects. As part of the development…
Read MoreData Security Concepts The focal point of our discussion revolves around critical aspects such as security controls, access controls, and the definition of identities. The primary objective of this solution…
Read MoreNaming Conventions Data Vault modeling is a powerful approach that introduces a multitude of entities to the database. To enhance usability and facilitate effective development, it is highly advisable to…
Read MoreWhat Are Bridge Tables? Bridge tables are special entities within the Data Vault that leverage query performance on the way out of the Data Vault. These entities are placed between…
Read MoreAlternative to the Driving Key There is a special case when a part of the hub references stored in a link can change without describing a different relation. This has…
Read MoreData Tests Testing is very important for data warehouse systems to make them work correctly and efficiently. In unit testing, each component is separately tested. By testing business logic using…
Read MoreInsert Only in Data Vault 2.0 Skilled modeling is important to harness the full potential of Data Vault 2.0. To get the most out of the system due to scalability…
Read MorePoint in Time Tables Point in time tables are useful when querying data from the Raw Vault that has multiple satellites on a hub or a link: About Point In…
Read MoreThe latest story to find itself added to the growing number of successful implementations of Scalefree’s services, and Data Vault 2.0 as a whole, centers around a sector known for…
Read MoreFocus on trends: Data Lake and no-sql, dwh architecture, self-service bi, modeling and gdpr In the past, we wrote about topics we were confronted with when we consult our clients…
Read More