# SNAL: Spatial Network Algebra for Modeling Spatial Networks in Database Systems

### Lin Qi, Huiyuan Zhang, Markus Schneider

#### Abstract

Spatial networks such as road networks, river networks, telephone networks, and power networks are ubiquitous spatial concepts deployed, for example, in route planning, communication services, high voltage grid topology analysis, and utility management. Current database systems are unable to efficiently handle, represent, store, query, and manipulate large spatial networks. Moreover, data models of spatial networks in a database context are rare due to their inherently complex nature. This paper offers a conceptual foundation called Spatial Network Algebra (SNAL) for designing, characterizing, and representing spatial networks. A general-purpose abstract model is proposed as a specification for a later implementation of spatial networks in different environments such as spatial database systems and GIS.

#### References

- Brinkhoff, T. (2002). A framework for generating networkbased moving objects. In Geoinformatica, volume 6, pages 153-180.
- Ding, Z., Yang, B., Güting, R., and Li, Y. (2015). Networkmatched trajectory-based moving-object database: Models and applications. IEEE Transactions on Intelligent Transportation Systems, Article in press.
- Dugundi, J. (1966). Topology. Allyn and Bacon.
- Egenhofer, M. J. and Herring, J. (1990). Categorizing binary topological relations between regions, lines, and points in geographic databases. In for Geographic Information, N. C. and Analysis, University of California, S.B.S.B. C., editors, Tech. rep.90-12.
- , R. (1994). Explicit graphs in a functional model for spatial databases. Knowledge and Data Engineering, IEEE Transactions on, 6(5):787-804.
- Gupta, S., Kopparty, S., and Ravishankar, C. (2004). Roads, codes, and spatiotemporal queries. In Proceedings of the 23rd ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, pages 115- 124.
- Güting, R. (1994). Graphdb: Modeling and querying graphs in databases. In 20th Int. Conf. on Very Large Databases, pages 297-308.
- Güting, R., Almeida, V., and Ding, Z. (2006). Modeling and querying moving objects in networks. In The VLDB Journal, volume 15, pages 165-190.
- Jensen, C., Pedersen, T., Speicys, L., and Timko, I. (2003). Data modeling for mobile services in the real world. In Int. Conf. on Advances in Spatial and Temporal Databases, pages 1-9.
- Jeung, H., Yiu, M., Zhou, X., and Jensen, C. (2010). Path prediction and predictive range querying in road network databases. In The VLDB Journal, volume 19, pages 585-602.
- Krogh, B., Pelekis, N., Theodoridis, Y., and Torp, K. (2014). Path-based queries on trajectory data. In 22nd ACM SIGSPATIAL Int. Conf. on Advances in Geographic Information Systems (ACM SIGSPATIAL GIS).
- Liu, H. and Schneider, M. (2010). Detecting the topological development in a complex moving region. Journal of Multimedia Processing and Technologies (JMPT), 1(3):160-180.
- McKenney, M. and Schneider, M. (2007). Spatial partition graphs: A graph theoretic model of maps. In Advances in Spatial and Temporal Databases, pages 167-184. Springer.
- Miller, H. and Shaw, S. (2001). Geographic Information Systems for Transportation. Oxford University Press.
- Popa, I. S., Zeitouni, K., Oria, V., Barth, D., and Vial, S. (2011). Indexing in-network trajectory flows. In The VLDB Journal, volume 20, pages 643-669.
- Qi, L. and Schneider, M. (2012). Monet: Modeling and querying moving objects in spatial networks. In 3rd ACM SIGSPATIAL Int. Workshop on GeoStreaming (IWGS).
- Qi, L., Zhang, H., and Schneider, M. (2015). Design and representation of complex objects in database systems. In 23rd ACM SIGSPATIAL Int. Conf. on Advances in Geographic Information Systems (ACM SIGSPATIAL GIS).
- Scheider, S. and Kuhn, W. (2008). Road networks and their incomplete representation by network data models. In GIScience 7808: Proceedings of the 5th International Conference on Geographic Information Science, pages 290-307.
- Schneider, M. (1997). Spatial Data Types for Database Systems - Finite Resolution Geometry for Geographic Information Systems. LNCS 1288, Springer-Verlag.

#### Paper Citation

#### in Harvard Style

Qi L., Zhang H. and Schneider M. (2016). **SNAL: Spatial Network Algebra for Modeling Spatial Networks in Database Systems** . In *Proceedings of the 2nd International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,* ISBN 978-989-758-188-5, pages 145-152. DOI: 10.5220/0005880001450152

#### in Bibtex Style

@conference{gistam16,

author={Lin Qi and Huiyuan Zhang and Markus Schneider},

title={SNAL: Spatial Network Algebra for Modeling Spatial Networks in Database Systems},

booktitle={Proceedings of the 2nd International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,},

year={2016},

pages={145-152},

publisher={SciTePress},

organization={INSTICC},

doi={10.5220/0005880001450152},

isbn={978-989-758-188-5},

}

#### in EndNote Style

TY - CONF

JO - Proceedings of the 2nd International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,

TI - SNAL: Spatial Network Algebra for Modeling Spatial Networks in Database Systems

SN - 978-989-758-188-5

AU - Qi L.

AU - Zhang H.

AU - Schneider M.

PY - 2016

SP - 145

EP - 152

DO - 10.5220/0005880001450152