Corporate Data Modelling

How to plan for and develop a corporate data model

Course contents:

Course benefits

Who should attend

Prerequisites

What you will learn

What you will cover

How you will learn

Duration and availability

Course of the month

Course directory

Public schedule and prices

Terms of business

Course benefits:

Any organisation wishing to manage its data as a corporate asset will consider, and possibly initiate, the development of a corporate data model as part of its data administration initiative.

Traditionally, the size and complexity of a corporate data model has reflected the size and complexity of the organisation. This very size and complexity have made it extremely difficult to develop a corporate data model which is both stable and delivered in sufficient time to influence system design. Consequently, corporate data modelling has unjustly earned a poor reputation.

A clear understanding of the pitfalls likely to be encountered when developing a corporate data model along with strategies, which can be used to overcome the problems, will substantially improve the chances of success.

Who should attend:

This course is suitable for:

• Data Managers and Data Administrators
• Business and Data Analysts
• Repository Administrators

Prerequisites:

The course assumes a basic knowledge of data modelling techniques and the role of a data administration function.

What you will learn:

This course teaches practical and effective approaches to the development of a corporate data model in order to underpin the sharing of data and information between separately developed systems and to reduce overall system costs.

On successful completion of the course, attendees will be able to:

• Plan for, and develop, a corporate data model
• Describe and discuss the relationships between a corporate data model and the system life cycle
• State the principles that underpin the development of a successful corporate data model
• Define and discuss the merits of different data modelling notations
• Define and discuss the requirements for supporting tools and standards

What you will cover:

• The role of a corporate data model - Why a corporate data model is needed; the corporate data model as an expression of the business and as the basis for database designs
• Corporate data modelling principles - The essential requirements and principles underpinning the development of a corporate data model capable of leading to sharable and flexible, yet stable, database designs
• Techniques employed in corporate data modelling - Options for starting the development of a corporate data model; advanced data modelling techniques useful in corporate data modelling
• The relationship between a corporate data model and the system life cycle - How new and legacy projects relate to the corporate data model; relationship to object oriented methods and rapid application development
• Supporting tools and standards - Selecting dictionaries, repositories or CASE tools; selecting appropriate data modelling notation; use of naming standards and meta data models.

How you will learn:

This course comprises short and focused lecture sessions with supporting exercises. Problems and issues are also discussed. Real life examples are used to highlight the principles. The course benefits from experience-based instruction.

Duration and availability:

Two days non-residential. In-house only.