1 TeraByte Project on top of MS-OLAP 
Author Message
 1 TeraByte Project on top of MS-OLAP

Hi Friends,

I would like to share with you a nice Data warehouse project, that was
done by  a company called "dataware", with cooperation of HP and
Microsoft.

Contents of the Data Warehouse:
The SQL database of the data warehouse had a size of 1.1 TB and was
created by simulating sales data from a fictional firm for 70 months.
A register of 5000 products sold at 1000 sales locations was listed in
the database with information about 3000 clients. A table with 240
million lines and a gross size of 16 GB was created every month. It
involves a total of 16.5 billion entries broken down into
day-customer-product-sales location.
Putting that amount of data generated on the power platform into text
files took 53 hours, 19 hours to the Microsoft SQL Server, and
creating the multidimensional cubes from this data with the help of
Microsoft SQL Server Analysis Services took 50 hours.

If you found it interesting, please download the full article about
the 1TB project from:
HTML: http://www.***.com/
PDF: http://www.***.com/

Yours,
Eynav Azarya, Panorama



Sun, 18 Jul 2004 22:24:57 GMT
 1 TeraByte Project on top of MS-OLAP

Quote:

> If you found it interesting, please download the full article about
> the 1TB project from:
> HTML: http://www.systemonline.cz/site/data-warehousing/terabyte-e.htm
> PDF: http://www.terabyte.cz/terabyte_hr.zip

Please regenerate the PDF with more sensible settings, over a megabyte
per page doesn't make sense. Putting real info instead of marketese
in it would also be nice.

Stephan Eggermont
Sensus, systems that make sense



Mon, 19 Jul 2004 06:28:30 GMT
 1 TeraByte Project on top of MS-OLAP
I gotta read this newsgroup more often.

Here's part of a note I sent to Eynav when I got his PR:

        Do you really think simulated implementations like this are
worthwhile?  For instance, I'll bet that over the 70 months, not one of
the 5000 products or 1000 locations or 3000 clients was added or
discontinued.  Am I right?  There's a lot more to real-world problems than
volume.

All the same, the Panorama products look pretty good.  I'll have to try
them out one of these days.

                        Seth

Quote:


>>If you found it interesting, please download the full article about
>>the 1TB project from:
>>HTML: http://www.systemonline.cz/site/data-warehousing/terabyte-e.htm
>>PDF: http://www.terabyte.cz/terabyte_hr.zip

>Please regenerate the PDF with more sensible settings, over a megabyte
>per page doesn't make sense. Putting real info instead of marketese
>in it would also be nice.

>Stephan Eggermont
>Sensus, systems that make sense



Mon, 26 Jul 2004 11:47:15 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. 23944-FL-Jacksonville-ORACLE Financials-Project Management-MS Project-PROJECT MANAGER / MS PROJECT

2. MI-Detroit-237174--ABT Workbench-MS Project-Project Workbench-Visio-MS Excel-MS

3. AZ-Phoenix-267336--MS Project-ORACLE-MS Word-MS Excel-Costs/Scheduler Planner Analyst

4. NY-NEW YORK-93077--Rational Rose-Life Cycle Applications-MS Excel-MS Project-MS

5. ON-TORONTO-323525--Project Management-Leadership-MS Project-UDB-RS/6000-Windows

6. NJ-Somerset-106025--MS Project-SUN-IT Project Manager

7. NJ-Somerset-106025--MS Project-SUN-IT Project Manager

8. 11381-FL-Miami-AS400-RPG-CL-Communication Skills-Project Management-MS Project-M

9. NJ-Somerset-106025--MS Project-SUN-IT Project Manager

10. 11381-FL-Miami-AS400-RPG-CL-Communication Skills-Project Management-MS Project-M

11. 11381-FL-Miami-AS400-RPG-CL-Communication Skills-Project Management-MS Project-M

12. 11381-FL-Miami-AS400-RPG-CL-Communication Skills-Project Management-MS Project-M


 
Powered by phpBB® Forum Software