Geos.730         GIS DATA MANAGEMENT                                                 (3 CH)

Concepts of databases and data warehouses, types, definitions and terminology, database management system objectives; digital vs paper-based, independence, integrity, reliability, accessibility, efficiency and security, relational databases and their role in GIS, design and manipulation of relational databases, database query and analysis using SQL (structured query language), concepts of OLTP, CUBE, OLAP, ROLAP and MOLAP, normalization and denormalization, data mining, access of RDBMS data in spatial database packages.

Books Recommended:

• DATA WAREHOUSES AND OLAP, Concepts, Architecture and Solution by Wrembel, R. and Koncilia, C., 2007. IRM Press, UK.
• Fundamentals of Relational Database Management System by Somathi, S. and Esakkirajan, S., 2007. Springer, Berlin.
• Delphi/Kylix Database Development by Harmon, E., 2002. Sams Publishing.
• Mastering MS Visual Basic by Petroutsos, E., 2008. SYBEX.
• Getting to know ArcObjects: Programming ArcGIS with VBA, 2003. ESRI press, Redlands, California.