Gold RDA dataset for derivative Relationships and Families

In this version, most sparqls ignore on purpose works not in a family!

Create the environment to use.

If any of the %magics is modified in the intermediate code, then set it again when it needed

In [1]:
%endpoint http://83.212.171.43:8890/sparql
%graph http://dbis.ionio.gr/grdadrv

%prefix rdac: <http://rdaregistry.info/Elements/c/>
%prefix rdax: <http://rdaregistry.info/Elements/x/>
%prefix rdaxo: <http://rdaregistry.info/Elements/x/object/>
%prefix rdaw: <http://rdaregistry.info/Elements/w/>
%prefix rdawo: <http://rdaregistry.info/Elements/w/object/>
%prefix rdawd: <http://rdaregistry.info/Elements/w/datatype/>
%prefix rdae: <http://rdaregistry.info/Elements/e/>
%prefix rdaeo: <http://rdaregistry.info/Elements/e/object/>
%prefix rdamo: <http://rdaregistry.info/Elements/m/object/>
%prefix rdamd: <http://rdaregistry.info/Elements/m/datatype/>

# %lang en
# %display table withtypes

%show all
Endpoint set to: http://83.212.171.43:8890/sparql
Default graph: http://dbis.ionio.gr/grdadrv
Prefix set: rdac: = <http://rdaregistry.info/Elements/c/>
Prefix set: rdax: = <http://rdaregistry.info/Elements/x/>
Prefix set: rdaxo: = <http://rdaregistry.info/Elements/x/object/>
Prefix set: rdaw: = <http://rdaregistry.info/Elements/w/>
Prefix set: rdawo: = <http://rdaregistry.info/Elements/w/object/>
Prefix set: rdawd: = <http://rdaregistry.info/Elements/w/datatype/>
Prefix set: rdae: = <http://rdaregistry.info/Elements/e/>
Prefix set: rdaeo: = <http://rdaregistry.info/Elements/e/object/>
Prefix set: rdamo: = <http://rdaregistry.info/Elements/m/object/>
Prefix set: rdamd: = <http://rdaregistry.info/Elements/m/datatype/>
Result maximum size: unlimited

How many Works, Expressions and Manifestations in the dataset

In [2]:
%display table

SELECT COUNT(?w) AS ?NoWorks COUNT(?e) AS ?NoExpressions COUNT(?m) AS ?NoManifestations
WHERE {
    {
        ?w a rdac:C10001
    }
    UNION
    {
        ?e a rdac:C10006
    }
    UNION
    {
        ?m a rdac:C10007
    }
}
Display: table
NoWorks NoExpressions NoManifestations
59 206 247
Total: 1, Shown: 1

Enumerate families

Note that in this version, statement for the family label is not optional!!! </br>Therefore, it counts ONLY works belonging to a family!

In [3]:
%display table

SELECT ?familyLabel  COUNT(?w) AS ?NoWorks 
WHERE {
    ?w a rdac:C10001.
    
    ?w rdfs:comment ?familyLabel.
   
}
ORDER BY ?familyLabel
Display: table
familyLabel NoWorks
CrimePunishmentFamily 4
ScarletLetterFamily 6
MadameBovaryFamily 3
WutheringHeightsFamily 7
DonQuijoteFamily 4
TomSawyerFamily 7
KaramazovBrothersFamily 3
CienAnosSoledadFamily 2
FaustFamily 7
IliadFamily 3
OdysseyFamily 2
Total: 11, Shown: 11

Enumerate Works with their related expressions per family

Note that in this version, statement for the family label is not optional!!! </br>Therefore, it counts ONLY works belonging to a family!

In [4]:
%display table

SELECT ?familyLabel  Count(?w) AS ?WorkWithExpr
WHERE {
    ?w rdawo:P10078 ?e.
    ?w rdfs:comment ?familyLabel.

}
ORDER BY ?familyLabel
Display: table
familyLabel WorkWithExpr
CrimePunishmentFamily 18
ScarletLetterFamily 16
MadameBovaryFamily 22
WutheringHeightsFamily 15
DonQuijoteFamily 12
TomSawyerFamily 26
KaramazovBrothersFamily 18
CienAnosSoledadFamily 7
FaustFamily 25
IliadFamily 21
OdysseyFamily 15
Total: 11, Shown: 11

Enumerate Work -2- Work properties,
count their instances too

Note that in this version, statement for the family label is not optional!!! </br>Therefore, it counts ONLY works belonging to a family!

In [5]:
%display table

SELECT (fn:replace(str(?p), "^.*[/#]", "") as ?property) (str(?pl) as ?label) COUNT(?p) AS ?Occurrences 
WHERE {
    ?s ?p ?o;
       a  rdac:C10001.
    ?o a  rdac:C10001.
    
    ?s rdfs:comment ?familyLabel.
    ?o rdfs:comment ?ofamilyLabel.
    
    OPTIONAL {?p rdfs:label ?pl.
              FILTER (lang(?pl) = 'en')
    }
}
ORDER BY ?p
Display: table
property label Occurrences
P10016 is dramatized as (work) 6
P10019 is contained in (work) 6
P10099 is freely translated as (work) 1
P10113 is adapted as libretto (work) 1
P10127 is dramatization of (work) 6
P10142 is adaptation of (work) 17
P10143 is free translation of (work) 1
P10147 is container of (work) 6
P10155 is adapted as (work) 17
P10156 is preceded by (work) 2
P10170 is succeeded by (work) 2
P10189 is libretto based on (work) 1
P10234 is opera adaptation of (work) 3
P10236 is adapted as opera (work) 3
P10290 is inspired by 3
P10291 is inspiration for 3
Total: 16, Shown: 16

Enumerate, count the instances and group by Family name all Work -2- Work properties

To include all subclasses of the Work class without enabling virtuoso inference, query specifies all of them. </br> Note that in this version, optional statement for the family label is disabled!!! </br>Therefore, it counts ONLY works belonging to a family!

In [6]:
%display table

SELECT (?familyLabel as ?Family) (fn:replace(str(?p), "^.*[/#]", "") as ?property) (str(?pl) as ?label) COUNT(?p) AS ?Occurrences 
WHERE {
    ?s ?p ?o;
       a  rdac:C10001.
    ?o a  rdac:C10001.
    
    ?s rdfs:comment ?familyLabel.
    ?o rdfs:comment ?ofamilyLabel.
#    OPTIONAL {?s rdfs:comment ?familyLabel}
    
    OPTIONAL {?p rdfs:label ?pl.
              FILTER (lang(?pl) = 'en')
    }
}
ORDER BY ?familyLabel ?p
Display: table
Family property label Occurrences
CrimePunishmentFamily P10016 is dramatized as (work) 1
CrimePunishmentFamily P10127 is dramatization of (work) 1
CrimePunishmentFamily P10142 is adaptation of (work) 2
CrimePunishmentFamily P10155 is adapted as (work) 2
ScarletLetterFamily P10016 is dramatized as (work) 2
ScarletLetterFamily P10127 is dramatization of (work) 2
ScarletLetterFamily P10142 is adaptation of (work) 1
ScarletLetterFamily P10155 is adapted as (work) 1
ScarletLetterFamily P10234 is opera adaptation of (work) 2
ScarletLetterFamily P10236 is adapted as opera (work) 2
MadameBovaryFamily P10113 is adapted as libretto (work) 1
MadameBovaryFamily P10142 is adaptation of (work) 1
MadameBovaryFamily P10155 is adapted as (work) 1
MadameBovaryFamily P10189 is libretto based on (work) 1
WutheringHeightsFamily P10142 is adaptation of (work) 5
WutheringHeightsFamily P10155 is adapted as (work) 5
WutheringHeightsFamily P10290 is inspired by 1
WutheringHeightsFamily P10291 is inspiration for 1
DonQuijoteFamily P10019 is contained in (work) 2
DonQuijoteFamily P10099 is freely translated as (work) 1
DonQuijoteFamily P10143 is free translation of (work) 1
DonQuijoteFamily P10147 is container of (work) 2
DonQuijoteFamily P10156 is preceded by (work) 1
DonQuijoteFamily P10170 is succeeded by (work) 1
TomSawyerFamily P10016 is dramatized as (work) 1
TomSawyerFamily P10127 is dramatization of (work) 1
TomSawyerFamily P10142 is adaptation of (work) 4
TomSawyerFamily P10155 is adapted as (work) 4
TomSawyerFamily P10290 is inspired by 1
TomSawyerFamily P10291 is inspiration for 1
KaramazovBrothersFamily P10016 is dramatized as (work) 2
KaramazovBrothersFamily P10127 is dramatization of (work) 2
CienAnosSoledadFamily P10290 is inspired by 1
CienAnosSoledadFamily P10291 is inspiration for 1
FaustFamily P10019 is contained in (work) 3
FaustFamily P10142 is adaptation of (work) 2
FaustFamily P10147 is container of (work) 3
FaustFamily P10155 is adapted as (work) 2
FaustFamily P10156 is preceded by (work) 1
FaustFamily P10170 is succeeded by (work) 1
FaustFamily P10234 is opera adaptation of (work) 1
FaustFamily P10236 is adapted as opera (work) 1
IliadFamily P10019 is contained in (work) 1
IliadFamily P10142 is adaptation of (work) 1
IliadFamily P10147 is container of (work) 1
IliadFamily P10155 is adapted as (work) 1
OdysseyFamily P10142 is adaptation of (work) 1
OdysseyFamily P10155 is adapted as (work) 1
Total: 48, Shown: 48

Enumerate Work -2- Expression properties, count their instances too


Note that in this version, statement for the family label is not optional!!! </br>Therefore, it counts ONLY works belonging to a family!

In [7]:
%display table

SELECT (fn:replace(str(?p), "^.*[/#]", "") as ?property) (str(?pl) as ?label) COUNT(?p) AS ?Occurrences 
WHERE {
    ?s ?p ?o;
       a  rdac:C10001.
    ?o a  rdac:C10006.
    
    ?s rdfs:comment ?familyLabel.
    
    OPTIONAL {?p rdfs:label ?pl}
    FILTER (lang(?pl) = 'en')
}
ORDER BY ?p
Display: table
property label Occurrences
P10078 has expression of work 195
Total: 1, Shown: 1

Enumerate Expression -2- Work properties, count their instances too

</br> Note that in this version, there is a statement for the family label!!! </br>Therefore, it counts ONLY works belonging to a family!

In [8]:
%display table

SELECT (fn:replace(str(?p), "^.*[/#]", "") as ?property) (str(?pl) as ?label) COUNT(?p) AS ?Occurrences 
WHERE {
    ?s ?p ?o;
       a  rdac:C10006.
    ?o a  rdac:C10001.
    
    ?o rdfs:comment ?ofamilyLabel.
    
    OPTIONAL {?p rdfs:label ?pl}
    FILTER (lang(?pl) = 'en')
}
ORDER BY ?p
Display: table
property label Occurrences
P20231 has work expressed 195
Total: 1, Shown: 1

Enumerate Expression -2- Expression properties, count their instances too


Note the existence of the statements for the family labels for the Works being realized by the Expressions!!! </br>Therefore, it counts ONLY works belonging to a family!

In [9]:
%display table

SELECT (fn:replace(str(?p), "^.*[/#]", "") as ?property) (str(?pl) as ?label) COUNT(?p) AS ?Occurrences 
WHERE {
    ?s ?p ?o;
       a  rdac:C10006.
    ?o a  rdac:C10006.
    
    ?s rdaeo:P20231 ?sw.
    ?sw rdfs:comment ?sfamilyLabel.
    ?o rdaeo:P20231 ?ow.
    ?ow rdfs:comment ?ofamilyLabel.
    
    OPTIONAL {?p rdfs:label ?pl}
    FILTER (lang(?pl) = 'en')
}
ORDER BY ?p
Display: table
property label Occurrences
P20074 is contained in (expression) 7
P20076 is replaced by (expression) 1
P20110 is adapted as libretto (expression) 1
P20121 is abridgement of (expression) 10
P20141 is translation of 49
P20145 is container of (expression) 7
P20152 is adaptation of (expression) 2
P20153 is adapted as (expression) 2
P20166 is abridged as (expression) 10
P20171 is translated as 49
P20189 is revision of 6
P20190 is libretto based on (expression) 1
P20199 is replacement of (expression) 1
P20203 is derivative (expression) 9
P20204 is based on (expression) 9
P20211 is revised as 6
Total: 16, Shown: 16

Enumerate, count the instances and group by Family name Expression -2- Expression properties


Note the existence of the statements for the family labels for the Works being realized by the Expressions!!! </br>Therefore, it counts ONLY works belonging to a family!

In [10]:
%display table

SELECT (?sfamilyLabel as ?Family) (fn:replace(str(?p), "^.*[/#]", "") as ?property) (str(?pl) as ?label) COUNT(?p) AS ?Occurrences 
WHERE {
    ?s ?p ?o;
       a  rdac:C10006.
    ?o a  rdac:C10006.
    
    ?s rdaeo:P20231 ?sw.
    ?sw rdfs:comment ?sfamilyLabel.
    ?o rdaeo:P20231 ?ow.
    ?ow rdfs:comment ?ofamilyLabel.
    
    OPTIONAL {?p rdfs:label ?pl}
    FILTER (lang(?pl) = 'en')
}
ORDER BY ?familyLabel ?p
Display: table
Family property label Occurrences
TomSawyerFamily P20074 is contained in (expression) 1
DonQuijoteFamily P20074 is contained in (expression) 2
FaustFamily P20074 is contained in (expression) 3
IliadFamily P20074 is contained in (expression) 1
OdysseyFamily P20076 is replaced by (expression) 1
MadameBovaryFamily P20110 is adapted as libretto (expression) 1
TomSawyerFamily P20121 is abridgement of (expression) 4
MadameBovaryFamily P20121 is abridgement of (expression) 2
KaramazovBrothersFamily P20121 is abridgement of (expression) 1
IliadFamily P20121 is abridgement of (expression) 2
OdysseyFamily P20121 is abridgement of (expression) 1
CrimePunishmentFamily P20141 is translation of 7
ScarletLetterFamily P20141 is translation of 2
MadameBovaryFamily P20141 is translation of 3
WutheringHeightsFamily P20141 is translation of 3
FaustFamily P20141 is translation of 3
DonQuijoteFamily P20141 is translation of 2
KaramazovBrothersFamily P20141 is translation of 7
CienAnosSoledadFamily P20141 is translation of 4
IliadFamily P20141 is translation of 10
OdysseyFamily P20141 is translation of 8
TomSawyerFamily P20145 is container of (expression) 1
FaustFamily P20145 is container of (expression) 3
DonQuijoteFamily P20145 is container of (expression) 2
IliadFamily P20145 is container of (expression) 1
IliadFamily P20152 is adaptation of (expression) 1
OdysseyFamily P20152 is adaptation of (expression) 1
IliadFamily P20153 is adapted as (expression) 1
OdysseyFamily P20153 is adapted as (expression) 1
TomSawyerFamily P20166 is abridged as (expression) 4
MadameBovaryFamily P20166 is abridged as (expression) 2
KaramazovBrothersFamily P20166 is abridged as (expression) 1
IliadFamily P20166 is abridged as (expression) 2
OdysseyFamily P20166 is abridged as (expression) 1
CrimePunishmentFamily P20171 is translated as 7
ScarletLetterFamily P20171 is translated as 2
MadameBovaryFamily P20171 is translated as 3
WutheringHeightsFamily P20171 is translated as 3
FaustFamily P20171 is translated as 3
DonQuijoteFamily P20171 is translated as 2
KaramazovBrothersFamily P20171 is translated as 7
CienAnosSoledadFamily P20171 is translated as 4
IliadFamily P20171 is translated as 10
OdysseyFamily P20171 is translated as 8
KaramazovBrothersFamily P20189 is revision of 2
IliadFamily P20189 is revision of 2
OdysseyFamily P20189 is revision of 2
MadameBovaryFamily P20190 is libretto based on (expression) 1
OdysseyFamily P20199 is replacement of (expression) 1
CrimePunishmentFamily P20203 is derivative (expression) 1
TomSawyerFamily P20203 is derivative (expression) 3
IliadFamily P20203 is derivative (expression) 3
OdysseyFamily P20203 is derivative (expression) 2
CrimePunishmentFamily P20204 is based on (expression) 1
TomSawyerFamily P20204 is based on (expression) 3
IliadFamily P20204 is based on (expression) 3
OdysseyFamily P20204 is based on (expression) 2
KaramazovBrothersFamily P20211 is revised as 2
IliadFamily P20211 is revised as 2
OdysseyFamily P20211 is revised as 2
Total: 60, Shown: 60

Enumerate Expression -2- Manifestation properties, count their instances too


Note the existence of the statements for the family labels for the Works being realized by the Expressions!!! </br>Therefore, it counts ONLY works belonging to a family!

In [11]:
%display table

SELECT (fn:replace(str(?p), "^.*[/#]", "") as ?property) (str(?pl) as ?label) COUNT(?p) AS ?Occurrences 
WHERE {
    ?s ?p ?o;
       a  rdac:C10006.
    ?o a  rdac:C10007.
    
    ?s rdaeo:P20231 ?sw.
    ?sw rdfs:comment ?sfamilyLabel.

    ?o rdamo:P30139 ?oe.
    ?oe rdaeo:P20231 ?ow.
    ?ow rdfs:comment ?ofamilyLabel.
    
    OPTIONAL {?p rdfs:label ?pl}
    FILTER (lang(?pl) = 'en')
}
ORDER BY ?p
Display: table
property label Occurrences
P20059 has manifestation of expression 236
Total: 1, Shown: 1

Enumerate Manifestation -2- Expression properties, count their instances too


Note the existence of the statements for the family labels for the Works being realized by the Expressions!!! </br>Therefore, it counts ONLY works belonging to a family!

In [12]:
%display table

SELECT (fn:replace(str(?p), "^.*[/#]", "") as ?property) (str(?pl) as ?label) COUNT(?p) AS ?Occurrences 
WHERE {
    ?s ?p ?o;
       a  rdac:C10007.
    ?o a  rdac:C10006.
    
    ?s rdamo:P30139 ?se.
    ?se rdaeo:P20231 ?sw.
    ?sw rdfs:comment ?sfamilyLabel.
    
    ?o rdaeo:P20231 ?ow.
    ?ow rdfs:comment ?ofamilyLabel.
    
    OPTIONAL {?p rdfs:label ?pl}
    FILTER (lang(?pl) = 'en')
}
ORDER BY ?p
Display: table
property label Occurrences
P30139 has expression manifested 236
Total: 1, Shown: 1

Enumerate Manifestation -2- Manifestation properties, count their instances too


Note the existence of the statements for the family labels for the Works being realized by the Expressions!!! </br>Therefore, it counts ONLY works belonging to a family!

In [13]:
%display table

SELECT (fn:replace(str(?p), "^.*[/#]", "") as ?property) (str(?pl) as ?label) COUNT(?p) AS ?Occurrences 
WHERE {
    ?s ?p ?o;
       a  rdac:C10007.
    ?o a  rdac:C10007.
    
    ?s rdamo:P30139 ?se.
    ?se rdaeo:P20231 ?sw.
    ?sw rdfs:comment ?sfamilyLabel.
    
    ?o rdamo:P30139 ?oe.
    ?oe rdaeo:P20231 ?ow.
    ?ow rdfs:comment ?ofamilyLabel.
    
    OPTIONAL {?p rdfs:label ?pl}
    FILTER (lang(?pl) = 'en')
}
ORDER BY ?p
Display: table
property label Occurrences
P30019 is facsimile contained in 1
P30046 is facsimile container of 1
P30210 has accompanying manifestation relationship with 2
Total: 3, Shown: 3

Enumerate and count the instances of properties between

  • Work -2- Work

  • Work -2- Expression, Expression -2- Work

  • Expression -2- Expression

  • Expression -2- Manifestation

  • Manifestation -2- Expression

  • Manifestation -2- Manifestation
    • </ul> </b>
    TODO
    Exclude works not in a family!

In [14]:
%display table

SELECT ?p as ?property str(?pl) AS ?label COUNT(?p) AS ?Occurrences
WHERE {
 
  {?s ?p ?o;
       a  rdac:C10001.
    ?o a  rdac:C10001.
  }
  UNION
  {?s ?p ?o;
       a  rdac:C10001.
    ?o a  rdac:C10006.
  }
  UNION
  {?s ?p ?o;
      a  rdac:C10006.
  ?o a  rdac:C10001.
  }
  UNION
  {?s ?p ?o;
      a  rdac:C10006.
  ?o a  rdac:C10006.
  }
  UNION
  {?s ?p ?o;
       a  rdac:C10006.
    ?o a  rdac:C10007.
  }
  UNION
  {?s ?p ?o;
      a  rdac:C10007.
  ?o a  rdac:C10006.
  }
  UNION
  {?s ?p ?o;
      a  rdac:C10007.
  ?o a  rdac:C10007.
  }  
  OPTIONAL {?p rdfs:label ?pl}
  FILTER (lang(?pl) = 'en')

}
ORDER BY ?p
Display: table
property label Occurrences
http://rdaregistry.info/Elements/e/object/P20059 has manifestation of expression 247
http://rdaregistry.info/Elements/e/object/P20074 is contained in (expression) 7
http://rdaregistry.info/Elements/e/object/P20076 is replaced by (expression) 1
http://rdaregistry.info/Elements/e/object/P20110 is adapted as libretto (expression) 1
http://rdaregistry.info/Elements/e/object/P20121 is abridgement of (expression) 10
http://rdaregistry.info/Elements/e/object/P20141 is translation of 49
http://rdaregistry.info/Elements/e/object/P20145 is container of (expression) 7
http://rdaregistry.info/Elements/e/object/P20152 is adaptation of (expression) 2
http://rdaregistry.info/Elements/e/object/P20153 is adapted as (expression) 2
http://rdaregistry.info/Elements/e/object/P20166 is abridged as (expression) 10
http://rdaregistry.info/Elements/e/object/P20171 is translated as 49
http://rdaregistry.info/Elements/e/object/P20189 is revision of 6
http://rdaregistry.info/Elements/e/object/P20190 is libretto based on (expression) 1
http://rdaregistry.info/Elements/e/object/P20199 is replacement of (expression) 1
http://rdaregistry.info/Elements/e/object/P20203 is derivative (expression) 9
http://rdaregistry.info/Elements/e/object/P20204 is based on (expression) 9
http://rdaregistry.info/Elements/e/object/P20211 is revised as 6
http://rdaregistry.info/Elements/e/object/P20231 has work expressed 206
http://rdaregistry.info/Elements/e/object/P20268 is subject of (expression) 1
http://rdaregistry.info/Elements/m/object/P30019 is facsimile contained in 1
http://rdaregistry.info/Elements/m/object/P30046 is facsimile container of 1
http://rdaregistry.info/Elements/m/object/P30139 has expression manifested 247
http://rdaregistry.info/Elements/m/object/P30210 has accompanying manifestation relationship with 2
http://rdaregistry.info/Elements/w/object/P10016 is dramatized as (work) 6
http://rdaregistry.info/Elements/w/object/P10019 is contained in (work) 6
http://rdaregistry.info/Elements/w/object/P10078 has expression of work 206
http://rdaregistry.info/Elements/w/object/P10099 is freely translated as (work) 1
http://rdaregistry.info/Elements/w/object/P10113 is adapted as libretto (work) 1
http://rdaregistry.info/Elements/w/object/P10127 is dramatization of (work) 6
http://rdaregistry.info/Elements/w/object/P10142 is adaptation of (work) 17
http://rdaregistry.info/Elements/w/object/P10143 is free translation of (work) 1
http://rdaregistry.info/Elements/w/object/P10147 is container of (work) 6
http://rdaregistry.info/Elements/w/object/P10155 is adapted as (work) 17
http://rdaregistry.info/Elements/w/object/P10156 is preceded by (work) 2
http://rdaregistry.info/Elements/w/object/P10170 is succeeded by (work) 2
http://rdaregistry.info/Elements/w/object/P10189 is libretto based on (work) 1
http://rdaregistry.info/Elements/w/object/P10234 is opera adaptation of (work) 3
http://rdaregistry.info/Elements/w/object/P10236 is adapted as opera (work) 3
http://rdaregistry.info/Elements/w/object/P10257 has subject (work) 10
http://rdaregistry.info/Elements/w/object/P10258 has subject (expression) 1
http://rdaregistry.info/Elements/w/object/P10264 is subject of (work) 10
http://rdaregistry.info/Elements/w/object/P10290 is inspired by 3
http://rdaregistry.info/Elements/w/object/P10291 is inspiration for 3
Total: 43, Shown: 43

Visualizing queries

Visualize Works in families

each Family is generated by Work -2- Work relationships in both directions

Note the existence of the statements for the family labels for the Works being realize the expressions!!! </br>Therefore, it counts ONLY works belonging to a family! </br></br> to see all family names run the sparql Enumerate families

In [15]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w ?p ?o;
       a  rdac:C10001.
    ?o a  rdac:C10001.
    
    ?w rdfs:comment ?sfamilyLabel.
    ?o rdfs:comment ?ofamilyLabel.
}
Display: svg
%3 node0 dbis 1000000050 node1 dbis 1000000069 node0->node1 ns0:P10142 node1->node0 ns0:P10155 node27 dbis 1000000001 node1->node27 ns0:P10016 node33 dbis 1000000248 node1->node33 ns0:P10155 node2 dbis 1000000009 node3 dbis 1000000104 node2->node3 ns0:P10189 node3->node2 ns0:P10113 node29 dbis 1000000166 node3->node29 ns0:P10155 node4 dbis 1000000040 node5 dbis 1000000101 node4->node5 ns0:P10099 node12 dbis 1000000042 node4->node12 ns0:P10147 node13 dbis 1000000041 node4->node13 ns0:P10147 node5->node4 ns0:P10143 node6 dbis 1000000110 node7 dbis 1000000115 node6->node7 ns0:P10155 node10 dbis 1000000108 node6->node10 ns0:P10019 node11 dbis 1000000111 node6->node11 ns0:P10170 node22 dbis 1000000563 node6->node22 ns0:P10147 node43 dbis 1000000112 node6->node43 ns0:P10236 node7->node6 ns0:P10142 node8 dbis 1000000118 node9 dbis 1000000167 node8->node9 ns0:P10236 node19 dbis 1000000114 node8->node19 ns0:P10155 node26 dbis 1000000004 node8->node26 ns0:P10016 node38 dbis 1000000067 node8->node38 ns0:P10016 node41 dbis 1000000065 node8->node41 ns0:P10236 node9->node8 ns0:P10234 node10->node6 ns0:P10147 node10->node11 ns0:P10147 node36 dbis 1000000250 node10->node36 ns0:P10155 node11->node6 ns0:P10156 node11->node10 ns0:P10019 node12->node4 ns0:P10019 node12->node13 ns0:P10156 node13->node4 ns0:P10019 node13->node12 ns0:P10170 node14 dbis 1000000107 node15 dbis 1000000282 node14->node15 ns0:P10142 node15->node14 ns0:P10155 node16 dbis 1000000222 node15->node16 ns0:P10291 node25 dbis 1000000199 node15->node25 ns0:P10155 node28 dbis 1000000043 node15->node28 ns0:P10155 node37 dbis 1000000146 node15->node37 ns0:P10155 node44 dbis 1000000247 node15->node44 ns0:P10016 node16->node15 ns0:P10290 node17 dbis 1000000106 node18 dbis 1000000283 node17->node18 ns0:P10291 node18->node17 ns0:P10290 node19->node8 ns0:P10142 node20 dbis 1000000070 node21 dbis 1000000281 node20->node21 ns0:P10016 node42 dbis 1000000102 node20->node42 ns0:P10016 node21->node20 ns0:P10127 node22->node6 ns0:P10019 node23 dbis 1000000119 node24 dbis 1000000120 node23->node24 ns0:P10147 node35 dbis 1000000220 node23->node35 ns0:P10155 node24->node23 ns0:P10019 node25->node15 ns0:P10142 node26->node8 ns0:P10127 node27->node1 ns0:P10127 node28->node15 ns0:P10142 node29->node3 ns0:P10142 node30 dbis 1000000012 node31 dbis 1000000142 node30->node31 ns0:P10155 node32 dbis 1000000066 node30->node32 ns0:P10155 node34 dbis 1000000249 node30->node34 ns0:P10155 node39 dbis 1000000039 node30->node39 ns0:P10291 node40 dbis 1000000038 node30->node40 ns0:P10155 node45 dbis 1000000219 node30->node45 ns0:P10155 node31->node30 ns0:P10142 node32->node30 ns0:P10142 node33->node1 ns0:P10142 node34->node30 ns0:P10142 node35->node23 ns0:P10142 node36->node10 ns0:P10142 node37->node15 ns0:P10142 node38->node8 ns0:P10127 node39->node30 ns0:P10290 node40->node30 ns0:P10142 node41->node8 ns0:P10234 node42->node20 ns0:P10127 node43->node6 ns0:P10234 node44->node15 ns0:P10127 node45->node30 ns0:P10142 node46 dbis 1000000169 node47 dbis 1000000121 node46->node47 ns0:P10142 node47->node46 ns0:P10155

Visualize Works in families

each Family is generated by Work -2- Work relationships in one direction only!

Note the existence of the statements for the family labels for the Works being realize the expressions!!! </br>Therefore, it counts ONLY works belonging to a family!

In [16]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w ?p ?o;
       a  rdac:C10001.
    ?o a  rdac:C10001.
    
    ?w rdfs:comment ?sfamilyLabel.
    ?o rdfs:comment ?ofamilyLabel.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
    
}
Display: svg
%3 node0 dbis 1000000108 node1 dbis 1000000111 node0->node1 ns0:P10147 node12 dbis 1000000250 node0->node12 ns0:P10155 node18 dbis 1000000110 node0->node18 ns0:P10147 node2 dbis 1000000282 node3 dbis 1000000107 node2->node3 ns0:P10155 node15 dbis 1000000043 node2->node15 ns0:P10155 node23 dbis 1000000247 node2->node23 ns0:P10016 node27 dbis 1000000146 node2->node27 ns0:P10155 node29 dbis 1000000222 node2->node29 ns0:P10291 node39 dbis 1000000199 node2->node39 ns0:P10155 node4 dbis 1000000041 node5 dbis 1000000042 node4->node5 ns0:P10170 node6 dbis 1000000012 node7 dbis 1000000249 node6->node7 ns0:P10155 node20 dbis 1000000038 node6->node20 ns0:P10155 node21 dbis 1000000219 node6->node21 ns0:P10155 node33 dbis 1000000066 node6->node33 ns0:P10155 node38 dbis 1000000142 node6->node38 ns0:P10155 node46 dbis 1000000039 node6->node46 ns0:P10291 node8 dbis 1000000040 node8->node4 ns0:P10147 node8->node5 ns0:P10147 node9 dbis 1000000101 node8->node9 ns0:P10099 node10 dbis 1000000104 node11 dbis 1000000009 node10->node11 ns0:P10113 node35 dbis 1000000166 node10->node35 ns0:P10155 node13 dbis 1000000118 node14 dbis 1000000114 node13->node14 ns0:P10155 node28 dbis 1000000004 node13->node28 ns0:P10016 node30 dbis 1000000167 node13->node30 ns0:P10236 node34 dbis 1000000067 node13->node34 ns0:P10016 node41 dbis 1000000065 node13->node41 ns0:P10236 node16 dbis 1000000119 node17 dbis 1000000120 node16->node17 ns0:P10147 node22 dbis 1000000220 node16->node22 ns0:P10155 node18->node1 ns0:P10170 node19 dbis 1000000112 node18->node19 ns0:P10236 node42 dbis 1000000563 node18->node42 ns0:P10147 node47 dbis 1000000115 node18->node47 ns0:P10155 node24 dbis 1000000069 node25 dbis 1000000001 node24->node25 ns0:P10016 node26 dbis 1000000050 node24->node26 ns0:P10155 node40 dbis 1000000248 node24->node40 ns0:P10155 node31 dbis 1000000106 node32 dbis 1000000283 node31->node32 ns0:P10291 node36 dbis 1000000070 node37 dbis 1000000281 node36->node37 ns0:P10016 node43 dbis 1000000102 node36->node43 ns0:P10016 node44 dbis 1000000121 node45 dbis 1000000169 node44->node45 ns0:P10155

Visualize all Works in a family

... focus on a family </br> This is a short view of a family because it contains only Works. Therefore Expressions and properties expressed in Expression level are not included
For an almost complete view of a family see presentations with Work and Expressions.

To specify a family, set its name in statement:</br> FILTER (?ntype = "BibFamily" and ?familyLabel = "CienAnosSoledadFamily")

Note:</br> to see all family names run the sparql Enumerate families

Summary for properties used in filter statement

propertypLabel
P10016is dramatized as (work)
P10099is freely translated as (work)
P10113is adapted as libretto (work)
P10147is container of (work)
P10155is adapted as (work)
P10170is succeeded by (work)
P10236is adapted as opera (work)
P10257has subject (work)
P10291is inspiration for

Family: CienAnosSoledadFamily

In [17]:
%display diagram
# %lang en

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "CienAnosSoledadFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000106 node1 dbis 1000000283 node0->node1 ns0:P10291

Family: CrimePunishmentFamily

In [18]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "CrimePunishmentFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000069 node1 dbis 1000000050 node0->node1 ns0:P10155 node2 dbis 1000000248 node0->node2 ns0:P10155 node3 dbis 1000000001 node0->node3 ns0:P10016

Family: DonQuijoteFamily

In [19]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "DonQuijoteFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000040 node1 dbis 1000000101 node0->node1 ns0:P10099 node2 dbis 1000000042 node0->node2 ns0:P10147 node3 dbis 1000000041 node0->node3 ns0:P10147 node3->node2 ns0:P10170

Family: FaustFamily

In [20]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "FaustFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000110 node1 dbis 1000000563 node0->node1 ns0:P10147 node2 dbis 1000000115 node0->node2 ns0:P10155 node4 dbis 1000000111 node0->node4 ns0:P10170 node5 dbis 1000000112 node0->node5 ns0:P10236 node3 dbis 1000000108 node3->node0 ns0:P10147 node3->node4 ns0:P10147 node6 dbis 1000000250 node3->node6 ns0:P10155

Family: IliadFamily

In [21]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "IliadFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000119 node1 dbis 1000000220 node0->node1 ns0:P10155 node2 dbis 1000000120 node0->node2 ns0:P10147

Family: KaramazovBrothersFamily

In [22]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "KaramazovBrothersFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000070 node1 dbis 1000000102 node0->node1 ns0:P10016 node2 dbis 1000000281 node0->node2 ns0:P10016

Family: MadameBovaryFamily

In [23]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "MadameBovaryFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000104 node1 dbis 1000000009 node0->node1 ns0:P10113 node2 dbis 1000000166 node0->node2 ns0:P10155

Family: OdysseyFamily

In [24]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "OdysseyFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000121 node1 dbis 1000000169 node0->node1 ns0:P10155

Family: ScarletLetterFamily

In [25]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "ScarletLetterFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000118 node1 dbis 1000000004 node0->node1 ns0:P10016 node2 dbis 1000000065 node0->node2 ns0:P10236 node3 dbis 1000000067 node0->node3 ns0:P10016 node4 dbis 1000000114 node0->node4 ns0:P10155 node5 dbis 1000000167 node0->node5 ns0:P10236

Family: TomSawyerFamily

In [26]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "TomSawyerFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000282 node1 dbis 1000000107 node0->node1 ns0:P10155 node2 dbis 1000000043 node0->node2 ns0:P10155 node3 dbis 1000000247 node0->node3 ns0:P10016 node4 dbis 1000000146 node0->node4 ns0:P10155 node5 dbis 1000000199 node0->node5 ns0:P10155 node6 dbis 1000000222 node0->node6 ns0:P10291

Family: WutheringHeightsFamily

In [27]:
%display diagram

CONSTRUCT{
   ?w ?p ?o.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "WutheringHeightsFamily"@en).

    ?w ?p ?o.
    ?o a  rdac:C10001.
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291).
}
Display: svg
%3 node0 dbis 1000000012 node1 dbis 1000000066 node0->node1 ns0:P10155 node2 dbis 1000000142 node0->node2 ns0:P10155 node3 dbis 1000000249 node0->node3 ns0:P10155 node4 dbis 1000000039 node0->node4 ns0:P10291 node5 dbis 1000000038 node0->node5 ns0:P10155 node6 dbis 1000000219 node0->node6 ns0:P10155

Visualize Works and Expressions in families

each Family is generated by:

  • Work -2- Work

  • Work -2- Expression

  • Expression -2- Expression
    • </ul> </b> This is a more complete visualization of a family, because it contains also Expressions, as well as relationships expressed in Expression level.

    Note also the extension of the filter statement in order to include all relationships expressed in Expression level.

    Expression level relationships summary:

    propertypLabel
    P20076is replaced by (expression)
    P20110is adapted as libretto (expression)
    P20145is container of (expression)
    P20153is adapted as (expression)
    P20166is abridged as (expression)
    P20171is translated as
    P20203is derivative (expression)
    P20211is revised as

    TODO
    Extend statements for labels in order to better validate the inclusion of only Works in family.

In [28]:
%display diagram

CONSTRUCT{
    ?s ?p ?o.
    ?o ?p1 ?o1.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?s ?p ?o;
       a rdac:C10001.

    ?s rdfs:comment ?sfamilyLabel.
    
    FILTER EXISTS {{?o a rdac:C10001} UNION {?o a rdac:C10006} } # W -2- W, W -2- E 
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291 or
            ?p = rdawo:P10078).
    
    
    OPTIONAL{
        ?o ?p1 ?o1.
        FILTER EXISTS {?o1 a rdac:C10006 } # E -2- E
        
        FILTER (?p1 = rdaeo:P20076 or ?p1 = rdaeo:P20110 or ?p1 = rdaeo:P20145 or 
                ?p1 = rdaeo:P20153 or ?p1 = rdaeo:P20166 or ?p1 = rdaeo:P20171 or 
                ?p1 = rdaeo:P20203 or ?p1 = rdaeo:P20211).
    }
}
Display: svg
%3 node0 dbis 1000000012 node1 dbis 1000000287 node0->node1 ns0:P10078 node2 dbis 1000000290 node0->node2 ns0:P10078 node24 dbis 1000000142 node0->node24 ns0:P10155 node28 dbis 1000000293 node0->node28 ns0:P10078 node60 dbis 1000000292 node0->node60 ns0:P10078 node74 dbis 1000000219 node0->node74 ns0:P10155 node97 dbis 1000000039 node0->node97 ns0:P10291 node154 dbis 1000000299 node0->node154 ns0:P10078 node161 dbis 1000000249 node0->node161 ns0:P10155 node164 dbis 1000000301 node0->node164 ns0:P10078 node173 dbis 1000000298 node0->node173 ns0:P10078 node185 dbis 1000000289 node0->node185 ns0:P10078 node199 dbis 1000000038 node0->node199 ns0:P10155 node213 dbis 1000000291 node0->node213 ns0:P10078 node235 dbis 1000000066 node0->node235 ns0:P10155 node3 dbis 1000000041 node4 dbis 1000000057 node3->node4 ns0:P10078 node35 dbis 1000000042 node3->node35 ns0:P10170 node124 dbis 1000000056 node3->node124 ns0:P10078 node168 dbis 1000000055 node3->node168 ns0:P10078 node209 dbis 1000000054 node3->node209 ns0:P10078 node5 dbis 1000000070 node6 dbis 1000000154 node5->node6 ns0:P10078 node15 dbis 1000000147 node5->node15 ns0:P10078 node34 dbis 1000000165 node5->node34 ns0:P10078 node41 dbis 1000000102 node5->node41 ns0:P10016 node58 dbis 1000000153 node5->node58 ns0:P10078 node59 dbis 1000000155 node5->node59 ns0:P10078 node79 dbis 1000000158 node5->node79 ns0:P10078 node83 dbis 1000000159 node5->node83 ns0:P10078 node86 dbis 1000000281 node5->node86 ns0:P10016 node92 dbis 1000000150 node5->node92 ns0:P10078 node105 dbis 1000000163 node5->node105 ns0:P10078 node121 dbis 1000000152 node5->node121 ns0:P10078 node134 dbis 1000000148 node5->node134 ns0:P10078 node141 dbis 1000000149 node5->node141 ns0:P10078 node196 dbis 1000000151 node5->node196 ns0:P10078 node206 dbis 1000000164 node5->node206 ns0:P10078 node214 dbis 1000000157 node5->node214 ns0:P10078 node223 dbis 1000000113 node5->node223 ns0:P10078 node7 dbis 1000000069 node8 dbis 1000000248 node7->node8 ns0:P10155 node11 dbis 1000000035 node7->node11 ns0:P10078 node12 dbis 1000000033 node7->node12 ns0:P10078 node20 dbis 1000000025 node7->node20 ns0:P10078 node48 dbis 1000000023 node7->node48 ns0:P10078 node49 dbis 1000000029 node7->node49 ns0:P10078 node85 dbis 1000000018 node7->node85 ns0:P10078 node133 dbis 1000000028 node7->node133 ns0:P10078 node139 dbis 1000000026 node7->node139 ns0:P10078 node144 dbis 1000000019 node7->node144 ns0:P10078 node147 dbis 1000000050 node7->node147 ns0:P10155 node160 dbis 1000000036 node7->node160 ns0:P10078 node175 dbis 1000000031 node7->node175 ns0:P10078 node184 dbis 1000000027 node7->node184 ns0:P10078 node190 dbis 1000000032 node7->node190 ns0:P10078 node218 dbis 1000000001 node7->node218 ns0:P10016 node238 dbis 1000000024 node7->node238 ns0:P10078 node242 dbis 1000000020 node7->node242 ns0:P10078 node240 dbis 1000000037 node8->node240 ns0:P10078 node9 dbis 1000000139 node10 dbis 1000000128 node9->node10 ns2:P20171 node11->node12 ns2:P20171 node11->node49 ns2:P20171 node11->node85 ns2:P20171 node11->node139 ns2:P20171 node11->node160 ns2:P20171 node11->node184 ns2:P20171 node11->node190 ns2:P20171 node13 dbis 1000000174 node14 dbis 1000000191 node13->node14 ns2:P20166 node16 dbis 1000000104 node16->node13 ns0:P10078 node16->node14 ns0:P10078 node17 dbis 1000000186 node16->node17 ns0:P10078 node40 dbis 1000000188 node16->node40 ns0:P10078 node46 dbis 1000000189 node16->node46 ns0:P10078 node50 dbis 1000000171 node16->node50 ns0:P10078 node51 dbis 1000000166 node16->node51 ns0:P10155 node66 dbis 1000000181 node16->node66 ns0:P10078 node73 dbis 1000000190 node16->node73 ns0:P10078 node106 dbis 1000000182 node16->node106 ns0:P10078 node122 dbis 1000000176 node16->node122 ns0:P10078 node142 dbis 1000000180 node16->node142 ns0:P10078 node145 dbis 1000000183 node16->node145 ns0:P10078 node151 dbis 1000000009 node16->node151 ns0:P10113 node162 dbis 1000000172 node16->node162 ns0:P10078 node166 dbis 1000000175 node16->node166 ns0:P10078 node189 dbis 1000000179 node16->node189 ns0:P10078 node193 dbis 1000000195 node16->node193 ns0:P10078 node202 dbis 1000000194 node16->node202 ns0:P10078 node208 dbis 1000000192 node16->node208 ns0:P10078 node211 dbis 1000000184 node16->node211 ns0:P10078 node230 dbis 1000000187 node16->node230 ns0:P10078 node18 dbis 1000000278 node19 dbis 1000000262 node18->node19 ns2:P20203 node21 dbis 1000000121 node22 dbis 1000000169 node21->node22 ns0:P10155 node43 dbis 1000000208 node21->node43 ns0:P10078 node44 dbis 1000000200 node21->node44 ns0:P10078 node53 dbis 1000000214 node21->node53 ns0:P10078 node71 dbis 1000000216 node21->node71 ns0:P10078 node72 dbis 1000000215 node21->node72 ns0:P10078 node82 dbis 1000000201 node21->node82 ns0:P10078 node100 dbis 1000000205 node21->node100 ns0:P10078 node111 dbis 1000000202 node21->node111 ns0:P10078 node131 dbis 1000000211 node21->node131 ns0:P10078 node132 dbis 1000000212 node21->node132 ns0:P10078 node146 dbis 1000000204 node21->node146 ns0:P10078 node158 dbis 1000000213 node21->node158 ns0:P10078 node181 dbis 1000000210 node21->node181 ns0:P10078 node198 dbis 1000000209 node21->node198 ns0:P10078 node45 dbis 1000000206 node22->node45 ns0:P10078 node23 dbis 1000000140 node23->node9 ns2:P20171 node25 dbis 1000000296 node24->node25 ns0:P10078 node26 dbis 1000000107 node27 dbis 1000000256 node26->node27 ns0:P10078 node29 dbis 1000000282 node29->node18 ns0:P10078 node29->node19 ns0:P10078 node29->node26 ns0:P10155 node30 dbis 1000000222 node29->node30 ns0:P10291 node33 dbis 1000000274 node29->node33 ns0:P10078 node61 dbis 1000000264 node29->node61 ns0:P10078 node77 dbis 1000000272 node29->node77 ns0:P10078 node78 dbis 1000000252 node29->node78 ns0:P10078 node96 dbis 1000000271 node29->node96 ns0:P10078 node99 dbis 1000000043 node29->node99 ns0:P10155 node118 dbis 1000000266 node29->node118 ns0:P10078 node127 dbis 1000000251 node29->node127 ns0:P10078 node128 dbis 1000000263 node29->node128 ns0:P10078 node135 dbis 1000000268 node29->node135 ns0:P10078 node138 dbis 1000000199 node29->node138 ns0:P10155 node149 dbis 1000000146 node29->node149 ns0:P10155 node152 dbis 1000000277 node29->node152 ns0:P10078 node178 dbis 1000000267 node29->node178 ns0:P10078 node180 dbis 1000000261 node29->node180 ns0:P10078 node186 dbis 1000000275 node29->node186 ns0:P10078 node201 dbis 1000000247 node29->node201 ns0:P10016 node207 dbis 1000000254 node29->node207 ns0:P10078 node216 dbis 1000000269 node29->node216 ns0:P10078 node225 dbis 1000000270 node29->node225 ns0:P10078 node226 dbis 1000000259 node29->node226 ns0:P10078 node237 dbis 1000000260 node29->node237 ns0:P10078 node87 dbis 1000000276 node30->node87 ns0:P10078 node31 dbis 1000000065 node32 dbis 1000000226 node31->node32 ns0:P10078 node33->node18 ns2:P20166 node33->node78 ns2:P20166 node33->node127 ns2:P20166 node33->node135 ns2:P20145 node33->node180 ns2:P20203 node33->node207 ns2:P20166 node36 dbis 1000000059 node35->node36 ns0:P10078 node37 dbis 1000000060 node35->node37 ns0:P10078 node113 dbis 1000000058 node35->node113 ns0:P10078 node38 dbis 1000000108 node39 dbis 1000000078 node38->node39 ns0:P10078 node62 dbis 1000000085 node38->node62 ns0:P10078 node63 dbis 1000000111 node38->node63 ns0:P10147 node67 dbis 1000000110 node38->node67 ns0:P10147 node91 dbis 1000000076 node38->node91 ns0:P10078 node94 dbis 1000000088 node38->node94 ns0:P10078 node95 dbis 1000000075 node38->node95 ns0:P10078 node136 dbis 1000000084 node38->node136 ns0:P10078 node140 dbis 1000000086 node38->node140 ns0:P10078 node169 dbis 1000000099 node38->node169 ns0:P10078 node187 dbis 1000000250 node38->node187 ns0:P10155 node191 dbis 1000000077 node38->node191 ns0:P10078 node192 dbis 1000000073 node38->node192 ns0:P10078 node194 dbis 1000000097 node38->node194 ns0:P10078 node195 dbis 1000000080 node38->node195 ns0:P10078 node210 dbis 1000000096 node38->node210 ns0:P10078 node212 dbis 1000000082 node38->node212 ns0:P10078 node220 dbis 1000000098 node38->node220 ns0:P10078 node239 dbis 1000000079 node38->node239 ns0:P10078 node42 dbis 1000000161 node41->node42 ns0:P10078 node43->node181 ns2:P20203 node44->node45 ns2:P20153 node44->node82 ns2:P20211 node46->node13 ns2:P20171 node46->node17 ns2:P20171 node47 dbis 1000000178 node46->node47 ns2:P20110 node46->node166 ns2:P20166 node46->node193 ns2:P20171 node52 dbis 1000000185 node51->node52 ns0:P10078 node53->node43 ns2:P20171 node53->node44 ns2:P20171 node53->node71 ns2:P20171 node53->node72 ns2:P20171 node53->node82 ns2:P20171 node53->node100 ns2:P20171 node53->node111 ns2:P20171 node53->node131 ns2:P20171 node54 dbis 1000000138 node55 dbis 1000000137 node54->node55 ns2:P20211 node56 dbis 1000000119 node56->node23 ns0:P10078 node56->node54 ns0:P10078 node56->node55 ns0:P10078 node57 dbis 1000000127 node56->node57 ns0:P10078 node68 dbis 1000000120 node56->node68 ns0:P10147 node69 dbis 1000000130 node56->node69 ns0:P10078 node70 dbis 1000000126 node56->node70 ns0:P10078 node76 dbis 1000000131 node56->node76 ns0:P10078 node84 dbis 1000000125 node56->node84 ns0:P10078 node103 dbis 1000000559 node56->node103 ns0:P10078 node104 dbis 1000000124 node56->node104 ns0:P10078 node114 dbis 1000000220 node56->node114 ns0:P10155 node115 dbis 1000000133 node56->node115 ns0:P10078 node116 dbis 1000000135 node56->node116 ns0:P10078 node123 dbis 1000000134 node56->node123 ns0:P10078 node170 dbis 1000000123 node56->node170 ns0:P10078 node174 dbis 1000000129 node56->node174 ns0:P10078 node177 dbis 1000000122 node56->node177 ns0:P10078 node179 dbis 1000000132 node56->node179 ns0:P10078 node58->node6 ns2:P20211 node58->node59 ns2:P20211 node58->node223 ns2:P20166 node60->node1 ns2:P20171 node60->node154 ns2:P20171 node60->node164 ns2:P20171 node156 dbis 1000000095 node63->node156 ns0:P10078 node157 dbis 1000000094 node63->node157 ns0:P10078 node64 dbis 1000000145 node65 dbis 1000000144 node64->node65 ns2:P20171 node67->node63 ns0:P10170 node88 dbis 1000000091 node67->node88 ns0:P10078 node107 dbis 1000000093 node67->node107 ns0:P10078 node109 dbis 1000000563 node67->node109 ns0:P10147 node143 dbis 1000000112 node67->node143 ns0:P10236 node229 dbis 1000000090 node67->node229 ns0:P10078 node234 dbis 1000000115 node67->node234 ns0:P10155 node68->node9 ns0:P10078 node68->node10 ns0:P10078 node153 dbis 1000000560 node68->node153 ns0:P10078 node69->node76 ns2:P20211 node70->node57 ns2:P20203 node71->node72 ns2:P20211 node75 dbis 1000000297 node74->node75 ns0:P10078 node79->node6 ns2:P20171 node79->node58 ns2:P20171 node79->node59 ns2:P20171 node79->node83 ns2:P20171 node79->node92 ns2:P20171 node79->node105 ns2:P20171 node79->node134 ns2:P20171 node80 dbis 1000000232 node81 dbis 1000000241 node80->node81 ns2:P20171 node182 dbis 1000000233 node80->node182 ns2:P20171 node82->node111 ns2:P20076 node231 dbis 1000000162 node86->node231 ns0:P10078 node110 dbis 1000000089 node88->node110 ns2:P20145 node89 dbis 1000000040 node89->node3 ns0:P10147 node89->node35 ns0:P10147 node90 dbis 1000000061 node89->node90 ns0:P10078 node93 dbis 1000000101 node89->node93 ns0:P10099 node112 dbis 1000000561 node89->node112 ns0:P10078 node117 dbis 1000000064 node89->node117 ns0:P10078 node137 dbis 1000000062 node93->node137 ns0:P10078 node167 dbis 1000000063 node93->node167 ns0:P10078 node94->node88 ns2:P20145 node94->node95 ns2:P20171 node94->node140 ns2:P20171 node94->node156 ns2:P20145 node98 dbis 1000000198 node97->node98 ns0:P10078 node232 dbis 1000000255 node99->node232 ns0:P10078 node101 dbis 1000000118 node101->node31 ns0:P10236 node101->node80 ns0:P10078 node101->node81 ns0:P10078 node102 dbis 1000000245 node101->node102 ns0:P10078 node108 dbis 1000000227 node101->node108 ns0:P10078 node125 dbis 1000000114 node101->node125 ns0:P10155 node129 dbis 1000000167 node101->node129 ns0:P10236 node148 dbis 1000000004 node101->node148 ns0:P10016 node155 dbis 1000000067 node101->node155 ns0:P10016 node101->node182 ns0:P10078 node203 dbis 1000000239 node101->node203 ns0:P10078 node204 dbis 1000000240 node101->node204 ns0:P10078 node217 dbis 1000000243 node101->node217 ns0:P10078 node219 dbis 1000000230 node101->node219 ns0:P10078 node222 dbis 1000000229 node101->node222 ns0:P10078 node228 dbis 1000000242 node101->node228 ns0:P10078 node103->node23 ns2:P20171 node103->node54 ns2:P20171 node103->node55 ns2:P20171 node103->node69 ns2:P20171 node103->node70 ns2:P20171 node103->node76 ns2:P20171 node103->node104 ns2:P20171 node103->node153 ns2:P20145 node103->node179 ns2:P20171 node171 dbis 1000000136 node104->node171 ns2:P20153 node109->node110 ns0:P10078 node112->node113 ns2:P20145 node112->node117 ns2:P20171 node112->node168 ns2:P20145 node114->node171 ns0:P10078 node115->node116 ns2:P20203 node119 dbis 1000000106 node120 dbis 1000000045 node119->node120 ns0:P10078 node163 dbis 1000000049 node119->node163 ns0:P10078 node165 dbis 1000000283 node119->node165 ns0:P10291 node176 dbis 1000000048 node119->node176 ns0:P10078 node197 dbis 1000000047 node119->node197 ns0:P10078 node205 dbis 1000000046 node119->node205 ns0:P10078 node123->node116 ns2:P20166 node126 dbis 1000000228 node125->node126 ns0:P10078 node127->node128 ns2:P20203 node130 dbis 1000000231 node129->node130 ns0:P10078 node131->node132 ns2:P20166 node131->node158 ns2:P20203 node137->node167 ns2:P20171 node183 dbis 1000000253 node138->node183 ns0:P10078 node139->node144 ns2:P20203 node159 dbis 1000000087 node143->node159 ns0:P10078 node227 dbis 1000000022 node147->node227 ns0:P10078 node172 dbis 1000000234 node148->node172 ns0:P10078 node150 dbis 1000000257 node149->node150 ns0:P10078 node151->node47 ns0:P10078 node224 dbis 1000000237 node155->node224 ns0:P10078 node156->node157 ns2:P20171 node221 dbis 1000000300 node161->node221 ns0:P10078 node165->node64 ns0:P10078 node165->node65 ns0:P10078 node176->node120 ns2:P20171 node176->node163 ns2:P20171 node176->node205 ns2:P20171 node179->node115 ns2:P20166 node179->node123 ns2:P20203 node188 dbis 1000000083 node187->node188 ns0:P10078 node200 dbis 1000000294 node199->node200 ns0:P10078 node215 dbis 1000000258 node201->node215 ns0:P10078 node233 dbis 1000000015 node218->node233 ns0:P10078 node241 dbis 1000000092 node234->node241 ns0:P10078 node236 dbis 1000000295 node235->node236 ns0:P10078

Visualize Works and Expressions in a family

using labels

... focus on a family

each Family is generated by the following relationships:

  • Work -2- Work

  • Work -2- Expression

  • Expression -2- Expression
    • </ul> </b>

    To include also properties to the opposite direction (inverse properties) remove respective property filters.
    Moreover, to exclude Expressions -2- Expressions properties remove OPTIONAL statements.

    To specify a family, set its name in statement:</br> FILTER (?familyLabel = "CienAnosSoledadFamily")

    Note:</br> to see all family names run the sparql Enumerate families

Family: CienAnosSoledadFamily

In [29]:
%display diagram svg withliterals
%lang en

CONSTRUCT{
    ?s ?p ?o.
    ?o ?p1 ?o1.
    ?s rdfs:label ?workID.
    ?o rdfs:label ?workExpID.
    ?o1 rdfs:label ?expID.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?s a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "CienAnosSoledadFamily"@en).

    ?s ?p ?o.
    FILTER EXISTS {{?o a rdac:C10001} UNION {?o a rdac:C10006} } # W -2- W, W -2- E 
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291 or
            ?p = rdawo:P10078).
    
    OPTIONAL{
        ?o ?p1 ?o1.
        FILTER EXISTS {?o1 a rdac:C10006 } # E -2- E
        
        FILTER (?p1 = rdaeo:P20076 or ?p1 = rdaeo:P20110 or ?p1 = rdaeo:P20145 or 
                ?p1 = rdaeo:P20153 or ?p1 = rdaeo:P20166 or ?p1 = rdaeo:P20171 or 
                ?p1 = rdaeo:P20203 or ?p1 = rdaeo:P20211).
        
        # get instances' label
        OPTIONAL { # when debug, use it as optional to find also works without a Work matching key
            ?o1 rdfs:label ?expID.
        }
    }
    
    # get instances' label
    OPTIONAL { # when debug, use it as optional to find also works without a Work matching key
        ?s rdfs:label ?workID
    }
    OPTIONAL { # when debug, use it as optional to find also works without a Work matching key
        ?o rdfs:label ?workExpID
    }
}
Display: svg
Show literals: on
Label preferred languages: ['en']
%3 node0 García Márquez, Gabriel, 1927-2014. Cien años de soledad. node1 (Text), spa. node0->node1 ns3:P10078 node2 English (Text), eng. Contributor(s): Rabassa, Gregory. node0->node2 ns3:P10078 node3 Italian (Text), ita. node0->node3 ns3:P10078 node4 Wallrafen, Hannes. Jornada en Macondo. node0->node4 ns3:P10291 node7 French (Text), fre. Contributor(s): Durand, Claude, 1938- tr. Durand, Carmen tr. node0->node7 ns3:P10078 node8 (Text), spa. Contributor(s): Joset, Jacques, 1943- . node0->node8 ns3:P10078 node1->node2 ns2:P20171 node1->node3 ns2:P20171 node1->node7 ns2:P20171 node5 (Text), spa. node4->node5 ns3:P10078 node6 Dutch (Text), dut. node4->node6 ns3:P10078 node5->node6 ns2:P20171

Family: TomSawyerFamily

In [30]:
%display diagram svg withliterals
%lang en

CONSTRUCT{
    ?s ?p ?o.
    ?o ?p1 ?o1.
    ?s rdfs:label ?workID.
    ?o rdfs:label ?workExpID.
    ?o1 rdfs:label ?expID.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?s a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "TomSawyerFamily"@en).

    ?s ?p ?o.
    FILTER EXISTS {{?o a rdac:C10001} UNION {?o a rdac:C10006} } # W -2- W, W -2- E 
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291 or
            ?p = rdawo:P10078).
    
    OPTIONAL{
        ?o ?p1 ?o1.
        FILTER EXISTS {?o1 a rdac:C10006 } # E -2- E
        
        FILTER (?p1 = rdaeo:P20076 or ?p1 = rdaeo:P20110 or ?p1 = rdaeo:P20145 or 
                ?p1 = rdaeo:P20153 or ?p1 = rdaeo:P20166 or ?p1 = rdaeo:P20171 or 
                ?p1 = rdaeo:P20203 or ?p1 = rdaeo:P20211).
        
        OPTIONAL { # when debug, use it as optional to find also works without a Work matching key
            ?o1 rdfs:label ?expID.
        }
    }
    
    OPTIONAL { # when debug, use it as optional to find also works without a Work matching key
        ?s rdfs:label ?workID
    }
    OPTIONAL { # when debug, use it as optional to find also works without a Work matching key
        ?o rdfs:label ?workExpID
    }

}
Display: svg
Show literals: on
Label preferred languages: ['en']
%3 node0 Twain, Mark, 1835-1910. Adventures of Tom Sawyer. node1 Japanese (Text), jpn. Contributor(s): Ōtsuka, Yūzō, 1921- . node0->node1 ns2:P10078 node2 Selections. (Text), eng. Contributor(s): Pirotta, Saviour, 1958- node0->node2 ns2:P10078 node3 Bengali (Text), ben. Contributor(s): Sirajur Rahman. node0->node3 ns2:P10078 node4 Chorpenning, Charlotte B. Tom Sawyer's treasure hunt, (dramatized from Samuel L. Clemens' Tom Sawyer) in four acts. node0->node4 ns2:P10155 node6 Selections. (Text), eng. node0->node6 ns2:P10078 node7 Malayalan (Text), mal. Contributor(s): Malayāḷarājyaṃ, tr. node0->node7 ns2:P10078 node8 Richardson, I. M. Tom Sawyer becomes a pirate. node0->node8 ns2:P10291 node9 (Audio), eng. node0->node9 ns2:P10078 node10 Selections. (Audio), eng. Contributor(s): Crosby, Bing, 1903-1977. node0->node10 ns2:P10078 node11 Selections. (Audio), eng. Contributor(s): Begley, Ed, 1901-1970. node0->node11 ns2:P10078 node12 (Text), eng. node0->node12 ns2:P10078 node14 Selections. (Audio), eng. Contributor(s): Hogan, Garrick node0->node14 ns2:P10078 node15 Polish (Text), pol. node0->node15 ns2:P10078 node16 Spencer, Sara. Tom Sawyer, dramatized from Mark Twain's story. node0->node16 ns2:P10016 node18 Selections. (Text), eng. node0->node18 ns2:P10078 node19 Spanish (Text), spa. Contributor(s): Barreto, José, tr. node0->node19 ns2:P10078 node20 complete story of Tom Sawyer. node0->node20 ns2:P10155 node22 (Text), eng. Contributor(s): Blaisdell, Robert. node0->node22 ns2:P10078 node23 (Audio), eng. Contributor(s): Chandler, Jeff, 1918-1961. node0->node23 ns2:P10078 node24 Gise, Joanne. Adventures of Tom Sawyer. node0->node24 ns2:P10155 node25 Russian (Text), rus. Contributor(s): Chukovskiĭ, Korneĭ, 1882-1969. node0->node25 ns2:P10078 node26 Selections. (Text), eng. Contributor(s): Usill, Dillon. node0->node26 ns2:P10078 node27 German (Text), ger. node0->node27 ns2:P10078 node28 Hebrew (Text), heb. node0->node28 ns2:P10078 node29 Kaplanowicz, Dan, 1880- . Yunge gazlonim. node0->node29 ns2:P10155 node31 Selections. (Audio), eng. Contributor(s): Newman, Paul, 1925-2008 nrt. node0->node31 ns2:P10078 node5 (Text), eng. node4->node5 ns2:P10078 node6->node14 ns3:P20203 node13 (Text), eng. node8->node13 ns2:P10078 node12->node2 ns3:P20166 node12->node6 ns3:P20166 node12->node18 ns3:P20145 node12->node22 ns3:P20166 node12->node23 ns3:P20203 node12->node26 ns3:P20166 node17 (Text), eng. node16->node17 ns2:P10078 node21 (Text), eng. node20->node21 ns2:P10078 node32 (Text), eng. node24->node32 ns2:P10078 node26->node10 ns3:P20203 node30 (Text), heb. node29->node30 ns2:P10078

Visualize Works, Expressions and Manifestations in a family

... focus on a family

each Family is generated by the following relationships:

  • Work -2- Work

  • Work -2- Expression

  • Expression -2- Expression

  • Expression -2- Manifestation

  • Manifestation -2- Manifestation
    • </ul> </b>

    To include also properties to the opposite direction (inverse properties) remove respective property filters.

    To specify a family, set its name in statement:</br> FILTER (?familyLabel = "TomSawyerFamily")

    Note:</br> to see all family names run the sparql Enumerate families

In [31]:
%display diagram svg withliterals
#%lang en

CONSTRUCT{
    ?w ?p ?we.
    ?we ?p1 ?e1.
    ?e rdaeo:P20059 ?m.
    ?m ?p2 ?m1.
    ?w rdfs:label ?workID.
    ?we rdfs:label ?workExpID.
    ?e1 rdfs:label ?exp1ID.
    ?e rdfs:label ?expID.
    ?m rdfs:label ?mID.
    ?m1 rdfs:label ?m1ID.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    ?w a rdac:C10001;
       rdfs:comment ?familyLabel.
    
    FILTER (?familyLabel = "TomSawyerFamily"@en). 

    ?w ?p ?we.
    FILTER EXISTS {{?we a rdac:C10001} UNION {?we a rdac:C10006} } # W -2- W, W -2- E 
    
    FILTER (?p = rdawo:P10016 or ?p = rdawo:P10099 or ?p = rdawo:P10113 or
            ?p = rdawo:P10147 or ?p = rdawo:P10155 or ?p = rdawo:P10170 or 
            ?p = rdawo:P10236 or ?p = rdawo:P10257 or ?p = rdawo:P10291 or
            ?p = rdawo:P10078).
    
    OPTIONAL{
        ?we ?p1 ?e1.
        FILTER EXISTS {?e1 a rdac:C10006 } # E -2- E
        FILTER (?p1 = rdaeo:P20076 or ?p1 = rdaeo:P20110 or ?p1 = rdaeo:P20145 or 
                ?p1 = rdaeo:P20153 or ?p1 = rdaeo:P20166 or ?p1 = rdaeo:P20171 or 
                ?p1 = rdaeo:P20203 or ?p1 = rdaeo:P20211)
        
        OPTIONAL { ?e1 rdfs:label ?exp1ID }

        OPTIONAL{
            ?e rdaeo:P20059 ?m  # E -2- M
            #FILTER EXISTS {?m a rdac:C10007 }
            FILTER(?e = ?we or ?e = ?e1)
            
            OPTIONAL { ?e rdfs:label ?expID }
            OPTIONAL { ?m rdfs:label ?mID }
            
            OPTIONAL{ 
                ?m ?p2 ?m1
                FILTER EXISTS {?m1 a rdac:C10007 } # Μ -2- M
                FILTER (?p2 = rdamo:P30046 or ?p2 = rdamo:P30210)
                #FILTER (?p2 != rdf:type)
                
                OPTIONAL { ?m1 rdfs:label ?m1ID }
            }
        }
    }
    OPTIONAL { ?w rdfs:label ?workID }
    OPTIONAL { ?we rdfs:label ?workExpID }
    
}
Display: svg
Show literals: on
%3 node0 Twain, Mark, 1835-1910. Adventures of Tom Sawyer. node1 Selections. (Text), eng. Contributor(s): Usill, Dillon. node0->node1 ns3:P10078 node2 Malayalan (Text), mal. Contributor(s): Malayāḷarājyaṃ, tr. node0->node2 ns3:P10078 node3 complete story of Tom Sawyer. node0->node3 ns3:P10155 node5 Russian (Text), rus. Contributor(s): Chukovskiĭ, Korneĭ, 1882-1969. node0->node5 ns3:P10078 node6 Richardson, I. M. Tom Sawyer becomes a pirate. node0->node6 ns3:P10291 node7 Kaplanowicz, Dan, 1880- . Yunge gazlonim. node0->node7 ns3:P10155 node11 Selections. (Audio), eng. Contributor(s): Crosby, Bing, 1903-1977. node0->node11 ns3:P10078 node12 Chorpenning, Charlotte B. Tom Sawyer's treasure hunt, (dramatized from Samuel L. Clemens' Tom Sawyer) in four acts. node0->node12 ns3:P10155 node16 (Text), eng. node0->node16 ns3:P10078 node18 (Audio), eng. Contributor(s): Chandler, Jeff, 1918-1961. node0->node18 ns3:P10078 node20 Selections. (Audio), eng. Contributor(s): Hogan, Garrick node0->node20 ns3:P10078 node21 Selections. (Text), eng. node0->node21 ns3:P10078 node23 (Audio), eng. node0->node23 ns3:P10078 node24 Selections. (Audio), eng. Contributor(s): Begley, Ed, 1901-1970. node0->node24 ns3:P10078 node25 Selections. (Text), eng. node0->node25 ns3:P10078 node26 Polish (Text), pol. node0->node26 ns3:P10078 node27 Selections. (Text), eng. Contributor(s): Pirotta, Saviour, 1958- node0->node27 ns3:P10078 node28 (Text), eng. Contributor(s): Blaisdell, Robert. node0->node28 ns3:P10078 node30 Spencer, Sara. Tom Sawyer, dramatized from Mark Twain's story. node0->node30 ns3:P10016 node31 Gise, Joanne. Adventures of Tom Sawyer. node0->node31 ns3:P10155 node35 Bengali (Text), ben. Contributor(s): Sirajur Rahman. node0->node35 ns3:P10078 node36 Selections. (Audio), eng. Contributor(s): Newman, Paul, 1925-2008 nrt. node0->node36 ns3:P10078 node37 German (Text), ger. node0->node37 ns3:P10078 node39 Spanish (Text), spa. Contributor(s): Barreto, José, tr. node0->node39 ns3:P10078 node40 Hebrew (Text), heb. node0->node40 ns3:P10078 node41 Japanese (Text), jpn. Contributor(s): Ōtsuka, Yūzō, 1921- . node0->node41 ns3:P10078 node1->node11 ns2:P20203 node4 (Text), eng. node3->node4 ns3:P10078 node29 (Text), eng. node6->node29 ns3:P10078 node8 (Text), heb. node7->node8 ns3:P10078 node9 2008. Naperville, Ill. : Sourcebooks Jabberwocky, 2008. node10 2008. Naperville, Ill. : Sourcebooks Jabberwocky, 2008. node9->node10 ns4:P30210 node10->node9 ns4:P30210 node19 [n.p.] Argo ZSW 561-3. p1976. node11->node19 ns2:P20059 node13 (Text), eng. node12->node13 ns3:P10078 node14 1982. Frederick, Md. : University Publications of America ; Washington, D.C. : Georgetown University Library, c1982. node15 1876. 1876. node14->node15 ns4:P30046 node16->node1 ns2:P20166 node16->node14 ns2:P20059 node16->node15 ns2:P20059 node17 1946. New York, Grosset & Dunlap [1946] node16->node17 ns2:P20059 node16->node18 ns2:P20203 node16->node21 ns2:P20145 node16->node25 ns2:P20166 node16->node27 ns2:P20166 node16->node28 ns2:P20166 node33 1994. [Knoxville, Tenn.] : BookWorm, c1994. node16->node33 ns2:P20059 node42 1964. Avon, Conn., Heritage Press [1964, c1936] node16->node42 ns2:P20059 node44 1992. Chicago, Ill. : J.G. Ferguson Pub. Co., c1992. node16->node44 ns2:P20059 node46 1954. Garden City, N.Y., Junior Deluxe Editions [1954] node16->node46 ns2:P20059 node38 [n.p.] Audio Book Talking Books C 311. [1960] node18->node38 ns2:P20059 node20->node10 ns2:P20059 node22 1876. Hartford, Conn. : American Pub. Co., 1876, c1875. node21->node22 ns2:P20059 node25->node9 ns2:P20059 node25->node20 ns2:P20203 node34 2013. New York, New York : Sandy Creek, [2013] node27->node34 ns2:P20059 node45 1996. New York : Dover Publications, c1996. node28->node45 ns2:P20059 node32 (Text), eng. node30->node32 ns3:P10078 node43 (Text), eng. node31->node43 ns3:P10078

A complete 4-Levels exploration of an RDA Work

using labels

In [32]:
%display diagram svg withliterals
%lang en

CONSTRUCT{
    <http://dbis.ionio.gr/Resources/library#dbis_1000000001> ?p ?o.
    ?o ?p1 ?o1.
    ?o1 ?p2 ?o2.
    ?o2 ?p3 ?o3.
}

FROM <http://dbis.ionio.gr/grdadrv>

WHERE {
    <http://dbis.ionio.gr/Resources/library#dbis_1000000001> ?p ?o.
    
    FILTER (?p != rdf:type)
    
    OPTIONAL{
        ?o ?p1 ?o1.
        FILTER (?p1 != rdf:type)
        
        OPTIONAL{
            ?o1 ?p2 ?o2.
            FILTER (?p2 != rdf:type)
            
            OPTIONAL{
                ?o2 ?p3 ?o3
                FILTER (?p3 != rdf:type)
            }
        }
    }
#    FILTER (?p = rdf:type or  ?p = skos:note or ?p = rdfs:label or  ?p = rdfs:comment or
#            ?p = rdawo:P10061 or ?p = rdawo:P10078 or ?p = rdawo:P10127 or
#            ?p = rdawd:P10002 or ?p = rdawd:P10088).
    
}
Display: svg
Show literals: on
Label preferred languages: ['en']
%3 node0 (Audio), eng. node1 Jackson, Robert Louis node0->node1 ns7:P20024 node82 Jackson, Robert Louis. Crime and punishment (Dostoevsky). node0->node82 ns7:P20231 node91 dbis 1000000357 node0->node91 ns7:P20059 node2 Amharic (Text), amh. Contributor(s): Kassa Gebre-Hiywot Fantu Sahle node3 2004. ʼAdis ʼAbabā, ʼItyop̣yā : Šāmā buks, 1997 [2004 or 2005] node2->node3 ns7:P20059 node5 Dostoyevsky, Fyodor, 1821-1881. Prestuplenie i nakazanie. node2->node5 ns7:P20231 node21 (Text), rus. node2->node21 ns7:P20141 node62 Fāntu Śāhlé‏ node2->node62 ns7:P20037 node90 Kassa Gebre-Hiywot node2->node90 ns7:P20037 node3->node2 ns10:P30139 node57 man083 node3->node57 rdfs:comment node4 Suter, Joanne. Crime and punishment. node4->node5 ns5:P10142 node7 CrimePunishmentFamily node4->node7 rdfs:comment node30 Suter, Joanne node4->node30 ns5:P10061 node76 (Text), eng. node4->node76 ns5:P10078 node5->node2 ns5:P10078 node5->node4 ns5:P10155 node6 Cowley, Joseph, 1923- . Crime and punishment. node5->node6 ns5:P10155 node5->node7 rdfs:comment node10 German. (Text), ger. Contributor(s): Dedek, Bernhard, ed. node5->node10 ns5:P10078 node12 English (Audio), eng. Contributor(s): Guidall, George nrt Garnett, Constance, 1861-1946 trl. node5->node12 ns5:P10078 node13 English (Text), eng. Contributor(s): Garnett, Constance, 1861-1946 tr. Neilson, William Allan, 1869-1946, ed. node5->node13 ns5:P10078 node15 Ackland, Rodney, 1908-1991. Dostoievsky's Crime and punishment. node5->node15 ns5:P10016 node17 English (Text), eng. Contributor(s): McDuff, David, 1945- . node5->node17 ns5:P10078 node5->node21 ns5:P10078 node24 English (Text), eng. Contributor(s): Pevear, Richard, 1943- Volokhonsky, Larissa node5->node24 ns5:P10078 node25 French (Text), fre. Contributor(s): Guertik, Elisabeth tr. node5->node25 ns5:P10078 node26 English (Text), eng. Contributor(s): Garnett, Constance, 1861-1946. node5->node26 ns5:P10078 node37 (Audio), eng. Contributor(s): Sheen, Michael. node5->node37 ns5:P10078 node38 French (Text), fre. node5->node38 ns5:P10078 node41 English (Text), eng. Contributor(s): Monas, Sidney node5->node41 ns5:P10078 node47 German (Text), ger node5->node47 ns5:P10078 node49 English (Text), eng. node5->node49 ns5:P10078 node54 (Text), rus. Contributor(s): Kari︠a︡kin, I︠U︡riĭ Fedorovich. node5->node54 ns5:P10078 node56 Dostoyevsky, Fyodor node5->node56 ns5:P10061 node80 Crime and punishment node5->node80 ns6:P10088 node5->node82 ns5:P10264 node6->node5 ns5:P10142 node6->node7 rdfs:comment node69 (Text), eng. node6->node69 ns5:P10078 node92 Cowley, Joseph node6->node92 ns5:P10061 node8 (Text), eng. node9 1948. London, S. Low, Marston [1948] node8->node9 ns7:P20059 node8->node15 ns7:P20231 node9->node8 ns10:P30139 node73 man084 node9->node73 rdfs:comment node10->node5 ns7:P20231 node11 Dedek, Bernhard node10->node11 ns7:P20048 node63 1924. Berlin, G. Grosser, 1924. node10->node63 ns7:P20059 node12->node5 ns7:P20231 node20 Garnett, Constance node12->node20 ns7:P20037 node12->node26 ns7:P20204 node31 1991. Prince Frederick, MD : Recorded Books, p1991. node12->node31 ns7:P20059 node61 Guidall, George node12->node61 ns7:P20022 node13->node5 ns7:P20231 node14 Neilson, William Allan node13->node14 ns7:P20048 node13->node20 ns7:P20037 node13->node21 ns7:P20141 node27 1917. New York, P. F. Collier & Son [c1917] node13->node27 ns7:P20059 node15->node5 ns5:P10127 node15->node7 rdfs:comment node15->node8 ns5:P10078 node81 Ackland, Rodney node15->node81 ns5:P10061 node16 2003. London ; New York : Penguin, c2003. node16->node17 ns10:P30139 node29 man081 node16->node29 rdfs:comment node94 134443168 node16->node94 ns10:P30083 node17->node5 ns7:P20231 node17->node16 ns7:P20059 node17->node21 ns7:P20141 node74 McDuff, David node17->node74 ns7:P20037 node18 1971. Berlin, Aufbau-Verlag, 1971. node19 man086 node18->node19 rdfs:comment node18->node47 ns10:P30139 node21->node2 ns7:P20171 node21->node5 ns7:P20231 node21->node13 ns7:P20171 node21->node17 ns7:P20171 node21->node24 ns7:P20171 node21->node25 ns7:P20171 node21->node26 ns7:P20171 node39 1905. 1905. node21->node39 ns7:P20059 node21->node41 ns7:P20171 node22 1994. [s.l.] : Naxos AudioBooks Ltd., p1994. node23 man072 node22->node23 rdfs:comment node22->node37 ns10:P30139 node24->node5 ns7:P20231 node24->node21 ns7:P20141 node33 1992. New York : Knopf, 1992. node24->node33 ns7:P20059 node53 Pevear, Richard node24->node53 ns7:P20037 node65 1993. New York : Vintage Books, 1993. node24->node65 ns7:P20059 node67 Volokhonsky, Larissa node24->node67 ns7:P20037 node25->node5 ns7:P20231 node25->node21 ns7:P20141 node60 1968. [Genève, Edito-Service; Evreux] distribué par le Cercle du bibliophile [c1968- node25->node60 ns7:P20059 node71 Guertik, Elisabeth node25->node71 ns7:P20037 node26->node5 ns7:P20231 node26->node12 ns7:P20203 node26->node20 ns7:P20037 node26->node21 ns7:P20141 node50 1927. New York, The Macmillan company, 1927. node26->node50 ns7:P20059 node51 1944. [New York, A. S. Barnes & co., inc., 1944] node26->node51 ns7:P20059 node66 1914. New York, The Macmillan co., [1914] node26->node66 ns7:P20059 node72 1922. New York, The Macmillan company, 1922. node26->node72 ns7:P20059 node27->node13 ns10:P30139 node28 man075 node27->node28 rdfs:comment node31->node12 ns10:P30139 node32 man071 node31->node32 rdfs:comment node33->node24 ns10:P30139 node34 man079 node33->node34 rdfs:comment node35 1886. New York : Thomas Y. Crowell, [1886?] node36 man073 node35->node36 rdfs:comment node35->node49 ns10:P30139 node37->node5 ns7:P20231 node37->node22 ns7:P20059 node88 Sheen, Michael node37->node88 ns7:P20022 node38->node5 ns7:P20231 node44 1967. Paris, Éditions de la Renaissance, 1967. node38->node44 ns7:P20059 node46 1948. [Paris] Gallimard [1948] node38->node46 ns7:P20059 node39->node21 ns10:P30139 node40 man281 node39->node40 rdfs:comment node41->node5 ns7:P20231 node41->node21 ns7:P20141 node58 2006. New York : Signet Classic, c2006. node41->node58 ns7:P20059 node79 Monas, Sidney node41->node79 ns7:P20037 node83 Miller, Robin Feuer node41->node83 ns7:P20048 node86 Stanton, Leonard J. node41->node86 ns7:P20048 node42 1971. 1971. node43 man282 node42->node43 rdfs:comment node42->node54 ns10:P30139 node44->node38 ns10:P30139 node45 man090 node44->node45 rdfs:comment node46->node38 ns10:P30139 node75 man089 node46->node75 rdfs:comment node47->node5 ns7:P20231 node47->node18 ns7:P20059 node48 1966. [Wien] Die Buchgemeinde [1966-] node47->node48 ns7:P20059 node48->node47 ns10:P30139 node68 man087 node48->node68 rdfs:comment node49->node5 ns7:P20231 node49->node35 ns7:P20059 node50->node26 ns10:P30139 node84 man077 node50->node84 rdfs:comment node51->node26 ns10:P30139 node52 man078 node51->node52 rdfs:comment node54->node5 ns7:P20231 node54->node42 ns7:P20059 node55 Kari︠a︡kin, I︠U︡riĭ Fedorovich node54->node55 ns7:P20048 node58->node41 ns10:P30139 node59 man082 node58->node59 rdfs:comment node60->node25 ns10:P30139 node85 man096 node60->node85 rdfs:comment node64 279567941 node61->node64 owl:sameAs node63->node10 ns10:P30139 node93 man088 node63->node93 rdfs:comment node65->node24 ns10:P30139 node70 man080 node65->node70 rdfs:comment node66->node26 ns10:P30139 node89 man074 node66->node89 rdfs:comment node69->node6 ns7:P20231 node87 dbis 1000000355 node69->node87 ns7:P20059 node72->node26 ns10:P30139 node78 man076 node72->node78 rdfs:comment node76->node4 ns7:P20231 node77 dbis 1000000356 node76->node77 ns7:P20059 node82->node0 ns5:P10078 node82->node1 ns5:P10061 node82->node5 ns5:P10257
In [ ]: