Have you ever imagined a world where transactional systems were able to focus solely on the tasks they were built to complete? Have you ever…
Define and create a data layer. That was the task my team was handed a few weeks back, with minimal context. The client is a…
Data warehouses and modern cloud architectures go together better than chocolate and peanut butter. The “abilities” (scalability, flexibility, reliability, etc.) of the cloud allows one…
Traditional data warehouses were often created as custom reporting data structures using on-site servers. These on-prem servers need to have a team of DBAs, storage…
Operational Data Stores (ODS) are entity-centric and should only contain data about that specific entity. When designing an ODS, you will use relational database design…