Bug 1302598 - [RFE] Add to ovirt_engine_history views that simplifies users usage of dwh views
Summary: [RFE] Add to ovirt_engine_history views that simplifies users usage of dwh views
Alias: None
Product: ovirt-engine-dwh
Classification: oVirt
Component: Database
Version: 4.0.0
Hardware: Unspecified
OS: Unspecified
Target Milestone: ovirt-4.0.0-beta
: 4.0.0
Assignee: Shirly Radco
QA Contact: Lukas Svaty
Depends On:
TreeView+ depends on / blocked
Reported: 2016-01-28 08:54 UTC by Shirly Radco
Modified: 2016-08-23 01:42 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
To simplify Data Warehouse database views for the user, this update adds a view for each time period (sample, hourly, and daily). The views join the configuration views with statistics views of the entities it relates to, for example network interface and disks. This means three new views have been added for virtual machines, and three for hosts.
Clone Of:
Last Closed: 2016-07-05 07:45:06 UTC
oVirt Team: Metrics
rule-engine: ovirt-4.0.0+
pnovotny: testing_plan_complete-
ylavi: planning_ack+
sradco: devel_ack+
pstehlik: testing_ack+

Attachments (Terms of Use)

System ID Private Priority Status Summary Last Updated
oVirt gerrit 57451 0 master MERGED history: added over_time views to simplify use 2016-05-18 05:08:03 UTC

Description Shirly Radco 2016-01-28 08:54:39 UTC
Description of problem:

We want to add views that will join views to be more user friendly.
That means having for each time period (sample/hourly/daily) views that join the configuration views with statistics views of the entity it relates to.

Comment 1 Sandro Bonazzola 2016-05-02 09:52:26 UTC
Moving from 4.0 alpha to 4.0 beta since 4.0 alpha has been already released and bug is not ON_QA.

Comment 2 Lukas Svaty 2016-06-15 09:21:24 UTC
sanity only
added tables:
v4_0_fully_joined_statistics_hosts_resources_usage_hourly v4_0_fully_joined_statistics_hosts_resources_usage_samples 4_0_fully_joined_statistics_vms_resources_usage_daily     v4_0_fully_joined_statistics_vms_resources_usage_hourly  | v4_0_fully_joined_statistics_vms_resources_usage_samples   

verified in ovirt-engine-dwh-setup-4.0.0-2.el7ev.noarch

Comment 3 Sandro Bonazzola 2016-07-05 07:45:06 UTC
oVirt 4.0.0 has been released, closing current release.

Note You need to log in before you can comment on or make changes to this bug.