Securities trade is a new and developing trade,but the competition is more fiercer day by day. Building the high-quality financial service company is the transition goals of many insightful securities broker companies.This kind of service theory of regarding customer as the centre has put forward higher demand for the technical support of the customer service.This thesis research on the application of Data Warehouse technique in the customer service of securities broker company. Introduce the idea of building securities customer Data Warehouse which securities customer analysis system based on. The system can obtain such key information as customer's behavior , profit and loss,offer solid technical support for the specialization and personalized service of securities broker company.This thesis describes in detail the system structural design of customer analysis system at first, design one with many themes multidimensional data model that the customer is as the centre , structure out securities customer Data Warehouse that accords with the demand to customer analyses. According to conditions that characteristic of data source is multi-platform, different data structure and datum amount heavy, put forward a set of solution to data extraction, transformation and load. Provide a implementation method that metadata control in automation while the data extraction, data transformation and data cut apart. Finally afford the algorithms that OLAP and data mining technology of decision tree , clustering which apply to the securities customer analyses. |