Invention Grant
- Patent Title: Materialized view generation
-
Application No.: US15840727Application Date: 2017-12-13
-
Publication No.: US10810196B2Publication Date: 2020-10-20
- Inventor: Kevin Williams , Amit Kumar Singh , Gaurav Roy
- Applicant: Hewlett-Packard Development Company, L.P.
- Applicant Address: US TX Spring
- Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee: Hewlett-Packard Development Company, L.P.
- Current Assignee Address: US TX Spring
- Agency: Perry + Currier Inc
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/2453

Abstract:
There is provided a method including determining whether a selection of database query identifiers is to be made in a fixed manner or a dynamic manner. The method also includes generating a collection including the selection from a list including database query identifiers related to a database. When the selection is to be made in the fixed manner, the selection of the database query identifiers includes a view name and/or database query logic. When the selection is to be made in the dynamic manner, the selection of the database query identifiers includes a corresponding view name. The method also includes generating a materialized view corresponding to a given database query identifier in the collection. Moreover, the method includes storing an identifier of the materialized view in association with the given database query identifier.
Public/Granted literature
- US20190179941A1 MATERIALIZED VIEW GENERATION Public/Granted day:2019-06-13
Information query