Patents by Inventor Christian Zentgraf
Christian Zentgraf 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: 11487824Abstract: A method, system, and program product for implementing an automated query filtering process for spatial data is provided. The method includes selecting a set of common depth levels for geohash structures. Data indicating results of the selection is stored and a specified depth level of the set of common geohash depth levels is selected. The selected geohash depth level is associated with a spatial column for spatial data to determine a set of geohash depth levels required to generate geohash values. A filter table or index associated with the spatial column is generated based on the selected subset of common geohash depth levels and a relationship between the spatial column, the specified geohash depth level and the filter table is stored within a database. Geohash values for the filter table are generated and a query of the database is executed with respect to the specified geohash depth level, the filter entries, and the filter table.Type: GrantFiled: February 13, 2020Date of Patent: November 1, 2022Assignee: International Business Machines CorporationInventors: Marion Behnen, Pooja Bhandari, Christian Zentgraf
-
Patent number: 11455217Abstract: Transaction consistency query support is available for replicated data from recovery log to external data stores. An external data store is populated with records using entries of a change data table. The change data table has entries for each transaction that has committed and is to be replicated, and each of the entries stores information for each log entry in a recovery log from a database management system. Each log entry identifies a transactional change of data and a transaction completion indicator of one of commit and abort. In response to receiving a query about a transaction of the transactions, a set of records are retrieved from the external data store for the transaction. From the set of records, records whose sequence identifier values are larger than a maximum transaction commit sequence identifier are removed. From the set of records, remaining records having transaction consistency are returned.Type: GrantFiled: December 21, 2017Date of Patent: September 27, 2022Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Serge Bourbonnais, Austin F. M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf, Kan Zhang
-
Patent number: 11442823Abstract: Transaction consistency query support is available for replicated data from recovery log to external data stores. An external data store is populated with records using entries of a change data table. The change data table has entries for each transaction that has committed and is to be replicated, and each of the entries stores information for each log entry in a recovery log from a database management system. Each log entry identifies a transactional change of data and a transaction completion indicator of one of commit and abort. In response to receiving a query about a transaction of the transactions, a set of records are retrieved from the external data store for the transaction. From the set of records, records whose sequence identifier values are larger than a maximum transaction commit sequence identifier are removed. From the set of records, remaining records having transaction consistency are returned.Type: GrantFiled: June 3, 2016Date of Patent: September 13, 2022Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Serge Bourbonnais, Austin F. M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf, Kan Zhang
-
Publication number: 20220171791Abstract: A method, system and computer program product is provided. The method includes identifying a large statement, writing rows that are changed by the large statement into a set of files outside a database management system recovery log, and writing log records for the set of files to the database management system recovery log, such that the log records provide ordering of row changes made by the large statement. The log records include a log sequence number corresponding to a first row changed and a format and encoding used for the row changes. The method further includes streaming, by the one or more processors of the computer system, the set of files out-of-band by a replication capture process to a target database management system.Type: ApplicationFiled: February 18, 2022Publication date: June 2, 2022Inventors: Serge Bourbonnais, Austin D'costa, Roger Zheng, Christian Zentgraf, David Mooney
-
Patent number: 11308119Abstract: A method, system and computer program product is provided. The method includes identifying a large statement, writing the rows that are changed by the large statement into a set of files outside a database management system recovery log, and writing log records for the set of files to the database management system recovery log, such that the log records provide ordering of row changes made by the large statement. The log records include a log sequence number corresponding to a first row changed and a format and encoding used for the row changes. The method further includes streaming, by the one or more processors of the computer system, the set of files out-of-band by a replication capture process to a target database management system.Type: GrantFiled: December 3, 2018Date of Patent: April 19, 2022Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Austin D'costa, Roger Zheng, Christian Zentgraf, David Mooney
-
Publication number: 20210256065Abstract: A method, system, and program product for implementing an automated query filtering process for spatial data is provided. The method includes selecting a set of common depth levels for geohash structures. Data indicating results of the selection is stored and a specified depth level of the set of common geohash depth levels is selected. The selected geohash depth level is associated with a spatial column for spatial data to determine a set of geohash depth levels required to generate geohash values. A filter table or index associated with the spatial column is generated based on the selected subset of common geohash depth levels and a relationship between the spatial column, the specified geohash depth level and the filter table is stored within a database. Geohash values for the filter table are generated and a query of the database is executed with respect to the specified geohash depth level, the filter entries, and the filter table.Type: ApplicationFiled: February 13, 2020Publication date: August 19, 2021Inventors: Marion Behnen, Pooja Bhandari, Christian Zentgraf
-
Patent number: 10902015Abstract: Several replication subscriptions are defined for a table in a database management system. The table is divided into partitions. Each replication subscription replicates transactions to a range of partitions. Subscriptions are assignable to different consistency groups. Transaction consistency is preserved at the consistency group level. A persistent delay table is created for each of several apply functions. Each apply function processes replication subscriptions for one consistency group, to replicate the table to a target table in parallel. Transactions for a given range of a partition are executed in parallel. When an apply function upon a row of the target table results in an error, the row is stored in the delay table. Application of each row in the delay table is repeatedly retried, and if successful, the row is removed from the delay table.Type: GrantFiled: January 19, 2017Date of Patent: January 26, 2021Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Austin F. M. D'Costa, Xiao Li, Jonathan W. Wierenga, Xin Wu, Christian Zentgraf, Xiang W. Zhou
-
Publication number: 20200175034Abstract: A method, system and computer program product is provided. The method includes identifying a large statement, writing the rows that are changed by the large statement into a set of files outside a database management system recovery log, and writing log records for the set of files to the database management system recovery log, such that the log records provide ordering of row changes made by the large statement. The log records include a log sequence number corresponding to a first row changed and a format and encoding used for the row changes. The method further includes streaming, by the one or more processors of the computer system, the set of files out-of-band by a replication capture process to a target database management system.Type: ApplicationFiled: December 3, 2018Publication date: June 4, 2020Inventors: Serge Bourbonnais, Austin D'costa, Roger Zheng, Christian Zentgraf, David Mooney
-
Patent number: 10216584Abstract: Provided are techniques for replicating relational transactional log data to a big data platform. Change records contained in change data tables are fetched. A relational change history with transaction snapshot consistency is rebuilt to generate consistent change records by joining the change data tables and a unit of work table based on a commit sequence identifier. The consistent change records are stored on the big data platform, and queries are answered on the big data platform using the consistent change records.Type: GrantFiled: December 21, 2017Date of Patent: February 26, 2019Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Austin F. M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf
-
Patent number: 10216582Abstract: Provided are techniques for replicating relational transactional log data to a big data platform. Change records contained in change data tables are fetched. A relational change history with transaction snapshot consistency is rebuilt to generate consistent change records by joining the change data tables and a unit of work table based on a commit sequence identifier. The consistent change records are stored on the big data platform, and queries are answered on the big data platform using the consistent change records.Type: GrantFiled: August 15, 2016Date of Patent: February 26, 2019Assignee: International Business Machines CorporationInventors: Serge Bourbonnais, Austin F. M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf
-
Publication number: 20180203913Abstract: Several replication subscriptions are defined for a table in a database management system. The table is divided into partitions. Each replication subscription replicates transactions to a range of partitions. Subscriptions are assignable to different consistency groups. Transaction consistency is preserved at the consistency group level. A persistent delay table is created for each of several apply functions. Each apply function processes replication subscriptions for one consistency group, to replicate the table to a target table in parallel. Transactions for a given range of a partition are executed in parallel. When an apply function upon a row of the target table results in an error, the row is stored in the delay table. Application of each row in the delay table is repeatedly retried, and if successful, the row is removed from the delay table.Type: ApplicationFiled: January 19, 2017Publication date: July 19, 2018Inventors: Serge Bourbonnais, Austin F. M. D'Costa, Xiao Li, Jonathan W. Wierenga, Xin Wu, Christian Zentgraf, Xiang W. Zhou
-
Publication number: 20180113771Abstract: Provided are techniques for transaction consistency query support for replicated data from recovery log to external data stores. An external data store is populated with records using entries of a change data table. The change data table has entries for each transaction that has committed and is to be replicated, and each of the entries stores information for each log entry in a recovery log from a database management system. Each log entry identifies a transactional change of data and a transaction completion indicator of one of commit and abort. In response to receiving a query about a transaction of the transactions, a set of records are retrieved from the external data store for the transaction. From the set of records, records whose sequence identifier values are larger than a maximum transaction commit sequence identifier are removed. From the set of records, remaining records having transaction consistency are returned.Type: ApplicationFiled: December 21, 2017Publication date: April 26, 2018Inventors: Serge Bourbonnais, Austin F.M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf, Kan Zhang
-
Publication number: 20180113766Abstract: Provided are techniques for replicating relational transactional log data to a big data platform. Change records contained in change data tables are fetched. A relational change history with transaction snapshot consistency is rebuilt to generate consistent change records by joining the change data tables and a unit of work table based on a commit sequence identifier. The consistent change records are stored on the big data platform, and queries are answered on the big data platform using the consistent change records.Type: ApplicationFiled: December 21, 2017Publication date: April 26, 2018Inventors: Serge Bourbonnais, Austin F.M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf
-
Publication number: 20180046551Abstract: Provided are techniques for replicating relational transactional log data to a big data platform. Change records contained in change data tables are fetched. A relational change history with transaction snapshot consistency is rebuilt to generate consistent change records by joining the change data tables and a unit of work table based on a commit sequence identifier. The consistent change records are stored on the big data platform, and queries are answered on the big data platform using the consistent change records.Type: ApplicationFiled: August 15, 2016Publication date: February 15, 2018Inventors: Serge Bourbonnais, Austin F.M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf
-
Publication number: 20170351585Abstract: Provided are techniques for transaction consistency query support for replicated data from recovery log to external data stores. An external data store is populated with records using entries of a change data table. The change data table has entries for each transaction that has committed and is to be replicated, and each of the entries stores information for each log entry in a recovery log from a database management system. Each log entry identifies a transactional change of data and a transaction completion indicator of one of commit and abort. In response to receiving a query about a transaction of the transactions, a set of records are retrieved from the external data store for the transaction. From the set of records, records whose sequence identifier values are larger than a maximum transaction commit sequence identifier are removed. From the set of records, remaining records having transaction consistency are returned.Type: ApplicationFiled: June 3, 2016Publication date: December 7, 2017Inventors: Serge Bourbonnais, Austin F.M. D'Costa, Yat On Lau, Xiao Li, Hong Min, Gong Su, Jonathan W. Wierenga, Christian Zentgraf, Kan Zhang
-
Publication number: 20110295429Abstract: A method for controlling a processing machine with driven axes, in particular a printing press, wherein a radius of at least one axis is used to automatically determine a control limiting value.Type: ApplicationFiled: September 1, 2009Publication date: December 1, 2011Applicant: Robert Bosch GmbHInventors: Stephan Schultze, Christian Zentgraf, Michael Seubert
-
Patent number: 7979479Abstract: A method, system, and computer program product for transaction-controlled graph processing and management are provided. The method includes notifying an external component of a database management system (DBMS) controlled transaction including multiple operations, and acquiring a DBMS transaction identifier associated with the transaction at the external component. The method further includes storing the DBMS transaction identifier as an external component transaction identifier, and receiving notification at the external component of events associated with the operations. The method additionally includes monitoring the events for an end-of-transaction operation, and passing notification of the end-of-transaction operation to an external routine.Type: GrantFiled: January 8, 2009Date of Patent: July 12, 2011Assignee: International Business Machines CorporationInventors: Benno Staebler, Knut Stolze, Christian Zentgraf
-
Patent number: 7798382Abstract: A method for regulating a web tension of a continuous materials which is moving using a transport device with a web-tension controller, includes determining controller characteristic parameters, and using for the determining of controller characteristic parameters a characteristic which is specifiable as a function and/or at several support points.Type: GrantFiled: November 24, 2006Date of Patent: September 21, 2010Assignee: Bosch Rexroth AGInventors: Christian Zentgraf, Stephan Schultze
-
Publication number: 20100174694Abstract: A method, system, and computer program product for transaction-controlled graph processing and management are provided. The method includes notifying an external component of a database management system (DBMS) controlled transaction including multiple operations, and acquiring a DBMS transaction identifier associated with the transaction at the external component. The method further includes storing the DBMS transaction identifier as an external component transaction identifier, and receiving notification at the external component of events associated with the operations. The method additionally includes monitoring the events for an end-of-transaction operation, and passing notification of the end-of-transaction operation to an external routine.Type: ApplicationFiled: January 8, 2009Publication date: July 8, 2010Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Benno Staebler, Knut Stolze, Christian Zentgraf
-
Publication number: 20070119894Abstract: A method for regulating a web tension of a continuous materials which is moving using a transport device with a web-tension controller, includes determining controller characteristic parameters, and using for the determining of controller characteristic parameters a characteristic which is specifiable as a function and/or at several support points.Type: ApplicationFiled: November 24, 2006Publication date: May 31, 2007Inventors: Christian Zentgraf, Stephan Schultze