Call for Paper - August 2020 Edition
IJCA solicits original research papers for the August 2020 Edition. Last date of manuscript submission is July 20, 2020. Read More

An Approach to Query Processing in Homogenously Distributed Spatial Databases

Print
PDF
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Year of Publication: 2016
Authors:
Monika Yadav
10.5120/ijca2016909431

Monika Yadav. Article: An Approach to Query Processing in Homogenously Distributed Spatial Databases. International Journal of Computer Applications 140(9):1-5, April 2016. Published by Foundation of Computer Science (FCS), NY, USA. BibTeX

@article{key:article,
	author = {Monika Yadav},
	title = {Article: An Approach to Query Processing in Homogenously Distributed Spatial Databases},
	journal = {International Journal of Computer Applications},
	year = {2016},
	volume = {140},
	number = {9},
	pages = {1-5},
	month = {April},
	note = {Published by Foundation of Computer Science (FCS), NY, USA}
}

Abstract

Query processing in distributed environment is basic need of many organizations in order to process huge amount of data in less amount of time. There are many approaches provided for parallel query processing in distributed environment. This paper presents the approach which does the parallel query processing in 4 steps. Firstly query fragmentation is done by using SQL parsing, then query redirection to the specified servers containing remotely distributed databases ,then query execution take place at both the servers and at last result of both part of query transferred to Local server where it get accumulated. Then result gets displayed on Geoserver. Different fragmentation techniques are also discussed in order to store fragmented data on distributed sites.

References

  1. Stefano Ceri, Giuseppe Pelagatti, “Levels of Distributed Transparency, Distributed Database Design,, Translation of Global Query to Fragment Query,” in Distributed Databases: Principles and Systems, pg-37-126.
  2. Monika Yadav, Neha Arora, “Fragmentation Techniques for Distributed Storage of Spatial Data”, Proceedings of IRF International Conference, 5th & 6th February 2014, Pune India.
  3. PostGIS Reference, [Online] Available: http://postgis.refractions.net/documentation/manual-1.3/ch06.html
  4. Spatial Functions, [Online] Available: http://postgis.refractions.net/docs/ST_Intersects.html
  5. Features of pgpool, [Online] Available:http://pgpool.projects.postgresql.org/
  6. Pgpool tutorial, [Online] Available: http://pgpool.projects.postgresql.org/pgpool-II/doc/tutorial-en.html.
  7. PgpoolAdmin features and installation, [Online] Available: http://pgpool.projects. postgresql.org/pgpoolAdmin/doc/en/install.html
  8. Dblink description, [Online] Available: http://www.postgresonline.com/journal/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html
  9. Geoserver-2.1 User Manual, [Online] Available:http://docs.geoserver.org/stable/en/user/
  10. Geoserver Information, [Online] Available: http://workshops.opengeo.org/
  11. 2010 TIGER/Line Shapefiles Technical Documentation. [Online] Available: http://catalog.data.gov/dataset/tiger-line-shapefile-2010-series-information-file-for-the-2010-census-block-state-based-shapefi.
  12. S.Bandhopadhyay, DataManagement (New Dimension and Perspectives), Join Processing in multidatabase.
  13. P.Bernstein, N.Goodman, E.W ong, C.Reev and J.Rothnie, Query Processing in a System for Distributed Databases.

Keywords

Database Fragmentation, Query Execution, Query Fragmentation and Query Redirection.