Pro Oracle Spatial (Hardcover)

by Euro Beinat (Author), Albert Godfrind (Author), Ravikanth V. Kothuri (Author)
Key Phrases: map viewer, index engine, map legend, Oracle Spatial, Oracle Application Server, London Buses (more...)

Editorial Reviews

Product Description
<p>With growing reliance on spatial components for making critical and strategic decisions, there is great incentive to maximize the added value of spatial data. Enter: <i> Pro Oracle Spatial. </i> This highly anticipated book examines the potential for organizations to exploit spatial information by way of Oracle Spatial. </p>

<p>Included are case studies of advanced spatial applications in healthcare, telecom, retail, and distribution industries. Further, the content is based on extensive feedback from training courses, discussion lists, and customers. This talented author team will also suggest best-practice approaches to common problems.

About the Author
No biography is available for this author.

No biography is available for this author.

Ravi Kothuri holds a Ph.D. in computer science from the University of California, Santa Barbara, and has been an active researcher and developer in the spatial and multimedia areas for the past 12 years. Currently, he serves as the project lead and software architect for various projects in Oracle Spatial. He has around 15 patents (some pending) on specific Oracle technology and has authored numerous articles for database conferences and journals. Other activities include teaching database courses for undergrads and reviewing of research articles for spatial and database conferences. Ravi enjoys music, movies, and playing with children.

Product Details

• Hardcover: 712 pages
• Publisher: Apress; 1 edition (November 15, 2004)
• Language: English
• ISBN-10: 1590593839
• ISBN-13: 978-1590593837
• Product Dimensions: 9.3 x 7.2 x 1.6 inches
• Shipping Weight: 2.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.4 out of 5 stars See all reviews (7 customer reviews)
• Amazon.com Sales Rank: #326,539 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

5.0 out of 5 stars Excellent book, fascinating topic, December 31, 2004

By	Jack D. Herrington "engineer and author" (Silicon Valley, CA) - See all my reviews (TOP 500 REVIEWER)    (REAL NAME)

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.

5 of 6 people found the following review helpful:

5.0 out of 5 stars Get up and Go: Oracle Spatial!, July 13, 2005

By	Simon G. Greener (Allens Rivulet, Tasmania, Australia) - See all my reviews (REAL NAME)

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

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

By	C. Faulkner (Leicester, UK) - See all my reviews (REAL NAME)

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.