Database Courses

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
DB courses Antwerp U.
Databases I (180)
Databases II (180)
Databases III (110)

• Historic models
• ERM
• Relational model
• Query languages
• Functional depend.
• Normalization
• Web databases
• SQL writing
• Expressive power
• Transitive Closure
• Datalog
• Constraints
• Triggers

• 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
DB courses Mons U.
Databases I
Databases II
Data mining KD

• Historic models
• ERM
• Relational model
• Query languages
• Functional depend.
• Normalization
• Web databases
• SQL writing
• Transactions
• Concurrency, recov.

• ERM
• XML
• XPath
• XSLT

• Association rules
• Clusters
• Classification
• Neural networks
• Genetic Algorithms

UG/mand
UG/mand
Grad/elective
5
DB courses Swinburne UT
Databases I
Databases II
Databases III

• Historic models
• ERM
• Relational model
• Query languages
• Functional depend.
• Normalization
• Web databases
• SQL writing

• 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
DB courses USQ
Database Sys csc3400
AWDM csc4404
DL-AT csc8409

• Historic models
• ERM
• Relational model
• Query languages
• Functional depend.
• Normalization
• SQL writing

• 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
DB courses Proposal
Database Sys csc3400
AWDM csc4404
DL-AT csc8409

• Historic models
• ERM
• Relational model
• Query languages
• Functional depend.
• Normalization
• SQL writing
• Web databases

• Transactions
• Concurrency
• Distributed databases
• Information retrieval
• Web Search
• Web databases
• XML basics
• Query optimization

• Postscript
• LaTeX
• XML
• XML Schema
• XPath
• XSLT
• SOAP
• XQuery

XML TheoryApplic.
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,
  ?