4 of 4 people found the following review helpful:
5.0 out of 5 stars
Excellent book, fascinating topic, December 31, 2004
This review is from: Pro Oracle Spatial (Hardcover)
Pro Oracle Spatial is a well written introduction to Oracle's spatial database extensions. Using this mechanism you can attach geometry data to your records and then search them using geometric patterns. Think of Yahoo maps as a good example of this. in fact, the case study portion of the book is a mapping website that you can search and overlay points of interest on. In addition the book demonstrates, to some degree, finding the best route between two spatial points.
It's a thick book on a thick topic, hard-backed, and well illustrated. The style is as walkthrough. Going through each section of the SDO extensions and showing how they are used in context. It's not a good reference work.
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
5 of 6 people found the following review helpful:
5.0 out of 5 stars
Get up and Go: Oracle Spatial!, July 13, 2005
This review is from: Pro Oracle Spatial (Hardcover)
I had a very bad accident back over the Christmas (2004)/New Year (2005) period and while confined to bed, a copy of "Pro Oracle Spatial" arrived in the mail.
Loving a good book, I quickly scanned the Table of Contents (nice to see it has a good Index as well!) and decided this was worth a read.
Well, it is no novel, so it took me a few months to digest; but digest it I did. No "heart burn" here: rather more it "lit the inner fires" of one of my passions: database-based spatial!
I started out in computing nearly 20 years ago on mainframe databases migrating to GIS within 5 years as it was a more interesting field of computing than business computing (and it allowed me to combine my computing science qualifications with my geomatics degree). However, the thing I missed the most was the solidity of the science underlying databases which allowed for logical separation of application from internal implementation: the GIS world was fixated on physical data formats (1960s computing). It took many years before the work of people like Michael Stonebraker and the science and math underlying Abstract Data Types (ADTs) finally hit the work of relational database management (RDBMS) to give us ORDBMS.
And the rest, as they say, is history.
Oracle Spatial has come a long way since the days of Multi-Dimension. The hard working team of dedicated developers up there in New Hampshire have built a rock solid piece of technology and deserve recognitition for it. Books like this go a long way to giving them that recognition and widen the audience for database-based spatial to a group of people who will appreciate what they have done because it is "familiar territory" and mainstream.
As a GIS professional and long standing database expert, I found this book covered much familiar territory, but even I found it gave a fresh perspective on what can be the tedious read of online documentation (no offence to the Oracle documentation team intended). In other words: I learned a few things I didn't know!
The more familar base concepts that are covered in the book are clear and lucid and a great adjunct to the manuals. The will make it easy for non-spatially literate people to "get up to speed".
I particularly liked the Case Studies as it is always enlightening to see how others made the rubber hit the ground.
The Common Mistakes and Errors chapter (14) had me nodding in ascent. I was "tickled pink" to discover that the original Multi-Dimension roots of Oracle Spatial are still there in the HHENCODE function described in "Reorganize the Table Data to Minimise I/O". My only regret was that I have wasted time implementing a version of the PEANO space curve (linear_key) in Java and PL/SQL and deployed it into 8.1.7.4 when I hadn't needed to do it all along! The discovery of the HHENCODE function (page 582) came at a time I was dusting off the old Peano code for the organisation of some Lidar data for my current employer. Thanks Oracle Spatial team for leaving the function in the product even at 10g!
I found the MapViewer and Network Analysis chapters clear and accessible and I particularly liked the Appendix on "Additional Spatial Analysis Functions" as this was an "eye opener" that confirmed for me that the Oracle team really do understand the uses for spatial data. Again, I could see immediate application at my workplace.
If you are their target audience ie [... application developers who are familar with Oracle technolgies and want to enhance their applications with spatial information ... but ... do not know much about spatial data] ("Who Should Read This Book?", page xxx) then this book is for you. If you are from a more traditional GIS background (and want to know what all the fuss is about) then you should get a copy of this book because the sort of technology that is described within it is part of the future of the geospatial data management and processing. For more seasoned Oracle and GIS veterans: even you will find something in it that is worth the price.
Order one today.
Simon Greener
GIS Manager, Oracle Spatial enthusiast
Allens Rivulet, Tasmania, Australia.
Longitude: 147.2048
Latitude: -43.0141
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
1 of 1 people found the following review helpful:
5.0 out of 5 stars
Need to get started with Spatial ? Get this book., May 25, 2006
This review is from: Pro Oracle Spatial (Hardcover)
Excellent book. I have been using Oracle Spatial for years but found various useful insights in this book. It is well laid out, accessible and covers pretty much all the bases. Good examples and case studies. Tackles the thorny issues around spatial indexing as well as I have seen.
Why can't Oracle do documentation like this ?!
Only drawback is that I found some errors in the discussion of transportable tablespaces WRT Spatial data.
Help other customers find the most helpful reviews
Was this review helpful to you? Yes
No
