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 ...Continue Reading

When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to create a data warehouse based on the operational data model?Continue Reading

What are your experiences with RAC node scaling in DSS workloads vs.
OLTP? Also, isn't the primary bottleneck in scaling out the overhead
of the cachefusion lock management protocols, not the actual interconnect?Continue Reading

I work in a product-based company. I am planning to build a generic data mart for all our future customers. we need to design our "Product" table generically, so that it can accomodate any type of products. Please suggest what is the best way to ...Continue Reading