Patents by Inventor Holger Bischoff
Holger Bischoff 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: 11727063Abstract: A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation a second query statement and a third query statement based on the first query statement, the second query statement to insert rows of a first partition of the source table into the target table and the third query statement to insert rows of a second partition of the source table into the target table, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.Type: GrantFiled: September 29, 2021Date of Patent: August 15, 2023Assignee: SAP SEInventors: SungGun Jung, Yuchon Yi, Holger Bischoff
-
Patent number: 11341120Abstract: Disclosed herein are system, method, and computer program product embodiments for creating a dictionary-free index. An embodiment operates by a database maintaining database table comprises a column and a row. The database creates a concatenated string index comprising a concatenated string value based on the database column's row. The database also creates a hash value list having a hash value based on the concatenation string index's concatenated string value. Thereafter, the database creates a directory having a pointer to (i) a row position of the hash value list or (ii) a row position of a collision list having the row position of the hash value in the hash value list. The database also creates a collision list containing the row positions of the hash values occurring multiple times in the hash value list. The index for the database table includes the hash value list, the directory, and the collision list.Type: GrantFiled: May 13, 2020Date of Patent: May 24, 2022Assignee: SAP SEInventors: Robert Schulze, Holger Bischoff, Neeraj Kulkarni
-
Publication number: 20220019626Abstract: A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation a second query statement and a third query statement based on the first query statement, the second query statement to insert rows of a first partition of the source table into the target table and the third query statement to insert rows of a second partition of the source table into the target table, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.Type: ApplicationFiled: September 29, 2021Publication date: January 20, 2022Inventors: SungGun Jung, Yuchon Yi, Holger Bischoff
-
Patent number: 11157565Abstract: A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation a second query statement and a third query statement based on the first query statement, the second query statement to insert rows of a first partition of the source table into the target table and the third query statement to insert rows of a second partition of the source table into the target table, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.Type: GrantFiled: April 4, 2019Date of Patent: October 26, 2021Assignee: SAP SEInventors: SungGun Jung, Yuchon Yi, Holger Bischoff
-
Publication number: 20200387490Abstract: Disclosed herein are system, method, and computer program product embodiments for creating a dictionary-free index. An embodiment operates by a database maintaining database table comprises a column and a row. The database creates a concatenated string index comprising a concatenated string value based on the database column's row. The database also creates a hash value list having a hash value based on the concatenation string index's concatenated string value. Thereafter, the database creates a directory having a pointer to (i) a row position of the hash value list or (ii) a row position of a collision list having the row position of the hash value in the hash value list. The database also creates a collision list containing the row positions of the hash values occurring multiple times in the hash value list. The index for the database table includes the hash value list, the directory, and the collision list.Type: ApplicationFiled: May 13, 2020Publication date: December 10, 2020Inventors: Robert Schulze, Holger BISCHOFF, Neeraj KULKARNI
-
Publication number: 20200320137Abstract: A system includes reception of a database query, the query comprising a first query statement to insert rows of a source table into a target table, generation a second query statement and a third query statement based on the first query statement, the second query statement to insert rows of a first partition of the source table into the target table and the third query statement to insert rows of a second partition of the source table into the target table, generation of a first query operator executable to perform the second query statement, generation of a second query operator executable to perform the third query statement, transmission of the first executable query operator to a second database server node storing the first partition of the source table, and transmission of the second executable query operator to a third database server node storing the second partition of the source table.Type: ApplicationFiled: April 4, 2019Publication date: October 8, 2020Inventors: SungGun Jung, Yuchon Yi, Holger Bischoff
-
Patent number: 10534797Abstract: A first store and a second store can be configured to store a first partition of a table of a database and a second partition of the table of the database, respectively. A database management system can be configured to at least update at least a first portion of the first partition where the update includes an update to a first primary key column in the first partition and verify that the first primary key column is unique across the first partition and the second partition. A first row having a first primary key value of the first primary key column from the first partition can be deleted, when the first primary key value in the first partition conflicts with a second primary key value of a second primary key column in the second partition.Type: GrantFiled: November 30, 2016Date of Patent: January 14, 2020Assignee: SAP SEInventors: Christian Bensberg, Martin Heidel, Lars Fricke, Holger Bischoff, Joern Schmidt, Edward-Robert Tyercha
-
Patent number: 10474697Abstract: An update to a partitioning column for a partitioned table in a database can be performed by handling rows for which the update will not require moving to a different partition separately (e.g. “locally”) for each partition followed by re-inserting those rows that will require moving to a different partition and deleting them from the original partition. The re-inserted rows are directed to a correct partition by application of the partitioning criteria for the table. Methods, articles, and systems are described.Type: GrantFiled: December 17, 2015Date of Patent: November 12, 2019Assignee: SAP SEInventors: Christian Bensberg, Lars Fricke, Martin Heidel, Holger Bischoff, Joern Schmidt, Edward-Robert Tyercha, Andreas Tonder
-
Publication number: 20180150544Abstract: A first store and a second store can be configured to store a first partition of a table of a database and a second partition of the table of the database, respectively. A database management system can be configured to at least update at least a first portion of the first partition where the update includes an update to a first primary key column in the first partition and verify that the first primary key column is unique across the first partition and the second partition. A first row having a first primary key value of the first primary key column from the first partition can be deleted, when the first primary key value in the first partition conflicts with a second primary key value of a second primary key column in the second partition.Type: ApplicationFiled: November 30, 2016Publication date: May 31, 2018Inventors: Christian Bensberg, Martin Heidel, Lars Fricke, Holger Bischoff, Joern Schmidt, Edward-Robert Tyercha
-
Patent number: 9817858Abstract: The present disclosure involves systems, software, and computer implemented methods for generating a hash identifier. One example method includes: identifying a record to include in a table, the record associated with two or more primary key fields that are concatenated to create a concatenated key, wherein the table includes one or more hash columns for storing hash identifiers; applying a hash function to the concatenated key to create a new hash value; determining whether a record in the table has a hash value matching the new hash value; in response to determining that a hash value of a record matches the new hash value and the concatenated key of the identified record does not match the concatenated key of any existing record, adding a counter to the new hash value to generate a unique hash ID; and storing the record, including the unique hash ID, in the table.Type: GrantFiled: December 10, 2014Date of Patent: November 14, 2017Assignee: SAP SEInventors: Katrin Eisenreich, Holger Bischoff
-
Publication number: 20170177700Abstract: An update to a partitioning column for a partitioned table in a database can be performed by handling rows for which the update will not require moving to a different partition separately (e.g. “locally”) for each partition followed by re-inserting those rows that will require moving to a different partition and deleting them from the original partition. The re-inserted rows are directed to a correct partition by application of the partitioning criteria for the table. Methods, articles, and systems are described.Type: ApplicationFiled: December 17, 2015Publication date: June 22, 2017Applicant: SAP SEInventors: Christian Bensberg, Lars Fricke, Martin Heidel, Holger Bischoff, Joern Schmidt, Edward-Robert Tyercha, Andreas Tonder
-
Publication number: 20160171039Abstract: The present disclosure involves systems, software, and computer implemented methods for generating a hash identifier. One example method includes: identifying a record to include in a table, the record associated with two or more primary key fields that are concatenated to create a concatenated key, wherein the table includes one or more hash columns for storing hash identifiers; applying a hash function to the concatenated key to create a new hash value; determining whether a record in the table has a hash value matching the new hash value; in response to determining that a hash value of a record matches the new hash value and the concatenated key of the identified record does not match the concatenated key of any existing record, adding a counter to the new hash value to generate a unique hash ID; and storing the record, including the unique hash ID, in the table.Type: ApplicationFiled: December 10, 2014Publication date: June 16, 2016Inventors: Katrin Eisenreich, Holger Bischoff
-
Patent number: 5749176Abstract: A motor vehicle door of the type having a door hollow (4) disposed between an inside wall and an outside wall (2, 3), electrical lines (11; 13; 15; 17), linkages (21) and/or Bowden cables (22) (altogether identified as supply lines below) being arranged in and with the door hollow. To accomplish that a forcible opening of the door from the outside by inserting tools, etc. into the door hollow is almost impossible, the supply lines (11; 13; 15; 17; 21; 22) are arranged on or in a support element (6; 20; 23) such that they are at least partially covered toward the outside wall (3) of the vehicle door (1; 100).Type: GrantFiled: August 8, 1996Date of Patent: May 12, 1998Assignee: Ymos Aktiengesellschaft IndustrieprodukteInventors: Gunther Heim, Thomas Uberreiter, Jurgen Hock, Holger Bischoff