Tip: Exposing logical attributes with virtual columns

May 23, 2008

Data modelers are often faced with the dilemma of how to model logical attributes in their data warehouse schema design. A new feature in Oracle 11g called virtual columns solves this dilemma by exposing logical attributes while reducing object management and storage consumption. Additionally, virtual columns can be used to improve availability, manageability and performance of the database. Virtual columns assist modelers in delivering simple, intuitive and fast performing designs.

The article continues at http://searchoracle.techtarget.com/tip/0,289483,sid41_gci1312740,00.html