Difference between revision 23 and current revision
Changed:
< There are several reasons to revise our [[http://www.sai.msu.su/sn/sncat/ SAI SN catalogue]].
< * First, we want to abandon historical monolithic table
to
> There are several reasons to revise our [http://www.sai.msu.su/sn/sncat/ SAI SN catalogue].
> * We want to abandon historical monolithic table
Changed:
< * Second, we want to
to
> * We propose to use sid (supernovae identificator)
> as a reference name instead of Zwicky's nomenclature, see [[sid details]] below;
> * We want to
Changed:
< [http://www.ivoa.net/Documents/latest/UCD.html IVOA UCD convention], [http://cdsweb.u-strasbg.fr/UCD/ucd1p-words.txt Strasburg list];
< * Third, we propose to use sid (supernovae identificator)
< as a reference name instead of Zwicky's nomenclature, see [[sid details]] below;
to
> [http://www.ivoa.net/Documents/latest/UCD.html IVOA UCD convention], [http://cdsweb.u-strasbg.fr/UCD/ucd1p-words.txt CDS Strasburg list];
Changed:
< * Supernovae - Galaxy ('''sn_galaxy_map''') - (sid,tid)
to
> * Supernovae - Galaxy ('''sn_galaxy_map''') - (sid,gid)
Changed:
< The supernova designation, in the standard form, as recommended by the [[http://cdsweb.u-strasbg.fr/viz-bin/Dic?/7116560 Dictionary of Astronomical Nomenclature]], consisting of the 'SN ' prefix followed by the year it was discovered, and then (if there were multiple supernovae in a particular year) either the upper-case letters 'A' through 'Z' (for the first 26 SNe discovered in a given year) or the lower-case letters 'aa', 'ab', etc. (for the 27th, 28th, etc., SNe discovered in a given year).
to
> The supernova designation, in the standard form, as recommended by the [[http://vizier.u-strasbg.fr/viz-bin/Dic?/7224509 Dictionary of Astronomical Nomenclature]], consisting of the 'SN ' prefix followed by the year it was discovered, and then (if there were multiple supernovae in a particular year) either the upper-case letters 'A' through 'Z' (for the first 26 SNe discovered in a given year) or the lower-case letters 'aa', 'ab', etc. (for the 27th, 28th, etc., SNe discovered in a given year).
Changed:
< * poor capacity - it is not quite adequate even for current rate of supernovae discoveries and will certainly fail in near future
to
> * poor capacity - it is not adequate even for current rate of supernovae discoveries and will certainly fail in near future
Changed:
< names, but we suggest to use our sssid (Sai Sncat Supernova identificator)
< or just sid, for example, 'SN 10256'.
to
> names, but I suggest to use new nomenclature for supernovae, for
> example, 1965.23, which <b>roughly</b> indicates the year of discovery and its serial number in this year.
Changed:
< so we need to use arrays to store filenames in relations.
to
> so we need arrays to store filenames in relations.
Changed:
< * {sn.img} - array of images of galaxy with supernova, SNsid-#.ext. For example, SN10256-1.jpg
to
> * {sn.img} - array of images of galaxy with supernova, SNsid-#.ext. For example, 1965.23-1.jpg
Note: This is a WIP (work in progress) and intended for internal usage.
There are several reasons to revise our SAI SN catalogue.
Objects (primary keys are shown in parentheses):
Auxiliary maps:
These relations allows us to run basic queries
select s.*, g.* from sn s, galaxy g, sn_galaxy_map sg where s.name = '1972e' and s.sid = sg.sid and g.gid = sg.gid;
select s.*, g.* from sn s, galaxy g, sn_galaxy_map sg where g.name = 'NGC5253' and g.gid = sg.sid and s.sid = sg.sid;
select s.*, g.* from sn s, galaxy g, team t, sn_team_map st, sn_galaxy_map sg where t.name = 'SAI' and st.tid = t.tid and s.sid = st.sid and sg.sid = s.sid and sg.gid = g.gid;
[::sid details]
Primary keys are unique (by definition) and non-monotonic integers. Note, they have no special meaning. This looks questionable in regards to supernovae, because historically, supernovae are referenced by their name, introduced by Zwicky. But, actually, this is just a convention, a habit.
The supernova designation, in the standard form, as recommended by the [Dictionary of Astronomical Nomenclature], consisting of the 'SN ' prefix followed by the year it was discovered, and then (if there were multiple supernovae in a particular year) either the upper-case letters 'A' through 'Z' (for the first 26 SNe discovered in a given year) or the lower-case letters 'aa', 'ab', etc. (for the 27th, 28th, etc., SNe discovered in a given year).
Some notes about Zwicky nomenclature:
So then, I don't see any rationale in semantic of supernovae names, they are just unique identifiers. For compatibility reason we'll keep old names, but I suggest to use new nomenclature for supernovae, for example, 1965.23, which roughly indicates the year of discovery and its serial number in this year.
[::Images]
Images are stored in a special location known to application. There could be several images per object, so we need arrays to store filenames in relations.
Filename of images are in following conventions: