QuickStudy: Enterprise Information Integration (EII)

By Russell Kay

September 19, 2005 12:00 PM ET

Comments

(1)

Computerworld -

Listen to the Computerworld TechCast: Enterprise Information Integration

The lifeblood of the modern enterprise is information. This isn't news. But as organizations collect more and more information from different sources and applications, it's increasingly difficult to deal with that information.

We know how to work with databases, data marts and data warehouses, because information in those places is carefully structured and massaged. (Read the Data Warehousing QuickStudy>.) But businesses also need to work with a wealth of unstructured information from sources such as document libraries, spreadsheets, e-mail and instant messaging archives, electronic forms and records, publicly available Web pages and commercial information services.

More
Computerworld
QuickStudies

Two elements are key to this discussion. First is the unstructured nature of content: Organizations have to handle streams of what might seem to be random text instead of the carefully delineated and validated fields that we're used to in "normally" managed data.

The second consideration is that companies are getting this information from multiple sources, both inside and outside the enterprise. Each data source has its own organization and format, and most were designed for a single, stand-alone purpose, not to be part of an integrated data collection. Thus, these repositories tend to be silos, independent of one another, and don't easily work well together.

We rely on a growing number of these data sources, and we need to be able to use new ones as they appear without having to rewrite our applications and tools.

The simple-minded answer to this problem is to aggregate all the data into a single, universal database or data warehouse. Unfortunately, creating such a central repository is a slow and expensive process. Maintaining and updating that repository is a job that could give any IT manager nightmares. And we haven't even addressed the issues of scalability and who owns the information. Clearly, a better, more efficient strategy is called for.

What's in a Name?

EII is the buzzword du jour, but the same idea has been around under a variety of other names, including virtual database, virtual data broker, federated query systems, federated data management and enterprise content integration. Indeed, it's possible to create a variety of alternate names that could be used in place of EII by simply picking one or two terms from each of the columns below and combining them - try it yourself. (How do you feel about contextual enterprise knowledge model convergence architecture?)
---A--- Virtual Integrated Enterprise Federated Combined Contextual Ad hoc Distributed Structured Aggregated		---B--- Information Data Knowledge Wisdom Query Content Schema Resource Model		---C--- Integration Infrastructure Base Broker Systems Management Convergence Architecture Solution Federation

Comment Recommend Digg Twitter ShareThis

Email Print Send Feedback Reprints

Jump to comments

data warehouse

Additional Resources

WHITE PAPER

Do You Know the 7 Steps to Successful Data Migration?

Approximately 60 percent of data migration projects overrun time or budget, while some fail completely. Download this white paper, "Enhancing Your Chance for Successful Data Migration," to learn the critical steps you need to take to execute a data migration project with minimum cost and risk to your business.

WHITE PAPER

Total Cost of Ownership of Server Computing Vs. PCs

Read the Gartner research note to learn why the TCO of a server-based computing deployment used to deliver all applications to users is around 50% lower than that of an unmanaged desktop deployment.

WHITE PAPER

IDC White Paper: Linux in a Global Recession

Economic downturns have a tendency to accelerate emerging technologies, boost the adoption of effective solutions, and punish solutions that are not cost competitive or that are out of synch with industry trends. This IDC White Paper presents the results of an IDC survey of 330 companies in Western Europe, Asia/Pacific and the Americas that measures the receptiveness to Linux and takes into consideration changing views driven by the disruptive economic environment that businesses face today.