Data Integration

Get Started. It's Free
or sign up with your email address
Rocket clouds
Data Integration by Mind Map: Data Integration

1. Enterprise Integration (EI)

1.1. capability to integrate information and functionalities from a variety of information systems in an enterprise

1.2. Enterprise Information Integration (EII)

1.2.1. integration on data and information level

1.2.1.1. structural integration

1.2.1.2. semantic integration

1.2.2. principal approaches (database-centric)

1.2.2.1. manual integration

1.2.2.2. common user interface

1.2.2.3. integration by applications

1.2.2.3.1. workflow management system (WFMS)

1.2.2.4. integration by middleware

1.2.2.5. uniform data access

1.2.2.5.1. mediated query systems

1.2.2.5.2. portals

1.2.2.5.3. federated database system (FDBMS)

1.2.2.5.4. integration-by-webservices

1.2.2.5.5. peer-to-peer integration

1.2.2.6. common data storage

1.2.2.6.1. date warehouse (DWH)

1.2.2.6.2. operational data stores

1.3. Enterprise Application Integration (EAI)

1.3.1. integration on the level of application logic

2. reasons / goal

2.1. single information access point

2.2. data consolidation turns diverse data into a more comprehensive basis

3. benefitary applications

3.1. Business Intelligence (BI)

3.1.1. querying / reporting on business activities

3.1.2. statistical analysis

3.1.3. Online Analytical Processing (OLAP)

3.1.4. data mining

3.1.4.1. forecasting

3.1.4.2. dicision making

3.1.4.3. enterprise-wide planning

3.1.4.4. gain sustainable competitive advantages

3.2. Customer Relationship Management (CRM)

3.2.1. integrated information on individual customers

3.2.2. business environemnt trends

3.2.3. current sales

3.3. Enterprise Information Portals (EIP)

3.3.1. integrated company information as personalized web sites

3.3.2. single access points for employees / customers / partners / public

3.4. e-Commerce / e-Business

3.4.1. enables and facilitates business transactions over computer networks

4. kinds of heterogenity

4.1. hardware and operating systems

4.2. data management software

4.3. data models / schemas / semantics

4.4. middleware

4.5. user interfaces

4.6. business rules and integrity constraints

5. dependencies

5.1. architectural view of integrated information system

5.1.1. http://i172.photobucket.com/albums/w13/mikecobo/ndk_wm/Fig1.png

5.2. content / functionality of source systems

5.3. kind of information that is managed by source systems

5.3.1. alphanumerical

5.3.2. multimedial

5.3.3. structured

5.3.4. semi-structured

5.3.5. unstructured

5.4. requirements concerning autonomy of source systems

5.5. intended use of integrated information system

5.5.1. read-only

5.5.2. read/write access

5.6. performance requirements

5.7. available resources

5.7.1. time

5.7.2. money

5.7.3. human resources

5.7.4. know-how