Ticket #406 (closed enhancement: worksforme)

Opened 10 years ago

Last modified 7 years ago

Merging MOPS schema into EA

Reported by: jbecla Owned by: fpierfed
Priority: normal Milestone:
Component: dbSchema Keywords:
Cc: Blocked By:
Blocking: #499, #500 Project: LSST
Version Number:
How to repeat:

not applicable

Description (last modified by fpierfed) (diff)

We are not going to black-box integrate DayMOPS into DC3a but rather shoot for full integration of PS-MOPS with the LSST pipeline framework for DC3b.

For this reason, the proposed database schema is fine.

Change History

comment:1 in reply to: ↑ description Changed 10 years ago by fpierfed

  • Owner changed from fpierfed to jbecla
  • Status changed from new to assigned

Replying to jbecla:

Need to merge MOPS schema into the baseline lsst schema.

Research and proposed changes done (by Serge). Initial merge in EA done (Jacek). Remaining tasks:

  • Clarify VARCHAR BINARY (Francesco)

Done

  • Clarify mops_Removals2Tracklets and mops_Attributions2Tracklets tables: do they provide one-to-one mappings? Might want to rename them (Francesco)

Done

  • confirm whether renaming mops_History to mops_Event is ok (Francesco)

Done

  • consider splitting mops_History into event type specific tables (Francesco)

Done

  • identifications2MovingObject:childId: ok to rename to movingObjectId? (Francesco)

Done

  • rename "status" columns. Suggestions: MovingObject.status --> MovingObject.mergedWithParent, DIASource.status --> DIASource.isDetected, _mops_EonQueue.status/mops_Tracklet.status --> processingStatus

Done

  • ok to rename tables and change plural to singular? (Francesco)

Done

  • Insert statements for mops_SSMDesc and prv_Filter: add to DC3 database initialization scripts (Serge)
  • Implement in EA (Jacek)

comment:2 Changed 10 years ago by jbecla

  • Owner changed from jbecla to smm

All changes done in EA, schema commited to DMS/cat/trunk/sql/lsstSchema4mysql.sql. Serge, please take care of "insert statements for mops_SSMDesc and prv_Filter: add to DC3 database initialization scripts (Serge)", then assign to Francesco for a final check.

comment:3 Changed 10 years ago by jbecla

  • Milestone changed from DC3b Apps DB Schema to DC3a Apps DB Schema

comment:4 Changed 10 years ago by smm

INSERT statements committed in [6255]. However, I notice that tables required by NightMOPS (as well as temp tables required by the association pipeline):

  • are missing from the schema
  • don't follow the naming conventions

In particular, there are two MOPS tables from DC2 we need to carry over: mops_pred (I suggest we rename this to mops_Prediction) and mops_ephem (-> mops_Ephemeris).

Do we want to introduce a special naming convention for tables used by pipelines to communicate to other pipelines or which are used internally?

comment:5 Changed 10 years ago by jbecla

  • Owner changed from smm to jbecla

The template tables (plus few others) were transfered from dc2 schema to dc3 schema.

comment:6 Changed 10 years ago by jbecla

  • Owner changed from jbecla to fpierfed

Francesco, please check the schema and make appropriate adjustments in your code. The schema is in DMS/cat/trunk/sql/lsstSchema4mysql.sql

comment:7 Changed 10 years ago by fpierfed

  • Blocking 500 added

comment:8 Changed 10 years ago by fpierfed

  • Blocking 499 added

comment:9 Changed 10 years ago by fpierfed

  • Status changed from assigned to closed
  • Resolution set to worksforme
  • Description modified (diff)
  • reviewstatus changed from notReady to reviewed

comment:10 Changed 7 years ago by robyn

  • Milestone DC3a Apps DB Schema deleted

Milestone DC3a Apps DB Schema deleted

Note: See TracTickets for help on using tickets.