Professional Web Applications Themes

Datawarehouse ? - Microsoft SQL / MS SQL Server

What is a Datawarehouse and how does it differ from Database? I know how to create Database in SQL Server. How do we create DataWarehouse in SQL Server? Sender...

  1. #1

    Default Datawarehouse ?

    What is a Datawarehouse and how does it differ from Database? I know how to
    create Database in SQL Server. How do we create DataWarehouse in SQL Server?

    Sender


    Sender Guest

  2. #2

    Default Re: Datawarehouse ?

    Hi,
    Basically datawarehouses are a central repository for all your data in
    de-normalised (not always) format.

    For example you might have a the following

    Sales table (Sales key, Customer Key)
    Sales details(Sales key, Product key)
    Product table (Product Key)
    Payments table (Payment KEy, Sales key,Customer key)
    Customer Table(Customer key)

    In the warehouse you might have a table which has all the details from the
    above in one table instead of a query
    You might also have monthly sales summary tables.
    Basically anything that makes data retreival quicker and easier, always
    remembering the datawarehouse is a readonly item.

    There are other features as well. like datawarehouses are typically on
    seperate machine (to reduce server load)

    --
    I hope this helps
    regards
    Greg O MCSD
    SQL Scribe Doentation Builder
    Doent any SQL server database in minutes
    Programmers love it, DBA dream of it
    AGS SQL Scribe download a 30 day trial today
    [url]http://www.ag-software.com/ags_scribe_index.asp[/url]


    "Sender" <userdomain.com> wrote in message
    news:eWofv%23cRDHA.1688TK2MSFTNGP11.phx.gbl...
    > What is a Datawarehouse and how does it differ from Database? I know how
    to
    > create Database in SQL Server. How do we create DataWarehouse in SQL
    Server?
    >
    > Sender
    >
    >

    Greg Obleshchuk Guest

  3. #3

    Default Datawarehouse ?

    Check out this site, it has several links by author Ralph
    Kimball.

    [url]http://www.intelligententerprise.com/ports/search_dw_fund[/url].
    shtml

    HTH

    Ray Higdon MCSE, MCDBA, CCNA
    >-----Original Message-----
    >What is a Datawarehouse and how does it differ from
    Database? I know how to
    >create Database in SQL Server. How do we create
    DataWarehouse in SQL Server?
    >
    >Sender
    >
    >
    >.
    >
    Ray Higdon Guest

Similar Threads

  1. datawarehouse load
    By utkanbir in forum Informix
    Replies: 1
    Last Post: August 15th, 03:34 PM
  2. Replies: 0
    Last Post: January 11th, 07:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139