Multi-axis expand/collapse for relational databases
US9811572B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 21, 2017 |
| Grant date | Nov 7, 2017 |
| Priority date | — |
| Expiry date | Mar 21, 2037 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/287
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
This disclosure describes systems, methods, and apparatus for expanding a row or column in an existing report, sourced from a relational database, where a column or row, respectively, of an opposite axis has already been expanded. Such a need often arises in reports sourced from a SQL database, and overcomes the storage-draining need to precompute all possible arrangements of data from the database prior to displaying the report. In some embodiments, a client can make a request for a multi-axis expansion, and a server can create filters for use in sub queries, one for each level of expansion in an axis of the report opposite to the axis where expansion is requested, the sub queries can be executed, results sets can be combined/formatted to form a new report, and the new report can be returned to the client for stitching into the existing report.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.