Patents by Inventor Oliver Koeth
Oliver Koeth 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: 10331662Abstract: A method, computer program product, and system for processing attribute value information for a data set. The method, computer program product, and system includes receiving a first data query on the data set. The first data query includes a condition on at least one attribute of the data set. While processing the first data query, data blocks containing records of the data set may be scanned. The data blocks contain first data blocks that are full. Attribute value information may be generated for the at least one attribute for the first data blocks. The attribute value information may be stored and a second data query involving a condition on at least one of the at least one attribute may be processed using the stored attribute value information.Type: GrantFiled: May 18, 2016Date of Patent: June 25, 2019Assignee: International Business Machines CorporationInventors: Thomas F. Boehme, Andreas Brodt, Oliver Koeth, Oliver Schiller
-
Patent number: 10282349Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.Type: GrantFiled: August 26, 2015Date of Patent: May 7, 2019Assignee: International Business Machines CorporationInventors: Gordon A. Booman, James L. Finnie, Oliver Koeth, Sunil K. Sarin
-
Patent number: 10255234Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.Type: GrantFiled: May 24, 2016Date of Patent: April 9, 2019Assignee: International Business Machine CorporationInventors: Gordon A. Booman, James L. Finnie, Oliver Koeth, Sunil K. Sarin
-
Publication number: 20190026340Abstract: A first data table and a second table to be joined is determined. The first data table and the second data table have a join attribute. Data blocks of the first data table are stored on a storage device. An attribute value information for the join attribute for the data block of the first data table is determined. At least one partition for the first data table and the second table is defined using at least he attribute value information on the join attribute. Each partition of the at least one partition has a respective partition range of values of the join attribute. A pair wise partition join is processed on a first partition range of the determined partition ranges.Type: ApplicationFiled: September 21, 2018Publication date: January 24, 2019Inventors: Thomas Boehme, Andreas Brodt, Oliver Koeth, Oliver Schiller
-
Patent number: 10013312Abstract: A method for archiving a predefined portion of a table residing in a database system includes: creating a first backup copy of the portion of the table; assigning to the portion of the table an access state flag; setting the access state flag; using the access state flag for preventing modification of existing backup copies of the portion of the table and for preventing further backup operations on the portion of the table; archiving the portion of the table to a separate system; deleting the content of the portion of the table from the database system and retaining the access state flag in the database system.Type: GrantFiled: September 24, 2014Date of Patent: July 3, 2018Assignee: International Business Machines CorporationInventors: Bjoern Broll, Claus Kempfert, Oliver Koeth, Laura M. Kunioka-Weis, Knut Stolze
-
Publication number: 20180129675Abstract: A method, computer program product, and system for processing attribute value information for a data set. The method, computer program product, and system includes receiving a first data query on the data set. The first data query includes a condition on at least one attribute of the data set. While processing the first data query, data blocks containing records of the data set may be scanned. The data blocks contain first data blocks that are full. Attribute value information may be generated for the at least one attribute for the first data blocks. The attribute value information may be stored and a second data query involving a condition on at least one of the at least one attribute may be processed using the stored attribute value information.Type: ApplicationFiled: January 4, 2018Publication date: May 10, 2018Inventors: Thomas F. Boehme, Andreas Brodt, Oliver Koeth, Oliver Schiller
-
Publication number: 20180075124Abstract: A computer program product and system include a first database engine that maintains a first database, a second database engine that maintains a second database, a table that has a first instance in the first database and a second instance in the second database, and program instructions to execute write transactions, asynchronously pool the changes of the first instance, responsive to receiving a query against the table, determine to execute the query against the second instance, identify a first time, define a current replication batch that selectively comprises the pooled changes of the transactions before the first time, asynchronously replicate the current replication batch, store each change, assign a batch-ID to the query, send the query and the batch-ID to the second engine, respond to the current replication batch being completed, by executing the query on the second instance, and return results of the query execution on the second instance.Type: ApplicationFiled: November 15, 2017Publication date: March 15, 2018Inventors: Andreas Brodt, Oliver Koeth, Daniel Martin, Knut Stolze
-
Publication number: 20180046693Abstract: A method includes, where a first database engine maintains a first database, a second database engine maintains a second database, and a table has a first instance in the first database and a second instance in the second database, executing write transactions, asynchronously pooling the changes of the first instance, and, in response to receiving a query against the table, determining to execute the query against the second instance. The method further includes identifying a first time, defining a current replication batch that selectively comprises the pooled changes of the transactions before the first time, asynchronously replicating the current replication batch, storing each change, assigning a batch-ID to the query, sending the query and the batch-ID to the second engine, responsive to the current replication batch being completed, executing the query on the second instance, and returning results of the query execution on the second instance.Type: ApplicationFiled: August 9, 2016Publication date: February 15, 2018Inventors: Andreas Brodt, Oliver Koeth, Daniel Martin, Knut Stolze
-
Publication number: 20170337210Abstract: A method, computer program product, and system for processing attribute value information for a data set. The method, computer program product, and system includes receiving a first data query on the data set. The first data query includes a condition on at least one attribute of the data set. While processing the first data query, data blocks containing records of the data set may be scanned. The data blocks contain first data blocks that are full. Attribute value information may be generated for the at least one attribute for the first data blocks. The attribute value information may be stored and a second data query involving a condition on at least one of the at least one attribute may be processed using the stored attribute value information.Type: ApplicationFiled: May 18, 2016Publication date: November 23, 2017Inventors: Thomas F. Boehme, Andreas Brodt, Oliver Koeth, Oliver Schiller
-
Publication number: 20170206066Abstract: The present invention relates to software development in a networked environment, and in particular to method and system for automatically assisted generation of composite applications (44) which are composed of a plurality of instantiable components, wherein a composite application infrastructure (CAI) component (15) handles application instances (19) during runtime and manages connections and data flow between said components of a composite application, and wherein a templating application infrastructure (TAI) component (13) manages templates (23) which contain references to said instantiable components.Type: ApplicationFiled: November 20, 2016Publication date: July 20, 2017Inventors: Peter Fischer, Oliver Koeth, Hendrik Haddorp, Andreas Nauerz
-
Publication number: 20170177667Abstract: A first data table and a second table to be joined is determined. The first data table and the second data table have a join attribute. Data blocks of the first data table are stored on a storage device. An attribute value information for the join attribute for the data block of the first data table is determined. At least one partition for the first data table and the second table is defined using at least he attribute value information on the join attribute. Each partition of the at least one partition has a respective partition range of values of the join attribute. A pair wise partition join is processed on a first partition range of the determined partition ranges.Type: ApplicationFiled: March 8, 2017Publication date: June 22, 2017Inventors: Thomas Boehme, Andreas Brodt, Oliver Koeth, Oliver Schiller
-
Publication number: 20170116267Abstract: A first data table and a second table to be joined is determined. The first data table and the second data table have a join attribute. Data blocks of the first data table are stored on a storage device. An attribute value information for the join attribute for the data block of the first data table is determined. At least one partition for the first data table and the second table is defined using at least he attribute value information on the join attribute. Each partition of the at least one partition has a respective partition range of values of the join attribute. A pair wise partition join is processed on a first partition range of the determined partition ranges.Type: ApplicationFiled: October 21, 2015Publication date: April 27, 2017Inventors: Thomas Boehme, Andreas Brodt, Oliver Koeth, Oliver Schiller
-
Publication number: 20170075931Abstract: A method for deleting a row from a table in a database system comprises logically deleting the row in the first table in the database system by inserting a key of the row into a corresponding row of a dedicated table in the database system; querying the dedicated table during a query against the first table to identify the corresponding row in the dedicated table; and in response to identifying the corresponding row in the dedicated table, deleting the row from the first table and the corresponding row from the dedicated table as part of query processing during a subsequent query.Type: ApplicationFiled: November 18, 2016Publication date: March 16, 2017Inventors: Andreas Brodt, Oliver Koeth, Daniel Martin, Knut Stolze
-
Publication number: 20170075940Abstract: A method for deleting a row from a table in a database system comprises logically deleting the row in the first table in the database system by inserting a key of the row into a corresponding row of a dedicated table in the database system; querying the dedicated table during a query against the first table to identify the corresponding row in the dedicated table; and in response to identifying the corresponding row in the dedicated table, deleting the row from the first table and the corresponding row from the dedicated table as part of query processing during a subsequent query.Type: ApplicationFiled: September 11, 2015Publication date: March 16, 2017Inventors: Andreas Brodt, Oliver Koeth, Daniel Martin, Knut Stolze
-
Publication number: 20170060908Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.Type: ApplicationFiled: May 24, 2016Publication date: March 2, 2017Inventors: Gordon A. Booman, James L. Finnie, Oliver Koeth, Sunil K. Sarin
-
Publication number: 20170060890Abstract: In an approach to storing data elements in a database, a database management unit provides a table-mapping file for enabling access to a table of a plurality of tables in a storage medium, the table-mapping file comprising a plurality of map records of a single table, a map record comprising information indicative of the table, a column of the table, a data section of the table, and a range of values of data elements included in the data section of the column. The unit receives a data element at the database via a communication interface, determines the table, column, and data section the data element is to be stored in, and stores the data element in the section file corresponding to the determined table, column and data section. The unit then updates the table-mapping file corresponding to the table, columns and data section the data element has been stored in.Type: ApplicationFiled: August 26, 2015Publication date: March 2, 2017Inventors: Gordon A. Booman, James L. Finnie, Oliver Koeth, Sunil K. Sarin
-
Patent number: 9513881Abstract: A system for assisted generation of composite applications which are composed of instantiable components includes a portal system executing in memory of a computer to: a) dynamically access a data source of one or more components being potentially suitable for being used within the composite application, b) parse the data source for a predetermined searched component according to a predetermined functionality specification standard, c) rank found components according to predetermined ranking criteria, d) define a list of selected usable components from the ranking, e) store at least a subset of the selected components locally, and, f) automatically deploy the composite application from the selected components.Type: GrantFiled: June 20, 2008Date of Patent: December 6, 2016Assignee: International Business Machines CorporationInventors: Peter Fischer, Hendrik Haddorp, Oliver Koeth, Andreas Nauerz
-
Patent number: 9354848Abstract: The present invention relates to software development in a networked environment, and in particular to a method for automatically assisted generation of composite applications which are composed of instantiable components. The method includes a) dynamically accessing a data source comprising one or more components being potentially suitable for being used within said composite application, b) parsing said data source for a predetermined searched component according to a predetermined functionality specification standard, c) ranking found components according to predetermined ranking criteria, d) defining a list of selected usable components from said ranking, e) storing at least a subset of said selected components locally, f) automatically deploying said composite application from said selected components.Type: GrantFiled: March 4, 2012Date of Patent: May 31, 2016Assignee: International Business Machines CorporationInventors: Peter Fischer, Hendrik Haddorp, Oliver Koeth, Andreas Nauerz
-
Patent number: 9286300Abstract: At least a portion of data from a first processing system is archived onto a second processing system based on partitions of the data. A query received at the first processing system is processed at the second processing system to retrieve archived data satisfying the received query in response to determining at the first processing system that the received query encompasses archived data. Embodiments of the present invention further include methods, systems, and computer program products for archiving and accessing data in substantially the same manner described above.Type: GrantFiled: May 2, 2013Date of Patent: March 15, 2016Assignee: International Business Machines CorporationInventors: Oliver Draese, Namik Hrle, Claus Kempfert, Oliver Koeth, Ruiping Li, Robert S. Muse, Knut Stolze, Guogen Zhang
-
Publication number: 20150142749Abstract: A method for archiving a predefined portion of a table residing in a database system includes: creating a first backup copy of the portion of the table; assigning to the portion of the table an access state flag; setting the access state flag; using the access state flag for preventing modification of existing backup copies of the portion of the table and for preventing further backup operations on the portion of the table; archiving the portion of the table to a separate system; deleting the content of the portion of the table from the database system and retaining the access state flag in the database system.Type: ApplicationFiled: September 24, 2014Publication date: May 21, 2015Inventors: Bjoern BROLL, Claus KEMPFERT, Oliver KOETH, Laura M. KUNIOKA-WEIS, Knut STOLZE