[Bug 2214] New: [STORY] Aggregated queries with group-by

[bugzilla-daemon at icedtea.classpath.org]

http://icedtea.classpath.org/bugzilla/show_bug.cgi?id=2214

            Bug ID: 2214
           Summary: [STORY] Aggregated queries with group-by
           Product: Thermostat
           Version: hg
          Hardware: x86_64
                OS: Linux
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: Thermostat
          Assignee: unassigned at icedtea.classpath.org
          Reporter: sgehwolf at redhat.com
                CC: thermostat at icedtea.classpath.org

As a user I want to aggregate data using functions (e.g. avg()) over groups of
values in the database. This would be useful for showing coarser grained graphs
over long time ranges.

For example if a memory chart is shown for several weeks, having milliseconds
granularity is not the right thing as the data set returned from the DB would
be massive. In such a case it would make more sense to calculate average values
for 1-hour-intervals and only return the aggregated values.

An alternative could be to have helper collections with pre-calculated averages
for those birds-eye-views of data sets.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.openjdk.java.net/pipermail/distro-pkg-dev/attachments/20150205/d5d467b6/attachment.html>