Explore the strategic importance of evolving data relationships and their impact on data-driven insights in our latest blog post. Learn how shifts in business rules require significant re-engineering, affecting data management and decision-making. Essential reading for executives and business analysts, this discussion highlights the need for adaptable data practices to maintain competitive advantage in a dynamic business environment.
Embracing Many-to-Many Relationships in Data Modeling: A Technical Guide PREFACE: there is another false belief out there: Many-to-many (links, pits, bridges) are bad and lead to join hell, and should never be used. WRONG…. want to know why? read on. Note: anyone who claims “LINKS ARE BAD” or “MANY-TO-MANY should never be used” needs to…
Discover the transformative power of mastering conceptual models. Elevate your business strategy and seamlessly integrate IT solutions with our cutting-edge insights on extended ontologies.
With the advent of OpenAI and ChatGPT, it is easier than ever for bad actors to add Poison Data to the public collective. Why should you care?
For those who are familiar with ‘Data Vault’ and are curious about ‘Data Mesh’, you may be asking yourself if any synergy exists between the two. I’m happy to say that there is beautiful symmetry between the two. Data Vault is a proven methodology for building an analytic solution end-to-end from the businesses’ perspective; in…
In Episode 2 of Unlocking the Data Vault, I mentioned the term: Poison Data. I must admit, it’s a cool term, and I also admit the term is not mine. It stems from espionage in an attempt to poison data that feeds AI / ML and deep learning algorithms. It distorts documents, imagery, video, and…
By Dan Linstedt Where Did The Agile Methodology Come From? Agile methodology and the word “agile” is thrown around boardrooms and scope documents like confetti at a child’s birthday party. Perhaps there is no adjective (or is it a proper noun?) thrown around more actively among data engineers and their managers than the term agile….
While the craze of AI has been dominating several minds these days, there are two sides to reality that the majority of folks aren’t prepared for or don’t know the answer to. The first of course is that it’s not there yet. And, the second is that it’s getting there at an unprecedented pace. Nevertheless,…
From the Desk of Dan: Understanding MetaOps MetaOps is a critical aspect of data management and analytics, especially in large organizations with complex data ecosystems. It helps organizations to better understand their data assets, reduce the risk of data breaches or errors, and improve the efficiency and effectiveness of data-related processes. MetaOps professionals are responsible…
A stored procedure to build and populate KEY_COLUMN_USAGE on Snowflake DB – because the database is currently missing this structure / view within the INFORMATION_SCHEMA.