Patents by Inventor Jeffrey Shute

Jeffrey Shute has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Systems and methods for asynchronous schema changes
    Patent number: 9244953
    Abstract: This disclosure provides systems and methods for updating database servers with schema changes to avoid concurrency anomalies. The system may receive a snapshot of a table to be updated with a new schema, wherein the snapshot is taken at a given time, and wherein the table includes a number of rows. The system may then read each row from the snapshot and read each row from the table to be updated at a second time. The system may then compare the rows read from the snapshot to the rows read from the table at the second time. Furthermore, the system may determine, based on the comparison, the rows from the snapshot that have not changed between the given time and the second time. The system may then write the rows that have not changed to the table to be updated.
    Type: Grant
    Filed: August 5, 2014
    Date of Patent: January 26, 2016
    Assignee: Google Inc.
    Inventors: Radek Vingralek, Jeffrey Shute, Eric Christopher Rollins, Sukhdeep Sodhi, Ian Rae
  • SYSTEMS AND METHODS FOR ASYNCHRONOUS SCHEMA CHANGES
    Publication number: 20140344311
    Abstract: This disclosure provides systems and methods for updating database servers with schema changes to avoid concurrency anomalies. The system may receive a snapshot of a table to be updated with a new schema, wherein the snapshot is taken at a given time, and wherein the table includes a number of rows. The system may then read each row from the snapshot and read each row from the table to be updated at a second time. The system may then compare the rows read from the snapshot to the rows read from the table at the second time. Furthermore, the system may determine, based on the comparison, the rows from the snapshot that have not changed between the given time and the second time. The system may then write the rows that have not changed to the table to be updated.
    Type: Application
    Filed: August 5, 2014
    Publication date: November 20, 2014
    Inventors: Radek Vingralek, Jeffrey Shute, Eric Christopher Rollins, Sukhdeep Sodhi, Ian Rae
  • Systems and methods for asynchronous schema changes
    Patent number: 8832159
    Abstract: This disclosure provides systems and methods for updating database servers with schema changes to avoid concurrency anomalies. The system may receive a snapshot of a table to be updated with a new schema, wherein the snapshot is taken at a given time, and wherein the table includes a number of rows. The system may then read each row from the snapshot and read each row from the table to be updated at a second time. The system may then compare the rows read from the snapshot to the rows read from the table at the second time. Furthermore, the system may determine, based on the comparison, the rows from the snapshot that have not changed between the given time and the second time. The system may then write the rows that have not changed to the table to be updated.
    Type: Grant
    Filed: September 14, 2012
    Date of Patent: September 9, 2014
    Assignee: Google Inc.
    Inventors: Radek Vingralek, Jeffrey Shute, Eric Christopher Rollins, Sukhdeep Sodhi, Ian Rae
  • SYSTEMS AND METHODS FOR ASYNCHRONOUS SCHEMA CHANGES
    Publication number: 20130318129
    Abstract: This disclosure provides systems and methods for updating database servers with schema changes to avoid concurrency anomalies. The system may receive a snapshot of a table to be updated with a new schema, wherein the snapshot is taken at a given time, and wherein the table includes a number of rows. The system may then read each row from the snapshot and read each row from the table to be updated at a second time. The system may then compare the rows read from the snapshot to the rows read from the table at the second time. Furthermore, the system may determine, based on the comparison, the rows from the snapshot that have not changed between the given time and the second time. The system may then write the rows that have not changed to the table to be updated.
    Type: Application
    Filed: September 14, 2012
    Publication date: November 28, 2013
    Applicant: GOOGLE INC.
    Inventors: Radek Vingralek, Jeffrey Shute, Eric Christopher Rollins, Sukhdeep Sodhi, Ian Rae