{"id":1810,"date":"2016-11-18T18:00:28","date_gmt":"2016-11-18T18:00:28","guid":{"rendered":"http:\/\/www.mollieecheverria.com\/?p=1810"},"modified":"2017-05-07T21:05:14","modified_gmt":"2017-05-07T21:05:14","slug":"november-18-2016","status":"publish","type":"post","link":"https:\/\/www.mollieecheverria.com\/?p=1810","title":{"rendered":"November 18, 2016"},"content":{"rendered":"<div class='booster-block booster-read-block'>\n                <div class=\"twp-read-time\">\n                \t<i class=\"booster-icon twp-clock\"><\/i> <span>Read Time:<\/span>3 Minute, 22 Second                <\/div>\n\n            <\/div><h3>Linked Data in a Relational Database<\/h3>\n<p>Prof. Miller gave my Program for Cultural Heritage class read-only access to the NYPL\u2019s archives database. Looking at the way this data is structured, particularly access terms for constituents, is helpful in thinking about tabular structure for the Whitney\u2019s linked data.<\/p>\n<p>There are three tables in the NYPL Archives schema, `collections`, `access_terms`, and `access_term_associations`<\/p>\n<p>The `access_term_associations` table is used to link the individual archival collections, store in the `collections` tables, to names of constituents, which are stored in the `access_terms` table:<\/p>\n<p>\u00a0 \u00a0 \u00a0 \u00a0\u00a0<a class=\"swipebox\" href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1811 size-large\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36-785x517.png\" alt=\"\" width=\"785\" height=\"517\" srcset=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36-785x517.png 785w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36-300x198.png 300w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36-768x506.png 768w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36.png 899w\" sizes=\"auto, (max-width: 785px) 100vw, 785px\" \/><\/a><\/p>\n<p>This structure allows the NYPL to generate some interesting interactive interfaces: <a href=\"http:\/\/archives.nypl.org\/tools\">http:\/\/archives.nypl.org\/tools<\/a><\/p>\n<p><a class=\"swipebox\" href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image28.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1812 size-full\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image28.png\" alt=\"\" width=\"634\" height=\"818\" srcset=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image28.png 634w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image28-233x300.png 233w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/a><a class=\"swipebox\" href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1813\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image17.png\" alt=\"\" width=\"626\" height=\"702\" srcset=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image17.png 626w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image17-268x300.png 268w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><\/a><a class=\"swipebox\" href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image00.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1814\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image00.png\" alt=\"\" width=\"713\" height=\"660\" srcset=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image00.png 713w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image00-300x278.png 300w\" sizes=\"auto, (max-width: 713px) 100vw, 713px\" \/><\/a><a class=\"swipebox\" href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1815\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image25.png\" alt=\"\" width=\"763\" height=\"631\" srcset=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image25.png 763w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image25-300x248.png 300w\" sizes=\"auto, (max-width: 763px) 100vw, 763px\" \/><\/a><\/p>\n<p>An archival collection from this database represented in JSON:<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;id&#8221; : 1,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;title&#8221; : &#8220;Thomas Addis Emmet collection&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;origination&#8221; : &#8220;Emmet, Thomas Addis,\\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a01828-1919&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;org_unit_id&#8221; : 1,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;date_statement&#8221; : &#8220;1483-1876 [bulk 1700-1800]&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;extent_statement&#8221; : &#8220;30.83 linear feet; 108 boxes, 21 volumes&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;linear_feet&#8221; : 30.83,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;keydate&#8221; : 1483,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;identifier_value&#8221; : &#8220;927&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;identifier_type&#8221; : &#8220;local_mss&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;bnumber&#8221; : null,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;call_number&#8221; : &#8220;MssCol 927&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;pdf_finding_aid&#8221; : &#8220;&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;max_depth&#8221; : 3,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;series_count&#8221; : 28,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;active&#8221; : 1,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;created_at&#8221; : &#8220;2013-01-08 20:52:54&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;updated_at&#8221; : &#8220;2015-11-05 03:03:37&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;boost_queries&#8221; : &#8220;[\\&#8221;emmet\\&#8221;]&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;date_processed&#8221; : null,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;component_layout_id&#8221; : 2,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;has_digital&#8221; : 1,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;featured_seq&#8221; : null,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;fully_digitized&#8221; : 1,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;show_generated_pdf&#8221; : 0,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;status_note&#8221; : null<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},<\/p>\n<p>These archival materials don\u2019t have URIs associated with them directly, presumably since they are organized at collection level.<\/p>\n<p>A constituent or concept related to this collection, including a link to a name authority record:<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;id&#8221; : 3004,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;term_original&#8221; : &#8220;Legislators&#8211;United States&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;term_authorized&#8221; : null,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;term_type&#8221; : &#8220;topic&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;authority&#8221; : &#8220;lcsh&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;authority_record_id&#8221; : null,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;value_uri&#8221; : &#8220;http:\/\/id.loc.gov\/authorities\/subjects\/sh85075851&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;control_source&#8221; : null,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;created_at&#8221; : &#8220;2013-01-08 21:01:45&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;updated_at&#8221; : &#8220;2013-01-08 21:01:45&#8221;<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},<\/p>\n<p>The access terms association that shows the relationship between the collection and concepts\/people related to it.<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;id&#8221; : 7246,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;describable_id&#8221; : 1,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;describable_type&#8221; : &#8220;Collection&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;access_term_id&#8221; : 3004,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;role&#8221; : null,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;controlaccess&#8221; : 1,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;name_subject&#8221; : 0,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;created_at&#8221; : &#8220;2013-01-08 21:01:45&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;updated_at&#8221; : &#8220;2013-01-08 21:01:45&#8221;,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;function&#8221; : null,<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8220;questionable&#8221; : 0<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0},<\/p>\n<p>\u00a0Because there may be many terms associated with each collection, and since any given term may apply to multiple collections, the access terms association table exists to represent this many-to-many relationship.<\/p>\n<p>For the Whitney\u2019s data, event table(s) could serve a similar role as the access terms association table for the NYPL, connecting constituents and objects as well as places and thesaurus terms.<\/p>\n<p>While non-relational databases are the standard for storing linked data, at the same time, since linked data is all about relationships, it would seem reasonable that it could be used to represent linked data relationships as well. There is still the issue of hosting, however, which is presumably where the use of a triple store would be needed.<\/p>\n<p>This site (<a href=\"https:\/\/sites.tufts.edu\/liam\/\">https:\/\/sites.tufts.edu\/liam\/<\/a>) gives a great overview of some methodologies of implementing linked data in archival settings, and also argues in favor of using a relational database as the basis for generating triples.<\/p>\n<p>The article mentions <a href=\"http:\/\/d2rq.org\/\">D2RQ<\/a>, a tool for hosting relational data I explored briefly and unsuccessfully tried to install earlier in the semester. I\u2019m not sure if I would have the technical ability to install it, but if IT at the Whitney could implement it like they did Joshua\u2019s PHP server, I could develop a MySQL database and host it on this server, solving the triple store issue and having a SPARQL endpoint available as well.<\/p>\n<p><a class=\"swipebox\" href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image09.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1816\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image09.png\" alt=\"\" width=\"384\" height=\"311\" srcset=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image09.png 384w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image09-300x243.png 300w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><\/a><\/p>\n<p>The article also mentions a project called <a href=\"http:\/\/labs.regesta.com\/progettoReload\/en\/\">ReLoad<\/a>, which seems to involve URIs and a SPARQL endpoint generated by\/stored in xDAMS. The URI links for this project seem to be dead, however, and I\u2019m somewhat unclear about how everything within the project is structured.<\/p>\n<h3>Experimenting with Databases<\/h3>\n<p>I ended up creating a test MySQL database to input. I uploaded a SQL file for this database to GitHub.<\/p>\n<p><a class=\"swipebox\" href=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image30.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1817\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image30-769x1024.png\" alt=\"\" width=\"769\" height=\"1024\" srcset=\"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image30-769x1024.png 769w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image30-225x300.png 225w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image30-768x1022.png 768w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image30-800x1065.png 800w, https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image30.png 984w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><\/a><\/p>\n        <div class=\"booster-block booster-reactions-block\">\n            <div class=\"twp-reactions-icons\">\n                \n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-1\" post-id=\"1810\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/happy.svg\" alt=\"Happy\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Happy                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                        \n                                                <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-2\" post-id=\"1810\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/sad.svg\" alt=\"Sad\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Sad                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-3\" post-id=\"1810\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/excited.svg\" alt=\"Excited\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Excited                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-6\" post-id=\"1810\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/sleepy.svg\" alt=\"Sleepy\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">\n                        Sleepy                    <\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                        \n                                                <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-4\" post-id=\"1810\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/angry.svg\" alt=\"Angry\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">Angry<\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                        \n                    <\/div>\n                <\/div>\n\n                <div class=\"twp-reacts-wrap\">\n                    <a react-data=\"be-react-5\" post-id=\"1810\" class=\"be-face-icons un-reacted\" href=\"javascript:void(0)\">\n                        <img decoding=\"async\" src=\"https:\/\/www.mollieecheverria.com\/wp-content\/plugins\/booster-extension\/\/assets\/icon\/surprise.svg\" alt=\"Surprise\">\n                    <\/a>\n                    <div class=\"twp-reaction-title\">Surprise<\/div>\n                    <div class=\"twp-count-percent\">\n                                                    <span style=\"display: none;\" class=\"twp-react-count\">0<\/span>\n                                                                        <span class=\"twp-react-percent\"><span>0<\/span> %<\/span>\n                                            <\/div>\n                <\/div>\n\n            <\/div>\n        <\/div>\n\n    ","protected":false},"excerpt":{"rendered":"<p>Linked Data in a Relational Database Prof. Miller gave my Program for Cultural Heritage class read-only access to the NYPL\u2019s archives database. Looking at the way this data is structured, particularly access terms for constituents, is helpful in thinking about tabular structure for the Whitney\u2019s linked data. There are three tables in the NYPL Archives [&hellip;]<\/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-1810","post","type-post","status-publish","format-standard","hentry","category-whitney-journal"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Mollie 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=1810\" \/>\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=1810#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1810\"},\"author\":{\"name\":\"amanda\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"headline\":\"November 18, 2016\",\"datePublished\":\"2016-11-18T18:00:28+00:00\",\"dateModified\":\"2017-05-07T21:05:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1810\"},\"wordCount\":619,\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1810#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image36-785x517.png\",\"articleSection\":[\"Whitney Linked Open Data Fellowship Journal\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1810\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1810\",\"name\":\"Mollie Echeverr\u00eda\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1810#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1810#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image36-785x517.png\",\"datePublished\":\"2016-11-18T18:00:28+00:00\",\"dateModified\":\"2017-05-07T21:05:14+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/#\\\/schema\\\/person\\\/12cc1a68de4ed401b88418f813f45084\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1810\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mollieecheverria.com\\\/?p=1810#primaryimage\",\"url\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image36.png\",\"contentUrl\":\"https:\\\/\\\/www.mollieecheverria.com\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/image36.png\",\"width\":899,\"height\":592},{\"@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=1810","twitter_misc":{"Written by":"amanda","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mollieecheverria.com\/?p=1810#article","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1810"},"author":{"name":"amanda","@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"headline":"November 18, 2016","datePublished":"2016-11-18T18:00:28+00:00","dateModified":"2017-05-07T21:05:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1810"},"wordCount":619,"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1810#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36-785x517.png","articleSection":["Whitney Linked Open Data Fellowship Journal"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mollieecheverria.com\/?p=1810","url":"https:\/\/www.mollieecheverria.com\/?p=1810","name":"Mollie Echeverr\u00eda","isPartOf":{"@id":"https:\/\/www.mollieecheverria.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1810#primaryimage"},"image":{"@id":"https:\/\/www.mollieecheverria.com\/?p=1810#primaryimage"},"thumbnailUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36-785x517.png","datePublished":"2016-11-18T18:00:28+00:00","dateModified":"2017-05-07T21:05:14+00:00","author":{"@id":"https:\/\/www.mollieecheverria.com\/#\/schema\/person\/12cc1a68de4ed401b88418f813f45084"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mollieecheverria.com\/?p=1810"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mollieecheverria.com\/?p=1810#primaryimage","url":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36.png","contentUrl":"https:\/\/www.mollieecheverria.com\/wp-content\/uploads\/2017\/04\/image36.png","width":899,"height":592},{"@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\/1810","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=1810"}],"version-history":[{"count":2,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1810\/revisions"}],"predecessor-version":[{"id":2171,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=\/wp\/v2\/posts\/1810\/revisions\/2171"}],"wp:attachment":[{"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mollieecheverria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}