Patents by Inventor Haakon Roberts

Haakon Roberts 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).

  • Patent number: 10013475
    Abstract: Embodiments of the present invention disclose a computer program product for rebalancing partitioned data based, at least in part, on limit key extrapolation in a database and one or more characteristics of the plurality of database partitions. Responsive to a determination that an upper limit key value of the last loaded record is greater than an upper limit key value of an empty partition, the computer redefines the upper limit key value of the empty partition using an extrapolated upper limit key value that is based, at least in part, on a range of limit key values. The computer updates one or more characteristics of the database, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition.
    Type: Grant
    Filed: July 24, 2017
    Date of Patent: July 3, 2018
    Assignee: International Business Machines Corporation
    Inventors: Ka Chun Ng, Haakon Roberts
  • Patent number: 9870416
    Abstract: Embodiments of the present invention disclose a method, computer program product, and system for rebalancing partitioned data based, at least in part, on one or more characteristics of the plurality of database partitions. The computer updating characteristics, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition. Embodiments of the present invention disclose a method, computer program product, and system for limit key extrapolation in a database. Responsive to a determination that the upper limit key value of the last loaded record is greater than the first upper limit key value of the first empty partition, the computer redefines the first upper limit key value of the first empty partition by an extrapolated upper limit key value based, at least in part, on the range of limit key values.
    Type: Grant
    Filed: April 24, 2014
    Date of Patent: January 16, 2018
    Assignee: International Business Machines Corporation
    Inventors: Ka Chun Ng, Haakon Roberts
  • Publication number: 20170316077
    Abstract: Embodiments of the present invention disclose a computer program product for rebalancing partitioned data based, at least in part, on limit key extrapolation in a database and one or more characteristics of the plurality of database partitions. Responsive to a determination that an upper limit key value of the last loaded record is greater than an upper limit key value of an empty partition, the computer redefines the upper limit key value of the empty partition using an extrapolated upper limit key value that is based, at least in part, on a range of limit key values. The computer updates one or more characteristics of the database, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition.
    Type: Application
    Filed: July 24, 2017
    Publication date: November 2, 2017
    Inventors: Ka Chun Ng, Haakon Roberts
  • Patent number: 9734226
    Abstract: Embodiments of the present invention disclose a computer program product for rebalancing partitioned data based, at least in part, on limit key extrapolation in a database and one or more characteristics of the plurality of database partitions. Responsive to a determination that an upper limit key value of the last loaded record is greater than an upper limit key value of an empty partition, the computer redefines the upper limit key value of the empty partition using an extrapolated upper limit key value that is based, at least in part, on a range of limit key values. The computer updates one or more characteristics of the database, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition.
    Type: Grant
    Filed: October 31, 2016
    Date of Patent: August 15, 2017
    Assignee: International Business Machines Corporation
    Inventors: Ka Chun Ng, Haakon Roberts
  • Publication number: 20170039262
    Abstract: Embodiments of the present invention disclose a computer program product for rebalancing partitioned data based, at least in part, on limit key extrapolation in a database and one or more characteristics of the plurality of database partitions. Responsive to a determination that an upper limit key value of the last loaded record is greater than an upper limit key value of an empty partition, the computer redefines the upper limit key value of the empty partition using an extrapolated upper limit key value that is based, at least in part, on a range of limit key values. The computer updates one or more characteristics of the database, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition.
    Type: Application
    Filed: October 31, 2016
    Publication date: February 9, 2017
    Inventors: Ka Chun Ng, Haakon Roberts
  • Patent number: 9405817
    Abstract: Embodiments of the present invention disclose a method, computer program product, and system for rebalancing partitioned data based, at least in part, on one or more characteristics of the plurality of database partitions. The computer updating characteristics, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition. Embodiments of the present invention disclose a method, computer program product, and system for limit key extrapolation in a database. Responsive to a determination that the upper limit key value of the last loaded record is greater than the first upper limit key value of the first empty partition, the computer redefines the first upper limit key value of the first empty partition by an extrapolated upper limit key value based, at least in part, on the range of limit key values.
    Type: Grant
    Filed: January 27, 2016
    Date of Patent: August 2, 2016
    Assignee: International Business Machines Corporation
    Inventors: Ka Chun Ng, Haakon Roberts
  • Publication number: 20160132582
    Abstract: Embodiments of the present invention disclose a method, computer program product, and system for rebalancing partitioned data based, at least in part, on one or more characteristics of the plurality of database partitions. The computer updating characteristics, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition. Embodiments of the present invention disclose a method, computer program product, and system for limit key extrapolation in a database. Responsive to a determination that the upper limit key value of the last loaded record is greater than the first upper limit key value of the first empty partition, the computer redefines the first upper limit key value of the first empty partition by an extrapolated upper limit key value based, at least in part, on the range of limit key values.
    Type: Application
    Filed: January 27, 2016
    Publication date: May 12, 2016
    Inventors: Ka Chun Ng, Haakon Roberts
  • Publication number: 20150309999
    Abstract: Embodiments of the present invention disclose a method, computer program product, and system for rebalancing partitioned data based, at least in part, on one or more characteristics of the plurality of database partitions. The computer updating characteristics, wherein the one or more characteristics include one or both of a) an average number of records per partition, and b) an average number of unique limit key values per partition. Embodiments of the present invention disclose a method, computer program product, and system for limit key extrapolation in a database. Responsive to a determination that the upper limit key value of the last loaded record is greater than the first upper limit key value of the first empty partition, the computer redefines the first upper limit key value of the first empty partition by an extrapolated upper limit key value based, at least in part, on the range of limit key values.
    Type: Application
    Filed: April 24, 2014
    Publication date: October 29, 2015
    Applicant: International Business Machines Corporation
    Inventors: Ka Chun Ng, Haakon Roberts
  • Publication number: 20070118574
    Abstract: Provided are a techniques for reorganizing data. Data is retrieved from an original data set and inserted into a shadow data set. A log record is read from an update log, wherein the log record includes a unique key identifying a data object and an indication of an activity associated with that data object. The activity associated with the data object is performed by determining whether the unique key is found in a shadow index for the shadow data set.
    Type: Application
    Filed: November 22, 2005
    Publication date: May 24, 2007
    Inventors: William Franklin, Haakon Roberts, James Teng, Jay Yothers
  • Publication number: 20070055687
    Abstract: A system, method and a computer usable medium tangibly embodying a program of instructions executable by the computer to perform a computer-based method for restoration of a database from a failed data recovery. For each failed data recovery the method generates a log error data set having log records of a faulty transaction unapplied to data due to inconsistency. Log error data set is directly useable by a log analysis tool to regenerate and redo the unapplied faulty transaction to recover the data and by a print log tool to diagnose the faulty transaction. Log records mimic format of records of an archive log data set and identify data objects, faulty transactions on the data objects and a range of the unapplied data objects' updates.
    Type: Application
    Filed: September 2, 2005
    Publication date: March 8, 2007
    Applicant: International Business Machines Corporation
    Inventors: Jeffrey Josten, Laura Kunioka-Weis, Thomas Majithia, Haakon Roberts, James Teng