Patents by Inventor John J. Campbell

John J. Campbell 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: 10929370
    Abstract: Disclosed aspects relate to index maintenance management of a relational database management system having a set of indexes. A subset of the set of indexes, which is indicated as a non-critical index subset, is detected with respect to the set of indexes. Related to maintenance of the subset of the set of indexes, a determination is made to perform an index maintenance impact action. Corresponding to the subset of the set of indexes, the index maintenance impact action is performed.
    Type: Grant
    Filed: April 14, 2016
    Date of Patent: February 23, 2021
    Assignee: International Business Machines Corporation
    Inventors: Saghi Amirsoleymani, John J. Campbell, Andrei F. Lurie, Terence P. Purcell
  • Patent number: 10585870
    Abstract: Rows are inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for updating data of the inserted rows, wherein reserving the second space includes reserving the second space on the page responsive to inserting each of the rows.
    Type: Grant
    Filed: November 29, 2016
    Date of Patent: March 10, 2020
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Charles R. Bonner, John J. Campbell, Frances H. Villafuerte, Maryela E. Weihrauch
  • Patent number: 9917885
    Abstract: According to one embodiment of the present invention, a system compares database transactions to corresponding performance information to identify conforming database transactions with an acceptable deviation from the performance information and outlier database transactions beyond the acceptable deviation from the performance information. The system aggregates information from a threshold quantity of conforming database transactions into an aggregated record, wherein the threshold quantity is dynamically adjusted, and generates a record for each outlier database transaction, wherein conditions for identifying the outlier database transactions are dynamically adjusted. Embodiments of the present invention further include a method and computer program product for managing database transactions in substantially the same manners described above.
    Type: Grant
    Filed: July 30, 2013
    Date of Patent: March 13, 2018
    Assignee: International Business Machines Corporation
    Inventors: John J. Campbell, Daniel Kozin, Nigel G. Slinger, John B. Tobler
  • Patent number: 9892145
    Abstract: A row is inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for adding data to the inserted row, wherein reserving the second space includes reserving the second space on the page responsive to inserting the row, so that the amount of space reserved for adding data to inserted rows grows as more rows are inserted. The page is marked full for the second space independently of whether the first space is full for inserting new rows. Data is added to rows on the page, responsive to detecting that the second space is full, by adding the data to one or more new pages, even though rows may still be inserted on the page using any remaining room in the first space on the page.
    Type: Grant
    Filed: September 10, 2016
    Date of Patent: February 13, 2018
    Assignee: International Business Machines Corporation
    Inventors: Charles R. Bonner, John J. Campbell, Frances H. Villafuerte, Maryela E. Weihrauch
  • Publication number: 20170300517
    Abstract: Disclosed aspects relate to index maintenance management of a relational database management system having a set of indexes. A subset of the set of indexes, which is indicated as a non-critical index subset, is detected with respect to the set of indexes. Related to maintenance of the subset of the set of indexes, a determination is made to perform an index maintenance impact action. Corresponding to the subset of the set of indexes, the index maintenance impact action is performed.
    Type: Application
    Filed: April 14, 2016
    Publication date: October 19, 2017
    Inventors: Saghi Amirsoleymani, John J. Campbell, Andrei F. Lurie, Terence P. Purcell
  • Patent number: 9774662
    Abstract: According to one embodiment of the present invention, a system compares database transactions to corresponding performance information to identify conforming database transactions with an acceptable deviation from the performance information and outlier database transactions beyond the acceptable deviation from the performance information. The system aggregates information from a threshold quantity of conforming database transactions into an aggregated record, wherein the threshold quantity is dynamically adjusted, and generates a record for each outlier database transaction, wherein conditions for identifying the outlier database transactions are dynamically adjusted. Embodiments of the present invention further include a method and computer program product for managing database transactions in substantially the same manners described above.
    Type: Grant
    Filed: September 22, 2014
    Date of Patent: September 26, 2017
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: John J. Campbell, Daniel Kozin, Nigel G. Slinger, John B. Tobler
  • Publication number: 20170083556
    Abstract: Rows are inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for updating data of the inserted rows, wherein reserving the second space includes reserving the second space on the page responsive to inserting each of the rows.
    Type: Application
    Filed: November 29, 2016
    Publication date: March 23, 2017
    Inventors: Charles R. Bonner, John J. Campbell, Frances H. Villafuerte, Maryela E. Weihrauch
  • Publication number: 20160378779
    Abstract: A row is inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for adding data to the inserted row, wherein reserving the second space includes reserving the second space on the page responsive to inserting the row, so that the amount of space reserved for adding data to inserted rows grows as more rows are inserted. The page is marked full for the second space independently of whether the first space is full for inserting new rows. Data is added to rows on the page, responsive to detecting that the second space is full, by adding the data to one or more new pages, even though rows may still be inserted on the page using any remaining room in the first space on the page.
    Type: Application
    Filed: September 10, 2016
    Publication date: December 29, 2016
    Inventors: Charles R. Bonner, John J. Campbell, Frances H. Villafuerte, Maryela E. Weihrauch
  • Patent number: 9519649
    Abstract: A row is inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for adding data to the inserted row, wherein reserving the second space includes reserving the second space on the page responsive to inserting the row.
    Type: Grant
    Filed: October 7, 2013
    Date of Patent: December 13, 2016
    Assignee: International Business Machines Corporation
    Inventors: Charles R. Bonner, John J. Campbell, Frances H. Villafuerte, Maryela E. Weihrauch
  • Publication number: 20150100606
    Abstract: A row is inserted in a database table on a page having a first space reserved for inserting rows of the database table. A second space is reserved for adding data to the inserted row, wherein reserving the second space includes reserving the second space on the page responsive to inserting the row.
    Type: Application
    Filed: October 7, 2013
    Publication date: April 9, 2015
    Applicant: International Business Machines Corporation
    Inventors: Charles R. Bonner, John J. Campbell, Frances H. Villafuerte, Maryela E. Weihrauch
  • Publication number: 20150039576
    Abstract: According to one embodiment of the present invention, a system compares database transactions to corresponding performance information to identify conforming database transactions with an acceptable deviation from the performance information and outlier database transactions beyond the acceptable deviation from the performance information. The system aggregates information from a threshold quantity of conforming database transactions into an aggregated record, wherein the threshold quantity is dynamically adjusted, and generates a record for each outlier database transaction, wherein conditions for identifying the outlier database transactions are dynamically adjusted. Embodiments of the present invention further include a method and computer program product for managing database transactions in substantially the same manners described above.
    Type: Application
    Filed: July 30, 2013
    Publication date: February 5, 2015
    Applicant: International Business Machines Corporation
    Inventors: John J. Campbell, Daniel Kozin, Nigel G. Slinger, John B. Tobler
  • Publication number: 20150039578
    Abstract: According to one embodiment of the present invention, a system compares database transactions to corresponding performance information to identify conforming database transactions with an acceptable deviation from the performance information and outlier database transactions beyond the acceptable deviation from the performance information. The system aggregates information from a threshold quantity of conforming database transactions into an aggregated record, wherein the threshold quantity is dynamically adjusted, and generates a record for each outlier database transaction, wherein conditions for identifying the outlier database transactions are dynamically adjusted. Embodiments of the present invention further include a method and computer program product for managing database transactions in substantially the same manners described above.
    Type: Application
    Filed: September 22, 2014
    Publication date: February 5, 2015
    Inventors: John J. Campbell, Daniel Kozin, Nigel G. Slinger, John B. Tobler
  • Patent number: 7725448
    Abstract: A method for performing disjunctive single-index access on a database is disclosed. The method includes a query engine determining whether a first OR predicate and a second OR predicate map to a shared index. Responsive to the query engine determining that the first OR predicate and the second OR predicate map to the shared index, the first OR predicate and the second OR predicate are ordered in an ascending sequence. A first range of the first OR predicate is queued. A first row of the shared index is probed for the first range of the first OR predicate. Whether the first row is disqualified by the first OR predicate is determined. Responsive to determining that the first row is not disqualified by the first OR predicate, the row is reported in a result reporting structure.
    Type: Grant
    Filed: August 31, 2007
    Date of Patent: May 25, 2010
    Assignee: International Business Machines Corporation
    Inventors: Thomas A. Beavin, Patrick D. Bossman, John J. Campbell, You-Chin Fuh, Terence P. Purcell
  • Patent number: 7644063
    Abstract: An apparatus, system, and method are disclosed for ensuring query execution plan stability in a database management system. The present invention binds a static database query to a new query execution plan (QEP) that produces the same result set as an original QEP bound to the static database query. Next, the present invention identifies one of the original QEP and the new QEP as a primary QEP and automatically collects execution statistics for the original QEP and the new QEP. Finally, the present invention automatically selects one of the original QEP and the new QEP as the primary QEP in response to completion of the automatic collection of execution statistics, the primary QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the primary QEP selected based on the execution statistics.
    Type: Grant
    Filed: August 17, 2007
    Date of Patent: January 5, 2010
    Assignee: International Business Machines Corporation
    Inventors: Patrick D. Bossman, Frank D. Bower, John J. Campbell, You-Chin Fuh, Adarsh R. Pannu, Terrence P. Purcell
  • Publication number: 20090063397
    Abstract: A method for performing disjunctive single-index access on a database is disclosed. The method includes a query engine determining whether a first OR predicate and a second OR predicate map to a shared index. Responsive to the query engine determining that the first OR predicate and the second OR predicate map to the shared index, the first OR predicate and the second OR predicate are ordered in an ascending sequence. A first range of the first OR predicate is queued. A first row of the shared index is probed for the first range of the first OR predicate. Whether the first row is disqualified by the first OR predicate is determined. Responsive to determining that the first row is not disqualified by the first OR predicate, the row is reported in a result reporting structure.
    Type: Application
    Filed: August 31, 2007
    Publication date: March 5, 2009
    Inventors: THOMAS A. BEAVIN, Patrick D. Bossman, John J. Campbell, You-Chin Fuh, Terence P. Purcell
  • Publication number: 20090049012
    Abstract: An apparatus, system, and method are disclosed for ensuring query execution plan stability in a database management system. The present invention binds a static database query to a new query execution plan (QEP) that produces the same result set as an original QEP bound to the static database query. Next, the present invention identifies one of the original QEP and the new QEP as a primary QEP and automatically collects execution statistics for the original QEP and the new QEP. Finally, the present invention automatically selects one of the original QEP and the new QEP as the primary QEP in response to completion of the automatic collection of execution statistics, the primary QEP selected such that the automatically selected QEP provides optimal execution performance based on performance criteria in comparison to the automatically unselected QEP, the primary QEP selected based on the execution statistics.
    Type: Application
    Filed: August 17, 2007
    Publication date: February 19, 2009
    Applicant: International Business Machines Corporation
    Inventors: Patrick D. Bossman, Frank D. Bower, John J, Campbell, You-Chin Fuh, Adarsh R. Pannu, Terence P. Purcell
  • Patent number: 5234214
    Abstract: The invention relates to a tennis ball holder and storage apparatus incorporated with a garment to be worn by a tennis player. The garment is previded with a hook element and a loop element of a hook and loop connector. The hook element is attached to the garment along a pocket open end and the loop element is attached to a pocket flap which exteds over the pocket opening such that the hook and loop elements will be aligned and engaged. The hook element on the garment can further be engaged with the nap surface on a standard tennis ball to thereby attach the ball to the garment. A pouch having a loop portion of a hook and loop fastener attached along its upper edge and adjacent its opening is provided. The loop portion on the pouch can be engaged with the hook element on the garment to thereby provide the garment with an auxiliary pocket for holding tennis balls.
    Type: Grant
    Filed: August 4, 1992
    Date of Patent: August 10, 1993
    Inventors: Layon A. Sexton, John J. Campbell
  • Patent number: 5227060
    Abstract: As shown in FIGS. 8 and 9, the instant invention provides a concave filter 530 which comprises two oppositely disposed geotextile fabric sheets 560A and 560B. Fabric sheets 560A and 560B are porous for filtering the liquid from the slurry solids and may be fabricated from a geotextile material such as the material composing filter sheets 330a and 330b (see FIG. 4). Disposed between fabric sheets 560A and 560B is at least one drainage grid 350 such as the drainage grid 350 illustrated in FIGS. 4 and 4A.
    Type: Grant
    Filed: July 7, 1992
    Date of Patent: July 13, 1993
    Assignee: Westinghouse Electric Corp.
    Inventors: Bryan A. Roy, Gregory F. Boris, John J. Campbell, John G. Funk, David J. Wozniak, James D. Gibson, Robert M. McCauley
  • Patent number: 5143615
    Abstract: Apparatus and method for dewatering radioactive waste slurry solids. The apparatus includes a vacuum pump for applying a vacuum to a suitable flexible filter and collapsible membrane combination in which the slurry solids are contained so that the slurry solids are compressively dewatered when the vacuum is applied. The apparatus further includes a container for suitably storing the resulting dewatered slurry solids.
    Type: Grant
    Filed: January 25, 1991
    Date of Patent: September 1, 1992
    Assignee: Westinghouse Electric Corp.
    Inventors: Bryan A. Roy, Gregory F. Boris, John J. Campbell, John G. Funk, David J. Wozniak, James D. Gibson, Robert M. McCauley
  • Patent number: 5022995
    Abstract: Apparatus and method for dewatering radioactive waste slurry solids. The apparatus includes a vacuum pump for applying a vacuum to a suitable flexible filter and collapsible membrane combination in which the slurry solids are contained so that the slurry solids are compressively dewatered when the vacuum is applied. The apparatus further includes a container for suitably storing the resulting dewatered slurry solids.
    Type: Grant
    Filed: May 16, 1990
    Date of Patent: June 11, 1991
    Assignee: Westinghouse Electric Corp.
    Inventors: Bryan A. Roy, Gregory F. Boris, John J. Campbell, John G. Funk, David J. Wozniak, James D. Gibson, Robert M. McCauley