Library

Course: How to Build an Enterprise-Wide Meta Data Repository

How to Build an Enterprise-Wide Meta Data Repository

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

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.

Basic knowledge
  • Students should have a pre-existing knowledge of designing, building and or supporting databases in a corporate environment or be involved in some capacity relating to extracting data and reporting information within a corporation
What you will learn
  • 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
Curriculum
Lectures quantity: 13
Common duration: 01:21:16
Introduction and Enterprise Level Data Repository Frameworks
  • 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;


  • Why a 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!

  • 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.

  • 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.

  • 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".

Enterprise Level Data Repositories - Strategies, Rationale and Implications
  • The Overall Repository Management Strategy  

    This lecture provides the student with important "Best Practice" information relating to Repository Management. Rationale, Implications and general tasks need to be completed in relation to implementing a sound Repository Management strategy are documented within this lecture.

  • 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.

  • Data Categorization Strategies, Rationale and Implications  

    This lecture provides the student with important "Best Practice" information relating to categorizing data between operational and decision support systems. Rationale, Implications and general tasks need to be completed in relation to implementing sound data categorization strategies are documented within this lecture.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

Rating
(0)
Enrolled Students
(0)
Level
Intermediate
Advanced
Price
$ 60.00
Course Language
English
reviews (0)
Average rating
0
0 voices
Detailed rating
5 stars
0%
4 stars
0%
3 stars
0%
2 stars
0%
1 stars
0%