NBA Team Star Schema-based Data Mining Analysis Applied Research

The existence of the complex nature of the relationship to the actual business data,the mass of data, the uncertainty of the dirty data, reduce performance and flexibility ofthe relational data model, data analysis, how to meet the data analysis of the data sourcestructure for efficient query performance an essential topics, this paper presents forordinary relational data into business-oriented theme of the star data modeling andanalysis of such data processing program.Star data structure modeling and analysis in this article rely on the NBA team data,select the ECLIPSE MYSQL5.1and MatLab2009development environment, the team oftechnical data clustering, team player classification of data pre-sentence, come to the jointtopology of multi-topic program in the superiority of the actual data processing andanalysis of such models. Which star model of the player and team two themes for the mainobject of study, after a systematic analysis of abstracted conceptual model into a physicalmodel, the formation of realistic database and the CSV text data related to ETL inMYSQL and warehousing operations. MatLab2009the clustering functions for dataanalysis, and analysis of the results of correlation analysis. Using the rules of decision treeclassification analysis classified the forecast after the change or add data classificationanalysis. Star data model of the player team text data conversion operations andwarehousing and analysis.Business-oriented theme of star-modeling methods in data mining analysis of thesource handling and convenient performance advantage of the player team data processingand analysis program, provides a favorable mining analysis of the data source structurestar schema the data of the program, to facilitate the analysis of such data model.