Physical vs Virtual Tables

Written by Jared Hillam

 

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    

 

 

Who is Intricity?

Intricity is a specialized selection of over 100 Data Management Professionals, with offices located across the USA and Headquarters in New York City. Our team of experts has implemented in a variety of Industries including, Healthcare, Insurance, Manufacturing, Financial Services, Media, Pharmaceutical, Retail, and others. Intricity is uniquely positioned as a partner to the business that deeply understands what makes the data tick. This joint knowledge and acumen has positioned Intricity to beat out its Big 4 competitors time and time again. Intricity’s area of expertise spans the entirety of the information lifecycle. This means when you’re problem involves data; Intricity will be a trusted partner. Intricity's services cover a broad range of data-to-information engineering needs:

 

Strategy Acceleration Migration-4

 

What Makes Intricity Different?

While Intricity conducts highly intricate and complex data management projects, Intricity is first a foremost a Business User Centric consulting company. Our internal slogan is to Simplify Complexity. This means that we take complex data management challenges and not only make them understandable to the business but also make them easier to operate. Intricity does this through using tools and techniques that are familiar to business people but adapted for IT content.

 

 

Thought Leadership

Intricity authors a highly sought after Data Management Video Series targeted towards Business Stakeholders at https://www.intricity.com/videos.  These videos are used in universities across the world. Here is a small set of universities leveraging Intricity’s videos as a teaching tool:

Educators in a Square 2.png

Talk With a Specialist

If you would like to talk with an Intricity Specialist about your particular scenario, don’t hesitate to reach out to us. You can write us an email: specialist@intricity.com

 

(C) 2023 by Intricity, LLC

This content is the sole property of Intricity LLC. No reproduction can be made without Intricity's explicit consent. 

 

Intricity, LLC. 244 Fifth Avenue Suite 2026 New York, NY 10001
Phone: 212.461.1100 • Fax: 212.461.1110 • Website: www.intricity.com

 

Simplifying Complexity