Data Warehouse Metadata

metadata-management-data-warehouse
It is a common belief that in order for the data warehouse to be successful, it must be metadata driven.
Our beginnings here at InfoLibrarian™ started with the data warehouse back in the 90's. We knew then and still believe today, that organizations will benefit from a comprehensive view of their metadata, and of metadata management.
InfoLibrarian's software was first released to address the need for metadata for the data warehouse, today; our products address the full range of purposes to deliver reliable metadata, especially for the data warehouse.

Typical Data Warehouse Metadata

Metadata

  • Source system and target system table mappings.
  • Destination schema.
  • Routines and scripts scheduling, mode of running.
  • Routine version and location.
  • Automated extract tool settings, if applicable.
  • Quality reconciliation and control routines.

Dimension Table Management Metadata

  • Dimensional models.
  • Dimensional schema info.
  • Slowly changing dimension policies for each incoming descriptive attribute.
  • Surrogate key assignment rule and counters.

Transformation and Metadata

  • Business specifications of the transformation rules.
  • Source to destination mappings.
  • Location of the transformation Scripts.
  • Staging area schema.
  • Load scripts, schedule and location.

Metadata for Job Control and Audit Logs as well as Documentation

  • Data lineage and audit records (where exactly did this record come from and when?).
  • Data Extraction, transform, loading run time logs, success summaries, and time stamps.
  • Data transform software version numbers.
  • Security settings for extract files, extract software, and extract metadata.
  • Security settings for data transmission (i.e., passwords, certificates).
  • Data staging area archive logs and recovery procedures.
  • Data staging archive security settings.

DBMS Metadata

  • DBMS system table contents.
  • Partition settings.
  • Indexes.
  • DBMS-level security privileges and grants.
  • View definitions.
  • Stored procedures and SQL administrative scripts.
  • Backup procedures and backup security.

Business Metadata

  • Business names and descriptions for columns, tables, groupings, and so on.
  • Canned query and report definitions.
  • Default join specification tool settings.
  • Bi tools metadata.
  • Reporting tools metadata.
  • Where used reports for data elements, tables, views, and reports.

Follow the links below to see how InfoLibrarian™ can help you to capture and manages data warehouse metadata.

Business Metadata
InfoLibrarian Software
InfoLibrarian Metadata adapters

Close this window
Featured Solution Webinar

infolibrarian-meta-data-management-server

InfoLibrarian Server™

Leveraging, managing and presenting metadata with the InfoLibrarian Metadata Management Framework™
Includes topics on Metadata Itegration, Business Metadata, Custom Metadata, Taxonomies and Lineage.
(Schedule Webinar)




Instructions

To request an InfoLibrarian™ solution webinar, please register and sign on to this site. You may submit your request directly using this dialog. Once you have submitted your request, a representative will initiate communication with you via email.

^ Back to Top


The names of companies and products mentioned herein may be the trademarks of their respective owners.

Close this window


Log In To Account



USER NAME * (This will be your email address) Forgot User Name    

PASSWORD * (6 characters minimum, 25 maximum) Forgot Password  







Don't Have An Account Yet



CREATE ONE ITS SIMPLE!



WHY YOU SHOULD CREATE AN ACCOUNT...

- Free trial downloads


- Free documentation downloads


- Members-only beta trials


- Product updates and service releases


- On-demand webinars


- Manage your support activity