database systems ii 91 574
Download
Skip this Video
Download Presentation
Database Systems II 91.574

Loading in 2 Seconds...

play fullscreen
1 / 6

Database Systems II 91.574 - PowerPoint PPT Presentation


  • 149 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Database Systems II 91.574' - calvin-holcomb


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 Exam 25 %
  • Final Exam 25 %
  • Project 25 %
  • 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
ad