Novels

With the information covered by the Bibliographie du Genre Romanesque Français (Martin, Mylne, and Frautschi 1977) within the MiMoText graph, we can not only query which novels were published between 1751 and 1800, but dive much deeper into the novels themselves.

Because we are planning on integrating statements from scholarly publications into MiMoTextBase, it is important to add wdt:P2 (instance of) wd:Q2 (literary work) to the query to retrieve results concerning only the “novels”.

To get an overview of the narrative perspective the novels are written in, you can use the property P33 (narrative form) in combination with COUNT (don’t forget the group by-operation!). By setting the #defaultView to “BarChart”, the results will be displayed as a bar plot.

Query to retrieve the narrative perspective of all novels by count

#title:Narrative perspectives of the novels
prefix mmd:<http://data.mimotext.uni-trier.de/entity/>
prefix mmdt:<http://data.mimotext.uni-trier.de/prop/direct/>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT (count(?narrativePerspectiveLabel) as ?count) ?narrativePerspectiveLabel 
WHERE
{
  ?work mmdt:P33 ?narrativePerspective. # work (novel) has property P33 (narrative perspective)
  ?narrativePerspective rdfs:label ?narrativePerspectiveLabel. # using of rdfs:label to display labels
  
  FILTER(lang(?narrativePerspectiveLabel) = "en") # filter is neccessary to display only one occurence. Other possibilites would be "en" or "de".
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en". }
 
}

group by ?narrativePerspectiveLabel
#defaultView:BarChart

In order to get the narrative perspective of each novel, you can simply replace the COUNT-operation with ?work (to get the link to the respective novel or ?workLabel to display the titles of the novels within the results list (or both if you want). (Please note: the value behind a ? is freely selectable, but it has to stay the same within each query.)

Query to retrieve the narrative perspective of each novel

By simply replacing P33 with P32 you can retrieve the narrative locations of each novel. To get all places referenced in all novels displayed one time, you can add DISTINCT in the selection part to group all multiple occurences.

Query to retrieve the narrative locations in the corpus

Tone

Those interested in the tone of the novels will find an overview of this property per novel here:

View as treemap

Book formats and publishing

Those interested in book history will find data on publishing places of first editions and also distribution formats of first editions (property P26).

Query: In which distribution formats were the novels published?

#title:Distribution formats of publications
#defaultView:BarChart
prefix mmd:<http://data.mimotext.uni-trier.de/entity/>
prefix mmdt:<http://data.mimotext.uni-trier.de/prop/direct/> 
Select  (str(SAMPLE(year(?date))) as ?year) (count(?format) as ?count) ?format 
   WHERE{
   ?item mmdt:P26 ?format.
   ?item mmdt:P9 ?date .
  FILTER(lang(?format) = "fr")
# FILTER(lcase(?format) = "12-in"@fr)
      Filter (regex(lcase(?format), "in-\\d+[\\s\\S]"))
   BIND(str(year(?date)) as ?year)
   SERVICE wikibase:label {bd:serviceParam wikibase:language "{AUTO_LANGUAGE}","fr" .}
  }

GROUP BY ?format ?year ?count

We can observe a diversification of small formats: in-12 and even in-18 and in-24. Smaller book formats enable the reader to read in a clandestine setting, on travels and individually, making their way out of the libraries and reading cabinets (cf. Sacquin n.d.).

drawing

Jean-Jacques Rousseau
Gravure d'Hippolyte Huet d'après un tableau de Joseph Albrier
XVIIIe siècle.
BnF, Musique, fonds estampes, Rousseau J.-J.
© Bibliothèque nationale de France

Previous Next

Where to find…
▼

… MiMoTextBase: data.mimotext.uni-trier.de
… SPARQL-Endpoint: query.mimotext.uni-trier.de
… MiMoText project site: https://mimotext.uni-trier.de

Am I right here or Where do I start?
▼

If you are new to SPARQL, you can go through the (short)Tutorial,which will give you an overview of how to write basic queries based on examples inMiMoTextBase. It’s supposed to give newbies an introduction to SPARQL, but it cannot give you a deep knowledge of SPARQL – maybe theseresourcescan help you with that.

If you are interested in MiMoTextBase and its content onauthors,novels,spacesorthemesof the French novel in 1751-1800 with already some SPARQL knowledge, you can have a look at the links.

WithinGOING FURTHER there are some queries on the data containing overviews of items like dates of publication or themes changing over time and comparing the different sources of the data inMiMoTextBase together with some interpretation on the outcome which could show the potential of initial questions on further research.

If you want more detailed information about the structure and the aims of our tutorial, you can find it in theintroduction of the tutorial.Information on the infrastructure and the models behind MiMoTextBase you can findhere.

I have no results. What can I do?
▼

Having no results in the result table can have different reasons. A simple solution is to check whether the variables are spelled the same in the SELECT and the WHERE part of the query.

Another reason could be being too specific in the query. Not all items in MiMoTextBase contain all information on all properties due to its sources. So it can be helpful to add the OPTIONAL function on some of the properties in your query, seehere.

Error message: Bad aggregate
▼

If you run into this error message, you probably have to group items. In the example below, we use the count function, but forgot to add GROUP BY.

Query to retrieve count of published works per author:

The solution is easy: We have to aggregate ?authorName by grouping. We can now get the results in descending order via order by desc(?count) and set a limit of 20 to get the top 20.

Query to retrieve authors with most novels published (top 20):

I have too many results. What can I do?
▼

Sometimes you can get many results on a query which can slow down the result generation or impair the readability of some visualizations. In those cases you could add the LIMIT-operation (seehere)to only get the TOP x items or the HAVING COUNT-operation (seehere)if you want only results that lie above a certain threshold.

If some of the items appear more often in the results than they should, make sure you filter all labels for one language (FR, EN, DE) separately as the graph is multilingual and the output will represent all languages within the graph, seehere.

How to find the right item / right property?
▼

If you're looking for the right identifier for properties, novels, authors, themes or locations, the simplest way is to visitdata.mimotext.uni-trier.deand type in the label (for example “London” or “about” or “philosophy”) in the search bar. The numerical identifier of the property or the item is visible in the URL or behind the name of the item or the property.

You can also consult our lists of themes, locations and properties and their numerical identifier in the knowledge graph below.

List of properties

Query:Retrieve a list of all the properties used in this graph

List of themes

For a list of all thematic concepts in the graph, see thisquerywhich lists all thematic concepts and their Q-identifier, ordered by occurrence:

List of locations

For a list of all narrative places in the graph, see thisquerywhich lists all narrative places and their Q-Identifier, ordered by occurrence:

These queries list themes or locations ordered by occurrence. We recommend using items or properties which have a certain number of connections in the graph, in order to get good results (with enough data points).

The query is very slow or there is a time out. What can I do?
▼

There are several possible reasons for a slowdown or a timeout of your query. It could be that the quantity of results is very high, so you might limit the results to check if the syntax of the query is OK. This is done by using theLIMITparameter. The LIMIT tells the algorithm where to stop, so if you insert for example LIMIT 100 at the end of your query, it will stop after 100 results. This can be helpful for debugging.

Parameters which potentially slow down the query are DISTINCT or ORDER BY. A strategy might be to comment them out to see if these slow down your query.