• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
You are here: Home » What is Information Integration

By Abhishek Ghosh October 30, 2021 6:28 pm Updated on October 30, 2021

What is Information Integration

Advertisement

Information integration is the merging of information from different data sets (data sources) with usually different data structures into a common uniform data structure. In this process, heterogeneous sources are to be brought together as completely and efficiently as possible into a structured unit that can be used more effectively than would be possible with direct access to the individual sources. Information integration is particularly necessary where several grown systems are to be connected, for example when merging companies, workflows and applications or when searching for information on the Internet. The integration of more complex systems only came into the focus of computer science research in the 1990s and is thus still under development.

The rapid development in the technology of databases since the 1960s led to the need to share and combine existing data. This combination can take place at a variety of levels in the database structure. A popular solution is based on the principle of the data warehouse, which extracts the data from heterogeneous sources, transforms it and loads it into a unified system.

Since 2009, the trend of information integration has been towards standardized query interfaces to query the data in real-time. This allows the data to be retrieved directly from heterogeneous sources, which provides an advantage in the timeliness of the data but requires increased access times. Since 2010, some research in this field has been dealing with the problem of semantic integration. This is less concerned with the structure of the architecture of different databases than with the resolution of semantic conflicts between heterogeneous data sources.

Advertisement

---

The models for data processing that have existed since 2011 lead to data isolation in the form of data islands of scattered data. These islands are an unwanted artefact, due to the methodology of data modelling, which leads to unequal data sets. To counteract this problem, methods have been developed to avoid data isolation artefacts and to integrate them into the data structure.

Information integration becomes significant in several different situations, both commercial and scientific. Examples of the practical application of information integration can be found in the integration of product information from manufacturer specifications and the retrieval of this information by product search engines or in the evaluation of various geological data sets to determine cross-border surface properties.

In the case of redundancy between the data of different sources, togetherness can be determined in some cases automatically and used for the completion of data sets (data fusion). For example, the entries of a telephone list and an employee directory can be combined if personal names match. Since more information about individual objects is available, this is also referred to as compaction.

The goal of the integration is to provide a consistent global view of all data sources. Redundant data sources can be used for verification. The merging of intentionally redundant sources leads to higher coverage and the completion of data sets with extensional redundancy of sources to a higher density.

 

Materialized Versus Virtual Integration

 

Two types of integration can be distinguished:

Materialized or physical integration: Data from different data sources – usually with different data structures – is transformed into the target structure and copied to a central database, where it is then available for evaluation. This principle can be found, for example, in data warehouses or the project for data exchange of the Open Archives Initiative.

Virtual or logical integration: The data remains in the different sources and the integration only takes place at a request (Federated Information System).

What is Information Integration

 

Integration Architectures

 

Materialized Integration Architectures

Data Warehouses (DWH) are the most important representatives of materialized database systems. The data required for a company’s information needs is persisted directly in a central data warehouse to provide a global, unified view of the relevant data. To integrate the source data into the data warehouse base database, an integration layer must be implemented for this purpose (ETL process).

Operational Data Stores (ODS): While data warehouse systems are primarily adapted to the requirements of corporate management and thus the available information serves the strategic decision-making processes, in operational data stores, the integrated data is available to operational business processes. This already implies that the data stored in a central data warehouse should be used operationally, i.e. after the integration has been completed (import, cleansing, storage), this data is subject to change. Therefore, the focus of ODS systems is not on historical, but primarily current data. In this respect, another essential distinguishing feature to DWH arises, since the synchronization to the source data must take place either for requests or at least at frequent, regular intervals. ODS is mostly used by companies in those business areas in which the timeliness of the data plays an essential role, such as in customer and supplier communication areas and warehouse management processes. With the trend towards a real-time data warehouse and more powerful database management systems, the operational data store is likely to merge into the data warehouse.

Virtual Integration Architectures

Unlike materialized systems, data in virtual database systems are not stored in the integrated system itself, but remains physically in the data sources and is only loaded into the integration system during requests (virtual data store).

Federated Database Systems (FDBS) is a global conceptual schema. This schema provides the interface to the local, distributed databases and their local schemas, and on the other hand, it provides requesting applications with an integrated global view of the federated source data utilizing appropriate services. FDBS are usually created by the union of several database systems (multi-database systems) with the aim of a central (federated) coordination of common tasks.

Tagged With https://thecustomizewindows com/2021/10/what-is-information-integration/ , Information integration

This Article Has Been Shared 329 Times!

Facebook Twitter Pinterest

Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to What is Information Integration

  • IBM Analytics Demo Cloud : Free Hadoop, Ambari With SSH

    IBM Analytics Demo Cloud is intended to learn Hadoop, Ambari, BigSQL free of cost with SSH access & web console. Here is how to get started.

  • How to Install Apache DataFu (DataFu Pig, DataFu Hourglass)

    Here is Guide on How to Install Apache DataFu on Debian System. Apache DataFu is a collection of well-tested libraries for data mining and statistics.

  • Big Data Analytics in Internet of Things (IoT)

    What is the Role of Big Data Analytics in the Internet of Things (IoT)? We can connect all the things to the cloud database & find the pattern.

  • What Apache Kafka Can Do?

    In increasingly complex application landscapes, the handling of data flows is becoming increasingly difficult. Read how Apache Kafka big data technology can help. Linking data from different systems is at the top of the to-do list in application handling. There are many solutions for this, each with advantages and disadvantages. Apache Kafka promises to solve […]

  • Every Thing is Collecting Your Data

    Privacy becoming a big concern in today’s connected world. We store (and share) more and more of our details and other information in digital formats. Most of us rely on our smartphones and gadgets to do everything from grocery shopping to work planning. Recent studies have shown that the amount of data we produce and […]

Additionally, performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

Get new posts by email:

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (24.3K Followers)
  • Twitter (5.8k Followers)
  • Facebook (5.7k Followers)
  • LinkedIn (3.7k Followers)
  • YouTube (1.3k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • What is Configuration Management February 5, 2023
  • What is ChatGPT? February 3, 2023
  • Zebronics Pixaplay 16 : Entry Level Movie Projector Review February 2, 2023
  • What is Voice User Interface (VUI) January 31, 2023
  • Proxy Server: Design Pattern in Programming January 30, 2023

About This Article

Cite this article as: Abhishek Ghosh, "What is Information Integration," in The Customize Windows, October 30, 2021, February 5, 2023, https://thecustomizewindows.com/2021/10/what-is-information-integration/.

Source:The Customize Windows, JiMA.in

PC users can consult Corrine Chorney for Security.

Want to know more about us? Read Notability and Mentions & Our Setup.

Copyright © 2023 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT