Metadata Registries for Integration and Business Intelligence

Course Description: Having consistent metadata definitions is perhaps the most important strategy in the precise exchange of computer information. XML use used universally by both Open Source Java and Microsoft infrastructure.   Understand XML and related technologies allows all participants on a team the ability to communicate effectively using common terminology.

Target Audience: Data architects, project managers, business analysts, testing and quality assurance, software developers, web site designers and web authoring.  This class is also appropriate for programmers that have not had exposure to XML or would like a refresher in XML technologies.

Prerequisites: Knowledge of how to use a Microsoft Windows computer including mouse and keyboard skills are essential for the successful completion of the labs.  Knowledge of computer systems operation, databases and data structures and data types is also helpful.  If the class participants have a background in XML (see XML course above) this class proceed through the introductory material much faster.

Sample Course Content

1. Definition of Metadata
2. Metadata registries
3. Business benefits of managed metadata
4. Metadata registry standards
5. Metadata publishing
6. Metadata harvesting
7. Glossaries
8. Data element approval workflow
9. ISO/IEC 11179 metadata registry standards
10. Metadata Semantics
11. Classification schemes
12. Representation terms
13. Creating precise definitions
14. Creating exchange documents
15. Web services
16. Using XML to store metadata
17. XML and metadata registries
18. Subschema generation
19. XML semantics
20. Semantic brokers and mappers
21. Visualization
22. Data warehouse metadata management
23. Dimensional analysis
24. Creating cubes using metadata registry information
25. Generating SQL using XML transforms

Optional Additional Topics

1. National Information Exchange Model (NIEM) - Recommended for state and federal agencies
2. Global Justice XML Data Model (GJXDM) - Recommended for public safety agencies
3. Web Ontology Language - (OWL)
4. Unified Modeling Language (UML)
5. XML metadata interchange (XMI)
6. Common Warehouse Metamodel (CWM)

Labs

1. Using the GTRI XML subschema generator
2. Designing and exchange documents
3. Structure of the National Information Exchange Model NIEM
4. Visualization lab

Length: 6-8 hours depending on audience background and options.

Cost: A single-day class is $2,995 including presentation handouts for 10 students.  Add $95 for each additional student above 10.  Customization work is performed at $150.00/hr.  This price does not include lodging, transportation or classroom setup time.

Classroom setup: This learning rate of class participants can be enhanced if the classroom is equipped with computers that have XML software installed. Options include using Altova's XMLSpy and Eclipse 3.0.  Please contact us for detailed specifications.