Using InfoSphere Data Architect – ce822-lpl
Course #: ce822-lpl
Duration: 2 Days
This course allows you to gain basic knowledge and skill in using InfoSphere Data Architect to diagram and document logical and physical database models and to employ the physical design functions. It includes several machine exercises utilizing various functions of InfoSphere Data Architect.
Objectives
- Use the Eclipse interface to employ InfoSphere Data Architect functions
- Given a logical model, use InfoSphere Data Architect to draw the visual diagram and store the model information
- Show the InfoSphere Data Architect functionality for Web publishing and PDF reporting
- Define the InfoSphere Data Architect capabilities to provide team support
- Use the logical model documented with InfoSphere Data Architect to produce a physical model
- Explain how to use InfoSphere Data Architect to create a physical model from existing DDL
- Use the Connection and Data Source Explorer
- Perform transformations using InfoSphere Data Architect
- Evaluate the use of validation and dependency analysis as provided with InfoSphere Data Architect
- Create and manage mapping models
Audience
This intermediate course is for data modelers, physical database designers, application analysts, database administrators, and other personnel who need to perform logical and physical modeling and associated functions as provided by InfoSphere Data Architect.
Prerequisites
You should have:
- Basic skills in logical data modeling.
- Knowledge of general RDBMS terminology
Topics
InfoSphere Data Architect Introduction
- Describe the basic architectural elements of the Eclipse Graphical User Interface (GUI)
- Explain the InfoSphere Data Architect Views and their contents
- Relate the functions of the Search tool
Logical Data Modeling
- Relate the concepts of a logical data model and notation techniques for its diagram
- Explain how a logical data model is represented in the various InfoSphere Data Architect Views in the Eclipse Graphical User Interface (GUI)
- Describe the InfoSphere Data Architect functions to create a project, a logical data model in the project, and the logical data model elements
- State the purpose and usage of a Glossary Model and a Domain Model
Web Publishing and BIRT Reporting
- Use Web Publishing interface as a means of publishing your logical or physical model in HTML or PDF format.
- Explain the level of details of the report, so as to be able to use the report as means of documentation as well as means of collaborating with your project team.
Physical Data Modeling and Transformations
- Discuss the various ways to create a physical data model
- Explain how to create a physical data model from an existing logical data model
- Describe the capabilities of InfoSphere Data Architect to perform DB2 for zSeries storage modeling for the physical data model
- Relate the usage of the InfoSphere Data Architect model analysis facility
- List the steps to generate DDL to deploy the completed physical data model
- State the InfoSphere Data Architect process to reverse engineer an existing physical database to a physical data model
- Describe the functions available with the InfoSphere Data Architect Data Source Explorer View
Database Lifecycle Management
- List the major activities for lifecycle management of the database and associated models
- Describe how to setup and use InfoSphere Data Architect Team Support with Eclipse CVS or with ClearCase Remote Client
- Explain how to use the InfoSphere Data Architect Compare and Synch features to manage concurrency and accuracy of data models
- Relate the reasons for an impact analysis and the steps to perform an impact analysis
- State the basic data model transformation functions
Validation and Dependency Analysis
- Describe how to invoke the analysis of a data model
- Explain and evaluate the results of a model analysis
- Describe how to invoke the impact analysis function
- Explain and evaluate the results of an impact analysis
Mapping Models and Data Integration
- Explain what mapping models are used for
- Create a new mapping model
- Configure mappings
- Configure mapping groups
- Generate scripts based on mapping models
- Discuss how InfoSphere Data Architect can integrate with InfoSphere Metadata Server
Agenda
Day 1
- Welcome
- Unit 1 - RDA Introduction
- Exercise 1
- Unit 2 - Logical Data Modeling
- Exercise 2
- Unit 3 - Web Publishing and BIRT Reporting
- Exercise 3
Day 2
- Unit 4 - Physical Data Modeling and Transformations
- Exercise 4
- Unit 5 - Database Lifecycle Management
- Unit 6 - Validation and Dependency Analysis
- Exercise 5
- Unit 7 - Mapping Models and Data Integration
- Exercise 5