In continuing our ongoing series, this piece within the blog series will describe the basics of querying and modifying data in MongoDB with a focus on the basics needed for…
Read More
A common requirement for enterprise data warehousing is to provide an analytical model for information delivery, for example in a dashboard or reporting solution. One challenge in this scenario is…
Read More
Data Lake Structure The organization of data within a data lake can significantly impact downstream accessibility. While offloading data into the data lake is a straightforward process, the real challenge…
Read More
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 More
To 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 More
REQUIREMENTS 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 More
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 standardization, these conventions are mandatory…
Read More
Data 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 More
Naming 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 More
Within 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 More
Back 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 More