{"id":1858,"date":"2017-02-14T18:00:29","date_gmt":"2017-02-14T18:00:29","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?p=1858"},"modified":"2017-05-08T00:06:08","modified_gmt":"2017-05-08T00:06:08","slug":"february-14-2017","status":"publish","type":"post","link":"https:\/\/www.mollieecheverria.com\/?p=1858","title":{"rendered":"February 14, 2017"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>4 Minute, 3 Second <\/div>\n\n <\/div>

CIDOC Namespaces<\/h3>\n

Fortunately, CIDOC seems to have finally added back pages for its individual entity classes and properties:<\/p>\n

http:\/\/www.cidoc-crm.org\/Version\/version-6.2<\/a><\/p>\n

Unfortunately, I don\u2019t know if these pages can be considered persistent URIs, since each entity and property page is bookended by \u201c\/version-6.2\u201d, and pages will not redirect without it:<\/p>\n

http:\/\/www.cidoc-crm.org\/Entity\/e2-temporal-entity\/version-6.2<\/a><\/p>\n

http:\/\/www.cidoc-crm.org\/Property\/p118-overlaps-in-time-with\/version-6.2<\/a><\/p>\n

Still, it is helpful at least in the conceptual mapping of the Whitney\u2019s data to be able to quickly view the properties that can be applied to each entity class, and to view subclasses and superclasses of entities, without having to manually scroll through a huge PDF.<\/p>\n

Separating Entities<\/h3>\n

I finally finished separating data for each CIDOC Entity class with a many-to-many relationship with another into its own table\/Google Sheet. I went pretty granular, ending up with 14 different sheets:<\/p>\n

E8 Acquisition<\/h4>\n

Used for non-purchase acquisition events.<\/p>\n

E12 Production<\/h4>\n

Used to represent the creation of an artwork.<\/p>\n

E22 Man-Made Object <\/h4>\n

(this could be problematic if used outside the context of the Founding Collection for newer items that don\u2019t have a physical component)<\/p>\n

Used to represent art objects in the Whitney\u2019s collection.<\/p>\n

E39 Actor<\/h4>\n

Used to represent the unique Whitney identifier for any kind of Constituent (Object, Acquisitions, and Ex-Collections-related).<\/p>\n

E42 Identifier<\/h4>\n

Used to record non-Whitney unique identifiers for Constituents and the name authority domains to which they belong (currently LC, VIAF, ULAN, Wikidata; potentially the Smithsonian American Art Museum in the future).<\/p>\n

E51 Contact Point<\/h4>\n

Used to record external URIs for Constituents on name authority sites.<\/p>\n

E53 Place<\/h4>\n

Used to record the names and GeoNames IDs for the birth and death locations of artists. Could also be used for any other place identifiers like object locations.<\/p>\n

E54 Dimension<\/h4>\n

Used to record dimensions of objects. Objects may have more than one listed dimension in TMS (framed vs. unframed, inches vs. cm), hence the need for a separate table.<\/p>\n

E55 Type<\/h4>\n

Used to record role type (artist, donor, art dealer, etc) of an Actor in a given event. Vocabulary for these roles is from the Getty AAT.<\/p>\n

E57 Material<\/h4>\n

Used to record the material components of art objects.<\/p>\n

E67 Birth<\/h4>\n

Used to record Constituent birth dates and locations.<\/p>\n

E69 Death<\/h4>\n

Used to record Constituent death dates and locations. Also includes links to the NYTimes Obituaries Joshua found.<\/p>\n

E82 Actor Appellation <\/h4>\n

(deprecated in the latest version of CIDOC still in development [Version 6.2.2] in favor of the broader E41 Appellation<\/strong>)<\/p>\n

Records the Display Names of Constituents along with any alternative forms.<\/p>\n

E96 Purchase <\/h4>\n

(a new Event class being added in CIDOC Version 6.2.2)<\/p>\n

Used to record information about the purchase of objects.<\/p>\n

I could definitely simplify this conceptual model at a later point, but I figure that since the main audience for this data would be art historical researchers, maybe more specificity would be beneficial.<\/p>\n

Neo4j<\/h3>\n

Neo4j apparently allows you to import CSV files directly and make table joins with their SQL-like query language called Cypher:<\/p>\n

https:\/\/neo4j.com\/developer\/guide-importing-data-and-etl\/<\/a><\/p>\n

Given that, I may just import my CSV data directly into Neo4j after cleaning it in OpenRefine rather than bothering to make a MySQL database first. Starting with an ER diagram may be helpful, however.<\/p>\n

Neo4j is also designed as more of a \u201cbig data\u201d database.<\/p>\n

CouchDB<\/h3>\n

CouchDB<\/a> is another popular NoSQL system I see mentioned a lot.<\/p>\n

CouchDB doesn\u2019t support SPARQL either, however, instead relying on a JSON-based query language<\/p>\n

Blazegraph<\/h3>\n

The Metaphacts<\/a>\u00a0database used by the Florentine Renaissance Drawings project is built on top of a Blazegraph<\/a>\u00a0database.<\/p>\n

Blazegraph is available as an open-source download. It also supports SPAQRL queries.<\/p>\n

It does seem somewhat harder to set up than something like Neo4j, however.<\/p>\n

Update: I installed Blazegraph easily, and it has a straighforward local interface. However, I\u2019m not really sure what the applicability of it is, if any.<\/p>\n

\"\"<\/a><\/p>\n

OrientDB<\/h3>\n

At first glance, OrientDB seems like it might have an easier to use interface. I will download it and give it a shot.<\/p>\n

http:\/\/orientdb.com\/download\/<\/a><\/p>\n

OrientDB took some time to install. You have to install a server and console client locally to use it:<\/p>\n

http:\/\/orientdb.com\/docs\/last\/<\/a><\/p>\n

At first glance, OrientDB seems more familiar and usable than previous graph databases I\u2019ve looked at.<\/p>\n

You can define Classes, for example (http:\/\/orientdb.com\/docs\/last\/<\/a>)<\/p>\n

\"\"<\/a><\/p>\n

I\u2019m not really sure if and how OrientDB supports linked data, however, which is obviously an issue<\/p>\n

DB Selection – Options<\/h3>\n

The number of database options is kind of overwhelming, quite frankly.<\/p>\n

This is a helpful overview:<\/p>\n

http:\/\/db-engines.com\/en\/ranking\/rdf+store<\/a><\/p>\n

\n
\n \n
\n \n \"Happy\"\n <\/a>\n
\n Happy <\/div>\n
\n 0<\/span>\n \n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Sad\"\n <\/a>\n
\n Sad <\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Excited\"\n <\/a>\n
\n Excited <\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Sleepy\"\n <\/a>\n
\n Sleepy <\/div>\n
\n 0<\/span>\n \n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n
\n \n \"Angry\"\n <\/a>\n
Angry<\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n \n <\/div>\n <\/div>\n\n
\n \n \"Surprise\"\n <\/a>\n
Surprise<\/div>\n
\n 0<\/span>\n 0<\/span> %<\/span>\n <\/div>\n <\/div>\n\n <\/div>\n <\/div>\n\n ","protected":false},"excerpt":{"rendered":"

CIDOC Namespaces Fortunately, CIDOC seems to have finally added back pages for its individual entity classes and properties: http:\/\/www.cidoc-crm.org\/Version\/version-6.2 Unfortunately, I don\u2019t know if these pages can be considered persistent URIs, since each entity and property page is bookended by \u201c\/version-6.2\u201d, and pages will not redirect without it: http:\/\/www.cidoc-crm.org\/Entity\/e2-temporal-entity\/version-6.2 http:\/\/www.cidoc-crm.org\/Property\/p118-overlaps-in-time-with\/version-6.2 Still, it is helpful at […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1858","post","type-post","status-publish","format-standard","hentry","category-whitney-journal"],"yoast_head":"\nMollie Echeverr\u00eda<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mollieecheverria.com\/?p=1858\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"amanda\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858\"},\"author\":{\"name\":\"amanda\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"headline\":\"February 14, 2017\",\"datePublished\":\"2017-02-14T18:00:29+00:00\",\"dateModified\":\"2017-05-08T00:06:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858\"},\"wordCount\":783,\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image07-785x375.png\",\"articleSection\":[\"Whitney Linked Open Data Fellowship Journal\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858\",\"name\":\"Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image07-785x375.png\",\"datePublished\":\"2017-02-14T18:00:29+00:00\",\"dateModified\":\"2017-05-08T00:06:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1858#primaryimage\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image07.png\",\"contentUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image07.png\",\"width\":1999,\"height\":955},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/\",\"name\":\"Mollie Echeverr\u00eda\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\",\"name\":\"amanda\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g\",\"caption\":\"amanda\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/mollie.echeverria\",\"https:\\\/\\\/www.instagram.com\\\/mollie_echeverria\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/mollieecheverria\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mollie Echeverr\u00eda","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mollieecheverria.com\/?p=1858","twitter_misc":{"Written by":"amanda","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mollieecheverria.com\/?p=1858#article","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1858"},"author":{"name":"amanda","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"headline":"February 14, 2017","datePublished":"2017-02-14T18:00:29+00:00","dateModified":"2017-05-08T00:06:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1858"},"wordCount":783,"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1858#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image07-785x375.png","articleSection":["Whitney Linked Open Data Fellowship Journal"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?p=1858","url":"https:\/\/www.mollieecheverria.com\/?p=1858","name":"Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1858#primaryimage"},"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1858#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image07-785x375.png","datePublished":"2017-02-14T18:00:29+00:00","dateModified":"2017-05-08T00:06:08+00:00","author":{"@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?p=1858"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mollieecheverria.com\/?p=1858#primaryimage","url":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image07.png","contentUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image07.png","width":1999,"height":955},{"@type":"WebSite","@id":"https:\/\/www.mollieecheverria.com\/#website","url":"https:\/\/www.mollieecheverria.com\/","name":"Mollie Echeverr\u00eda","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mollieecheverria.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084","name":"amanda","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/933d63347db0a4d6741d3684945d79bd61634cc6a5094794faf3a30fe7f432df?s=96&d=mm&r=g","caption":"amanda"},"sameAs":["https:\/\/www.facebook.com\/mollie.echeverria","https:\/\/www.instagram.com\/mollie_echeverria\/","https:\/\/www.linkedin.com\/in\/mollieecheverria\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1858","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1858"}],"version-history":[{"count":8,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1858\/revisions"}],"predecessor-version":[{"id":2192,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1858\/revisions\/2192"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}