Data Base Administration II
(Design and Implementation)
Design
and create a relational data base for an application. Build a
dictionary of data items and convert it into a field reference file. Use
standard file normalization techniques to remove redundant data
items. Use
date data types and variable length fields. Set up,
use, and manage the journaling of changes to physical files.
Streamline system backup by incorporating file journaling in the backup
strategy. Set up
a commitment control environment.
Perform backward and forward recovery operations under commitment
control. Use
Open Query File to dynamically select, sequence, and join records in HLL
programs.| Relational Data Base
Concepts Data Base Design Concepts Documenting the Business Function Entities and Data Items Design as an Iterative Process Resolving the Data Base Homonyms and Synonyms Derived Data Items Mutually Exclusive Items File Normalization Normal Forms 1, 2, and 3 Boyce-Codd Normal Form Documenting the Data Base Model |
Creating the Physical Data
Base Journaling Journals and Journal Receivers Journal Images Fixing a Damaged File Operational Considerations Commitment Control "Set" Processing COMMIT and ROLLBACK Commitment Boundaries Commit Cycle Notify Objects Operational Considerations |
OPNQRYF Command Selecting Files and Records Defining Key Fields Mapped Fields Select/Omit Processing Grouping OPNQRYF Join |
| Audience Any programmer, systems analyst, or data base administrator who will have the task of defining and creating data base files. Prerequisites AS/400 Workstation Operations AS/400 System Operations AS/400 Data Base Administration I |
Format Self-Instructional Materials Twenty Audio CDs Student Text Workbook Interactive Media |
Time Required Approximately 15 Hours |