Enhanced Querying of Open Data Portals

  • Mauro Pelucchi
  • Giuseppe PsailaEmail author
  • Maurizio Toccu
Conference paper
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 322)


Open Data portals have become a common service provided by many Public Administrations around the world, where they openly publish many data sets concerning citizens and territories, in order to increase the amount of information made available for people, firms and public administrators. As an effect, Open Data corpora has become so huge that it is impossible to deal with them by hand; as a consequence, it is necessary to develop tools for effectively querying corpora of open data, in order to find the desired data sets.

In our previous work [1], we presented a novel technique to query open data corpora. In this paper, we present an evolution of that technique, obtained by refining some steps and by introducing some novelties. We still rely on the blindly querying approach: the user does not have to know in advance the actual structure of possibly thousands of data sets, but formulates the query trying to characterize the items of interests; in fact, a novelty of our approach is that our technique looks for single items within data sets, not for data sets. Then, the technique tries to rewrite the query by exploiting the catalog of the corpus in order to find the most similar and relevant terms.

The main enhancement introduced in the technique and presented in this paper is the way the technique looks for similar terms in the catalog, that now is based on a semantic approach: the WordNet dictionary is exploited to get synonyms of terms in the query. Furthermore, a new set of experiments has been performed, in order to prove the effectiveness of the enhanced technique.


  1. 1.
    Pelucchi, M., Psaila, G., Toccu, M.: Building a query engine for a corpus of open data. In: Proceedings of the 13th International Conference on Web Information Systems and Technologies (WEBIST-2917) INSTICC, pp. 126–136. ScitePress, Porto (2017)Google Scholar
  2. 2.
    Manning, C.D., Raghavan, P., Schütze, H., et al.: Introduction to Information Retrieval, vol. 1. Cambridge University Press, Cambridge (2008)CrossRefGoogle Scholar
  3. 3.
    Miller, G.A.: Wordnet: a lexical database for English. Commun. ACM 38, 39–41 (1995)CrossRefGoogle Scholar
  4. 4.
    Winkler, W.E.: The state of record linkage and current research problems. In: Statistical Research Division, US Census Bureau, Citeseer (1999)Google Scholar
  5. 5.
    Jaro, M.A.: Advances in record-linkage methodology as applied to matching the 1985 census of Tampa, Florida. J. Am. Statis. Assoc. 84, 414–420 (1989)CrossRefGoogle Scholar
  6. 6.
    Liu, J., Dong, X., Halevy, A.Y.: Answering structured queries on unstructured data. In: WebDB, vol. 6, Citeseer, Chicago, Illinois, USA, pp. 25–30 (2006)Google Scholar
  7. 7.
    Pelucchi, M., Psaila, G., Toccu, M.: The challenge of using map-reduce to query open data. In: Proceedings of the 6th International Conference on Data Science Technologies and Applications DATA-2017, INSTICC. ScitePress, Madrid (2017)Google Scholar
  8. 8.
    Shahi, D.: Apache solr: An introduction. In: Apache Solr. Springer, Heidelberg, pp. 1–9 (2015). Scholar
  9. 9.
    Khosro, S.C., Jabeen, F., Mashwani, S., Alam, I.: Linked open data: towards the realization of semantic web - a review. Indian J. Sci. Technol. 7, 745–764 (2014)Google Scholar
  10. 10.
    Miller, E.: An introduction to the resource description framework. Bull. Am. Soc. Inf. Sci. Technol. 25, 15–19 (1998)CrossRefGoogle Scholar
  11. 11.
    Clark, K.G., Feigenbaum, L., Torres, E.: Sparql protocol for rdf. World Wide Web Consortium (W3C) Recommendation, p. 86 (2008)Google Scholar
  12. 12.
    Auer, S., Bizer, C., Kobilarov, G., Lehmann, J., Cyganiak, R., Ives, Z.: DBpedia: a nucleus for a web of open data. In: Aberer, K., et al. (eds.) ASWC/ISWC - 2007. LNCS, vol. 4825, pp. 722–735. Springer, Heidelberg (2007). Scholar
  13. 13.
    Schwarte, A., Haase, P., Hose, K., Schenkel, R., Schmidt, M.: Fedx: a federation layer for distributed query processing on linked open data. In: The Semantic Web: Research and Applications. Extended Semantic Web Conference, vol. 6644, pp. 481–486. Springer, Heidelberg (2011).
  14. 14.
    Kononenko, O., Baysal, O., Holmes, R., Godfrey, M.: Mining modern repositories with elastic search. In: MSR, Hyderabad, India, 29–30 June 2014Google Scholar
  15. 15.
    Gormley, C., Tong, Z.: Elasticsearch: The Definitive Guide: A Distributed Real-Time Search and Analytics Engine. O’Reilly Media, Inc., Massachusetts (2015)Google Scholar
  16. 16.
    Bordogna, G., Capelli, S., Psaila, G.: A big geo data query framework to correlate open data with social network geotagged posts. In: Bregt, A., Sarjakoski, T., van Lammeren, R., Rip, F. (eds.) GIScience 2017. LNGC, pp. 185–203. Springer, Cham (2017). Scholar
  17. 17.
    Bordogna, G., Ciriello, D.E., Psaila, G.: A flexible framework to cross-analyze heterogeneous multi-source geo-referenced information: the J-CO-QL proposal and its implementation. In: Proceedings of the International Conference on Web Intelligence, pp. 499–508. ACM (2017)Google Scholar

Copyright information

© Springer International Publishing AG, part of Springer Nature 2018

Authors and Affiliations

  • Mauro Pelucchi
    • 1
  • Giuseppe Psaila
    • 1
    Email author
  • Maurizio Toccu
    • 1
  1. 1.University of BergamoBergamoItaly

Personalised recommendations