Integrating Distributed Data Bases in a Semantic Framework - The K-Metropolis Project

Daniela Giordano, Alfredo Torre, Salvatore Alessi, Alfio Costanzo, Alberto Faro


This paper presents how data integration is obtained in K-Metropolis, i.e. a project inspired by the Connected Government framework and supported by the Regional Government of Sicily that aims at integrating data residing on personal, commercial and municipal databases of different organizations. In response to the user queries, K-Metropolis suggests the most suitable services by a decision support system illustrated in previous works using all the data available at urban level. E-payment of the recommended commercial services is supported. On request, e-government certificates are provided to the mobile users. When needed, the data and certificates are displayed on a Google Maps based interface. In a companion paper we show how K-Metropolis is able to display on a more powerful GIS not only geo-referenced data of the public services but also thematic drawings that further qualify these data.


  1. Al-Hader, M., et al., SOA of smart city geospatial management. Third UKSim European Symposium on Computer Modeling and Simulation, EMS 7809, 2009.
  2. Aoun C., The Smart City Cornerstone: Urban Efficiency. Schneider Electric White Paper, 2013.
  3. Berdier C., Roussey C., Urban Ontologies: the Towntology Prototype towards Case Studies. Springer, 2007.
  4. Bizer C., Heath T., Berners-Lee T., 2009. Linked data - the story so far”, Int. J. Semantic Web Inf. Syst., vol.5(3).
  5. Corlan M., Flash Platform Tooling: Flash Builder. Adobe, 2009.
  6. Costanzo A., Faro A., Giordano D., Venticinque M., WiCity: A federated architecture of metropolitan databases to support mobile users in real time. Int. Conf. on Computer and Information Science, ICCIS. A Conf. of World Engineering Science and Technology Congress, ESTCON, 2012.
  7. Costanzo A., Faro A., Giordano D., WI-CITY: living, deciding and planning using mobiles in Intelligent Cities. 3rd International Conference on Pervasive and Embedded Computing and Communication Systems, PECCS 2013, Barcelona, INSTICC, 2013.
  8. Crisafi A., Giordano D., Spampinato C., GRIPLAB 1.0: Grid Image Processing Laboratory for Distributed Machine Vision Applications. Proc. 17th IEEE Int Conf on Enabling Technologies: Infrastructure for Collaborative Enterprises, WETICE 7808, IEEE, 2008.
  9. David M., Developing Websites with jQuery Mobile. Focal Press, 2011.
  10. Faro A., Giordano D., Musarra A., Ontology Based Mobility Information Systems. Proc. of Systems, Men and Cybernetics Conference, SMC'03, vol.3, 4288- 4293, IEEE, 2003.
  11. Faro A., Giordano D., Spampinato C., Evaluation of the Traffic Parameters in a Metropolitan Area by Fusing Visual Perceptions and CNN Processing of Webcam Images. IEEE Transactions on Neural Networks, Vol. 19 (6), IEEE, 2008.
  12. Faro A., Giordano D., Spampinato C., Integrating Location Tracking, Traffic Monitoring and Semantics in a Layered ITS Architecture. Intelligent Transport Systems, vol.5(3),IET, 2011.
  13. Faro A., Giordano D., Spampinato C., 2011. Adaptive background modelling integrated with luminosity sensors and occlusion processing for reliable vehicle detection”, IEEE Transactions on Intelligent Transportation Systems, Vol.12(4).
  14. Giordano D., Torre A., Salemi C., Alessi S., Faro A., An Ontology based Approach to Integrate Data and Maps in the Government Enterprise Architecture: a Case Study. Proc. 15th International Conference on Enterprise Information Systems, ICEIS, Angers, INSTICC, 2013.
  15. Hartl M., 2011. Ruby on Rails 3. Addison Wesley.
  16. Hayes. P., 2004. RDF Semantics. W3C Recommendation 10.
  17. Nebot. V., Berlanga. R., 2012. Building data warehouses with semantic data. Decision Support Systems, Vol.52(4).
  18. Offor, P.I., Vehicle Ad Hoc Network (VANET). 2012. Safety Benefits and Security Challenges. Available at SSRN:
  19. Prud'hommeaux E., Seaborne A., 2008. SPARQL Query Language for RDF. W3C Rec. 15.1.2. http://www.w3. org/TR/rdf-sparql-query/.
  20. Saha P., 2010. Government Enterprise Architecture Research Project, NUS Institute of Systems Science. http:// documents/unpan/unpan039390.pdf.
  21. Salampasis, M., Tektonidis, D., Kalogianni, E., TraceALL: A Semantic Web Framework for Food Traceability Systems. Jornal of Systems and Information Technology, Vol. 14(4), 2005.
  22. Sheth, A., Enterprise applications of semantic web, IFIP International Conference on Industrial Applications of Semantic Web. IASW2005, Finland, 2005.
  23. Smith, M. K. , Welty, C.D., McGuinness D.L., OWL Web Ontology Language Guide, W3C Recommendation. http:// www. /TR/ 2004/REC-owl-guide20040210, 2004.
  24. Telematics Reserach Group (TRG), Preview portable navigation: the future is bright for connectivity. http://www. _Jan_08.pdf,2008.
  25. Teller J., John R. Lee J.R., Catherine Roussey C., (Eds.), Ontologies for Urban Development, Springer, 2007.
  26. Teller J., Billen R., Cutting-Decelle A.F., 2010. Ontology based approaches for improving the interoperability between 3D urban models. Journal of Inf. Technology in Construction.
  27. Zhai, J., Jiang, J., Yu, Y., Li J., Ontology-based Integrated Information Platform for Digital City. IEEE Proc. of Wireless Communications, Networking and Mobile Comp., WiCOM 7808, 2008.

Paper Citation

in Harvard Style

Giordano D., Torre A., Alessi S., Costanzo A. and Faro A. (2013). Integrating Distributed Data Bases in a Semantic Framework - The K-Metropolis Project . In Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8565-59-4, pages 322-328. DOI: 10.5220/0004558203220328

in Bibtex Style

author={Daniela Giordano and Alfredo Torre and Salvatore Alessi and Alfio Costanzo and Alberto Faro},
title={Integrating Distributed Data Bases in a Semantic Framework - The K-Metropolis Project},
booktitle={Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},

in EndNote Style

JO - Proceedings of the 15th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Integrating Distributed Data Bases in a Semantic Framework - The K-Metropolis Project
SN - 978-989-8565-59-4
AU - Giordano D.
AU - Torre A.
AU - Alessi S.
AU - Costanzo A.
AU - Faro A.
PY - 2013
SP - 322
EP - 328
DO - 10.5220/0004558203220328