Introduction to Database SystemsCSE 444Lecture 27: Wrap-upCSE 444 - Summer 2010 1Reminder: About the Final 2ndMidterm• Open book and open notes – But you won’t have time to read during final!– No laptops, no mobile devices • Topics: Basically 2ndhalf of the course– No ER diagrams, no FDs, transactions, serializibility.No Pig Latin details (i e no“write a Pig Latin–No Pig Latin details (i.e., no write a Pig Latin program to do X”), but know the basics of the language and its relation to Map-ReduceCSE 444 - Summer 2010 2Review Advice• Review lectures• Review hw2 and hw3 • Review project 3 and project 4• Practice sample finals posted on websiteCSE 444 - Summer 2010 3What We Have Learned in 444• How to use a DBMS as a:– Data analyst: SQL, SQL, SQL,…Application programmer: JDBC XML–Application programmer: JDBC, XML,…– Database administrator: tuning, triggers, security– Massive-scale data analyst: Pig/MapReduce• How DBMSs work:– Transactions–Data storage and indexing–Data storage and indexing– Query execution CSE 444 - Summer 2010 4Where to Go From Here?• Seek hands on experience– Experience using & building DBMSsInternships research projects opensource projects–Internships, research projects, open-source projects– Check-out 544 assignments 2 and 3• Read more about DBMSs– Other chapters in our book–Other chapters inRamakrishnan&Gehrkebook–Other chapters in Ramakrishnan& Gehrkebook– Readings in DBMS book– Proceedings of SIGMOD, VLDB, ICDE, CIDRCSE 444 - Summer 2010 5Hope you had agreat quarter!Hope you had a great quarter!CSE 444 - Summer 2010
View Full Document