Patents by Inventor Johannes Schuetzner
Johannes Schuetzner 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: 10452629Abstract: Methods and apparatus, including computer program products, for maintaining a set of indexes in a database management system (DBMS) having at least one table. A current, stale or deferred status is defined for at least a part of the indexes, resulting in at least a part of a set of current, stale, or deferred indexes in the DBMS. Current indexes are maintained by refreshing a current index synchronously with a table change relating to the current index. Stale indexes are maintained by refreshing a stale index continuously and asynchronously to table modifications of tables relating to the stale index based on log information relating to the modifications. Deferred indexes are maintained by building a deferred index in response to a query to a table relating to the deferred index, thereby bringing the deferred index in accordance with the current query time status to the table relating to the deferred index.Type: GrantFiled: April 7, 2011Date of Patent: October 22, 2019Assignee: International Business Machines CorporationInventors: Namik Hrle, Johannes Schuetzner, James Z. Teng
-
Patent number: 9800557Abstract: Embodiments relate to operating a data processing system. An aspect includes receiving a request for data storage by an application server, said request comprising restricted-access data. Another aspect includes processing the request in the first application server thereby extracting said restricted-access data from the request. Another aspect includes encrypting said restricted-access data with a cryptographic key associated with said privacy regime to a cipher representation. Another aspect includes defining a masking rule relative to the field designated for storage of the cipher representation, the masking rule defining a set of privacy regimes applicable to processing of the restricted-access data. Another aspect includes forwarding the cipher representation and the masking rule to the shared database by a database client.Type: GrantFiled: March 3, 2015Date of Patent: October 24, 2017Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Albert Maier, Volker Seemann, Johannes Schuetzner
-
Patent number: 9792326Abstract: Dynamically switching between a plurality of execution paths to execute a function, such as a user-defined function. The plurality of execution paths include an execution path that uses caching and another execution path that uses inlining. A user-defined function is executed at least once using a first execution path. Then, for a later execution of the function, the execution path is automatically switched to a second execution path.Type: GrantFiled: October 31, 2016Date of Patent: October 17, 2017Assignee: International Business Machines CorporationInventors: Andrei F. Lurie, Dirk Nakott, Johannes Schuetzner
-
Patent number: 9317697Abstract: Embodiments related to processing of restricted-access data. An aspect includes receiving a request for data from a user by a storage system infrastructure comprising a centralized database that stores non-restricted access data and a local system that stores restricted-access data associated with a first set of areas or entities and comprising a federated database for providing a federated view, wherein the requested data comprises restricted-access first data and non-restricted access second data. Another aspect includes based on an association of the user, routing, by a routing entity, the request to the local system. Another aspect includes receiving the request at the at least one federated database of the local system. Another aspect includes retrieving from the federated database the restricted-access first data and the non-restricted access second data.Type: GrantFiled: January 25, 2013Date of Patent: April 19, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Albert Maier, Thomas Rech, Johannes Schuetzner, Volker Seemann
-
Publication number: 20150256520Abstract: Embodiments relate to operating a data processing system. An aspect includes receiving a request for data storage by an application server, said request comprising restricted-access data. Another aspect includes processing the request in the first application server thereby extracting said restricted-access data from the request. Another aspect includes encrypting said restricted-access data with a cryptographic key associated with said privacy regime to a cipher representation. Another aspect includes defining a masking rule relative to the field designated for storage of the cipher representation, the masking rule defining a set of privacy regimes applicable to processing of the restricted-access data. Another aspect includes forwarding the cipher representation and the masking rule to the shared database by a database client.Type: ApplicationFiled: March 3, 2015Publication date: September 10, 2015Inventors: Albert Maier, Volker Seemann, Johannes Schuetzner
-
Patent number: 8972346Abstract: Operating a parallel database server system, where the database server system comprises at least two database servers and one data source. A client identifier is received from a client requesting services from one of said database servers. Information associated with said client is retrieved. The client is allocated to one of said database servers based on the retrieved information.Type: GrantFiled: December 1, 2010Date of Patent: March 3, 2015Assignee: International Business Machines CorporationInventors: James W Pickel, Wolfgang Reichert, Johannes Schuetzner
-
Patent number: 8954407Abstract: Methods and Apparatus, including computer program products, for maintaining indexes in a database management system. The database management system includes a table having table entries and an index data structure having index data structure entries, the index data structure relating to the table. The index data structure is updated synchronously with an insertion of table entries. The index data structure is maintained unchanged when the table entries are deleted. It is verified by an index-scan on the index data structure that a valid criterion is fulfilled for index data structure entries, and those index data structure entries that pass the valid criterion from the index-scan are returned.Type: GrantFiled: April 12, 2011Date of Patent: February 10, 2015Assignee: International Business Machines CorporationInventors: Namik Hrle, Johannes Schuetzner, Knut Stolze
-
Patent number: 8161017Abstract: According to one embodiment of the present invention, a method for identifying relevant database indexes is provided. According to one embodiment of the present invention, a method includes determining the importance of a particular database transaction and storing an index name related to the transaction along with an indicator of the importance. A database transaction is initiated and the importance indicator is received in an index advisor. The index advisor then makes an index recommendation based on the index importance.Type: GrantFiled: April 3, 2009Date of Patent: April 17, 2012Assignee: International Business Machines CorporationInventors: Namik Hrle, Johannes Schuetzner, James Teng
-
Publication number: 20120016881Abstract: Methods and apparatus, including computer program products, for maintaining a set of indexes in a database management system (DBMS) having at least one table. A current, stale or deferred status is defined for at least a part of the indexes, resulting in at least a part of a set of current, stale, or deferred indexes in the DBMS. Current indexes are maintained by refreshing a current index synchronously with a table change relating to the current index. Stale indexes are maintained by refreshing a stale index continuously and asynchronously to table modifications of tables relating to the stale index based on log information relating to the modifications. Deferred indexes are maintained by building a deferred index in response to a query to a table relating to the deferred index, thereby bringing the deferred index in accordance with the current query time status to the table relating to the deferred index.Type: ApplicationFiled: April 7, 2011Publication date: January 19, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Namik Hrle, Johannes Schuetzner, James Z. Teng
-
Publication number: 20120016851Abstract: Methods and Apparatus, including computer program products, for maintaining indexes in a database management system. The database management system includes a table having table entries and an index data structure having index data structure entries, the index data structure relating to the table. The index data structure is updated synchronously with an insertion of table entries. The index data structure is maintained unchanged when the table entries are deleted. It is verified by an index-scan on the index data structure that a valid criterion is fulfilled for index data structure entries, and those index data structure entries that pass the valid criterion from the index-scan are returned.Type: ApplicationFiled: April 12, 2011Publication date: January 19, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Namik Hrle, Johannes Schuetzner, Knut Stolze
-
Publication number: 20110295800Abstract: Operating a parallel database server system, where the database server system comprises at least two database servers and one data source. A client identifier is received from a client requesting services from one of said database servers. Information associated with said client is retrieved. The client is allocated to one of said database servers based on the retrieved information.Type: ApplicationFiled: December 1, 2010Publication date: December 1, 2011Applicant: International Business Machines CorporationInventors: James W. Pickel, Wolfgang Reichert, Johannes Schuetzner
-
Publication number: 20100257152Abstract: According to one embodiment of the present invention, a method for identifying relevant database indexes is provided. According to one embodiment of the present invention, a method includes determining the importance of a particular database transaction and storing an index name related to the transaction along with an indicator of the importance. A database transaction is initiated and the importance indicator is received in an index advisor. The index advisor then makes an index recommendation based on the index importance.Type: ApplicationFiled: April 3, 2009Publication date: October 7, 2010Applicant: International Business Machines CorporationInventors: Namik Hrle, Johannes Schuetzner, James Teng
-
Patent number: 7693875Abstract: A method of searching a data page in a table space of a database for inserting a data record to a first table, wherein the table space comprises space map pages and sets of data pages, wherein each space map page comprises information about the available storage space of one set of data pages, wherein each space map page and the corresponding set of data pages is further assigned to a table range for each table to which at least one data page in the set of data pages belongs to, wherein the database further comprises a clustering index for the first table in the database management system, wherein the database management system comprises a space usage information database, and wherein the space usage information database holds space usage information for each table range.Type: GrantFiled: January 5, 2007Date of Patent: April 6, 2010Assignee: International Business Machines CorporationInventors: Namik Hrle, Johannes Schuetzner, James Teng
-
Patent number: 7552110Abstract: Presented is a method to perform a query to retrieve data from a database that is part of a computer system comprising a Data-Base Management System (DBMS) with an optimizer. A Query Execution Plan (QEP) is generated for the query. The QEP is assessed by considering statistical values about previous executions of the query according to the QEP to decide whether to choose the QEP or to generate a new QEP. Furthermore, the statistical values on previous executions of the query are exploited during query optimization. The query is executed according to the chosen QEP. For optimizing the execution of future queries, statistical values about the execution of the query are collected during execution.Type: GrantFiled: September 22, 2004Date of Patent: June 23, 2009Assignee: International Business Machines CorporationInventors: Namik Hrle, Johannes Schuetzner
-
Publication number: 20070168640Abstract: A method of searching a data page in a table space of a database for inserting a data record to a first table, wherein the table space comprises space map pages and sets of data pages, wherein each space map page comprises information about the available storage space of one set of data pages, wherein each space map page and the corresponding set of data pages is further assigned to a table range for each table to which at least one data page in the set of data pages belongs to, wherein the database further comprises a clustering index for the first table in the database management system, wherein the database management system comprises a space usage information database, and wherein the space usage information database holds space usage information for each table range.Type: ApplicationFiled: January 5, 2007Publication date: July 19, 2007Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Namik Hrle, Johannes Schuetzner, James Teng
-
Publication number: 20050065921Abstract: A computer system and a corresponding method perform a query to retrieve data from a database. The computer system comprises a Data-Base Management System (DBMS) with an optimizer. A Query Execution Plan (QEP) is generated for the query. The QEP is assessed by considering statistical values about previous executions of the query according to the QEP to decide whether to choose the QEP or to generate a new QEP. Furthermore, the statistical values on previous executions of the query are exploited during query optimization. The query is executed according to the chosen QEP. For optimizing the execution of future queries, statistical values about the execution of the query are collected during execution.Type: ApplicationFiled: September 22, 2004Publication date: March 24, 2005Applicant: International Business Machines CorporationInventors: Namik Hrle, Johannes Schuetzner