中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

9 records (took 0.022 seconds)

    INTELLIGENT QUERY PLAN CACHE SIZE MANAGEMENT
    1.
    发明申请
    INTELLIGENT QUERY PLAN CACHE SIZE MANAGEMENT 有权

    公开(公告)号：US20230021502A1

    公开(公告)日：2023-01-26

    申请号：US17381059

    申请日：2021-07-20

    Applicant: SAP SE

    Inventor： Jaeyeon Won ,  Sung Gun Lee ,  Sanghee Lee ,  Boyeong Jeon ,  Hyung Jo Yoon ,  JunGyoung Seong

    IPC: G06F16/2453

    Abstract: 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.

    Automatic Type Determination For Database Programming
    3.
    发明申请
    Automatic Type Determination For Database Programming 有权

    公开(公告)号：US20210240455A1

    公开(公告)日：2021-08-05

    申请号：US16780706

    申请日：2020-02-03

    Applicant: SAP SE

    Inventor： Chanho Jeong ,  Boyeong Jeon ,  Kiyoung Kim

    IPC: G06F8/41

    Abstract: In one embodiment, the present disclosure pertains to automated data type determination of variables that are written in a programming language. In one embodiment, a programming language statement is received. The programming language statement includes a variable, an expression to which the variable is set, and a request to determine a data type of the variable. The expression is processed to deduce a data type of the expression. In certain embodiments, the data type of the expression is then assigned as the data type of the variable such that the data type can be used when the programming language statement is compiled into machine executable code.

    INTELLIGENT QUERY PLAN CACHE SIZE MANAGEMENT
    4.
    发明公开
    INTELLIGENT QUERY PLAN CACHE SIZE MANAGEMENT 审中-公开

    公开(公告)号：US20240232196A1

    公开(公告)日：2024-07-11

    申请号：US18616771

    申请日：2024-03-26

    Applicant: SAP SE

    Inventor： Jaeyeon Won ,  Sung Gun Lee ,  Sanghee Lee ,  Boyeong Jeon ,  Hyung Jo Yoon ,  JunGyoung Seong

    IPC: G06F16/2453

    CPC classification number: G06F16/24542 ,  G06F16/24539

    Abstract: A method for intelligent query plan cache size management can be implemented. The method measures actual compilation times of generating query execution plans for a plurality of incoming queries. At least some of the query execution plans are stored in a query execution plan cache. The method can estimate ideal compilation times of generating the query execution plans for the plurality of incoming queries under an assumption that no query execution plan is evicted from the query execution plan cache, monitor differences between the actual compilation times and the ideal compilation times in continuous time windows, and adjust a size of the query execution plan cache in runtime based on the monitored differences.

    Intelligent query plan cache size management
    5.
    发明授权
    Intelligent query plan cache size management 有权

    公开(公告)号：US11971889B2

    公开(公告)日：2024-04-30

    申请号：US17381059

    申请日：2021-07-20

    Applicant: SAP SE

    Inventor： Jaeyeon Won ,  Sung Gun Lee ,  Sanghee Lee ,  Boyeong Jeon ,  Hyung Jo Yoon ,  JunGyoung Seong

    IPC: G06F16/2453

    CPC classification number: G06F16/24542 ,  G06F16/24539

    Abstract: 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.

    DATABASE MANAGEMENT SYSTEM QUERY PLAN CACHE MANAGEMENT
    6.
    发明申请
    DATABASE MANAGEMENT SYSTEM QUERY PLAN CACHE MANAGEMENT 有权

    公开(公告)号：US20210271679A1

    公开(公告)日：2021-09-02

    申请号：US17322042

    申请日：2021-05-17

    Applicant: SAP SE

    Inventor： Sung Gun Lee ,  Sanghee Lee ,  Hyung Jo Yoon ,  Boyeong Jeon

    IPC: G06F16/2455 ,  G06F16/2453 ,  G06F16/28

    Abstract: According to some embodiments, a system to manage a query plan cache for a Database Management System (“DBMS”) includes a DBMS query plan cache data store. The DBMS query plan cache data store may contain, for example, electronic records representing a plurality of query plans each associated with a set of instructions created in response to a query previously submitted by a user. A DBMS query plan cache management platform may then calculate a utility score for each query plan in the DBMS query plan cache data store. At least one query plan may be evicted from the DBMS query plan cache data store based on the calculated utility score, wherein the evicting is not based on a size of the DBMS query plan cache.

    Database management system query plan cache management
    8.
    发明授权
    Database management system query plan cache management 有权

    公开(公告)号：US11561977B2

    公开(公告)日：2023-01-24

    申请号：US17322042

    申请日：2021-05-17

    Applicant: SAP SE

    Inventor： Sung Gun Lee ,  Sanghee Lee ,  Hyung Jo Yoon ,  Boyeong Jeon

    IPC: G06F16/2455 ,  G06F16/2453 ,  G06F16/28

    Abstract: According to some embodiments, a system to manage a query plan cache for a Database Management System (“DBMS”) includes a DBMS query plan cache data store. The DBMS query plan cache data store may contain, for example, electronic records representing a plurality of query plans each associated with a set of instructions created in response to a query previously submitted by a user. A DBMS query plan cache management platform may then calculate a utility score for each query plan in the DBMS query plan cache data store. At least one query plan may be evicted from the DBMS query plan cache data store based on the calculated utility score, wherein the evicting is not based on a size of the DBMS query plan cache.

    Automatic type determination for database programming
    9.
    发明授权
    Automatic type determination for database programming 有权

    公开(公告)号：US11385874B2

    公开(公告)日：2022-07-12

    申请号：US16780706

    申请日：2020-02-03

    Applicant: SAP SE

    Inventor： Chanho Jeong ,  Boyeong Jeon ,  Kiyoung Kim

    IPC: G06F9/44 ,  G06F8/41

    Abstract: In one embodiment, the present disclosure pertains to automated data type determination of variables that are written in a programming language. In one embodiment, a programming language statement is received. The programming language statement includes a variable, an expression to which the variable is set, and a request to determine a data type of the variable. The expression is processed to deduce a data type of the expression. In certain embodiments, the data type of the expression is then assigned as the data type of the variable such that the data type can be used when the programming language statement is compiled into machine executable code.

Patent Agency Ranking