{"id":3577,"date":"2019-07-09T20:49:05","date_gmt":"2019-07-09T20:49:05","guid":{"rendered":"https:\/\/notebooks.dataone.org\/?p=3577"},"modified":"2019-07-09T20:49:33","modified_gmt":"2019-07-09T20:49:33","slug":"week-7-sql-database-creation","status":"publish","type":"post","link":"https:\/\/notebooks.dataone.org\/prov-self\/week-7-sql-database-creation\/","title":{"rendered":"Week 7 SQL Database creation"},"content":{"rendered":"\n<p>Happy 4th of July, everyone <\/p>\n\n\n\n<p>Main tasks for me in this week is to build an SQLite for future analysis, dive deeper and try to figure out how Galaxy Group collect information and added tags, additionally, continue reading the papers related to \u201cprovenance\u201d, \u201creproducibility\u201d and \u201cworkflow\u201d in the corpus. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Where are these tags come from?<\/strong> <\/h3>\n\n\n\n<p>To ensure the&nbsp;reproducibility and also the&nbsp;legality to analyze these papers, we email the group member of the Galaxy Project. Hope we can get the answer soon. <br>As for the tags automatically generated by Zotero, some interesting points have been found. By comparing the information of one paper in Galaxy Collection and personal Zotero Group, the big difference except who added this paper existed in library catalog and tags. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"942\" height=\"871\" src=\"https:\/\/notebooks.dataone.org\/wp-content\/uploads\/2019\/07\/image-3.png\" alt=\"\" class=\"wp-image-3581\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"925\" height=\"905\" src=\"https:\/\/notebooks.dataone.org\/wp-content\/uploads\/2019\/07\/image-4.png\" alt=\"\" class=\"wp-image-3582\" \/><\/figure>\n\n\n\n<p>Furthermore, by going to the website where this paper published,&nbsp;we confirmed that automatically generated tags come from the keywords provided by the publisher. One thing attracts our attention is that these tags lost their provenance, which could be our further research topic. For example, the tags come from&nbsp;IEEE Xplore actually should be divided into four categories including&nbsp;IEEE Keywords,&nbsp;INSPEC: Controlled Indexing,&nbsp;INSPEC: Non-Controlled Indexing, &nbsp;and Author Keywords.&nbsp; <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>SQLite for&nbsp;Galaxy Zotero Corpus<\/strong><\/h3>\n\n\n\n<p>SQL is always a good language to analyze data and ER-diagram could present the data much clearer. Through several transformations, the final database comes out. <br>Database V1.0 contains three tables named paper_table, link_table, tag_table. For paper_table, it contains six attributes including paper_id, title, author, year, abstract and publication. paper_id is the primary key. In tag_table, three attributes are included tag_id, tag_name, and tag_type. To connect these two tables, link_table is created which contains paper_id and tag_id.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1013\" height=\"543\" src=\"https:\/\/notebooks.dataone.org\/wp-content\/uploads\/2019\/07\/image.png\" alt=\"\" class=\"wp-image-3579\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Paper reading<\/strong><\/h3>\n\n\n\n<p>The number of papers under these chosen tags(&#8216;+Methods&#8217;, &#8216;Reproducibility&#8217;)is:5 <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"995\" height=\"350\" src=\"https:\/\/notebooks.dataone.org\/wp-content\/uploads\/2019\/07\/image-1.png\" alt=\"\" class=\"wp-image-3578\" \/><\/figure>\n\n\n\n<p>The number of papers under these chosen tags(&#8216;Reproducibility&#8217;, &#8216;Workflow&#8217;)is:7\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1017\" height=\"506\" src=\"https:\/\/notebooks.dataone.org\/wp-content\/uploads\/2019\/07\/image-2.png\" alt=\"\" class=\"wp-image-3580\" \/><\/figure>\n\n\n\n<p>Reading &nbsp;for these 12 papers will be finished next week.&nbsp;\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Happy 4th of July, everyone Main tasks for me in this week is to build an SQLite for future analysis, dive deeper and try to figure out how Galaxy Group collect information and added tags, additionally, continue reading the papers related to \u201cprovenance\u201d, \u201creproducibility\u201d and \u201cworkflow\u201d in the corpus. Where <a class=\"more-link\" href=\"https:\/\/notebooks.dataone.org\/prov-self\/week-7-sql-database-creation\/\">Continue reading <span class=\"screen-reader-text\">  Week 7 SQL Database creation<\/span><span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":124,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[391],"tags":[],"_links":{"self":[{"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/posts\/3577"}],"collection":[{"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/users\/124"}],"replies":[{"embeddable":true,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/comments?post=3577"}],"version-history":[{"count":2,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/posts\/3577\/revisions"}],"predecessor-version":[{"id":3584,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/posts\/3577\/revisions\/3584"}],"wp:attachment":[{"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/media?parent=3577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/categories?post=3577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/notebooks.dataone.org\/wp-json\/wp\/v2\/tags?post=3577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}