Skip to main content

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

Abstract

The modern world generates huge amounts of documents each day. Text data is ubiquitous in the digital space. They can contain information about products in an online store, the opinions of a blog author, reportage in a newspaper or questions and advice from online forums. Most of this data is managed using DBMS - mainly relational ones. Thus, the more crucial it becomes to find the most efficient use of the available text search mechanisms. This work examines the basic word search methods in the two of the most popular open DBMS: PostgreSQL and MariaDB. The results of the empirical tests will serve as a starting point for discussion is the “Poor Man’s Search Engine” SQL antipattern still an antipattern?

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

Access this chapter

Subscribe and save

Springer+ Basic
$34.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

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. Arzamasova, N., Schäler, M., Böhm, K.: Cleaning antipatterns in an SQL query log. IEEE Trans. Knowl. Data Eng. 30(3), 421–434 (2018)

    Article  Google Scholar 

  2. Eessaar, E.: On query-based search of possible design flaws of SQL databases. In: Sobh, T., Elleithy, K. (eds.) Innovations and Advances in Computing, Informatics, Systems Sciences, Networking and Engineering. LNEE, vol. 313, pp. 53–60. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-06773-5_8

    Chapter  Google Scholar 

  3. Eessaar, E., Voronova, J.: Using SQL queries to evaluate the design of SQL databases. In: Elleithy, K., Sobh, T. (eds.) New Trends in Networking, Computing, E-learning, Systems Sciences, and Engineering. LNEE, vol. 312, pp. 179–186. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-06764-3_23

    Chapter  Google Scholar 

  4. Karwin, B.: SQL Antipatterns. The Pragmatic Bookshelf (2010)

    Google Scholar 

  5. Khumnin, P., Senivongse, T.: SQL antipatterns detection and database refactoring process. In: 2017 18th IEEE/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel/Distributed Computing (SNPD), pp. 199–205. IEEE (2017)

    Google Scholar 

  6. Korotkov, A.: Index support for regular expression search. In: Proceedings of PostgreSQL Conference (2012)

    Google Scholar 

  7. Nagy, C., Cleve, A.: A static code smell detector for SQL queries embedded in Java code. In: 2017 IEEE 17th International Working Conference on Source Code Analysis and Manipulation (SCAM), pp. 147–152. IEEE (2017)

    Google Scholar 

  8. Torres, A., Galante, R., Pimenta, M.S., Martins, A.J.B.: Twenty years of object-relational mapping: a survey on patterns, solutions, and their implications on application design. Inf. Softw. Technol. 82, 1–18 (2017)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Marta Burzańska .

Editor information

Editors and Affiliations

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

Burzańska, M., Wiśniewski, P. (2018). How Poor Is the “Poor Man’s Search Engine”?. 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_23

Download citation

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

  • 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