Query rebinding for high-availability database systems

A computer-implemented method for managing execution of queries querying physical data logically represented by a data abstraction model, comprising:

• receiving a first abstract query against queryable data in a data warehouse, the first abstract query having one or more result fields configured to return requested data from the data warehouse, each result field having a corresponding logical field specification of a first data abstraction model, wherein each corresponding logical field specification describes an access method for accessing physical data in the data warehouse;
• in response to receiving the first abstract query and determining that the first abstract query is configured for retrieving data from the data warehouse, detecting whether the data warehouse is available;
• and
• if the data warehouse is unavailable:
• creating, on the basis of the first abstract query, a second abstract query against physical data in an operational data store containing all the queryable data of the data warehouse, wherein the data warehouse and the operational data store use differently structured data structures, the second abstract query having one or more result fields configured to return the requested data from the operational data store, each result field of the second abstract query having a corresponding logical field specification of a second data abstraction model abstractly describing the operational data store, wherein each corresponding logical field specification describes an access method for accessing physical data in the operational data store;
• and
• executing the second abstract query against the operational data store to obtain the requested data.

A computer-readable medium containing a program which, when executed by a processor, performs operations for managing execution of queries querying physical data logically represented by a data abstraction model, the operations comprising:

• receiving a first abstract query against physical data in a first data source, the first abstract query having one or more result fields configured to return requested data from the first data source, each result field having a corresponding logical field specification of a first data abstraction model, wherein each corresponding logical field specification describes an access method for accessing physical data in the first data source;
• in response to receiving the first abstract query and determining that the first abstract query is configured for retrieving data from the first data source, detecting whether the first data source is available;
• and
• if the first data source is unavailable:
• creating, on the basis of the first abstract query, a second abstract query against physical data in a second data source containing at least a portion of the requested data, the second abstract query having one or more result fields configured to return at least the portion of the requested data from the second data source, each result field of the second abstract query having a corresponding logical field specification of a second data abstraction model abstractly describing the second data source, wherein each corresponding logical field specification describes an access method for accessing physical data in the second data source;
• and
• executing the second abstract query against the second data source to obtain at least the portion of the requested data.

A system, comprising:

• a first data source having physical data;
• a second data source having physical data including at least some of the physical data contained in the first data source;
• and
• a query builder component for managing execution of queries querying physical data logically represented by a data abstraction model, the query builder component being configured to:
• receive a first abstract query against the physical data in the first data source, the first abstract query having one or more result fields configured to return requested data from the first data source, each result field having a corresponding logical field specification of a first data abstraction model, wherein each corresponding logical field specification describes an access method for accessing physical data in the first data source;
• detect, in response to receiving the first abstract query and determining that the first abstract query is configured for retrieving data from the first data source, whether the first data source is available;
• and
• if the first data source is unavailable:
• create, on the basis of the first abstract query, a second abstract query against the physical data in the second data source containing at least a portion of the requested data, the second abstract query having one or more result fields configured to return at least the portion of the requested data from the second data source, each result field of the second abstract query having a corresponding logical field specification of a second data abstraction model abstractly describing the second data source, wherein each corresponding logical field specification describes an access method for accessing physical data in the second data source;
• and
• execute the second abstract query against the second data source to obtain at least the portion of the requested data.