Automated propagation of non-conflicting queries in distributed databases
First Claim
Patent Images
1. A computer-implemented method, comprising:
- receiving a logical table definition as part of a database query within a distributed database system;
determining whether the received logical table definition matches a local logical table definition;
processing the query in response to determining that the received logical table definition matches the local logical table definition; and
forwarding the query to at least one other distributed database node;
where determining whether the received logical table definition matches the local logical table definition comprises identifying at least one of a column name match and a column data type match between the received logical table definition and the local logical table definition; and
where processing the query in response to determining that the received logical table definition matches the local logical table definition comprises;
identifying a local physical table associated with the local logical table definition;
retrieving at least one data element from a local physical table storage location associated with the local physical table based upon a determination of at least one of the column name match and a column data type match between the received logical table definition and the local logical table definition; and
responding to the query with the retrieved at least one data element.
0 Assignments
0 Petitions
Accused Products
Abstract
A logical table definition is received as part of a database query within a distributed database system. A determination is made as to whether the received logical table definition matches a local logical table definition. The query is processed in response to determining that the received logical table definition matches the local logical table definition. The query is forwarded to at least one other distributed database node.
56 Citations
14 Claims
-
1. A computer-implemented method, comprising:
-
receiving a logical table definition as part of a database query within a distributed database system; determining whether the received logical table definition matches a local logical table definition; processing the query in response to determining that the received logical table definition matches the local logical table definition; and forwarding the query to at least one other distributed database node; where determining whether the received logical table definition matches the local logical table definition comprises identifying at least one of a column name match and a column data type match between the received logical table definition and the local logical table definition; and where processing the query in response to determining that the received logical table definition matches the local logical table definition comprises; identifying a local physical table associated with the local logical table definition; retrieving at least one data element from a local physical table storage location associated with the local physical table based upon a determination of at least one of the column name match and a column data type match between the received logical table definition and the local logical table definition; and responding to the query with the retrieved at least one data element. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A system, comprising:
-
a memory adapted to store information associated with propagation of non-conflicting queries in distributed databases; and
a processor programmed to;receive a logical table definition as part of a database query within a distributed database system; store the received logical table definition to the memory; determine whether the received logical table definition matches a local logical table definition; process the query in response to determining that the received logical table definition matches the local logical table definition; and forward the query to at least one other distributed database node; where, in being programmed to determine whether the received logical table definition matches the local logical table definition, the processor is programmed to identify at least one of a column name match and a column data type match between the received logical table definition and the local logical table definition; and where, in being programmed to process the query in response to determining that the received logical table definition matches the local logical table definition, the processor is programmed to; identify a local physical table associated with the local logical table definition; retrieve at least one data element from a local physical table storage location associated with the local physical table based upon a determination of at least one of a column name match and a column data type match between the received logical table definition and the local logical table definition; and respond to the query with the retrieved at least one data element. - View Dependent Claims (7, 8, 9)
-
-
10. A computer program product comprising a computer readable storage memory including computer readable program code, where the computer readable program code when executed on a computer causes the computer to:
-
receive a logical table definition as part of a database query within a distributed database system; determine whether the received logical table definition matches a local logical table definition; process the query in response to determining that the received logical table definition matches the local logical table definition; and forward the query to at least one other distributed database node; where in causing the computer to determine whether the received logical table definition matches a local logical table definition, the computer readable program code when executed on the computer causes the computer to identify at least one of a column name match and a column data type match between the received logical table definition and the local logical table definition; and where in causing the computer to process the query in response to determining that the received logical table definition matches the local logical table definition, the computer readable program code when executed on the computer causes the computer to; identify a local physical table associated with the local logical table definition; retrieve at least one data element from a local physical table storage location associated with the local physical table based upon the determination of at least one of the column name match and a column data type match between the received logical table definition and the local logical table definition; and respond to the query with the retrieved at least one data element. - View Dependent Claims (11, 12, 13, 14)
-
Specification