1 / 8

Database Courses

Database Courses. Survey USQ Survey other universities Proposal. DB courses: content. Basic theory Historic models, ERM, Rel.Model, QLs, FDs, normalization, … Basic practice SQL, UML writing, web databases Advanced theory Transactions, Concurrency, Q optim., expressive power, datalog, …

season
Download Presentation

Database Courses

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Courses Survey USQ Survey other universities Proposal

  2. DB courses: content • Basic theory • Historic models, ERM, Rel.Model, QLs, FDs, normalization, … • Basic practice • SQL, UML writing, web databases • Advanced theory • Transactions, Concurrency, Q optim., expressive power, datalog, … • Advanced practice • DB implementation, constraints, triggers, query plans • ‘New’ themes in dbs • Data mining, information retrieval, web search, OLAP, oo-db, temp • Semistructured databases • XML, XPath, XSchema, XQuery, XSLT, Soap, research topics

  3. Historic models ERM Relational model Query languages Functional depend. Normalization Web databases SQL writing Expressive power Transitive Closure Datalog Constraints Triggers DB courses: Antwerp U. Databases I (180%) Databases II (180%) Databases III (110%) • Transactions • Concurrency, recov. • Distributed databases • Security • Missing information • Query optimization • OLAP • Temporal databases • Data mining • Information retrieval • Semistructured DBs: • XML • XML Schema • XPath • XSLT • XQuery • Research topics UG/mand UG/mand Grad/elective

  4. Historic models ERM Relational model Query languages Functional depend. Normalization Web databases SQL writing Transactions Concurrency, recov. DB courses: Mons U. Databases I Databases II Data mining & KD • ERM • XML • XPath • XSLT • Association rules • Clusters • Classification • Neural networks • Genetic Algorithms UG/mand UG/mand Grad/elective

  5. Historic models ERM Relational model Query languages Functional depend. Normalization Web databases SQL writing DB courses: Swinburne UT Databases I Databases II Databases III • Transactions • Concurrency, recov. • Distributed databases • Triggers • Web databases • Oracle PL/SQL • SQL cursors • Physical design • Query plans • Views • OO-dbs • Relational-OOdbs UG/mand UG/mand Grad/elective

  6. Historic models ERM Relational model Query languages Functional depend. Normalization SQL writing DB courses: USQ Database Sys: csc3400 AWDM: csc4404 DL-AT: csc8409 • Transactions • Concurrency • Distributed databases • Information retrieval • Web Search • Web databases • XML basics • Postscript • LaTeX • XML • XML Schema • XPath • XSLT • SOAP UG Grad/elec Grad/elec LaTeX also appears in csc2408 Database Design: cis2002 Data mining: csc3417 • More or less the same: • SQL in Oracle • Bit more practical • Less Algebra, Calculus • Association rules • Clusters • Decision trees • … UG UG

  7. Historic models ERM Relational model Query languages Functional depend. Normalization SQL writing Web databases DB courses: Proposal Database Sys: csc3400 AWDM: csc4404 DL-AT: csc8409 • Transactions • Concurrency • Distributed databases • Information retrieval • Web Search • Web databases • XML basics • Query optimization • Postscript • LaTeX • XML • XML Schema • XPath • XSLT • SOAP • XQuery XML Theory+Applic. Data mining: csc3417 • Association rules • Clusters • …

  8. Proposal: Database Group • Used to exist at USQ (Yanchun) • Restart group to • Discuss course content • Avoid overlaps • Offer interesting, current material • Quality control • Offer student projects • Perhaps research support? • Members: • Ron A, Tony, Jiuyong, Xiaodi, David Lai, Stijn, …?

More Related