18835589. JOIN OPERATIONS FOR DATASETS WITH INCONSISTENT DIMENSIONS (Google LLC)
JOIN OPERATIONS FOR DATASETS WITH INCONSISTENT DIMENSIONS
Organization Name
Inventor(s)
Richard Stapenhurst of London GB
Christopher Thompson-walsh of London GB
JOIN OPERATIONS FOR DATASETS WITH INCONSISTENT DIMENSIONS
This abstract first appeared for US patent application 18835589 titled 'JOIN OPERATIONS FOR DATASETS WITH INCONSISTENT DIMENSIONS
Original Abstract Submitted
A database system comprising an interface and a processor may perform techniques described in this disclosure. The interface may receive a query for accessing a first dataset and a second dataset, where the query identifies multiple dimensions of the first dataset and the second dataset. The first dataset may include a first dimension, and the second dataset may include a second dimension, but excludes the first dimension. The processor may translate the query into a structured query that conforms to a database query language, where the structured query defines a join between the first dataset and the second dataset over the second dimension. The processor may also transmit the structured query to a database, and receive, responsive to the structured query, an indication that a virtual table was created that combines the first dataset and the second dataset over the second dimension of the second dataset.