The key technology and optimization of query in Multi table Web Database
Zheng Yuan · Journal of Central South University of Technology(Natural Science) · 2002
To meet the demand of general information query service in the specialized Web database and supply some gaps in this service, the key technology and optimization method of multi table query in Web database are discussed in this paper. The design guideline of query interface is brought forward. The implementation of interface is described. It leads user to make correct operation so that the result can correspond with the user′s expectation. The optimization of interface is realized so as to decrease the delay of Internet transmission by compressing the size of interface HTML file. The formation of SQL statements is discussed. For enhancing the efficiency of information query and improving the performance of Web database server, the SQL statements are optimized by means of sub -query. Specially, the more records the database contains, the more obviously the performance of server will be improved. The interaction, such as drop and drag, visible/hidden etc, is introduced in the result interface so that users can query more effectively.