Post reply

Creating a datawarehouse

  • November 4, 2005 at 4:31 am

    #69896

    I a student supposed to implement a data warehouse using sql server 2000 then integrate it with ArcGIS. How ever I do not know how to start building one in sql server. Secondly i am new in the field of databases but have to creat the DW inorder to complete my study.

    Andy

    Kindest Regards,

    ABurton

  • November 4, 2005 at 9:47 am

    #602385

    You could start by reading some of the information on this site.

    http://www.kimballgroup.com/

    Good luck!!!!!

  • November 4, 2005 at 10:14 am

    #602397

    The best thing you can do is to keep the design simple.

    Investigate a star schema. It's easy to create and maintain and the theory behind them are simple. Basically, you have one table in the middle which contains measures (e.g total sales) as well as foreign keys referring to dimensions (e.g. product codes).

    One question. Where are you getting the data from? Or do you have to create that as well.

    ------------------------------
    The Users are always right - when I'm not wrong!

  • November 7, 2005 at 6:34 am

    #602570

    I wish to create a land use management data warehouse from Census data, household budget survey data, agricultural survey data, business register for a specific region. Secondly what modules do I need to have for sql server 2000. Tried oracle but failed to keep it running.

     

    Andy

    Kindest Regards,

    ABurton

  • November 7, 2005 at 9:45 am

    #602626

    Have you been given a sql server database?

    You will need one. If the data is in oracle, get an oracle person to import the data from oracle into sql server into some new tables.

    Once you get the data, you can then create the warehouse.

    ------------------------------
    The Users are always right - when I'm not wrong!

  • November 8, 2005 at 12:30 am

    #602729

    Hi Guys,

    I looking around otherwise what modules do I need to have in sql server 2000 enterprise ed.

     

    Kindest Regards,

    ABurton

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply