Best practices for data mining functionality in SQL Server 2005

To sell personalized ringtones to users and other content providers that can be downloaded to a mobile phone, it is necessary to keep abreast of the market and understand the needs of users. ABS-CBN Interactive Corporation (hereinafter referred to as ABSI) is a subsidiary of the largest integrated media and entertainment company in the Philippines, ABS-CBN, and ABSI offers valuable cross-selling information to its customers by searching its own online transaction (OLTP) data. But this search will take many days to complete, not to provide personalized advice to customers. Absi hopes to increase sales by increasing the responsiveness of the system and taking a proactive role in business activities. In collaboration with Microsoft Business Intelligence Gold Partner DB Wizards, ABSI deployed the Microsoft SQL server™2000 Data Warehouse, while DB Wizards recommended that ABSI company use Microsoft SQL Server 2005. has now provided customers with accurate and personalized services, the response rate increased by one times, so that ASBI can occupy the opportunity in business activities.

I. Business SITUATION

Philippine mobile phone users like to use personalized ringtones and some other services including wireless games, reading biographies of celebrities, downloading picture information, participate in TV interaction and short message chat. ABS-CBN Interactive Company (hereinafter referred to as ABSI) is the largest integrated media and entertainment company in the Philippines, the subsidiary of ABS-CBN Broadcasting Company, it is the leader in this market.

Millions of users per month, ABSI company has always been passionate with the needs of customers consistent, providing them with as much relevant experience. In order to achieve this goal, the ABSI company predicts market trends and future supply of goods by studying the user's buying patterns.

According to the agreement with the wireless provider, ABSI company can send users a lot of information each week to provide new ringtones information and other value-added services, the company's biggest goal is to use the best response speed and optimize the number of available information it is allocated to provide users with the most relevant information to improve sales.

To increase ringtone sales, Absi is analyzing online transaction data (OLTP) data for research and predicting the best ringtones to provide. During the parsing process, SQL statements are used to query Microsoft SQL server™2000 (Microsoft Windows Server system™integrated Server Software) OLTP data. The results are then copied to Microsoft Excel for analysis. Using these systems to produce a report takes at least three days, which means that the report is never up to date and cannot react to the current situation, because manual processing is used in the process and may cause errors. The system can provide helpful information to provide advice to customers, but it takes nearly a week to complete, and the results are propagated to the customer.