1 / 9

Understanding the Value Chain Databases in DBMS & DW

Explore the essential databases representing the product flow and value chain in DBMS & Data Warehousing. Learn about the Demand and Supply Value Chains, database integration, and supply chain management.

jeffreygeorge
Download Presentation

Understanding the Value Chain Databases in DBMS & DW

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Adv. DBMS & DW Chapter 5: The Value Chain Hachim Haddouti

  2. The Value Chain • Series of databases that represent the value chain of the product flow • Value chain: • Demand side: needs to satisfy customer’ s demand • Supply side: needs to manufcture producst

  3. The Demand Value Chain • six databases (all steps of product flow): • finished goods inventory • manufacturing shipments to distribution center • distribution center inventory • distribution center depletions to retail stores • retail store inventory • retail store sales

  4. The Demand Value Chain Finished Goods: Time, Product, Warehouse Shipments to Distribution Center: Time, Product, Warehouse, Center, Contract, Mode Distribution Center: Time, Product, Center Depletions to Retail Stores: Time, Product, Center, Store, Contract, Mode …

  5. The Demand Value Chain cont. • Physical products move sequentially through this sequence • --> May involve multiple different companies • All 6 DBs share Product and Time dim • “The attraction of assembling a value chain of databases is that several can be combined in a single report by drilling across.” • --> snapshot of the value chain, how the bulge of product moves from manufacturer to consumer

  6. The Demand Value Chain cont. • Design principle: • “In order to support drill-across applications, all constraints on dimension attributes must evaluate to exactly the same set of dimensional entities from one database in the value chain to the next database in the value chain.” • a common dimension table shared by all fact tables • special cases: • dimensions with reduced detail (Ch 16) • eg, manufacturer has a finer detail than later • derived dimensions that support aggregates (Ch 13) • precomputed sums to help specific queries

  7. Potential subdivisions in the value chain: • Transshipments -- shuffling materials before passing them on, eg. with multiple holding points in multiple plants. • Breaking inventory steps -- unallocated to allocated • Separating orders and shipments, returns • multiple shipments can satisfy one order • returns must be tracked carefully, with reasons (Return Reason, Disposition.in separate dim)

  8. The supply value chain • Representing the manufacturing process:raw materials converted to finished goods. • Suplly-Side includes measurements of cont. Flow processes as well as the document-oriented processes seen on the Demand Side. • different databases: • purchase orders • deliveries • materials inventory • process monitoring • bill of materials • finished goods inventory • manufacturing plans

  9. The supply value chain different databases cont.: • Purchase orders • Time, Part, Supplier, Deal • Deliveries • Time, Part, Supplier, Plant, Mode, Deal • Materials inventory • Time, Part, Plant • Process monitoring • Time, Part, Process, Plant • Bill of materials • Time, Part, Product • Finished goods inventory • Time, Product, Warehouse • Manufacturing plans • Time, Product

More Related