View source for 18835589. JOIN OPERATIONS FOR DATASETS WITH INCONSISTENT DIMENSIONS (Google LLC)

<!-- JSON-LD markup for search engines:
{"@context":"https://schema.org","@type":"TechArticle","headline":"JOIN OPERATIONS FOR DATASETS WITH INCONSISTENT DIMENSIONS","name":"JOIN OPERATIONS FOR DATASETS WITH INCONSISTENT DIMENSIONS","description":"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, whe...","datePublished":"2022-06-14","mainEntity":{"@type":"Patent","identifier":"18835589","name":"JOIN OPERATIONS FOR DATASETS WITH INCONSISTENT DIMENSIONS","abstract":"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.","applicationNumber":"18835589","datePublished":"2022-06-14","inventor":[{"@type":"Person","name":"Richard Stapenhurst"},{"@type":"Person","name":"Christopher Thompson-Walsh"},{"@type":"Person","name":"Alexandru Okros"},{"@type":"Person","name":"Andrea Ambu"}],"applicant":{"@type":"Organization","name":"Google LLC"},"additionalProperty":[{"@type":"PropertyValue","name":"IPC Classification","value":"G06F16/2455"},{"@type":"PropertyValue","name":"IPC Classification","value":"G06F16/21"},{"@type":"PropertyValue","name":"IPC Classification","value":"G06F16/2452"},{"@type":"PropertyValue","name":"CPC Classification","value":"G06F16/2456"}]}}
-->

=JOIN OPERATIONS FOR DATASETS WITH INCONSISTENT DIMENSIONS=


==Organization Name==

[[:Category:Google LLC|Google LLC]]


[[Category:Google LLC]]

==Inventor(s)==

[[:Category:Richard Stapenhurst of London GB|Richard Stapenhurst of London GB]][[Category:Richard Stapenhurst of London GB]]

[[:Category:Christopher Thompson-walsh of London GB|Christopher Thompson-walsh of London GB]][[Category:Christopher Thompson-walsh of London GB]]

[[:Category:Alexandru Okros of London GB|Alexandru Okros of London GB]][[Category:Alexandru Okros of London GB]]

[[:Category:Andrea Ambu of London GB|Andrea Ambu of London GB]][[Category:Andrea Ambu 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.



[[Category:G06F16/2455]]
[[Category:G06F16/21]]
[[Category:G06F16/2452]]
[[Category:CPC_G06F16/2456]]