Database systems ii 91 574
This presentation is the property of its rightful owner.
Sponsored Links
1 / 6

Database Systems II 91.574 PowerPoint PPT Presentation


  • 97 Views
  • Uploaded on
  • Presentation posted in: General

Database Systems II 91.574. Content: Database-system implementation Research topics Instructor: John Sieg Required Texts: Ramakrishnan, Database Management Systems , McGraw-Hill Sieg, How To Build a Database System Web site: www.cs.uml.edu/~john/91.574/574syl.html. 91.574 - Grading.

Download Presentation

Database Systems II 91.574

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Database systems ii 91 574

Database Systems II91.574

  • Content:

    • Database-system implementation

    • Research topics

  • Instructor: John Sieg

  • Required Texts:

    • Ramakrishnan, Database Management Systems, McGraw-Hill

    • Sieg, How To Build a Database System

  • Web site: www.cs.uml.edu/~john/91.574/574syl.html


91 574 grading

91.574 - Grading

  • Midterm Exam25 %

  • Final Exam25 %

  • Project25 %

  • Journal, presentations,

    participation, etc.25 %

John Sieg, UMass Lowell


Possible topics

Possible Topics

  • implementation techniques for relational database systems

  • rule-based query optimization

  • deductive database systems

  • object-oriented database systems

  • query evaluation techniques

John Sieg, UMass Lowell


Possible topics cont

Possible Topics, cont.

  • on-line analytic processing systems and multidimensional databases

  • distributed systems

  • parallelism

  • programmatic interfaces to database systems, e.g., Microsoft’s OBDC and Database Classes

John Sieg, UMass Lowell


Project

Project

  • Extend the QBE interface with

    • a scanner built using flex and a parser built using bison

    • a query optimizer built using RBO

  • If you are interested in doing database research, you may choose a different project. Please discuss alternatives with me early in the semester.

John Sieg, UMass Lowell


Schedule first two sessions

Schedule (First Two Sessions)

  • First session:

    • Speaker: John Sieg

    • Topic: Query Processing: Validation, Modification, Lexical Scanning, Parsing; Flex & Bison

  • Second session:

    • Speaker: John Sieg

    • Topic: Query Optimization

    • Reading: Homebrew book, "Translating SQL"

    • Reading: "Access Path Selection in a Relational Database System," Selinger et al., Proceedings of the ACM SIGMOD International Conference on the Management of Data, 1979, pp. 23-24


  • Login