CSE 444 Database Management Systems Autumn 1997 University of Washington Introduction and WelcomeToday's TopicsCourse ContentsMy Goals for YouWhat this course is notAre you in the right course?Instructor's PerspectiveCourse StructureInfrastructureHands-on StuffLooking forward to the paper...Looking forward to the projects...A Note of Caution01/14/19 A-1CSE 444Database Management SystemsAutumn 1997University of WashingtonIntroduction and Welcome© 1997 UW CSE01/14/19 A-2Today's Topics•Course contents overview•Course structure overview•What is a database? and who cares?01/14/19 A-3Course Contents•DB for decades has been the workhorse of corporate applications–unglamorous but essential–lots of good-paying (but dull?) jobs•DB is once again a hot hot topic–objects, very large DB, new media, distributed heterogeneous computing, RAD, etc., etc.01/14/19 A-4My Goals for You•Learn classic topics really well–E/R modeling, relational design, classic query languages, storage and indexing, transaction processing concepts•Hands-on practice with small DBs on PC•Have awareness of some current trends•Enough background to go forth and learn anything you need to in the real world.01/14/19 A-5What this course is not•Not "Mastering Microsoft Access 97" (or Oracle or Sybase or whatever)•Not becoming an SQL guru•Not building way-cool GUIs in Visual Basic or Java•Not a course on CORBA or ODBM or SQL Server or ...01/14/19 A-6Are you in the right course?•CSE 326 is the prerequisite•Also very helpful–Operating Systems–Programming Languages–Software Engineering–Computer Architecture•CSE 444 will likely be taught again Winter•Likely an advanced DB course in Spring01/14/19 A-7Instructor's Perspective•1970's: database consultant for Honeywell•1980's: as a grad student, DB was one of my "quals" areas•1990's: taught a semester-length version of this course•Admit to feeling somewhat distanced from current practice...Hoping your papers and projects will help correct that!01/14/19 A-8Course Structure•Tests: midterm and final.–important but not huge•Written (non-programming) homework•Hands-on homework (using Microsoft Access 97) including some programming•Short research paper (due mid-quarter)•Group DB project (due end of quarter)01/14/19 A-9Infrastructure•TA: Jake Cockrell •Lecture periods–slides will only outline the material–sometimes follow text, sometimes not–I'll want you to participate, too.•Text: Elmasri and Navathe 2nd edition–Start reading today! Chapters 1-3–Later you might want to buy books on MS Access and/or SQL01/14/19 A-10Hands-on Stuff•Lab: Sieg 232 (NT)–Pay a visit today! Verify you can log-on and start up MS Access•Web sitewww.cs.washington.edu/education/courses/444/•E-mail•We can do a lot by e-mail and web, but I still would like to see you in person!01/14/19 A-11Looking forward to the paper...•Topic–Proposed by you, OK'd by me. Start looking!–Every person should have a different topic–Should be something current and not otherwise covered in the course–Could be a commercial product or application–Could relate to other CS areas •OS, Architecture, Networking, ProgLangs, etc.•Writing counts!01/14/19 A-12Looking forward to the projects...•Group projects–Each group with a different project–Get to know each other so you can form good groups!•"Service" oriented–Should fulfill a real need for someone outside the course•Emphasis on DB–But also specification, user interface, etc.01/14/19 A-13A Note of Caution•The paper and projects will OVERLAP other activities: tests, homeworks, etc.•You may expect conflicts and deadline clashes within the course!Please use all your best time-management skills to avoid overload and
View Full Document