To quote a no-name former employee, "if you run out of room in the data = center for disk drives, go build another building." Ya right!!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: MacGregor, Ian A. [mailto:ian@xxxxxxxxxxxxxxxxx] Sent: Wednesday, September 08, 2004 12:43 PM To: Jared.Still@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: How to store 50 Terabytes per day? Before replying please see: http://www-search.slac.stanford.edu:8765/query.html?col=3D3Dslacweb&col=3D= 3Dt=3D odays&col=3D3Dssrlweb&col=3D3Dslacpubs&col=3D3Dbabarweb&qt=3D3Dlsst&chars= et=3D3Diso=3D -8859-1&qc=3D3Dslacweb+todays+ssrlweb+slacpubs+babarweb Then choose "LSST for SDSC". This is a powerpoint presentation about = =3D the project that contains some information on the computing =3D requirements. Problems with Oracle: What is the maximum number of partitions for a = =3D database? Will hierarchical file management systems does it work with? = =3D What if that system needs to be extende?. Is Oracle's one-cluster hence = =3D one-architecture technology right for the project? Does Oracle RAC tie = =3D you to a single vendor? Can RAC's communicate with other RAC's? Does = =3D anyone think this will be done using RAID10. I'm not sure how much of the data will be online annd how much will be = =3D nearline storage. =3D20 Ian Macgregor Stanford Linear Accelerator Center ian@xxxxxxxxxxxxxxxxx =3D20 =3D20 =3D20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx =3D [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of =3D Jared.Still@xxxxxxxxxxx Sent: Wednesday, September 08, 2004 9:08 AM To: oracle-l@xxxxxxxxxxxxx Subject: How to store 50 Terabytes per day? This quote appears in the following article:=3D20 http://www.computerworld.com/hardwaretopics/storage/story/0,10801,95694,0= =3D 0.html?nas=3D3DDM-95694 " When it's in operation in 2011 at a site still to be determined, the = =3D telescope being built for the LSST project will collect data at a rate = =3D of about 6GB (equivalent to one DVD) per 10 seconds, generating many =3D petabytes of data over time. One petabyte equals roughly 100 times the = =3D printed contents of the Library of Congress. The LSST project "pushes = =3D forward database technology dramatically," says Philip Pinto, a physics = =3D professor at Steward Observatory at the University of Arizona and a =3D member of the LSST project's board of directors. "The LSST database will = =3D probably be the largest known nonproprietary database in the = world."=3D20 So if you were faced with the task of storing 50 Terabytes per day, what = =3D kind of architecture would it require? Do you think Oracle would hold up with a transaction rate of 600 =3D Megabytes per second? The architecture of such a beast could drive out some interesting =3D developments for more general use. Jared -- To unsubscribe - =3D mailto:oracle-l-request@xxxxxxxxxxxxx&subject=3D3Dunsubscribe To search the archives - //www.freelists.org/archives/oracle-l/ -- To unsubscribe - = mailto:oracle-l-request@xxxxxxxxxxxxx&subject=3Dunsubscribe=20 To search the archives - //www.freelists.org/archives/oracle-l/ -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/