公开(公告)号：WO2023033719A2

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

申请号：PCT/SG2022/050540

申请日：2022-07-29

Applicant: LEMON INC.

Inventor： CHEN, Jianjun ,  DING, Yonghua ,  LIU, Ye ,  LI, Fangshi ,  CAO, Lixun ,  LIU, Yang ,  ZHANG, Li ,  ZHANG, Mingyi ,  ZHANG, Lei ,  SHI, Rui

IPC: G06F16/27 ,  G06F16/28 ,  G06F16/22 ,  G06F16/901 ,  G06F16/23 ,  G06F16/2433 ,  G06F16/24575 ,  G06F16/258 ,  G06F16/278 ,  G06F16/283

Abstract: The present disclosure describes hybrid transactional and analytical processing (HTAP) techniques. A HTAP system comprises a first processing engine configured to perform online transactional processing, a second processing engine configured to perform online analytical processing, and a storage in communication with the first processing engine and the second processing engine. The first processing engine, the second processing engine, and the storage may be modularized and configured to be decoupled from each other. The system may be configured to capture data by the first processing engine in real time, organize the data in a first format in a first part of the storage for use by the first processing engine, propagate the data to a second part of the storage subsystem, and organize the data in a second format in the second part of the storage for use by the second processing engine.

公开(公告)号：WO2023033720A2

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

申请号：PCT/SG2022/050549

申请日：2022-08-02

Applicant: LEMON INC.

Inventor： CHEN, Jianjun ,  DING, Yonghua ,  LIU, Ye ,  LI, Fangshi ,  CAO, Lixun ,  LIU, Yang ,  ZHANG, Li ,  ZHANG, Mingyi ,  MENG, Xiangrui ,  ZHAO, Junda ,  ZHANG, Lei ,  SHI, Rui

IPC: G06F16/23 ,  G06F16/27 ,  G06F16/28 ,  G06F16/22 ,  G06F16/901 ,  G06F16/2358 ,  G06F16/2365 ,  G06F16/278 ,  G06F16/283

Abstract: The present disclosure describes techniques of providing data consistency for hybrid transactional and analytical processing. Logical logs and log serial numbers (LSNs) associated with the logical logs may be generated based on data captured by a first processing engine. The logical logs and the LSNs may be propagated to a storage subsystem configured to be in communication with the first processing engine and a second processing engine. The LSNs and information indicative of LSN schema versions may be stored and distributed by a metadata service. The first processing engine, the second processing engine, the storage subsystem and the metadata service are modularized, and support a LSN mechanism for maintaining data consistency.

公开(公告)号：EP4488843A1

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

申请号：EP24185149.2

申请日：2024-06-27

Applicant: DOUYIN VISION CO., LTD. ,  Lemon Inc.

Inventor： FAN, Liya ,  ZHOU, Dongyan ,  CAO, Jianhua ,  WANG, Dongwei ,  CHEN, Heng ,  SHI, Rui ,  CHEN, Jianjun

IPC: G06F16/2453

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.

公开(公告)号：EP4330831A2

公开(公告)日：2024-03-06

申请号：EP22865179.0

申请日：2022-08-02

Applicant: Lemon Inc.

Inventor： CHEN, Jianjun ,  DING, Yonghua ,  LIU, Ye ,  LI, Fangshi ,  CAO, Lixun ,  LIU, Yang ,  ZHANG, Li ,  ZHANG, Mingyi ,  MENG, Xiangrui ,  ZHAO, Junda ,  ZHANG, Lei ,  SHI, Rui

IPC: G06F16/23 ,  G06F16/27 ,  G06F16/28 ,  G06F16/22 ,  G06F16/901

公开(公告)号：EP4309050A2

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

申请号：EP22865178.2

申请日：2022-07-29

Applicant: Lemon Inc.

Inventor： CHEN, Jianjun ,  DING, Yonghua ,  LIU, Ye ,  LI, Fangshi ,  CAO, Lixun ,  LIU, Yang ,  ZHANG, Li ,  ZHANG, Mingyi ,  ZHANG, Lei ,  SHI, Rui

IPC: G06F16/27 ,  G06F16/28 ,  G06F16/22 ,  G06F16/901 ,  G06F16/23