Re: Data Mart

  • From: "Don Doo" <doodon@xxxxxxxxx>
  • To: oracledba.williams@xxxxxxxxx
  • Date: Wed, 6 Sep 2006 22:03:53 -0400

Hi Murtuja,
The odtug website also has a few very good articles available for free
download at
I would recommend
Data Warehouse Architectures by George Lumpkin
Database Design for Data Marts and Data Warehouses by Vincent Chazhoor
Successful Dimensional Modeling of Very Large Data Warehouses by Bert Scalzo
Optimizing Data Warehouse Ad-Hoc Queries Against "Star Schemas"by Bert
Advanced Dimensional Modeling by Vincent chazhoor

A few useful blogs in data warehouse area


On 9/6/06, Dennis Williams <oracledba.williams@xxxxxxxxx> wrote:


Your Enterprise Oracle license should give you what you need. You are
licensed for the partitioning features which are used a lot in data
    In general, you need to start by understanding what the Star Schema is
and why it is better for data marts than the conventional normalized schema.
    I would suggest you go to the site and
begin reading. Ralph posts a lot of good articles online. But you may want
to purchase one of Ralph's books because the book will present the
information in a more organized manner.
    Once you understand the big picture of what data warehousing is and
why sites implement it, for the DBA I would highly encourage you to look at
Tim Gorman's paper Scaling to Infinity, which can be found at: This will start you
off in the right directions from the beginning.

Dennis Williams

Other related posts: