Course description
This course builds on the introductory module in databases. It intends to introduce more advanced topics in databases such as data mining and data warehousing, distributed databases and client server architecture after introducing the DBMS implementation.
Course learning outcomes
On successful completion of this module, the student will be able to:
· Apply normalization techniques
· Understand how transactions are processed in a database.
· Explain the concepts of Distributed Databases and Data Warehousing.
· Explain some database security issues.
· Explain the different techniques in Concurrency Control. - Tune and Optimize some Database Applications.
· Carefully explain the concepts of Object-Oriented database
· Understand theoretical foundations and principles of database design
· Learn new ways to query and model data.
· Get familiar with the expanding role of database technology in big data era.
· Understand and practice the research skills (algorithm design, problem solving, paper review and presentation)
Course content
· Introduction, Concepts and Definitions
· Normalization Techniques
· Data Mining and Data warehouse
· Transaction Processing
· Concurrency Control
· Distributed Databases
· Database Security
· Temporal database
Course reading Materials
· Fundamentals of Database Systems, Ramez Elmasri, Shamkant Navathe, pp.1200, Addison Wesley, 6 edition, 2010, ISBN-13: 978-0136086208
· Advanced Database Systems, Carlo Zaniolo , Stefano Ceri, Christos Faloutsos , Richard T. Snodgrass, V.S. Subrahmanian, and Roberto Zicari , pp. 576, Morgan Kaufmann, 1997, ISBN-13: 978-1558604438
· Foundations of Databases: The Logical Level, Serge Abiteboul , Richard Hull, and Victor Vianu, pp. 685, Addison Wesley, 1994, ISBN-13:978-0201537710
· Readings in Database Systems, Joseph M. Hellerstein (Editor), and Michael Stonebraker (Editor), pp. 877, The MIT Press, 4 edition, 2005, ISBN-13: 978-0262693141
· Transaction Processing: Concepts and Techniques, Jim Gray, and Andreas Reuter, pp. 1070, Morgan Kaufmann, 1992, ISBN-13: 978-1558601901
· Data Mining: Concepts and Techniques, Jiawei Han, and Micheline Kamber, pp. 800, Morgan Kaufmann, 2nd edition, 2005, ISBN-13:978-1558609013
· The Architecture for the Next Generation of Data Warehousing, William H. Inmon, Derek Strauss, and Genia Neushloss, pp. 400, Morgan Kaufmann, 2008, ISBN-13: 978-0123743190
· Date, Database Systems, 8th edition, 2004
· Patrick Valduriez M. TamerOzsu, Principles of Distributed Database Systems, 2nd Edition, Prentice Hall, 1999.