Whole Database Retrieval Method of General Relational Database Based on Lucene

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.