Computer Science 380:

Principles of Database Systems

Chapter 9

Gregory M. Kapfhammer


creative commons licensed ( BY-NC-SA ) flickr photo shared by danmachold

Database Use Patterns

Non-Declarative

Print a report

Display results in a GUI

Interact with the user

Transmit data across the network

Application Programs and User Interfaces

The Web!

Dynamic versus Static

Two-Tier versus Three-Tier

Client-Side versus Server-Side

Application Performance

Throughput

Response time

Driving on the highway

Trade-offs


creative commons licensed ( BY-NC-SA ) flickr photo shared by kara_vanmalssen

Cache

Parallel Processing

Application Security

SQL injection attacks

Cross-site scripting attacks

Password leakage

Authentication and authorization

Encryption


creative commons licensed ( BY-NC ) flickr photo shared by Thomas Hawk