Motores de buscas em redes sociais: um estudo comparativo das tecnologias SQL LIKE, MYSQL Full-Text Search e LUCENE

Abstract

In this work are presents the search engines that are currently available on the Web: the LIKE operator of SQL language that is used in most DBMSs, the full-text indexes implemented in SGBD MySQL and the Lucene library ofindexing and searching; Due to the increased use of social networks by Web users and the volume of information in social networks growing exponentially, the organization and the availability of this information for later retrieval in a fast, accurateand relevant way are important points to be observed and studied. For the performance tests with these search engines, was considered a social network where the scenario is inhabited by a people who study and / or working away from their hometowns and seek housing options, entertainment and emergency services. The results from performance tests showed the Lucene library of indexing and searching as thebest solution to be implemented in the social network proposed in this paper, because the minimum and maximum times to serve a search request are better than others search engines.