公开(公告)号：US12164517B2

公开(公告)日：2024-12-10

申请号：US18092779

申请日：2023-01-03

Applicant: Adobe Inc.

Inventor： Vibhor Porwal ,  Yeuk-Yin Chan ,  Vidit Bhatia ,  Subrata Mitra ,  Shaddy Garg ,  Sergey N Kazarin ,  Sameeksha Arora ,  Himanshu Panday ,  Gautam Pratap Kowshik ,  Fan Du ,  Anup Bandigadi Rao ,  Anil Malkani

IPC: G06F16/245 ,  G06F16/2453 ,  G06F16/2458

Abstract: To retrieve information derived from a plurality of separately stored datasets, join structures are identified within the plurality of separately stored datasets. Join structures can include datasets joined by a central dataset, datasets joined by a single key, and datasets joined across a plurality of keys. Each of the join structures corresponds to a query processing schema that defines a sampling technique. When a join query is received as a SQL query, the join query identifies a portion of the plurality of separately stored datasets, from which a join structure is selected and a corresponding query processing schema is identified. The join query is reconstructed to form a reconstructed join query that comprises query processing schema instructions to derive the requested information using the sampling technique defined by the identified query processing schema.