virtual cube


Virtual cubes are often likened to views in a relational database. A virtual cube merges portions of two existing cubes so that a combination of dimensions and measures can be analyzed through the single, virtual cube. For example, a retailer may have two cubes: one that stores the number of visitors to its website and another that stores purchases. A virtual cube could be used to correlate the data from both cubes to calculate the average sales per website visit.

Virtual cubes can also be used to prevent unauthorized users from viewing private or sensitive information. For example, if a cube has both sensitive and non-sensitive information, the non-sensitive information can be made available in a virtual cube for those users who need it. The sensitive data, meanwhile, remains in the existing cube where it is accessed by authorized users.  

This was last updated in April 2012

Dig Deeper on Database management system (DBMS) architecture, design and strategy



Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.


File Extensions and File Formats

Powered by: