Full-Text Search Engine using MySQL

  • Cornelia Gyorodi Department of Computer Science Faculty of Electrical Engineering and Information Technology University of Oradea, Str. Universitatii 1, 410087, Oradea, Romania
  • Robert Gyorodi Department of Computer Science Faculty of Electrical Engineering and Information Technology University of Oradea, Str. Universitatii 1, 410087, Oradea, Romania
  • George Pecherle Department of Computer Science Faculty of Electrical Engineering and Information Technology University of Oradea, Str. Universitatii 1, 410087, Oradea, Romania
  • George Mihai Cornea Department of Computer Science Faculty of Electrical Engineering and Information Technology University of Oradea, Str. Universitatii 1, 410087, Oradea, Romania

Abstract

In this article we will try to explain how we can create a search engine using the powerful MySQL full-text search. The ever increasing demands of the web requires cheap and elaborate search options. One of the most important issues for a search engine is to have the capacity to order its results set as relevance and provide the user with suggestions in the case of a spelling mistake or a small result set. In order to fulfill this request we thought about using the powerful MySQL full-text search. This option is suitable for small to medium scale websites. In order to provide sound like capabilities, a second table containing a bag of words from the main table together with the corresponding metaphone is created. When a suggestion is needed, this table is interrogated for the metaphone of the searched word and the result set is computed resulting a suggestion.

References

[1] Fine-Tuning MySQL Full-Text Search - http://dev.mysql.com/doc/refman/5.0/en/fulltextfine- tuning.html

[2] Full text search - by Wikipedia - http://en.wikipedia.org/wiki/Full_text_search

[3] MySQL's Full-Text Formulas - by Database Journals - http://www.databasejournal.com/ features/mysql/article.php/3512461/MySQLs-Full-Text-Formulas.htm

[4] Metaphone - by Wikipedia - http://en.wikipedia.org/wiki/Metaphone

[5] The Levenstein distance - http://us2.php.net/levenshtein

[6] Atlam, E.-S., Ghada, E.-M., Fuketa, M., Morita, K., Aoe, J., A compact memory space of dynamic full-text search using Bi-gram index, Computers and Communications, 2004. Proceedings ISCC 2004. Ninth International Symposium

[7] Ikeda, T., Mano, H., Itoh, H., Takegawa, H., Hiraoka, T., Horibe, S., Ogawa, Y., "TRMeister: a DBMS with high-performance full-text search functions", Data Engineering, 2005. ICDE 2005. Proceedings. 21st International Conference
http://dx.doi.org/10.1109/icde.2005.148

[8] Misutka, J., Galambos, L., "Mathematical Extension of Full Text Search Engine Indexer", Information and Communication Technologies: From Theory to Applications, 2008. ICTTA 2008. 3rd International Conference
http://dx.doi.org/10.1109/ictta.2008.4530006

[9] D. Zmaranda, G. Gabor, Issues on Optimality Criteria Applied in Real-Time Scheduling, International Journal of Computers Communications & Control, ISSN 1841-9836, Suppl.S, 3(S):536-540, 2008
Published
2010-12-01
How to Cite
GYORODI, Cornelia et al. Full-Text Search Engine using MySQL. INTERNATIONAL JOURNAL OF COMPUTERS COMMUNICATIONS & CONTROL, [S.l.], v. 5, n. 5, p. 735-743, dec. 2010. ISSN 1841-9844. Available at: <http://univagora.ro/jour/index.php/ijccc/article/view/2233>. Date accessed: 30 nov. 2021.

Keywords

full-text, search, MySQL, index, search engine, ranking, metaphone, Levenstein