Skip to main content

DETEXA: Declarative Extensible Text Exploration and Analysis

  • Conference paper
  • First Online:
Linking Theory and Practice of Digital Libraries (TPDL 2022)

Abstract

Metadata enrichment through text mining techniques is becoming one of the most significant tasks in digital libraries. Due to the pandemic increase of open access publications, several new challenges have emerged. Raw data are usually big, unstructured, and come from heterogeneous data sources. In this paper, we introduce a text analysis framework which is implemented in extended SQL and exploits the scalability characteristics of modern database management systems. The purpose of this framework is to provide the opportunity to build performant end-to-end text mining pipelines which includes data harvesting, cleaning, processing, and text analysis at once. SQL is selected due to its declarative nature which offers fast experimentation and the ability to build APIs, so that domain experts can edit text mining workflows via easy-to-use graphical interfaces. Our experimental analysis demonstrates that the proposed framework is very effective and achieves significant speedup in common use cases compared to other popular approaches.

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

Access this chapter

Subscribe and save

Springer+ Basic
EUR 32.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 69.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 89.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

Similar content being viewed by others

Notes

  1. 1.

    https://www.clarin.eu/.

References

  1. NLTK. https://www.nltk.org

  2. PySpark. https://spark.apache.org/docs/latest/api/python/

  3. Dask. https://dask.org

  4. Raasveldt, M., Mühleisen, H.: Vectorized UDFs in column-stores. In: Proceedings of the 28th International Conference on Scientific and Statistical Database Management (2016)

    Google Scholar 

  5. https://www.postgresql.org/docs/current/xfunc.html

  6. https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ExtendingVertica/UDF-SQLFunctions/CreatingUser-DefinedSQLFunctions.htm

  7. Declarative Extensible Text EXploration and Analysis (DETEXA). https://github.com/madgik/detexa

  8. Foufoulas, Y., Simitsis, A., Stamatogiannakis, L., Ioannidis, Y.: YeSQL: “You extend SQL” with rich and highly performant user-defined functions in relational databases. PVLDB (2022)

    Google Scholar 

  9. OpenAIRE. https://www.openaire.eu

  10. Varoquaux, G., et al.: Scikit-learn: machine learning without learning the machinery. GetMob.: Mob. Comput. Commun. 19(1), 29–33 (2015)

    Google Scholar 

  11. Vasiliev, Y.: Natural Language Processing with Python and SpaCy: A Practical Introduction. No Starch Press (2020)

    Google Scholar 

  12. Gensim text processing library. https://radimrehurek.com/gensim

  13. Giannakopoulos, T., Stamatogiannakis, E., Foufoulas, I., Dimitropoulos, H., Manola, N., Ioannidis, Y.: Content visualization of scientific corpora using an extensible relational database implementation. In: Bolikowski, Ł, Casarosa, V., Goodale, P., Houssos, N., Manghi, P., Schirrwagen, J. (eds.) TPDL 2013. CCIS, vol. 416, pp. 101–112. Springer, Cham (2014). https://doi.org/10.1007/978-3-319-08425-1_10

    Chapter  Google Scholar 

  14. tfidf algorithm. https://www.kaggle.com/code/xfffrank/tfidf-stemming/notebook

Download references

Acknowledgements

This work is funded by EU projects OpenAIRE-Nexus (101017452) and HBP (945539). The authors would like to acknowledge Lefteris Stamatogiannakis, Mei Li Triantafillidi, Tasos Giannakopoulos and Lampros Smyrnaios for their valuable contributions in the design and implementation of the presented library.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Yannis Foufoulas .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2022 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Foufoulas, Y., Zacharia, E., Dimitropoulos, H., Manola, N., Ioannidis, Y. (2022). DETEXA: Declarative Extensible Text Exploration and Analysis. In: Silvello, G., et al. Linking Theory and Practice of Digital Libraries. TPDL 2022. Lecture Notes in Computer Science, vol 13541. Springer, Cham. https://doi.org/10.1007/978-3-031-16802-4_9

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-16802-4_9

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-16801-7

  • Online ISBN: 978-3-031-16802-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics