C20.0046DatabaseManagementSystemsLecture#1.pptVIP

M.P. Johnson, DBMS, Stern/NYU, Sp2004 C20.0046: Database Management SystemsLecture #1 Matthew P. Johnson Stern School of Business, NYU Spring, 2004 Personnel Instructor: Matthew P. Johnson KMEC 8-176, mjohnson@ Office hours: KMC 8-176, Th 12:15-2:15 please visit! Tutor/TF/grader: Matthew P. Johnson! Communications Web page: /~mpj9/dbms syllabus course policies may move in the future… Blackboard web site Some materials will be available here Discussion board send general-interest messages here to benefit all! Go to Click on C20.0046 Acknowledgements Thanks to Ramesh, Ullman, et al., Raghu and Johannes, Dan Suciu, Arthur Keller, David Kuijt for course materials See classpage for other related, antecedent DBMS courses What Is a Database? A very large, integrated collection of data. Models real-world enterprise. Entities (e.g., students, courses, instructors, TAs) Relationships (e.g., Joe is taking C20.0046) George is currently taking C20.0046 Dick is currently teaching C20.0046 Condi is currently TA-ing C20.0046 but took it last semester A Database Management System (DBMS) is a software package designed to store and manage databases. Databases are everywhere Example: Ordering a pizza Databases involved? Pizza Hut’s DB stores previous orders by customer stores previous credit cards used Credit card records huge databases of (attempted) purchases location, date, amount, parties phone company’s records Local Usage Details (“Pull his LUDs, Lenny.”) Caller ID ensures reported address matches destination Your wallet is full of DB records Driver’s license Credit cards NYUCard Medical insurance card Social security card Gym membership Money (serial numbers) Maybe even photos Databases are everywhere Q: Websites backed by DBMSs? retail: Amazon, etc. data-mining: Page You Made search engines: Google, etc. directories: Internic, etc. searchable DBs: IMDB, , etc. Q: Non-web examples of DBMSs? criminal/terrorist: TIA air