I doubt it, because the foreign key constraints are not used
in the PS-MOPS schema in MySql, as described in the README file from
https://www.lsstcorp.org/docushare/dsweb/View/Collection-613.
This implies that the relationship between tables are defined only
implicitly, and I wonder if this would remain or change.
Bongki
On Wed, 7 Jun 2006, Jeffrey P Kantor wrote:
> Hello all,
>
> If we can get a copy of the MOPS schema in SQL, we can import it into
> Enterprise Architect to create the ER diagram. Jacek Becla knows how to do
> this and the "gotchas" to look out for.
>
> Jeff
>
> > From: Bongki Moon <[EMAIL PROTECTED]>
> > Reply-To: LSST Data Management <[email protected]>
> > Date: Tue, 6 Jun 2006 21:48:59 -0700 (MST)
> > To: LSST Data Management <[email protected]>
> > Subject: [LSST-data] Minutes of UA CS MOPS meeting for 06/06, 2006
> >
> > Minutes for UA MOPS meeting, June 06, 2006
> >
> > In attendance:
> > Kobus Barnard, Bongki Moon, Francesco Pierfederici (phone), Praveen Rao,
> > Mohamad Hegazy
> >
> > Main points:
> >
> > o Mohamad Hegazy joined us for the metting. He is an MS studnet in CS who
> > is potentially interested in joining the team. This is good news because
> > Scott Morris will be reducing his time commitment to the project. We are
> > hopeful that Mohamad will pick up some of Scott's duties in the upcomming
> > weeks.
> >
> > o Praveen discussed Rob Jedicke's documents regarding the overview of
> > operations, software for orbit proximity, use of JPL package, file
> > format,
> > etc.
> >
> > o Francesco reported that what we call the "progjection pipeline" is far
> > from finished in the PanSTARS system. Since this is a critical piece of
> > infrastructure for our approach, it is a likely candidate for
> > co-development. The issues are congruent with Praveen Rao's research
> > interests, but we are open to dicsussion on how to distrubute the
> > development.
> >
> > o Francesco said PS is willing to provide us with accounts on their
> > machines
> > so that we can have access to the JPL package. More detail should come
> > forth.
> >
> > o Francesco was asked to investigate more on the database schema design,
> > whose overview was given us in a pdf format. Among others, there was
> > a few design issues around the tracklets and orbits. Examples are:
> > Is an orbit stored as a collection of tracklets? How are they related
> > to each other in the schema design, via a foreign key? Is any ER-diagram
> > available?
> >
> > _______________________________________________
> > LSST-data mailing list
> > [email protected]
> > http://www.lsstmail.org/mailman/listinfo/lsst-data
> >
>
> _______________________________________________
> LSST-data mailing list
> [email protected]
> http://www.lsstmail.org/mailman/listinfo/lsst-data
>
_______________________________________________
LSST-data mailing list
[email protected]
http://www.lsstmail.org/mailman/listinfo/lsst-data
