[Smwg] [EXTERNAL] SANA Registry Updates.

Thu Nov 7 19:38:34 UTC 2019

Hi Colin,

Glad to hear that things are moving along.  It's really what is needed for the SM WG and also for the whole registry concept to provide the value it was designed to deliver.  So thanks for picking up the flag and marching it downfield.

Other comments, etc <<in-line>> below.

Cheers, Peter

From: SMWG <smwg-bounces at mailman.ccsds.org> on behalf of Colin Haddow <Colin.Haddow at esa.int>
Date: Thursday, November 7, 2019 at 9:37 AM
To: SMWG <smwg at mailman.ccsds.org>
Cc: "EXTERNAL-Reynolds, John G (9110-Affiliate)" <john.reynolds at esa.int>, Erik Barkley <erik.j.barkley at jpl.nasa.gov>
Subject: [EXTERNAL] [Smwg] SANA Registry Updates.

Hi Peter,
                  okay I'm going to be responsible for coordinating the updates for the ESA entries in the SANA registry. Is there any documentation on the underlying database design ? As far as I can figure out the main relations (ignoring Operator and Owner etc.) for the Sites Service and Apertures registry is with the Aperture and Aperture Link registry, similarly for the Spacecraft ID the main relation would appear to be with Spacecraft.

<<The database design, per se, is abstractly defined in the RMP, CCSDS 313.1-y-1.  Look at sec 2.4.6, 3.3.2.4, and at Annex B4.  We can, if need be, get the full database design from the SAANA, but I think these sections will spell out what the registries are intended to contain.  Your assumption about the SS&A relationship to the Aperture DB is correct.  I think fig B-5 spells it out pretty clearly. >>

Also with respect to the Contact registry for the ESA entries at least there are names that go way back in history and are long retired. Can these be removed from the registry or are they required to maintain consistency ? If they are required for consistency what would be the appropriate status to use to indicate that these contacts are no longer valid ?

<<We maintain the original contact who created entries and would need the names for consistency.  But we do also need to know who is currently responsible.  That can be determined by looking at the Contacts registry and filtering on AR.  Maybe that is a little obscure and we should think about adding a filtered link to the SS&A page (and the SCID registry page) that provides a hot link to the latest info.  Would that help?>>

Couple of other points that have come up during our initial discussions -
1.       On the spacecraft registry there is an alias field. This would also be useful on the Aperture Registry - could be used to handle things like DSN giving DSN station identifiers to ESA stations etc.
<<We do have a name and an abbreviation field.  I suspect that we can add an alias field as well, as we did for Spacecraft.  We probably will need to develop some guidelines about how to fill all of these fields out.  I was thinking we might need a sort of "cheat sheet" for these different AR roles.  We had not thought of that before, but as this turns real maybe we need to create such a modest guidance document.  How does that sound to you?>>
2.       One of the guys I'm working with (John Reynolds) is also involved with the IOAG Spacecraft Emergency W/G. He's told me that IOAG are considering setting up their own registry for use in that context as they've currently not found the CCSDS SSA very useful (not to mention out of date). We've had a quick look at the information contained in the various SSA related registries and think that pretty much all of the needed data is there (or at least will be once the registry is updated). Possibly what would be needed is some sort of query that pulls this together into a more useful format ?
<<Since the source of a lot of the current SS&A material was the earlier IOAG RF Asset DB what we have in the SANA, in a real database, should both look familiar and provide the needed functionality.  From a CCSDS / SM WG point of view I cannot imagine that we would not want to have the necessary info to handle S/C emergencies in the SANA SS&A DB.  I would think that having such a DB where you could find assets that were suitable to support emergency situations would be a really good thing.
That said, I would like to better understand what you really mean by "some sort of query that pulls this together into a more useful format ".  Just what would that "useful format" contain?  I am sure that we can ask the SANA Operaotr to build a specialized query to do whatever is needed, and display it in whatever way is needed, if only we knew what that was.>>

Once we've got a bit further with reviewing and updating the data I'll maybe organise a WebEx with you (and possibly the SANA operator) to disuss any changes (such as the above 2) that we think would be useful.

<<Whenever you are ready.  Let me know>>

Cheers for now,

Colin

Cheers, Peter

---------------------------------------------------------------------------------------------------------
Dr. Colin R. Haddow,
HSO-GI, European Space Agency,
European Space Operations Centre,
Robert-Bosch-Str 5,
64293 Darmstadt,
Germany.

Phone; +49 6151 90 2896
Fax;      +49 6151 90 3010
E-Mail;  colin.haddow at esa.int
---------------------------------------------------------------------------------------------------------

This message is intended only for the recipient(s) named above. It may contain proprietary information and/or

protected content. Any unauthorised disclosure, use, retention or dissemination is prohibited. If you have received

this e-mail in error, please notify the sender immediately. ESA applies appropriate organisational measures to protect

personal data, in case of data privacy queries, please contact the ESA Data Protection Officer (dpo at esa.int).
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.ccsds.org/pipermail/smwg/attachments/20191107/0af54a7e/attachment-0001.html>