SOA driving interest in virtual data warehouses - Network World

Skip Links

DNSstuff.com
Get information about your IP
IP Information
50+ On-demand DNS and network tools

Software

Videos

rssRss Feed
Get instant email notification when white papers, webcasts, executive guides are added to our library.  Stay informed and up-to-date with the latest on IT Technologies with Network World's Resource Alerts.
Audio

Microsoft sniffing around Facebook? Google's Paris street photos may spark lawsuits. Listen now!

Network World 360

Tech vendors are like high school. Listen now!

Network World's Twisted Pair

Additional Resources

RSS

FEATURED REPORTS

Executive Guide: Storage Heats Up HP

Get the latest on storage technologies that allow IT professionals to better cope with new IT demands. Learn how storage technologies can help you successfully tackle e-Discover, regulatory compliance, green data center initiatives and the data explosion. Get all the details now.

RSS

FEATURED WEBCASTS

Discover how to Create an Orchestrated Data Center through Virtualization Novell

IT professionals like the idea of consolidating hundreds of servers into only a few, but it takes a lot more to cost effectively consolidate and virtualize servers. Watch this six-chapter webcast, "Reduce Complexity and Cost - Windows Server Consolidation with Virtualization" to learn how to effectively consolidate your Windows environment. One of the themes explored includes the characteristics of an orchestrated data center, which includes: Resource management, dynamic provisioning, job management, policy management, accounting and auditing and real-time availability. Learn more about orchestration and much more today. Register below to learn more and be entered to win an Archos 605 Portable Media Player.

IT Buyer's Guides

View All Buyer's Guides

Free Newsletters

Sign up and receive the latest news, reviews and trends on your favorite technology topics

Save The Date!
What They Are Saying

If Microsoft does nothing to fix the problem in a timely manner, that is wrong and makes for poor business...- Anonymous

Join the Discussion

Partner Content
CA logo

CA Network & Voice Resource Center

Comprehensive Network & Voice Management Visit CA Network & Voice Management Resource Center and get insights into industry best practices, information that helps you to address your challenges.

CA Network & Voice Management Resource Center

whitepaper

Managing Voice Over IP for Successful Convergence

Voice over IP (VoIP) has much to offer in cost savings but some customers have concerns about VoIP call quality compared to the quality of traditional voice services. This white paper will help you learn how to take the right steps so that voice quality is assured.

Managing VoIP for Successful Convergence

whitepaper

The Changing Face of Network Management

Managing your network is serious business. This paper discusses the benefits of integrating configuration change-awareness into your network fault management solution

Download Whitepaper

SOA driving interest in virtual data warehouses

Data federation keeps information in its place and allows for easier tweaking than traditional data warehouses, experts say.
By Ann Bednarz , Network World , 09/27/2006
  • Social Web 
  • Email 
  • Feedback 
  • Close

When the Minnesota Department of Agriculture needed to marry data from the state’s financial systems with its own laboratory management system for billing purposes, Kurt Wood considered using a data warehouse but balked at the manpower required to create and maintain multiple copies of the data sets. He found an alternative in data federation.

Data federation, or enterprise information integration, is the ability to access multiple data sources with a single query. It works like a virtual data warehouse: The data being queried remains in its place, rather than copied to a central repository, so companies don’t have to keep duplicate versions in sync. Under the covers, the software takes on tasks such as reconciling data formats, maintaining data integrity and building an aggregate view of information.

“We’re able to get real-time financial data from the state over the WAN, and we can manipulate it here," says Wood, data and application manager at the Department of Agriculture. The agency doesn’t have to worry about incompatible formats, because IBM’s data federation software handles the translations required to link data from DB2 and Oracle databases, nor does it have to fuss with extraction, transformation and load (ETL) tools.

“We could have gone with the ETL method, or passing text files, but we’ve got just a small staff of programmers here," Wood says. “When you do something like that, the data being transferred over can be old, or someone forgets to do it, or the transfer doesn’t go right and needs to be redone. We figured, why not just tap directly into the system?"

While it’s not a new concept, data federation is gaining attention as enterprises look to deploy service-oriented architecture (SOA) environments.

The demands of SOA are a good fit for data federation, says Ted Friedman, a research vice president at Gartner. “Just as you have application services and business services in an SOA, we believe you’ll also have data services that provide for common and consistent access to data, movement of data, transformation of data and so forth," Friedman says.

1 | 2 | 3 |  Next >
Comment
Login
Forgot your account info?
Add comment
Anonymous comments subject to moderator approval. Register here for member benefits.
Have a NetworkWorld account? Log in here. Register now for a free account.
First Name
Last Name
E-mail
Zip Code