中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

9 records (took 0.009 seconds)

    Data transfer and management system for in-memory database
    1.
    发明授权
    Data transfer and management system for in-memory database 有权

    公开(公告)号：US11423000B2

    公开(公告)日：2022-08-23

    申请号：US16878894

    申请日：2020-05-20

    Applicant: SAP SE

    Inventor： Nilesh Gohad ,  Adrian Dragusanu ,  Neeraj Kulkarni ,  Dheren Gala

    IPC: G06F16/22 ,  G06F9/54 ,  G06F16/2455 ,  G06F12/0882

    Abstract: Various embodiments for providing a data transfer and management system are described herein. An embodiment operates by determining that data of a column is stored in a column loadable format in which all of the data of the column is moved from the disk storage location to a memory responsive to a data request. A data vector that identifies a plurality of value IDs corresponding to at least a subset of the plurality of rows of the column, is identified. A page format that provides that a portion of the data of the column across a subset of the plurality of rows is moved from the second disk storage location into the memory responsive to the data request is determined. The entries of the data vector are requested, converted from column loadable format into the page persistent format, and stored across one or more memory pages.

    Synopsis based advanced partition elimination
    2.
    发明授权
    Synopsis based advanced partition elimination 有权

    公开(公告)号：US11468093B2

    公开(公告)日：2022-10-11

    申请号：US15796365

    申请日：2017-10-27

    Applicant: SAP SE

    Inventor： Christian Bensberg ,  Alexander Boehm ,  Adrian Dragusanu ,  Xun Cheng ,  Reza Sherkat ,  Anisoara Nica ,  Mihnea Andrei

    IPC: G06F16/23 ,  G06F16/27 ,  G06F16/22 ,  G06F16/2455 ,  G06F16/215

    Abstract: Disclosed herein are system, method, and computer program product embodiments for determining a constraint data statistics object is consistent. An embodiment operates by receiving a query for a database table. The embodiment determines a constraint data statistic object associated with a partition of the database table. The embodiment determines the constraint data statistics object is consistent with a data state of the partition of the database table based on consistency metadata of the constraint data statistics object. The embodiment processes the query for the database table based on the determining the constraint data statistics object is consistent with the data state of the partition of the database table.

    Synopsis Based Advanced Partition Elimination
    6.
    发明申请
    Synopsis Based Advanced Partition Elimination 审中-公开

    公开(公告)号：US20180329974A1

    公开(公告)日：2018-11-15

    申请号：US15796365

    申请日：2017-10-27

    Applicant: SAP SE

    Inventor： Christian Bensberg ,  Alexander Boehm ,  Adrian Dragusanu ,  Xun Cheng ,  Reza Sherkat ,  Anisoara Nica ,  Mihnea Andrei

    IPC: G06F17/30

    CPC classification number: G06F17/30303

    Abstract: Disclosed herein are system, method, and computer program product embodiments for determining a constraint data statistics object is consistent. An embodiment operates by receiving a query for a database table. The embodiment determines a constraint data statistic object associated with a partition of the database table. The embodiment determines the constraint data statistics object is consistent with a data state of the partition of the database table based on consistency metadata of the constraint data statistics object. The embodiment processes the query for the database table based on the determining the constraint data statistics object is consistent with the data state of the partition of the database table.

    Data transfer and management system for in-memory database
    7.
    发明授权
    Data transfer and management system for in-memory database 有权

    公开(公告)号：US11775496B2

    公开(公告)日：2023-10-03

    申请号：US17867487

    申请日：2022-07-18

    Applicant: SAP SE

    Inventor： Nilesh Gohad ,  Adrian Dragusanu ,  Neeraj Kulkarni ,  Dheren Gala

    IPC: G06F16/22 ,  G06F9/54 ,  G06F16/2455 ,  G06F12/0882

    CPC classification number: G06F16/2282 ,  G06F9/54 ,  G06F12/0882 ,  G06F16/221 ,  G06F16/2237 ,  G06F16/24552

    Abstract: Various embodiments for providing a data transfer and management system are described herein. An embodiment operates by determining that data of a column is stored in a column loadable format in which all of the data of the column is moved from the disk storage location to a memory responsive to a data request. A data vector that identifies a plurality of value IDs corresponding to at least a subset of the plurality of rows of the column, is identified. A page format that provides that a portion of the data of the column across a subset of the plurality of rows is moved from the second disk storage location into the memory responsive to the data request is determined. The entries of the data vector are requested, converted from column loadable format into the page persistent format, and stored across one or more memory pages.

    PREPARED EXECUTION PLANS FOR JOINS WITH PARTITIONED TABLES
    8.
    发明申请
    PREPARED EXECUTION PLANS FOR JOINS WITH PARTITIONED TABLES 审中-公开
    准备执行计划与联合表

    公开(公告)号：US20160371329A1

    公开(公告)日：2016-12-22

    申请号：US14746193

    申请日：2015-06-22

    Applicant: SAP SE

    Inventor： Christian Bensberg ,  Wolfgang Stephan ,  Robin Joy ,  Adrian Dragusanu

    IPC: G06F17/30

    CPC classification number: G06F16/24542 ,  G06F16/2456

    Abstract: A computer-implemented method for preparing and executing a plan for a query containing joins against one or more tables having multiple partitions includes receiving a query containing joins to execute against one or more tables in a database, where at least one of the tables includes multiple partitions. Prior to executing the query, the method includes preparing a plan to join the multiple partitions using paths between the joined partitions and storing the plan in a cache. During execution of the query, the method includes analyzing one or more clauses of the query to determine which of the joined partitions to prune from the plan, removing from the plan the paths connecting the pruned partitions and executing the plan without the pruned partitions to return a result to the query.

    Abstract translation: 一种用于准备和执行包含与具有多个分区的一个或多个表的联接的查询的计划的计算机实现的方法，包括接收包含连接以对数据库中的一个或多个表执行的查询，其中至少一个表包括多个 分区。 在执行查询之前，该方法包括准备使用连接的分区之间的路径来连接多个分区并将该计划存储在高速缓存中的计划。 在执行查询期间，该方法包括分析查询的一个或多个子句，以确定从计划中剪除哪个已连接的分区，从计划中删除连接已修剪分区的路径并执行计划，而不需要修剪的分区返回 查询的结果。

    Fair prefetching in hybrid column stores
    9.
    发明授权
    Fair prefetching in hybrid column stores 有权

    公开(公告)号：US11442862B2

    公开(公告)日：2022-09-13

    申请号：US16850310

    申请日：2020-04-16

    Applicant: SAP SE

    Inventor： Robert Schulze ,  Adrian Dragusanu ,  Anup Ghatage ,  Colin Florendo ,  Mihnea Andrei ,  Randall Hammon ,  Sarika Iyer ,  Simhachala Sasikanth Gottapu ,  Yanhong Wang

    IPC: G06F12/08 ,  G06F12/0862 ,  G06F12/0882 ,  G06F16/24 ,  G06F16/22

    Abstract: Disclosed herein are system, method, and computer program product embodiments for performing fair prefetching. An embodiment operates by splitting a data vector into a first subrange and a second subrange. The embodiment performs a first chance prefetch operation on the first subrange based on a fixed number of pages, thereby loading a set of pages of the first subrange into a main memory. The embodiment performs the first chance prefetch operation on the second subrange based on the fixed number of pages, thereby loading a first set of pages of the second subrange into the main memory. The embodiment performs a second chance prefetch operation on the second subrange based on the performing the first chance prefetch operation on the second subrange, thereby loading a second set of pages of the second subrange into the main memory. The embodiment then executes the query.

Patent Agency Ranking