The Query Optimization Based On Data Mining

After the world enters the information age, along with the computer technology swift and violent development, indicated the information data by the index speed fast growth, stores the data the database also suddenly to inflate along with it. When searches the data like this day by day from the huge data, the database inquiry speed is unsatisfactory. Some materials indicated,In modern engineering project,The technical personnel operating time operating time 10% -30% is uses in seeks in the appropriate information,But administrative personnel then has 80% time is uses in the information collection and the preparation. In order to provides the convenient information inquiry to the project development personnel, fast looks up the information which found needs, develops an effective inquiry system to have the necessity very much. May say the inquiry optimization technology is current has the important theory and theapplication value research topic extremely, therefore the this article main goal is studies one kind to be possible to enhance the new solution which the inquiry optimizes, may further realize the inquiry speed enhancement.Because the data mining is from massive, not incomplete, has the noise, is fuzzy, in the stochastic data,Withdraws the concealment in among, the people beforehand does not know, but also is the latent useful information and the knowledge process, he may according to the people the specific request, discovers the information from the voluminous data which needs. Therefore this article obtains the data mining technology the information, introduces to the inquiry optimization technology, unifies with the traditional index technology proposed one kind "based on the data mining technology inquiry optimization" the plan, and to this kind of solution design thought, the design law law, the result carries on the analysis.This article first elaborated we conduct the research the background, the goal, the content, the significance. Next, the multianalysis present stage uses in each kind of technology which inquires optimizes, among, the key analysis enhances the inquiry efficiency through the SQL sentence optimization the reason, the principle and the method as well as the index technology. Then through to the data mining technology analysis, uses the functionwhich its connection rule may realize, elaborated the data mining technology carries on the principle and the method to the SQL sentence which the optimization thus the realization inquiry optimizes, also is we to the overall system design thought. Finally we apply the above theory to the Japanese negotiable securities system in "the contract with the module", carried on the test and the practice has obtained the certain effect.Our research, through may realize using the data mining excavates between the data the relations, reduces the data search space, unified with the traditional index technology, has realized the inquiry optimization, has realized the inquiry speed enhancement. This article also had innovation has broken the former data mining mentality, was not merely uses in the data mining result to the people providing the knowledge information, by made some decisions-making, what was main was excavates the result with the precise digital presentation, used in providing to the computer makes the further analysis and processing.In brief, this article research results mainly are use the data mining technology and the index technology union, proposed one kind based on the data mining technology new inquiry optimization plan. Goal further enhances which using this technical realization inquiry efficiency.