From - Fri Mar 16 16:02:55 2001 Received: from fnal.gov (infnts.ts.infn.it [140.105.6.150]) by quark.ts.infn.it (8.9.3/8.9.3) with SMTP id AAA05733 for ; Fri, 16 Mar 2001 00:55:08 +0100 (MET) Received: from fnal.gov (131.225.9.20) by INFNTS with TCP/IP SMTP; Fri, 16 MAR 01 00:55 CET Received: from fnal.gov ([131.225.233.212]) by smtp.fnal.gov (PMDF V6.0-24 #37519) with ESMTP id <0GA800A78UV8GL@smtp.fnal.gov> for Stefano.Belforte@ts.infn.it; Thu, 15 Mar 2001 08:57:08 -0600 (CST) Date: Thu, 15 Mar 2001 08:57:08 -0600 To: r.stdenis@physics.gla.ac.uk Cc: Stefano Belforte , Igor Gorelov , franco.semeria@bo.infn.it Message-id: <3AB0D844.FF20703B@fnal.gov> MIME-version: 1.0 X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-1.3.0f2smp i686) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en References: Sender: From: Jack Cranshaw Subject: Re: DB export to Italy Stefano, Have you tried just using the oracle client which you get distributed automatically with the offline software? If you've had problems, then please send us the numbers on performance or lack thereof. But I would actually push people to first try just using the database at Fermilab. One indicator that this may serve well is that Vladimir who works with silicon now does his work on a machine at Texas Tech because the PC there is faster than anything available at Fermilab, and although the network connection is poor, the database access is not noticeably different than at Fermilab. We're slowly getting a handle on the export, but I don't see a viable export of all the pieces of the database that you need for analysis for at least one month. Due to the chronically undermanned effort given to the database software, things move slowly. Offers of help are gladly appreciated. Cheers, Jack "Rick St. Denis" wrote: > Dear Stefano > I have not heard from Mark for some time and lost touch with operations > of the database as I have been teaching since February. > So the proposals and intentions for export were fine, but needed action > from proponents. Jack has had to put as first and only priority the second > commissioning run. Er. I mean Run II. So I am frankly not sure what > happened to export and could not chase it. > We can mumble lots about who has responsibility to provide what, which > commmittee wants what thing, but if you really want to get the full CDFDB, > then I think we need someone who is doing what Igor Gorelov of New Mexico > has done. He has studied oracle, having taken official courses, set up a > server on a linux box at new mexico and started replication to it. He is > now going to FNAL for 6 months having realized how much he needs to know > to actually get a server working and how much he can learn from the > Fermilab Computing Division people, like Nelly Stanfield and others. > But even then, you have a whole new problem: the network > connectivity. The fact is that when we modify the schema -- and we do > this more than we would have liked -- we have to wipe out the replication > and refresh it all. As the database has grown, this becomes quite > demanding! > Also, when you talk about the full database, you probably dont want > every silicon raw calibration. But to pick and choose, you need mark's > solution. If you go with the oracle solution, you are looking at a lot of > work and resource usage. Kinda like buying a jaguar. > I will try to find out therefore what mark is up to, but suspect i will > not get a lot of happiness. > cheers > rick > > ***************************** > Dr. Richard St. Denis,Dept. of Phys.& Astr., Glasgow University > Glasgow G12 8QQ; United Kingdom; UK Phone: [44] (141) 330 5887 > UK Fax : [44] (141) 330 5881 > ====================================== > FermiLab PO Box 500; MS 318 Batavia, Illinois 60510 USA > FNAL Phone: [00] 1-630-840-2943 FNAL Fax: [00] 1-630-840-2968 > Sidet: [00] 1-630-840-8630 FCC: [00] 1-630-840-3707 > > On Wed, 14 Mar 2001, Stefano Belforte wrote: > > > Rick, > > given the kind of network connectivity we have among italian sites, > > and between Italy and Fnal, it make sense for us to look for a > > solution that exports the full CDF DB to just one place and then > > processes running all over Italy could access this common location > > rather then having local copies. > > This would hoepfully simplify our work over there. > > While this sort of naturally blends (I think) with a full blown > > Oracle replica, it may still be a work-saving solution also for > > the freeware export. > > Franco kindly offered to set up this on a central server in Bologna > > if/when a proper technical proposal is singled out. > > We very much need your opinion and input on this and definitely > > would like to talk about it sometimes in the next couple of weeks > > when Franco will also be at Fermilab (I am at Fnal all months). > > We definitely can start by e-mail, just as you find more convenient. > > > > Looking forward to hearing from you > > Stefano > > -- > > Stefano Belforte - I.N.F.N. tel : +39 040 375-6261 (fax: 375-6258) > > Area di Ricerca - Padriciano 99 e-mail: Stefano.Belforte@ts.infn.it > > 34012 TRIESTE TS - Italy Web : http://www.ts.infn.it/~belforte > > at Fermilab: CDF trailers 169-N tel: (630)840-8698 > >