Difference between revisions of "Information models"

Revision as of 19:32, 22 October 2023

Diversity Workbench information models

• DiversityAgents new version 2023!
• DiversityCollection new version 2016!
• DiversityDescriptions new version 2023!
• DiversityExsiccatae
• DiversityGazetteers new version 2020!
• DiversityMobile
• DiversityProjects new version 2018!
• DiversityReferences new version 2020!
• DiversityResources
• DiversitySamplingPlots new version 2020!
• DiversityScientificTerms new version 2023!
• DiversityTaxonomy
• DiversityTaxonNames new version 2019!

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.

• DiversityAgents database scheme
• DiversityCollection database scheme
• DiversityDescriptions database scheme
• DiversityGazetteers database scheme
• DiversityProjects database scheme
• DiversityReferences database scheme
• DiversitySamplingPlots database scheme
• DiversityScientificTerms database scheme
• DiversityTaxonNames database scheme

--> 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