Publisher: Morgan Kaufmann, Year: 2001 Join Groupĭue to copyright or some other issues, the resources you currently see may not be available, for more information, such as purchase, lease, second-hand transfer or other method, you can join our Telegram group, many other GIS tips would be shared here.From the query processing point of view, the following three properties characterize the differences between spatial and relational databases (Brinkhoff et al., 1993): (1) unlike relational databases, spatial databases do not have a fixed set of operators that serve as building blocks for query evaluation (2) spatial databases deal with extremely large volumes of complex objects, which have spatial extensions and cannot be sorted in one dimension (3) computationally expensive algorithms are required to test the spatial operators, and the assumption that I/O costs dominate CPU costs is no longer valid.
#Spatial database management system pdf series
Series: The Morgan Kaufmann Series in Data Management Systems Book InfoĪuthor(s): Philippe Rigaux, Michel Scholl, Agnès Voisard
My favorite advanced GIS textbook is GIS: A Computing Perspective, Second Edition. The coverage is focused on applications to spatial databases. Overall, the book is well written and clearly presents the material. The section of PostgreSQL is interesting but better material exists on the web. This chapter might be of historical interest but is hardly worth covering.
#Spatial database management system pdf software
The chapter presents how the spatial index is utilized for joins and relates.Ĭhapter 8: Commercial Systems: Any book that attempts to survey existing software is always out of date. Others will find it overwhelming.Ĭhapter 7: Query Processing: Like Chapter 6, this chapter delves into details that only a student truly interested in researching spatial indexes or developing new databases would be concerned with. Students who desire to research spatial indexing will find the chapter lacking. This would be a good chapter for a "short week" as it is either a research focus or matter of "it just works". This chapter will be challenging for Geography students but simple for Computer Science students.Ĭhapter 6: Spatial Access Methods: The biggest challenge for spatial databases is spatial indexing - adding a true sense of "where" to SELECT.WHERE! The chapter focuses mostly on classical index structures - B-tree, R-Tree, etc. Pseudo-code is given but I would recommend the classic Computational Geometry in C (Cambridge Tracts in Theoretical Computer Science) for detailed implementations. Basic computational geometry is a necessary extension for a database to truly support spatial data. One of the most significant aspects of a spatial databases is that it encodes geometric representations of geographic phenomena. This chapter provides a basic introduction to computation geometry techniques and their application to spatial data. For most teaching purposes, this chapter can be skipped.Ĭhapter 5: Computational Geometry: An odd gem in a text on spatial databases. The chapter even breaks down the model into relational algebra statements. The model is designed specifically to encode spatial data in a basic relational model. The section on formats and standards is a bit dated but provides a nice theoretical background - especially for the Census TIGER data.Ĭhapter 3: Logical Models and Query Languages: Opposite of Chapter 2, this chapter will challenge the Geography student while further grounding the Computer Science student in GIS data types.Ĭhapter 4: The Constraint Data Model: Here the authors choose to introduce some unique material in the form of the constraint data model. This review, alone, is worth the price of the book.Ĭhapter 1: Introduction to Spatial Database: Covers basic concepts of SQL, DBMS and spatial data.Ĭhapter 2: Representation of Spatial Objects: This chapter should be familiar to anyone with a GIS background but would fill in the gaps for computer science students. Each chapter is completed with an excellent bibliographical review of relevant publications.
For the computer science student, the book extends basic knowledge of DBMS for spatial applications. For the geography student, the text provides an excellent coverage of database concepts while drawing on familiar topics. It would be an excellent text for an advanced GIS programming course for either geography students or computer science students. The book covers a lot of ground in just over 400 pages. This textbook is an excellent resource for people specifically interested in the theoretical nuts and bolts of spatial databases.