Database Design And Tuning For Statistics Data Processing System

The paper’s work is around statistics data processing the item launch of, current of statistics application software of the data of exchange unify of standard, resulted in covariance data under the item background that saving, application top hard realization information share, still give in the meantime basic level statistics worker increment many burden, at so, for avoid repeated development, waste resource, development statistics inquisition data processing item to moderate each statistics application of the data of, end unify to use that data processing system to completion each item statistics business, for so complications and need to be provide vivid search of system, the function of database system go to pass importance, along with data quantity more and more big, pressure and bottleneck be subjected to by database system be more more complications, the function adjust excellent work seem to be is importance.How availably assurance usage database system of application be placed in good of circulate appearance, have already become item whether satisfy customer request of most direct of one of the index sign, as a result demand to the following a few aspect do to adjust excellent:Database design adjust an excellent data saving structure;The SQL of the usage carry on adjust in the development process excellent;Carry on adjusting excellent grade to the hardware programming, operate system, database parameter in the item implement process;Therefore, the function adjust excellent is a technique noodles wide, problem complications and at item implement of each stage need to be value of work, the paper first introduction adjust excellent tool and adjust excellent theories, this is most basically to adjust an excellent method, then take this as foundation, to statistics data processing system after carry on a need analysis, assurance data saving project, after in the item the development and the implement the process, aim at statistics processing system system in each the function mold function problem within piece, from the disk array programming, modification database parameter, slow save big form, various SQL etc. to carry on adjust excellent, according to item of actual circumstance, continuously try various adjust an excellent project, and with test use the way of example, with adjust excellent previous carry on comparison, the body which keep a view appear to adjust excellent effect, end pass contrast test use an example result, comprehensive analysis behind choice the superior project to assurance system fast valid of circulate, attain to adjust an excellent purpose.Item maintenance the process actually also is to make exchange the verification process of the carry on of excellent effect, how fixed position the function bottleneck is to make exchange excellent work of a test, in the paper Tightness how assurance the function bottleneck enumerated some method, in order to from current system circulate various using of resource circumstance within process, fast find out the bottleneck of function, assurance cause the reason of function problem, then do a function solution for correspond, this is also detection problem and problem-solving only route.The paper pass to the database design which statistics a data processing item with adjust excellent, from the item circulate of angle to say, satisfy customer to function of request, make item of implement and maintenance can smoothly progress, and got customer of approve, say from the technique, adjust excellent theories in the item adjust the excellent process get full of practice, and combine the characteristics of item oneself, formation 1 set more and practically adjust an excellent method, though adjust excellent of work more complications, ten thousand become not to leave it religion, control good adjust the method of excellent technique and analysis problem, can nicely make use of these technique and experience, dissimilarity of the item environment carry on adjust excellent, attain the effect of half effort and double results, this is also the paper value place!...