广东省气象短信推广数据分析程序设计

为了推广气象短信的应用,经常需要分析用户数据用于群发,或提取部分或全部数据用于与运行商稽核。这涉及到复杂的SQL语句编写和大数据量的导入导出,大部分的功能比较单一且重复。广东省气象短信的定制用户已经是达千万量级,短信系统需要采用能快速导入导出大批量数据的技术。为此,采用复杂的组合选择技术自动生成SQL语句,由数据库完成数据比对和提取工作;针对目前气象短信Oracle和SQL Server数据库并存的现状,提出了不同的导入导出数据的解决方案。该方案中,Oracle采用SQL＊LOADER和SQL＊UNLOADER导入导出数据,SQL Server采用DTS技术,程序采用Delphi开发。

Programming for Guangdong meteorology SMS promotion data analysis

For the promotion of meteorology SMS, analyzing user data for mass messaging, or taking part or all data for the provider＇s checking are often needed. Hence complex SQL compiling and mass data import/export technology is involved, but most of them are repeated and simple. Now, the number of meteorology SMS users is huge （up to ten million levels）, so that a technology to import/export mass data rapidly is necessary. In this paper, the authors generate SQL automatically, and database execute SQL to complete data comparison and abstraction, and propose two different solutions to resolve Oracle and SQL Server mass data import/export according to our data storage. For Oracle database, the authors use SQL＊LOADER and SQL＊UNLOADER to import/export mass data, but for SQL Server, use Data Transformation Services （DTS）.