Transcript Database Design for the Web

Database Design
for the Web
The Fundamentals
Chapters 8-9
databases on the web
• They’re better than files in almost every way:
– Easier to store data
– Better data access
• Speed
• Ease
• Random
– Concurrency is built-in to the system
– Security is easier to achieve
• But they add a significant level of complexity to
your website
– Require constant administration & oversight
databases on the web
• How we use them:
– To provide data to web pages dynamically
– To update an organization’s inventories, logs,
etc.
– To provide secure access to websites
– To handle transactions
• Sample applications
– Blogs, shopping carts, …
The steps to creating a databasebacked website
•
Develop a data model.
– What information are you going to store and
how will you represent it?
•
Develop a collection of legal transactions
on that model.
– E.g., inserts and updates.
•
Develop a set of Web forms
– One for each transaction.
Data models