SOA Data Modeling Training

Chapter 1. Getting Started with XML

• Unstructured Text Document
• An Employee Document
• What is XML ?
• Why Study XML?
• Data and Document Structure
• Elements
• First XML
• Another Example of XML
• Well-formed vs. Valid XML Document
• Presentation Style
• Goals of XML
• Usage of XML
• Summary

Chapter 2. XML Syntax

• XML Elements
• Empty and Non-Empty Elements
• XML Naming Rules
• Rules for XML Tags
• Nesting and Hierarchy of XML Elements
• Simple XML
• Sections of an XML Document
• XML Constructs…
• XML Declaration
• Processing Instructions
• Is the XML Declaration a Processing Instruction ?
• XML Elements
• Tag Attributes
• Comment Tags
• CDATA Tags
• Entity References
• Character References
• Namespaces
• Namespace URLS
• Namespaces
• Using XML Namespaces
• Working with Binary Data
• Encoding Binary Data
• Specifying Content Type of Binary Data
• Summary

Chapter 3. Basic XML Schemas

• What is XML Schema ?
• Goals of Schema
• Converting DTDs to Schema
• Recall: Namespaces
• The equivalent schema
• Sample instance document
• Documents Needed
• XML Schema Namespaces
• Link Documents to Schemas
• Inline element declarations
• Schema Data Types
• Schema Type Definitions
• Schema Simple Data Types
• Primitive Data Types
• Simple Types
• Facet – Restrictions on Element Content
• Using the Facet
• More Samples
• Define Simple Element Type
• Element Declaration
• Element Occurrence Indicators
• Complex Type
• Attribute Declaration
• Attribute Declarations
• Occurrence of Attributes
• Value Constraints on Attributes
• Sequence Element
• Element Choices
• Express any order
• Annotations

Chapter 4. XPath Fundamentals

• Xpath
• Tree Structure
• Example
• XPath Examples
• XPath Core Definitions
• Wildcards and Multiple Matches
• Other Node Operators
• Path Operators
• Predicates
• Predicate Relationships and Attributes
• More Predicate Examples
• Predicates Chaining and Indexing
• XPath Expressions
• XPath Numbers
• XPath Strings
• XPath Booleans
• XPath Functions
• String Functions
• Boolean Functions
• Number Functions
• XSLT and XPath
• XPath and Content Based Routing
• Summary

Chapter 5. Introduction to XQuery

• What Is XQuery?
• XQuery Uses
• XQuery Properties
• XPath and XSLT
• XQuery Flow
• XQuery Participants
• Sample XQuery Source
• Simple Example Queries
• FLWOR Queries
• F-WOR Explained
• L Explained
• Wrapping Output
• Converting Output
• Inline Output
• Data Rendering
• Functions
• Joins
• Join Example
• Summary

Chapter 6. Introduction to XSL

• Formatting XML Documents
• XSL
• Three Parts of XSL
• XSLT – XSL Transformation
• <xsl:stylesheet>
• <?xml-stylesheet>
• <xsl:template>
• <xsl:template>
• <xsl:value-of>
• Navigating with XPath
• Navigating With XPath
• <xsl:for-each>
• <xsl:if>
• XPath Boolean expressions
• XPath Boolean Expressions
• <xsl:choose>
• <xsl:apply-templates>
• <xsl:sort>
• The Music Collection Example – Introduction
• The Music Collection Example – Sample XML file
• The Music Collection Example – Retrieving owner details
• The Music Collection Example – Retrieving the core data
• The Music Collection Example – Current Output
• The Music Collection Example – Retrieving canadianContent data
• The Music Collection Example – Current Output
• The Music Collection Example – Retrieving media data
• The Music Collection Example – Final Output
• Formatting XML Documents

Chapter 7. XML in Applications

• Topics
• Needs for Using XML in Applications
• Basic Functionalities Required for XML Applications
• XML Parser
• Obtaining a Parser
• SAX
• How it Works
• DOM
• DOM Parsing
• Applying XML Across System Boundaries
• Using XML on the Client Side
• Using XML on the Server Side
• Using XML in Non-Networked Systems
• Using XML in RDBMS
• The J2EE Blueprint
• A Typical Architecture Using XML in J2EE Applications
• Using XML in Applets
• Using XML Parser in Applets
• Using XML in Servlets
• Creating XML Middleware for Accessing Databases
• Transforming RDBMS Data to XML Data
• Transforming XML Data to RDBMS Data
• Storing XML Data in DB2

Chapter 8. Web services Description Language (WSDL)

• WSDL Overview
• WSDL Document Tags
• WSDL Namespaces
• <definitions>
• <import>
• <types>
• <message>
• <portType>
• <operation>
• One-way <operation>
• Request-Response <operation>
• Solicit-Response <operation>
• Notification <operation>
• Modeling Simple Operation
• Modeling Complex Operation
• Modeling Complex Message
• <binding>
• More on <binding>
• <binding> Syntax
• SOAP Binding Example
• <service> and <port>
• More on <port>
• WSDL SOAP Binding Extensions
• soap:binding
• soap:operation
• RPC or Document Style?
• WSDL API for Java
• Summary

Chapter 9. Information Management in SOA

• Introduction
• SOA and Enterprise Information Management
• Replication Overview
• Operational Challenges
• SOA and Data Basics
• Intro: Operational Data
• Data Publishing Event
• Modeling Events
• Data Mediation
• Data Format
• Generic Data Model
• Example Generic Data Model
• Mapping Data
• Loading Data
• Extract Transform Load (ETL)
• ETL and SOA
• Data Federation
• SOA Data Layering
• Data Federation vs ETL
• Summary

Chapter 10. Introduction to Service Oriented Analysis & Design (SOAD)

• Introduction to SOAD
• Applying OOAD Principles
• Encapsulation
• Encapsulation in SOAD
• Inheritance
• Inheritance in SOAD
• Polymorphism
• Polymorphism in SOAD
• Why OOAD Is Not Enough
• Granularity
• The Need for Loose Coupling
• The SOAD Methodology
• The SOAD Methodology Steps
• Stage 1: Requirements Gathering & Process or Message Flow Modeling
• Stage 1: Requirements Gathering & Process Modeling
• Stage 2: Service Identification
• Stage 3: Service Implementation
• Stage 4: Process Implementation
• SOAD Stages and SOA Lifecycle
• Summary

Chapter 11. Data Modeling in SOA

• Data Modeling in SOA
• Data Models in SOA
• The Physical Data Model
• Deriving the Physical Data Model
• Scenario 1: New Software System
• Scenario 2: Legacy Data Model
• Strategy #1: Adapter-based service example
• Strategy #1: Another adapter example
• Strategy #2: Wrapper Web service
• Scenario 3: Meet-in-the-middle
• The role of XML in SOA data modeling
• Converting Relational to XML data
• Storing XML data in a RDBMS
• Approaches to storing XML data in a RDBMS
• Storing the entire XML document
• Shredding the XML document
• Using a native XML data type
• SQL extensions for native XML support
• The Logical Data Model
• Benefits of the Logical data model
• Deriving a Logical Data model from the Physical
• Designing the Logical Data Model
• The Enterprise Architecture approach
• EA Approach – example
• Aligning your logical and physical models
• How to align your logical and physical models
• The SOAD approach
• The Logical Data Model in Business Process Modeling
• Business Process state variables
• Input and the Receive activity
• Output and the Reply activity
• The Invoke activity
• The Assign activity
• Why do you need a published data model?
• Industry-standard XML-based data models
• Review questions
• Summary

Chapter 12. The Data Mapping Layer

• Why do you need data transformation in SOA?
• Interface mapping in SOA
• Business processes and data mapping
• How are Data Maps used?
• How are Data Maps created?
• XML-to-XML data mapping
• XML-to-Any data mapping
• Mapping techniques
• Copy
• Splitting
• Aggregation
• Enrichment
• Filtering
• Computed
• Testing data maps
• Review questions
• Summary

Chapter 13. Master Data Management (MDM)

• What is Master Data Management?
• A typical data management scenario
• Why do you need MDM? (1 of 2)
• Why do you need MDM? (2 of 2)
• Why do you need MDM in SOA? (1 of 2)
• Why do you need MDM in SOA? (2 of 2)
• What role does MDM play in SOA?
• MDM and SOA shared principles
• MDM and SOA Governance
• MDM products
• Implementing MDM in an SOA (1 of 3)
• Implementing MDM in an SOA (2 of 3)
• Implementing MDM in an SOA (3 of 3)
• Review questions
• Summary

Chapter 14. Industry Standard Data Models

• What are industry data models?
• Why are these models important in SOA?
• ACORD – Introduction
• ACORD – Insurance data models
• ACORD, IBM and SOA
• The future of ACORD and SOA
• HL7 - Healthcare
• The HL7 data model
• SID - Telecom
• ARTS - Retail
• Review questions
• Summary

Chapter 15. Schema Configuration Management

• Evolving Schema
• Managing XML Schema
• Management Techniques
• Internal Techniques
• Schema Version Attribute
• Adding An Attribute
• Namespace Change
• File-Based Mechanisms
• External
• Which To Use?
• Summary

Chapter 16. Data Model Governance

• What is data governance?
• Roles and Responsibilities
• What is metadata?
• SOA metadata repository
• SOA registry as a governance tool
• Review questions
• Summary

Chapter 17. Data Modeling Patterns and Best Practices

• Pattern template
• Data Federation pattern – Synopsis
• Data Federation pattern – Benefits
• Data Federation pattern – Context
• Data Federation pattern – Solution
• Data Federation pattern – Solution architecture
• Data Federation pattern – Considerations
• Data Federation pattern – Summary
• Data Consolidation pattern – Synopsis
• Data Consolidation pattern – Benefits
• Data Consolidation pattern – Context
• Data Consolidation pattern – Solution
• Data Consolidation pattern – Considerations
• Data Consolidation pattern – Summary
• Data Cleansing pattern – Synopsis
• Data Cleansing pattern – Benefits
• Data Cleansing pattern – Context
• Data Cleansing pattern – Solution
• Data Cleansing pattern – Considerations
• Data Cleansing pattern – Summary
• Data Management systems primer
• MDM patterns – Synopsis
• MDM patterns – Benefits
• MDM pattern taxonomy
• MDM pattern catalogue
• Transaction Interception pattern
• Transaction Interception pattern flow
• MDM Pub/Sub pattern
• Message-based Integration pattern
• Master Data Integration pattern
• Information synchronization pattern (1 of 2)
• Information synchronization pattern (2 of 2)
• BI Analytical pattern
• Review questions
• Summary