Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 20 Aug 2001 @ 12:14:52 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Databases - 1 large or 4 small?
From:   Barbara George

We are in the process of re-designing our Teradata databases and I have some questions.

First, some background.
There are 3 separate companies involved, with possibly a fourth; the data is currently in 3 separate databases with slightly different formats. The new database will have the same format for all companies. One of the existing companies and the new company are extremely security-conscious.

Lookup and other shared tables are loaded into only one database, the others refer to these tables. Currently the loads run concurrently for all three companies, after the shared tables have been loaded.

Load times
Shared tables - 1,5 to 2 hrs
Company A - max 2,5 hrs
Company B - around 1 hour
Company C - around 0,5 hrs

Currently 90% of all queries are run against Company A, but users of Company B data will increase dramatically after the re-design. There are some users who require data from all companies; the majority of users require data from only 1 company at a time.

The size of the data for Company A is greatest, with Company B catching up quickly. Company C & D are small.

The query tool on the new database/s will be Microstrategy 7.

What will the impact on loading and performance be if all the companies are loaded into 1 database? What advantages/disadvantages are there to making one database or 4?

Barbara George
Manager, Business Information
Pick 'n Pay, Cape Town, South Africa

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020