<br />
<b>Warning</b>:  Undefined array key 0 in <b>/home/digitald/public_html/courses/wp-content/plugins/radgeek-FWP---Add-Attribution-70acf52/add-attribution-feedwordpress.php</b> on line <b>363</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/digitald/public_html/courses/wp-content/plugins/radgeek-FWP---Add-Attribution-70acf52/add-attribution-feedwordpress.php:363) in <b>/home/digitald/public_html/courses/wp-includes/rest-api/class-wp-rest-server.php</b> on line <b>1930</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/digitald/public_html/courses/wp-content/plugins/radgeek-FWP---Add-Attribution-70acf52/add-attribution-feedwordpress.php:363) in <b>/home/digitald/public_html/courses/wp-includes/rest-api/class-wp-rest-server.php</b> on line <b>1930</b><br />
{"id":710,"date":"2017-10-30T02:15:25","date_gmt":"2017-10-30T06:15:25","guid":{"rendered":"https:\/\/tuckercraig.com\/DIG101\/?p=157"},"modified":"2017-10-30T02:15:25","modified_gmt":"2017-10-30T06:15:25","slug":"understanding-databases-its-super-important","status":"publish","type":"post","link":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/2017\/10\/30\/understanding-databases-its-super-important\/","title":{"rendered":"Understanding Databases: It\u2019s Super Important"},"content":{"rendered":"<p>Manovich offers <a href=\"http:\/\/vv.arts.ucla.edu\/AI_Society\/manovich.html\">an artistic definition of a database<\/a> and a few specific applications of the data structure, but I want to discuss the fundamentals of the technology alongside very popular sources of databases and the ethical, and slightly nerdy, <a href=\"https:\/\/www.wikiwand.com\/en\/Database\">importance of databases<\/a>\u00a0&#8212; the qualities of which carry physical affects and digital applications that require computational care while sometimes perpetuating moral questions.<\/p>\n<p><strong>What is a database?<\/strong><br \/>\nIn its simplest form a database is a sequence of rows and columns whose rows correspond to elements or packets of information, be it a person, tweet, google search result, etc. and whose column corresponds to a piece of the information: name, author, date posted, etc.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/wiki.ucalgary.ca\/images\/e\/e3\/Navneet_-_Database_Example_1_-_Student_Table.png\"><img data-recalc-dims=\"1\" class=\"alignnone size-full wp-image-162\" src=\"https:\/\/i0.wp.com\/tuckercraig.com\/DIG101\/wp-content\/uploads\/2017\/10\/database_example.png?resize=525%2C199&#038;ssl=1\" alt=\"\" width=\"525\" height=\"199\" srcset=\"https:\/\/tuckercraig.com\/DIG101\/wp-content\/uploads\/2017\/10\/database_example.png 1032w, https:\/\/tuckercraig.com\/DIG101\/wp-content\/uploads\/2017\/10\/database_example-300x114.png 300w, https:\/\/tuckercraig.com\/DIG101\/wp-content\/uploads\/2017\/10\/database_example-768x292.png 768w, https:\/\/tuckercraig.com\/DIG101\/wp-content\/uploads\/2017\/10\/database_example-1024x389.png 1024w, https:\/\/tuckercraig.com\/DIG101\/wp-content\/uploads\/2017\/10\/database_example-604x229.png 604w\" sizes=\"(max-width: 1032px) 100vw, 1032px\" \/><\/a>One of the most popular forms of databases is an <a href=\"https:\/\/www.wikiwand.com\/en\/SQL\">SQL<\/a> database. (SQL = &#8220;Structured Query Language&#8221;) Wherein the data exists as a table with columns the user can sort, alter and make queries or selections\/filters to to get information out.<\/p>\n<p><strong>Where do we encounter databases?<br \/>\n<\/strong>In addition to video games, museums, and the generalized &#8220;Web&#8221; mentioned in <a href=\"http:\/\/vv.arts.ucla.edu\/AI_Society\/manovich.html\">Manovich&#8217;s work<\/a>, there are a few increasingly popular examples of databases which have large impacts on the modern digital world.<\/p>\n<p><a href=\"https:\/\/www.google.com\/search\/howsearchworks\/\"><em>Google:<\/em><\/a> When we use the word &#8216;google&#8217; we are simply referring to the interface used to access the database that the company Google has collected. &#8220;Spiders&#8221; or, as Google sometimes puts it, &#8216;web crawlers&#8217; visit the entirety of the generally accessible &#8216;Internet&#8217; and gather information which Google stores in their database. Users then query the data stored for information like articles, images, documents, webpages, etc. Google&#8217;s Search Algorithm holds similar structure to SQL databases is in its filtering and sorting of data by its diverse variables.<\/p>\n<p><iframe width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/BNHR6IQJGZs?feature=oembed\" frameborder=\"0\" gesture=\"media\" allowfullscreen><\/iframe><\/p>\n<p><a href=\"https:\/\/www.facebook.com\/friends\/requests\/?fcref=ffi\"><em>Facebook<\/em><\/a>\u00a0uses databases in its collection of human information. Which, of course, raises the <em>digital-<\/em>age old moral question: is it ethically sound to be collecting &#8216;personal&#8217; data? That is, data from a vast group of people. The question stems less from the concept of the structure, as data is meant to be stored, and more from the extent and subject of the data that is being collected. See <a href=\"https:\/\/tuckercraig.com\/DIG101\/facebook-would-like-access-to-you\/\">this previous blog post<\/a> I made about the ethical dilemma of Facebook&#8217;s sometimes unsolicited collection of &#8220;private&#8221; data.*<\/p>\n<p><strong>Why are they important?<\/strong><br \/>\nBeyond the artistic, cultural value that Manovich mentions, databases occupy physical space and computing power &#8212; something we&#8217;ve discussed in the past with cloud computing. Databases can easily be neglected as a computational &#8216;thing&#8217; that collects data and exists purely in our digital &#8216;cloud&#8217;. Take google&#8217;s data center for example. There is no magical cloud that information floats across. It, instead, lies in the ones and zeroes of physical hard drives and memory devices that exist in factories sprinkled all across the world leading to <a href=\"https:\/\/tuckercraig.com\/DIG101\/apple-makes-plans-for-clean-energy-data-center\/\">real world impacts<\/a>.<\/p>\n<p>In the modern world this constant spread and collection of information has come to be a big part of our progress being made in the digital world today. The constant moral questions being asked, from Facebook&#8217;s collection of personal information to Trump&#8217;s proposed &#8220;<a href=\"http:\/\/www.cnn.com\/videos\/politics\/2017\/01\/17\/trump-tracker-muslim-registry.cnn\">database for muslims<\/a>&#8220;, are all raising an equally important question of how, why, and for what should we use databases?<\/p>\n<p><strong><em>*Also, see <a href=\"https:\/\/tuckercraig.com\/DIG101\/big-brother-and-internet-security\/\">this post<\/a> for additional thoughts on data collection as a whole.<\/em><\/strong><\/p>\n\n<p class=\"syndicated-attribution\"><em>Posted from <a href=\"https:\/\/tuckercraig.com\/DIG101\/understanding-databases\/\">DIG101<\/a> by <a href=\"https:\/\/courses.digitaldavidson.net\/dig101-2017\/author\/0\/\" title=\"Read other posts by Tucker C.\">Tucker C.<\/a><\/em><\/p>","protected":false},"excerpt":{"rendered":"<p>Manovich offers an artistic definition of a database and a few specific applications of the data structure, but I want to discuss the fundamentals of the technology alongside very popular sources of databases and the ethical, and slightly nerdy, importance of databases&nbsp;&mdash; the qualities of which carry physical affects and digital applications that require computational &hellip;<\/p>\n","protected":false},"author":165,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[10],"tags":[266],"class_list":["post-710","post","type-post","status-publish","format-standard","hentry","category-group-c","tag-ethical"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p95kZR-bs","jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/posts\/710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/users\/165"}],"replies":[{"embeddable":true,"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/comments?post=710"}],"version-history":[{"count":1,"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/posts\/710\/revisions"}],"predecessor-version":[{"id":711,"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/posts\/710\/revisions\/711"}],"wp:attachment":[{"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/media?parent=710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/categories?post=710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/courses.digitaldavidson.net\/dig101-2017\/wp-json\/wp\/v2\/tags?post=710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}