Difference between revisions of "File:Opasnet base connection.ANA"

From Testiwiki
Jump to: navigation, search
(uploaded a new version of "Image:Opasnet base connection.ANA": Corrected a bug in Analytica_node. Added features for multi-variable uploads, but not ready yet (see Variable_info and Ch_var).)
(technical edits)
 
(31 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
[[Category:Opasnet]]
 +
[[Category:Opasnet Base]]
 
[[Category:Analytica tool]]
 
[[Category:Analytica tool]]
 
[[Category:SQL tool]]
 
[[Category:SQL tool]]
 
[[Category:Open assessment]]
 
[[Category:Open assessment]]
 
{{tool|moderator=Jouni}}
 
{{tool|moderator=Jouni}}
−
This model is an interface for uploading data to and downloading it from the [[Opasnet base]]. This file is an editable version of a [http://www.analyticaonline.com/24a/Client/AwpClient.aspx?inviteId=invite58&inviteCode=61143 web interface]. For using the file, you need [[Analytica]] Enterprise. For using the web interface, you only need a web browser (Mozilla Firefox recommended).  
+
''This page relates to old versions of [[Opasnet Base (2008-2011)]] and its connections. For the current database version, see [[Opasnet Base]].
  
−
==An improved web interface==
+
This model is an interface for uploading data to and downloading it from the [[Opasnet Base]]. For using the file, you need [[Analytica]] Enterprise.
  
−
There is also a [http://base.opasnet.org 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.
+
[[Uploading to Opasnet Base]] helps you understand what data could and should be updated to [[Opasnet Base]] and what the recommended data structures and formats are. For technical instructions how to use the current upload software, see [[Opasnet Base connection]]. For a general description about the database, see [[Opasnet Base]] and for technical details about the database, see [[Opasnet Base structure]]. For details about downloading data, see [[Opasnet Base UI]].
  
−
The data is stored into the [[Opasnet base]] as two-dimensional tables, one for each data object (data objects can be either [[study|studies]] or [[variable]]s. For details, see the [[Opasnet Base structure|description of the database structure]].  For example, the data called [[Morbidity data for Europe]] consists of a table that is indexed by four [[index|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).
+
'''Some key parts of OBC explained
  
−
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.
+
; Findid: This function gets an id from a table. It has the following parameters: '''in''': the property for which the id is needed. In MUST be unique in cond and it must contain index i. '''table''': the table from where the id is brought. The table MUST have .j as the column index, .i as the row index, and a column named 'id'. '''cond''': the name of the field that is compared with in. Cond must be text.
−
# 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==
+
;Textify: Changes a number to a text value with up to 15 significant numbers. This bypasses the number formatting problem that tends to convert e.g. 93341 to '93.34K'. If the input is null, the result is ''.
−
 
 
−
* Now the model interprets the results as numbers if applicable, otherwise text.
 
−
* Analytica_node creates an indexname list where local indices start with dot (.Index). The dot should be removed, because in the Opasnet Base there are no local indices.
 
−
* Upload the read functions. The indices should have the real names from the Opasnet Base, not just In1, In2 and so on.
 
−
* The queries for read functions should be the same queries as in <nowiki>[[Template:Resultlink]]</nowiki>.
 
−
* The read functions don't work properly. They don't show Testvariable data uploaded 28.8.2009 for some reason.
 
−
* The first read function should show data in 2D format; only the next function should turn it into an array. This is because not all data has originally been arrays and would result in hugely multidimensional arrays with a lot of empty cells.
 
−
 
 
−
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.
 
−
*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.
 
  
 
==See also==
 
==See also==
  
 +
* [[Opasnet Base Connection for R]]
 +
* [[Opasnet Base]]
 +
* [[Opasnet Base structure]]
 +
* [[Uploading to Opasnet Base]]
 +
* [[Opasnet Base UI]]
 
* Previous version [[:image:RDB connection.ANA]] and [[:image:RDB reader.ANA]] were only for either reading or writing data.
 
* Previous version [[:image:RDB connection.ANA]] and [[:image:RDB reader.ANA]] were only for either reading or writing data.
 +
[[Category:Opasnet Base]]
 +
* [http://cs.stanford.edu/people/thathoo/rmysql.pdf Guidance document for RMySQL] (the MySQL database connection for [[R]] software.

Latest revision as of 19:01, 10 April 2015


This page relates to old versions of Opasnet Base (2008-2011) and its connections. For the current database version, see Opasnet Base.

This model is an interface for uploading data to and downloading it from the Opasnet Base. For using the file, you need Analytica Enterprise.

Uploading to Opasnet Base helps you understand what data could and should be updated to Opasnet Base and what the recommended data structures and formats are. For technical instructions how to use the current upload software, see Opasnet Base connection. For a general description about the database, see Opasnet Base and for technical details about the database, see Opasnet Base structure. For details about downloading data, see Opasnet Base UI.

Some key parts of OBC explained

Findid
This function gets an id from a table. It has the following parameters: in: the property for which the id is needed. In MUST be unique in cond and it must contain index i. table: the table from where the id is brought. The table MUST have .j as the column index, .i as the row index, and a column named 'id'. cond: the name of the field that is compared with in. Cond must be text.
Textify
Changes a number to a text value with up to 15 significant numbers. This bypasses the number formatting problem that tends to convert e.g. 93341 to '93.34K'. If the input is null, the result is .

See also

File history

Click on a date/time to view the file as it appeared at that time.

(newest | oldest) View ( | older 10) (10 | 20 | 50 | 100 | 250 | 500)
Date/TimeDimensionsUserComment
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.
(newest | oldest) View ( | older 10) (10 | 20 | 50 | 100 | 250 | 500)
  • You cannot overwrite this file.

The following 3 pages link to this file:

Retrieved from "http://www.opasnet.org/testiwiki/index.php?title=File:Opasnet_base_connection.ANA&oldid=35358"