All
I have recently been handed the reins of a GeoServer 2.0.2 installation (I’m a newbie) and I am currently migrating this installation to new hardware architecture. During our initial testing our Oracle DBA noticed that the SDO_FILTER is being used in potentially incompatible way (Oracle 11gR2 being used);
SDO_FILTER is being written as follows:
SDO_FILTER(GEOM, :1, 'mask=anyinteract querytype=WINDOW') = 'TRUE'
``
*Extract from GeoServer Log –*
``
*2011-04-15 09:19:50,724 DEBUG [geotools.jdbc] - SELECT ….. WHERE (SDO_FILTER(GEOM, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE' AND (THEME != ? OR (THEME = ? AND MAKE = ?) OR (THEME = ? AND MAKE = ?)))*
``
I am informed by my DBA that the SDO_FILTER should not have a mask defined. The DBA is actually surprised that Oracle is not falling over with an “incorrect parameters/arguments being used” error. The DBA also informs me that the querytype=WINDOW is deprecated and no longer required but it is not an issue as Oracle ignores it. Oracle is quietly ignoring the mask=anyinteract argument instead of raising an error and executing the SDO_FILTER operation.
``
DBA informs me that the SDO_FILTER should look like
``
SDO_FILTER(GEOM, :1) = 'TRUE'
The question the DBA raised to me which I need some help on is whether GeoServer is actually trying to execute an ANYINTERACT mask against the data as this would returns fewer rows than SDO_FILTER?
The DBA suggested that if GeoServer is trying to execute an ANYINTERACT mask then this should be using either SDO_RELATE with mask=anyinteract or SDO_ANYINTERACT.
SDO_RELATE(GEOM, :1, 'mask=anyinteract') = 'TRUE'
OR
SDO_ANYINTERACT(GEOM, :1) = 'TRUE'
It came to light as Oracle has released a performance improvement patch for the ANYINTERACT spatial operations and our DBA was searching to see if GeoServer utilised the ANYINTERACT capability.
Please could I have some feedback?
· Especially if this would be resolved by upgrading to 2.0.3
· Is it potentially fixed in 2.1.*
· Have I posted this to the incorrect mailing list and it should have been the Developer List for review
Regards
Russel
Russel Tinnion
GIS Architect & Key IT Account Manager
Direct dial 01793 714817
Mobile 07977 256809
Email Russel.Tinnion@anonymised.com
Fax 0844 2499201
Helpdesk 0844 249 9200
TM Group (UK) Limited
200 Delta Business Park l Swindon l Wiltshire l SN5 7XD
www.tmgroup.co.uk
TM Group includes
TM Property Searches Limited www.tmpropertysearches.co.uk
TM Search Choice Limited www.tmsearchchoice.co.uk
TM Property Searches Limited (company number 03775703) and TM Search Choice Limited (company number 05281723) are wholly owned subsidiaries of TM Group (UK) Limited (company number 05278187). TM Group and its subsidiaries are registered in England: 200 Delta Business Park, Swindon, Wiltshire, SN5 7XD and are appointed representatives of First Title Insurance plc which is authorised and regulated by the Financial Services Authority.
From time to time we would like to contact you with details of products, services and other events that may be of interest to you. We respect your privacy and will not share your personal data with any third parties outside TM Group. If you do NOT wish to receive such information please email info@anonymised.com.
The information in this email is confidential and is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any use, disclosure, copying, distribution or retention of any part of it is prohibited and may be unlawful.
Any views or opinions expressed are solely those of the author and do not necessarily represent those of TM Group Limited. If you have received this communication in error please notify us by email or by telephone 0844 2499200 and then delete the email and any copies.
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk