Information for December 2002
The next meeting of the LA Area DB2 User Group will be held on
December 5, 2002 at American Honda in Torrance. The meeting room will open at 8:30am
for coffee and refreshments with the first presentation beginning around
The American Honda campus is located at 1919 Torrance Blvd, Torrance, CA
90501. The telephone is (310) 783-2000. It is about 1.5 miles south of
Freeway and about 1.5 miles west of the 110 freeway.
here for directions and a map.
Michael Scofield is a popular
speaker, author and consultant on data architecture, data warehousing, and
data quality. Most recently, he was Director of Data Quality for Experian
(formerly TRW Credit Data) in Orange, California. Prior to this position,
he was Vice President and Manager of Information Quality for Home Savings
of America (Los Angeles). He is keenly interested in data quality
assessment, and reverse engineering and mining of production databases.
His articles on data
architecture and data quality techniques have been published in
Information Week, IBI System Journal, Data Management Review, and the
Database Newsletter. His speaking engagements include DAMA-International
conferences, Meta-data Conferences in London and the U.S., various DAMA
chapters, DB2 user groups, and The Data Warehousing Institute. He also
writes humor, published in the Los Angeles Times and other journals.
Importance of Data Architecture for Avoiding ERP Disaster and
Preserving Quality in the Data Asset
For a variety of reasons, companies are looking to the "silver bullet"
offered by ERP and other broad-spectrum business application packages to
resolve their business application backlog. For some businesses, this may
be a suitable alternative, but for many mature businesses, it could be a
Fundamentally, your business has a logical data architecture, whether
you model it or not. The physical data architecture reflected in existing
relational databases may not be keeping up with the business logical
model. Indeed, existing applications (legacy or ERP) and their underlying
databases may actually retard the natural morphing of the business.
This presentation will look at data architecture. Why it is hard to
understand. Why it is hard to explain to executives (let alone legacy
programmers). Why enterprises develop fragmented data architectures. What
companies tried to achieve with ERP packages. Why they may be
disappointed. What are the potential points of failure in the disconnect
between the legacy logical data architecture, and the package's data
architecture. How to spot the problems. How they might be mitigated.
Running businesses on ERP packages and the remaining legacy
applications provides significant data integration challenges. We will
look at those challenges, what semantic data integration is really about
(it is far more than mere name and address). Akin to this is a review of
the fundamentals of data quality, and how it applies to the evaluation and
planning of the ERP conversion.
BACK TO THE