Skip to main content
Top

2018 | OriginalPaper | Chapter

How Poor Is the “Poor Man’s Search Engine”?

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

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?

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
1.
go back to reference 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)CrossRef 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)CrossRef
4.
go back to reference Karwin, B.: SQL Antipatterns. The Pragmatic Bookshelf (2010) Karwin, B.: SQL Antipatterns. The Pragmatic Bookshelf (2010)
5.
go back to reference 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) 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)
6.
go back to reference Korotkov, A.: Index support for regular expression search. In: Proceedings of PostgreSQL Conference (2012) Korotkov, A.: Index support for regular expression search. In: Proceedings of PostgreSQL Conference (2012)
7.
go back to reference 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) 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)
8.
go back to reference 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)CrossRef 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)CrossRef
Metadata
Title
How Poor Is the “Poor Man’s Search Engine”?
Authors
Marta Burzańska
Piotr Wiśniewski
Copyright Year
2018
DOI
https://doi.org/10.1007/978-3-319-99987-6_23

Premium Partner