Please enable JavaScript.
Coggle requires JavaScript to display documents.
Adv DB Ass2 (Design of a solution (Conceptual (Document requirement that…
Adv DB Ass2
Design of a solution
Conceptual
Document requirement that addresses the problem
Logical
How application interacts with other components (internal or external)
Technical specification
Physical
System architecture explained in detail
Problems
Lynda.com
Data-mart fragmentation
Data mart w/o EDW
Lynda video Section 2
Data Latency
Increase frequency batch ETL feeds
Build spinoff solutions (real-time data marts)
Real-time messaging
feeds instead of ETL
Problem for Supermarket
Expense comparison
HR: tracking employee resignation over 2 years
Operational BI:
Architectural mismatch
