{"id":395,"date":"2016-10-28T10:49:02","date_gmt":"2016-10-28T14:49:02","guid":{"rendered":"https:\/\/portfolios.cs.earlham.edu\/?p=395"},"modified":"2016-10-28T10:49:02","modified_gmt":"2016-10-28T14:49:02","slug":"work-log-10192016-102716","status":"publish","type":"post","link":"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/","title":{"rendered":"Work Log 10\/19\/2016-10\/27\/16"},"content":{"rendered":"<p>I spent this week charting out ER diagrams for a Facebook database schema. A lot of this work involved converting DDL statements I found online into a class diagram, and understanding how the classes related to each other. I am now at a point where I understand the entities and their relationships, and the next step is figuring out which of these entities I care about for my project.<\/p>\n<p>I have also been using Mining <a href=\"http:\/\/Mining the Social Web by Matthew Russell, published by O'Reilly, is an overview of data mining popular websites such as Twitter, Facebook, Linkedin and more. It even goes as far as touching on the semantic web and the not-so-popular Google Buzz.  Each area is covered with a brief explanation of how to set up any programs, a look at the API, some examples of the mining code and a couple of suggestions on how to use it. The book covers a lot of ground which is either a blessing, or a curse, depending on what you're looking for.\">The Social Web<\/a>. This book is an overview of data mining popular websites such as Twitter, Facebook, and (interestingly as a social media site), LinkedIn. It even touches on the semantic web and the not-so-popular Google Buzz. Each area is covered with explanations on how to set up programs, a brief introduction to and explanation on the workings of the API, some examples of mining code and a couple of suggestions on how to use it.<\/p>\n<p>&nbsp;<\/p>\n<p>I plan to use the data I am learning to harvest through these APIs to test and iteratively hone my data model. I&#8217;m currently working on charting out the ER diagram for Twitter, although this is proving trickier than it&#8217;s Facebook counterparts because I&#8217;ve only been able to find fragments of the model in different places.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I spent this week charting out ER diagrams for a Facebook database schema. A lot of this work involved converting DDL statements I found online into a class diagram, and understanding how the classes related to each other. I am &hellip; <a href=\"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/\">Read More<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-395","post","type-post","status-publish","format-standard","hentry","category-deeksha"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Work Log 10\/19\/2016-10\/27\/16 - CS\/DS Student Portfolios<\/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:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Work Log 10\/19\/2016-10\/27\/16 - CS\/DS Student Portfolios\" \/>\n<meta property=\"og:description\" content=\"I spent this week charting out ER diagrams for a Facebook database schema. A lot of this work involved converting DDL statements I found online into a class diagram, and understanding how the classes related to each other. I am &hellip; Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/\" \/>\n<meta property=\"og:site_name\" content=\"CS\/DS Student Portfolios\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-28T14:49:02+00:00\" \/>\n<meta name=\"author\" content=\"Deeksha Srinath\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Deeksha Srinath\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/2016\\\/10\\\/28\\\/work-log-10192016-102716\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/2016\\\/10\\\/28\\\/work-log-10192016-102716\\\/\"},\"author\":{\"name\":\"Deeksha Srinath\",\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/#\\\/schema\\\/person\\\/9ccb1fcd09a7acf8608249f6cb0acf86\"},\"headline\":\"Work Log 10\\\/19\\\/2016-10\\\/27\\\/16\",\"datePublished\":\"2016-10-28T14:49:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/2016\\\/10\\\/28\\\/work-log-10192016-102716\\\/\"},\"wordCount\":214,\"commentCount\":0,\"articleSection\":[\"Deeksha\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/2016\\\/10\\\/28\\\/work-log-10192016-102716\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/2016\\\/10\\\/28\\\/work-log-10192016-102716\\\/\",\"url\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/2016\\\/10\\\/28\\\/work-log-10192016-102716\\\/\",\"name\":\"Work Log 10\\\/19\\\/2016-10\\\/27\\\/16 - CS\\\/DS Student Portfolios\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/#website\"},\"datePublished\":\"2016-10-28T14:49:02+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/#\\\/schema\\\/person\\\/9ccb1fcd09a7acf8608249f6cb0acf86\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/2016\\\/10\\\/28\\\/work-log-10192016-102716\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/2016\\\/10\\\/28\\\/work-log-10192016-102716\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/2016\\\/10\\\/28\\\/work-log-10192016-102716\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Work Log 10\\\/19\\\/2016-10\\\/27\\\/16\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/#website\",\"url\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/\",\"name\":\"CS\\\/DS Student Portfolios\",\"description\":\"AI and ML, Image Classification, Arduino\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/#\\\/schema\\\/person\\\/9ccb1fcd09a7acf8608249f6cb0acf86\",\"name\":\"Deeksha Srinath\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83e5d2353cf7d2dc2efdf8c8975082c2e403ac1e9a1a051a4045d20ba8feb8a3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83e5d2353cf7d2dc2efdf8c8975082c2e403ac1e9a1a051a4045d20ba8feb8a3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83e5d2353cf7d2dc2efdf8c8975082c2e403ac1e9a1a051a4045d20ba8feb8a3?s=96&d=mm&r=g\",\"caption\":\"Deeksha Srinath\"},\"url\":\"https:\\\/\\\/portfolios.cs.earlham.edu\\\/index.php\\\/author\\\/dsrina13\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Work Log 10\/19\/2016-10\/27\/16 - CS\/DS Student Portfolios","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:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/","og_locale":"en_US","og_type":"article","og_title":"Work Log 10\/19\/2016-10\/27\/16 - CS\/DS Student Portfolios","og_description":"I spent this week charting out ER diagrams for a Facebook database schema. A lot of this work involved converting DDL statements I found online into a class diagram, and understanding how the classes related to each other. I am &hellip; Read More","og_url":"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/","og_site_name":"CS\/DS Student Portfolios","article_published_time":"2016-10-28T14:49:02+00:00","author":"Deeksha Srinath","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Deeksha Srinath","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/#article","isPartOf":{"@id":"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/"},"author":{"name":"Deeksha Srinath","@id":"https:\/\/portfolios.cs.earlham.edu\/#\/schema\/person\/9ccb1fcd09a7acf8608249f6cb0acf86"},"headline":"Work Log 10\/19\/2016-10\/27\/16","datePublished":"2016-10-28T14:49:02+00:00","mainEntityOfPage":{"@id":"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/"},"wordCount":214,"commentCount":0,"articleSection":["Deeksha"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/","url":"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/","name":"Work Log 10\/19\/2016-10\/27\/16 - CS\/DS Student Portfolios","isPartOf":{"@id":"https:\/\/portfolios.cs.earlham.edu\/#website"},"datePublished":"2016-10-28T14:49:02+00:00","author":{"@id":"https:\/\/portfolios.cs.earlham.edu\/#\/schema\/person\/9ccb1fcd09a7acf8608249f6cb0acf86"},"breadcrumb":{"@id":"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/portfolios.cs.earlham.edu\/index.php\/2016\/10\/28\/work-log-10192016-102716\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/portfolios.cs.earlham.edu\/"},{"@type":"ListItem","position":2,"name":"Work Log 10\/19\/2016-10\/27\/16"}]},{"@type":"WebSite","@id":"https:\/\/portfolios.cs.earlham.edu\/#website","url":"https:\/\/portfolios.cs.earlham.edu\/","name":"CS\/DS Student Portfolios","description":"AI and ML, Image Classification, Arduino","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/portfolios.cs.earlham.edu\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/portfolios.cs.earlham.edu\/#\/schema\/person\/9ccb1fcd09a7acf8608249f6cb0acf86","name":"Deeksha Srinath","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/83e5d2353cf7d2dc2efdf8c8975082c2e403ac1e9a1a051a4045d20ba8feb8a3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/83e5d2353cf7d2dc2efdf8c8975082c2e403ac1e9a1a051a4045d20ba8feb8a3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/83e5d2353cf7d2dc2efdf8c8975082c2e403ac1e9a1a051a4045d20ba8feb8a3?s=96&d=mm&r=g","caption":"Deeksha Srinath"},"url":"https:\/\/portfolios.cs.earlham.edu\/index.php\/author\/dsrina13\/"}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"Deeksha Srinath","author_link":"https:\/\/portfolios.cs.earlham.edu\/index.php\/author\/dsrina13\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/portfolios.cs.earlham.edu\/index.php\/category\/student\/2016\/deeksha\/\" rel=\"category tag\">Deeksha<\/a>","rttpg_excerpt":"I spent this week charting out ER diagrams for a Facebook database schema. A lot of this work involved converting DDL statements I found online into a class diagram, and understanding how the classes related to each other. I am &hellip; Read More","_links":{"self":[{"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/posts\/395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/comments?post=395"}],"version-history":[{"count":1,"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/posts\/395\/revisions"}],"predecessor-version":[{"id":397,"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/posts\/395\/revisions\/397"}],"wp:attachment":[{"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/media?parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/categories?post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/portfolios.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/tags?post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}