Upside Down Data Modeling - Next Level Integration
Modeling in data integration has undergone significant changes, often unnoticed. The evolution of data integrity, database transformations, and the nuances of information accuracy are explored in this thought-provoking content. Discover the impact of change in databases, the eternal precision of values, and the complex dynamics of data classification. Gain insights into the key principles governing data management and the significance of accurate data representation. Dive deep into the world of data modeling and unlock the secrets of database evolution.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Modeling has become Upside Down and we haven t even noticed... lr@u2c.se Understanding the Next Level of Data Integration linkedin.com/in/ronnback #transitional @anchormodeling www.anchormodeling.com
If you look at a row in a database at two different times, it has rarely changed. In the rare case that is has changed, whatever was before the change is lost forever.
If you can figure out that something has changed in the database, it could either be that the new stuff supersedes the old or the old stuff was plain wrong all along... ...or both.
Information in a database is absolutely and universally true*. * or maybe erroneous, but true until proven otherwise, and gone soon thereafter.
Values are always infinitely precise. Your blue is my blue and the server clock is both fit for all purposes and the one all other clocks tick in harmony with.
There are no differences of opinion. Whenever someone is wrong, the ETL will make it right, then and there.
There is a master key, forever used to unlock the insight about whether you ve seen something before or if it is a new thing.
A thing belongs to one class, and one class only, eternally. Which class precisely was determined in a sitting of one or more masters of classification, usually a long time ago.
Because it is fun ...and satisfying ...and useful ...and what we are used to ...and have the tools for ...and sunk costs into ...and taught by important people ...and rarely questioned!
