×

Database query optimizer that takes network choice into consideration

  • US 10,452,654 B2
  • Filed: 02/18/2013
  • Issued: 10/22/2019
  • Est. Priority Date: 12/05/2006
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method for executing a query to a distributed database in a networked computer system that is coupled to a plurality of networks, the method comprising the steps of:

  • (A) providing a plurality of nodes coupled to the plurality of networks, each of the plurality of networks comprising a communication path between at least two of the plurality of nodes, each node comprising at least one processor and memory, the plurality of nodes comprising the distributed database with a first node including first data in the distributed database and a second node including second data in the distributed database, the plurality of networks allowing communication between the plurality of nodes, wherein first and second of the plurality of networks provide alternative network connections to the first node;

    (B) on a third of the plurality of nodes, executing the query that retrieves the first data in the distributed database and the second data in the distributed database by performing the steps of;

    (B1) determining characteristics of the plurality of networks between the first, second and third nodes; and

    (B2) selecting at least one of the plurality of networks for executing the query to the distributed database according to the characteristics of the plurality of networks between at least two nodes involved in processing the query and according to historical information that includes which of the plurality of networks were used during at least one previous execution of a query.

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