Database structure of the SIMPLE Editor.

Below follows a short description of the Database structure we have chosen to encode the SIMPLE-lexicon in.

Table summary
Table-name
Content
Semu
Predikat
Predikat_Argument_Kobling
Argument
Argument_Informarg_Kobling
Informarg
Informarg_Wvsf_Kobling
Wvsf
RWeightValSemU
Const_Features
ARTIKKEL
DEFINISJONSDEL

 

In the original Sgml-files lexical data and structural data are intertwined. We have chosen to separate the two.
The structural information regarding the hierarchical organisation of the SIMPLE Ontology, the Qualia structure etc. is located in the 'Content' Table.

The lexical data is divided into several tables since it is partly in a one-to-one relationship, and partly in a many-to-one relationship.

The Central element in the Simple-lexicon, called a Semantic Unit (SemU) embeds various types of elements. Each SemU can only have one 'Simple Type'(Template), 'SuperTemplate', 'Semantic class', 'Domain', 'UnificationPath', 'Glossa'(freedefinition), and 'Event Type'. These elements resides in the main table named Semu, together with other information that also holds a one-to-one relationship.

The biggest bulk in the table structure is for the Predicative Representation, and argument structure that comes with Selectional Restrictions. This consists of the tables 'Predikat', 'Argument', 'Informarg', and 'Wvsf', as well as the linking tables 'Predikat_Argument_Kobling', 'Argument_Informarg_Kobling', and 'Table Informarg_Wvsf_Kobling'.

The Qualia links are all in the same format and reside in the 'RWeightValSemU' table. The 'Type' field holds them apart by telling what kind of qualia link it is (Formal, Telic, Agentive or Constitutive).

The Constitutive Features are different than the other qualias, in that they are features with values rather than links to other SemUs. Constitutive Features are therefore placed in a separate table.(Const_Features).

The Glossa field in the Semu-table holds a pointer to an imported version of 'Bokmålsordboken', an online Norwegian monolingual dictionary, that resides in a separate table-structure. (ARTIKKEL and DEFINISJONSDEL)

 

 
Table Semu
Field Type Null
Id int(11) No
Language varchar(255) No
Ordklasse varchar(255) No
LastEditedBy varchar(255) No
EditDate timestamp(14) Yes
Semu_id varchar(255) No
Naming varchar(255) Yes
Example varchar(255) Yes
Comment varchar(255) Yes
Template varchar(255) Yes
SuperTemplate varchar(255) Yes
Domain varchar(255) Yes
SemClass varchar(255) Yes
Glossa varchar(255) Yes
EventType varchar(255) Yes
UnificationPath varchar(255) Yes
PredId varchar(255) Yes
PredIdTypeoflink varchar(255) Yes
LinkDansk varchar(255) Yes
LinkNorsk varchar(255) Yes
LinkSvensk varchar(255) Yes
Table Content
Field Type Null
Id int(11) No
Type varchar(255) No
Number varchar(255) No
Label varchar(255) No
Parent timestamp(14) Yes
HasChildren tinyInt(4) No
Info varchar(255) Yes
Table Predikat
Field Type Null
Id int(11) No
Pred_id varchar(255) No
Type varchar(255) Yes
Naming varchar(255) Yes
Example varchar(255) Yes
Multilingual varchar(255) Yes
Table Predikat_Argument_Kobling
Field Type Null
Id int(11) No
Pred_id varchar(255) Yes
Arg_id varchar(255) Yes
Table Argument
Field Type Null
Id int(11) No
Arg_id varchar(255) No
Comment varchar(255) Yes
SemanticRole varchar(255) Yes
Arg_type varchar(255) Yes
Table Argument_Informarg_Kobling
Field Type Null
Id int(11) No
Arg_id varchar(255) Yes
Inf_id varchar(255) Yes
Table Informarg
Field Type Null
Id int(11) No
Inf_id varchar(255) No
Comment varchar(255) Yes
Status varchar(255) Yes
Table Informarg_Wvsf_Kobling
Field Type Null
Id int(11) No
Inf_id varchar(255) Yes
Wvsf varchar(255) Yes

Table Wvsf

Field Type Null
Id int(11) No
Wvsf varchar(255) Yes
Value varchar(255) Yes

 
Table RWeightValSemU
Field Type Null
Id int(11) No
Semu_id varchar(255) Yes
Weight varchar(255) Yes
Comment varchar(255) Yes
Target varchar(255) Yes
Type varchar(255) Yes
Semr varchar(255) Yes
Table Const_Features
Field Type Null
Id int(11) No
Semu_id varchar(255) No
Feature varchar(255) Yes
ProtEss varchar(10) Yes
Value varchar(255) Yes

 

  
Table ARTIKKEL
Field Type Null
ARTIKKEL_ID int(11) Yes
OPPSLAG varchar(255) Yes
BOYNING varchar(255) Yes
ETYMOLOGI varchar(255) Yes
UTTALE varchar(255) Yes
SORTFORM varchar(255) Yes
SORT_REKKE varchar(255) Yes
INNLEDER_BLOKK varchar(255) Yes
HEADER varchar(255) Yes
Table DEFINISJONSDEL
Field Type Null
DEFINISJON_ID int(11) Yes
DEFINISJONSNUMMER varchar(255) Yes
ARTIKKEL_ID int(11) Yes
DEFINISJON text Yes
GRAMM_INN varchar(255) Yes
SEMANTIKK_INN varchar(255) Yes
HOVED_DEFINISJON varchar(255) Yes
NIVAA varchar(255) Yes
 

<- Back to Index