SQL Server Performance

Data warehousing & data mining

Discussion in 'Analysis Services/Data Warehousing' started by riya, Sep 5, 2005.

  1. riya New Member

    Hi,

    I am new to data warehousing & data mining. Can somebody please explain both of these & also their differences? Also please let me know what tools are available for each of them. Is there any in-built feature in SQL 2000 which provides these. Then please brief me on that too...

    Thanks & Regards


    Riya
  2. ranjitjain New Member

    Hi Riya,
    Data Warehousing is a very broad topic.
    So you need to refer to diffrent books or tutorials over the net on these topics.
    Ofcourse SQL 2000 has various tools to accomplish Data Warehousing.
  3. Akthar New Member

    Hi Riya,

    Yes you do have tool in SQL depends on what you want to do:
    You have SQL Analysis Services with CUBE Designer and ALSO DTS, Where by you can create your DATAWAREHOUSE

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  4. Akthar New Member

    You can start by Installing SQL ANALYSIS SERVICES, you'll get the BOOKS ONLINE help also have a look at<a target="_blank" href=http://www.databasejournal.com/features/mssql/article.php/3503201.>http://www.databasejournal.com/features/mssql/article.php/3503201.</a><br />I hope this help[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />AKTHAR DILMOHAMUD<br />65 BENARES ST<br />PORT LOUIS<br />MAURITIUS
  5. satya Moderator

  6. Akthar New Member

    Hi,

    see if this helps:http://www.olap.com

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
  7. satya Moderator

    Akthar
    The link you've specified refers to a third party tool provider and I have no idea how they can help in this regard.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. Chatterjee New Member

    A warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process...as per Bill Inmon

    We can mine the data after making data warehouse. Mining allways highlights the hidden feature in the data.I can give you an example...

    Suppose for create a Good Quality "ABC" product a,b,c,d,e ingredients are needed...
    But c ingredient is too costly for the manufacturer...
    Now they want to reduce the producing cost of "ABC" ..but they don't want to compromise with the quality of "ABC".. Now how is it possible??.. So some other ratio of raw materials can fulfill the requirement.. For that purpose different analysis is necessary.. Like Nural Analysis/Clustering Analysis(Different Ways) etc...

    So ultimately we can say data warehouse is possible without data mining but data mining is not possible without data warehouse.. Because data mining is the extended requirement of data warehousing..

Share This Page