Whole Database Retrieval Method of General Relational Database Based on Lucene

Dawei Jin,Gang Chen,Wenning Hao,Liu Bin
DOI: https://doi.org/10.1109/ICAICA50127.2020.9182496
2020-01-01
Abstract:Aiming at the needs of full-database retrieval of multi-table massive data, a general-purpose, lightweight, non-invasive full-database retrieval method was proposed and implemented. The JDBC technology was used to complete the content extraction of the general database, and the mapping relationships of common database data types such as Mysql, Sqlserver, and Oracle in the Type class were summarized. Based on Lucene, The full-text indexing of the database content is implemented. From the result of experiment, it could be demonstrated that the proposed method has good performance and stability and is well appropriate for construction of index system for common relational database.
What problem does this paper attempt to address?