Patents by Inventor Walter D. ALVEY
Walter D. ALVEY 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: 10176205Abstract: Provided are techniques for using parallel inserts to insert into a column store. A list of sub-ranges for a columnar table is created. A change statement for one or more rows to be inserted into the columnar table is received. For each of the received change statements, a sub-range from the list of sub-ranges is identified and data is serially inserted into the identified sub-range of the columnar table, while allowing parallel processing of each change statement for different sub-ranges of the columnar table.Type: GrantFiled: August 3, 2016Date of Patent: January 8, 2019Assignee: International Business Machines CorporationInventors: Walter D. Alvey, Chandrasekaran Mohan, Steven R. Pearson, James J. Seeger, Jr., Richard S. Sidle, Adam J. Storm, Roger L. Q. Zheng
-
Patent number: 9910876Abstract: According to one embodiment of the present invention, a method for processing a query in a column database is provided. The method for analyzing test results may include a computer, associating a first set of metadata values with a set of records in a table, wherein each record has an associated state indicated by a metadata value. The method may further include the computer receiving a query to return one or more records of the set of records. The method may further include the computer determining that one or more records in the set of records satisfies the query. The method may further include the computer determining whether at least a first record in the one or more records that satisfies the query is in a returnable state based, at least in part, on the metadata value.Type: GrantFiled: June 11, 2014Date of Patent: March 6, 2018Assignee: International Business Machines CorporationInventors: Walter D. Alvey, Ronald J. Barber, Yi Ding, Chandrasekaran Mohan, Steven R. Pearson, Richard S. Sidle, Adam J. Storm
-
Patent number: 9910877Abstract: According to one embodiment of the present invention, a method for processing a query in a column database is provided. The method for analyzing test results may include a computer, associating a first set of metadata values with a set of records in a table, wherein each record has an associated state indicated by a metadata value. The method may further include the computer receiving a query to return one or more records of the set of records. The method may further include the computer determining that one or more records in the set of records satisfies the query. The method may further include the computer determining whether at least a first record in the one or more records that satisfies the query is in a returnable state based, at least in part, on the metadata value.Type: GrantFiled: March 11, 2015Date of Patent: March 6, 2018Assignee: International Business Machines CorporationInventors: Walter D. Alvey, Ronald J. Barber, Yi Ding, Chandrasekaran Mohan, Steven R. Pearson, Richard S. Sidle, Adam J. Storm
-
Patent number: 9697242Abstract: Embodiments relate to database systems. An aspect includes deferring row insert operations until occurrence of a triggering event. One method includes receiving a row insert for a tuple into a column group store table, where the tuple includes one or more tuplets and each of the tuplets corresponds to a column group in the column group store table. The method also includes copying at least one of the tuplets into an insert buffer that is specific to one of the column groups in the column group store table. The method also includes deferring the row insert into the column group store table until an occurrence of one or more triggering events. The method also includes flushing the row insert into storage associated with the column group store table, in response to the occurrence of the one or more triggering events.Type: GrantFiled: January 30, 2014Date of Patent: July 4, 2017Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Walter D. Alvey, Matthew A. Huras, Sam B. Lightstone, Chandrasekaran Mohan, Steven R. Pearson, James J. Seeger, Richard S. Sidle, David C. Smith, Adam J. Storm
-
Publication number: 20160342635Abstract: Provided are techniques for using parallel inserts to insert into a column store. A list of sub-ranges for a columnar table is created. A change statement for one or more rows to be inserted into the columnar table is received. For each of the received change statements, a sub-range from the list of sub-ranges is identified and data is serially inserted into the identified sub-range of the columnar table, while allowing parallel processing of each change statement for different sub-ranges of the columnar table.Type: ApplicationFiled: August 3, 2016Publication date: November 24, 2016Inventors: Walter D. ALVEY, Chandrasekaran MOHAN, Steven R. PEARSON, James J. SEEGER, JR., Richard S. SIDLE, Adam J. STORM, Roger L.Q. ZHENG
-
Patent number: 9442913Abstract: Provided are techniques for using parallel inserts to insert into a column store. A list of sub-ranges for a columnar table is created. A change statement for one or more rows to be inserted into the columnar table is received. For each of the received change statements, a sub-range from the list of sub-ranges is identified and data is serially inserted into the identified sub-range of the columnar table, while allowing parallel processing of each change statement for different sub-ranges of the columnar table.Type: GrantFiled: January 30, 2014Date of Patent: September 13, 2016Assignee: International Business Machines CorporationInventors: Walter D. Alvey, Chandrasekaran Mohan, Steven R. Pearson, James J. Seeger, Jr., Richard S. Sidle, Adam J. Storm, Roger L. Q. Zheng
-
Patent number: 9442914Abstract: Provided are techniques for using parallel inserts to insert into a column store. A list of sub-ranges for a columnar table is created. A change statement for one or more rows to be inserted into the columnar table is received. For each of the received change statements, a sub-range from the list of sub-ranges is identified and data is serially inserted into the identified sub-range of the columnar table, while allowing parallel processing of each change statement for different sub-ranges of the columnar table.Type: GrantFiled: November 14, 2014Date of Patent: September 13, 2016Assignee: International Business Machines CorporationInventors: Walter D. Alvey, Chandrasekaran Mohan, Steven R. Pearson, James J. Seeger, Jr., Richard S. Sidle, Adam J. Storm, Roger L. Q. Zheng
-
Publication number: 20150363468Abstract: According to one embodiment of the present invention, a method for processing a query in a column database is provided. The method for analyzing test results may include a computer, associating a first set of metadata values with a set of records in a table, wherein each record has an associated state indicated by a metadata value. The method may further include the computer receiving a query to return one or more records of the set of records. The method may further include the computer determining that one or more records in the set of records satisfies the query. The method may further include the computer determining whether at least a first record in the one or more records that satisfies the query is in a returnable state based, at least in part, on the metadata value.Type: ApplicationFiled: March 11, 2015Publication date: December 17, 2015Inventors: Walter D. Alvey, Ronald J. Barber, Yi Ding, Chandrasekaran Mohan, Steven R. Pearson, Richard S. Sidle, Adam J. Storm
-
Publication number: 20150363440Abstract: According to one embodiment of the present invention, a method for processing a query in a column database is provided. The method for analyzing test results may include a computer, associating a first set of metadata values with a set of records in a table, wherein each record has an associated state indicated by a metadata value. The method may further include the computer receiving a query to return one or more records of the set of records. The method may further include the computer determining that one or more records in the set of records satisfies the query. The method may further include the computer determining whether at least a first record in the one or more records that satisfies the query is in a returnable state based, at least in part, on the metadata value.Type: ApplicationFiled: June 11, 2014Publication date: December 17, 2015Inventors: Walter D. Alvey, Ronald J. Barber, Yi Ding, Chandrasekaran Mohan, Steven R. Pearson, Richard S. Sidle, Adam J. Storm
-
Publication number: 20150213071Abstract: Embodiments relate to database systems. An aspect includes deferring row insert operations until occurrence of a triggering event. One method includes receiving a row insert for a tuple into a column group store table, where the tuple includes one or more tuplets and each of the tuplets corresponds to a column group in the column group store table. The method also includes copying at least one of the tuplets into an insert buffer that is specific to one of the column groups in the column group store table. The method also includes deferring the row insert into the column group store table until an occurrence of one or more triggering events. The method also includes flushing the row insert into storage associated with the column group store table, in response to the occurrence of the one or more triggering events.Type: ApplicationFiled: January 30, 2014Publication date: July 30, 2015Applicant: International Business Machines CorporationInventors: Walter D. Alvey, Matthew A. Huras, Sam S. Lightstone, Chandrasekaran Mohan, Steven R. Pearson, James J. Seeger, JR., Richard S. Sidle, David C. Smith, Adam J. Storm
-
Publication number: 20150213073Abstract: Provided are techniques for using parallel inserts to insert into a column store. A list of sub-ranges for a columnar table is created. A change statement for one or more rows to be inserted into the columnar table is received. For each of the received change statements, a sub-range from the list of sub-ranges is identified and data is serially inserted into the identified sub-range of the columnar table, while allowing parallel processing of each change statement for different sub-ranges of the columnar table.Type: ApplicationFiled: November 14, 2014Publication date: July 30, 2015Inventors: Walter D. ALVEY, Chandrasekaran MOHAN, Steven R. PEARSON, James J. SEEGER, Jr., Richard S. SIDLE, Adam J. STORM, Roger L.Q. ZHENG
-
Publication number: 20150212999Abstract: Provided are techniques for using parallel inserts to insert into a column store. A list of sub-ranges for a columnar table is created. A change statement for one or more rows to be inserted into the columnar table is received. For each of the received change statements, a sub-range from the list of sub-ranges is identified and data is serially inserted into the identified sub-range of the columnar table, while allowing parallel processing of each change statement for different sub-ranges of the columnar table.Type: ApplicationFiled: January 30, 2014Publication date: July 30, 2015Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Walter D. ALVEY, Chandrasekaran MOHAN, Steven R. PEARSON, James J. SEEGER, JR., Richard S. SIDLE, Adam J. STORM, Roger L.Q. ZHENG