LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 1996, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 7 Jun 1996 17:58:41 GMT
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "John Z. Zhao" <jzz@LONGHORNS.QUANTUM.EPSILON.COM>
Organization: Epsilon Data Management
Subject:      Re: Using SAS with DB2-Tables

SAS is not a RDBMS system. It's understandable for the company to chose DB2 over SAS, even thought SAS Inc. has been trying very hard to have its share on data wareshouing. But from DBMS's view point, RDBMSs such as DB2, SYBASE are much easier to build a data warehousing, specially when it is VLDB (very larage database). SAS still has long way to go in this area.

SAS does have some advantages on data wareshouing applications. It has a full range of analytic and desk-top tools for statistical analysis, data mining and reporting writing. SAS/ACCESS together with SAS/CONNECT would enable SAS application developers, both using MVS and PC, to port some of your application or develop application READING data from DB2 tables. It would be very difficult to put SAS output back to DB2 tables.

I have been trying to use SAS to update DB2 tables in VLDB. Performance is not encouraging at all.


Thomas Kregeloh (100577.1775@CompuServe.COM) wrote: > I am building a large data warehouse for an insurance company. The > DWH will be held on an MVS-Host. > It is intended to use DB2 instead of SAS-Tables for all of the > tables. > Any comments / experiences etc. are very welcome.

> Thomas Kregeloh, Hamburg

-- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=-=-=

Internet: Epsilon Data Management Tel: 617-273-0250 x6219 Fax: 617-272-1760


Back to: Top of message | Previous page | Main SAS-L page