Data Integration is the process of integrating data from multiple sources and probably have a single view over all these sources and answering queries using the combined information. Once the data integrated, so that they form a unified new whole and give users the illusion of interacting with one single information system.
The reason for integration is twofold:
*First, given a set of existing information systems, an integrated view can be created to facilitate information access and reuse through a single information access point.
*Second, given a certain information need, data from different complementing information systems is to be combined to gain a more comprehensive basis to satisfy the need.
There is a manifold of applications that benefit from integrated information. For instance, in the area of business intelligence (BI), integrated information can be used for querying and reporting on business activities, for statistical analysis, online analytical processing (OLAP), and data mining in order to enable forecasting, decision making, enterprise-wide planning, and, in the end, to gain sustainable competitive advantages.
For customer relationship management (CRM), integrated information on individual customers, business environment trends, and current sales can be used to improve customer services.
Integration can be physical or virtual:
• Physical: Coping the data to warehouse
• Virtual: Keep the data only at the sources
The most complex and difficult part of integrating data is transforming data into a common format. Understanding the data to be combined and understanding (and possibly defining) the structure of the combined data requires both a technical and business understanding of the data and data structures in order to define how the data needs to be transformed.
Data integration
A computer system comprises hardware and software components, aiming to offer a powerful computational tool. These systems play a crucial role across diverse domains, aiding us in numerous tasks. The prevalence of the internet has significantly bolstered the utilization of computers for information sharing and communication. Computer systems empower us to store, process, display, and transmit information. Even in a basic modern computer system, multiple programs are typically required to carry out various functions effectively.
The Most Popular Posts
-
The trash can has been a familiar presence on computer desktops starting with the early Macintosh systems. Unwanted files can be moved t...
-
Computer is a problem solving device. When a particular problem is to be solved, it is necessary to design a set of instructions for the com...
-
CyberCash Inc. was founded in 1994 and is performing secure credit card presentations since April 1995. CyberCash provides a range of commer...
-
A firewall in a computer network performs a role that is very similar to that of a firewall in a building. Just as a fire...
-
Doxxing is the word coined to describe the process of releasing of personally identifying information to the public without their consent. ...
-
-
Adenosine diphosphate (ADP) is a key molecule in cellular energy regulation, consisting of adenosine and two phosphate groups. It is central to the cell's ...
-