1 / 12

Ceri Binding Hypermedia Research Unit, University of Glamorgan, Wales

Ceri Binding Hypermedia Research Unit, University of Glamorgan, Wales http://hypermedia.research.glam.ac.uk/kos/STELLAR/. STELLAR Applications. STELLAR.Console. STELLAR.Web. STELLAR.Win. STELLAR Data Conversions. SQL2CSV SQL2TAB. SQLEXECUTE. Delimited Data. Database. CSV2DB TAB2DB.

kylee-watson
Download Presentation

Ceri Binding Hypermedia Research Unit, University of Glamorgan, Wales

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ceri Binding Hypermedia Research Unit, University of Glamorgan, Wales http://hypermedia.research.glam.ac.uk/kos/STELLAR/

  2. STELLAR Applications STELLAR.Console STELLAR.Web STELLAR.Win

  3. STELLAR Data Conversions SQL2CSV SQL2TAB SQLEXECUTE Delimited Data Database CSV2DB TAB2DB CSV2STG TAB2STG DELIM2STG SQL2STG User-defined template XML RDF [other textual formats]

  4. SKOS Template Fields

  5. SKOS_CONCEPTSCHEMES Template input skos:ConceptScheme data:s123 dcterms:title dcterms:creator Template model dcterms:description “New scheme” “New scheme used for testing” “Fred Bloggs” Template output

  6. SKOS_CONCEPTS - relationships skos:ConceptScheme data:s123 skos:Concept data:c789 skos:Concept data:c456 skos:related skos:broader skos:narrower skos:inScheme skos:Concept data:c456 skos:Concept data:c456 skos:Concept data:c789

  7. SKOS_CONCEPTS – labels skos:Concept data:c456 skos:hiddenLabel skos:prefLabel skos:altLabel “rock” “rocks” “stones”

  8. SKOS_CONCEPTS - notes skos:Concept data:c456 skos:note “Note 1” skos:scopeNote “Note 2” skos:changeNote “Note 3” skos:definition “Note 4” skos:editorialNote “Note 5” skos:example “Note 6” (RDF output) skos:historyNote “Note 7”

  9. A Practical Example • English Heritage “AMIE” database – multiple thesauri: • MDA object types • Monument types • Main building materials • Covering building materials • Archaeological sciences • Evidence • Timelines

  10. AMIE database conversion using STELLAR thesaurus_terms.csv thesaurus_term_uses.csv thesaurus_term_preferences.csv thesaurus_term_relations.csv classification_groups.csv (data import) (data cleansing) CSV2DB Internal Database SQLEXECUTE (delimited input data) (data export) SELECT DISTINCT tt.the_te_uid AS concept_id, term AS altlabel FROM thesaurus_termstt INNER JOIN thesaurus_term_preferencesttp ON ttp.the_te_uid_1 = tt.the_te_uid WHERE tt.status <> 'P' SQL2CSV (cleansed & mapped data) (SQL query) CSV2STG SQL2STG Template (data conversion) (RDF output data)

  11. Extract of SKOS RDF output

  12. Ceri Binding Hypermedia Research Unit, University of Glamorgan, Wales http://hypermedia.research.glam.ac.uk/kos/STELLAR/

More Related