Hi Nicole, This will go a long way toward getting us where we need to be! I have some good contacts via Iconix at EA, so we can apply additional "leverage" if needed. Please keep me posted on their progress against this list and let me know if I can assist. Thanks!
Jeff PS Let's also put a collection in docushare Data Management: Hardware and Software Deliverables for the UW prototype pipeline, and post the schema and database links there. Thanks again! > From: Nicole Silvestri <[EMAIL PROTECTED]> > Reply-To: LSST Data Management <[email protected]> > Date: Wed, 1 Mar 2006 16:41:45 -0800 (PST) > To: LSST Data Management <[email protected]> > Subject: Re: [LSST-data] Re: LSST Database telecon Wed Mar 01 > > Hi Jeff et al., > >> Schemas should be in Enterprise Architect whenever possible, in docushare >> otherwise. I understand that UW has some issues with the SQL generated by >> EA, so if an exception needs to be made, at least there should be a link to >> the schema within Docushare. There is a collection in Data > > Yes, Russell has had to spend a lot of time 'repairing' the SQL that is > generated by EA. This part of EA seems to be less robust than the UML > we've been using for the rest of the project. EA has been good about > responding to our bug reports and claims that the next release of EA will > have improved functionality in this area - they admit that they still have > some work to do. Sounds like they are willing to improve the database > section in a timely fashion - some of the bugs we reported have already > been addressed as they work on the latest version. > > Creating the UML in EA for databases is straightforward and relatively > simple to do. I see no issue with creating a merged schema in EA. > Perhaps by the time we have converged on a final schema, a lot of the > major issues we have encountered with EA's SQL generation will be > resolved. > >> (With regard to the EA SQL issues, we need them documented so that we can >> forward them on to EA support.) > > I have compiled the bug reports we have sent to EA along with our notes on > EA's database issues. Russell has added this list to our unsecured > database link here: > > http://www.astro.washington.edu/rowen/LSST/EABug_bullets.txt > > Unfortunately this list is a little incomplete. EA's bug reporting form > is web-based and does not generate a copy of the report. We unfortunately > were not very good about keeping notes on all of the little issues we > found/reported. The ones in this list are certainly the more agregeous > bugs/issues. We will continue to update this list as we trip across other > bugs and issues with EA's SQL generation. > > As a reminder - our database schema can be found here: > > http://www.astro.washington.edu/rowen/LSST/DBDocs/UWDatabase.html > > Please feel free to add these links to the docushare or plone (or anywhere > you see fit). > > Nicole > _______________________________________________ > 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
