...
The database viewer is a configuration support tool for inspecting the contents of the FEWS database (localdatastore). It provides an overview in tabular form of statistics and other metadata (columns) of the timeseries (rows) in the database. From To aid the inspection of data, the user can add or remove columns, and select and filter rows. From the Database Viewer it is also possible to access the content (=values) of selected timeseries by opening the timeseries dialog. The database viewer is available in two different modes:
- Workflow based database viewer - for each available workflow, all timeseries written to the database in that workflow can be inspected. From the Explorer, the Database Viewer can be accessed using <F12> + J.
- Timeseries lister - for the selection made in the Data Viewer or Forecasts (Explorer Tabs) all available timeseries in the database are listed and can be inspected. To enable this mode, some configuration is required.
...
- .
Configuration (mode: timeseries lister)
To enable the timeseries lister, it must be added as explorertask in Explorer.xml:
| No Format |
|---|
<explorerTask name="Timeseries Lister"> <iconFile>tableInfo.jpg</iconFile> <taskClass>nl.wldelft.fews.gui.plugin.timeseriestableviewer.TimeSeriesTableViewer</taskClass> <toolbarTask>true</toolbarTask> <menubarTask>true</menubarTask> <allowMultipleInstances>false</allowMultipleInstances> <accelerator>ctrl T</accelerator> </explorerTask> |
Usage
The database viewer enables the user to inspect the database. The database records are visualised as individual rows, which can be selected. When selected it can be browsed through (all columns) or its values can be inspected through a graph (scalar series) or the spatial display (grid data).
In the top window, workflows are available. When selected, the lower part of the screen shows the records which have been written to the database in this selected workflow. In this lower part, individual rows can be selected as well.
All meta information and statistics are calculated on-the-fly and are not stored. Within selections or filters (e.g. on start/end time) the content of the (visible) columns are updated immediately.
There are many columns which can be viewed: general columns about module instance, location, parameter, disk space and all kind of relevant meta information about the selected record(s).
Besides the 'general' metadata, the basic statistics of that row can be inspected. Thess basic statistics are sum, average, maximum, minimum, etc.
The remaining columns describe the quality of the data. If the user e.g. wants to know how many values are 'unreliable' and how many 'periods' of unreliable data are available, this information can be retrieved. The same is true for all kinds of combinations of doubtful, completed and corrected data. This same functionality (number of records, periods) is available for primary and secondary validation results. This means that the user can inspect number of records and periods of e.g. hard maximums and flag comparison or series comparison.
When many records (rows) are available the user can filter the results. Double-clicking a cell will automatically filter for that value. If you want to filter on e.g. a location, select the location (name or Id) column and press F8 or double-click it. The background color of the cell will turn blue (meaning there's a filter on it).
This filter mechanism is applicable on all available columns, including the Start and End Time. When the users changes the start and/or end time, the visible columns will be updated accordingly.
Context Menu Options
figure 2: context menu of the Database Viewer
...
The list of available columns can be adjusted by (un)selecting the individual elements. Only the selected ones will be visible in Database Viewer after confirming after by clicking <OK>.
Selections can be copied to the clipboard (<Copy Selection> button) and adjusted in a text editor (figure 5). These lists can be shared amongst users (e.g. e-mail). From a text editor you can adjust the list by removing rows, select the remaining rows and then copy it the clipboard (<CTRL+C>) again. After that then use the <Paste Selection> button to update your selected columns (figure 6). See below:
figure 5: Copying the selection of columns to clipboard
figure 6: Pasting the selection of columns from the clipboard
Usage
The database viewer enables the user to inspect the database. The database records are visualised as individual rows, which can be selected. When selected it can be browsed through (all columns) or its values can be inspected through a graph (scalar series) or the spatial display (grid data).
In the top window, workflows are available. When selected, the lower part of the screen shows the records which have been written to the database in this selected workflow. In this lower part, individual rows can be selected as well.
All meta information and statistics are calculated on-the-fly and are not stored. Within selections or filters (e.g. on start/end time) the content of the (visible) columns are updated immediately.
There are many columns which can be viewed. General columns about module instance, location, parameter, disk space and all kind of relevant meta information about the selected record(s).
Besides the 'general' metadata, the basic statistics of that row can be inspected. This basic statistics are sum, average, maximum, minimum etc.
The remaining columns describe the quality of the data. If the user e.g. wants to know how many values are 'unreliable' and how many 'periods' of unreliable data are available, this information can be retrieved. The same is true for all kinds of combinations of doubtful, completed and corrected data. This same functionality (number of records, periods) is available for primary and secondary validation results. This means that the user can inspect number of records and periods of e.g. hard maximums and flag comparison or series comparison.
When many records (rows) are available the user can filter the results. Double-clicking a cell will automatically filter for that value. If you want to filter on e.g. a location, select the location (name or Id) column and press F8 or double-click it. The background color of the cell will turn blue (meaning there's a filter on it).
This filter mechanism is applicable on all available columns, including the Start and End Time. When the users changes the start and/or end time, the visible columns will be updated accordingly.