[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | Executive Information Solutions & Data Warehousing Conference |
| Notice: | Welcome to the Data Warehousing conference |
| Moderator: | 26002::HAGGERTY |
|
| Created: | Thu Sep 01 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 499 |
| Total number of notes: | 2932 |
Hello!
Got contacted by a consultancy company who is answering a DW-bid.
The solution is based on Oracle, choice of UNIX or NT. (have suggested UNIX
so far)
Not a large solution compared to some the discussions in here about TB
databases, but still we need some help sizing a configuration.
The data we've got so far:
- 75 mill orderlines
- 1.4 mill lines of invoices
- 20000 lines of resellers
- 9000 lines of number of articles
- 14000 lines of articles_sold
- 2.7 mill lines of reseller_sold
- 10 suppliers
- load 500.000 lines once a week
- 10 concurrent users
The customer anticipate this to be max 30 GB, the consultancy company
anticipates it to be 50 GB.
They have defined lots of queries and reports against this data.
The require tuning of "normal" reports so that the response time is 3 sec or
less.
The consultancy company can design and implement the database as best fit.
I know this might not be enough data to do proper sizing, but I hope that you
have some suggestions.
- Is UNIX the correct platform, or is NT ok too?
- Which server 4*000 or 8*000?
- Memory?
- Numbers of CPU?
- special needs for the I/O-system?
- Oracle VLM?
-.....
Thanks in advance
Bjorn Au!
Norway
[Posted by WWW Notes gateway]
| T.R | Title | User | Personal
Name | Date | Lines
|
|---|