Patents by Inventor Edward-Robert Tyercha
Edward-Robert Tyercha 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).
-
Publication number: 20230066096Abstract: Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.Type: ApplicationFiled: November 10, 2022Publication date: March 2, 2023Inventors: Edward-Robert Tyercha, Janardhan Hungund, Deepak Shrivastava
-
Patent number: 11526527Abstract: Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.Type: GrantFiled: April 4, 2019Date of Patent: December 13, 2022Assignee: SAP SEInventors: Edward-Robert Tyercha, Janardhan Hungund, Deepak Shrivastava
-
Publication number: 20220100715Abstract: A physio-logical migration of a database from a source system to a target system may include exporting a catalog of the database in a data interchange format that preserves the hierarchical dependencies present amongst the entities included in the catalog. The physio-logical migration of the database may further include exporting the contents of a table in the database in a binary format compatible at the target system. The binary format may be a data buffer having a metadata portion, a fixed-size portion, and a page chain portion. Where the target system is a cloud-based system, the physio-logical migration of the database may include exporting the catalog and the contents of the table to a cloud-based object store before importing the catalog and the contents of the table to the target system. Related systems and articles of manufacture, including computer program products, are also provided.Type: ApplicationFiled: March 23, 2021Publication date: March 31, 2022Inventors: Juchang Lee, Ivan Veselinov Andreev, Eunsang Kim, Jaehwa Kim, Yong Sik Kwon, Joo Yeon Lee, Jian Luo, Myunggon Park, Edward-Robert Tyercha, Zheng-Wei Wang, Paul Willems
-
Patent number: 11042568Abstract: A computer implemented method for monitoring databases includes providing views for monitoring information associated with a first datacenter and proxy views for monitoring information associated with a second datacenter. The first datacenter receives a query for monitoring information and parses the query to identify filter information that identifies which of the first or second datacenter the requested services are running on. If the filter information indicates the service is running on the first datacenter, the first datacenter queries the views to request the monitoring information from the server on the first datacenter running the requested service. If the filter information indicates the service is running on the second datacenter, the first datacenter queries the proxy views to request the monitoring information from the server on the second datacenter running the requested service, and receives the monitoring information. Related apparatus, systems, techniques and articles are also described.Type: GrantFiled: June 28, 2019Date of Patent: June 22, 2021Assignee: SAP SEInventors: Edward-Robert Tyercha, Thomas Simenec, Thomas Koetter, Reiner Singer
-
Publication number: 20200320087Abstract: Computer-implemented methods, systems and products, the method comprising receiving, at a data server associated with a database, a command for data transfer between a client machine and the data server over a communications network, the data being stored in at least a data table comprising one or more columns; in response to receiving the command for data transfer, determining whether one or more columns of the data table are designated; identifying the one or more designated columns, such that data associated with the one or more designated columns is either considered or not considered for purpose of the data transfer; and executing the command to transfer the data in the database according to the designated columns.Type: ApplicationFiled: April 4, 2019Publication date: October 8, 2020Inventors: Edward-Robert Tyercha, Janardhan Hungund, Deepak Shrivastava
-
Patent number: 10706019Abstract: Disclosed herein are system, method, and computer program product embodiments for performing database processing after a lock condition. An embodiment operates by receiving a release of a lock on data of a database. It is determined whether the data was modified by a processing of a first transaction associated with the first request. The lock is provided to a second transaction associated with a second request to access the data. If the first transaction did not modify the data, a second transaction associated with the second request is retried without refreshing a snapshot of the data. If the first transaction modified the data, the snapshot of the data is refreshed before the second transaction is retried.Type: GrantFiled: September 22, 2015Date of Patent: July 7, 2020Assignee: SAP SEInventors: Andreas Tonder, Martin Heidel, Edward-Robert Tyercha, Juchang Lee
-
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: 20190324974Abstract: A computer implemented method for monitoring databases includes providing views for monitoring information associated with a first datacenter and proxy views for monitoring information associated with a second datacenter. The first datacenter receives a query for monitoring information associated with services running on the first datacenter and/or the second datacenter. The first datacenter parses the query to identify filter information that identifies which of the first or second datacenter the requested services are running on. If the filter information indicates the service is running on the first datacenter, the first datacenter queries the views to request the monitoring information from the server on the first datacenter running the requested service.Type: ApplicationFiled: June 28, 2019Publication date: October 24, 2019Inventors: Edward-Robert Tyercha, Thomas Simenec, Thomas Koetter, Reiner Singer
-
Patent number: 10380130Abstract: A query of spatial data is received by a database comprising a columnar data store storing data in a column-oriented structure. Thereafter, a minimal bounding rectangle associated with the query is identified using a grid order scanning technique. The spatial data set corresponding to the received query is then mapped to physical storage in the database using the identified minimal bounding rectangle so that the spatial data set can be retrieved. Related apparatus, systems, techniques and articles are also described.Type: GrantFiled: June 27, 2017Date of Patent: August 13, 2019Assignee: SAP SEInventors: Edward-Robert Tyercha, Gerrit Simon Kazmaier, Hinnerk Gildhoff, Isil Pekel, Lars Volker, Tim Grouisborn
-
Patent number: 10380142Abstract: A computer implemented method for monitoring databases includes providing views for monitoring information associated with a first datacenter and proxy views for monitoring information associated with a second datacenter. The first datacenter receives a query for monitoring information and parses the query to identify filter information that identifies which of the first or second datacenter the requested services are running on. If the filter information indicates the service is running on the first datacenter, the first datacenter queries the views to request the monitoring information from the server on the first datacenter running the requested service. If the filter information indicates the service is running on the second datacenter, the first datacenter queries the proxy views to request the monitoring information from the server on the second datacenter running the requested service, and receives the monitoring information. Related apparatus, systems, techniques and articles are also described.Type: GrantFiled: November 28, 2016Date of Patent: August 13, 2019Assignee: SAP SEInventors: Edward-Robert Tyercha, Thomas Simenec, Thomas Theodor Koetter, Reiner Singer
-
Patent number: 10318557Abstract: DBSCAN clustering analyses can be improved by pre-processing of a data set using a Hilbert curve to intelligently identify the centers for initial partitional analysis by a partitional clustering algorithm such as CLARANS. Partitions output by the partitional clustering algorithm can be process by DBSCAN running in parallel before intermediate cluster results are merged.Type: GrantFiled: June 9, 2017Date of Patent: June 11, 2019Assignee: SAP SEInventors: Edward-Robert Tyercha, Gerrit Simon Kazmaier, Hinnerk Gildhoff, Isil Pekel, Lars Volker, Tim Grouisborn
-
Publication number: 20180150541Abstract: A computer implemented method for monitoring databases includes providing views for monitoring information associated with a first datacenter and proxy views for monitoring information associated with a second datacenter. The first datacenter receives a query for monitoring information associated with services running on the first datacenter and/or the second datacenter. The first datacenter parses the query to identify filter information that identifies which of the first or second datacenter the requested services are running on. If the filter information indicates the service is running on the first datacenter, the first datacenter queries the views to request the monitoring information from the server on the first datacenter running the requested service.Type: ApplicationFiled: November 28, 2016Publication date: May 31, 2018Inventors: Edward-Robert Tyercha, Thomas Simenec, Thomas Theodor Koetter, Reiner Singer
-
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
-
Publication number: 20170308605Abstract: DBSCAN clustering analyses can be improved by pre-processing of a data set using a Hilbert curve to intelligently identify the centers for initial partitional analysis by a partitional clustering algorithm such as CLARANS. Partitions output by the partitional clustering algorithm can be process by DBSCAN running in parallel before intermediate cluster results are merged.Type: ApplicationFiled: June 9, 2017Publication date: October 26, 2017Inventors: Edward-Robert Tyercha, Gerrit Simon Kazmaier, Hinnerk Gildhoff, Isil Pekel, Lars Volker, Tim Grouisborn
-
Publication number: 20170293662Abstract: A query of spatial data is received by a database comprising a columnar data store storing data in a column-oriented structure. Thereafter, a minimal bounding rectangle associated with the query is identified using a grid order scanning technique. The spatial data set corresponding to the received query is then mapped to physical storage in the database using the identified minimal bounding rectangle so that the spatial data set can be retrieved. Related apparatus, systems, techniques and articles are also described.Type: ApplicationFiled: June 27, 2017Publication date: October 12, 2017Inventors: Edward-Robert Tyercha, Gerrit Simon Kazmaier, Hinnerk Gildhoff, Isil Pekel, Lars Volker, Tim Grouisborm
-
Patent number: 9720931Abstract: A query of spatial data is received by a database comprising a columnar data store storing data in a column-oriented structure. Thereafter, a minimal bounding rectangle associated with the query is identified using a grid order scanning technique. The spatial data set corresponding to the received query is then mapped to physical storage in the database using the identified minimal bounding rectangle so that the spatial data set can be retrieved. Related apparatus, systems, techniques and articles are also described.Type: GrantFiled: May 9, 2014Date of Patent: August 1, 2017Assignee: SAP SEInventors: Edward-Robert Tyercha, Gerrit Simon Kazmaier, Hinnerk Gildhoff, Isil Pekel, Lars Volker, Tim Grouisborn
-
Patent number: 9703856Abstract: DBSCAN clustering analyses can be improved by pre-processing of a data set using a Hilbert curve to intelligently identify the centers for initial partitional analysis by a partitional clustering algorithm such as CLARANS. Partitions output by the partitional clustering algorithm can be process by DBSCAN running in parallel before intermediate cluster results are merged.Type: GrantFiled: July 7, 2014Date of Patent: July 11, 2017Assignee: SAP SEInventors: Edward-Robert Tyercha, Gerrit Simon Kazmaier, Hinnerk Gildhoff, Isil Pekel, Lars Volker, Tim Grouisborn
-
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
-
Patent number: 9613055Abstract: A query of spatial data is received by a database comprising a columnar data store storing data in a column-oriented structure. Thereafter, a minimal bounding rectangle associated with the query is identified using a tree-order scanning technique. A spatial data set that corresponds to the received query is then mapped to the physical storage in the database using the identified minimal bounding rectangle. Next, the spatial data set is then retrieved. Related apparatus, systems, techniques and articles are also described.Type: GrantFiled: May 9, 2014Date of Patent: April 4, 2017Assignee: SAP SEInventors: Edward-Robert Tyercha, Gerrit Simon Kazmaier, Hinnerk Gildhoff, Isil Pekel, Lars Volker, Tim Grouisborn