Patents by Inventor JunGyoung Seong
JunGyoung Seong 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: 11971889Abstract: A method for intelligent query plan cache size management can be implemented. During execution of a plurality of incoming queries in a database management system, the method can measure actual compilation times of generating query execution plans for the plurality of incoming queries. The database management system can have a query execution plan cache which has a size that can store at least some of the query execution plans. The method can monitor differences between the actual compilation times and ideal compilation times of generating query execution plans for the plurality of incoming queries. The ideal compilation times can be estimated by assuming no query execution plan is evicted from the query execution plan cache. The method can adjust the size of the query execution plan cache based on the monitored differences.Type: GrantFiled: July 20, 2021Date of Patent: April 30, 2024Assignee: SAP SEInventors: Jaeyeon Won, Sung Gun Lee, Sanghee Lee, Boyeong Jeon, Hyung Jo Yoon, JunGyoung Seong
-
Patent number: 11567938Abstract: A computer-implemented method can measure query locality during execution of a plurality of incoming queries in a database management system. The database management system includes a query execution plan cache which has a size that can store at least some of query execution plans generated for the plurality of incoming queries. Based on the measured query locality, the method can adjust the size of the query execution plan cache.Type: GrantFiled: July 20, 2021Date of Patent: January 31, 2023Assignee: SAP SEInventors: Jaeyeon Won, Sung Gun Lee, Sanghee Lee, Boyeong Jeon, Hyung Jo Yoon, JunGyoung Seong
-
Publication number: 20230021502Abstract: A method for intelligent query plan cache size management can be implemented. During execution of a plurality of incoming queries in a database management system, the method can measure actual compilation times of generating query execution plans for the plurality of incoming queries. The database management system can have a query execution plan cache which has a size that can store at least some of the query execution plans. The method can monitor differences between the actual compilation times and ideal compilation times of generating query execution plans for the plurality of incoming queries. The ideal compilation times can be estimated by assuming no query execution plan is evicted from the query execution plan cache. The method can adjust the size of the query execution plan cache based on the monitored differences.Type: ApplicationFiled: July 20, 2021Publication date: January 26, 2023Applicant: SAP SEInventors: Jaeyeon Won, Sung Gun Lee, Sanghee Lee, Boyeong Jeon, Hyung Jo Yoon, JunGyoung Seong
-
Publication number: 20230024210Abstract: A computer-implemented method can measure query locality during execution of a plurality of incoming queries in a database management system. The database management system includes a query execution plan cache which has a size that can store at least some of query execution plans generated for the plurality of incoming queries. Based on the measured query locality, the method can adjust the size of the query execution plan cache.Type: ApplicationFiled: July 20, 2021Publication date: January 26, 2023Applicant: SAP SEInventors: Jaeyeon Won, Sung Gun Lee, Sanghee Lee, Boyeong Jeon, Hyung Jo Yoon, JunGyoung Seong
-
Patent number: 11294903Abstract: A system includes determination, for a first partitioned physical query operator in a query operator tree, of a partition-wise placement cost based on a cost of each table partition associated with the first partitioned physical query operator and a partition-wise placement cost of any child physical query operator of the first partitioned physical query operator, determination of a placement cost for the first partitioned physical query operator physical query operator for each of a plurality of operator execution locations based on the determined partition-wise placement cost, determination, for a logical query operator associated with the first partitioned physical query operator, of a merged placement cost for each of the plurality of operator execution locations, and determination an execution location for the first partitioned physical query operator based on the determined partition-wise placement cost.Type: GrantFiled: April 3, 2019Date of Patent: April 5, 2022Assignee: SAP SEInventors: JunGyoung Seong, Jane Jung Lee, Jung Kook Lee, Sehee Shim
-
Patent number: 11157500Abstract: A system includes determination of a first partition-wise operation on a first database table partition of a first table located at a first server node and a first database table partition of a second table located at a second server node, determination of a first cost to execute the first partition-wise operation on the first server node, and a second cost to execute the first partition-wise operation on the second server node, determination of a second partition-wise operation on a result of the first partition-wise operation, determination of a third cost to execute the second partition-wise operation on the first server node based on the first cost and the second cost, and a fourth cost to execute the second partition-wise operation on the second server node based on the first cost and the second cost, determination of one of the first server node and the second server node to execute the second partition-wise operation based on the third cost and the fourth cost, and determination of one of the first serType: GrantFiled: April 3, 2019Date of Patent: October 26, 2021Assignee: SAP SEInventors: JunGyoung Seong, Jane Jung Lee, Jung Kook Lee
-
Publication number: 20200320076Abstract: A system includes determination of a first partition-wise operation on a first database table partition of a first table located at a first server node and a first database table partition of a second table located at a second server node, determination of a first cost to execute the first partition-wise operation on the first server node, and a second cost to execute the first partition-wise operation on the second server node, determination of a second partition-wise operation on a result of the first partition-wise operation, determination of a third cost to execute the second partition-wise operation on the first server node based on the first cost and the second cost, and a fourth cost to execute the second partition-wise operation on the second server node based on the first cost and the second cost, determination of one of the first server node and the second server node to execute the second partition-wise operation based on the third cost and the fourth cost, and determination of one of the first serType: ApplicationFiled: April 3, 2019Publication date: October 8, 2020Inventors: JunGyoung Seong, Jane Jung Lee, Jung Kook Lee
-
Publication number: 20200320077Abstract: A system includes determination, for a first partitioned physical query operator in a query operator tree, of a partition-wise placement cost based on a cost of each table partition associated with the first partitioned physical query operator and a partition-wise placement cost of any child physical query operator of the first partitioned physical query operator, determination of a placement cost for the first partitioned physical query operator physical query operator for each of a plurality of operator execution locations based on the determined partition-wise placement cost, determination, for a logical query operator associated with the first partitioned physical query operator, of a merged placement cost for each of the plurality of operator execution locations, and determination an execution location for the first partitioned physical query operator based on the determined partition-wise placement cost.Type: ApplicationFiled: April 3, 2019Publication date: October 8, 2020Inventors: JunGyoung Seong, Jane Jung Lee, Jung Kook Lee, Sehee Shim