Full-Text Search Extensions for JSON Documents: Design Goals and Implementations

  • Dušan PetkovicEmail author
Conference paper
Part of the Communications in Computer and Information Science book series (CCIS, volume 928)


One of main advantages of JSON (JavaScript Object Notation) is to represent structured as well as semi-structured data at the same time. Although the existing SQL/JSON standard specifies the way, how queries in relation to exact search can be preformed, it lacks the support for queries concerning full-text search. In this article we propose a set of design goals that full-text search extension of the SQL/JSON language should support. Additionally, the given set is valid for any full-text search language in relation to JSON documents. Also, we discuss full-text language extensions implemented in relational database systems concerning JSON documents and answer the question to what extent the extensions are supported by these systems.


JSON SQL/JSON Full-text search JSON integration Design goals 


  1. 1.
    Amer-Yahia, S., Botev, C.: TeXQuery: A full text search extension to XQuery. WWW (2004)Google Scholar
  2. 2.
    Amer-Yahia, S., Koudas, N., Marian, A., Srivastava, D., Toman, D.: Content and structure for storing for xml. VLDB (2005)Google Scholar
  3. 3.
    Baeza-Yates, R., Ribiero-Neto, B.: Modern Information Retreival. Addison Wesley (1999)Google Scholar
  4. 4.
    Brown, E.: Fast evaluation of structured queries for information retrieval. SIGIR (1999)Google Scholar
  5. 5.
    Carmel, D., Maarek, Y., Mandelbrod, M., Mass, Y., Soffer, A.: Searching XML documents via XML fragments. SIGIR (2003)Google Scholar
  6. 6.
    Chinenyanga, T., Kushmerick, N.: Expressive and efficient ranked querying of XML data. In: SIGIR Workshop on XML and Information Retrieval (2001)Google Scholar
  7. 7.
    Cohen, S., Mamou, J., Kanza, Y., Sagiv, Y.: Xsearch: A semantic search engine for XML. VLDB (2003)Google Scholar
  8. 8.
    Florescu, D., Kossmann, D.: Integrating keyword search into XML query processing. WWW (2000)Google Scholar
  9. 9.
    Fuhr, N., Grossjohann, K.: XIRQL: An extension of XQL for information retrieval. In: SIGIR Workshop on XML and Information Retrieval (2000)Google Scholar
  10. 10.
    Grabs, T., Schek, H.: Flexible information on retrieval from XML with Power-DB-XML. In: INEX Workshop (2002)Google Scholar
  11. 11.
    ISO/IEC: ISO/IEC 9075–2:2016 Information technology: Database language SQL - Part 2: Foundations (2016)Google Scholar
  12. 12.
    ISO/IEC: ISO/IEC TR 19075–6:2017 Information technology: Database language SQL Technical Reports - Part 6: SQL support for JavaScript Object Notation (JSON) (2017)Google Scholar
  13. 13.
    Melton, J., Eisenberg, A.: SQL multimedia and application packages. SIGMOD Rec. 30 (2001)Google Scholar
  14. 14.
    Naughton, J., DeWitt, D., Maier, D., Aboulnaga, A., Chen, J., Galanis, L.: Niagara internet query system. IEEE Data Eng. Bull. 24 (2001)Google Scholar
  15. 15.
    Oracle: Oracle text (2017). Accessed 25 Nov 2017
  16. 16.
    Petkovic, D.: JSON integration in relational database systems. IJCA 168 (2017)Google Scholar
  17. 17.
    Petkovic, D.: SQL Server 2016: A Beginner’s Guide. McGraw Hill (2017)Google Scholar
  18. 18.
    Petkovic, D.: SQL/JSON standard: Properties and deficiencies. Datenbank Spektrum 17 (2017)Google Scholar
  19. 19.
    Theobald, A., Weikum, G.: Adding relevance to XML. WebDB (2000)Google Scholar
  20. 20.
    Zemke, F., Hammerschmidt, B., Kulkarni, K., Liu, Z., McMahon, D., Melton, J., Michels, J., Oezcan, F., Pirahesh, H.: ANSI SQL/JSON: Part 1 (2017). Accessed 25 Nov 2017.
  21. 21.
    Zemke, F., Hammerschmidt, B., Kulkarni, K., Liu, Z., McMahon, D., Melton, J., Michels, J., Oezcan, F., Pirahesh, H.: ANSI SQL/JSON: Part 2 : Querying JSON (2017). Accessed 25 Nov 2017.

Copyright information

© Springer Nature Switzerland AG 2018

Authors and Affiliations

  1. 1.University of Applied SciencesRosenheimGermany

Personalised recommendations