×

Positioned updates in a distributed shared-nothing data store

  • US 9,177,008 B1
  • Filed: 12/10/2014
  • Issued: 11/03/2015
  • Est. Priority Date: 06/29/2012
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • associating each row of a database table distributed among segments of a distributed data store with a respective segment identifier indicating a segment on which the row is stored;

    receiving one or more query statements including a declaration of a structured query language cursor and an update statement, the declaration including a select statement for retrieving one or more rows of data from the database table, the select statement including a field name identifying a data field for selection from the one or more rows, the cursor being defined for scrolling the data field of the one or more rows, the update statement including a statement for updating the data field of the one or more rows;

    transforming the select statement, including adding a segment identifier data field as a new data field in the select statement;

    transforming the update statement, including adding a respective segment identifier to each of the one or more rows of data retrieved by executing the transformed select statement, each segment identifier being retrieved according to the added segment identifier data field; and

    dispatching the transformed update statement to the segments.

View all claims
  • 3 Assignments
Timeline View
Assignment View
    ×
    ×