Difference between revisions of "File:Opasnet base connection.ANA"
(uploaded a new version of "Image:Opasnet base connection.ANA": Reformatted the outline. Corrected node-based data table calculations. Deleted modules Additonal_parts, Additional_parts1, Table_format_for_input, and Dependency_graph.) |
(uploaded a new version of "Image:Opasnet base connection.ANA": Major restructuring: Only one node can be uploaded at a time. 2D data table is the basic for all data formats, also Analytica nodes are transformed into 2D. This simplifies the code a lot.) |
(No difference)
| |
Revision as of 07:50, 8 June 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.
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 | |
|---|---|---|---|---|
| 22:44, 28 December 2008 | (341 KB) | Jouni (talk | contribs) | The test phase is not yet successful. Several write nodes need updates. An example model, Farmed salmon, is saved with this file. | |
| 23:28, 15 December 2008 | (239 KB) | Jouni (talk | contribs) | All tasks listed with previous version are completed. Now write part should work but haven't tested. Then, read part should be updated as well. | |
| 14:50, 15 December 2008 | (258 KB) | Jouni (talk | contribs) | Seems to work (almost). Tasks: Check Write_sett and Write_item. Make buttons for updating each table separately (is this needed for all tables?). Remove redundant attributes. Remove Old_parts. Think about updating procedure and make coherent. | |
| 23:49, 14 December 2008 | (251 KB) | Jouni (talk | contribs) | New model starts to get shape. All database queries are now in Buttons, and query results are static nodes. Not all write nodes work, but most are pretty good already. | |
| 16:56, 8 December 2008 | (150 KB) | Jouni (talk | contribs) | Large changes. Two thirds done. NOTE: this version does not work. | |
| 14:57, 4 December 2008 | (126 KB) | Jouni (talk | contribs) | Small improvements | |
| 20:49, 3 December 2008 | (76 KB) | Jouni (talk | contribs) | New ideas implemented but far from ready. Most read queries are now up-to-date. I haven't touched the insert queries yet. | |
| 14:37, 1 December 2008 | (67 KB) | Jouni (talk | contribs) | SQL updates but only half way through. The Opasnet base structure is still changing. | |
| 05:38, 1 December 2008 | (66 KB) | Jouni (talk | contribs) | Small edits | |
| 06:25, 29 November 2008 | (66 KB) | Jouni (talk | contribs) | A compilation of image:RDB connection.ANA and image:RDB reader.ANA. |
- 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)
