ER Model

This page shows the core entity-relationship model used in ClimateKG Data Bench. It maps AR6 corpus structure, authorship, glossary, acronym, and bibliographic entities into Wikibase classes and properties.

erDiagram

    WORK {
        WikibaseItem instance_of "P1 Instance of: P1=Q2"
    }
    REPORT_SERIES {
        WikibaseItem instance_of "P1 Instance of: P1=Q3"
        String title "rdfs:label item label"
        String description "rdfs:description item description"
        WikibaseItem part_of "P3 Part of: parent Work"
        WikibaseItem parts "P4 Parts: child Series or Books"
    }
    REPORT {
        WikibaseItem instance_of "P1 Instance of: P1=Q4"
        String title "rdfs:label item label"
        String doi "P10 DOI"
        String isbn_elec "P30 ISBN Electronic (DOI)"
        String isbn_print "P31 ISBN Print (DOI)"
        String license "P11 LICENSE"
        WikibaseItem tags "P12 Has TAG"
        String date "P8 Date"
        Url pdf "P7 PDF"
        String openalex "P9 OPENALEX"
        WikibaseItem part_of "P3 Part of: parent Report Series"
        WikibaseItem parts "P4 Parts: child Books and Chapters"
    }
    TEXT_DIVISION {
        WikibaseItem instance_of "P1 Instance of: P1=Q5"
        String title "rdfs:label item label"
        String doi "P10 DOI"
        String isbn_elec "P30 ISBN Electronic (DOI)"
        String isbn_print "P31 ISBN Print (DOI)"
        String license "P11 LICENSE"
        WikibaseItem tags "P12 Has TAG"
        String date "P8 Date"
        Url pdf "P7 PDF"
        String openalex "P9 OPENALEX"
        WikibaseItem part_of "P3 Part of: parent Series"
        WikibaseItem parts "P4 Parts: child Chapters"
    }
    CHAPTER {
        WikibaseItem instance_of "P1 Instance of: P1=Q6"
        String title "rdfs:label item label"
        String doi "P10 DOI"
        String openalex "P9 OPENALEX"
        Url wiki "P5 Wiki"
        Url source "P6 Source"
        Url pdf "P7 PDF"
        WikibaseItem tags "P12 Has TAG"
        WikibaseItem part_of "P3 Part of: parent Book"
    }

    AUTHOR {
        WikibaseItem instance_of "P1 Instance of: P1=Q3998"
        String climatkg_author_id "P20 ClimateKG Author ID: e.g. AU0001"
        String last_name "P21 last name"
        String first_name "P22 first name"
        String gender "P23 gender: M or F"
        String citizenship "P24 citizenship"
        String country_of_residence "P25 country of residence"
        String affiliation "P26 affiliation"
        WikibaseItem contributed_to "P27 contributed to chapter: FK to Q6 Chapter"
    }

    GLOSSARY_TERM {
        WikibaseItem instance_of "P1 Instance of: P1=Q1 Category"
        String name "rdfs:label item label"
        String also_known_as "skos:altLabel item alias"
        Monolingualtext definition "P13 Definition"
        WikibaseItem part_of_series "P3 Part of: FK to Q4 Series via series_ref"
    }

    ACRONYM {
        WikibaseItem instance_of "P1 Instance of: P1=Q2087"
        String code "rdfs:label acronym code as item label"
        Monolingualtext description "P13 Definition: multiple; source as qualifier"
        WikibaseItem report "P3 Part of: FK to Q4 Series (report)"
    }

    WORK ||--|{ REPORT_SERIES : "contains"
    REPORT_SERIES ||--|{ REPORT : "contains"
    REPORT ||--|{ TEXT_DIVISION : "contains"
    TEXT_DIVISION ||--|{ CHAPTER : "contains"
    AUTHOR ||--|{ CHAPTER : "contributes to"
    REPORT ||--|{ GLOSSARY_TERM : "has"
    REPORT ||--|{ ACRONYM : "has"


    

For the full mapping workflow and generated artefacts, see research_data/data-xml-dtd/erm/README.qmd.