Re: 21 terabytes at NYNEX

Michael E. Austin (austin_at_inmind.com) wrote:

: Unfortunately you are not thinking about the capabilities of the Digital
: platform. Using CI (cluster interconnect) you could put x CI controllers
: (at 70-100Mbits/sec) that can talk to 3-400 HSx Storage controllers which
: can handle a very large number of disk each.

My mistake... The maximum nodes in a cluster is 256, so the number of storage controllers will be less than 250. if you use correct HSx storage controller, You would be able to get the 21T that you require. Other things you will need to consider... How the heck are you going to back the sucker up? The backup utility for RDB (RMU/BACKUP or rmu -backup on Digital Unix) can now achieve 200Gb/hr backup speed. You cannot come anywhere near that with the other engine. RDB also allows you to load the database at a blindingly fast 3/4Tb in < 6 hrs. Among other VLDB features that actually allow you to manage the system. Consider this. You have a backup of a storage area (tablespace) and this tablespace is 200GB. You determine you have a single bad page in the database. With RDB, you can restore JUST THAT ONE PAGE and make it consistent WITHOUT having to restore the entire 200GB tablespace.

There is more to managing a VLDB than 'can I get enough disk space on the system'! Things to consider...

: : 21Tb therefore needs to be served by 12 Systems with a distributed
: : system, or more likely a using a series of data marts built on
: : a transaction repository.
 

: If you want REAL scalability use OracleRDB and VMS. It is a lot more
: stable and 1000 times more manageable when you get into database of this
: size. Especially since your filesystems can only be 2GB in Unix. VMS
: does not have this restriction. RDB (V7.0) allows for both horizontal AND
: vertical partitioning of your data. Does Oracle? And you would want to use
: this to manage this size of database. There are projects using this
: configuration that will exceed 100Tb in the next few years.
 

: : I wrote an article on this scale of system for the European Oracle
: : User Group and have built systems upto 5Tb.

: Michael Austin
: OracleRDB Independent Consultant
: austin_at_inmind.com
Received on Tue May 07 1996 - 00:00:00 CEST