Oracle Spatial - A True OpenWorld Story

I heard this story over dinner at OpenWorld:

An Oracle user from biotech giant, let’s call him Richard, walked up to Oracles Spatial demo pod at OpenWorld and wanted to know more about how to leverage Oracle's mapping and spatial analysis capabilities using Oracle Application Server MapViewer. Richard is not in the biotech’s IT organization, but a user engaged in a variety of interesting analytical applications related to the biotech’s business. Much of their analysis is spatial or location-based (for example, looking at the capabilities and capacities of hospitals and other healthcare facilities for kidney dialysis and other services, with respect to demographics in the area, availability of government funding, boundaries of representatives' congressional districts, and other factors). The Oracle demonstrator, call him John, was pleasantly surprised to learn that Richard had already used APEX (Application Express), the powerful and easy-to-use development tool included with Oracle Database, to develop a few applications.

Richard was excited to learn that MapViewer could be used with APEX to incorporate maps and spatial queries into the biotech’s analytical applications. John described how easily he could build location-based applications, and how their IT group could use them as prototypes for more sophisticated enterprise implementations if desired. But Richard was way ahead of John, and already had some great ideas in mind.

Richard's next stop was the NAVTEQ exhibit booth, where Steven Pierce from Johnston-McLamb was demonstrating applications that Johnston-McLamb developed for customers using the spatial and location capabilities of Oracle Database and NAVTEQ mapping data (NAVTEQ and Johnston-McLamb are both excellent Oracle Spatial partners). After Richard described one map visualization and query application that he wanted at the biotech, Steven said "We can put that and many other similar applications together for you using Oracle MapViewer very easily. You don't have any sample data with you at Oracle OpenWorld, do you?". Richard replied, "As a matter of fact, I've got some business information from our Oracle database on this USB drive in Excel format." In a matter of minutes, Steven loaded the data into an Oracle Database table on the spot and showed it against a NAVTEQ base map using Oracle Application Server MapViewer.

Richard was sold. He sat down with Steven and drafted a brief statement of work. Johnston-McLamb got a contract on the spot to help the biotech company implement Oracle-based map visualization and spatial analysis applications.

Now that is an OpenWorld story with a happy ending!

- Jeff from the Oracle Database Insider team


As an ESRI software user I would like to see Oracle 11g and Oracle spatial on a Mac platform using MacOSX Leopard. I would love to see this work in that environment.

Posted by Michael Morin on October 13, 2008 at 05:37 AM PDT #

Michael, I've posed your question to some folks who might be able to answer you. Will post their replies when I get them. In the meantime you might try Oracle Mix [] to see if there is already an answer to this question or a group whose working on getting an answer. - Jeff

Posted by Jeff on October 15, 2008 at 01:56 AM PDT #

Michael, Here's a comment by my contact in the product management team: "The bottom line is that Oracle Database 10g (and therefore Oracle Spatial 10g) is supported on Mac OSX, but Oracle Database 11g is not there yet. Assuming Mac OS X is the Intel chip, then an 11g port is expected, but not until 11.2." Good luck, and I would encourage you to check in with Oracle Mix to see if there's a group that is following the issue. Or you could even set up a group to follow the issue and make your needs known. -- Jeff

Posted by Jeff on October 16, 2008 at 02:30 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« February 2015