Dynamic context definitions in distributed databases
First Claim
1. A method, comprising:
- receiving a database query comprising a logical table identifier and a dynamically-updatable constant column identifier at a distributed database node within a distributed network of databases, where the received dynamically-updatable constant column identifier specifies a requested context matching criterion to identify runtime-updatable constant columns with matching context within logical tables with identical logical table names within the distributed network of databases and where the runtime-updatable constant columns are updatable during a system runtime of use of the distributed network of databases without taking distributed database nodes out of service to allow runtime context changes for the logical tables within the distributed network of databases;
filtering local logical table definitions to identify a local logical table with a table name that matches the received logical table identifier and that comprises a locally-defined dynamically-updatable constant column identifier that matches the received 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 with the table name that matches the received logical table identifier and that comprises the locally-defined dynamically-updatable constant column identifier that matches the received dynamically-updatable constant column identifier;
responding to the database query, in response to forming the local query response, with the local query response; and
making an application programming interface (API) call to generate a query targeting a distributed logical table definition from a logical node level of the distributed database node and receiving an API response, where the API call comprises an indication to a database node level of the distributed database node to change a dynamically-updatable data value associated with a runtime-updatable constant column of the local logical table and a new data value, and further comprising, at the database node level in response to the API call, updating the dynamically-updatable data value associated with the runtime-updatable constant column of the local logical table with the new data value during the system runtime.
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.
-
Citations
18 Claims
-
1. A method, comprising:
-
receiving a database query comprising a logical table identifier and a dynamically-updatable constant column identifier at a distributed database node within a distributed network of databases, where the received dynamically-updatable constant column identifier specifies a requested context matching criterion to identify runtime-updatable constant columns with matching context within logical tables with identical logical table names within the distributed network of databases and where the runtime-updatable constant columns are updatable during a system runtime of use of the distributed network of databases without taking distributed database nodes out of service to allow runtime context changes for the logical tables within the distributed network of databases; filtering local logical table definitions to identify a local logical table with a table name that matches the received logical table identifier and that comprises a locally-defined dynamically-updatable constant column identifier that matches the received 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 with the table name that matches the received logical table identifier and that comprises the locally-defined dynamically-updatable constant column identifier that matches the received dynamically-updatable constant column identifier; responding to the database query, in response to forming the local query response, with the local query response; and making an application programming interface (API) call to generate a query targeting a distributed logical table definition from a logical node level of the distributed database node and receiving an API response, where the API call comprises an indication to a database node level of the distributed database node to change a dynamically-updatable data value associated with a runtime-updatable constant column of the local logical table and a new data value, and further comprising, at the database node level in response to the API call, updating the dynamically-updatable data value associated with the runtime-updatable constant column of the local logical table with the new data value during the system runtime. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. 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 and a dynamically-updatable constant column identifier at a distributed database node within a distributed network of databases, where the received dynamically-updatable constant column identifier specifies a requested context matching criterion to identify runtime-updatable constant columns with matching context within logical tables with identical logical table names within the distributed network of databases and where the runtime-updatable constant columns are updatable during a system runtime of use of the distributed network of databases without taking distributed database nodes out of service to allow runtime context changes for the logical tables within the distributed network of databases; filter local logical table definitions to identify a local logical table with a table name that matches the received logical table identifier and that comprises a locally-defined dynamically-updatable constant column identifier that matches the received 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 with the table name that matches the received logical table identifier and that comprises the locally-defined dynamically-updatable constant column identifier that matches the received dynamically-updatable constant column identifier; store the local query response to the memory; respond to the database query, in response to forming the local query response, with the local query response; and make an application programming interface (API) call to generate a query targeting a distributed logical table definition from a logical node level of the distributed database node and receiving an API response, where the API call comprises an indication to a database node level of the distributed database node to change a dynamically-updatable data value associated with a runtime-updatable constant column of the local logical table and a new data value, and where the processor is further programmed to, at the database node level in response to the API call, update the dynamically-updatable data value associated with the runtime-updatable constant column of the local logical table with the new data value during the system runtime. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17)
-
-
18. 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 and a dynamically-updatable constant column identifier at a distributed database node within a distributed network of databases, where the received dynamically-updatable constant column identifier specifies a requested context matching criterion for further filtering of logical tables with identical logical table names within the distributed network of databases; filter local logical table definitions to identify a local logical table with a table name that matches the received logical table identifier and that comprises a locally-defined dynamically-updatable constant column identifier that matches the received dynamically-updatable constant column identifier; and in response to identifying the local logical table with the table name that matches the received logical table identifier and that comprises the locally-defined dynamically-updatable constant column identifier that matches the received 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 from a logical node level of the distributed database node to a database node level of the distributed database node, where the API call comprises a database group name; create, at the database node level in response to the API call, 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 at the logical node level of the distributed database node; and respond to the database query with the local query response.
-
Specification