Opasnet base structure: Revision history

21 February 2009

• curprev 07:1607:16, 21 February 2009‎ Jouni talk contribs‎ 13,470 bytes −845‎ →‎Data: oldfashioned descriptions removed
• curprev 07:1307:13, 21 February 2009‎ Jouni talk contribs‎ 14,315 bytes +237‎ →‎Result: renaming
• curprev 06:4106:41, 21 February 2009‎ Jouni talk contribs‎ 14,078 bytes −2,527‎ →‎Table and field names: old parts removed

10 February 2009

• curprev 06:5706:57, 10 February 2009‎ Juha Villman talk contribs‎ 16,605 bytes 0‎ →‎Table structure: Loc -table (changed Obj_id_d to Obj_id_id)

9 February 2009

• curprev 13:3413:34, 9 February 2009‎ Juha Villman talk contribs‎ 16,605 bytes −299‎ →‎Table structure: deleted Roww table
• curprev 13:3113:31, 9 February 2009‎ Juha Villman talk contribs‎ 16,904 bytes +36‎ →‎Table structure: Updated Loc and Locres

2 February 2009

• curprev 14:4014:40, 2 February 2009‎ Jouni talk contribs‎ 16,868 bytes +669‎ →‎Opasnet Data: completely rewritten based on own better thinking

1 February 2009

• curprev 19:3719:37, 1 February 2009‎ Jouni talk contribs‎ 16,199 bytes +258‎ idea of nugget data in the Base

29 January 2009

• curprev 06:2706:27, 29 January 2009‎ Jouni talk contribs‎ m 15,941 bytes 0‎ →‎Opasnet Data
• curprev 06:2706:27, 29 January 2009‎ Jouni talk contribs‎ 15,941 bytes +2,104‎ →‎See also: First desctiption of Opasnet Data based on own thinking and discussions with Mikko, Hanna, and Kalle

9 January 2009

• curprev 08:2508:25, 9 January 2009‎ Juha Villman talk contribs‎ 13,837 bytes +18‎ →‎Table structure: small changes to descriptions
• curprev 08:1408:14, 9 January 2009‎ Juha Villman talk contribs‎ 13,819 bytes −1,441‎ →‎Table structure: Updated table structure to actual database structure

29 November 2008

• curprev 21:5021:50, 29 November 2008‎ Jouni talk contribs‎ 15,260 bytes −949‎ →‎Table and field names: new structure idea updated
• curprev 20:1220:12, 29 November 2008‎ Jouni talk contribs‎ 16,209 bytes +476‎ →‎Table and field names: new structure idea
• curprev 09:3709:37, 29 November 2008‎ Jouni talk contribs‎ 15,733 bytes +1,431‎ new idea of table structure
• curprev 07:3407:34, 29 November 2008‎ Jouni talk contribs‎ m 14,302 bytes +22‎ categorised
• curprev 06:1506:15, 29 November 2008‎ Jouni talk contribs‎ 14,280 bytes +67‎ →‎Definition: Dependencies added
• curprev 05:5605:56, 29 November 2008‎ Jouni talk contribs‎ 14,213 bytes −7,564‎ completely edited and restructured as variable. Now is up-to-date
• curprev 04:5604:56, 29 November 2008‎ Jouni talk contribs‎ m 21,777 bytes 0‎ Result database moved to Opasnet base: The name is according to the new nomenclature.

28 November 2008

• curprev 20:5720:57, 28 November 2008‎ Jouni talk contribs‎ 21,777 bytes +43‎ →‎Table structure: structure change suggested to Run_list

19 November 2008

• curprev 04:3104:31, 19 November 2008‎ Jouni talk contribs‎ 21,734 bytes −2‎ →‎A suggested table and column structure for the database: Emm removed because ICF is a better idea

18 November 2008

• curprev 22:3122:31, 18 November 2008‎ Jouni talk contribs‎ 21,736 bytes +711‎ →‎A suggested table and column structure for the database: Emm table added

12 November 2008

• curprev 07:4607:46, 12 November 2008‎ Jouni talk contribs‎ 21,025 bytes +1,858‎ →‎A suggested table and column structure for the database: naming improvement suggeted

13 October 2008

• curprev 12:0012:00, 13 October 2008‎ Juha Villman talk contribs‎ 19,167 bytes +73‎ →‎Useful queries that are not (yet) part of a model of procedure
• curprev 09:5509:55, 13 October 2008‎ Juha Villman talk contribs‎ 19,094 bytes +12‎ →‎Useful queries that are not (yet) part of a model of procedure
• curprev 09:5309:53, 13 October 2008‎ Juha Villman talk contribs‎ 19,082 bytes +18‎ →‎Useful queries that are not (yet) part of a model of procedure

3 October 2008

• curprev 13:1413:14, 3 October 2008‎ Jouni talk contribs‎ m 19,064 bytes +42‎ template added

1 October 2008

• curprev 21:0721:07, 1 October 2008‎ Jouni talk contribs‎ 19,022 bytes +114‎ →‎A suggested table and column structure for the database: small edits
• curprev 09:1009:10, 1 October 2008‎ Juha Villman talk contribs‎ m 18,908 bytes +1,395‎ →‎A suggested table and column structure for the database: better positioning
• curprev 07:4007:40, 1 October 2008‎ Juha Villman talk contribs‎ 17,513 bytes +258‎ better positioning for tables
• curprev 07:2707:27, 1 October 2008‎ Juha Villman talk contribs‎ 17,255 bytes +1,774‎ added rest of the tables used in Result database
• curprev 07:1907:19, 1 October 2008‎ Juha Villman talk contribs‎ 15,481 bytes −2,368‎ added few tables to result database

17 September 2008

• curprev 06:5306:53, 17 September 2008‎ Jouni talk contribs‎ 17,849 bytes −3,787‎ →‎Some useful syntax: outdated queries removed

11 September 2008

• curprev 08:0508:05, 11 September 2008‎ Jouni talk contribs‎ 21,636 bytes +758‎ →‎List all variables and runs of these variables, together with dimensions and indices used (concatenated): corrected

10 September 2008

• curprev 21:0521:05, 10 September 2008‎ Jouni talk contribs‎ 20,878 bytes +1,245‎ →‎All indices
• curprev 20:1920:19, 10 September 2008‎ Jouni talk contribs‎ 19,633 bytes +677‎ →‎All indices: added two queries

25 August 2008

• curprev 15:3815:38, 25 August 2008‎ Jouni talk contribs‎ 18,956 bytes +1,895‎ No edit summary

8 August 2008

• curprev 14:4314:43, 8 August 2008‎ Jouni talk contribs‎ 17,061 bytes +147‎ →‎Some useful syntax: RDB reader added

3 August 2008

• curprev 15:1415:14, 3 August 2008‎ Jouni talk contribs‎ 16,914 bytes +543‎ →‎The sample of the newest run of each variable: Analytica import query added

30 July 2008

• curprev 08:3608:36, 30 July 2008‎ Jouni talk contribs‎ m 16,371 bytes +17‎ →‎List of variables at dimension and run level
• curprev 08:3508:35, 30 July 2008‎ Jouni talk contribs‎ 16,354 bytes +977‎ →‎List of runs for each variable at result_id level: variables at run level added

18 July 2008

• curprev 12:0212:02, 18 July 2008‎ Jouni talk contribs‎ 15,377 bytes −29‎ →‎Some useful syntax: link to Image:RDB connection.ANA added

17 July 2008

• curprev 07:0007:00, 17 July 2008‎ Jouni talk contribs‎ m 15,406 bytes +52‎ →‎List of runs for each variable at result_id level
• curprev 06:5006:50, 17 July 2008‎ Jouni talk contribs‎ 15,354 bytes +358‎ →‎List of runs for each variable at result_id level: udpate
• curprev 06:3106:31, 17 July 2008‎ Jouni talk contribs‎ 14,996 bytes +1,424‎ basic SQL querys added

30 January 2008

• curprev 09:2609:26, 30 January 2008‎ Jouni talk contribs‎ m 13,572 bytes −1‎ No edit summary
• curprev 09:2409:24, 30 January 2008‎ Jouni talk contribs‎ m 13,573 bytes +61‎ No edit summary
• curprev 09:2309:23, 30 January 2008‎ Jouni talk contribs‎ m 13,512 bytes 0‎ Help:Result database moved to Result database: Methods and tools are moved from the Help to the Main namespace

7 January 2008

• curprev 09:3809:38, 7 January 2008‎ Jouni talk contribs‎ 13,512 bytes +13,141‎ copied from Intarese:Help:Result database

31 December 2007

• curprev 08:4408:44, 31 December 2007‎ Jouni talk contribs‎ 371 bytes +371‎ some useful syntax stored