• 主题
高级搜索  >
历史搜索 清空历史
首页> 外文期刊>Communications of the Association for Information Systems >Sherwin-Williams' Data Mart Strategy: Creating Intelligence Across the Supply Chain
【24h】

Sherwin-Williams' Data Mart Strategy: Creating Intelligence Across the Supply Chain

机译：宣威威廉姆斯的数据集市策略：在整个供应链中创造情报

获取原文
           
页面导航
  • 摘要
  • 著录项
  • 相似文献
  • 相关主题

摘要

Companies can build a data warehouse using a top-down or a bottom-up approach, and each has its advantages and disadvantages. With the top-down approach, a project team creates an enterprise data warehouse that combines data from across the organization, and end-user applications are developed after the warehouse is in place. This strategy is likely to result in a scaleable data warehouse, but like most large IT projects, it is time consuming, expensive, and may fail to deliver benefits within a reasonable timeframe. With the bottom-up approach, a project team begins by creating a data mart that has a limited set of data sources and that meets very specific user requirements. After the data mart is complete, subsequent marts are developed, and they are conformed to data structures and processes that are already in place. The data marts are incrementally architected into an enterprise data warehouse that meets the needs of users across the organization. The appeal of the data mart strategy is that a mart can be built quickly, at relatively little cost and risk, while providing a proof of concept for data warehousing. The risk is that the initial data mart will not scale into an enterprise data warehouse, and what has been built will have to be scrapped and redone. This article provides a case study of Sherwin-Williams' successful use of the bottom-up, data mart strategy. It provides background information on Sherwin-Williams, the data warehousing project, the benefits being realized from the warehouse, and the lessons learned. The case is a "textbook example" of how to successfully execute a data mart strategy. Video clips of interviews with key individuals at Sherwin-Williams help bring the case alive.
机译：公司可以使用自上而下或自下而上的方法来构建数据仓库，每个公司都有其优点和缺点。使用自上而下的方法，项目团队创建了一个企业数据仓库，该仓库将来自整个组织的数据组合在一起，并在仓库到位后开发了最终用户应用程序。此策略可能会导致可伸缩的数据仓库，但与大多数大型IT项目一样，它既耗时，昂贵又可能无法在合理的时间内交付收益。使用自下而上的方法，项目团队首先创建一个数据集市，该数据集市具有一组有限的数据源并且可以满足非常特定的用户要求。数据集市完成后，将开发后续集市，并使它们符合已经存在的数据结构和流程。数据集市以增量方式构建到企业数据仓库中，可以满足整个组织中用户的需求。数据集市策略的吸引力在于，可以以相对较低的成本和风险快速构建集市，同时为数据仓库提供概念证明。风险在于初始数据集市将无法扩展到企业数据仓库中，而已构建的内容将必须报废并重做。本文提供了Sherwin-Williams成功使用自下而上的数据集市策略的案例研究。它提供有关Sherwin-Williams，数据仓库项目，从仓库中获得的收益以及汲取的教训的背景信息。该案例是如何成功执行数据集市策略的“教科书示例”。与宣威公司关键人物访谈的视频片段有助于使案件生动起来。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱：kefu@zhangqiaokeyan.com

京公网安备：11010802029741号 ICP备案号：京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有

  • 客服微信

  • 服务号