Hierarchical dimension analysis in multi-dimensional pivot grids
US10585892B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 12, 2015 |
| Grant date | Mar 10, 2020 |
| Priority date | — |
| Expiry date | Nov 2, 2035 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/283
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method facilitating transforming or updating displayed data using data hierarchy information. An example method includes storing hierarchy information characterizing a dataset via one or more tree tables; selectively accessing a database to update data characterized by metadata of the one or more tree tables; employing one or more pivot grids to replicate one or more hierarchical properties of the one or more tree tables; and displaying information based on the one or more pivot grids. The displaying step may further include using the pivot grid(s) to generate and display analytic(s), wherein data for the pivot grid(s) and analytics(s) is obtained from flattened tree tables. Dynamically executed Structured Query Language (SQL) construct(s) may retrieve un-cached fresh multi-dimensional data used for the pivot grid(s) or analytic(s) in a manner consistent with hierarchy information retrieved (via SQL) from the tree tables as tree metadata.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.