This is a grid mentioned in our video titled Physical VS Virtual. The grid provides the pros/cons between persisting data into a physical form vs pros/cons of using virtual tables.
Virtual |
Physical |
||
Pros |
Cons |
Pros |
Cons |
| Real Time Capable | Chaotic to Maintain | Easy to Audit | Difficult to Change |
Buffers Anomolies |
Difficult to Scale Sources | Fast Queries | Latent Data |
| Easy to Prototype | Difficult to Trace History | Tracks History | Sensitive to Volitility |
| Late Arriving Data Issues | Whole Transactions | ||
| Excessive Query Compute | |||