Generating reports based on materialized view
US9311357B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Mar 15, 2013 |
| Grant date | Apr 12, 2016 |
| Priority date | — |
| Expiry date | Sep 19, 2033 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24539
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems and methods for generating a report for a resource are described. The report is generated from databases comprising data sets related to a plurality of resources. An example method includes dynamic generation of a first query upon selection of at least one attribute by a user. The first query includes instructions for being performed on the data sets. The method further includes determining that the first query is stored in a table schema. The table schema is associated with a first trigger. The method also includes invoking the first trigger based on the determining. The first trigger is configured to execute the first query to generate a materialized view upon execution of the first query. The method may include generating the report by executing a second query on the materialized view. The second query may be created based on materialized view data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.