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

Post a Comment

Popular posts from this blog

Ghosting

Ghosting is to cease communications without notification. The use of the word "ghost" as a verb originated in social media in reference to dating, but the term is now used by employers to describe employees and potential employees who suddenly disappear. Typically, ghosting is used to describe: Job candidates who suddenly stop responding to messages. New hires who fail to show up for their first day of work. Employees who do not show up for a shift. Employees who leave work in the middle of the day and never come back. Some analysts blame ghosting on millennial entitlement. The reasoning is that members of the millennial generation have been brought up to feel they are special -- so special, in fact, that they do not need to follow conventional rules of behavior. Other analysts, however, maintain that ghosting behavior stems from changes in the job market and the phenomenon is simply a reflection of the laws of supply and demand in a healthy jo...
Post a Comment
Read more

Data deduplication

Data deduplication -- often called intelligent compression or single-instance storage -- is a process that eliminates redundant copies of data and reduces storage overhead. Data deduplication techniques ensure that only one unique instance of data is retained on storage media, such as disk, flash or tape. Redundant data blocks are replaced with a pointer to the unique data copy. In that way, data deduplication closely aligns with incremental backup, which copies only the data that has changed since the previous backup. For example, a typical email system might contain 100 instances of the same 1 megabyte (MB) file attachment. If the email platform is backed up or archived, all 100 instances are saved, requiring 100 MB of storage space. With data deduplication, only one instance of the attachment is stored; each subsequent instance is referenced back to the one saved copy. In this example, a 100 MB storage demand drops to 1 MB. Target vs. source deduplication Data deduplica...
Post a Comment
Read more

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...
Post a Comment
Read more