Analysis And Research About Technology Of Medicine Enterprise Customer Relations Management Based On Data Warehouse

With the development of technology of information and level people's health ,the database technique also got a very big development, but people obtain the information from the business database can't satisfy the demand of the decision far and far. So we can scoop out a technique through the usage data warehouse technique, the OLAP technique and data mining to carry out CRM(Customer Relation Management),raising the competition ability of the business enterprise thus.I studied customer relation management system based on many dimensions, then put forward analysis calculate way based on many dimensions of the OLAP. I designed whole system structure and function request of each mold from function of the system. Many dimensions data models of the database is designed through star model ,and designed the data conversion service of DTS adopting the SQL SERVER2000 business enterprise version and carried out sample conversion and load of data. I analytical the existing medicine enter to sell a data by usage the Analysis servers taking mining tool to get a conclusion thus, those will carry out theories basis to CRM of medicine professionThe data warehouse will realize through designing of the concept model, of the logic model, of the physical model, passing rule to the connection in the meantime of research, it become connection rule combined of many dimensions together with the OLAP technique. Passing a discussion production and access technique, technique of ADO MD was adopted to carry out inquiry of many dimensions and all kind of operation.This text indicated a direction for information construction of the medicine business enterprise and put forward making policy a support.