Automated query path reporting in distributed databases
First Claim
Patent Images
1. A method, comprising:
- forwarding a database path reporting query, comprising a logical table definition that maps to at least one physical table within at least one distributed database node and at least one route tracing indicator that specifies distributed route tracing information to be returned in response to the forwarded database path reporting query, to the at least one distributed database node within a distributed network of databases;
receiving at least one path reporting query response comprising the distributed route tracing information associated with each distributed database node that processed the forwarded database path reporting query along a path associated with the at least one path reporting query response;
processing the received distributed route tracing information to characterize query route propagation within the distributed network of databases;
identifying local route tracing information based upon the at least one route tracing indicator,where identifying the local route tracing information based upon the at least one route tracing indicator comprises;
mapping the database path reporting query into a database count query that specifies return of a number of rows that match a count query criterion within the database count query;
executing the database count query against a local database, where the database count query returns the number of rows of the local database that match the count query criterion; and
forming the local route tracing information using the number of rows of the local database that match the count query criterion;
combining the identified local route tracing information with the distributed route tracing information of the at least one path reporting query response; and
returning the at least one path reporting query response to at least one of a distributed database node and an application-level module.
1 Assignment
0 Petitions
Accused Products
Abstract
A database query comprising a logical table definition and at least one route tracing indicator is forwarded to at least one distributed database node within a distributed network of databases. At least one query response is received including distributed route tracing information associated with each distributed database node that processed the database query along a path associated with the at least one query response. The received distributed route tracing information is processed to characterize query route propagation within the distributed network of databases. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.
-
Citations
16 Claims
-
1. A method, comprising:
-
forwarding a database path reporting query, comprising a logical table definition that maps to at least one physical table within at least one distributed database node and at least one route tracing indicator that specifies distributed route tracing information to be returned in response to the forwarded database path reporting query, to the at least one distributed database node within a distributed network of databases; receiving at least one path reporting query response comprising the distributed route tracing information associated with each distributed database node that processed the forwarded database path reporting query along a path associated with the at least one path reporting query response; processing the received distributed route tracing information to characterize query route propagation within the distributed network of databases; identifying local route tracing information based upon the at least one route tracing indicator, where identifying the local route tracing information based upon the at least one route tracing indicator comprises; mapping the database path reporting query into a database count query that specifies return of a number of rows that match a count query criterion within the database count query; executing the database count query against a local database, where the database count query returns the number of rows of the local database that match the count query criterion; and forming the local route tracing information using the number of rows of the local database that match the count query criterion; combining the identified local route tracing information with the distributed route tracing information of the at least one path reporting query response; and returning the at least one path reporting query response to at least one of a distributed database node and an application-level module. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A system, comprising:
-
a memory adapted to store data path query reporting information; and a processor programmed to; forward a database path reporting query, comprising a logical table definition that maps to at least one physical table within at least one distributed database node and at least one route tracing indicator that specifies distributed route tracing information to be returned in response to the forwarded database path reporting query, to the at least one distributed database node within a distributed network of databases; receive at least one query path reporting response comprising the distributed route tracing information associated with each distributed database node that processed the forwarded database path reporting query along a path associated with the at least one path reporting query response; process the received distributed route tracing information to characterize query route propagation within the distributed network of databases; identify local route tracing information based upon the at least one route tracing indicator, where in being programmed to identify the local route tracing information based upon the at least one route tracing indicator, the processor is programmed to; map the database path reporting query into a database count query that specifies return of a number of rows that match a count query criterion within the database count query; execute the database count query against a local database, where the database count query returns the number of rows of the local database that match the count query criterion; and form the local route tracing information using the number of rows of the local database that match the count query criterion; and where the processor is further programmed to; combine the identified local route tracing information with the distributed route tracing information of the at least one path reporting query response; return the at least one path reporting query response to at least one of a distributed database node and an application-level module; and store the processed distributed route tracing information to the memory. - View Dependent Claims (10, 11, 12, 13, 14, 15)
-
-
16. A system, comprising:
-
a memory adapted to store data path query reporting information; and a processor programmed to; forward a database path reporting query, comprising a logical table definition that maps to at least one physical table within at least one distributed database node and at least one route tracing indicator that specifies distributed route tracing information to be returned in response to the forwarded database path reporting query, to the at least one distributed database node within a distributed network of databases; receive at least one path reporting query response comprising the distributed route tracing information associated with each distributed database node that processed the forwarded database path reporting query along a path associated with the at least one query path reporting response; process the received distributed route tracing information to characterize query route propagation within the distributed network of databases; map the database path reporting query into a database count query that specifies return of a number of rows that match a count query criterion within the database count query; execute the database count query against a local database, where the database count query returns the number of rows of the local database that match the count query criterion; identify local route tracing information using the number of rows of the local database that match the count query criterion; combine the identified local route tracing information with the distributed route tracing information of the at least one query path reporting response;
store the combined route tracing information to the memory; andreturn the at least one path reporting query response to at least one of a distributed database node and an application-level module.
-
Specification