数据仓库技术在eBay+IT客户支持系统中应用.pdf

数据仓库技术在 eBay IT 客户支持系统中的应用 应的 MicroStrategy 框架对象（Schema Object ）以及公共对象（Public Object）、 参与执行部分数据分析过程演算工作用以验证设计方案的有效性，并负责向 IT 管理层发布 项目最终数据报表服务。 目前，eBay IT 客户支持系统数据仓库及其 OLAP 在线分析处理服务已进入最终用户 测试阶段（User Acceptance Testing - UAT），并预计于年内正式投入使用。这一项目 的设计与实现，不仅将有效提高 IT 部门数据分析的质量与效果、准确反映 IT 服务业务的 质量与现状，从而满足管理层对于 IT 营运业务数据分析的需求，同时还推动了 IT 数据仓 库策略的发展。它将为后续进一步集成 IT 内部其他管理信息系统数据打下扎实的基础。 关键词 数据仓库，ETL ，在线分析处理（OLAP ）， MicroStrategy Desktop II 数据仓库技术在 eBay IT 客户支持系统中的应用 THE APPLICATION OF DATA WAREHOUSE TECHNOLOGY IN EBAY IT CUSTOMER SUPPORT SYSTEMS ABSTRACT eBay is one of the worlds largest electronic trading platforms. Establishment 15 years ago, eBay and more than 20 employees from an auction site has grown in strength, to the end of 2008 already has 16,000 employees worldwide. The business expanded from e-commerce to Internet banking, electronic payments field. In order to meet the company development, eBay IT sector has implemented and deployed a series of internal customer support systems. As of the end of fiscal year 2008, eBay IT has a total of 3 sets of internal customer support systems. These systems are at different stages of development in the company were to implement the deployment. The database systems, and the way of data storing are not the same. Meanwhile, these customer support systems are separated from each other in the application and data layers. This has brought a lot of data redundancy, and very difficult to effectively extract from the historical data for supporting effective information needs of IT management decisions. Last year the global economy, especially in the context of change, IT sector was facing unprecedented pressure. Management team is eager to study the information from those customer support systems on the implementation of IT service level