Difference between revisions of "File:Opasnet base connection.ANA"
(uploaded a new version of "File:Opasnet base connection.ANA": Code streamlined. All different upload types seem to work to Data_table phase but not further. Added observise function to work with table-based prob data.) |
(uploaded a new version of "File:Opasnet base connection.ANA": Update finalised and first tests are successful. The code has become much simpler, it can even been understood by outsiders.) |
(No difference)
| |
Revision as of 23:05, 8 July 2010
This page is a method.
The page identifier is Op_en2676 |
|---|
| Moderator:Jouni (see all) |
|
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. You can select slices from a variable.
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).
Developmental needs
Kehitettävää (by Erkki):
- A) Taulukkodatan syöttö on vielä epävarmaa, toimii välillä ja välillä ei, vailla selkeää johdonmukaisuutta. ==> Epävarma toiminta voisi Juhan mukaan viitata johonkin selain-/flash-/tms.-tekniseen fibaan.
- B) Parametrisarakkeissa olevan puuttuvan datan käsittely näyttää keskeneräiseltä, koska 'Null' ei nähtävästi kelpaa arvoksi lainkaan (ko. rivit jäävät kokonaan pois), ja 'Undefined'-arvot AWP muuntaa nolliksi, mikä johtaa harhaan.
- ⇤1 : There is no need to store null values, because all missing values are null anyway. --Jouni 11:57, 13 January 2010 (UTC)
- C) Kun menen katsomaan http://base.opasnet.org/, niin ko. study näkyy kylläkin pudotusvalikossa, mutta "post"-painikkeella ei palaudu mitään dataa. Juha varmaan fiksailee tuon kun ehtii.
TODO: {{#todo:Järjestelmää voisi muuttaa seuraavasti:
- Ensin ladataan obj-, act- ja loc-tiedot (explanations). Vasta sen jälkeen ladataan muut (observations: cell, loccell, res). Tämä edellyttää: a) kaikki loc-tietot kaikista ladattavista muuttujista käsitellään kerralla tai luodaan luuppi myös explanationsiin (edellinen parempi), b) kaikki lataustavat tuottavat standardimuotoisen Data_tablen.
- Replace/append pitää toimia kaikilla lataustyypeillä.
- Ind pitäisi erottaa omaksi taulukseen Obj:sta. Tämä kuitenkin vaatii niin paljon muutoksia, ettei siihen ryhdytä neuvottelematta Juhan ja Einarin kanssa. Alustavia valmisteluja kuitenkin tehdään halkaisemalla OBC:n Objects-taulu kahtia, Indices erikseen.
See also
- Opasnet Base
- Opasnet Base structure
- Previous version image:RDB connection.ANA and image:RDB reader.ANA were only for either reading or writing data.
- Guidance document for RMySQL (the MySQL database connection for R software.
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)
