1CSE544: Principles of Database Management SystemsSpring 2005Dan SuciuPresented today by: Nilesh Dalvi2HighlightsNew course structure• New format: lecturing + paper reading• Modified content (+transactions, -basics)• Small research project (as before)3FormatBasic structure:• Lectures on Thursdays• Paper discussions on Tuesdays (reviews !)Variations:• More lectures in the beginning• More paper discussions towards the end4Content• Data modeling basics (3weeks):– SQL/XQuery with homeworks on Postgres/Galax– Logical foundations of databases• Transactions (2weeks):– concurrency control (locks, timestamps)– recovery (undo, redo, undo/redo, Aries(?))• Topics in query execution/optimization (3weeks)• Novel topics in data management (2weeks)– Data security, databases+IR, probabilistic db5Project• Choose from a list of mini-research topics, or come up with your own• Open ended• Write short research paper (2-3 pages)• Conference-style presentation6Grading (very tentative)• Homework: 10%• Paper reviews: 20%• Participation in the discussions: 10%• Project: 40% • Final (will we have one ?): 20%Your inputs are welcome7TextbooksWon’t follow any book, but you may want to consult them if you need more details to understand a topic• Database Management Systems, Ramakrishnan• The Complete Book, GarciaMolina, Ullman, Widom• Xquery from the Experts, Howard Katz, Ed.• Data on the Web, Abiteboul, Buneman, Suciu• Theory of database systems, Abiteboul, Hull, Vianu8Why Take It ?• It is a quals course (but so are others)• Looking for a thesis topic in 1-2 years ?– 3+1 db faculty = about 10%– Rich source of research topics • Looking for a job in 1-2 years ?– Interview questions: ACID, 3NF, update anomalies• Do you like fun, challenging courses ?Look no further...9Announcement: CSE590QDatabase seminar• This quarter’s topic (tentative wording):New Trends in Selectivity Estimation• Time: TBD• Room: Database Lab, CSE 605• Watch email for an
View Full Document