Patents by Inventor Ka Chun Ng

Ka Chun Ng 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