Difference between revisions of "File:Opasnet base connection.ANA"
m (→An improved web interface) |
(uploaded a new version of "Image:Opasnet base connection.ANA": Small changes with Res and Resinfo) |
(No difference)
| |
Revision as of 13:35, 28 August 2009
This page is a method.
The page identifier is Op_en2676 |
|---|
| Moderator:Nobody (see all) Click here to sign up. |
|
Give your opinion to the peer rating of the content of this page. |
| Upload data
|
This model is an interface for uploading data to and downloading it from the Opasnet base. This file is an editable version of a web interface. For using the file, you need Analytica Enterprise. For using the web interface, you only need a web browser (Mozilla Firefox recommended).
An improved web interface
There is also a web interface for downloading only; this interface produces raw data tables that you can copy-paste to an external software. However, some pieces of data are very large, and you may experience downloading the data, or handling the data afterwards. Therefore, there is a need to improve the interface. The improvement needs are described in this chapter.
The data is stored into the Opasnet base as two-dimensional tables, one for each data object (data objects can be either studies or variables. For details, see the description of the database structure. For example, the data called Morbidity data for Europe consists of a table that is indexed by four indices: Year, Sex, Age, and Country. Indices define the specifics of a particular observation. In addition, there is one parameter (morbidity), which is the field that contains the observations (values of interest).
Often, the user is only interested in a part of the data, e.g. one year of observation, one country, and maybe a few age groups. So, there should be an interface that shows the data in the Opasnet in a few steps, when a user selects a data object.
- The user is shown the list of uploads (versions) of the data object. The default is the newest upload, but the user should be able to choose an older one as well. This is based on the query that is shown on the metadata box as "List of uploads".
- The user is shown the list of indices and locations (possible values). The user can choose any combination of locations with tick boxes beside each location.
- The user is shown a two-dimensional table of data with indices and parameters as fields, and observations as rows. This can then be copy-pasted to other programs. Alternatively, a comma separated file (CSV) is created and a Save as dialog box appears. Now the "The newest upload" link does something like this but does not allow for selecting locations, and the output format is not optimal for copy-pasting data into another software.
- In cases where the data is given as distributions instead of point estimates, the data can also be downloaded as a sample file of distributions.
Development needs
- Evaluate function in Data_table converts all text values to null, which is not good. Instead, it should be asked somewhere whether the content is text, number, or either one.
See also
- Previous version image:RDB connection.ANA and image:RDB reader.ANA were only for either reading or writing data.
File history
Click on a date/time to view the file as it appeared at that time.
(newest | oldest) View (newer 10 | older 10) (10 | 20 | 50 | 100 | 250 | 500)| Date/Time | Dimensions | User | Comment | |
|---|---|---|---|---|
| 05:40, 31 March 2009 | (762 KB) | Jouni (talk | contribs) | An intermediate version that combines the two input formats: Analytica model and data table. Works for Analytica model, but a lot to clean still. | |
| 11:58, 27 March 2009 | (745 KB) | Jouni (talk | contribs) | European morbidity data included as an example of data formatting. | |
| 12:26, 25 March 2009 | (322 KB) | Jouni (talk | contribs) | New part added for uploading data tables. Now this works, but the model uploading (with several variables) is not updated. This version requires a password and it only works from within THL. | |
| 06:02, 7 January 2009 | (154 KB) | Jouni (talk | contribs) | The model passed all functionality tests. Now it is ready for test use. Farmed salmon model was removed from the file. | |
| 07:05, 6 January 2009 | (291 KB) | Jouni (talk | contribs) | Now the Reader works beautifully and it is simple. But there is still some strange problems with Write buttons. Otherwise this is almost ready for production use. | |
| 13:51, 31 December 2008 | (259 KB) | Jouni (talk | contribs) | I looked at the reader but it does not work yet. In addition, some functions seem extremely complex. It cannot be that difficult. | |
| 06:34, 31 December 2008 | (345 KB) | Jouni (talk | contribs) | Finally it works! Problems with Sample1 were corrected, and now memory demand is much lower. Now it should be tested well and documented. Update Read part. | |
| 22:14, 30 December 2008 | (364 KB) | Jouni (talk | contribs) | Now it should work except something strange with Sample1. Also, sampling does not result in a real sample but a series of mid values. | |
| 18:15, 30 December 2008 | (361 KB) | Jouni (talk | contribs) | I realised that tables Loc and Roww should be merged and locations should be organised by index, not by dimension. After this version, I'll change the model accordingly. | |
| 14:40, 29 December 2008 | (353 KB) | Jouni (talk | contribs) | Some progress done but not finished yet. I drew a graph to show dependencies between tables. The buttons are now updated and the first ones work. Still some problems with Write_item and Write_sam. A new write table created: Sample1. When this works, there |
- You cannot overwrite this file.
File usage
The following 3 pages link to this file:
- File:RDB connection.ANA (file redirect)
- File:RDB reader.ANA (file redirect)
- File:Transferring to result database.ANA (file redirect)
