DYNAMIC CONTEXT DEFINITIONS IN DISTRIBUTED DATABASES
First Claim
1. A method, comprising:
- receiving a database query comprising a logical table identifier at a distributed database node within a distributed network of databases, where the logical table identifier comprises a dynamically-updatable constant column identifier;
filtering local logical table definitions based upon the logical table identifier and the dynamically-updatable constant column identifier to identify a local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier;
forming a local query response to the database query comprising data retrieved from a local physical database table mapped by the local logical table in response to identifying the local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier; and
responding to the database query, in response to forming the local query response, with the local query response.
1 Assignment
0 Petitions
Accused Products
Abstract
A database query is received including a logical table identifier at a distributed database node within a distributed network of databases. The logical table identifier includes a dynamically-updatable constant column identifier. Local logical table definitions are filtered based upon the logical table identifier and the dynamically-updatable constant column identifier to identify a local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier. A local query response is formed including data retrieved from a local physical database table mapped by the local logical table in response to identifying the local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier. The database query is responded to, in response to forming the local query response, with at least the local query response. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.
61 Citations
20 Claims
-
1. A method, comprising:
-
receiving a database query comprising a logical table identifier at a distributed database node within a distributed network of databases, where the logical table identifier comprises a dynamically-updatable constant column identifier; filtering local logical table definitions based upon the logical table identifier and the dynamically-updatable constant column identifier to identify a local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier; forming a local query response to the database query comprising data retrieved from a local physical database table mapped by the local logical table in response to identifying the local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier; and responding to the database query, in response to forming the local query response, with the local query response. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system, comprising:
-
a memory adapted to store context information for logical queries; and a processor programmed to; receive a database query comprising a logical table identifier at a distributed database node within a distributed network of databases, where the logical table identifier comprises a dynamically-updatable constant column identifier; filter local logical table definitions based upon the logical table identifier and the dynamically-updatable constant column identifier to identify a local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier; form a local query response to the database query comprising data retrieved from a local physical database table mapped by the local logical table in response to identifying the local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier; store the local query response to the memory; and respond to the database query, in response to forming the local query response, with the local query response. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A system, comprising:
-
a memory adapted to store context information for logical queries; and a processor programmed to; receive a database query comprising a logical table identifier at a distributed database node within a distributed network of databases, where the logical table identifier comprises a dynamically-updatable constant column identifier; filter local logical table definitions based upon the logical table identifier and the dynamically-updatable constant column identifier to identify a local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier; and in response to identifying the local logical table associated with the logical table identifier and the dynamically-updatable constant column identifier; form a local query response to the database query comprising data retrieved from a local physical database table mapped by the local logical table; store the local query response to the memory; make an application programming interface (API) call to generate a query targeting a distributed logical table definition, where the API call comprises a database group name; create a constant column associated with the local logical table with the database group name as a column name for the constant column to join a database group associated with the database group name; receive an API response; and respond to the database query with the local query response.
-
Specification