Eli Mesika has submitted this change and it was merged.
Change subject: core: DB - Snapshot Materialized Views support
......................................................................
core: DB - Snapshot Materialized Views support
Adding Snapshot Materialized Views support to the database.
A Snapshot Materialized View is actually a table built on top of
a real view that enables to select data from the Snapshot Materialized
View easily and efficiently.
Candidates for Snapshot Materialized Views are views that are based on
slowly-changing data. The Snapshot Materialized Views is actually
functioning as a cache.
The Snapshot Materialized View is refreshed per request.
The Snapshot Materialized View definitions are stored in the
materialized_views table.
Change-Id: I17333db996f0e3b1856e2df02a621810c3ebaa53
Signed-off-by: Eli Mesika <emesika(a)redhat.com>
---
M backend/manager/dbscripts/dbfunctions.sh
A backend/manager/dbscripts/materialized_views_sp.sql
A backend/manager/dbscripts/upgrade/post_upgrade/0020_create_materialized_views.sql
A backend/manager/dbscripts/upgrade/pre_upgrade/0030_add_materialized_views_table.sql
4 files changed, 368 insertions(+), 0 deletions(-)
Approvals:
Eli Mesika: Verified; Looks good to me, approved
--
To view, visit
http://gerrit.ovirt.org/10105
To unsubscribe, visit
http://gerrit.ovirt.org/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I17333db996f0e3b1856e2df02a621810c3ebaa53
Gerrit-PatchSet: 6
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Allon Mureinik <amureini(a)redhat.com>
Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com>
Gerrit-Reviewer: Yair Zaslavsky <yzaslavs(a)redhat.com>