摘自《Data Mining - Concepts and Techniques》
In general, the warehouse design process consists of the following steps:
1. Choose a business process to model, for example, orders, invoices, shipments,inventory, account administration, sales, or the general ledger. If the business process is organizational and involves multiple complex object collections, a data warehouse model should be followed. However, if the process is departmental and focuses on the analysis of one kind of business process, a data mart model should be chosen.
2. Choose the grain of the business process. The grain is the fundamental, atomic level of data to be represented in the fact table for this process, for example, individual transactions, individual daily snapshots, and so on.
3. Choose the dimensions that will apply to each fact table record. Typical dimensions are time, item, customer, supplier, warehouse, transaction type, and status.
4. Choose the measures that will populate each fact table record. Typical measures are numeric additive quantities like dollars sold and units sold.
分享到:
相关推荐
The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space....
Written by the leading experts in the field, this comprehensive guide shows you how to implement the SAP Business Information Warehouse (BW) and create useful applications for business analysis of ...
Several business rules (constraints) are applied to the design and development of a data warehouse. Seismic-time horizons, welldata, reservoir properties and petroleum production as data dimensions or...
Winner of IBM’s 2012 Gerstner Award for his implementation of big data and data warehouse initiatives and author ofPractical Hadoop Security, author Bhushan Lakhe walks you through the entire ...
a shared source as a template, with the actual needs of the nursing home operations management system for analysis and functional adjustments , explored the use of JSP development process of nursing ...
Winner of IBM’s 2012 Gerstner Award for his implementation of big data and data warehouse initiatives and author of Practical Hadoop Security, author Bhushan Lakhe walks you through the entire ...
Process Design 465 Performance Management 465 The Technical Business Content 466 Reporting and Analysis 469 Data Loading and Data Management 478 Data Extraction 479 Data Staging 480 System ...
Throughout the design process, great emphasis was placed on ensuring the readability, practicality, scalability, generality, ease of future maintenance, user-friendliness, and simplicity of the ...
8. 时空数据建库过程(Spatiotemporal Data Warehouse Process):是指从数据采集、数据处理、数据存储到数据挖掘和数据应用的整个过程。 9. 时空数据质量要求(Spatiotemporal Data Quality Requirements):是指...
它是 SAP Business Suite 和 SAP Business by Design 的基础。 SAP NetWeaver 平台的关键特点: * 它是一个开放技术平台,提供了一套全面的技术,用于运行关键业务应用程序和集成人员、流程和信息。 * 它是一个...
9. DW或DWH(Data Warehouse):数据仓库,是专门设计用于数据分析的大型数据库,存储来自不同源的历史数据。 10. OLAP(On-Line Analytical Processing):联机分析处理,用于多维数据分析,支持复杂的查询和报告...
此外,还有BOM(Bill Of Material,物料清单)、MRP(Material Requirements Planning,物料需求计划)、PAC(Production Activity Control,车间作业管理)等概念,这些概念都是生产计划和控制的重要组成部分。...
本文旨在作为一些著名的数据仓库建模和设计技术的一种方法。 更好地理解设计问题的方法还需要指出一个实际案例,例如“支持高等教育管理”。 本文的每个段落几乎都是一个特有问题的隐喻:声明核心过程,粒度,维度和...