| Thesis research for the problems and challenges in the sales of coal enterprises face,based on the theory of data mining and data access,etc.,within the Pingdingshan Tianan Coal Mining Company Limited period coal density measurements carried out in-depth analysis and research,the using mass / volume density measurement density measurement method using the R statistical analysis tools,within a period of one mine in Pingdingshan coal samples were analyzed density as a function of the heat,come to its negative correlation,so as to realize coal hair fast Estimation of heat;coal sales due to changes in the process of policy-denominated sales,leading to both parties in the transaction process importance of coal quality,based on this,the use of Microsoft’s Microsoft Visual Studio.NET 2010 software development tools and SQL Server 2012 relational database management systems,multilayer software development model based on the development of the "icoal quality integrated information management system",In this paper,the main research contents and innovation points are as below:Firstly,quickly estimate the heat: the proposed coal sales for the contradictions that exist under the current dispersion of the calorific value of coal quality valuation background information on their estimate of the accuracy requirements of the fast density of coal for heat,a method using mass / volume density measurements using a graduated cylinder,pipette,pallet scales,measuring cups and other experimental instruments to measure the density of coal samples,and then use heat to achieve rapid estimation of density,and has a certain value.Secondly,Research based on Linear Regression and Realize of R Language: theory and algorithms based on data mining,the use of the R statistical analysis tool,based on data obtained from the measurement of a mine in Pingdingshan,its function of density of coal samples were heat statistical analysis,the conclusion that negative linear relationship between density and heat,thus achieving a rapid estimation of calorific value of coal samples,which can promote coal sales business,for enterprises to bring huge economic benefits,effectively improve their core competitiveness power,coal companies and ultimately achieve a win-win alliance customers.Thirdly,comprehensive information management system of coal quality: the process of valuation changes due to the sales of coal sales policy,leading to both parties in the transaction process,the importance of coal quality,transaction process from both sides of the dispute may be "the price game","trading volume game" steering "quality Game." Based on this,the use of Microsoft’s Microsoft Visual Studio.NET 2010 software development tools and SQL Server 2012 relational database management system,multi-layer software development model based on the development of the "integrated coal quality information management system" to achieve the parties to the transaction quality information collection,processing,storage,and other management operations. |