I don't want to walk into too much of a hornets nest here but I'm dubious about the comment...
"Oracle 8i Spatial is a GIS independendent way of storing Spatial Data and making it accessible from a various kind of systems (MapInfo, Intergraph, ESRI,...even SQL native) ." This implies an Oracle 8/9i spatial repository can be shared across a variety of software - which would be wonderful. This isn't true in our experience of ESRI - because their SDE software is middleware which will use a range of RDBMS to store spatial types, if you are hoping to use other software to maintain the same data its unlikely to work. VIEW access might be OK - "don't know" in case any lawyers are reading - but SDE only maintains its own indices. The Oracle Spatial indices to support MapInfo or anyone else are different. Also a very big "don't know at all" about Intergraph for the same reason. Theres nothing wrong in this - all the manufacturers have their own proprietary format and the ESRI products will all talk to SDE on 8/9i - but you should be cautious in thinking a spatial 'repository' maintained through SDE will work optimally or at all with any other manufacturers products just because it happens to be using Oracle Spatial. And presumably vice-versa. Its the difference between 'in the database' and 'using the database'. BTW I'd LOVE to be contradicted on this. Paul Crisp Syntegra Direct: 0191 461 4522 Mobile: 0776 414 3762 Fax: (0191) 461 1959 Innovation Place Metro Riverside Park Delta Bank Road Gateshead Tyne & Wear NE11 9DJ -----Original Message----- From: Markus Lindner [mailto:[EMAIL PROTECTED]] Sent: 22 January 2002 13:45 To: [EMAIL PROTECTED]; MapInfo-L Subject: Re: MI-L Oracle 9i Spatial: who else? I think you cannot measure the two different philosophies and compare the results. Spatialware is an Extender on SQLServer only for the use with Mapinfo products, Oracle 8i Spatial is a GIS independendent way of storing Spatial Data and making it accessible from a various kind of systems (MapInfo, Intergraph, ESRI,...even SQL native) . And by the way there is a lot of tuning possibilities inside Oracle 8i, read the docs, ask your Oracle Admin, and have a deep look at your data, i am sure that there is a great potential tuning it, but there is no cook-book for that, it depends on the data, the way you look at it, and and and.... Regards, Markus ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 22, 2002 2:28 PM Subject: Re: MI-L Oracle 9i Spatial: who else? > > Hi > We r also seriously working on Oracle Spatial with MapInfo product > range, and would like to add some comments to the ongoing discussion. > I'm having two databases SQL server 7.0 (with Spatialware4.5 trial version) > and Oracle8i spatial > > Both my databases are populated with a set of 23 layers, populated through > EasyLoader. > Now when I load a Workspace with "Live Access" in MI 6.5, the > SQL-Spatialware loads the workspace in less than 50 sec and it takes about > 170 sec for the Oracle spatial database to load the same workspace.. > > Any comments on this observation..?? > Is it something to do about Spatialware being native to MapInfo and the way > Oracle stores spatial data..?? > > Regards > Kaul, Deepak > Software Engineer > RMSI, NOIDA > INDIA > > > > _______________________________________________________________________ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. > _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.syntegra.com ******************************************************************** _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
