Semantic Data Modeling Example and ROI

1. Semantic Data ModelingExample and ROI Pierre Bonnet MDM Alliance Group pierre.bonnet@orchestranetworks.com September 2011 Publication free of use under Creative Commons www.mdmalliancegroup.com

2. Semantic modeling (part 01 – static) f2 a f1 g e h b c d a : many to many association b : association holding a qualifier attribute c : constraint over associations d : associative class with reflexive association e : adaptative data cardinality depending on country f1,f2 : inheritance of values g : business state management h : business operations from state machine

3. Semantic modeling (part 02 - dynamic) Depending on business sate values of the Product MDM’s operations (update, delete) cannot handle all data: these are key business integrity constraints to enforce with care g h Product’s business State machine

4. 5 Rich Logical data modeling - Semantic & SQL - 1a 4 2b 2a 1c 3 1b 1a, 1b, 1c : multivaluated FK attribute 2a, 2b : inheritance of values 3 : embedded business rules (data constraint) 4 : embedded adaptative data cardinality 5 : embedded business states management

5. inherited attribute inherited attribute inherited attribute subset subset state state state state join table adaptative cardinality join table adaptative cardinality join table join table join table Poor Logical data modeling - Only SQL - What happens when semantic modeling is not used! No automation to implement business states integrity rules Must be hard-coded

6. Rich Logical data modeling - Semantic & SQL - Data Integrity Poor Logical data modeling - Only SQL - x 4 x 8 Data Integrity

7. The semantic modeling is the key way to synchronize heteregeneous systems and to plan a progressive journey to streamline IS architecture Caveat: semantic modeling is not just data modeling As it represents a sustainable investment it MUST BE JUSTIFIED through clear ROI indicators How to activate ROI fromthe semantic modeling?

8. If semantic modeling remains just data models then ROI cannot be enforced When it is put within a MDM system it provides business users and IT specialists with key benefits Orchestra Networks’ lesson learnt from many IS streamlining programs The eight ROI indicators described below How to activate ROI fromthe semantic modeling?

9. ROI #1 If the MDM system holds a model-driven management tool it allows for automatically generating UI from semantic data models, it means Data Oriented UI IS business stakeholders are really involved in validating data models Governance => BUSINESS USER = DATA OWNER! Key benefits from semantic modeling associated with MDM

10. ROI #2 The MDM is used as the Data Dictionary: terms, definition, taxonomy, synomym unified view on top your existing systems Eg. different UI labels depending on systems Key benefits from semantic modeling associated with MDM

11. ROI #3 The MDM is used as the Semantic Broker. It consolidates all identifiers of business objects and their relationships (Foreing keys), and their identity to allow for cross data quering streamline the way of implementing unified queries relying on several databases better way to provide business users with efficient query mechanisms Key benefits from semantic modeling associated with MDM

12. ROI #4 As the Semantic Broker holds all referential integrity constraints between objects it can be used to enforce IS integrity either at the level of every system and/or at a unified IS level. It also can control business states evolving attached to every key business objects when a system update relationship between business objects it informs the Semantic Broker which control the integrity this mechanism allows for garanteeing a high-level quality of data required in any SOA approach Key benefits from semantic modeling associated with MDM

13. ROI #5 As the Semantic Broker holds all referential integrity constraints between objects it can be used to enforce IS integrity at the level of data flows within ESB rather than use an approach of hard-coding to implement data flow controls, the MDM system is used to automatically check integrity constraints hold at the level of relationships between objets this mechanism allows for garanteeing a high-level quality of data flow required in any SOA approach Key benefits from semantic modeling associated with MDM

14. ROI #6 Certain type of Business Rules must be provisionned within the MDM system directly rather than through a BRMS system atomic control above data that are handled directly within data models (facet XML) data oriented rules that are defined as transcodication decision tables Key benefits from semantic modeling associated with MDM

15. ROI #7 As soon as the MDM system holds master data beyond business objects’ identifiers (PK, FK, business states) it must be used as the master/reference data provider of the BRMS and the BPM the additional-cost of adding a new business rule is dramatically reduced as reference/master data are retrieved from the MDM system directly in the right context and version BPM are parameterized by benefiting from the data governance brings by the MDM system. It enforces the concept of Adaptive Configuration Management (ACM) Key benefits from semantic modeling associated with MDM

16. ROI #8 The MDM system is enriched in a progressive way with different natures of master data to provide business users and IT specialists with master data governance features version managament, data approval workflow, rigth management, auditability, traceability, etc. Key benefits from semantic modeling associated with MDM

17. End Pierre Bonnet MDM Alliance Group pierre.bonnet@orchestranetworks.com September 2011 Publication free of use under Creative Commons