Updating shared and independent materialized views in a multi-tenant environment
Shared materialized views are maintained during data changes to the primary data and during creation of new materialized views. Shared data stored for use by shared materialized views is distinguished from data stored by an independent materialized view. A view selector manages data updates to shared materialized views and corresponding mapping table. The view selector directs movement of data between a shared materialized view and an independent materialized view through the lifecycle of the materialized views.
1. A computer-implemented method comprising:
monitoring a change data feed to a primary data store for an update to a data operation;
responsive to detecting the update, analyzing the update for effect on stored materialized views;
identifying a set of stored materialized views that require updating due to the update to the data operation, the set of stored materialized views including shared materialized views using shared data stored in a shared materialized view store, and an independent materialized view using derived data; and
taking an update action on the set of stored materialized views, the update action including:
moving the derived data to the shared materialized view store; and
updating a mapping table for the shared data to include the derived data for the independent materialized view.
2. The computer-implemented method of claim 1 , wherein the update to a data operation is one of adding a data operation and deleting a data operation.
3. The computer-implemented method of claim 1 , further comprising:
collecting a set of queries against the primary data store;
identifying candidate queries to request against a materialized view;
determining to store query data derived from the candidate queries as either shared data or independent data; and
storing the shared data in the shared materialized view store for shared materialized views.
4. The computer-implemented method of claim 3 , further comprising:
creating the mapping table for the shared data; and
storing the mapping table in the shared materialized view store.
5. A computer program product comprising a computer-readable storage medium having a set of instructions stored therein which, when executed by a processor, causes the processor to perform a method comprising:
monitoring a change data feed to a primary data store for an update to a data operation;
responsive to detecting the update, analyzing the update for effect on stored materialized views;
identifying a set of stored materialized views that require updating due to the update to the data operation, the set of stored materialized views including shared materialized views using shared data stored in a shared materialized view store, and an independent materialized view using derived data; and
taking an update action on the set of stored materialized views, the update action including:
moving the derived data to the shared materialized view store; and
updating a mapping table for the shared data to include the derived data for the independent materialized view.
6. The computer program product of claim 5 , wherein the update to a data operation is one of adding a data operation and deleting a data operation.
7. The computer program product of claim 5 , further comprising:
collecting a set of queries against the primary data store;
identifying candidate queries to request against a materialized view;
determining to store query data derived from the candidate queries as either shared data or independent data; and
storing the shared data in the shared materialized view store for shared materialized views.
8. The computer program product of claim 7 , further comprising:
creating the mapping table for the shared data; and
storing the mapping table in the shared materialized view store.
9. A computer system comprising:
a processor set; and
a computer readable storage medium;
wherein:
the processor set is structured, located, connected, and/or programmed to run program instructions stored on the computer readable storage medium; and
the program instructions which, when executed by the processor set, cause the processor set to perform a method comprising:
monitoring a change data feed to a primary data store for an update to a data operation;
responsive to detecting the update, analyzing the update for effect of the change on stored materialized views;
identifying a set of stored materialized views that require updating due to the update to the data operation, the set of stored materialized views including shared materialized views using shared data stored in a shared materialized view store, and an independent materialized view using derived data; and
taking an update action on the set of stored materialized views, the update action including:
moving the derived data to the shared materialized view store; and
updating a mapping table for the shared data to include the derived data for the independent materialized view.
10. The computer system of claim 9 , wherein the update to a data operation is one of adding a data operation and deleting a data operation.
11. The computer system of claim 9 , further comprising:
collecting a set of queries against the primary data store;
identifying candidate queries to request against a materialized view;
determining to store query data derived from the candidate queries as either shared data or independent data; and
storing the shared data in the shared materialized view store for shared materialized views.
12. The computer system of claim 11 , further comprising:
creating the mapping table for the shared data; and
storing the mapping table in the shared materialized view store.