Agenda

1
Agenda

• Intro Databases the core of interactive
  websites
• Technology
• So what is a database anyway?
• The web server HTTP, HTML and all that
• Getting interactive tools packages
• Applications
• Template driven sites
• Transactions eCommerce and the like
• Logs, data mining stats

2
Databases 101

• Data structured shared
• entities, attributes, relations
• concurrency
• DBMS database management systems
• SQL structured query language
• users and access
• backup recovery
• Applications
• OLTP online transaction processing
• data warehousing mining

Database
Normalized ERD
Application
3
WebServers 101

• Serving up content
• handling browser requests
• security encryption
• logs
• Protocols
• TCP/IP networking
• DNS domain name system
• HTTP hypertext transfer protocol
• Get /smorais/www HTTP/1.0
• User-Agent Mozilla/4.0 (Macintosh I PPC)
• Accept text/html /Cookie name value
• Referer http//www.foo.com/bar.html
• Host www.geek.org
• HTML hypertext markup language
• lthtmlgtltheadgt lttitlegtgeekTalklt/titlegt lt/headgt
  ltbodygt hello world! lt/bodygtlt/htmlgt

browser
internet
WebServer
4
Interactivity

• Beyond static content
• dynamic page generation
• forms and user input
• Tools
• CGI common gateway interface
• REQUEST_METHOD GET
• SCRIPT_NAME /cgi-bin/test-cgi
• QUERY_STRING buttonon
• Perl server-side scripting
• Java object-oriented, cross-platform distributed
  applications
• Packages
• WebServer extensions
• Application servers

WebServer
Database
extensions
Application server
5
Applications

• Template driven sites
• HTML components stored in the database
• easy administration
• Dynamic content generation
• personalized pages
• Transactions
• eCommerce
• Intranet applications
• Data analysis
• Site usage statistics
• Tracking banner impressions, clickthroughs