Skip to content.

Sections
Home » Resource Center » Real-World Decision Support (RWDS) Journal » October 2000 - Volume 1, Issue 09

October 2000 - Volume 1, Issue 09

IN THIS ISSUE

  • Strategies for Custom Data Warehouse ETL Processing   

    This article provides a technical methodology and implementation strategy for performing custom ETL processing. A detailed example of a full life cycle ETL process, from source to warehouse, is systematically reviewed during the article. These techniques can be beneficial for decision support projects that are just getting started or for the implementation of a prototype by providing a quick, easy to learn, cost effective method for loading information into a warehouse. Existing infrastructures, even those who have purchased and implemented commercial off the shelf (COTS) ETL products, can benefit from these techniques by augmenting their existing procedures and processes with portions of this method.

  • HOW TO PROTECT THE WAREHOUSE USING A META DATA REPOSITORY   

    Meta data often is spoken about in terms associated with data warehouses. While it is understood that knowledge workers need meta data to perform their functions, other individuals related to the data warehouse can also reap great rewards from the use of meta data. This article is about how the data warehouse developer's can make use of the meta data to "protect" the data warehouse.

  • Building a Data Warehouse in Iterations   

    This article is excerpted from a book titled Data Warehouse Project Management (Addison-Wesley, September 2000). All material is copyright Addison Wesley Longman, Sid Adelman and Larissa Moss.

  • Enterprise Data Management: Integrating The Manual Steps   

    Enterprise Data Management (EDM) is the strategy behind understanding and sharing data across the enterprise and making information available to decision makers, regardless of the source of the data. The technology has been through several generations in the last few decades. In the past, it was thought of as a data conversion. After several iterations, the technology is now known by the general term of data migration. Data migrations are present everywhere today as they are used to build EDM applications such as E-commerce, Enterprise Resource Planning, Customer Relationship Management (CRM), Business Intelligence (BI), Data Warehousing, and Data Marts.

Letter From the Editor

by David Marco, President of Enterprise Warehousing Solutions, Inc.

Dear Readers,

Welcome to our 9th issue of Real-World Decision Support (RWDS). I have some exciting news to share with all of our readers. First, my book "Building and Managing the Meta Data Repository" is now on sale. Please feel free to click on the following link to see it on Amazon.com

Second, I am very pleased to announce that our membership at RWDS has grown from 2000 registered readers in the July Issue #8 to over 2900 for this current issue. I would like to sincerely thank all of the people that have contributed articles and to all of our readers who have so effectively spread the word on our newsletter.

For this issue we are privileged to have contributions from Sid Adelman, of Sid Adelman & Associates, Larissa Moss of Method Focus, Inc., Lance Carroll of Metagenix, Inc., Mike Jennings of Hewitt Associates, and Bob Seiner, editor of The Data Administration Newsletter.

Our regular columnist Mike Jennings has yet again delivered our lead article " Strategies for Custom Data Warehouse ETL Processing". This article is a must read for any company that will be building their own data warehouse ETL (extraction, transformation, and load) process.

Sid Adelman and Larissa Moss have presented a very informative article on the importance of building a data warehouse in iterative steps. This article is an adaptation from their book "Data Warehouse Project Management" (Addison Wesley).

Next, Lance Carroll of Metagenix, Inc. has contributed an excellent article on enterprise data management.

Lastly, Bob Seiner of The Data Administration Newsletter has provided a well-written article on the value of technical meta data to a corporation’s data warehousing team.

As a reminder, articles for our January, 2001 issue of Real-World Decision Support are due by December 12, 2000.

Calling All Writers

At RWDS we are always looking to publish new and informative, how-to articles. Our ever growing readership now totals over 26,000 registered readers and more than 30,000 unique visitors that visit the website during a new issue publication. Articles for RWDS can cover any topic in decision support, business intelligence, knowledge management, or information technology (IT) in general. Below is a brief list of possible topics:

  • Architecture
  • Best Practices
  • Conducting Tool Evaluations
  • Data Marts
  • Data Modeling
  • Data Warehousing
  • e-Business
  • Industry Standards
  • Meta Data
  • Operational Data Stores
  • Project Management
  • Staffing
  • UML
  • Unstructured Data
  • "War" stories from the field
  • XML, Etc.

Don't miss this opportunity to join the ranks of "those that write". If you would like to publish an article in Real-World Decision Support please send an email to MReed@EWSolutions.com and make sure to read our article guidelines at http://www.EWSolutions.com/

Please feel free to send all comments and questions on how we can improve Real-World Decision Support to ARiley@EWSolutions.com

This newsletter is published quarterly (January 1st, April 1st, July 1st, & October 1st) and is dedicated to providing informative, real-world solutions to the challenges of implementing decision support systems, e-business solutions, XML, and meta data repositories.

To offer feedback and suggestions on Real-World Decision Support, please contact us at: admin@EWSolutions.com