How Poor Is the "Poor Man's Search Engine"?

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?

[1]  Twittie Senivongse,et al.  SQL antipatterns detection and database refactoring process , 2017, 2017 18th IEEE/ACIS International Conference on Software Engineering, Artificial Intelligence, Networking and Parallel/Distributed Computing (SNPD).

[2]  Anthony Cleve,et al.  A Static Code Smell Detector for SQL Queries Embedded in Java Code , 2017, 2017 IEEE 17th International Working Conference on Source Code Analysis and Manipulation (SCAM).

[3]  Klemens Böhm,et al.  Cleaning Antipatterns in an SQL Query Log , 2018, IEEE Transactions on Knowledge and Data Engineering.

[4]  Marcelo Soares Pimenta,et al.  Twenty years of object-relational mapping: A survey on patterns, solutions, and their implications on application design , 2017, Inf. Softw. Technol..

[5]  Erki Eessaar,et al.  On Query-Based Search of Possible Design Flaws of SQL Databases , 2015 .

[6]  Erki Eessaar,et al.  Using SQL Queries to Evaluate the Design of SQL Databases , 2015 .