Enterprise information integration

Source: Wikipedia, the free encyclopedia.

Enterprise information integration (EII) is the ability to support a unified view of data and information for an entire organization. In a

heterogeneous
data sources to appear to a user or system as a single, homogeneous data source.

Overview

indexing and data access
methods.

Standardized data access

XQJ, OLE DB, and more recently ADO.NET
.

There are also standard formats for representing data within a file that are very important to information integration. The best-known of these is XML, which has emerged as a standard universal representation format. There are also more specific XML "grammars" defined for specific types of data such as

Directory Service Markup Language for holding directory-style information. In addition, non-XML standard formats exist such as iCalendar for representing calendar information and vCard for business card
information.

Enterprise Information Integration (EII) applies data integration commercially. Despite the theoretical problems described above, the private sector shows more concern with the problems of data integration as a viable product.[1] EII emphasizes neither on correctness nor tractability, but speed and simplicity.

Combining disparate data sets
Each data source is disparate and as such is not designed to support EII. Therefore, data virtualization as well as data federation depends upon accidental data commonality to support combining data and information from disparate data sets. Because of this lack of data value commonality across data sources, the return set may be inaccurate, incomplete, and impossible to validate.
One solution is to recast disparate databases to integrate these databases without the need for ETL. The recast databases support commonality constraints where referential integrity may be enforced between databases. The recast databases provide designed data access paths with data value commonality across databases.
Simplicity of deployment
Even if recognized as a solution to a problem, EII as of 2009 currently takes time to apply and offers complexities in deployment. Proposed schema-less solutions include "Lean Middleware".[2]
Handling higher-order information
Analysts experience difficulty—even with a functioning information integration system—in determining whether the sources in the database will satisfy a given application. Answering these kinds of questions about a set of repositories requires semantic information like metadata and/or ontologies.

Applications

EII products enable

web content management
(CMS).

Data access technologies

See also

  • Business Intelligence 2.0 (BI 2.0)
  • Data warehouse – Centralized storage of knowledge
  • Disparate system – Data processing system without interaction with other computer data processing systems
  • Enterprise integration – technical field of enterprise architecture focused on system interconnection, data interchange, data exchange and distributed computing
  • Federated database system – type of meta-database management system which transparently maps multiple autonomous database systems into a single federated database
  • Resource Description Framework – Formal language for describing data models
  • Semantic heterogeneity – when database schema or datasets for the same domain are developed by independent parties, resulting in differences in meaning and interpretation of data values
  • Semantic integration – Interrelating info from diverse sources
  • Semantic Web – Extension of the Web to facilitate data exchange
  • Web 2.0 – World Wide Web sites that use technology beyond the static pages of earlier Web sites
  • Web services
     – Service offered between electronic devices via the internet

References