文件名称：Dimensional Modeling
文件大小：8.44MB
文件格式：PDF
更新时间：2014-09-25 17:28:17
Dimensional Modeling Ben_Hu
Within the scope of business computing and information technology (IT), it has been said that the 1980s were about performing your business, the 1990s were about analyzing your business, and the late 1990s and beyond are about new routes to market and bringing your business to the World Wide Web. To build further upon these categorizations, we offer the following points: Performing your business – Online Transaction Processing (OLTP) was the supporting technology. – Companies could increase net revenue by: • Lowering cost of sales through computerized automation, and less intensive labor. The internal cost and percent of (human) labor is lowered. • Better utilization of (capital) inventory, and increased visibility of on hand inventory. A customer new order call center can view and sell products from numerous and remote company-owned distribution centers. • Faster turnaround on order processing, faster order assembly and shipment, and faster bill generation and collection. The number of days outstanding, an important accounting metric, is lowered. – Companies could grow in size beyond previously known limits. – OLTP data is modeled using Entity Relationship (E/R) modeling, sometimes referred to as Third Normal Form (3NF).