{"id":1765,"date":"2016-09-30T18:00:19","date_gmt":"2016-09-30T18:00:19","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?p=1765"},"modified":"2017-05-07T19:11:15","modified_gmt":"2017-05-07T19:11:15","slug":"september-30-2016","status":"publish","type":"post","link":"https:\/\/www.mollieecheverria.com\/?p=1765","title":{"rendered":"September 30, 2016"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>2 Minute, 56 Second <\/div>\n\n <\/div>

I\u2019m kind of curious how the tables that make up the backend of the TMS database are organized. I\u2019m taking Database Design this semester, and am eventually going to start working with MySQL in more depth. I\u2019m wondering whether it be worthwhile to make a MySQL database that could store provenance information in a more normalized form than TMS. I know Joshua already made a MySQL database for outputting URIs, so maybe I could augment his database with Provenance info.<\/p>\n

\u00a0I downloaded and looked at Joshua\u2019s various object and artist csv files, as well as his \u201clod_test.sql\u201d file. I\u2019m not that familiar with SQL at this point, but I can kind of see how his MySQL database is set up with an Objects and People table. At this point the two tables aren\u2019t connected to one another. It seems like it would make sense to have URIs created from the Objects table relate to URIs created by the People table at some point, however. Object resource URIs from the British Museum\u2019s collection, for example, contain links to Person\/Institution URIs relating to the object, such as \u201chas former or current owner\u201d. I\u2019m not sure how to do this from a technical standpoint yet, however. To indicate something like provenance, it seems like it would make sense to try to enter Acquisition-related constitutions into the current People table, or to create separate Object Related and Acquisition-related Constituent tables, and to somehow connect the Object and People tables when outputting PHP files. I guess just putting Acquisition-related constituents into a tabular format would be a start. Additionally, since Acquisition-related constituents may be institutions like galleries, maybe it would make sense to create an Institutions table, or change People to Person-Institution?<\/p>\n

I read about D2RQ (http:\/\/d2rq.org\/<\/a>), a tool for converting data from relational databases into an RDF format, and allowing it to be accessed through SPARQL queries. It seems like something beyond my current technical abilities to use, but I wonder whether it could eventually be used to convert a database built up from Joshua\u2019s current one into more interconnected URIs. Additionally, if the Whitney eventually hosts Joshua\u2019s URIs online, this would maybe assist with providing a SPARQL endpoint to query them.<\/p>\n

Using MySQL, maybe I\u2019ll try to create an ER diagram of how the Objects and People tables could be connected, using the British Museum collection as a model. My initial thought would be to create tables representing the predicates in RDF triples. Not sure if it would be possible to convert data from this kind of relational model into linked data, however. Linked data is meant to overcome the hurdles of storing data in relational databases, so maybe using mySQL for this kind of data \u00a0is counterintuitive? Using MySQL as a triple store is apparently not unheard of, however (http:\/\/rdfextras.readthedocs.io\/en\/latest\/store\/mysqlpg.html<\/a>). \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

Alternately, maybe NoSQL makes more sense as a database system for the project, since it is more commonly used for triple stores. The British Museum seems to use GraphDB to store their triples, which is available as a free download (http:\/\/ontotext.com\/products\/graphdb\/<\/a>). GraphDB can import data stored as .ttl, .rdf, .rj, .n3, .nt, .nq, .trig, .brf, and .owl files. Maybe it would make more sense to apply a script to the Person and Object csv files to generate triples in a format that can be fed into GraphDB?<\/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":"

I\u2019m kind of curious how the tables that make up the backend of the TMS database are organized. I\u2019m taking Database Design this semester, and am eventually going to start working with MySQL in more depth. I\u2019m wondering whether it be worthwhile to make a MySQL database that could store provenance information in a more […]<\/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-1765","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=1765\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1765#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1765\"},\"author\":{\"name\":\"amanda\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"headline\":\"September 30, 2016\",\"datePublished\":\"2016-09-30T18:00:19+00:00\",\"dateModified\":\"2017-05-07T19:11:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1765\"},\"wordCount\":586,\"articleSection\":[\"Whitney Linked Open Data Fellowship Journal\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1765\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1765\",\"name\":\"Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"datePublished\":\"2016-09-30T18:00:19+00:00\",\"dateModified\":\"2017-05-07T19:11:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1765\"]}]},{\"@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=1765","twitter_misc":{"Written by":"amanda","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mollieecheverria.com\/?p=1765#article","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1765"},"author":{"name":"amanda","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"headline":"September 30, 2016","datePublished":"2016-09-30T18:00:19+00:00","dateModified":"2017-05-07T19:11:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1765"},"wordCount":586,"articleSection":["Whitney Linked Open Data Fellowship Journal"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?p=1765","url":"https:\/\/www.mollieecheverria.com\/?p=1765","name":"Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"datePublished":"2016-09-30T18:00:19+00:00","dateModified":"2017-05-07T19:11:15+00:00","author":{"@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?p=1765"]}]},{"@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\/1765","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=1765"}],"version-history":[{"count":2,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1765\/revisions"}],"predecessor-version":[{"id":2159,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1765\/revisions\/2159"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}