中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

11 records (took 0.012 seconds)

    Provision of position data for query runtime errors
    1.
    发明授权
    Provision of position data for query runtime errors 有权

    公开(公告)号：US10324929B2

    公开(公告)日：2019-06-18

    申请号：US15339615

    申请日：2016-10-31

    Applicant: SAP SE

    Inventor： Weimin Qi ,  Jaehyok Chong ,  Kihong Kim ,  Yu Wang ,  Di Wu

    IPC: G06F17/30 ,  G06F16/2453 ,  G06F11/36 ,  G06F8/41

    Abstract: A query is parsed and positions of symbols of the query are determined. A parse tree including the positions of the symbols is generated based on the parsed query. The parse tree is sent to a DBMS optimizer. The parse tree is transformed into an optimizer tree. The optimizer tree includes the positions of the symbols of the query.Based on the optimizer tree, a query execution plan is generated for the execution of the query. The positions of the symbols of the query is copied from the optimizer tree into the query execution plan. The query execution plan is sent to a query execution engine.The query is executed in accordance with the query execution plan. When a runtime error is detected, an exception message associated with the runtime error is displayed. The error message includes an error code and the positions of the symbols of the query.

    DYNAMIC QUERY EXPRESSIONS
    2.
    发明申请
    DYNAMIC QUERY EXPRESSIONS 审中-公开

    公开(公告)号：US20200311078A1

    公开(公告)日：2020-10-01

    申请号：US16368448

    申请日：2019-03-28

    Applicant: SAP SE

    Inventor： Zhi Qiao ,  Stefan Baeuerle ,  Ki Hong Kim ,  Florian Scheid ,  Timm Falter ,  Andreas Balzar ,  Di Wu

    IPC: G06F16/2453 ,  G06F16/22 ,  G06F9/54

    Abstract: Implementations of the present disclosure include receiving a query, the query including an expression macro (EM), processing the query to provide a raw parse tree, the raw parse tree including an initial node representative of the EM, retrieving metadata corresponding to the EM, the metadata including a definition string, replacing the initial node with a node based on the definition string to provide a consumable parse tree, and executing the query within the database system using the consumable parse tree to provide a query result.

    HARMONIZED STRUCTURED QUERY LANGUAGE AND NON-STRUCTURED QUERY LANGUAGE QUERY PROCESSING
    3.
    发明申请
    HARMONIZED STRUCTURED QUERY LANGUAGE AND NON-STRUCTURED QUERY LANGUAGE QUERY PROCESSING 审中-公开

    公开(公告)号：US20180293276A1

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

    申请号：US15483690

    申请日：2017-04-10

    Applicant: SAP SE

    Inventor： Jin Uk Bae ,  Stefan Baeuerle ,  Christian Bensberg ,  Steffen Geissinger ,  Ki Hong Kim ,  Taehyung Lee ,  Jaeyun Noh ,  Di Wu ,  Long Zhang

    IPC: G06F17/30

    Abstract: A method can include: generating a query execution plan for a query including a plurality of operations that operate on data from a relational database and data from a non-structured query language (NoSQL) database, the generating comprising optimizing the query by: identifying a first operation that operate on data from the relational database and an intermediate result output by a second operation, the second operation outputting the intermediate result by operating on the data from the NoSQL database; and determining a fixed datatype for the intermediate result, an indication of the fixed datatype being included in the query execution plan; and executing, based on the query execution plan, the query, the executing of the query comprising converting the intermediate result to the fixed datatype, the converting enabling the first operation to operate on the intermediate result output by the second operation along with the data from the relational database.

    PROVISION OF POSITION DATA FOR QUERY RUNTIME ERRORS
    7.
    发明申请
    PROVISION OF POSITION DATA FOR QUERY RUNTIME ERRORS 审中-公开

    公开(公告)号：US20180121326A1

    公开(公告)日：2018-05-03

    申请号：US15339615

    申请日：2016-10-31

    Applicant: SAP SE

    Inventor： Weimin Qi ,  Jaehyok Chong ,  Kihong Kim ,  Yu Wang ,  Di Wu

    IPC: G06F11/36 ,  G06F17/30

    CPC classification number: G06F17/30463 ,  G06F8/427 ,  G06F11/3628 ,  G06F11/3636 ,  G06F17/30474

    Abstract: A query is parsed and positions of symbols of the query are determined. A parse tree including the positions of the symbols is generated based on the parsed query. The parse tree is sent to a DBMS optimizer. The parse tree is transformed into an optimizer tree. The optimizer tree includes the positions of the symbols of the query.Based on the optimizer tree, a query execution plan is generated for the execution of the query. The positions of the symbols of the query is copied from the optimizer tree into the query execution plan. The query execution plan is sent to a query execution engine.The query is executed in accordance with the query execution plan. When a runtime error is detected, an exception message associated with the runtime error is displayed. The error message includes an error code and the positions of the symbols of the query.

    Write access control in a database
    8.
    发明授权
    Write access control in a database 有权

    公开(公告)号：US10275401B2

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

    申请号：US15364649

    申请日：2016-11-30

    Applicant: SAP SE

    Inventor： Chul Won Lee ,  Kyu Hwan Kim ,  Marcel Birn ,  Jane Jung Lee ,  Di Wu ,  Juchang Lee ,  Zhi Qiao

    IPC: G06F16/27 ,  G06F16/23 ,  G06F16/2455 ,  G06F16/903

    Abstract: A computer implemented method for initializing a first image of a first database from a recovery image; modifying the first image of the first database by replaying transaction logs of a second database; establishing a connection with a client; receiving a query via the connection, the query including a transaction to be executed on the first database; and rejecting the query when the transaction would cause any one of: updating of the first image of the first database; generating a new transaction log; and modifying the recovery image. Related apparatus, systems, techniques and articles are also described.

    PROPAGATION OF STRUCTURED QUERY LANGUAGE ASSOCIATIONS
    9.
    发明申请
    PROPAGATION OF STRUCTURED QUERY LANGUAGE ASSOCIATIONS 审中-公开

    公开(公告)号：US20180336245A1

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

    申请号：US15596905

    申请日：2017-05-16

    Applicant: SAP SE

    Inventor： Di Wu ,  Ki Hong Kim ,  Stefan Baeuerle ,  Steffen Weinstock ,  Daniel Hutzel ,  Zhi Qiao

    IPC: G06F17/30

    CPC classification number: G06F16/24535 ,  G06F16/212 ,  G06F16/245 ,  G06F16/24537

    Abstract: A method for propagating a structure query language (SQL) association can include determining, based at least on a syntax of a SQL create view statement, that a SQL association requires propagation to a SQL view associated with the SQL create view statement. The SQL association can combine data from at least a first data model and a second data model at a database. The SQL view can comprise at least a portion of the combined data. An association information data structure can be generated for storing information corresponding to a definition of the SQL association. The SQL create view statement can be executed based on the association information data structure. Related systems and articles of manufacture, including computer program products, are also disclose.

    Dynamic query expressions
    10.
    发明授权
    Dynamic query expressions 有权

    公开(公告)号：US11416485B2

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

    申请号：US16368448

    申请日：2019-03-28

    Applicant: SAP SE

    Inventor： Zhi Qiao ,  Stefan Baeuerle ,  Ki Hong Kim ,  Florian Scheid ,  Timm Falter ,  Andreas Balzar ,  Di Wu

    IPC: G06F16/2453 ,  G06F9/54 ,  G06F16/22

    Abstract: Implementations of the present disclosure include receiving a query, the query including an expression macro (EM), processing the query to provide a raw parse tree, the raw parse tree including an initial node representative of the EM, retrieving metadata corresponding to the EM, the metadata including a definition string, replacing the initial node with a node based on the definition string to provide a consumable parse tree, and executing the query within the database system using the consumable parse tree to provide a query result.

Patent Agency Ranking