Learning Center

Physical vs Virtual Tables

Written by Jared Hillam | Jul 7, 2018 12:08:00 AM

 

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