STORAGE ENGINE FOR HYBRID DATA PROCESSING
    2.
    发明申请

    公开(公告)号:WO2023033721A2

    公开(公告)日:2023-03-09

    申请号:PCT/SG2022/050550

    申请日:2022-08-02

    Applicant: LEMON INC.

    Abstract: The present disclosure describes storage techniques for hybrid transactional and analytical processing. Data captured by a first processing engine may be received. The first processing engine may be configured to perform online transactional processing). Multiple replicas of logical logs generated based on the data may be distributed to a Delta Store by applying a quorum protocol on the multiple replicas. Data in the Delta Store are stored in a row format and are visible to a query for online analytical processing performed by a second processing engine. Data may be flushed from the Delta Store to a Base Store based on one or more predetermined rules. Data in the Base Store are stored in a columnar format and may be accessible by the second processing engine.

    DATABASE-BASED DATA PROCESSING METHOD, DEVICE, MEDIUM AND APPARATUS

    公开(公告)号:EP4488843A1

    公开(公告)日:2025-01-08

    申请号:EP24185149.2

    申请日:2024-06-27

    Abstract: The present disclosure relates to a database-based data processing method, device, medium, and apparatus, the method including: receiving a target query statement; determining a corresponding target materialized view for executing the target query statement according to a data query time corresponding to the target query statement and a time granularity of the materialized view in a database, wherein the database is constructed with the materialized view at different time granularities; rewriting the target query statement according to the time granularity of the target materialized view to obtain a plurality of target sub-query statements, wherein the target sub-query statements include sub-query statements which are queried based on the target materialized view; and merging the target sub-query statements, and performing a data query according to a query statement obtained by merging.

Patent Agency Ranking