CONFERENCE - DAY 2
WEDNESDAY
29 October, 2003
09:00–10:00 KEYNOTE Information Quality Keynote:
REVERSING THE HIGH CO$T$ OF LOW QUALITY INFORMATION
Larry P. English, President and Principal, INFORMATION IMPACTt International, Inc.
10:00–10:15   Break

10:15–11:15

META DATA

How To Manage Standing Data Using A Meta Data Repository
Irene Miller, Independent Consultant

10:15–11:15

Information Quality

Measuring ROI from Your Information Quality Initiatives
Kathy Hunter, Information Management Consultant, InfoAdvantage Ltd.

10:15–11:15 DAMA
Track 1

To Laugh Or Cry? Further Fallacies In Data Management 2003
Fabian Pascal, Data Management Specialist/Editor & Publisher, DATABASE DEBUNKINGS

10:15–11:15

DAMA
Track 2

Shell UK Exploration - Implementation Architecture in A Fast Changing Organisation
Steve Mutch, Data Warehouse Team Leader, Shell UK Exploration and Production

10:15–11:15 DAMA
Track 3
Servicing the Need for a Global Resource
Peter Haine, Director, Information and Data Architecture, GlaxoSmithKline
     
11:20–12:20 META DATA Coping With Disparate Data After An Acquisition
Robert Dias, Migration Specialist, Ithaca Solutions
11:20–12:20 Information Quality

Broadband Changes UK Telephony & BT’s Attitude to IQ Forever
John Hodges and David Evans, Data Quality Consultants, BTexact

11:20–12:20 DAMA
Track 1

You Can’t Cost-Justify Architecture!
John A. Zachman, President, Zachman International

11:20–12:20 DAMA
Track 2

UML For Data Management
Terry Quatrani, UML Evangelist, IBM

11:20–12:20 DAMA
Track 3
Enterprise-wide Data Warehouse Design Issues
Joe Oates, Chief Architect, Sybase
12:20– 13:20   Lunch
13:20–14:20 KEYNOTE  DAMA INTERNATIONAL Keynote:
A ROADMAP TO ENTERPRISE INTEGRATION AND COLLABORATION
Mike Ferguson, European Managing Director, Intelligent Business Strategies

14:25–15:25

META DATA

Implementing An Information Architecture Through Meta Data Management at BT
Helen Hepburn, Information Architect & Peter Smillie, Metadata Consultant, BTexact

14:25–15:25

Information Quality

Data Quality at Bulgari: A Case Study
Alberto Villari, Data Quality Manager, Bulgari S. p. A.

14:25–15:25

DAMA
Track 1

Developing Enterprise Architecture in Practice
Trevor Bedeman, Head of Insurance Customer Data Management, Lloyds TSB Insurance

14:25–15:25 DAMA
Track 2

Data Modelling-Analysis or Design?
Graeme Simsion, Senior Fellow, University of Melbourne

14:25–15:25 DAMA
Track 3
CDISC: Establishing Global Information Standards for the Pharmaceutical Industry
Derek Chalmers, Assistant Director, Global Standards & Biomedical Asset Management, GlaxoSmithKline (UK)
15:25–15:40   Break

15:40–16:40

META DATA

OASIS Content Assembly Mechanism for eBusiness Collaboration
Martin Roberts, B2B Solutions Expert and OASIS CAM TC member, BT Exact

15:40–16:40 Information Quality

Data Quality Management for Data Warehouse Systems: Experiences at a Swiss Bank
Dr. Markus Helfert, Lecturer, Dublin City University

15:40–17:10 DAMA
Track 1,
Track 2 & 3

DAMA PANEL - MODEL-DRIVEN ARCHITECTURES OR ARCHITECTURE-DRIVEN MODELS - Thoughts from a Panel of Experts 
Michael Brackett, Graeme Simsion, Peter Aiken, Joe Oates, John Zachman

     
16:40–17:10 META DATA META DATA CONFERENCE Q&A SESSION AND CHAIR WRAP UPS
16:40–17:10 Information Quality INFORMATION QUALITY CONFERENCE Q&A SESSION AND CHAIR WRAP UPS 
 
Wednesday
29 October
9:00 –10:00

Information Quality Keynote:
REVERSING THE HIGH CO$T$ OF LOW QUALITY INFORMATION


Larry English Larry P. English
President
INFORMATION IMPACT International, Inc.

Organizations that ignore information quality problems today do so at their own risk. The high costs of information "scrap and rework" that in the past was considered a "normal cost of doing business," devastate the organization’s balance sheet and can cause business or mission failure in the realized Information Age.

The same condition was true of manufacturing in the Industrial Age when companies were squandering 20-40% of their revenue in costs of manufacturing scrap and rework. That is, until Deming, Juran, Ishikawa, Imai and Crosby proved to the world that by designing quality in, you can eliminate the high costs of low quality products. Just as quality principles transformed manufacturing processes to recover and eliminate the costs of scrap and rework, so also does Information Quality Improvement principles and processes help you recover and eliminate the costs of processes failure and information scrap and rework caused by low-quality information.

In this presentation, Mr. English describes how to measure the costs of nonquality information, both direct costs and opportunity costs. He describes how process improvement, information presentation design improvement and error proofing can transform business process effectiveness and business success. Mr. English describes how leading-edge organizations are gaining competitive advantage and increasing business effectiveness through information quality management.

  • The high—and hidden—costs of low quality information
  • The real metrics of information quality: $$$, £££, €, ¥¥¥
  • How to measure the real costs of nonquality information
  • How to prevent customers from leaving and losing their customer lifetime value
  • Measure the ROI of process improvement and quality information
  • How to create and sustain the High IQ™ Organization

High IQ™ is a trademark of INFORMATION IMPACT International, Inc.

Wednesday
29 October
10:15–11:15

META DATA

How To Manage Standing Data Using A Meta Data Repository


Irene Miller

Irene Miller
Independent Consultant

In this presentation, Irene describes how tactical requirements analysis was completed for a major telecommunications company in order to provide an integrated tool and repository architecture. Irene will then describe how the results of the tactical requirements study were used in the detailed requirements analysis, the final tool selection, the design and customisation of the tools and the final implementation. Topics covered will include:

  • Background to the study
  • Steps to introducing the tool and repository architecture
  • The meta model used to hold standing data
  • Procedures used, in particular those to keep copies of the data in sync
  • How problems such as version and change control were tackled
  • Business benefits resulting from these accomplishments e.g. improved business understanding, data quality and impact analysis

Wednesday
29 October
10:15–11:15

Information
Quality

Measuring ROI from Your Information Quality Initiatives
Kathy Hunter

Kathy Hunter
Information Management Consultant
InfoAdvantage Ltd.

A financial downturn needn’t stop businesses increasing their IQ. In fact, information quality helps organisations to make the most of the information they already have. In today’s difficult conditions, it is essential that all projects deliver return on investment. This presentation will focus on measuring the results of your information quality initiatives in order to quantify ROI. Topics include:

  • Quality metrics for accuracy and validity of information
  • Methods for capturing the recovery of poor data quality costs
  • Creating ROI by capitalising on quality information

Practical hints and tips will be provided along with ideas for promoting IQ in organisations that require near immediate ROI.

Wednesday
29 October
10:15–11:15

DAMA
Track 1

To Laugh Or Cry? Further Fallacies In Data Management 2003
Fabian Pascal

Fabian Pascal
Data Management Specialist/Editor & Publisher
DATABASE DEBUNKINGS

Most of what is being said, written about, or done in data management by vendors, the trade press and "experts" is irrelevant, misleading, or outright wrong. While this is to a degree true of IT in general, in the data management field the problems are so acute that, claims to the contrary notwithstanding, technology is actually regressing! This is due to the persistent failure by both DBMS vendors and database users, including database designers, DBAs, application developers and managers, to educate themselves and rely on a sound foundation in their respective practices. Indeed, it is lack of proper education—and interest in acquiring such--that makes the "cookbook approach" and industry fads and the accelerating obsolescence they are based on possible and acceptable in the first place! This presentation:

  • Exposes some of the prevalent fallacies in the industry
  • Demonstrates fundamentally flawed technologies, products and practices they lead to
  • Expounds their costly practical consequences
  • Offers an opportunity to test yourself on your ability to see through the former and avoid the latter.

Wednesday
29 October
10:15–11:15

DAMA
Track 2

Back to top

Shell UK Exploration - Implementation Architecture in A Fast Changing Organisation
Steve Mutch

Steve Mutch
Data Warehouse Team Leader
Shell UK Exploration and Production


Shell UK Exploration and Production (EXPRO), operates a number of North Sea oil platforms and exploratory drilling sites. The company had a need to improve the coherence, accuracy and transparency of financial management information, along with the need to integrate Planning data. In order to do this and keep up with very fast changing organization such as Shell, EXPRO needed to implement an underlying architecture to deal with a constant sea of change.
The benefits of the project have been:
  • Massive improvements in the consistency, transparency and detail of management information
  • Ten analyst man-years saved per year
  • Faster, more consistent and more accurate business planning models.

Wednesday
29 October
10:15–11:15

DAMA
Track 3

Back to top

Servicing the Need for a Global Resource
Peter Haine

Peter Haine
Director, Information and Data Architecture
GlaxoSmithKline


In GlaxoSmithKline a Service based model has been adopted for the delivery of value-adding IT solutions: this requires a clear annunciation of the business benefits sought, and the collection of metrics that demonstrate the achievement of those benefits.
Applying such an approach to data standardisation requires an assessment of the value of each and every master reference data standard requested. There is no shortage of candidates but considerable variability in the return on investment delivered by what prove to be tough standardisation issues. The process of implementing data standards into the global applications portfolio will be described in this presentation and the metrics chosen to demonstrate the benefits delivered, assessed, to show how a service based approach enables focus on value for money activity.
  • Strategy for delivering the value from global data
  • Re-using rather than re-inventing data
  • Measuring the benefits from data re-use
  • Focusing on the real value-adding targets
 

Wednesday
29 October
11:20–12:20

META DATA

Coping With Disparate Data After An Acquisition
Robert Dias

Robert Dias
Migration Specialist
Ithaca Solutions

Companies decide to acquire other companies after extensive due diligence, except in the area of IT. This means that the first one knows of problems of getting at the data of the acquired company is after acquisition. So, what can be done? In this presentation, Robert will take a real-life example of a company using IBM equipment, which acquired a company that used Unisys equipment. He will show the problems that were faced by the acquiring company because the data formats were so different, the real data layouts were not really known and the data was "dirty". He will then describe what was done to solve these problems. Topics include:

  • How to understand the source layouts
  • How to carry out a gap analysis
  • Data mapping
  • Data conversion including the problems and solutions associated with signs, half-byte data, hexadecimal data and when a date is not a date
  • How the data was cleansed

Wednesday
29 October
11:20–12:20

Information
Quality

Broadband Changes UK Telephony & BT’s Attitude to IQ Forever
John Hodges

John Hodges
Data Quality Consultant
BTexact

David Evans David Evans
Data Quality Consultant
BTexact

British Telecom has a vital role in delivering ‘Broadband Britain’. However this delivery has not been trouble free. Poor information quality was causing problems such as unaccounted inventory and unsatisfactory fault resolution that caused poor customer satisfaction and loss of revenue. Senior management got tough on these effects, which saw a rapid rollout of a strategic data quality program, focusing on cultural change as well as best-of-breed IQ improvement methodologies. This presentation offers practical advice to IQ practitioners by focusing on:

  • The IQ challenges faced by BT in its Broadband deployment
  • Our strategy for addressing them
  • How we delivered quick wins
  • How we have moved towards a strategic approach to information quality management by deploying pan-business data quality measures and maintaining improvement gains

Wednesday
29 October
11:20–12:20

DAMA
Track 1

You Can’t Cost-Justify Architecture!
John A. Zachman

John A. Zachman
President
Zachman International

Most people still think that the way to acquire funding for new systems is "cost-justification." I would suggest that this is a vestige of the past … the Industrial Age. The game has changed!! We are now clearly well into the Information Age and the value proposition for systems has radically changed. Now Architecture … Enterprise Architecture … plays a central role in providing value to the Enterprise. There are four reasons why you "do" Architecture including alignment, integration, change management and reduced time to market. Without Architecture, there is NO WAY you can do any of these things. This presentation begins with a brief tutorial on the Framework for Enterprise Architecture to define what Enterprise Architecture is, and then develops the logic as to its value to the Information Age Enterprise.

Wednesday
29 October
11:20–12:20

DAMA
Track 2

Back to top

UML For Data Management

Terry Quatrani

 

Terry Quatrani
UML Evangelist
IBM

Finally database modellers can now reap the same rewards from using the Unified Modelling Language as application developers have been doing for years. Application and database modellers can now speak one language - UML. No longer are database analysts, modellers, and designers relegated to the tail end of the development lifecycle. Now database designers can participate from the inception of the project, helping shape those early decisions that often have a critical impact on the system’s data. Also, being able to link together the object and data models, and thereby improving the understanding of both, helps yield higher quality systems. Delegates will learn:

  • The basic UML diagrams and how they can be used for data modelling
  • The UML profile for data modelling
  • The relationship between the UML diagrams and conceptual, logical, and physical data modelling
  • The benefits of each UML diagram to the database designer
  • How UML helps to jumpstart their database design.

Wednesday
29 October
11:20–12:20

DAMA
Track 3

Back to top

Enterprise-wide Data Warehouse Design Issues
Joe Oates

Joe Oates
Chief Architect
Sybase

Most data warehouse projects are actually data marts. Enterprise-Wide data warehouse design is beyond the experience of most data warehouse developers. This presentation presents a new concept called data warehouse normal form (DWNF).

This is not merely a theoretical presentation; rather it is based on experience designing a commercial packaged data warehouse product.
Topics covered include:

  • The difference between a data mart and an Enterprise-wide data warehouse
  • The "Whole Customer" concept
  • Patterns that free the designer from having to implement a series of disconnected data marts
  • How object-oriented thinking is a necessity
  • Experiences and issues
 
Wednesday
29 October
13:20–14:20

DAMA INTERNATIONAL Keynote:
A ROADMAP TO ENTERPRISE INTEGRATION AND COLLABORATIONY


Mike Ferguson Mike Ferguson
European Managing Director
Intelligent Business Strategies

This keynote presentation begins by outlining examples of business problems caused by lack of integration and collaboration. It then defines an enterprise architecture that shows how processes, applications, information, and collaborative tools can be integrated. This architecture also shows why common business metadata is the missing piece of the puzzle that integrates the enterprise. In addition, the session includes a roadmap showing the steps to achieving enterprise integration. This includes requirements, how EAI and ETL can be integrated on common metadata and how intelligence and collaboration can be used to guide business operations to meet strategic business objectives.

Wednesday
29 October
14:25–15:25

META DATA

Implementing An Information Architecture Through Meta Data Management at BT
Helen Hepburn

Helen Hepburn
Information Architect
BTexact

Peter Smillie Peter Smillie
Metadata Consultant
BTexact

In this presentation, Helen and Peter will describe how internal Information Management specialists have introduced and linked the concepts of ‘Information Architecture’ and ‘Metadata Management’ in British Telecom. Helen and Peter will describe how shifts and trends in the market have impacted this work, the difficulties they encountered and how they were overcome, and what the lessons learned to date are. Particular emphasis is placed in this presentation upon why the work became so important, how the concept was proved and how both IT and business were impacted. Topics covered include:

  • What is an Information Architecture?
  • The business drivers behind the Information Architecture - EAI Hub Architecture & other automation; Business Intelligence; and business integration
  • How the Information Architecture is being maintained
  • The impact on the business - the ‘business architecture’; design authority/governance; and cultural change
  • The impact on IT - the role of the partner/‘intelligent supplier’; realisation/implementation of the business architecture; and the design process

Wednesday
29 October
14:25–15:25

Information
Quality

Data Quality at Bulgari: A Case Study
Alberto Villari

Alberto Villari
Data Quality Manager
Bulgari S. p. A.

In this presentation, Mr. Villari describes Bulgari’s establishment of its Corporate Data Quality project. Bulgari produces and sells 50,000 different products. It recognized the need to qualify its products to enable marketing and management to analyze performances and outcomes of different product lines, designs, materials etc. The company enriched and improved its product information quality and made its definition and business rule information be available to business personnel. Project phases included:

  • Documentation of data definition, Owner, Consumers, Visibility rules inside and outside the company, and other information for each new Data (Attribute), which formed a complete Data Dictionary.
  • The creation of a grid of Data (Attributes) Owners and Information Consumers
  • The (re-)definition of process involving the definition and/or use of the information.
  • Integration of newly defined Attributes and Processes inside our ERP.

Wednesday
29 October
14:25–15:25

DAMA
Track 1

Developing Enterprise Architecture in Practice
Trevor Bedeman

Trevor Bedeman
Head of Insurance Customer Data Management
Lloyds TSB Insurance

Enterprise architecture is a powerful new field. This is a case study of development in one company. We show in practice how we are building up the function in LTSB Insurance, how we have developed a series of successful studies, which have expanded in a logical way to cover the whole business, and how we have achieved business understanding and buy-in in practice.

We look back at the first three years in an open and honest way, and discuss what we have learned from experience, and how we have developed and modified our approach. We also look at how and why in practice we have modified the standard approaches to the field, in particular we have worked at a high level rather than an excruciating level of detail! We also relate what major gaps we think we have, where we intend to go next, and what lessons we hope we have learned for the future.

  • Organising for enterprise architecture
  • The first study: mapping and recommending
  • Different approaches – functions, domains and processes
  • Communicating to the business – concepts, knowledge nd dialogue
  • Establishing a key business function

Wednesday
29 October
14:25–15:25

DAMA
Track 2

Back to top

Data Modelling-Analysis or Design?
Graeme Simsion

Graeme Simsion
Senior Fellow
University of Melbourne

Graeme Simsion has for some years argued that data modelling is a design activity, involving choice and creativity. Presentations of his position have engendered vigorous debate amongst both academics and practitioners.

In this presentation, Graeme will summarise the arguments regarding this debate and discuss the implications for practice. He will include results of research, which he has undertaken over the past two years.

Wednesday
29October
14:25–15:25

DAMA
Track 3

Back to top

CDISC: Establishing Global Information Standards for the Pharmaceutical Industry
Derek Chalmers

Derek Chalmers
Assistant Director, Global Standards & Biomedical Asset Management
GlaxoSmithKline (UK)

Carrying out Clinical Trials is a key step for any pharmaceutical company aiming to bring a new drug to market. Trials generate a large amount of data, often from a variety of sources, which must be collected, processed and analysed by a range of disparate methodologies. Eventually, this data must be packaged as information for both internal and external customers each with their own specifications. The Clinical Data Interchange Standards Consortium (www.CDISC.org) is a cross-industry collaboration aiming to lead the development of global, vendor-neutral, platform independent data standards to improve data quality and accelerate product development in the pharmaceutical industry. This talk aims to:

  • Summarize the clinical trial environment and the challenges facing the international pharmaceutical industry
  • Provide an overview of the CDISC organization and its collaborative approach
  • Discuss some of the CDISC success stories and ongoing initiatives
 

Wednesday
29 October
15:40–16:40

META DATA

OASIS Content Assembly Mechanism for eBusiness Collaboration


Martin Roberts
B2B Solutions Expert and
OASIS CAM TC member
BT Exact

The OASIS CAM work is specifically focused on providing XML ‘templating’ tools that bridge the gap between business process components and the implementation layer of backend business application systems. In this presentation, David will describe not only the latest architecture work within OASIS but also show industry domain uses of CAM templates including the OAGI BODs for supply chain integration, the UBL purchasing transaction templates and RosettaNet electronic components supply integration. Attendees will learn how they can use CAM templates to enhance their own information systems semantics. Topics covered include:

  • Understanding eBusiness Information Architectures
  • Building consistent information transactions
  • Integrating business process engines with content transactions

Wednesday
29 October
15:40–16:40

Information
Quality

Data Quality Management for Data Warehouse Systems: Experiences at a Swiss Bank
Dr. Markus Helfert

Dr. Markus Helfert
Lecturer
Dublin City University

In this presentation, Dr. Helfert describes experiences in implementing a Data Quality improvement project at a large bank.

  • Effects of poor data quality in a banking environment: they didn’t know how much money they had!
  • The Data Warehouse System and Architecture
  • A rule-based Data Quality Assessment system
  • Data Quality processes and organizational structures
  • Lesson learned, tips and techniques and further developments

Wednesday
29 October
15:40–17:10

DAMA

DAMA PANEL DISCUSSION - MODEL-DRIVEN ARCHITECTURES OR ARCHITECTURE-DRIVEN MODELS - Thoughts from a Panel of Experts
Michael Brackett Michael Brackett John Zachman John Zachman
Graeme Simsion

Graeme Simsion

Joe Oates Joe Oates
Peter Aiken Peter Aiken

Several decades ago database management systems were evolving and data modelling was in its infancy. One concept that emerged during the early days of data modelling was canonical synthesis. Individual data models were prepared and, according to canonical synthesis, could be easily plugged together to make an enterprise-wide data architecture. Most of us know that concept has not resulted in any viable data architectures.

An apparently new concept has recently emerged which is generally refereed to as model-driven architectures. In many respects it is nothing more than canonical synthesis with a new name, and like canonical synthesis, has not produced any enterprise-wide architectures. The wide disparity in data models, and data modelling techniques, simply prevents them from being connected to form a consistent data architecture.

Another concept that emerged several decades ago is the Framework for Information System Architectures. This concept promotes a framework consisting of a set of architectures for each column, each of which is composed of a set of models for each row in the column. The phrase 'a complete set of representations, enterprise-wide, horizontally and vertically integrated, to an excruciating level of detail' is well-known today.

A common architecture concept directly supports the Framework concept. One enterprise-wide architecture supports each column in the Framework. All models within a column are developed within their respective common architecture. For example, the common data architecture encompasses everything in the data column, and so on.

Information technology is now faced with two basic and conflicting approaches: model driven-architectures and architecture-driven models. Which is best has not yet been proven conclusively; but there are many examples and opinions. This panel of experts will present and support their views followed by questions from the delegates.

 

Wednesday
29 October
16:40–17:10

META DATA

META DATA CONFERENCE Q&A SESSION AND CHAIR WRAP UPS


Wednesday
29 October
16:40–17:10

Information
Quality

INFORMATION QUALITY CONFERENCE Q&A SESSION AND CHAIR WRAP UPS