Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search

View all Portals

Scheduled Events

White Paper Library
Research Papers

View Job Listings
Post a job


DM Review Home
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

Buyer's Guide
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

About Us
Press Releases
Advertising/Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Meta Data Management & Enterprise Architecture:
Industry-Specific MME Applications, Part 3

  Column published in DM Review Magazine
December 2005 Issue
  By David Marco

This column is adapted from the book Universal Meta Data Models by David Marco & Michael Jennings, John Wiley & Sons, 2004.

In the first two parts of this series, I walked through examples in the banking, healthcare insurance and manufacturing industries. This month I will address managed meta data environment (MME) applications for national defense and pharmaceutical industries.

National defense organizations such as the FBI, the U.S. Army, Navy, Air Force, Marines, Coast Guard and Britain's Royal Navy have some of the most extensive MME requirements of any type of organization. These groups are absolutely dependent on the information from their systems and the proper functionality of their immense IT applications. This is doubly important to understand because the activities that these organizations engage in place people in harm's way. Our application scenario maps the IT system's data elements to the functional information elements for interfaces between the major IT systems.

A key task of the National Security Organization is to deliver medical supplies to various theaters of operation. They want to see which branches of the military utilize what interfaces and elements to accomplish this task (see Figure 1). This type of report is highly valuable when problems or enhancements need to be resolved or made across the IT systems.

Figure 1: National Security MME Report: Systems Interfaces Report

Pharmaceutical companies tend to have more sophisticated MME and data stewardship committees because of the regulations around clinical trials. Clinical trials are the processes a pharmaceutical company goes through to research, develop and attain government approval for new compounds (drugs). The average cost for developing a new drug is between $150 to $250 million and more than 10 years of time before it can be brought to market. Every day that a new compound is delayed from reaching the market costs the company $1 million in lost revenue. This includes the extra time it will take to recoup sunk expenses (ever see the interest expense on $150 million?) and the possibility of a competitor creating a competing compound.

During these trials, government agencies such as the FDA have rigorous standards that must be met before a new drug can gain approval. Passing these FDA (and other agency requirements) tests is not easy. These organizations and their corresponding legislation require that a pharmaceutical company has very definitive data elements. For example, Title 21 CFR Part 11 has a significant impact on a clinical trial for a pharmaceutical company. Look at the following passage from the FDA  Department of Health and Human Services, entitled "Title 21 CFR Part 11, Electronic Records; Electronic Signatures; Final Rule" dated Thursday March 20, 1997:

"The Food and Drug Administration (FDA) is issuing regulations that provide criteria for acceptance by FDA, under certain circumstances, of electronic records ... the pharmaceutical industry met with the agency to determine how they could accommodate paperless record systems ... to develop a uniform approach by which the agency could accept electronic signatures and records in all program areas ... The final rule provides criteria under which the FDA will consider electronic records to be equivalent to paper records, and electronic signatures equivalent to traditional handwritten signatures."

Compliance with FDA regulations such as this is no small task, and almost every pharmaceutical company is struggling to adhere to this regulatory rule. This rule will be the focus point of our application scenario.

TheGreatPharma Company is a large pharmaceutical company that is running a clinical trial on a new compound. In order to pass various Title 21 CFR Part 11 audit compliance regulations, they must track every instance where a person changed any data within the clinical trial. The meta data captured in this process includes what data was changed, who changed it, when was it changed, what its prior value was, what its new value is and why it was changed. The audit compliance report shown in Figure 2 could be generated directly form the MME and provided to the FDA to assist in expediting the process of FDA approval.

Figure 2: Title 21 CRF Part 11 MME Report: Audit Compliance

In my next column I will conclude this series on specific industry examples of how an MME can provide value to any large government or commercial organization.


For more information on related topics visit the following related portals...
Compliance and Enterprise Achitecture.

David Marco is an internationally recognized expert in the fields of enterprise architecture, data warehousing and business intelligence and is the world's foremost authority on meta data. He is the author of Universal Meta Data Models (Wiley, 2004) and Building and Managing the Meta Data Repository: A Full Life-Cycle Guide (Wiley, 2000). Marco has taught at the University of Chicago and DePaul University, and in 2004 he was selected to the prestigious Crain's Chicago Business "Top 40 Under 40."  He is the founder and president of Enterprise Warehousing Solutions, Inc., a GSA schedule and Chicago-headquartered strategic partner and systems integrator dedicated to providing companies and large government agencies with best-in-class business intelligence solutions using data warehousing and meta data repository technologies. He may be reached at (866) EWS-1100 or via e-mail at DMarco@EWSolutions.com.

View Full Issue View Full Magazine Issue
E-mail This Column E-Mail This Column
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.