From: "THOMAS SHEA 
Subject: My list and some thoughts

Hubert,

Below are my guesses for data quantities in the categories your table.  This is
pretty crude but it's a start.  I have also been painting pictures for myself
of data requirements from several points of view.  It is interesting how much
overlap there is between say focusing on a channel number centric system vs.
the cable plant documentation requirements vs. what we should record through
On-line. It's mostly the same data arranged differently.  A classic use for
relational systems. While it appears that it would be a quite complicated
arrangement, it certainly feels manageable and given some cleverness, could
turn out to be fairly simple.  I will share it after I have more time with it.

One thing we might want to discuss tomorrow is just what belongs in the
category headings.  It seems that there is a healthy hierarchy begging to come
out of those headings. While we should in principle consider all types of data,
actual drawings and photographs may well not end up in a structured DB.  For
instance, here at BNL, as there must be at LANL, there are already well
established methods for storing engineering drawings, but certainly cataloging
and indexing them makes sense. 

I made up the following list of categories for data to go into a structured
database. I had not gotten anywhere near guessing at sizes.  I think we need to
consider carefully whether things like actual CAD drawings and photos should be
stored in, or just be cataloged by the database system.

	SE&I
	- Catalog of mechanical drawing numbers, titles, and authors
	- Catalog of baselined drawings and documentation
	- PHENIX Nomenclature
	- Channel characteristics
	- Cable and pluming plant data
	- Catalog of electronic systems documentation
	- Survey data
	- QA documentation (or a catalog of such)

	PM
	- Index of PHENIX Notes	
	- List of institutions and participants with pertinent 
	  information (Phone Book)
	

Here I revise the list for the table. Somehow the more I look at the numbers
the more I think they seem small.

SE&I

Construction and QA data 
  QA documentation: a few (5)MB  
  Drawing and parts catalog: 2 MB
  Documentation of construction and cable plant: 	depending on 
    how it is done - 20 to 100MB
  Electronic documentation: several GB in ViewLogic 
  Integration model files: 500MB   

			- total . . . . . . . . . . several GB 
			- total in a structured DB: 27MB
-------------------------------------------------------------------

Calibration and Alignment
   Alignment data for all systems in the MFH hall from BNL survey: 0.5MB/year

			- total in a structured DB: 0.5MB/year
-------------------------------------------------------------------

Drawings
  Of common systems (carriages water & electrical, cooling, etc.: 200 MB

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

Digital photographs: 
  The movie is many many GB but I don't see it being included in 	
  anything we are doing.  So far there is no official photography effort in
  PM or SE&I

-------------------------------------------------------------------
Documentation: 
  Word and Excel and HTML files: A few (10 - 20)MB 

			- total . . . . . . . . . . 20MB 
			- total in a structured DB: 0

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

PM

Documentation: 
  Word, Excel, and HTML files A few (10)MB (I doubt if much of this stuff
  will go into a structures database system.) 
	 
  Phenix notes: 
    These are mostly on paper but the index and future notes may be
    in electronic form and could go into a DB.

-------------------------------------------------------------------
Otherwise this is a bad week to talk to folks in PM due to the DOE review of
RHIC.