Документ взят из кэша поисковой машины. Адрес
оригинального документа
: http://www.sai.msu.su/~megera/oddmuse/index.cgi/sncat_proposal
Дата изменения: Unknown Дата индексирования: Mon Apr 11 08:01:07 2016 Кодировка: Поисковые слова: meteor shower |
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: