中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

39 records (took 0.018 seconds)

    UNIFIED TABLE QUERY PROCESSING
    31.
    发明申请
    UNIFIED TABLE QUERY PROCESSING 有权

    公开(公告)号：US20210224280A1

    公开(公告)日：2021-07-22

    申请号：US17220556

    申请日：2021-04-01

    Applicant: SAP SE

    Inventor： Franz Faerber ,  Juchang Lee ,  Ivan Schreter

    IPC: G06F16/2455 ,  G06F16/24 ,  G06F16/21 ,  G06F16/22

    Abstract: A system and method of query processing in a multi-level storage system having a unified table architecture. A query is received by a common query execution engine connected with the unified table architecture, the query specifying a data record. The common query execution engine performs a look-up for the data record based on the query at the first level storage structure. If the data record is not present at the first level storage structure, the common query execution engine performs separate look-ups in each of the second level storage structure and the main store.

    Performing complex operations in a database using a semantic layer
    33.
    发明授权
    Performing complex operations in a database using a semantic layer 有权

    公开(公告)号：US09842137B2

    公开(公告)日：2017-12-12

    申请号：US14590769

    申请日：2015-01-06

    Applicant: SAP SE

    Inventor： Franz Faerber ,  Daniel Baeumges ,  Tobias Mindnich ,  Christoph Weyerhaeuser

    IPC: G06F17/30

    CPC classification number: G06F17/30463 ,  G06F17/30315 ,  G06F17/30404 ,  G06F17/30433 ,  G06F17/30471

    Abstract: The present invention includes a database with a semantic layer for performing standard SQL and complex operations custom to one or more application. In one embodiment the present invention includes receiving a data request from an application in a database, the data request specifying standard SQL operations and custom application operations to be performed for said application. The data request is processed in a semantic layer of the database. The semantic layer processes the standard SQL operations and the custom application operations and generates a logical execution plan comprising the standard SQL operations and the custom application operations. The logical execution plan is converted into a physical execution plan, which is executed by the database to generate a data result. The data result may be sent back to the application.

    Deleting records in a multi-level storage architecture
    35.
    发明授权
    Deleting records in a multi-level storage architecture 有权

    公开(公告)号：US09740715B2

    公开(公告)日：2017-08-22

    申请号：US14827231

    申请日：2015-08-14

    Applicant: SAP SE

    Inventor： Franz Faerber ,  Juchang Lee ,  Ivan Schreter

    IPC: G06F7/00 ,  G06F17/00 ,  G06F17/30

    CPC classification number: G06F17/30303 ,  G06F17/30289 ,  G06F17/30306 ,  G06F17/30315 ,  G06F17/30345 ,  G06F17/30371

    Abstract: Deleting a data record from the second level storage or main store is disclosed. A look-up is performed for the data record in the first level storage, where the data record is defined by a row identifier. If the row identifier is found in the first level storage, a look-up is performed for an updated row identifier representing an update of the data record in the second level storage and the main store, the update of the data record being defined by an updated row identifier. If the updated row identifier is found in the second level storage, an undo log is generated from the first level storage to invalidate a row identifier of the row identifier. A flag is generated representing an invalid updated row identifier, and a redo log is generated to restore the data record in the first level storage.

    Many-core algorithms for in-memory column store databases
    37.
    发明授权
    Many-core algorithms for in-memory column store databases 有权
    内存列存储数据库的多核算法

    公开(公告)号：US09424313B2

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

    申请号：US14566953

    申请日：2014-12-11

    Applicant: SAP SE

    Inventor： Jonathan Dees ,  Peter Sanders ,  Franz Faerber ,  Jochen Seidel

    IPC: G06F17/30

    CPC classification number: G06F17/30466 ,  G06F17/30463

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

    Abstract translation: 可以在查询的至少一部分中识别模式，该查询的定义在查询请求中被接收。 所识别的模式可以与一组预先定义的模式相匹配，每一模式都与保存在库中的多个预编译查询执行子组件的至少一个预编译查询执行子组件相关联。 可以生成用于执行查询的计划，例如通过基于从定义导出的计划的伪代码表示将与匹配模式相关联的预编译查询执行子组件合并到计划中。

    LOGLESS ATOMIC DATA MOVEMENT
    38.
    发明申请
    LOGLESS ATOMIC DATA MOVEMENT 有权
    无痕原子数据运动

    公开(公告)号：US20160042028A1

    公开(公告)日：2016-02-11

    申请号：US14827236

    申请日：2015-08-14

    Applicant: SAP SE

    Inventor： Franz Faerber ,  Juchang Lee ,  Ivan Schreter

    IPC: G06F17/30 ,  G06F3/06

    CPC classification number: G06F17/30371 ,  G06F3/0604 ,  G06F3/0638 ,  G06F3/0644 ,  G06F3/0647 ,  G06F3/065 ,  G06F3/0652 ,  G06F3/0673 ,  G06F3/0683 ,  G06F17/30117 ,  G06F17/30153 ,  G06F17/30315 ,  G06F17/30348 ,  G06F17/30377 ,  G06F17/30575 ,  G06F17/30587

    Abstract: A system and method of logless atomic data movement. An internal transaction is started within a multi-level storage architecture, the internal transaction to merge data from the first level storage structure to the second level storage structure. Committed data is read from a first level storage structure of the multi-level storage architecture as specified by the internal transaction. The committed data from the first level storage structure is inserted into a second level storage structure in a bulk insertion process, and the committed data is marked as being deleted from the first level storage. The internal transaction is then committed to the multi-level storage architecture when the committed data has been inserted into the second level storage structure.

    Abstract translation: 无原子数据运动的系统和方法。 内部事务在多级存储架构内启动，内部事务将数据从第一级存储结构合并到第二级存储结构。 从内部事务指定的多级存储架构的第一级存储结构读取提交的数据。 来自第一级存储结构的提交的数据被插入到批量插入过程中的第二级存储结构中，并且所提交的数据被标记为从第一级存储器中删除。 当提交的数据已插入到第二级存储结构中时，内部事务将被提交到多级存储架构。

Patent Agency Ranking