SQL - CS 580 Client-Server Programming Spring Semester,...

Info iconThis preview shows pages 1–16. Sign up to view the full content.

View Full Document Right Arrow Icon
CS 580 Client-Server Programming Spring Semester, 2009 Doc 15 SQL 18 March, 2010 Copyright ©, All rights reserved. 2010 SDSU & Roger Whitney, 5500 Campanile Drive, San Diego, CA 92182-7700 USA. OpenContent ( http:// www.opencontent.org/opl.shtml ) license defines the copyright on this document.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 You will be creating your own tables in your database for the server We will be using SQLite for the database
Background image of page 2
3 CS 514 in 51 slides
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Jargon 4 Client Server 2-Tier Client Server Database 3-Tier
Background image of page 4
More Jargon 5 Sometimes database means a program for managing data Oracle Corporation is a database company. MS Access is database. Sometimes database means a collection of data I keep a database of my CD collection on 3 by 5 cards Sometimes database means a set of tables, indexes, and views My program needs to connect to the Airline Reservation database, which uses Oracle
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Some Reasons for Using a Database 6 Persistence of data Sharing of data between programs Handle concurrent requests for data access Transactions that can be rolled back Report generation
Background image of page 6
In the Beginning - Relational Databases 7 Dr. E. F. Codd Develops relational database model Early 1970's IBM System R relational database Mid 1970's Contained the original SQL language First commercial database - Oracle 1979
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Object Databases were there too 8 Objects are stored in the database Research into databases fo graph structured databases Early to mid 1970s Oobject-oriented database term first used 1985 First commercial OO database system 1986
Background image of page 8
Relational Databases dominated Market 9 Relational databases standard DB Administrators make lots money Oracle makes ton of money MySQL & PostgresSQL open source databases become popular
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
But Some Were not Happy 10 Large data sets not handled well Think Google SQL databases not flexible enough
Background image of page 10
NoSQL Databases 11 Hadoop/HBase Cassandra CouchDB MongoDB Amazon SimpleDB MemcacheDB Document Store Key/Value Store Eventually Consistent Key Value Store
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Relational Databases and SQL 12 Database consists of a number of tables Table is a collection of records Each Column of data has a type +----------------------+----------------------+------------+----------+ | firstname | lastname | phone | code | +----------------------+----------------------+------------+----------+ | John | Smith | 555-9876 | 2000 | | Ben | Oker | 555-1212 | 9500 | | Mary | Jones | 555-3412 | 9900 | +----------------------+----------------------+------------+----------+ Use Structured query language (SQL) to access data
Background image of page 12