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 and Data Administration:
Meta Data Repository Project Plan: The Feasibility Phase

  Column published in DM Review Magazine
February 2001 Issue
  By David Marco

The key to your company's prosperity is how well you gather, retain and disseminate knowledge. To this end, the meta data repository is the key for gathering, retaining and disseminating knowledge. This column is the second installment in a walk-through of the key tasks in each of the five fundamental phases of a project plan to build a meta data repository: orientation, feasibility, design, construction and rollout. This month we will focus on the feasibility phase (see Figure 1).

Feasibility Phase

With the orientation phase completed, your company is ready to move into the feasibility phase. The purpose of the feasibility phase is to ascertain whether or not it is cost beneficial for the company to build a meta data repository. There are two key deliverables that occur during the feasibility phase: the project scope document and the high-level project plan.

Figure 1: Feasibility Phase Tasks

Create Project Scope Document

The project scope document is the first, and possibly the most important, deliverable in the meta data repository project. Unfortunately, it is also the deliverable that many companies fail to produce. The project scope document should define the specific business and technical drivers for the implementation of the meta data repository. It serves as the project's compass and drives all subsequent project development work, thereby eliminating the phenomenon of "project creep." Project creep is a very common cause of project failure; it occurs when the end-user requirements increase or change significantly during the design and development phases. Remember the three "S's" of development: staff, scope and schedule. If you change one, you have to change them all or the quality of the project will suffer.

Creating a project scope document typically requires three to four weeks. If your company sign-off policy calls for multiple signatures and/or there are strong political pressures among the decision-makers, then it may take as many as seven weeks to complete this deliverable. On the other hand, if the company is essentially a dictatorship and requires only a single, high-level signature, the entire project scope document process can be completed in as few as one or two weeks.

Perform High-Level Planning and Estimating

The high-level project plan is the second key deliverable of the feasibility phase. This plan defines the cost of the initial release of the meta data repository project and is vital for cost justifying the design and development phases of the project. Once the project plan is approved by the project champion, the project manager of the meta data repository will have to obtain the resources to staff the plan. It is best when the internal staff of the corporation can fulfill these resource requirements. If the IT department does not have enough resources to meet the demands of the project plan, the project manager has three options. First, the project manager may hire additional IT staff, which could elongate the project time lines. Second, the manager could lengthen the project time lines so that the available staff can meet its requirements. Third, the project manager could hire a consulting vendor to partner with on the project.

Tune in next month, when I will be walking through the design phase.

Note: This column is adapted from my book Building and Managing the Meta Data Repository. The complete project plan is available on the accompanying CD-ROM.


For more information on related topics visit the following related portals...
DW Administration, Mgmt., Performance.

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.

Solutions Marketplace
Provided by IndustryBrains

Data Validation Tools: FREE Trial
Protect against fraud, waste and excess marketing costs by cleaning your customer database of inaccurate, incomplete or undeliverable addresses. Add on phone check, name parsing and geo-coding as needed. FREE trial of Data Quality dev tools here.

Backup SQL Server or Exchange Continuously
FREE WHITE PAPER. Recover SQL Server, Exchange or NTFS data within minutes with TimeSpring?s continuous data protection (CDP) software. No protection gaps, no scheduling requirements, no backup related slowdowns and no backup windows to manage.

Speed Databases 2500% - World's Fastest Storage
Faster databases support more concurrent users and handle more simultaneous transactions. Register for FREE whitepaper, Increase Application Performance With Solid State Disk. Texas Memory Systems - makers of the World's Fastest Storage

Design Databases with ER/Studio: Free Trial
ER/Studio delivers next-generation data modeling. Multiple, distinct physical models based on a single logical model give you the tools you need to manage complex database environments and critical metadata in an intuitive user interface.

Free EII Buyer's Guide
Understand EII - Trends. Tech. Apps. Calculate ROI. Download Now.

Click here to advertise in this space

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.