Course Description
As corporations increase in size and complexity, securing, managing and insuring the integrity and accuracy of internal data becomes a critical component to continued corporate growth. If a corporation is growing, there will come a time in each entity's evolution where an ELDR (Enterprise Level Data Repository/Meta Data Repository) becomes an integral component to the organizations information systems architecture.
This course provides the student with the knowledge required to:
Justify the need for an ELDR within the corporation
Construct a set of Best Practices/Principles for it's design
Design and build the Framework for the services the ELDR will provide
Design the resulting architecture required for the ELDR
Define the rules for the data/information to be stored within the ELDR (Data Dictionary, operational, decision support, etc.)
Define the categories of data, data integrity, data security, etc.
Define the rules, processes and structures required to check-in, check-out and modify data/information stored within the ELDR (Management Framework)
Define the application components that will comprise the ELDR system
This course is designed to support the ongoing efforts of an IT department and its data architects and managers in designing, building and maintaining a corporation's business, operational and decision support information systems. It is an advanced course most useful to database architects, senior information systems analysts and systems development personnel.
What am I going to get from this course?
- Students will learn best practices relating to architecting Meta Data Repositories for a corporation.
- Students will learn how to implement and manage meta data repositories in corporations.
- Students will learn how to implement and operate geographically dispersed meta data repositories for complex organizations.
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Students should have a knowledge of building and or supporting databases in a corporate environment.
Who should take this course? Who should not?
- This course targets database administrators, developers and architects working for corporations.
- The course would also be useful to information technology consultants.
Curriculum
Module 1: Introduction and Enterprise Level Data Repository Frameworks
Lecture 1
Introduction to Enterprise Level Meta Data Repositories
This course assists the student in learning how to define and construct an Enterprise Level Data Repository (ELDR). Within this course, we will define both an architectural and a management/operational framework for the Repository. The full scope of this course lecture series includes the following:
•A defined and sample Repository Management Framework for a Corporation globally.
•Defined personnel roles to manage this environment including an overview of tasks usually relating to each of the roles.
•An ELDR “Help Desk” support environment definition including training tips; and,
•An initial definition of targeted users of the ELDR systems and tools.
Lecture 2
Why Build an Enterprise Level Meta Data Repository?
As corporations grow, undertaking the construction and deployment of an Enterprise Level Meta Data Repository becomes an almost "Must Do" project. The increasing complexities of systems and data as corporations globally deploy need some form of structured meta data environment else the corporation is at risk of losing control of its internal information assets; and this can hurt them as they continue to try to compete in the marketplace. This lecture discusses in overview what an ELDR actually is, the benefits of implementing one within a corporate environment and the risks a corporation will face if it does not build one - so be sure to check this lecture out!
Lecture 3
Key Terms to Learn in This Lecture Series
This lecture provides detailed definitions of key terms used in this lecture series that the student should understand before going through the full course.
Lecture 4
Database Referential Integrity and Its Importance in High Availability Systems
Database referential integrity is not just a database design feature to be taken for granted when databases are implemented and deployed. As a database and systems architect, when working with high concurrent user and high availability systems, you will need to thoroughly understand referential integrity and all its ramifications to your final deployed database designs. In high availability systems, its usage becomes in actuality, an architectural design consideration.
Lecture 5
Building a Global Data Dictionary
A Global Data Dictionary is a "cornerstone" component to a Meta Data Repository. Be sure to watch this video to learn what types of content a corporation should be collecting about their internal data and application systems through these "Dictionaries".
Module 2: Enterprise Level Data Repositories - Strategies, Rationale and Implications
Lecture 6
The Overall Repository Management Strategy
Data Management Strategies, Rationale and Implications
Lecture 7
Data Management Strategies, Rationale and Implications
This lecture provides the student with important "Best Practice" information relating to Data Management. Rationale, Implications and general tasks need to be completed in relation to implementing a sound Data Management strategy are documented within this lecture.
Lecture 8
Data Categorization Strategies, Rationale and Implications
This lecture provides the student with important "Best Practice" information relating to Data Management. Rationale, Implications and general tasks need to be completed in relation to implementing a sound Data Management strategy are documented within this lecture.
Lecture 9
Data Distribution Strategies, Rationale and Implications
This lecture provides the student with important "Best Practice" information relating to distributing a Meta Data Repository within geographically dispersed and complex corporations. Rationale, Implications and general tasks need to be completed in relation to implementing sound data distribution strategies are documented within this lecture.
Lecture 10
Data Transaction Management Services
This lecture provides the student with important "Best Practice" information relating to implementing sound data transaction management services within complex corporations. Rationale, Implications and general tasks need to be completed in relation to implementing sound data transaction management services strategies are documented within this lecture.
Lecture 11
Data Integrity Strategies, Rationale and Implications
This lecture provides the student with important "Best Practice" information relating to maintaining data integrity within a Meta Data Repository environment. Rationale, Implications and general tasks need to be completed in relation to implementing sound data integrity strategies are documented within this lecture.
Lecture 12
Data Security Strategies, Rationale and Implications
This lecture provides the student with important "Best Practice" information relating to implementing effective Meta Data Repository security strategies to protect the MDR/ELDR environment. Rationale, Implications and general tasks need to be completed in relation to implementing sound data security strategies are documented within this lecture.
Lecture 13
ELDR Security Profiles
This lecture provides the student with useful knowledge on how to implement useful MDR security profiles for those that have a need to access the MDR environment. Rationale, Implications and general tasks need to be completed in relation to implementing security profiles for end users of the MDR/ELDR are documented within this lecture.
