Dr. Silvia Nittel, School of Computing and Information Science, Spatial Informatics Cluster, University of Maine

SIE555 Spatial Database Systems

Spring  2012  --- Tues/Thurs 12:30-1:15pm

Silvia Nittel

Course Description

This course covers software system and data processing aspects of spatial database systems. It introduces database technology for spatial DBMS. Spatial data models and query languages. Storage hierarchy and structures. File organization. Index structures. Spatial index structures. Implementation of relational and spatial operators. Spatial query processing and optimization. Transaction management and crash recovery. Commercial spatial database systems. 

Lec. 3. Cr. 3.

Prerequisites: graduate standing, object-oriented programming experience in Java, or C++

Course Texts: 

Database Management Systems (3rd Ed), Raghu Ramakrishnan, Johannes Gehrke, McGraw Hill.

Optional: Spatial Databases: with Application to GIS, Philippe Rigaux, Michel Scholl, Agnes Voisard, Morgan Kaufmann Publishers.

Powerpoint slides of lecture material will be available via Umaine/Blackboard (http://courses.maine.edu/).

Software: 

The course will involved many in-class, hands-on programming assignments. Please make sure to have an up-to-date laptop available for class with sufficient RAM and disk space. For programming database systems, we will use a Java development environment (Java and Eclipse), the MySQL open source database management system (DBMS), and the JDBC library to connect to the database. For the spatial database labs, we will use Oracle Spatial (available in the labs). Every student will install his/her own DBMS on their laptop and use it for the assignments.

JAVA SOFTWARE:

1. Java: We are using Java SE Development Kit, JDK 6.0 Update 25. 

Windows/Linux/Solaris: This download is available at the following link. (Make sure to get the JDK, not JRE!) 

Mac OS users: "Mac OS X is the only major consumer operating system that comes complete with a fully configured and ready-to-use Java runtime and development environment. Professional Java developers are increasingly turning to the feature-rich Mac OS X as the operating system of choice for both Mac-based and cross-platform Java development projects. Mac OS X includes the full version of J2SE 1.5, pre-installed with the Java Development Kit (JDK) and the HotSpot virtual machine (VM), so you don't have to download, install, or configure anything."

2. Eclipse:  For Java software development, we also use Eclipse Classic 3.7.1  as the integrated development environment (IDE). The eclipse software is available at this link (the 3rd link)

Installation Notes:: The java installation will create a directory  "C:\Program Files\Java\" under Windows. Make sure to unzip and install eclipse into the same directory "C:\Program Files\Java\eclipse".

DATABASE SOFTWARE:

3. MySQL:  Select your  computer operating system platform, and download the appropriate MySQL Community Server 5.5.15 software. (link to MySQL). For example for Windows, download "Windows (x86, 32-bit), MSI Installer Essentials - Recommended".

4. JDBC for MySQL: Downloand the Java DataBase Connectivity (JDBC) software for MySQL (Connector/J) here.

5. MySQL Workbench GUI for MySQL here

SPATIAL DATABASE SOFTWARE:

6. Oracle 11g.  The DBMS server is installed on the department's lab machine. You will get remote access and your DBS login in class.

7. JDBC for Oracle 11g.  Downloand the Java DataBase Connectivity (JDBC) software for Oracle here. (make sure the JDBC version matches your JDK version!)

8. Oracle 11g client.  Downloand the Oracle 11g client software  here. (Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit) 

9. SQL Developer.   This tool is similar to MySQL Workbench and works with Oracle in general  (link to software here).

10. MapBuilder.   Mapbuilder is a tool  that supports interact with spatial data in Oracle (link to software here). (documentation here)
    (-->Oracle Fusion Middleware MapViewer Version 11g ps4 (11.1.1.5.1)  --> Mapbuilder (2nd link)

10. sdoapi.jar.  Java package to convert shape files into Oracle spatial data  (on Blackboard).


Distance Education:
The class is available via Adobe Connect Pro.

Course Goals and Objectives

Faculty Information

Dr. Silvia Nittel
Spatial Information Science and Engineering
334 Boardman Hall
nittel@spatial.maine.edu

 
Office Hours:
Office hours for this course will be announced at the beginning of the semester. Alternatively, contact me by email to arrange a time to meet.

Grading, Class Policies and Course Expectations

As a graduate level course, you are expected to exhibit high quality work that demonstrates sound understanding of the concepts and their complexity. Earning an “A” represents oral and written work that is of exceptionally high quality and demonstrates superb understanding of the course material. A “B” grade represents oral and written work that is of good quality and demonstrates a sound understanding of course material. A “C” grade represents a minimally adequate completion of assignments and participation demonstrating a limited understanding of course material.

Grading criteria:

Assignments – 40%

            Midterm  – 30%

            Final Project -- 30%

 

Academic honesty

Academic honesty is expected.  Plagiarism is unacceptable in this course and will result in a failing grade.

Students with disabilities:

If you have a disability for which you may be requesting an accommodation, please contact Ann Smith, Coordinator of Services for Students with Disabilities (Onward Building, 581-2319), as early as possible in the term.