1 / 23

CIS 2109 Database and File Management Systems

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.

walter
Télécharger la présentation

CIS 2109 Database and File Management Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CIS 2109 Database and File Management Systems Lecture 1: Introduction

  2. 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?

  3. Goals of the course • Learn database management principles • Learn some tools and how to use them • Build real systems

  4. Admin and Syllabus

  5. Your experience?

  6. What? “organized collection of logically structured data.”

  7. Where do we find DBs?

  8. 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

  9. How large? Data Warehouses Terabytes. Even Petabytes.

  10. Share your DVD collection • How do we keep track? • What is stored? types, etc? • How do we read information out of it?

  11. 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?

  12. 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

  13. What happens when the power goes out?

  14. What happens when the power goes out?Persistence

  15. We open a 2nd video store • Shared customer table • Maybe shared DVD table • What problems arise? • Consistency?

  16. Web Storefront

  17. Customer suspends subscription.What happens?

  18. Suspend subscription • Suspend: • Pending deliveries • Billing once all movies are returned • Keep: • Contact information • Billing information • DVD queue • Sending advertisements, offers, etc. • Database triggers.

  19. Billing • Customer has: • an account balance • credit card • monthly subscription fee • At the right time of the month, we: • add 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

  20. DB Software • MS Access, Filemaker • SQLite (Firefox/TBird, Lightroom, Dropbox, Android) • MySQL • Oracle, Postgres, MS SQL Server

  21. 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)

  22. Other models • NoSQL • XML • JSON • Think Twitter, Google Maps mashups

  23. Who? • DB application developers • DB designer • DBA • DBMS implementor • Data analyst

More Related