Difference between revisions of "Information models"

From Diversity Workbench
Jump to: navigation, search
(→‎dwb database schemes)
 
(43 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 +
[[Image: DWB components.png|450px|right|DWB components © SNSB IT Center'']]
 +
 
===Diversity Workbench information models===
 
===Diversity Workbench information models===
  
−
* [[DiversityAgents Information Models|DiversityAgents]] '''new version 2016!'''
+
* [[DiversityAgents Information Models|DiversityAgents]] '''new version 2023!'''
 
* [[DiversityCollection Information Models|DiversityCollection]] '''new version 2016!'''
 
* [[DiversityCollection Information Models|DiversityCollection]] '''new version 2016!'''
−
* [[DiversityDescriptions Information Models|DiversityDescriptions]] '''new version 2016!'''
+
* [[DiversityDescriptions Information Models|DiversityDescriptions]] '''new version 2023!'''
 
* [[DiversityExsiccatae Information Models|DiversityExsiccatae]]
 
* [[DiversityExsiccatae Information Models|DiversityExsiccatae]]
−
* [[DiversityGazetteers Information Models|DiversityGazetteers]]
+
* [[DiversityGazetteers Information Models|DiversityGazetteers]] '''new version 2020!'''
 
* [[DiversityMobile Information Models|DiversityMobile]]
 
* [[DiversityMobile Information Models|DiversityMobile]]
−
* [[DiversityProjects Information Models|DiversityProjects]] '''new version 2016!'''
+
* [[DiversityProjects Information Models|DiversityProjects]] '''new version 2018!'''
−
* [[DiversityReferences Information Models|DiversityReferences]]
+
* [[DiversityReferences Information Models|DiversityReferences]] '''new version 2020!'''
 
* [[DiversityResources Information Models|DiversityResources]]
 
* [[DiversityResources Information Models|DiversityResources]]
−
* [[DiversitySamplingPlots Information Models|DiversitySamplingPlots]]
+
* [[DiversitySamplingPlots Information Models|DiversitySamplingPlots]] '''new version 2020!'''
−
* [[DiversityScientificTerms Information Models|DiversityScientificTerms]]
+
* [[DiversityScientificTerms Information Models|DiversityScientificTerms]] '''new version 2023!'''
 
* [[DiversityTaxonomy Information Models|DiversityTaxonomy]]
 
* [[DiversityTaxonomy Information Models|DiversityTaxonomy]]
−
* [[DiversityTaxonNames Information Models|DiversityTaxonNames]]
+
* [[DiversityTaxonNames Information Models|DiversityTaxonNames]] '''new version 2019!'''
−
 
+
  
 
===dwb database schemes===
 
===dwb database schemes===
  
−
Some information models are available as [[Schemes|dwb database schemes]] with each single data table and data column referenced as term or concept by its own stable and persistent URL.
+
Some information models are available as database schemes with each single data column of a table and each single table referenced by its own stable and persistent URL.  
 +
 
 +
*[[dwbAgents_v02.01.23|DiversityAgents database scheme]]
 +
*[[dwbCollection|DiversityCollection database scheme]]
 +
*[[dwbDescriptions_v03.03.07|DiversityDescriptions database scheme]]
 +
*[[dwbGazetteers|DiversityGazetteers database scheme]]
 +
*[[dwbProjects|DiversityProjects database scheme]]
 +
*[[dwbReferences|DiversityReferences database scheme]]
 +
*[[dwbSamplingPlots|DiversitySamplingPlots database scheme]]
 +
*[[dwbScientificTerms_v01.00.15|DiversityScientificTerms database scheme]]
 +
*[[dwbTaxonNames|DiversityTaxonNames database scheme]]
 +
 
 +
--> see [[Help:Concepts,_collections,_and_schemes| Information on schemes, concepts, concept collections]].
 +
 
 +
===dwb XML schema definition (xsd) ===
 +
 
 +
The structure of DWB databases is available as a XML schema definition (xsd), the schema as set of individual xsd-files each describing one database table. These xsd schemes contain all necessary information to interact with or reconstruct the database tables. Each table column is described by name, datatype, textual description and whether it is part of the primary key. The xsd schemes for the DWB modules can be generated for all tables of interest via DWB rich clients using the menu ''Data - Archive - Create Schema''.
 +
 
 +
 
 +
A sample schema for the table "Analysis" of the DiversityCollection application with database information model DiversityCollection_02.06.21 is given below:
 +
 
 +
<pre style="white-space: pre;">
 +
<DiversityCollection_02.06.21>
 +
<xs:schema id="DiversityCollection_02.06.21">
 +
  <xs:element name="DiversityCollection_02.06.21" msdata:IsDataSet="true" msdata:MainDataTable="Analysis" msdata:UseCurrentLocale="true">
 +
  <xs:complexType>
 +
    <xs:choice minOccurs="0" maxOccurs="unbounded">
 +
    <xs:element name="Analysis">
 +
      <xs:complexType>
 +
      <xs:sequence>
 +
        <xs:element name="AnalysisID" msdata:Caption="ID of the analysis (primary key)" type="xs:int"/>
 +
        <xs:element name="AnalysisParentID" msdata:Caption="Analysis ID of the parent analysis, if it belongs to a certain type documented in this table" type="xs:int"/>
 +
        <xs:element name="DisplayText" msdata:Caption="Name of the analysis as e.g. shown in user interface" type="xs:string"/>
 +
        <xs:element name="Description" msdata:Caption="Description of the analysis" type="xs:string"/>
 +
        <xs:element name="MeasurementUnit" msdata:Caption="The measurement unit used for the analysis, e.g. mm, µmol, kg" type="xs:string"/>
 +
        <xs:element name="Notes" msdata:Caption="Notes on this analysis" type="xs:string"/>
 +
        <xs:element name="AnalysisURI" msdata:Caption="URI referring to an external documentation of the analysis" type="xs:string"/>
 +
        <xs:element name="OnlyHierarchy" msdata:Caption="If the entry is only used for the hierarchical arrangement of the entries" type="xs:boolean"/>
 +
        <xs:element name="LogCreatedWhen" msdata:Caption="Point in time when this data set was created" type="xs:dateTime"/>
 +
        <xs:element name="LogCreatedBy" msdata:Caption="Name of the creator of this data set" type="xs:string"/>
 +
        <xs:element name="LogUpdatedWhen" msdata:Caption="Point in time when this data set was updated last" type="xs:dateTime"/>
 +
        <xs:element name="LogUpdatedBy" msdata:Caption="Name of the person to update this data set last" type="xs:string"/>
 +
        <xs:element name="RowGUID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:Caption="" type="xs:string"/>
 +
      </xs:sequence>
 +
      </xs:complexType>
 +
    </xs:element>
 +
    </xs:choice>
 +
  </xs:complexType>
 +
  <xs:unique name="Constraint1" msdata:PrimaryKey="true">
 +
    <xs:selector xpath=".//Analysis"/>
 +
    <xs:field xpath="AnalysisID"/>
 +
  </xs:unique>
 +
  </xs:element>
 +
</xs:schema>
 +
</DiversityCollection_02.06.21>
 +
</pre>
 +
 
 +
----
 +
 
 +
 
 +
 
 +
 
 +
Back to [http://diversityworkbench.net/Portal/Main_Page Introduction and Overview]

Latest revision as of 20:34, 22 October 2023

DWB components © SNSB IT Center

Diversity Workbench information models

dwb database schemes

Some information models are available as database schemes with each single data column of a table and each single table referenced by its own stable and persistent URL.

--> see Information on schemes, concepts, concept collections.

dwb XML schema definition (xsd)

The structure of DWB databases is available as a XML schema definition (xsd), the schema as set of individual xsd-files each describing one database table. These xsd schemes contain all necessary information to interact with or reconstruct the database tables. Each table column is described by name, datatype, textual description and whether it is part of the primary key. The xsd schemes for the DWB modules can be generated for all tables of interest via DWB rich clients using the menu Data - Archive - Create Schema.


A sample schema for the table "Analysis" of the DiversityCollection application with database information model DiversityCollection_02.06.21 is given below: 

<DiversityCollection_02.06.21>
 <xs:schema id="DiversityCollection_02.06.21">
  <xs:element name="DiversityCollection_02.06.21" msdata:IsDataSet="true" msdata:MainDataTable="Analysis" msdata:UseCurrentLocale="true">
   <xs:complexType>
    <xs:choice minOccurs="0" maxOccurs="unbounded">
     <xs:element name="Analysis">
      <xs:complexType>
       <xs:sequence>
        <xs:element name="AnalysisID" msdata:Caption="ID of the analysis (primary key)" type="xs:int"/>
        <xs:element name="AnalysisParentID" msdata:Caption="Analysis ID of the parent analysis, if it belongs to a certain type documented in this table" type="xs:int"/>
        <xs:element name="DisplayText" msdata:Caption="Name of the analysis as e.g. shown in user interface" type="xs:string"/>
        <xs:element name="Description" msdata:Caption="Description of the analysis" type="xs:string"/>
        <xs:element name="MeasurementUnit" msdata:Caption="The measurement unit used for the analysis, e.g. mm, µmol, kg" type="xs:string"/>
        <xs:element name="Notes" msdata:Caption="Notes on this analysis" type="xs:string"/>
        <xs:element name="AnalysisURI" msdata:Caption="URI referring to an external documentation of the analysis" type="xs:string"/>
        <xs:element name="OnlyHierarchy" msdata:Caption="If the entry is only used for the hierarchical arrangement of the entries" type="xs:boolean"/>
        <xs:element name="LogCreatedWhen" msdata:Caption="Point in time when this data set was created" type="xs:dateTime"/>
        <xs:element name="LogCreatedBy" msdata:Caption="Name of the creator of this data set" type="xs:string"/>
        <xs:element name="LogUpdatedWhen" msdata:Caption="Point in time when this data set was updated last" type="xs:dateTime"/>
        <xs:element name="LogUpdatedBy" msdata:Caption="Name of the person to update this data set last" type="xs:string"/>
        <xs:element name="RowGUID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:Caption="" type="xs:string"/>
       </xs:sequence>
      </xs:complexType>
     </xs:element>
    </xs:choice>
   </xs:complexType>
   <xs:unique name="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//Analysis"/>
    <xs:field xpath="AnalysisID"/>
   </xs:unique>
  </xs:element>
 </xs:schema>
</DiversityCollection_02.06.21>



Back to Introduction and Overview

Retrieved from "https://diversityworkbench.net/w/index.php?title=Information_models&oldid=23452"