This wiki has undergone a migration to Confluence found Here
Difference between revisions of "RIMdb"
Jump to navigation
Jump to search
Rene spronk (talk | contribs) (New page: category:RIMBAA Issue ==Summary== *Creation of a simple reference [[RIMBAA] implementation in the form of a SQL-enabled RIM-based database. ==Discussion== *(Dutch RIMBAA WG, 2008012...) |
Rene spronk (talk | contribs) |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | [[category:RIMBAA Issue]] | + | [[category:Closed RIMBAA Issue]] |
==Summary== | ==Summary== | ||
| − | *Creation of a simple reference [[RIMBAA] implementation in the form of a SQL-enabled RIM-based database. | + | *Creation of a simple reference [[RIMBAA]] implementation in the form of a SQL-enabled RIM-based database. This is a quick-and-dirty version of a RIM based database, for testing purposes. |
| + | |||
| + | *See [[SqlServer RIMBAA script]] (created by Ewout Kramer, based on Java SIG materials). | ||
==Discussion== | ==Discussion== | ||
*(Dutch RIMBAA WG, 20080129) create RIM Reference Model as an SQL script, to use as a sandbox to play with RIM dbs and a list of requirements for a Clinical Data Repository (CDR). It will be a like a "Getting Started with a RIMdb". | *(Dutch RIMBAA WG, 20080129) create RIM Reference Model as an SQL script, to use as a sandbox to play with RIM dbs and a list of requirements for a Clinical Data Repository (CDR). It will be a like a "Getting Started with a RIMdb". | ||
*Create a SQL-script to generate the RIM based database. | *Create a SQL-script to generate the RIM based database. | ||
| + | *20080603: Ernst and Michael are busy generating a database from the Access Rose database. However, the generated database will not necessarily be sufficient to support efficient querying and storage. For this, some denormalisations will have to be done and also, you might need additional table(s) to support the datatypes (like GTS). Ernst has experience in implementing this database, so it would be sensible to compare his database to the RIMBAA Sig specifications. Also, Ernst will describe how he handles datatypes, especially GTS. Ewout offers to do the technical writing, if necessary. | ||
| + | *20090129 (René): It sounds like we may want to re-use the outcomes of the [[Database with native ISO datatypes]] work item. | ||
| + | *20090120 (Michael): We should write down the transformation rules. Ernst and I have some rules, but not written them down. I think the result will be a '''SQL ITS'''! | ||
| + | *See [[SqlServer RIMBAA script]] (created by Ewout Kramer, based on Java SIG materials). | ||
Latest revision as of 12:47, 6 February 2009
Summary
- Creation of a simple reference RIMBAA implementation in the form of a SQL-enabled RIM-based database. This is a quick-and-dirty version of a RIM based database, for testing purposes.
- See SqlServer RIMBAA script (created by Ewout Kramer, based on Java SIG materials).
Discussion
- (Dutch RIMBAA WG, 20080129) create RIM Reference Model as an SQL script, to use as a sandbox to play with RIM dbs and a list of requirements for a Clinical Data Repository (CDR). It will be a like a "Getting Started with a RIMdb".
- Create a SQL-script to generate the RIM based database.
- 20080603: Ernst and Michael are busy generating a database from the Access Rose database. However, the generated database will not necessarily be sufficient to support efficient querying and storage. For this, some denormalisations will have to be done and also, you might need additional table(s) to support the datatypes (like GTS). Ernst has experience in implementing this database, so it would be sensible to compare his database to the RIMBAA Sig specifications. Also, Ernst will describe how he handles datatypes, especially GTS. Ewout offers to do the technical writing, if necessary.
- 20090129 (René): It sounds like we may want to re-use the outcomes of the Database with native ISO datatypes work item.
- 20090120 (Michael): We should write down the transformation rules. Ernst and I have some rules, but not written them down. I think the result will be a SQL ITS!
- See SqlServer RIMBAA script (created by Ewout Kramer, based on Java SIG materials).
