Patents by Inventor Frank-Martin Haas
Frank-Martin Haas 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: 11941142Abstract: Methods for using SQL statements to access an application-server-managed database are disclosed herein. In some embodiments, a user sends, either directly or indirectly (i.e., remotely) a SQL statement from an ODBC application or server, respectively, to an application server that preprocesses SQL statements for accessing data from a centralized database. The application server may have a SQL endpoint, and access to the SQL endpoint may be determined by a user's logon credentials, a user's presentation of a SAML token, or a user's presentation of a valid certificate. The application server may then parse the SQL statement and determine the user's authorization to access certain objects in the centralized database based on a SQL handler design-time configuration. A result from the statement may be sent back to the user either directly or indirectly and exposed.Type: GrantFiled: July 30, 2021Date of Patent: March 26, 2024Assignee: SAP SEInventors: Arne Harren, Marco Haupt, Helmut Prestel, Rolf Hammer, Christiane Kettschau, Kai Baumgarten, Diego Sebastian Will, Minh-Khanh Do, Timm Falter, Frank-Martin Haas, Kilian Kilger
-
Publication number: 20230030785Abstract: Methods for using SQL statements to access an application-server-managed database are disclosed herein. In some embodiments, a user sends, either directly or indirectly (i.e., remotely) a SQL statement from an ODBC application or server, respectively, to an application server that preprocesses SQL statements for accessing data from a centralized database. The application server may have a SQL endpoint, and access to the SQL endpoint may be determined by a user's logon credentials, a user's presentation of a SAML token, or a user's presentation of a valid certificate. The application server may then parse the SQL statement and determine the user's authorization to access certain objects in the centralized database based on a SQL handler design-time configuration. A result from the statement may be sent back to the user either directly or indirectly and exposed.Type: ApplicationFiled: July 30, 2021Publication date: February 2, 2023Inventors: Arne Harren, Marco Haupt, Helmut Prestel, Rolf Hammer, Christiane Kettschau, Kai Baumgarten, Diego Sebastian Will, Minh-Khanh Do, Timm Falter, Frank-Martin Haas, Kilian Kilger
-
Patent number: 11061897Abstract: Techniques and solutions are described for facilitating the distribution of tables and table data between a shared container and one or more tenant containers. The tables can include a sharing indicator that can designate a table (or a view on a table) as having a materializable type. Materializable types can initially be deployed in the shared container, and a tenant container can have read access to the table via a view. If the tenant attempts to modify the materializable table, the table can be materialized in the tenant container. Metadata for a materializable table can include materialization instructions. Techniques and solutions are also provided for converting between sharing types, and for updating shared containers or table schemas.Type: GrantFiled: May 7, 2018Date of Patent: July 13, 2021Assignee: SAP SEInventors: Andreas Zimmermann, Volker Driesen, Markus Gebhard, Torsten Ziegler, Frank-Martin Haas
-
Patent number: 10592509Abstract: The present disclosure involves systems, software, and computer implemented methods for using declarative rules for optimized access to data. One example method includes receiving a structured query language (SQL) query, the SQL query associated with at least one database table and at least one predicate. A determination is made as to whether the SQL query is associated with at least one declarative rule based on the at least one database table and the at least one predicate. In response to determining that the SQL query is associated with at least one declarative rule, the at least one associated declarative rule is applied, during optimization of the SQL query. The at least one declarative rule defines a transformation to the SQL query to be performed during query optimization. An updated SQL query is generated based on the applied at least one associated declarative rule and the updated SQL query is provided.Type: GrantFiled: May 22, 2017Date of Patent: March 17, 2020Assignee: SAP SEInventors: Torsten Ziegler, Christian Hansen, Frank-Martin Haas, Stefan Baeuerle, Mihnea Andrei, Alexander Boehm
-
Publication number: 20190340282Abstract: Techniques and solutions are described for facilitating the distribution of tables and table data between a shared container and one or more tenant containers. The tables can include a sharing indicator that can designate a table (or a view on a table) as having a materializable type. Materializable types can initially be deployed in the shared container, and a tenant container can have read access to the table via a view. If the tenant attempts to modify the materializable table, the table can be materialized in the tenant container. Metadata for a materializable table can include materialization instructions. Techniques and solutions are also provided for converting between sharing types, and for updating shared containers or table schemas.Type: ApplicationFiled: May 7, 2018Publication date: November 7, 2019Applicant: SAP SEInventors: Andreas Zimmermann, Volker Driesen, Markus Gebhard, Torsten Ziegler, Frank-Martin Haas
-
Publication number: 20180253473Abstract: The present disclosure involves systems, software, and computer implemented methods for using declarative rules for optimized access to data. One example method includes receiving a structured query language (SQL) query, the SQL query associated with at least one database table and at least one predicate. A determination is made as to whether the SQL query is associated with at least one declarative rule based on the at least one database table and the at least one predicate. In response to determining that the SQL query is associated with at least one declarative rule, the at least one associated declarative rule is applied, during optimization of the SQL query. The at least one declarative rule defines a transformation to the SQL query to be performed during query optimization. An updated SQL query is generated based on the applied at least one associated declarative rule and the updated SQL query is provided.Type: ApplicationFiled: May 22, 2017Publication date: September 6, 2018Inventors: Torsten Ziegler, Christian Hansen, Frank-Martin Haas, Stefan Baeuerle, Mihnea Andrei, Alexander Boehm
-
Patent number: 9372880Abstract: Provided are techniques for reclamation of empty pages in database tables. In response to receiving a plurality of records for insertion into a database table, the plurality of records are inserted into one or more contiguous pages. In response to at least some of the plurality of records being deleted from the database table, the one or more contiguous pages are reclaimed by: relocating any records from the plurality of records remaining in the one or more contiguous pages and releasing the one or more contiguous pages.Type: GrantFiled: April 29, 2013Date of Patent: June 21, 2016Assignee: International Business Machines CorporationInventors: Frank-Martin Haas, Nelson Hop Hing, Matthew A. Huras, Catherine S. McArthur, Sean W. McKeough, Keriley K. Romanufa, Torsten W. E. Ziegler
-
Patent number: 8886596Abstract: A computer system including instructions recorded on a non-transitory computer-readable storage medium and readable by at least one processor may include a table generator module, a table updater module, and a data replicator module. The table generator module may be configured to cause the at least one processor to generate a target table. The table updater module may be configured to cause the at least one processor to modify data in the target table synchronously with data being modified in a source table. The data replicator module may be configured to cause the at least one processor to replicate the data contained in the source table in the target table.Type: GrantFiled: October 11, 2010Date of Patent: November 11, 2014Assignee: SAP SEInventors: Arndt Effern, Frank-Martin Haas, Torsten Ziegler
-
Publication number: 20140324917Abstract: Provided are techniques for reclamation of empty pages in database tables. In response to receiving a plurality of records for insertion into a database table, the plurality of records are inserted into one or more contiguous pages. In response to at least some of the plurality of records being deleted from the database table, the one or more contiguous pages are reclaimed by: relocating any records from the plurality of records remaining in the one or more contiguous pages and releasing the one or more contiguous pages.Type: ApplicationFiled: April 29, 2013Publication date: October 30, 2014Applicants: SAP AG, International Business Machines CorporationInventors: Frank-Martin Haas, Nelson Hop Hing, Matthew A. Huras, Catherine S. McArthur, Sean W. McKeough, Keriley K. Romanufa, Torsten W.E. Ziegler
-
Publication number: 20120089566Abstract: A computer system including instructions recorded on a non-transitory computer-readable storage medium and readable by at least one processor may include a table generator module, a table updater module, and a data replicator module. The table generator module may be configured to cause the at least one processor to generate a target table. The table updater module may be configured to cause the at least one processor to modify data in the target table synchronously with data being modified in a source table. The data replicator module may be configured to cause the at least one processor to replicate the data contained in the source table in the target table.Type: ApplicationFiled: October 11, 2010Publication date: April 12, 2012Applicant: SAP AGInventors: Arndt Effern, Frank-Martin Haas, Torsten Ziegler
-
Patent number: 7774319Abstract: In an embodiment, a database interface performs a three-step optimistic database access. The database interface initially performs an optimistic read of a database object. The database object is checked for consistency after the optimistic read. If the database object is inconsistent, a first pessimistic read is performed with an isolation level that does not guarantee consistency (e.g., with an isolation level of committed read). The database object is checked again for consistency after the first pessimistic read. If the database object is inconsistent, a second pessimistic read is performed with an isolation level that may guarantee consistency (e.g., with an isolation level of repeatable read).Type: GrantFiled: August 11, 2004Date of Patent: August 10, 2010Assignee: SAP AGInventors: Rainer Schweigkoffer, Guenther Drach, Tobias Wenner, Frank-Martin Haas, Torsten Ziegler
-
Patent number: 7702696Abstract: Methods and a system for managing database usage. The methods and system include receiving a request to create a table, determining the table is an empty table, and storing a pseudo-table in a data store in response to determining the table is empty. The pseudo-table may be a database view. Metadata related to a table may be stored in the pseudo-table to describe characteristics of the table. The pseudo-table occupies less space than a corresponding empty table. The system may implement the methods in middleware transparent to the applications.Type: GrantFiled: April 16, 2007Date of Patent: April 20, 2010Assignee: SAP AGInventors: Torsten Ziegler, Frank-Martin Haas
-
Patent number: 7461097Abstract: In a software system (200/210/220) with a business application (200), database migration from a source database (210) to a physically different target database (230) is performed by a migration tool (260) that evaluates database instructions (201) that the application (200) consecutively sends to the source database (210). The migration tool (260) stores representations (254, 255) of an action type (205, D, I, U) and of a key (231) in a log table (250) when an action type coincides with a predetermined action type (D, I, U); copies source table entries to the target table (240); and adjusts entries in the target table that have keys represented in the log table (250). During migration, the application (200) and the source table continue communicating.Type: GrantFiled: November 14, 2003Date of Patent: December 2, 2008Assignee: SAP AktiengesellschaftInventors: Martin Stahl, Bernd Kohler, Guenter Briam, Torsten Ziegler, Frank-Martin Haas
-
Publication number: 20080256118Abstract: Methods and a system for managing database usage. The methods and system include receiving a request to create a table, determining the table is an empty table, and storing a pseudo-table in a data store in response to determining the table is empty. The pseudo-table may be a database view. Metadata related to a table may be stored in the pseudo-table to describe characteristics of the table. The pseudo-table occupies less space than a corresponding empty table. The system may implement the methods in middleware transparent to the applications.Type: ApplicationFiled: April 16, 2007Publication date: October 16, 2008Inventors: Torsten Ziegler, Frank-Martin Haas
-
Publication number: 20060036574Abstract: In an embodiment, a database interface performs a three-step optimistic database access. The database interface initially performs an optimistic read of a database object. The database object is checked for consistency after the optimistic read. If the database object is inconsistent, a first pessimistic read is performed with an isolation level that does not guarantee consistency (e.g., with an isolation level of committed read). The database object is checked again for consistency after the first pessimistic read. If the database object is inconsistent, a second pessimistic read is performed with an isolation level that may guarantee consistency (e.g., with an isolation level of repeatable read).Type: ApplicationFiled: August 11, 2004Publication date: February 16, 2006Inventors: Rainer Schweigkoffer, Guenther Drach, Tobias Wenner, Frank-Martin Haas, Torsten Ziegler
-
Publication number: 20040122865Abstract: In a software system (200/210/220) with a business application (200), database migration from a source database (210) to a physically different target database (230) is performed by a migration tool (260) that evaluates database instructions (201) that the application (200) consecutively sends to the source database (210). The migration tool (260) stores representations (254, 255) of an action type (205, D, I, U) and of a key (231) in a log table (250) when an action type coincides with a predetermined action type (D, I, U); copies source table entries to the target table (240); and adjusts entries in the target table that have keys represented in the log table (250). During migration, the application (200) and the source table continue communicating.Type: ApplicationFiled: November 14, 2003Publication date: June 24, 2004Inventors: Martin Stahl, Bernd Kohler, Guenter Briam, Torsten Ziegler, Frank-Martin Haas