Meeting: Database Requirements for CCP4 Projects

17th October 2005 York University

Agenda

The agenda can be found here: agenda.html

Participants

Peter Briggs, Keith Wilson, Susy Griffiths, Chris Morris, Wanjuan Yang, Ronan Keegan, Graeme Winter, Kevin Cowtan, Eleanor Dodson, Paul Emsley, Charles Ballard, Dan Rolfe, Garib Murshudov, Liz Potterton, Fei Long, Steven Ness.

Summary

A summary of the meeting has been prepared by Wanjuan Yang and Peter Briggs:

• Meeting Summary [Word] [PDF]

Presentations

The following presentations are available for download as Powerpoint files:

• Introduction (Peter Briggs) [CCP4_DBS_MeetingIntro.ppt] [CCP4_DBS_MeetingIntro.pdf]
• CCP4(i)/BIOXHIT Database (Peter Briggs & Wanjuan Yang) [CCP4_DB_BIOXHIT_db.ppt] [CCP4_DB_BIOXHIT_db.pdf]
• "Database" usage and requirements for CCP4 Automation (Charles Ballard) [CCP4_DB_HAPPy.ppt] [CCP4_DB_HAPPy.pdf]
• Databases in e-HTPX (Graeme Winter) [CCP4_DB_eHTPX.ppt] [CCP4_DB_eHTPX.pdf]
• Crank and Databases (Steven Ness) [CCP4_DB_Crank.ppt] [CCP4_DB_Crank.pdf]
• CCP4i database overview (Peter Briggs) [CCP4_DB_CCP4i.ppt] [CCP4_DB_CCP4i.pdf]

A presentation by Chris Morris is also available from a password protected area:

• The Map Is Not The Territory: Some experience of software development using a data model [data_modelling.ppt]

Thanks to all the speakers for providing their presentations.

Outcomes

• CCP4 data model: we will now work on incorporating the requirements of the various participants into the CCP4/BIOXHIT data model.
• EBI data model: this has been suggested as a potential starting point for CCP4 data model. See a version here http://www.ccp4.ac.uk/peter/private/MSD-SQL/sql.html (password protected)
• Project glossary: it was suggested that we should maintain a project glossary which defines the common concepts. An example which could be used as a starting point for this project is here: example_glossary.html
  Another example is that for the PIMS project: http://www.pims-lims.org/project/glossary.html