Re: VLDB - 10TB

Hi Laurence,

first i would decide, if such a strong database growth really is necessary.
Perhaps it would be a good choice to take a less expensive format for the stored objects (jpeg, not gif, less colour resolution ...)

You could swap out old, not recent used data.

To my opinion, Oracle should be the better choice than MS SQL Server, if you deal with large databases.

In Oracle, you use logical Files for Storage (Tablespaces), which can be devided in multiple physical files (Datafiles). This can be used to overcome limitations in Filesystems or Device Drivers.

Under performance, administration and backup aspects it would be a good idea, to use multiple Tablespaces with multiple Datafiles. This could spread the IO load on many disks / IO Channels.

In Oracle you can do online backups, if the database is configured for it. Also you can do partial backups.
(Divide and rule ;-)
The main problem is, that the backup device(s) are at least as fast as your database grows.

There are many possible configurations to increase performance, nearer discussion would burst the scope of this short answer.

Regs. Lothar Received on Tue Apr 29 2003 - 17:26:21 CEST