RE: Database Archive

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Tue, 13 Apr 2004 15:10:59 -0700
Message-ID: <26E3EC48949D134C94A1574B2C89466113A836@exchange2.slac.stanford.edu>

We've been using an HSM, HPSS, for quite a while for the event data from the Babar expeirmment. The current database size in 895.0 TB. We're also moving away from Objectivity database toward the Xroot file system, which was developed with physics data in mind. I scanned the article Jared posted quickly, but didn't catch any mention of power-managed disk arrays. These keep the nearline storage on disks which are normally powered-down, but spin up when they need to service a request. I believe the acronym MAID has been coined for these systems.

Ian MacGregor
Stanford Linear Acclerator Center
ian_at_slac.stanford.edu

-----Original Message-----

From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com] Sent: Monday, April 12, 2004 2:40 PM
To: oracle-l_at_freelists.org
Subject: Database Archive

First off, this is not about archive logs. It is about archiving data. ie. moving data from your database to an offline system or moving it to nearline storage (HSM, etc)

I was reading an article in Computerworld about this:

http://www.computerworld.com/databasetopics/data/software/story/0,10801,90819,00.html

Or just go to computerworld.com and type in QuickLink 44949

What struck me about this article is twofold

archiving data to improve performance
the databases they refer to don't seem all that large.

I would think that given a decent database to work with (Oracle) and someone fairly knowledgeable to run it, achieving acceptable performance would not require moving data out of the database.

For instance, one of the databases referred to is 100G is size.

Many of us have tables larger than that.

Just wondering what others reactions to this article are.

I plan to write a letter to computerworld regarding this, but thought it a

good idea to weigh in here first.

Thanks,

Jared

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Apr 13 2004 - 17:32:01 CDT