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

Resource Portals
Analytic Applications
Business Intelligence
Business Performance Management
Data Integration
Data Quality
Data Warehousing Basics
More Portals...


Information Center
DM Review Home
Conference & Expo
Web Seminars & Archives
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

General Resources
Industry Events Calendar
Vendor Listings
White Paper Library
Software Demo Lab

General Resources
About Us
Press Releases
Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Business Intelligence:
Data Diversity: Let It Be

  Column published in DM Review Magazine
June 2002 Issue
  By Susan Osterfelt

One of the best things to ever hit the old information technology function must be Web services in support of enterprise application integration (EAI). For a while, we thought we were going to have to replace all of our legacy application systems and data, but no! We can now leave those old systems in place (many of which are running just fine, thank you) and use middleware to expose these systems and their data to the Web. EAI involves software used to integrate applications and processes within an enterprise or across enterprises. EAI is achieved by developing integration standards that facilitate interaction among disparate systems without the need for custom point-to-point application integration work. Data can remain in diverse formats yet be integrated with other relevant data to enable business transactions and decisions. Diversity of data is no longer something to be overcome or reengineered, but rather something to be leveraged.

However, EAI relies on knowing what data is where, which brings in our old friend meta data. Meta data has always been important, especially in data warehouse creation, as a passive guide to the pieces of data that are critical to an enterprise's continuity. Meta data has been housed in meta data repositories and has been important for application developers, business analysts and even users to understand what a piece of data means, where it comes from, how it's calculated and who uses it. However, the problem has been its passivity.

With EAI, meta data now assumes an even more critical role. EAI is dependent on all applications participating in a solution being willing to use the same business semantics. Additionally, with EAI, meta data must assume an active role. Data about the data needs to be sent within the message, along with data about the source and target applications related to the message. Meta data must enable the correct routing and transformation of data between applications.

A fancy term that is being used to describe meta data for EAI is "ontology." An ontology provides a formalized view reflecting a common understanding of data within a domain. Ontologies do what "enterprise data models" did previously. Ontologies explain entities, attributes and relationships. However, instead of just being a record of this information, ontologies provide a machine-readable common semantic layer that is active and can help actually route data between applications.

It sounds great, doesn't it? But the main problem with implementing an ontology within an EAI framework is complexity. We all know how complex it is to define the data that is important to an organization. It's difficult to define in the first place, difficult to maintain over time and difficult to understand. Developing an EAI ontology may seem too difficult an undertaking - yet we can't "not do it." It simply must be done. Technologies and products will be emerging to help us build ontologies and dynamically mediate discrepancies in business definitions, yet it will be enforcing the discipline of dealing with complexity within our organizations that will be the critical success factor. Not having an ontology will be worse than having one that isn't perfect.

This whole idea of EAI is relatively immature. Meta data models must be developed based on incomplete examples and guidelines available from industry resources. The ties between ontologies and business process models must be defined. Then integration brokers can use this meta data to route and transform data between systems. Interface definitions can be reused. Messages used to transmit entries to an operational system can be copied and delivered separately to an analytic application for business activity monitoring. Diverse data can remain diverse, yet be used for different purposes. The essence of EAI is dealing with heterogeneity because homogeneity is often an unrealistic expectation.

No one can "boil the ocean" and develop an enterprise-wide, detailed, full-function meta data repository for application integration. I'm not sure that could ever be achieved. However, application integration is here to stay. Its benefits far outweigh the complete replacement of legacy systems. We need to move forward in developing an ontology to support it - step-by-step, application-by-application and project- by-project. The net result of dealing with diverse data via an EAI ontology will be lower costs and improved functionality, and we will extend the life of our legacy systems by maintaining their independence but leveraging their data. Isn't that the goal of data diversity? Our organizations can speak words of wisdom if we let the data be.


For more information on related topics visit the following related portals...
Meta Data, Enterprise Application Integration (EAI) and Business Intelligence.

Susan Osterfelt is senior vice president at Bank of America, in Charlotte, North Carolina. She can be reached at susan.osterfelt@bankofamerica.com.

Solutions Marketplace
Provided by IndustryBrains

Bowne Global Solutions: Language Services
World's largest language services firm offers translation/localization, interpretation, and tech writing. With offices in 24 countries and more than 2,000 staff, we go beyond words with an in depth understanding of your business and target markets

Award-Winning Database Administration Tools
Embarcadero Technologies Offers a Full Suite of Powerful Software Tools for Designing, Optimizing, Securing, Migrating, and Managing Enterprise Databases. Come See Why 97 of the Fortune 100 Depend on Embarcadero!

Online Backup and Recovery for Business Servers
Fully managed online backup and recovery service for business servers. Backs up data to a secure offsite facility, making it immediately available for recovery 24x7x365. 30-day trial.

Test Drive the Standard in Data Protection
Double-Take is more affordable than synchronous mirroring and enables you to recover from an outage more quickly than tape backup. Based upon the Northeast blackout and the west coast wild fires, can you afford to be without it?

Help Desk Software Co-Winners HelpSTAR and Remedy
Help Desk Technology's HelpSTAR and BMC Remedy have been declared co-winners in Windows IT Pro Readers' Choice Awards for 2004. Discover proven help desk best practices right out of the box.

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

Thomson Media

2005 The Thomson Corporation and DMReview.com. All rights reserved.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.