FactGrid:Data modeling: Difference between revisions

From FactGrid
Jump to navigation Jump to search
(Add link to Vocabulary data model)
 
(57 intermediate revisions by 4 users not shown)
Line 1: Line 1:
== FactGrid:Vocabularies ==
* [[FactGrid:Vocabularies|Vocabularies]] for vocabularies used in FactGrid
* [[FactGrid:Vocabulary model|Vocabulary model]] for vocabularies stored in FactGrid


== The Problem of on-and off existence ==
== FactGrid data models ==
* [[FactGrid:Freemasonry data model|Freemasonry]]
* [[FactGrid:Data model for manuscripts|Medieval Codices]]
* [[FactGrid:Print publications data model|Print publications]]
* [[FactGrid:Prose fiction data model|Prose fiction]]
* [[FactGrid:Career Statements|Career Statements]]


Gotha's Lodge [[Item:Q10575]] is a typical example: it has a starting point [[Property:P49]] but actually several new starts and more than one end [[Property:P50]]. People found a lodge, the lodge is closed (in the events of the French Revolution), it re-opens in the national wave of the Napoleonic wars, it is closed again in 1935 and re-eopened in 1949 or later or never.
== Sample Items ==
 
* [[Item:Q385847|Address]]
Is it always the same lodge? What do we do with changing names? The German National Library creates loads of items under ever new names - and you have to make sure to get the respective successions. The alternative: If those involved wanted to state that they actually are the same people (even if that is only a fiction of continuity) let them:
* [[Item:Q272575|Book (1719)]]
 
* [[Item:Q418721|Conference]]
The present solution: We have started to use [[Property:P137]] "History" and [[Item:Q94446]] "active phase":
* [[Item:Q436785|Cooking recipe]]
 
* [[Item:Q40154|Duchy]]
See [[Item:Q10575]] Lodge "Ernst zum Compaß", Gotha
* [[Item:Q133|Human (*1731)]] / [[Item:Q18837|Human (*1889)]]
 
* [[Lexeme:L1|Lexeme]]
We can now use qualifiers on each active phase in order to state a respective beginning and a respective end. Is this a good option? How does it work in SPARQL searches if you want to give a time line? How does the option agree with the general P49/P50 use on items?
* [[Item:Q10575|Lodge]]
 
* [[Item:Q393504|Manuscript]]
--Timeline is fine. Try for example  [https://database.factgrid.de/query//#%23defaultView%3ATimeline%0A%23lodges%20in%20Gotha%20between%201760%20and%201830%0ASELECT%20%3Flodge%20%3FlodgeLabel%20%3Fstart%20%3Fend%20%0AWHERE%20%0A%7B%0A%20%20%3Flodge%20wdt%3AP2%20wd%3AQ11211%20.%0A%20%20%3Flodge%20wdt%3AP83%20wd%3AQ10279%20.%0A%20%20%3Flodge%20p%3AP137%20%5B%0A%20%20%20%20%20%20%20%20ps%3AP137%20wd%3AQ94446%3B%0A%20%20%20%20%20%20%20%20pq%3AP49%20%3Fstart%3B%0A%20%20%20%20%20%20%20%20pq%3AP50%20%3Fend%20%20%20%20%20%20%20%5D%0A%20%20%20FILTER%28%3Fstart%20%3C%20%221830-01-01T00%3A00%3A00Z%22%5E%5Exsd%3AdateTime%20%26%26%20%3Fend%20%3E%20%221760-01-01T00%3A00%3A00Z%22%5E%5Exsd%3AdateTime%29%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Gotha's Lodge between 1760 and 1830]. No problem either with the general P49/P50 (you can use OPTIONAL for the history) --[[User:Bruno Belhoste|Bruno Belhoste]] ([[User talk:Bruno Belhoste|talk]]) 18:46, 14 May 2020 (CEST)
* [[Item:Q195108|Political Party]]
 
* [[Item:Q418619|Prize-question]]
::Beautiful. You know how to script these things. (And you should write a blog post one of these days about practical tips - like how to get open refine connected or how to best learn scripting these things... --22:18, 14 May 2020 (CEST)
* [[Item:Q102134|Unit of length]]
:::Just tested it with all the lodges that have these markers. Turns out that the search does not get the continuities. I added labels to show that.
* [[Item:Q451049|War]]
:::* [https://database.factgrid.de/query//#%23defaultView%3ATimeline%0A%23lodges%20in%20Gotha%20between%201760%20and%201830%0ASELECT%20%3Flodge%20%3FlodgeLabel%20%3Fstart%20%3Fend%20WHERE%20%7B%0A%20%20%3Flodge%20wdt%3AP2%20wd%3AQ11211%3B%0A%20%20%20%20p%3AP137%20_%3Ab1.%0A%20%20_%3Ab1%20ps%3AP137%20wd%3AQ94446%3B%0A%20%20%20%20pq%3AP49%20%3Fstart%3B%0A%20%20%20%20pq%3AP50%20%3Fend.%0A%20%20FILTER%28%28%3Fstart%20%3C%20%221830-01-01T00%3A00%3A00Z%22%5E%5Exsd%3AdateTime%29%20%26%26%20%28%3Fend%20%3E%20%221760-01-01T00%3A00%3A00Z%22%5E%5Exsd%3AdateTime%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D all lodges histories]
:::The visualisation packs the histories without understanding the continuities. --[[User:Olaf Simons|Olaf Simons]] ([[User talk:Olaf Simons|talk]]) 07:24, 15 May 2020 (CEST)
 
== Changing names ==
 
An organisation can run through dozens of name changes over the years - e.g. an Early Modern Publishing house with name changes whenever a father hands down the business to son, wife, son in law etc.
 
We are presently using [[Property:P57]] for a history of naming but that is not ideal since usual searches will not get to the the right names at the right moment.
 
== Stemmata ==
[[File:Howald-sigerist.png|thumb|Ernst Howald and Henry E. Sigerist. Antonii Musa De herba vettonica ... Leipzig 1927]] We created two properties for this: [[Property:P233]] names the object - a book edition, a manuscript or any other thing that is genetically earlier. [[Property:P234]] comes as the qualifier and offers a statement on what basis the object can be seen as a following. You might for instance link a translation to the edition that gave the original text.
 
The organisation is top down chronological (the guide lines in the picture above are not that beautiful, but dates on y-axis would be cool).
 
Objects can have multiple connections to earlier Items (a medieval scribe could use two books to create a new version of the text).
 
It would be cool if the P234 information became available on the lines that are connecting items.
 
One of the problems is here also: How do I select a family of items?
 
== The situation at a particular point in time ==
Think of a house: Tenants are moving in and out - we can model that with [[Property:P239]] "resident" and P49/50 qualifiers. You are now interested in the situation at a point in history: Who were the tenants on March 3, 1848?
 
If we can get this done for a house like [[Item:Q14572]] we might be able to show a city at a point in time.
 
== Organisational ties ==
Originally we thought we should use The Wikibase advantage of being able to create any imaginable statement to do just that. A lodge has a "Mother lodge", so do create a link to that (with the daughter lodge respective property). It can chose an umbrella organisation, it will accept an obedience (adhering a system) etc.
 
The problem of these specific properties
 
* is that a neighbouring organisation might have its own nomenclature for pretty much the same dependencies - or that it can have the same terms, but mean something different with them.
* that you need to know the specific terminology in order to run a query
 
The general solution could be a standard option like "organisational ties" and use that property to specify them with the quakifiers for the specific tie.
 
A more specific solution can lie in between these poles: We create a pattern of general types of these ties, so that we can then ask broad questions in order to see different networks.
 
# is owned by / owns
# parent organisation / subsidiaries
# received the patent from / granted patents to
# represented by / representing
# member of / members
# partner organisations
# organisationally supported by / supporting with organisational help
# financed by / finances
# recognised by / recognises
# next hierarchical level level above / next hierarchical level underneath
 
One would now use qualifiers to give the exact terminologies. Which of these are redundant? which of the are missing? #
 
Is there a better option?

Latest revision as of 12:17, 30 January 2024

FactGrid:Vocabularies

FactGrid data models

Sample Items

Retrieved from "https://database.factgrid.de/w/index.php?title=FactGrid:Data_modeling&oldid=7697681"