Advertisement
Promo

Become a member of the ZDNet UK community

Alena Semeshko

View blog's RSS Feed

Data Integration Blog

In this blog you can find posts with useful links to, news on and analysis of things like data integration, mashups, data quality, data warehousing, application integration (EAI), data management…the list goes on.

Tuesday 30 September 2008, 2:41 PM

Data Federation vs. Data Integration?

Posted by Alena Semeshko

Data federation and data integration. What's the difference between the two?

I understand data federation as something that joins data from different sources distributed around the company without actually moving it from the original source. That is to say, data federation software creates a single repository that doesn't contain the data itself, rather its metadata (information about the actual data/its location). This technology allows users to have a single standardized view of data displayed in a single data layer without having to deal with the variety of original data sources.

James Kobielus in his ZDNet blog explores the core difference between the enterprise data warehousing (EDW) and data federation.

Data federation generally seems outdated, compared to data warehousing, which at first looks like a more reasonable approach:

Federated environments are not optimized for heavy-hitting data matching, merging, transformation and cleansing, all of which are essential functions to deliver a “single version of the truth” for business intelligence (BI).

However, James also lists the benefits data federation may deliver in the company's overall Business Intelligence strategy:

Data federation is an umbrella term for a wide range of operational BI topologies that provide decentralized, on-demand alternatives to the centralized, batch-oriented architectures characteristic of traditional EDW environments.

In the real world, dara federation and EDW are not that mutually exclusive, and may very well target different markets, as data federation is better suited to near-real-time BI requirements than the batch-oriented EDWs deployed in many organizations.

So, where does data integration fit in the picture? Certain aspects of data integration intersect with both of the technologies discussed above. On the one hand, data integration may very well involve copying and moving data around, which is contrary to the definition of data federation, yet fits very well into the concept of data warehousing. On the other hand, data federation is in many aspects only a single instance of data integration in that the metadata it uses can be employed in the integration processes.


Next

Previous


Comments on this post

Alena Semeshko
  • Alena Semeshko
  • Sales / Marketing
  • Member since: July 2008

Site Activity Rating 3

Contacts

Number of Contacts: 3

Contacts' Latest Discussions

Number of Tracked Discussions: 1,041

ator1940 ator1940

Did not say it was.

Friday 6 November 2009, 2:13 PM

15 comments
ator1940 ator1940

Human error can be avoided.

Friday 6 November 2009, 1:49 PM

3 comments
ator1940 ator1940

MS Stuffs OOXML JTC1/SC34 Maintenance...

Thursday 5 November 2009, 3:42 PM

1 comment

Contacts' Latest Blogs

Number of Contacts Blogs: 2

Avatar ator1940

Open Virtual Desktop

Friday 21 November 2008, 4:19 AM

2 comments

Skip Sub Navigation Links to CNET Brand Links

Help

Become part of the ZDNet community.

Newsletters