RE: Database Archive
- From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Apr 2004 15:10:59 -0700
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@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: Jared.Still@xxxxxxxxxxx [mailto:Jared.Still@xxxxxxxxxxx]
Sent: Monday, April 12, 2004 2:40 PM
To: oracle-l@xxxxxxxxxxxxx
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
1) archiving data to improve performance
2) 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@xxxxxxxxxxxxx put 'unsubscribe'
in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
