US 11,941,031 B2
Systems and methods for specifying OLAP cube at query time
Stephan Gudmundson, Mountain View, CA (US); Nikhil Teletia, Mountain View, CA (US); Andrew Leeds, Mountain View, CA (US); and John Sismanis, Mountain View, CA (US)
Assigned to GOOGLE LLC, Mountain View, CA (US)
Appl. No. 17/290,543
Filed by Google LLC, Mountain View, CA (US)
PCT Filed Feb. 6, 2019, PCT No. PCT/US2019/016901
§ 371(c)(1), (2) Date Apr. 30, 2021,
PCT Pub. No. WO2020/149865, PCT Pub. Date Jul. 23, 2020.
Claims priority of provisional application 62/792,640, filed on Jan. 15, 2019.
Prior Publication US 2022/0012266 A1, Jan. 13, 2022
Int. Cl. G06F 16/28 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/283 (2019.01) [G06F 16/2264 (2019.01); G06F 16/24552 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system configured for generating an online analytical processing (OLAP) cube, the system comprising:
one or more processors configured by machine-readable instructions to:
receive a query comprising a request for information from a data-source of a relational data warehouse;
receive a cube definition file comprising a schema providing structured data organization of data in the data-source of;
parse data of the data-source to automatically generate a data-source property configuration for the data-source by automatically determining if one or more values of the data-source correspond to a key, an attribute, or a measure;
generate the OLAP cube based on the cube definition file and the data-source property configuration for the determined parsed data from the data-source; and
respond to the query with the information from the data-source, the information obtained based on the generated OLAP cube.