CIS 2109 Database and File

tenderlaΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 10 μήνες)

96 εμφανίσεις

CIS 2109 Database and File
Management Systems

Lecture 1: Introduction

Lots of data in the world


Single data warehouse:
terabytes

to
petabytes


Mountains of data. How do we:


manage it?


turn mountain of data points to useful
information?


connect the dots?

Goals of the course


Learn database management principles


Learn some tools and how to use them


Build real systems

Admin and Syllabus

Your experience?

What?


organized collection of logically structured data.


Where do we find DBs?

Where?


Credit card


Telephone


Music


Doctor’s office


Sports stats


Car dealer, parts,
etc
.


Payroll, HR,
etc
.


Airlines


Weather


Web ad markets


Target. Who’s pregnant?


TU student DB


Pizza place +
CallerID


Address


Previous orders


Google Maps


Where’s the pizza?


Flu maps


Amazon


OS
config

info

How large?

Data Warehouses

Terabytes
. Even
Petabytes
.

Share your DVD collection


How do we keep track?


What is stored? types,
etc
?


How do we read information out of it?


Corner video store


Start charging


Due dates


Movie sales. Should price ever be


negative?


NaN
?


Some processing


What movies are popular?


Customers with expiring credit cards?


Consistency, Accuracy


Does the customer’s address make sense?


e
.g.
Does the zip code agree with the city, state?


What if the customer moves?


Change city


But forget to change zip

What happens when the power goes
out?



What happens when the power goes
out?


Persistence

We open a 2
nd

video store


Shared customer table


Maybe shared DVD table


What problems arise?


Consistency?

Web Storefront

Customer suspends subscription.


What happens?

Suspend subscription


Suspend:


Pending deliveries


Billing once all movies are returned


Keep:


Contact information


Billing information


DVD queue


Sending advertisements, offers, etc.


Database
triggers
.


Billing


Customer has:


an account balance


c
redit card


m
onthly subscription fee


At the right time of the month, we:


a
dd the subscription fee to their balance


When the customer authorizes payment:


Send charge to credit card issuing bank


Deduct charge from account balance


What happens if there’s a network disruption in the
middle?


DB Transactions

DB Software


MS Access,
Filemaker


SQLite (Firefox/
TBird
,
L
ightroom
,
D
ropbox
, Android)


MySQL


Oracle,
Postgres
, MS SQL Server

How do you talk to these?


From a console


From a utility program,
e.g.
, MySQL
Workbench


Embed in other code,
e.g., JDBC, PHP, JSP, ASP,
Rails,
Django

(through ORMs)



Other models


NoSQL


XML


JSON


Think Twitter, Google Maps
mashups


Who?


DB application developers


DB designer


DBA


DBMS
implementor


Data analyst