Introduction to Database Systems CSE 414, Exams of Database Management Systems (DBMS)

Download Introduction to Database Systems CSE 414 and more Exams Database Management Systems (DBMS) in PDF only on Docsity!

Introduction to Database Systems

CSE 414

Lecture 1: Introduction

Write down Webquiz token

Class Goals

• The world is drowning in data!
• Need computer scientists to help manage this data
  • Help domain scientists achieve new discoveries
  • Help companies provide better services (e.g., Facebook)
  • Help governments (and universities!) become more efficient
• Welcome to 414: Introduction to Database Systems
  • Existing tools PLUS data management principles
  • This is not just a class on SQL!

Course Format

• Lectures
  • Location: here!
  • Please attend
• Sections:
  • Content: exercises, tutorials, questions, new materials (occasionally)
  • Locations: see web
  • Please attend
  • Bring your laptop
• 8 homework assignments
• 7 web quizzes
• Midterm and final
• Class and section participation
  • Post and answer questions (in class, piazza, etc)

Grading

• Homeworks 30%
• Web quizzes 10%
• Midterm 20%
• Final 30%
• Class participation 10%
• This is all subject to change

Textbook Main textbook, available at the bookstore:

• Database Systems: The Complete Book , Hector Garcia-Molina, Jeffrey Ullman, Jennifer Widom Second edition. REQUIRED READING!

Other Texts Available at the Engineering Library (some on reserve):

• Database Management Systems , Ramakrishnan
• Fundamentals of Database Systems , Elmasri, Navathe
• Foundations of Databases , Abiteboul, Hull, Vianu
• Data on the Web, Abiteboul, Buneman, Suciu

Eight Homework Assignments

H1: SQL+sqlite intro (1 week)

H2: SQL basics (1 week)

H3: Advanced SQL on Azure (1+ weeks)

H4: Datalog and Relational Algebra (1+ weeks)

H5: NoSQL: Json/SQL++ (1 week)

H6: Spark on AWS (1+ weeks)

H7: Schema Design (1week)

H8: Transactional Application (1+ weeks)

About the Assignments

• You will learn/practice the course material:
  • SQL, RA, parallel db, transactions, ...
• You will also learn lots of new technology
  • Cloud computing: Azure, and Amazon web services
  • NoSQL: AsterixDB, Spark
  • Databases: sqlite, Microsoft SQL Server
  • Git
• Each ranges in its difficulty to setup and use
• Will require (non-trivial) time to fiddle and explore!
• The time spent learning the new technology is very useful: write everything on your CV! 11

Seven Web Quizzes

• http://newgradiance.com/
• Create account; please use the same ID as your UW ID
• Course token will be posted on piazza
• Short tests, take many times, best score counts
• No late days – closes at 11:59pm deadline
• Provide explanations for wrong answers

Exams

• Midterm (Nov. 1) and Final (Dec. 13)
• You may bring letter-size piece of paper with notes
  • May write on both sides
  • Midterm: 1 sheet, Final: 2 sheets
• Closed book. No computers, phones, watches,...
• Location: in class

Lecture Notes

• Will be available before class online
• Feel free to bring them to class to take

notes

Using Electronics in Class

In the lectures:

• Opened laptops may disturb neighbors
• Please sit in the back if you take notes on laptop; pads / surfaces are OK
• Please don’t check your email / youtube / fb In the sections:
• Always bring your laptop (starting Thursday)

Outline of Today’s Lecture

• Overview of database management

systems

• Course content

Database What is a database? Give examples of databases