 |
|||||||||
|
|||||||||
|
|
Dear Sybase User;
For those who were able to make this seminar, it was a very interesting and informative talk by Mr Jeff Bulter of the United State Internal Revenue Service and their efforts to develop a data warehouse. Jeff' presentation was excellent and covered many of the technical, management and people hurdles that the IRS has over come to build the existing common data warehouse system. Approximately 40 people were signed up with just over 30 people actually attending. Those people who attended were extrememly interested in the IRS presentation and asked many pertainent questions. Also in attendance were actual users from Statistics Canada who have actually implemented a data ware house using Sybase's new IQ database.
During Jeff's presentation, he made some very interesting points. Here are some of the major highlights:
1) The current CDW data warehouse is 72 terabytes in size.
2) The Data Warehouse should grow to around 100 terabytes by this year end.
3) Sybase IQ is the main reason that they can actually support this kind of data volume.
4) IQ is 20 times less expensive than TeraData (10x better just in th e licensing aspect). The IRS has Terdata but is phasing it out.
5) Sybase IQ can summarize 500M rows in 2-3 seconds!
6) Do not waste your time trying conventional RDBMS like SQLServer, Oracle, DB/2, etc.
7) The largest table in the Data Warehouse is just over 3 billion rows!
8) Sybase IQ is running on Sun hardware with up to 500 users!
9) The IRS has built their own on-line web "meta data" repository for the Data Warehouse.
10) Jeff was with the Department of Transportation where he also built a large data warehouse using IQ.
11) Data Ware house users have tools like SAS, DataFlux, Excel, Business Objects, etc that all interface to IQ.
As you can tell from the above highlights, the presentation was filled with vital infortmation for those thinking of venturing into the data warehouse realm. We hope to be able to post some of the slides on this site soon. So come back and visit this Blog soon!
Regards ... Chris Pollach
