Im very new to realm of databases. And im trying to put together a database to store parking location in a city. And I need spatial database, so that i could query something like give me all the parking location in 1km range and that sort of thing.
So far ive failed to find a decent book which explain how to achieve the things i want or a good reference
books and links which may have helps you in the past would be much appreciated.
Have a look at http://www.postgis.net/ (if you plan to use Postgres/Postgis) or google for "oracle spatial" (if using Oracle). Or if you use Hibernate have a look at www.hibernatespatial.org to see how spatial queries work within hibernate. Hibernatespatial supports differenz spatial dialects.