This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
admin:features:geo:home [2011/01/10 22:53] els created |
admin:features:geo:home [2011/03/25 15:50] deb |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ~~NOTOC~~ | ||
| + | |||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 6: | Line 8: | ||
| **[[admin:features:geo:home|Overview]]** -> [[admin:features:geo:latlong|Latitude and Longitude]] -> [[admin:features:geo:radius|Radius Distance Searches]] -> [[admin:features:geo:indexing|Indexing]] -> [[admin:features:geo:optimization|Optimization]] | **[[admin:features:geo:home|Overview]]** -> [[admin:features:geo:latlong|Latitude and Longitude]] -> [[admin:features:geo:radius|Radius Distance Searches]] -> [[admin:features:geo:indexing|Indexing]] -> [[admin:features:geo:optimization|Optimization]] | ||
| + | ---- | ||
| ==== Overview ==== | ==== Overview ==== | ||
| Line 13: | Line 16: | ||
| To support these types of searches, Omnidex provides the capability to report and search based on distances from geographic coordinates. These searches are possible using some simple Omnidex indexes paired with a [[dev:sql:functions:distance|$DISTANCE function]] available in SQL SELECT statements. This function reports the distance between two sets of coordinates, and can also be used in criteria to select rows that meet distance requirements. | To support these types of searches, Omnidex provides the capability to report and search based on distances from geographic coordinates. These searches are possible using some simple Omnidex indexes paired with a [[dev:sql:functions:distance|$DISTANCE function]] available in SQL SELECT statements. This function reports the distance between two sets of coordinates, and can also be used in criteria to select rows that meet distance requirements. | ||
| - | Current implementations of relational databases provide some support for distance calculations; however, these can be complex and costly. Some database requiring that the developer code trigonometric functions in stored procedures. Some databases do not use indexes to speed these searches. Some databases charge separately for this feature. Omnidex provides this capability in the base product. | + | Current implementations of relational databases provide some support for distance calculations; however, these can be complex and costly. Some databases require that the developer code trigonometric functions in stored procedures. Some databases do not use indexes to speed these searches. Some databases charge separately for this feature. Omnidex provides this capability in the base product. |
| ==== ==== | ==== ==== | ||
| Line 20: | Line 23: | ||
| ====== Additional Resources ====== | ====== Additional Resources ====== | ||
| + | |||
| + | See also: | ||
| * [[admin:optimization:home|Optimization Strategies]] | * [[admin:optimization:home|Optimization Strategies]] | ||
| - | * [[admin:optimization:geo:math|The Math Behind Geographic Searches]] | + | * [[admin:features:geo:math|The Math Behind Geographic Searches]] |
| * [[dev:sql:functions:distance|$DISTANCE function]] | * [[dev:sql:functions:distance|$DISTANCE function]] | ||
| {{page>:admin:features:see_also&nofooter&noeditbtn}} | {{page>:admin:features:see_also&nofooter&noeditbtn}} | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||