To all those that have been a part of the Scalefree journey up until this point, We’d first and foremost like to thank you for all the contributions you have…
Read MoreTo put it simply, an Enterprise Data Warehouse (EDW) collects data from your company’s internal as well as external data sources, to be used for simple reporting and dashboarding purposes.…
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 MoreAn initial decision of critical importance within Data Vault development relates to the definition of naming conventions for database objects. As part of the development standardization, these conventions are mandatory…
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 MoreWithin Data Vault there are special entities which leverage the query performance on the way out of the Data Vault. These entities are placed between the Data Vault and the…
Read MoreBack in 2017 we introduced the link structure with an example of a Data Vault model in the banking industry. We showed how the model looks like when a link…
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 MoreSkilled modeling is important to harness the full potential of Data Vault 2.0. To get the most out of the system due to scalability and performance, it also has to…
Read MoreA problem that occurs when querying the data out of the Raw Data Vault happens when there are multiple satellites on a hub or a link:In the above example, there…
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 More