2 Replies Latest reply: Mar 3, 2011 5:29 PM by Dsegleau-Oracle RSS

    "SPATIAL functions/Library " support in Berkeley db XML or other editions


      Can you please let me know if Berkeley db supports Spatial functions/API support to work on spatial data and gis map related applications. Please guide me which other databases have spatial support in case Berkeley db doesn't support.

      Waiting for your reply,

      Thanks and Regards,
      Pradeep Penchala
        • 1. Re: "SPATIAL functions/Library " support in Berkeley db XML or other editions

          Just put my two cents. Including but not limited to:

          *1. Oracle Berkeley DB XML -- KML*

          Keyhole Markup Language (KML) is an XML schema for expressing geographic annotation and visualization within Internet-based (http://en.wikipedia.org/wiki/Keyhole_Markup_Language). In November 2007 a new KML 2.2 Standards Working Group was established within OGC to formalize KML 2.2 as an OGC standard.

          Berkeley DB XML is a good choice to storage/manage/query/update KML data. You can setup containers/indexes to manager huge amount of KML data efficiently.

          *2. Oracle Berkeley DB -- R-tree*

          R-trees are tree data structures that are similar to B-trees, but are used for spatial access methods (http://en.wikipedia.org/wiki/R-tree).

          Berkeley DB supports R-tree module, which can help you use R-tree structure for doing range queries.

          Best regards,
          Oracle Berkeley DB XML
          • 2. Re: "SPATIAL functions/Library " support in Berkeley db XML or other editions

            To expand on what Rucong mentioned, the SQL API in Berkeley DB is SQLite compatible. Therefore you can use the SQLite spatial functions (http://www.sqlite.org/rtree.html) in Berkeley DB. You should also be able to use any other spatial package that is available for/built on SQLite. Simply replace the SQLite library with the Berkeley DB library when building the spatial functionaliy. For additional details, please look at the "Building Berkeley DB" guide for the platform that you are interested in. For example, for Windows you would look here: (http://download.oracle.com/docs/cd/E17076_02/html/installation/build_win_sql.html#id3845473) .



            Edited by: dsegleau on Mar 3, 2011 3:28 PM