Research Of Query Optimization Based On Construction Project Data Analysis System

With the rapid development of science and technology, information technology and networktechnology grew and developed like the bamboo rises after the rain. The database as the corecarrier of the two science and technology capacity, is also in constant developing andchanging.All flowers bloomed together from the initial mesh, hierarchy to today’s relation,parallel, distributed and any other kinds of database. Development is delightful, problem alsoarise a meditation. In the database, the largest share of the operations, the efficiency of search isextremely low in the face of various data types: structure, non-structure, view and other emergingforms of storage and data and the connection between data, data search and other aspects of thequeries. So many experts and scholars explore and research since the query optimization appears.In this thesis, the essay based on Construction project data analysis system, researching anddiscussing query optimization technology in the actual project, providing some valuable practicalexperience for research and development of the technology of the query optimization.In this thesis,it’s firstly provided the overview of the development and background of the database, the presentsituation of the query optimization technology development, the basic theory of the queryoptimization technology and described the necessity of the query optimization. Then, it describesand introduces the basic principle, the background and the current development of the GeneticAlgorithm, also analyses the implementation steps of the GA, proposed the query optimizationbased on the GA. The coded syntax tree model, fitness function and cost estimation is analyzed inbrief. Then designed some feasible query optimization scheme based on Construction project dataanalysis system, which the schemes are provided from two levels: the algebraic optimization andphysical optimization. Then gave the examples of the query optimization, using the experiment totest the effect and the feasibility of the query optimization.Finally, the essay summarizes thecontent of this paper and outlooks the future of the development of the technology of the queryoptimization.