Use full-text search in construncion application of thin client architecture

Anna Piwowarczyk-Cybula, Adam Piórkowski

Abstract


Thin client architecture is now widely used solution for developing applications for business management. With the increase in users of the system architects are problems loading the application. In areas where user interaction is associated with many searches, it is appropriate to ensure optimal operation of selection. Searches may also take place in a complex textual descriptions of the stored entities. Then we turn to the full-text indexes. This article presents an analysis of the implementation of this mechanism in different database management systems. Examples include the structure and query the actual database of real estate market.

Keywords


database; full-text search; ranking

Full Text:

PDF (Polski)

References


Hendreson K.: Bazy danych w architekturze Klient/serwer. Wydawnictwo Robomatic, Wrocław 1999.

Cieślewicz J., Pelikant A.: Reprezentacja i wyszukiwanie dokumentów tekstowych w bazie danych. Studia Informatica, Vol. 30, 2A, Politechnika Śląska, 2009.

MySQL 5.1 Reference Manual, http://dev.mysql.com/doc/refman/5.1/en/

PostgreSQL 8.3.6 Documentation, http:/www.postgresql.org

Clarke C. L. A., Cormack G. V., Tudhope E. A.: Relavance Ranking for One to Three Term Queries. Information and management, 36(2):291-311,2000.

SQL Server 2008 Product Documentation, http://msdn.microsoft.com

Centrum informacyjne produktu IBM DB2, http://publib.boulder.ibm.com/info-center/ db21uw/v9r5/index.jsp

Oracle Database Documentation Library, http://www.oracle.com/pls/db 111/homepage




DOI: http://dx.doi.org/10.21936/si2010_v31.n2B.412