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@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@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Yair Zaslavsky <yzaslavs@redhat.com>