DOC PREVIEW
UW CSE 444 - Lecture Notes

This preview shows page 1-2-3-4 out of 13 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 13 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

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

UW CSE 444 - Lecture Notes

Documents in this Course
XML

XML

48 pages

SQL

SQL

25 pages

SQL

SQL

42 pages

Recovery

Recovery

30 pages

SQL

SQL

36 pages

Indexes

Indexes

35 pages

Security

Security

36 pages

Wrap-up

Wrap-up

6 pages

SQL

SQL

37 pages

More SQL

More SQL

48 pages

SQL

SQL

35 pages

XML

XML

46 pages

Triggers

Triggers

26 pages

Load more
Download Lecture Notes
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Lecture Notes and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Lecture Notes 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?