Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kirun
Yak Posting Veteran
60 Posts |
 Posted - 2002-03-09 : 02:08:31
|
| hi thereI m working on SQL sever 2000. How can we can we make datawarehouse out of a already built database. Actually we are working or i would rather say experimenting on OLAP . When we start on this we havent have a slightest idea on OLAP .but as we worked on that we found that there are dataware houses and datamining techniques in that .But before knowing this we have built all fact tables and all cubes etc etc.Now we want that there should a dataware house so that we can mine our cubes and get the results..I need to know that is that possible that we can now make a dataware house.. OR any one can just point out our mistake or can point out the guidline that how can we make the dataware house. And what are the factors which must be in out mind before making a database can n e busy just point out the website or any sort of resource which can help us in this matterOne more thing does n e buddy know n e sort of tool in sql server which will give the result of data mining or of cubes in graphical way or in visual way.. not in that way which sql server shows in meta data pane. form example plyanalysit and procalrity..thanks in advance |
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2002-03-13 : 00:16:39
|
| hey no answers ..... |
 |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-03-13 : 00:37:09
|
Kirun,For a start a "datawarehouse" is a buzz word...Question: What is the difference between a datawarehouse a database?Answer: Absolutely nothing!The realtity is however, that a datawarehouse is usually read only to the end user. It is primarily used to store historical data and take load of a production (read OLTP) system.The Analysis Service part is a completely different animal. It is simply a (as the title states) an analytical engine. It has a different query engine (MDX) and lots of lovely statistical functions.Analysis Services can take data from just about any data source.. Text files, databases, spreadsheets etc.. Notice however there is no driver for a "datawarehouse"!  As for further information.. funnily enough Microsoft has extensive information.. As for the data mining output.. wouldn't know and frankly don't care.You only have a choice of 2 algorithms out of the box for data mining.If you really need to serious analysis on sets of data, then Statistica or Mathimatica are (IMHO) the end game tools...HTHDavidMTomorrow is the same day as Today was the day before. |
|
|
|
|
|
|
about datawarehosue and analysis services