CIS 115

Lecture 28: Databases, Web 2.0, Informatics, & Social Media (oh my)

kst8r

K-State's new social network!

• What features should it have?
• What data do we need?
• How should it be stored?
• How can we retrieve it?

Edgar F. Codd

Image Source: Wikipedia

Relational Database

Image Source: Wikipedia

Relational Database

Database Normalization

• Avoid modification anomalies
• Minimize errors when redesigning
• Mirror real-world concepts
• Avoid problems with different types of queries

Relational Database

Related Tables

Storing Phone Numbers

Many-to-One?

One-to-Many

Source: New Tools Workshop

Core Web 2.0 Technologies

• DOM
• Javascript
• AJAX
• JSON

Document Object Model (DOM)

Image Source: Wikipedia

JavaScript (1995)

• Originally called "LiveScript"
• Used to manipulate the DOM after the page has loaded
• Makes the web page much more interactive for the user
• Unrelated to the Java programming language

AJAX (2005)

• Asynchronous Javascript and XML
• Allows scripts on a webpage to send and receive data in the background without reloading the page
• XML not required; may use JSON instead

Extensible Markup Language (XML)

<person>
   <firstName>John</firstName>
   <lastName>Smith</lastName>
   <age>25</age>
   <address>
      <city>New York</city>
      <postalCode>10021</postalCode>
      <state>NY</state>
      <streetAddress>21 2nd Street</streetAddress>
   </address>
   <phoneNumbers>
      <element>
         <number>212 555-1234</number>
         <type>home</type>
      </element>
      <element>
         <number>646 555-4567</number>
         <type>fax</type>
      </element>
   </phoneNumbers>
</person>

JavaScript Object Notation (JSON)

{
    "firstName": "John",
    "lastName": "Smith",
    "age": 25,
    "address": {
        "streetAddress": "21 2nd Street",
        "city": "New York",
        "state": "NY",
        "postalCode": 10021
    },
    "phoneNumbers": [
        {
            "type": "home",
            "number": "212 555-1234"
        },
        {
            "type": "fax",
            "number": "646 555-4567"
        }
    ]
}

Social Media

• How people communicate online
• Users create and share content
• Sharing is real-time between users
• Content can be shared & discussed

Rise of Social Media

• 1997 - Six Degrees
• 1999 - Blogger & LiveJournal
• 2001 - Wikipedia
• 2002 - Friendster
• 2003 - LinkedIn & MySpace
• 2004 - Facebook, Flickr & digg
• 2005 - YouTube & Reddit
• 2006 - Twitter

Social Media Stats

• #1 Activity on the Web
• 1 Billion Facebook Users
• 58% of Facebook Users log on Daily
• 43% of people 65+ use Social Media
• Fewer teens are using Facebook than before

Discussion Time!

Is Web 2.0 and Social Media
Good, Bad, or Otherwise?

List 5-10 Good and 5-10 Bad aspects of Web 2.0 and Social Media

Informatics

• Broad area encomapssing information processing and information systems
Many domains: art, science, medicine, law
• Tasks: analytics, visualization, data/info integration

Informatics

• Technology impacting Information
  The use of technology to extract meaning out of large data sets


• Information impacting Technology
  Innovation to technology driven by new data collections


• People impacting Information
  The creation and manipulation of content to produce new informational value

Source: Blog Schmog

Informatics

• Information impacting People
  The connections made or strengthened through the aggregation of existing information


• People impacting Technology
  Social and political policy that affects access to and development of technology


• Technology impacting People
  The cultural changes resulting from the introduction and use of technology

Source: Blog Schmog

Use Case: Business Intelligence & Customer Relationship Management

Image Source: Wikipedia

Source: Forbes

Assignments

• Blog 13: Design a Robot - Due 5/4 10PM
• Scratch Game Project - Due 5/5 10PM
  
• Wiki Final Version - Due 5/8 10PM

Blog 13 - Design a Robot

In the lecture on robotics, we talked about many examples of how robots are shaping the world we live in today. Based on what you have learned i this class, design a robot that you think would be useful or interesting to you. Some things you can include:

• What would your robot look like? Would it be human-like or based more on the function (like a roomba for example)?
• What would your robot be capable of doing? What wouldn't it be able to do?
• Are there robots today that are doing these tasks? Are those robots good at what they do?
• How comfortable would you be allowing robots to take over many daily tasks in your life?