CIS 115

Lecture 17: Databases, Web 2.0 & Social Media

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

Assignments

• Read and be prepared to discuss:
  • Blown to Bits Chapter 1 - Digital Explosion
• Blog 8 - Due 3/31 10:00 PM
• Mars Rover: Due 4/9 10:00 PM

Blog 8: How Has the Internet Influenced You?

The internet has been a major force in our lives for several decades now. Write about how the internet has influenced you as a person. Try and think about ways that you would be a different person if you didn’t have the internet. Things you can think about:

• Instant Messaging, Email and Social Media
• Online Gaming
• Wikipedia and Simple Online Research
• Availability of Media Online