Federated query management

1. A computer-implemented method comprising:

generating, by execution of one or more computer processors, a federated query targeting a plurality of databases identified by respective names in the federated query;

saving the federated query with a list of the targeted databases in a federated query database;

retrieving the saved federated query from the federated query database;

transforming the retrieved federated query from a query consistent with a first data representation to a query consistent with a second data representation;

determining availability of the targeted databases; and

upon determining unavailability of any of the targeted databases, notifying a user; and

upon determining availability of all of the targeted databases:

parsing the transformed federated query into subqueries, each subquery targeted to run against a respective one of the targeted databases;

converting at least one of the subqueries from XML to a subquery consistent with a data representation associated with the respective database targeted by the subquery; and

executing the subqueries.

2. A method, comprising integrating computer readable code onto a computer readable storage medium of a computing system, wherein the code in combination with the computing system is adapted to perform the method of claim 1 .

3. A computer-implemented method for accessing data, comprising:

generating, by execution of one or more computer processors, a federated query targeting a plurality of databases identified by respective names in the federated query;

saving the federated query with a list of the targeted databases in a federated query database stored on one or more computer readable storage media, wherein saving comprises first transforming the federated query from a query consistent with a first data representation to a query consistent with an XML representation;

determining availability of the targeted databases prior to executing the saved federated query; and

upon determining that one or more of the targeted databases are not available, programmatically modifying the saved federated query to run against available databases, wherein modifying comprises: parsing the saved federated query into subqueries, each subquery targeted to run against a respective one of the targeted databases; converting at least one of the subqueries from the XML representation to a subquery consistent with a data representation associated with the database targeted by the subquery; and executing the subqueries.

4. The computer-implemented method of claim 3 , wherein modifying the saved federated query to run against available databases comprises modifying the federated query to run against a backup database of an unavailable targeted database.

5. The computer-implemented method of claim 4 , wherein determining the availability of the targeted databases comprises executing a query against each of the targeted databases.

6. The computer-implemented method of claim 5 , further comprising:

providing, to a user one, or more graphical user interface (GUI) screens presenting a list of previously saved federated queries; and

receiving, from the user, a selected one of the previously saved federated queries targeting one or more databases;

retrieving the selected federated query from the federated query database;

determining availability of the targeted databases targeted by the selected federated query; and

if any of the targeted databases are unavailable, providing to the user one or more graphical user interface (GUI) screens notifying the user of the unavailability of the targeted databases.

7. A computer-readable storage media tangibly bearing computer-executable instructions for performing the computer implemented method of claim 3 .

8. A method, comprising integrating computer readable code onto a computer readable storage medium of a computing system, wherein the computer readable code in combination with the computing system is adapted to perform the method of claim 3 .

9. A computer readable storage medium containing a program which, when executed by a processor, performs a method, comprising:

generating, by execution of one or more computer processors, a federated query targeting a plurality of databases identified by respective names in the federated query;

saving the federated query with a list of the targeted databases in a federated query database;

retrieving the saved federated query from the federated query database;

transforming the retrieved federated query from a query consistent with a first data representation to a query consistent with a second data representation;

determining availability of the targeted databases; and

upon determining unavailability of any of the targeted databases, notifying a user; and

upon determining availability of all of the targeted databases:

parsing the transformed federated query into subqueries, each subquery targeted to run against a respective one of the targeted databases;

converting at least one of the subqueries from XML to a subquery consistent with a data representation associated with the respective database targeted by the subquery; and

executing the subqueries.