Ref : DBD / 2 days

Télécharger la fiche descriptive du séminaire

Context

MEGA Database Design enables the modeling of information system data, and generation of the corresponding relational diagram and SQL script for database creation. The tool enables parallel management of conceptual objects (entities, associations, attributes) and logical objects (tables, columns, keys) to take account of developments and optimizations. MEGA also enables reverse documentation of an existing database from an extraction file or an ODBC driver, with reverse generation of the logical model and reverse design of the conceptual model.

Who should attend?

• Data administrators
• IS architects
• Database administrators
• Application managers
• Analysts Designers Developers

Expected Benefits

• Master database modeling concepts: conceptual and physical models.
• Learn, through a realistic business case, how to use MEGA Designer – Database effectively and make the best use of the MEGA repository.
• Optimize the structure of a relational database and generate the corresponding SQL script.
• Reverse engineer an existing relational database to obtain a conceptual schema.

Course Content

Introduction

• Presentation of MEGA
• Database design procedure

Data modeling

• Basic concepts
• Other concepts, rules and approach

Synchronization

• Database creation
• Conceptual and logical object mapping
• Transformation rules
• Relational diagram
• Synchronization configuration

Optimizations and developments

• Denormalization and mapping management
• Complements: views, tablespaces, triggers, etc.

Generation

• Configuring Generation
• Elements necessary for defining Database structure

Reverse generation

• Reverse Design Cycle
• Configuring Reverse Generation
• Extraction Utility
• Logical Model Creation

Synchronization (logical to conceptual)

• Synchronization Rules
• Synchronization Wizard

Making best use of the MEGA repository

• Producing project related documentation
• Generating HTML pages
• The Query tool
• Working as a team

Lab exercises

Over 2 days, training alternates theoretical presentations of data modeling and practical exercises covering all phases of the design of a data system and reverse documentation of an existing repository.

• Producing a data diagram from a real case
• Synchronization: management of logical objects obtained
• Exercises in modification and optimizations of models
• SQL script generation
• Reverse generation of an existing repository
• Exercises in repository use