A201_Cutshall.pdf

1、https:/An Enterprise Data Architecture FrameworkAaron N.Cutshall,DHA,MSHIAaron N.Cutshall,DHA,MSHIJust who is this guy?Just who is this guy?Principal Data Architect,Population HealthB.S.ComputerScienceM.S.ComputerInformationSystemsM.S.HealthInformatics40YearsSpeaker various eventsDoctor of Healthcar

2、e AdministrationCopyright 2026,SQLRV LLC-All Rights ReservedAmbassador ProgramsAdjunct InstructorSomething to considerSomething to consider“The difference between good and bad architecture is the time you spend on it.”Sir David Chipperfield,Celebrated British ArchitectcreditCopyright 2026,SQLRV LLC-

3、All Rights ReservedIntroductionIntroductionData architectural challenges Maintain consistency Data from disparate sources Confusion on termsCopyright 2026,SQLRV LLC-All Rights ReservedEnterprise Level Framework Ingest data from many sources Homogenize for consistency Be the single source of truthOpe

4、rational Data Store Data Zones Data Migration Data Standards Data KeysSome Enterprise Data ChallengesSome Enterprise Data Challenges Multiple data sources Various databases RDBMS sources(SQL Server,Postgres,Oracle,etc.)Vendor-specific structures may not meld Potentially limited access to data Flat f

5、iles from outside sources Governmental agencies(state and federal)Trading partners or third-party agencies Data captured from APIs Usually from closed or protected systems Not always conformant to specifications or completeCopyright 2026,SQLRV LLC-All Rights ReservedSome Enterprise Data ChallengesSo

6、me Enterprise Data Challenges Different data grains Concept easy to understand but difficult to explain Levels at which data is unique Defines the relationship with other data Example Cars:Make Unique to a manufacturer(ex.Jeep)Model Unique within a manufacturer(ex.Gladiator)Trim Variations of a mode