Patents by Inventor Jonathan Dees
Jonathan Dees 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: 11947509Abstract: Various embodiments for a triple integration and querying system are described herein. An embodiment operates by identifying a plurality of triples corresponding to a knowledge graph, and generating a table in a database into which to import the set of triples. The table includes a subject column, a predicate column, and multiple object columns across different datatypes. Values from the triples of the knowledge graph are loaded into the table and a query is executed on the table.Type: GrantFiled: August 23, 2022Date of Patent: April 2, 2024Assignee: SAP SEInventors: Christian Bensberg, Jonathan Dees, Markus Fath
-
Publication number: 20240086426Abstract: A method for executing a query may include generating a partition value identifier for a partitioned table. The partitioned table may include a main fragment including a main dictionary storing a first value and a main value identifier corresponding to the first value and a delta fragment including a delta dictionary storing a second value and a delta value identifier corresponding to the second value. The partition value identifier may be set based at least in part on the first value and the second value. The generated partition value identifier and a corresponding one of the main value identifier and the delta value identified may be maintained as part of a mapping. A query to group data stored in the partitioned table may be received. The query may be executed by at least using the mapping.Type: ApplicationFiled: November 21, 2023Publication date: March 14, 2024Inventors: Andreas Amler, Jonathan Dees, Till Merker
-
Publication number: 20240070136Abstract: Various embodiments for a triple integration and querying system with dictionary compression are described herein. An embodiment operates by identifying a table of a database with four or more columns with triple formatted data including one subject column, one predicate column, and two or more object columns. It is determined that a master dictionary is to be generated for the both the subject column and the predicate column based on an identical datatype being used for both columns. A subject data dictionary and a predicate data dictionary are generated. A unique value is assigned a same unique identifier a in both the object data dictionary and the subject data dictionary. A master dictionary including both the unique values from the subject data dictionary and the predicate data dictionary is generated. Values in the subject column and the predicate column are replaced based on the unique values from the master dictionary.Type: ApplicationFiled: August 23, 2022Publication date: February 29, 2024Inventors: CHRISTIAN BENSBERG, Jonathan DEES, Markus FATH
-
Publication number: 20240070133Abstract: Various embodiments for a triple integration and querying system are described herein. An embodiment operates by identifying a plurality of triples corresponding to a knowledge graph, and generating a table in a database into which to import the set of triples. The table includes a subject column, a predicate column, and multiple object columns across different datatypes. Values from the triples of the knowledge graph are loaded into the table and a query is executed on the table.Type: ApplicationFiled: August 23, 2022Publication date: February 29, 2024Inventors: CHRISTIAN BENSBERG, Jonathan Dees, Markus Fath
-
Patent number: 11860906Abstract: A method for executing a query may include generating a partition value identifier for a partitioned table. The partitioned table may include a main fragment including a main dictionary storing a first value and a main value identifier corresponding to the first value and a delta fragment including a delta dictionary storing a second value and a delta value identifier corresponding to the second value. The partition value identifier may be set based at least in part on the first value and the second value. The generated partition value identifier and a corresponding one of the main value identifier and the delta value identified may be maintained as part of a mapping. A query to group data stored in the partitioned table may be received. The query may be executed by at least using the mapping.Type: GrantFiled: May 16, 2022Date of Patent: January 2, 2024Assignee: SAP SEInventors: Andreas Amler, Jonathan Dees, Till Merker
-
Publication number: 20230367791Abstract: A method for executing a query may include generating a partition value identifier for a partitioned table. The partitioned table may include a main fragment including a main dictionary storing a first value and a main value identifier corresponding to the first value and a delta fragment including a delta dictionary storing a second value and a delta value identifier corresponding to the second value. The partition value identifier may be set based at least in part on the first value and the second value. The generated partition value identifier and a corresponding one of the main value identifier and the delta value identified may be maintained as part of a mapping. A query to group data stored in the partitioned table may be received. The query may be executed by at least using the mapping.Type: ApplicationFiled: May 16, 2022Publication date: November 16, 2023Inventors: Andreas Amler, Jonathan Dees, Till Merker
-
Patent number: 11475004Abstract: Various examples are directed to systems and methods optimizing database queries. A database management system may receive a first query comprising a plurality of query expressions. The database management system may determine that a first expression of the first query is nullable and that the first expression is null preserving. The database management system may generate optimized query code for the first query. The optimized query code may comprise a first code segment and a conditional jump instruction. The first code segment that, when executed by a processor, may cause the processor to perform operations comprising determining a value of the first expression. The conditional jump instruction may, when executed by the processor, cause the processor to perform operations comprising: skipping execution of at least a portion of the first code segment and returning null for the first expression.Type: GrantFiled: September 12, 2017Date of Patent: October 18, 2022Assignee: SAP SEInventors: Maik Goergens, Jonathan Dees
-
Patent number: 11429636Abstract: Technologies are provided for scaling applications via application scenarios. Portions of application resource content stored in a database are associated with application scenarios. The portions of the resource content associated with an application scenario are replicated to one or more computing nodes associated with the application scenario. Requests associated with the application scenario are transmitted to the one or more one or more computing nodes, where they are processed using the replicated portions of the resource content associated with the application scenario.Type: GrantFiled: September 25, 2020Date of Patent: August 30, 2022Assignee: SAP SEInventors: Achim Becker, Franz Faerber, Florian Foebel, Kesavaprakash Vasudevan, Martin Weidner, Jonathan Dees
-
Patent number: 11106676Abstract: Techniques are described for efficient execution of analytical queries on large amounts of data in a parallel database cluster while making maximal use of the available hardware.Type: GrantFiled: December 23, 2014Date of Patent: August 31, 2021Assignee: SAP SEInventors: Martin Weidner, Jonathan Dees, Peter Sanders
-
Publication number: 20210011928Abstract: Technologies are provided for scaling applications via application scenarios. Portions of application resource content stored in a database are associated with application scenarios. The portions of the resource content associated with an application scenario are replicated to one or more computing nodes associated with the application scenario. Requests associated with the application scenario are transmitted to the one or more one or more computing nodes, where they are processed using the replicated portions of the resource content associated with the application scenario.Type: ApplicationFiled: September 25, 2020Publication date: January 14, 2021Applicant: SAP SEInventors: Achim Becker, Franz Faerber, Florian Foebel, Kesavaprakash Vasudevan, Martin Weidner, Jonathan Dees
-
Patent number: 10824639Abstract: Technologies are provided for scaling applications via application scenarios. Portions of application resource content stored in a database are associated with application scenarios. The portions of the resource content associated with an application scenario are replicated to one or more computing nodes associated with the application scenario. Requests associated with the application scenario are transmitted to the one or more one or more computing nodes, where they are processed using the replicated portions of the resource content associated with the application scenario.Type: GrantFiled: December 18, 2015Date of Patent: November 3, 2020Assignee: SAP SEInventors: Achim Becker, Franz Faerber, Florian Foebel, Kesavaprakash Vasudevan, Martin Weidner, Jonathan Dees
-
Patent number: 10628419Abstract: A pattern can be identified in at least part of a query whose definition is received in a query request. The identified pattern can be matched with a set of pre-defined patterns, each of which has associated therewith at least one pre-compiled query execution sub-component of a plurality of pre-compiled query execution sub-components retained in a library. A plan for executing the query can be generated, for example by incorporating the pre-compiled query execution sub-component associated with the matched pattern into the plan based on a pseudo code representation of the plan derived from the definition.Type: GrantFiled: August 18, 2016Date of Patent: April 21, 2020Assignee: SAP SEInventors: Jonathan Dees, Peter Sanders, Franz Faerber, Jochen Seidel
-
Patent number: 10542127Abstract: Disclosed herein are system, method, and computer program product embodiments for fault tolerant communications in a distributed system. An embodiment operates by determining a failure of a first node of a cluster of a plurality of nodes. Prior to the failure, a second node transmitted a first message to the first node. The second node determines content corresponding to the first message. A third node to which to provide the content of the first sub-task is identified. A second message, including content corresponding to the first message, is transmit to the third node.Type: GrantFiled: September 6, 2017Date of Patent: January 21, 2020Assignee: SAP SEInventors: Jan Stengler, Jonathan Dees, Martin Weidner
-
Publication number: 20190079974Abstract: Various examples are directed to systems and methods optimizing database queries. A database management system may receive a first query comprising a plurality of query expressions. The database management system may determine that a first expression of the first query is nullable and that the first expression is null preserving. The database management system may generate optimized query code for the first query. The optimized query code may comprise a first code segment and a conditional jump instruction. The first code segment that, when executed by a processor, may cause the processor to perform operations comprising determining a value of the first expression. The conditional jump instruction may, when executed by the processor, cause the processor to perform operations comprising: skipping execution of at least a portion of the first code segment and returning null for the first expression.Type: ApplicationFiled: September 12, 2017Publication date: March 14, 2019Inventors: Maik Goergens, Jonathan Dees
-
Publication number: 20190075194Abstract: Disclosed herein are system, method, and computer program product embodiments for fault tolerant communications in a distributed system. An embodiment operates by determining a failure of a first node of a cluster of a plurality of nodes. Prior to the failure, a second node transmitted a first message to the first node. The second node determines content corresponding to the first message. A third node to which to provide the content of the first sub-task is identified. A second message, including content corresponding to the first message, is transmit to the third node.Type: ApplicationFiled: September 6, 2017Publication date: March 7, 2019Inventors: Jan Stengler, Jonathan Dees, Martin Weidner
-
Patent number: 10055480Abstract: Aggregating input into hashtables using just-in-time compilation of compilable code in response to a database query. Compilable code can be generated that is configured to cause a programmable processor to produce one or more hashmaps based on the input database. The one or more hashmaps can correspond to each individual thread from the input. The compilable code can be configured to cause the one or more processors to insert the hashmaps into a scheduler. Compilable code can be generated that is configured to: aggregate elements from the one or more hashmaps into buckets of elements having the same partition identity; rehash the buckets of elements having the same partition identity to reduce the number of groups within the bucket; facilitate the merger of all non-empty elements from each target-partition into a merged-partition.Type: GrantFiled: May 29, 2015Date of Patent: August 21, 2018Assignee: SAP SEInventors: Gordon Gaumnitz, Arnaud Lacurie, Ingo Mueller, Jonathan Dees
-
Patent number: 9964959Abstract: The invention relates to a method and apparatus for inspecting an aircraft fuel tank. The invention also relates to an aircraft fuel tank including an inspection apparatus. The invention provides an aircraft fuel tank, the aircraft fuel tank containing a robotic device. The robotic device is arranged to be movable within the aircraft fuel tank. The robotic device further comprises a sensor for inspecting the aircraft fuel tank.Type: GrantFiled: May 6, 2016Date of Patent: May 8, 2018Assignee: AIRBUS OPERATIONS LIMITEDInventors: Matthew Noel Orchard, Jonathan Dee
-
Publication number: 20170177685Abstract: Technologies are provided for scaling applications via application scenarios. Portions of application resource content stored in a database are associated with application scenarios. The portions of the resource content associated with an application scenario are replicated to one or more computing nodes associated with the application scenario. Requests associated with the application scenario are transmitted to the one or more one or more computing nodes, where they are processed using the replicated portions of the resource content associated with the application scenario.Type: ApplicationFiled: December 18, 2015Publication date: June 22, 2017Applicant: SAP SEInventors: Achim Becker, Franz Faerber, Florian Foebel, Kesavaprakash Vasudevan, Martin Weidner, Jonathan Dees
-
Publication number: 20160357816Abstract: A pattern can be identified in at least part of a query whose definition is received in a query request. The identified pattern can be matched with a set of pre-defined patterns, each of which has associated therewith at least one pre-compiled query execution sub-component of a plurality of pre-compiled query execution sub-components retained in a library. A plan for executing the query can be generated, for example by incorporating the pre-compiled query execution sub-component associated with the matched pattern into the plan based on a pseudo code representation of the plan derived from the definition.Type: ApplicationFiled: August 18, 2016Publication date: December 8, 2016Inventors: Jonathan Dees, Peter Sanders, Franz Faerber, Jochen Seidel
-
Publication number: 20160350394Abstract: Aggregating input into hashtables using just-in-time compilation of compilable code in response to a database query. Compilable code can be generated that is configured to cause a programmable processor to produce one or more hashmaps based on the input database. The one or more hashmaps can correspond to each individual thread from the input. The compilable code can be configured to cause the one or more processors to insert the hashmaps into a scheduler. Compilable code can be generated that is configured to: aggregate elements from the one or more hashmaps into buckets of elements having the same partition identity; rehash the buckets of elements having the same partition identity to reduce the number of groups within the bucket; facilitate the merger of all non-empty elements from each target-partition into a merged-partition.Type: ApplicationFiled: May 29, 2015Publication date: December 1, 2016Inventors: Gordon Gaumnitz, Arnaud Lacurie, Ingo Mueller, Jonathan Dees