Design of a Java spatial extension for relational databases

Journal of Systems and Software

Volumn 84, Issue 12, 2011, Pages 2314-2323

  Martinez Llario, J ^a   Gonzalez Alcaide, M ^a  

^a UNIVERSITAT POLITÈCNICA DE VALÈNCIA   (Spain)

Author keywords

FOSS; GIS; Java; OGC; PostGIS; Spatial database

Indexed keywords

FOSS; JAVA; OGC; POSTGIS; SPATIAL DATABASE;

C (PROGRAMMING LANGUAGE); COMPUTER PROGRAMMING; COMPUTER SOFTWARE PORTABILITY; GEODESY; GEOGRAPHIC INFORMATION SYSTEMS; MAPPING; OPEN SYSTEMS; RELATIONAL DATABASE SYSTEMS;

JAVA PROGRAMMING LANGUAGE;

EID: 80053572329     PISSN: 01641212     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.jss.2011.06.072     Document Type: Article

References (30)

1. C. Arens, J. Stoter, and P. van Oosterom Modelling 3D spatial objects in a geo-DBMS using a 3D primitive Computers & Geosciences 31 2 2005 165 177 (Pubitemid 40133576)
2. I. Baca Moreno-Torres, J. de Diego Alarcón, and A. Pérez Navarro Desarrollo de un índice espacial para la extensión JASPA sobre H2 2011 Universidad Oberta Cataluña
3. M. Benedikt, and L. Libkin Aggregate operators in constraint query languages Journal of Computer and System Sciences 64 3 2002 628 654
4. D.G. Brown, R. Riolo, D.T. Robinson, M. North, and W. Rand Spatial process and data models: toward integration of agent-based models and GIS Journal of Geographical Systems 7 1 2005 25 47 (Pubitemid 40473212)
5. C. Chen, Y.C. Cheng, C. Hsieh, and I. Wu Exception handling refactorings: directed by goals and driven by bug fixing Journal of Systems and Software 82 2 2009 333 345
6. R. Chen, and J. Xie Open source databases and their spatial extensions G.B. Hall, M.G. Leahy, Open Source Approaches in Spatial Data Handling 2008 Springer Berlin Heidelberg 105 129 Available from: http://dx.doi.org/10.1007/ 978-3-540-74831-1-6
7. Davis, M.; 2006. JTS topology suite. Available from: http://www. vividsolutions.com/jts/JTSHome.htm.
8. Deoliveira, J.; 2010. GeoDB. Available from: http://github.com/jdeolive/ geodb.
9. ESRI ArcGIS 9.3 Geodatabase Topology Rules 2010 Environmental Systems Research Institute, Inc. Redlands, CA Available from: http://webhelp.esri.com/ arcgisdesktop/9.3/pdf/Topology-rules-poster.pdf.
10. R.G. Fichman, and C.F. Kemerer Incentive compatibility and systematic software reuse Journal of Systems and Software 57 1 2001 45
11. B. Goetz Java Theory and Practice: The Exceptions Debate 2004 Available from: http://www.ibm.com/developerworks/java/library/j-jtp05254.html
12. R. Groot, and J. McLaughlin Geospatial Data Infrastructure. Concepts, Cases and Good Practice 2000 Oxford University Press Oxford
13. H2, 2010. H2 Documentation. Version 1.3.146. Available from: http://www.h2database.com/h2.pdf.
14. ISO/IEC 13249-3:2006, 2006. Information technology - database languages - SQL multimedia and application packages - part 3: spatial.
15. A.T. Kralidis Geospatial open source and open standards convergences Advances in Geographic Information Science 2 2008 1 20 Available from: http://dx.doi.org/10.1007/978-3-540-74831-1-1
16. J. Martinez-Llario, J.H. Weber-Jahnke, and E. Coll Improving dissolve spatial operations in a simple feature model Advances in Engineering Software 40 3 2009 170 175
17. N. Matthew, and R. Stones Beginning Databases with postgreSQL: From Novice to Professional 2005 Apress New York
18. OpenGIS Consortium OpenGIS Simple Features Specification for SQL, Revision 1.1 1999 OpenGIS Project Document 99-049
19. OpenGIS Consortium, 2006. OpenGIS implementation specification for geographic information - simple feature access - part 2: SQL option (revision 1.2.1 ed.). Available from: http://www.opengeospatial.org/standards/sfs.
20. PL/Java, 2006. PL/Java 1.2 user guide. Available from: http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pljava/org.postgresql.pljava/docs/ userguide.html?rev=1.15#Type-mapping-.
21. PostgreSQL, 2009. PostgreSQL 8.4.5 documentation. Available from: http://www.postgresql.org/docs/8.4/interactive/index.html.
22. Ramsey, P.; 2007. The state of open source GIS. In: Paper Presented at the Vancouver, BC, Canada. Available from: http://www.foss4g2007.org/ presentations/viewattachment.php?attachment-id=8.
23. T. Soler, and L.D. Hothem Coordinate systems used in geodesy: basic definitions and concepts Journal of Surveying Engineering 114 2 1988 84 97
24. S. Steiniger, and G.J. Hay Free and open source geographic information tools for landscape ecology Ecological Informatics 4 4 2009 183 195
25. Stolze, K.; 2003. Sql/mm spatial: the standard to manage spatial data in relational database systems. In: Paper Presented at the Proceedings of the BTW, LNI P-26, pp. 247-264.
26. P. Van Oosterom, J. Stoter, W. Quak, and S. Zlatanova The balance between geometry and topology Paper Presented at the Advances in Spatial Data Handling 10th International Symposium on Spatial Data Handling 2002 209 224
27. T. Vijlbrief, and P. van Oosterom The GEO++ system: an extensible GIS Proceedings of the 5th International Symposium on Spatial Data Handling Charleston, South Carolina 1992 40 50
28. S. Zakhour, S. Hommel, J. Royal, I. Rabinovitch, T. Risser, and M. Hoeber Exceptions. The Java Tutorial: A Short Course on the Basics 4th edition java series (4th ed.) 2006 Prentice Hall PTR Upper Saddle River, NJ
29. S. Zlatanova 3D geometries in spatial DBMS W. Cartwright, Innovations in 3D Geo Information Systems 2006 Springer Berlin, Heidelberg 1 14 Available from: http://dx.doi.org/10.1007/978-3-540-36998-1-1
30. S. Zlatanova, and J. Stoter The role of DBMS in the new generation GIS architecture S. Rana, J. Sharma, Frontiers of Geographic Information Technology 2006 Springer Berlin Heidelberg 155 180 Available from: http://dx.doi.org/10. 1007/3-540-31305-2-8