FAQ
Hi,


Please help me with this as it is very urgent.


I have to install and implement Oracle Data Mart in my company.We have oracle 9i on solaris 9.Can you send me documents about data mart.I have downloaded some docs from Oracle site but it is not enough.


I want guidencel for schema design for Oracle Data Mart.How the Datamart schema is different than general Database.


Additional Licence is required for Oracle Data Mart??We have licence for oracle 9i Enterprise Version.



Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail.

Search Discussions

  • Dennis Williams at Sep 6, 2006 at 3:50 pm
    Murtuja,

    Your Enterprise Oracle license should give you what you need. You are
    licensed for the partitioning features which are used a lot in data
    warehouses.

    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 http://www.ralphkimball.com/ 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:
    http://www.tcoug.org/Archive/Fall2004/Fall2004.html. This will start you off
    in the right directions from the beginning.

    Dennis Williams
  • Don Doo at Sep 7, 2006 at 2:03 am
    Hi Murtuja,
    The odtug website also has a few very good articles available for free
    download at
    http://www.odtug.com/pls/htmldb/f?p=500:815:6729629124491114353:::815:P815_TOPIC:6
    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
    Scalzo
    Advanced Dimensional Modeling by Vincent chazhoor

    A few useful blogs in data warehouse area

    http://oraclesponge.wordpress.com
    http://pjsrandom.wordpress.com/
    http://www.rittman.net/

    Don
    On 9/6/06, Dennis Williams wrote:

    Murtuja,

    Your Enterprise Oracle license should give you what you need. You are
    licensed for the partitioning features which are used a lot in data
    warehouses.
    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 http://www.ralphkimball.com/ 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:
    http://www.tcoug.org/Archive/Fall2004/Fall2004.html. This will start you
    off in the right directions from the beginning.

    Dennis Williams

    --
    http://www.freelists.org/webpage/oracle-l
  • Jay.Miller_at_tdameritrade.com at Sep 7, 2006 at 7:00 pm
    Partitioning is not a standard option for Oracle, it has an additional
    fee. I agree that it is important for a data mart or data warehouse.





    Thanks,

    Jay Miller

    Sr. Oracle DBA

    x68355



    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Dennis Williams
    Sent: Wednesday, September 06, 2006 11:51 AM
    To: murtuja_oracle_at_yahoo.com
    Cc: freelists
    Subject: Re: Data Mart



    Murtuja,



    Your Enterprise Oracle license should give you what you need. You are
    licensed for the partitioning features which are used a lot in data
    warehouses.

    ...



    Dennis Williams

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 6, '06 at 3:51a
activeSep 7, '06 at 7:00p
posts4
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase