40 likes | 190 Views
Database management systems with distributed, XML and datawarehousing applications. Third Country Training Program JICA/PJIIT, Warsaw , February 200 3. Lectures: Dr. Lech Banachowski, lech@pjwstk. edu .pl Exercises: Dr. Krzysztof Stencel, stencel@mimuw.edu.pl. Objectives of the course.
E N D
Database management systems with distributed, XML and datawarehousingapplications Third Country Training Program JICA/PJIIT, Warsaw, February 2003 Lectures: Dr. Lech Banachowski, lech@pjwstk.edu.pl Exercises: Dr. Krzysztof Stencel, stencel@mimuw.edu.pl
Objectives of the course • To get acquainted with: • database management systems, • distributed database systems, • data warehouses, and • XML databases. • To provide a hands-on experience with Oracle database software. • To present the way the advanced topics of databases are taught at PJIIT. • To exchange views how to teach advanced topics of databases.
Topics of the course • Relational database model. • Architecture of a relational database management system. • SQL Database Language. • Distribution of data in the network. • Distributed databases. • Extracting and integration of information coming from many databases – data warehouses. • XML data model. • Storing XML data in a database.
References and software • The course MS PowerPoint presentations - \\ftp\public\lech\3rdC. • Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems, McGraw-Hill, 2nd edition, 2000; 3rd edition, 2003 - slides available from: Raghu Ramakrishnan raghu@cs.wisc.edu; book site: http://www.cs.wisc.edu/~dbbook • Hector Garcia-Molina, Jeffrey D.Ullman,Jennifer D. Widom, Database Systems: The Complete Book, Prentice Hall, 1st edition, 2001 • Oracle 9i Database Server - Enterprise Edition.