Essential Guide

Exploring data virtualization tools and technologies

A comprehensive collection of articles, videos and more, hand-picked by our editors

virtual (federated) database

A virtual database, also called a federated database, is a system in which several databases appear to function as a single entity.

A virtual database, also called a federated database, is a way to view and query several databases as if they were a single entity. 

The goal of working in a virtual database is to be able to look at data in a more unified way without having to duplicate it across multiple databases or manually combine the results from multiple queries. In a homogenous environment, virtual databases can help distribute the load of very large databases

Each component database in the system is completely self-sustained and functional. When an application queries a virtual database, the system figures out which of its component databases contains the data being requested and passes the request to it. The biggest challenge to building a virtual database is that the developer needs to first build a universal data model. The data model serves as a map to every source of data within the company. Finding a single schema that can address all of a company’s data needs can be difficult, particularly if data is dirty.

Integrating disparate databases under a centralized console offers several benefits. First, federated databases offer an alternative to merging databases together, which can be a tedious task. Second, they help programmers avoid the tight coupling of applications with legacy databases by eliminating vendor and schema lock-in. Applications can be written to target the intermediary layer – the virtual database – as opposed to a specific database by a specific vendor. Finally, applications need only to be connected to the virtual database in order to work with data from multiple databases. 

See also: data federation technology, online analytical processing (OLAP), multidimensional database (MDB), virtual private database (VPD)

This was first published in February 2011

Continue Reading About virtual (federated) database

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Essential Guide

Exploring data virtualization tools and technologies

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

File Extensions and File Formats

Powered by:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close