Re: Data Mart

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: murtuja_oracle@xxxxxxxxx
  • Date: Wed, 6 Sep 2006 10:50:50 -0500


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: