The Relational Model课件.pptVIP

The Relational Model CS 186, Spring 2007, Lecture 2 Cow book Section 1.5, Chapter 3 Mary Roth Administrivia Homework 0 Due next Tuesday, Jan 23 10 p.m. Submission instructions added to homework description Class account forms here if you need them Discussion sections will meet today Questions? Outline What we learned last time What is and what good is a DBMS anyway? Components of a DBMS New stuff A brief history of databases The relational data model Review: What is a database? A collection of data organized for rapid search and retrieval Data collection has some logical meaning, and some reason for it to be organized in a particular way. Review: What is a DBMS? A software system designed to manage a database. Think big and lots of data 300,000,000 bank accounts Think mission critical 1,000,000 transactions a day You’d need a DBMS to: Help you find things fast Help you keep track of what’s going on Review: ACID properties Review: DBMS components A DBMS is like an ogre; it has layers We’re going to learn about these layers all semester We’re going to build several layers in our homework projects Review: DBMS components Review: How does a DBMS work? Review: Typical architecture for DB applications Summary: Benefits of a DBMS Data independence applications worry about what data they want, not how it is stored Efficient data access DBMS is smart about how to retrieve data Data integrity and security DBMS won’t let you corrupt data Centralized administration stored data on single server and let people specialize in managing it Concurrent access Handles multiple users efficiently and recoverably Reduced application development time Derived from 1-5 Minibase is a Java-based DBMS Intermission Get up and stretch Ask a quick question Get a drink of water A brief history of databases Birth of the DBMS parallels adoption of computer over 1960s and 1970s 1960s: IBM introduced IMS 36 years old! ‘Legacy’ technology, but still important! 100,000,000 bank transactions a day