CFP last date
22 April 2024
Reseach Article

An Approach to Query Processing in Homogenously Distributed Spatial Databases

by Monika Yadav
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 140 - Number 9
Year of Publication: 2016
Authors: Monika Yadav
10.5120/ijca2016909431

Monika Yadav . An Approach to Query Processing in Homogenously Distributed Spatial Databases. International Journal of Computer Applications. 140, 9 ( April 2016), 1-5. DOI=10.5120/ijca2016909431

@article{ 10.5120/ijca2016909431,
author = { Monika Yadav },
title = { An Approach to Query Processing in Homogenously Distributed Spatial Databases },
journal = { International Journal of Computer Applications },
issue_date = { April 2016 },
volume = { 140 },
number = { 9 },
month = { April },
year = { 2016 },
issn = { 0975-8887 },
pages = { 1-5 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume140/number9/24619-2016909431/ },
doi = { 10.5120/ijca2016909431 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T23:41:46.720701+05:30
%A Monika Yadav
%T An Approach to Query Processing in Homogenously Distributed Spatial Databases
%J International Journal of Computer Applications
%@ 0975-8887
%V 140
%N 9
%P 1-5
%D 2016
%I 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.
Index Terms

Computer Science
Information Sciences

Keywords

Database Fragmentation Query Execution Query Fragmentation and Query Redirection.