Re: How to implement Spatial Data Handling technique in Oracle
Date: 11 Feb 1995 03:48:44 GMT
Message-ID: <3hhc2s$cks_at_ixnews2.ix.netcom.com>
In <3hh6u9$m5h_at_news.kreonet.re.kr> Park Min Seok <msPark_at_hdss.hsr.re.kr> writes:
>
>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.
>
>
>
Can you tell us a little bit about the characteristics of the problem, e.g.:
- how many objects are being stored?
- do you have line segments, points, rectangles, arbitrarily shaped objects, ...
- are you dealing with 2-d, 3-d, k-d data?
- are you dealing with conventional distance metrics (e.g. Euclidean norms, max coordinate distance, etc.)
- do your objects have a predominant orientation?
- is this a multi-user system, so that full transactional integrity must be maintained on each object and each part of each object?
- etc.
/jim Received on Sat Feb 11 1995 - 04:48:44 CET