Skip to main content
SpringerLink
Log in

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

  • Conference paper
  • First Online:
Beyond Databases, Architectures and Structures. Facing the Challenges of Data Proliferation and Growing Variety (BDAS 2018)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 928))

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Amer-Yahia, S., Botev, C.: TeXQuery: A full text search extension to XQuery. WWW (2004)

    Google Scholar 

  2. Amer-Yahia, S., Koudas, N., Marian, A., Srivastava, D., Toman, D.: Content and structure for storing for xml. VLDB (2005)

    Google Scholar 

  3. Baeza-Yates, R., Ribiero-Neto, B.: Modern Information Retreival. Addison Wesley (1999)

    Google Scholar 

  4. Brown, E.: Fast evaluation of structured queries for information retrieval. SIGIR (1999)

    Google Scholar 

  5. Carmel, D., Maarek, Y., Mandelbrod, M., Mass, Y., Soffer, A.: Searching XML documents via XML fragments. SIGIR (2003)

    Google Scholar 

  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. Cohen, S., Mamou, J., Kanza, Y., Sagiv, Y.: Xsearch: A semantic search engine for XML. VLDB (2003)

    Google Scholar 

  8. Florescu, D., Kossmann, D.: Integrating keyword search into XML query processing. WWW (2000)

    Google Scholar 

  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. Grabs, T., Schek, H.: Flexible information on retrieval from XML with Power-DB-XML. In: INEX Workshop (2002)

    Google Scholar 

  11. ISO/IEC: ISO/IEC 9075–2:2016 Information technology: Database language SQL - Part 2: Foundations (2016)

    Google Scholar 

  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. Melton, J., Eisenberg, A.: SQL multimedia and application packages. SIGMOD Rec. 30 (2001)

    Google Scholar 

  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. Oracle: Oracle text (2017). http://www.oracle.com/technetwork/testcontent/11goracletexttwp-133192.pdf. Accessed 25 Nov 2017

  16. Petkovic, D.: JSON integration in relational database systems. IJCA 168 (2017)

    Google Scholar 

  17. Petkovic, D.: SQL Server 2016: A Beginner’s Guide. McGraw Hill (2017)

    Google Scholar 

  18. Petkovic, D.: SQL/JSON standard: Properties and deficiencies. Datenbank Spektrum 17 (2017)

    Google Scholar 

  19. Theobald, A., Weikum, G.: Adding relevance to XML. WebDB (2000)

    Google Scholar 

  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. http://www.wiscorp.com/pub/DM32.2-2014-00025r1-sql-json-part-1.pdf

  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. http://www.wiscorp.com/pub/DM32.2-2014-00025r1-sql-json-part-2.pdf

Download references

Author information

Authors and Affiliations

  1. University of Applied Sciences, Hochschulstr. 1, 83024, Rosenheim, Germany

    DuĊĦan Petkovic

Authors
  1. DuĊĦan Petkovic
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to DuĊĦan Petkovic .

Editor information

Editors and Affiliations

  1. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    StanisĊ‚aw Kozielski

  2. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Dariusz Mrozek

  3. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    PaweĊ‚ Kasprowski

  4. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    BoĊĵena MaĊ‚ysiak-Mrozek

  5. Institute of Informatics, Silesian University of Technology, Gliwice, Poland

    Daniel Kostrzewa

Rights and permissions

Reprints and permissions

Copyright information

Âİ 2018 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Petkovic, D. (2018). Full-Text Search Extensions for JSON Documents: Design Goals and Implementations. In: Kozielski, S., Mrozek, D., Kasprowski, P., MaĊ‚ysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. Facing the Challenges of Data Proliferation and Growing Variety. BDAS 2018. Communications in Computer and Information Science, vol 928. Springer, Cham. https://doi.org/10.1007/978-3-319-99987-6_22

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-99987-6_22

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-99986-9

  • Online ISBN: 978-3-319-99987-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation