Context-and-version-aware facade for database queries

A computer program product for accessing versioned data objects within a database, comprising;

• a hardware computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising computer readable program code configured to:
• create a first new connection to a database stored in a memory, wherein the first new connection is configured with contextual information about data objects within the database and includes a first existing database connection, and wherein the first new connection is of a different connection type than the first existing database connection;
• grant a request for a database connection using the first new database connection;
• receive via the first new connection a first query from a first client, wherein the first query requests access to a versioned data object stored in the database;
• and
• modify the received first query to add contextual information configured on the first new connection, so that the modified first query is able to retrieve using the first existing database connection a first version of the versioned data object from among a plurality of versions of the versioned data object stored in the database, wherein the first version corresponds to the contextual information.

A system for accessing versioned data objects within a database, comprising:

• a database comprising a plurality of versioned data objects stored in memory;
• a first database client;
• a table comprising contextual information about the plurality of versioned data objects stored in memory;
• and
• a processor configured with logic to:
• create a first new connection to the database, wherein the first new connection is configured with contextual information from the table and includes a first existing database connection, and wherein the first new connection is of a different connection type than the first existing database connection;
• grant a request for a database connection using the first new database connection;
• receive via the first new connection a first query from the first database client, wherein the first query requests access to a versioned data object stored in the database;
• and
• modify the received first query to add contextual information configured on the first new connection, so that the modified first query is able to retrieve using the first existing database connection a first version of the versioned data object from among a plurality of versions of the versioned data object stored in the database, wherein the first version corresponds to the contextual information.