Skip to main content

Data Integration


Data integration is the process of retrieving data from multiple source systems and combining it in such a way that it can yield consistent, comprehensive, current and correct information for business reporting and analysis. Integration is the act of bringing together smaller components into a single system that functions as one. In computing, the source systems may be various types of digital devices and the data may be in a variety of formats.

Important data integration techniques include:
  • Data consolidation: Data is copied from multiple sources and integrated into a single data store
  • Data propagation: Applications copy and push data from one location to another
  • Data federation: Data federation software enables an organization to aggregate data from multiple source systems into a virtual database for use in business intelligence (BI) and other analyses.
  • Data warehousing: Data warehouses store data collected by various operational systems; the data is captured for access and analysis, rather than transaction processing.

 Customer data integration

Customer data integration (CDI) was one of the first drivers for consolidating and managing information from disparate sources. Software for managing data gathered through customer interactions can help ensure that departments across a business are able to reliably access the most current and complete view of customer information available.

Data integration in the cloud

Integration as a Service (IaaS) is a cloud-based delivery model that strives to connect on-premise data with data located in cloud-based applications. This paradigm facilitates real-time exchange of data and programs among enterprise-wide systems and trading partners.

In business-to-business (B2B) integration, IaaS allows partners to develop, maintain and manage custom integrations for diverse systems and applications in the cloud. In this way, the enterprise can more effectively pursue process innovations without the need to constantly modify and maintain diverse and often incompatible application programs.

Comments

Popular posts from this blog

Black swan

A  black swan event  is an incident that occurs randomly and unexpectedly and has wide-spread ramifications. The event is usually followed with reflection and a flawed rationalization that it was inevitable. The phrase illustrates the frailty of inductive reasoning and the danger of making sweeping generalizations from limited observations. The term came from the idea that if a man saw a thousand swans and they were all white, he might logically conclude that all swans are white. The flaw in his logic is that even when the premises are true, the conclusion can still be false. In other words, just because the man has never seen a black swan, it does not mean they do not exist. As Dutch explorers discovered in 1697, black swans are simply outliers -- rare birds, unknown to Europeans until Willem de Vlamingh and his crew visited Australia. Statistician Nassim Nicholas Taleb uses the phrase black swan as a metaphor for how humans deal with unpredictable events in his 2007...

A Graphics Processing Unit (GPU)

A graphics processing unit (GPU) is a computer chip that performs rapid mathematical calculations, primarily for the purpose of rendering images. A GPU may be found integrated with a central processing unit (CPU) on the same circuit, on a graphics card or in the motherboard of a personal computer or server. In the early days of computing, the CPU performed these calculations. As more graphics-intensive applications such as AutoCAD were developed; however, their demands put strain on the CPU and degraded performance. GPUs came about as a way to offload those tasks from CPUs, freeing up their processing power. NVIDIA, AMD, Intel and ARM are some of the major players in the GPU market. GPU vs. CPU A graphics processing unit is able to render images more quickly than a central processing unit because of its parallel processing architecture, which allows it to perform multiple calculations at the same time. A single CPU does not have this capability, although multi...

6G (sixth-generation wireless)

6G (sixth-generation wireless) is the successor to 5G cellular technology. 6G networks will be able to use higher frequencies than 5G networks and provide substantially higher capacity and much lower latency. One of the goals of the 6G Internet will be to support one micro-second latency communications, representing 1,000 times faster -- or 1/1000th the latency -- than one millisecond throughput. The 6G technology market is expected to facilitate large improvements in the areas of imaging, presence technology and location awareness. Working in conjunction with AI, the computational infrastructure of 6G will be able to autonomously determine the best location for computing to occur; this includes decisions about data storage, processing and sharing.  Advantages of 6G over 5G 6G is expected to support 1 terabyte per second (Tbps) speeds. This level of capacity and latency will be unprecedented and wi...