Research on Query Method with Approximate Matching in Relational Database
LI Qing-hong · Jisuanji gongcheng · 2011
Traditional accurate query of mass data is easy to lead to overload.Aiming at this problem,this paper uses Bootstrap method of the confidence interval based on the simulation to provide database support.The method reduces the range of query data by querying part or sample data instead of all data sets for simplifying basic data of the query.The time of querying all data sets can complete repeated queries for multiple samples,the confidence bound of the database query should be obtained.Employing a basic Structured Query Language(SQL) query gets the approximation results,which correspond to user demand.Experimental result shows that the Bootstrap method is effective for querying data.