March 23, 2012 at 9:50 am
Hello
I want to set up data warehouse, sql or oracle has tools for set up data warehouse?
how can i set up a data warehouse? how book i must study?
Best Regards
March 23, 2012 at 9:56 am
this is the book i used to learn warehouseing
March 23, 2012 at 9:56 am
IMHO, Ralph Kimball is your best bet.
http://www.kimballgroup.com/html/books.html
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 23, 2012 at 10:32 am
There are a lot of people with strong opinions on the data warehouse question. The first thing I would be looking at, though, is do you need a data warehouse, a data mart, or an operational data store. According to some folks, there is a big difference.
The differences, AFAIK, are 1) how many different kinds of data / number of sources, 2) update latency, 3) access needs, and 4) turnover (archiving).
In my workplace, they actually do make a big deal about the differences and the fact that each has its proper place.
March 23, 2012 at 11:38 am
Thank you for answering, is there any software for create data warehouse in sql or oracle?
March 23, 2012 at 11:54 am
farnaz224 (3/23/2012)
Thank you for answering, is there any software for create data warehouse in sql or oracle?
SQL Server is the software. So, too, is Oracle.
Data warehouses vary so much from business to business that there isn't a one-size-fits-all package you can unwrap. Basically, you use the database software tools to create what you need. That includes T-SQL, SSAS, SSRS, and SSIS.
March 26, 2012 at 4:51 am
Currently there are two main architectures approaches: Inmon and Kimball. Kimball is a quickstarter and you'll get quick results. The problem with Kimball architectures are the adaptibility in case of changing business processes, auditability or handling the different demands of the business. So choose Kimball in case you have a tight schedule, strict goal and you want quick results (also it's optimized for cubes (or the other way around 😉 )).
In case you have more time to build i would suggest looking at the Inmon architecture. Inmon architecture are created from a profound base and you'll generate the (kimball)starschemas from the base (virtual or not). This enhances different varying demands from the business and last but not least the auditability is further improved because you store the information AS IS in the base layer. For the base layer you could use model techniques like a 3NF, Datavault or anchor modeling. I would recommend Datavault or Anchormodeling.
Look into some blogpost from me and take a look at a research document Watson & Ariyachandra.
Inmon vs Kimball according to....Inmon himself
Kimball vs Inmon (Part II) : it's now scientific.
Data Warehouse Architectures: Factors in the Selection Decision and the Success of the Architectures
March 27, 2012 at 2:33 pm
This is one of those "how high is 'up'?" questions, and the answer(s) depend on your specific needs. You can go with the free-as-in-beer solutions like SSIS/SSRS/SSAS or punch it up with Cognos or Business Objects (my weapon of choice) or many other products on the market. I don't think you're going to get a single answer because you're going to need someone who is sitting down with you to understand what you're wanting to accomplish, what you have available, and, ahem, how much you're willing to spend.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply