virtual cube

A virtual cube is a subset of one or two existing cubes in a database. Database administrators create virtual cubes for security purposes and/or to enable analysis of the shared data.

 

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 first published in April 2012

Glossary

'virtual cube' is part of the:

View All Definitions

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

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close