Advanced Database Systems by Jun Yang
Jun Yang is an Associate Professor of Computer Science at Duke University. His primary research interest lies in the area of database and data-intensive computing. He received my M.S., Ph.D. from Stanford University and B.A. from University of California, Berkeley.
This course “Advanced Database Systems” covers advanced database management system design principles and techniques. The course materials will be drawn from both classic and recent research literature. Possible topics include access methods, query processing and optimization, transaction processing, distributed databases, object-oriented and object-relational databases, data warehousing, data mining, Web and semistructured data, search engines,
Course Lecture Notes:
- Introduction
- Relational model and algebra
- Relational design
- SQL basics
- Physical data organization
- More SQL
- Indexing: basics, ISAM, B-tree
- Indexing: more trees
- Indexing: hashing
- Indexing: text
- Query processing: scan, sort, hash
- Query processing: index-based
- Query processing: systems view
- Review;
- XML basics
- XPath, XQuery
- XSLT
- XML-relational mapping
- XML query processing
- Query optimization: rewrite
- XML indexing
- XML indexing
- Query optimization: cost estimation
- Query optimization: algorithms
- Concurrency control
- Recovery
About Author
by Imed Bouchrika
Dr. Imed Bouchrika received his PhD degrees in Electronics and Computer Science from the University of Southampton in United Kingdom in 2008. He has been in the industry as a software developer for over a decade primarily designing and developing interactive web applications. At the same time, he worked as a research fellow at the Image Processing research group at the University of Southampton investigating the potential use of gait as new biometric for forensic and security applications.
