Version 1.2 (2002-10-17)
This document describes the design of the web interface to the QC1 database which enables interactive plotting of QC1 parameters.
Because of the large number of existing parameters, it seems generally not useful to offer a tool which can do anything. Therefore this interface is thought for the expert user who wants a 'quick and dirty' tool for interactive plotting of selected QC1 parameters.
The present strategy is to offer the following functionalities:
The interface is an HTML page with a predefined format. It has:
This interface is created from scratch by a script which reads from the format description table (e.g. uves_bias) the relevant information into a template page.
The format description table needs three configuration columns:
plot_flag describes if and in which way a key is relevant for plotting. There are 4 options:
sort_flag is an integer number which is used for user-controlled sorting of multiple options. Multiple values are permitted:
xdy - default choice for x; plotting on y axis also possible
xyd - default choice for y; plotting on x axis also possible
fxy - offered as filter, but also plottable on x and y
keyword_type has one of three
values (gen/qc1/ins) and is used for the qc1_browser interface.
The interface is called qc1_plot. It is a form which consists of 4 tables: X axis, Y axis, filter, options.
The value of plot_flag, together with a set of rules and the sorting flag, describes the way the query interface is constructed.
1. X axis: radio button with default value denoted by XD, shown on top. Other choices (those keys with plot_flag = X or XY) are offered below the default value, sorted by sort_flag. All choices are shown in a table, with columns: radio button, field_name, field_description.
2. Y axis: radio button with default value denoted by YD, shown on top. Other choices (those keys with plot_flag = Y or XY) are offered below the default value, sorted by sort_flag. All choices are shown in a table, with columns: radio button, field_name, field_description.
3. Filter: a set of select boxes (sorted by sort_flag), one for each key with plot_flag = F. All choices are shown in a table, with columns: field_name, select box, field_description. The select box should offer all possible entries ('select distinct...') plus 'any'. The initially selected value should be the first available non-any.
Range in time: select boxes; f"from" and "to"; default values should be: "from" = today minus one month, "to" = today. Format is YYYY-MM-DD.
Statistics options: radio buttons; one set for average, one set for errors. "average" has: none (default), regression, mean. Options are mutually exclusive. "errors" has: none (default), 3 sigma, +/- 10% (mutually exclusive).
Format options: radio buttons; gif (default) and ps .
buttons for "submit" and "reset".
This is the description of the interface only. The plot engine needs to be determined independently. The interface delivers to the plot engine:
This should be sufficient for a unique description of the plot desired. The plot engine then should create a plot as specified, with the additional rules:
The example page uves_bias_plot.html illustrates the concept and the design. It can be used as template.
The set of format description tables for uves is found here (.xls).
comments to <Reinhard.Hanuschik@eso.org>
Last update: Oct 17, 2002