×

Node-level sub-queries in distributed databases

  • US 9,471,647 B2
  • Filed: 09/30/2015
  • Issued: 10/18/2016
  • Est. Priority Date: 10/09/2008
  • Status: Expired due to Fees
First Claim
Patent Images

1. A computer program product, comprising:

  • a non-transitory computer readable storage memory having computer readable program code embodied therewith, where the computer readable program code when executed on a computer causes the computer to;

    receive a database logical query comprising a logical query indicator at a distributed database management system (DBMS) within a distributed network of database management systems, where the logical query indicator encapsulates within the received database logical query at least one physical database query and the logical query indicator further comprises at least one provenance indicator that instructs distributed database management systems that process the at least one encapsulated physical database query to add a database management system identifier to query responses, and the database logical query comprises at least one database management system identifier that identifies at least one distributed DBMS to execute the encapsulated physical database query against a physical database managed by the at least one distributed DBMS;

    determine that the at least one database management system identifier matches a local database management system identifier;

    execute the at least one encapsulated physical database query against at least one local physical database table within the physical database managed by the at least one distributed DBMS;

    form a local query response comprising data retrieved from the at least one local physical database table;

    add the local database management system identifier to the local query response in response to the at least one provenance indicator; and

    respond to the database logical query with at least the local query response.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×