Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    2

    Question Data warehouse design consderations?

    Hii All,

    I am new to data warehousing. If some one could let me know what are the design consideration for database design used in data warehousing. Right now i have made a i design but i how do i check wheather it is good design for date warehousing? So let me know the check points and other things that i should keep in mind while i design my database for data warehousing?

    Regards
    Debugger

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by sumit_vij11
    how do i check wheather it is good design for date warehousing?
    what are some of the information requirements? for example, if you make a data warehouse for an ecommerce web site, you might want to answer questions like "which regions have the highest rate of abandoned orders?" or "what product lines have the least profitability?"

    one sure way to measure whether a data warehouse design is any good is to try some of the queries against it that it was built to satisfy
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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