How to implement Spatial Data Handling technique in Oracle

We are building a Geographic Information System on Oracle7 RDBMS. In GIS, Handling spatial data efficiently is important part to make it good system. However, traditional relational dbms doesn't support it efficiently. Of course, I think it possible to manage spatial data in rdbms like Oracle, Empress, etc .. , but this can not guarantee high performance of GIS. In spite of these reason, We decided to use Oracle RDBMS to make a GIS for some reasons. We wouldn't tell them here. Anyway, We have to build a GIS on Oracle. So, I'm seeking some techniques handling spatial data in RDBMS specially Indexing, Querying and Storing them.

Now, it is time to ask some questions to you .

First, Is there any way to incorporate Spatial Data Indexing Mechanism like R-trees in Oracle Database? We want to deal this with Oracle as possible to guarantee data integrity and stability.

Second, Does the composite key indexing oracle offers can provide resonable performance?

Third, Is it possible to build a application using Pro*C and C++ and to compile Pro*C code and C++ code with GNU C++ compiler or Sparc C++ compiler or ohter C++ compilers.

We are using Oracle7 RDBMS and SunSparc C++ and GNU C++ compilers.

Thanks in advance for your kind help.

Park, Min-Seok.

Software R&D Center, Hyundai Electronics Industries Co., Ltd. Seoul, Korea.

E-mail: msPark_at_hdss.hsr.ke.kr. Received on Sat Feb 11 1995 - 03:20:57 CET