Difference between revisions of "Time Series"
(→Time Series elaboration cycle) |
(→Time Series Import) |
||
Line 10: | Line 10: | ||
= Time Series Import = | = Time Series Import = | ||
− | Through a wizard interface a Time Series, represented as a csv file(RFC 4180) is imported through in the system | + | Through a wizard interface a Time Series, represented as a csv file(RFC 4180) is imported through in the system. |
CSV file can either be imported by uploading the file from the user file system or from the user workspace. | CSV file can either be imported by uploading the file from the user file system or from the user workspace. | ||
Line 17: | Line 17: | ||
* Character Encoding | * Character Encoding | ||
+ | * the file header flag | ||
* field separator | * field separator | ||
− | * columns | + | * columns to import/exclude |
− | The configuration | + | The configuration shows a CSV sample based on the selected parameters. This sample is limited to the first 50 rows. |
+ | |||
+ | [[Image:ts_import_wizard.png|frame|none|Time Series import wizard: CSV file configuration]] | ||
Through the sample grid, it is possible to select which columns a user wants to exclude from the importing. | Through the sample grid, it is possible to select which columns a user wants to exclude from the importing. | ||
− | + | [[Image:ts_import_wizard_column_selection.png|frame|none|Time Series import wizard: column selection]] | |
+ | In order to made the system accept the current configuration it is necessary to verify the whole file by clicking on the “Check configuration” button. The system will check then the entire CVS for RFC 4180 compliance. | ||
− | If there is any error it will be possible to see which rows are wrong and , in case, to decide to skip them in the importing phase. | + | If there is any error it will be possible to see which rows are wrong and, in case, to decide to skip them in the importing phase. |
+ | [[Image:ts_import_wizard_errors.png|frame|none|Time Series import wizard: errors]] | ||
Once the importing phase is completed it will be possible to define metadata for the current imported CSV. | Once the importing phase is completed it will be possible to define metadata for the current imported CSV. | ||
Line 41: | Line 46: | ||
In order to start the curation phase it is necessary to transform the imported CSV into a TS by clicking on the button “Create Time Series”. | In order to start the curation phase it is necessary to transform the imported CSV into a TS by clicking on the button “Create Time Series”. | ||
+ | [[Image:ts_CSV_view.png|frame|none|CSV view]] | ||
= Time Series Curation = | = Time Series Curation = |
Revision as of 15:47, 4 December 2009
Contents
Time Series elaboration cycle
Time Series elaboration cycle is made up of four phases:
- Time Series Import: a TS is imported through in the system though a CSV file.
- Time Series Curation: TS is corrected and cleaned.
- Time Series Manipulation: TS is elaborated depending on user need.
- Time Series Publication: TS come available for the community.
Time Series Import
Through a wizard interface a Time Series, represented as a csv file(RFC 4180) is imported through in the system.
CSV file can either be imported by uploading the file from the user file system or from the user workspace.
Once a CSV file has been loaded it is possible to select some parameters relative to the uploaded file:
- Character Encoding
- the file header flag
- field separator
- columns to import/exclude
The configuration shows a CSV sample based on the selected parameters. This sample is limited to the first 50 rows.
Through the sample grid, it is possible to select which columns a user wants to exclude from the importing.
In order to made the system accept the current configuration it is necessary to verify the whole file by clicking on the “Check configuration” button. The system will check then the entire CVS for RFC 4180 compliance.
If there is any error it will be possible to see which rows are wrong and, in case, to decide to skip them in the importing phase.
Once the importing phase is completed it will be possible to define metadata for the current imported CSV.
The last step consists of a CSV creation into the system. During the creation a loading bar will indicate the overall progress of the operation.
CSV Data Handling
Once the CSV has been created it will be possible to open it for examining its content. (note that the content can be ordered at this time)
A CSV can be exported directly into the Workspace, see TS CSV export section.
In order to start the curation phase it is necessary to transform the imported CSV into a TS by clicking on the button “Create Time Series”.
Time Series Curation
The curation phase allows to curate a TS by linking it to the reference data and consequently correcting eventual errors.
Each TS column can belong to the following types:
- dimension: the column is associated to the previously imported reference
- Attribute: [TBA]
- Value: [TBA]
In order to define a curated TS it is necessary to cure all the columns. The yet cured columns are shown by using a green filled circle in the column header. The not yet cured columns are shown by using a red filled circle in the column header.
Column Curation
In order to start curating a column, user should right click on the column header and select the item “Edit properties”. A new panel will appear for the column property editing.
This panel allows to rename a column by editing its label.
By using the radio selection buttons it is possible to select the column type.
For the attribute types and values it is possible to select the data type: Text, Integer, Float, Date, Time, Boolean, Timestamp.
For the type Column it is possible to edit the family key and key value to associate. By using the check errors button it is possible to know hoe many rows contain errors associated to that dimension. By using the sample button it will be show a sample of the values with the reference data referred.
For each column it is possible to exploit the GUESS tool, which will try to guess which reference data has to be associated to the column by using the reference date present into the system. For each proposed dimension the errors number will be automatically calculated.
Once the configuration is done, it is either possible to save or discard the changes.
If the column has been associated to a dimension and, there are some rows which contain errors, the system enters in a mode called error editing.
Error editing
In this modality only the containing error rows are shown
The row error can be due to the following reasons:
- the value cannot find its equivalent among reference data values
- the value cannot find a correspondence among reference data values
These two types of errors will be shown by using different colors.
System allow to edit the values for each single column. If the cell belong to type dimension, a popup wil appear with the list of possible values to associate to it.
It is possible to discard all the changes going back to the previous column configuration any time.
Once all the rows are corrected the system will ask to the user to save the changes applied so far.
Note: It won't be possible to discard the changed made in editing mode.
Editing and Column removal
It is possible to edit single column values at any time. In order to remove a whole column from the TS, right click on the column header you want to remove and select “Remove column”.
Curation Closing
Once all column have been curated it will be possible to close the curation publishing the TS in the Curated TS list.
Time Series Manipulation
A Time Series can be manipulate through the following operations:
- Filtering: filter the TS by Column or Values criteria.
- Union:Union of two Time Series.
- Denormalization: Denormalization of TS Values
- Grouping: grouping of values by column selection.
- Aggregation: values aggregation by column selection.
Once the single operation is applied is possible to save the TS or discard the operation. (except for the union operation)
Filtering
It is possible to filter the TS by selecting the filtering conditions to apply to the TS Column Values.
Clearly condition types vary depending on the column type:
- for each column type is posible to apply condtions based on compound expressions: filtering by range;
- for each column of type dimension is possible to defin a set of acceptable values: filtering by value.
Union
The Union operation merges two TS in one single TS.
The full operation is executed ny using a Wizard interface.
Fisrt step consist of selecting the TS to merge with the one currently open. Once step first is done, system checks for compatibility.
Denormalization
Denormalizes the TS based on an attribute and a value..
Grouping
[TBA]
Aggregation
[TBA]
Time Series publishing
A TS cam be published either at VO or VRE level at anytime.
Time Series Export
A TS can be exported in the user workspace using CSV format.
First step consists of the configuration of the csv to create: char-set selection, field separator, column selection and so on.
Second step asks for the basket in which save the CSV file.
Workspace integration
TS can be saved as items in the user Workspace
In order to open a previously workspace saved TS, or from another user, click on the “Load from workspace” button.