Changes between Version 15 and Version 16 of dbSchemaUpdateApr09


Ignore:
Timestamp:
05/19/2009 09:41:49 PM (10 years ago)
Author:
jbecla
Comment:

added open issues/questions

Legend:

Unmodified
Added
Removed
Modified
  • dbSchemaUpdateApr09

    v15 v16  
    242242 
    243243 
     244{{{ 
     245#!html 
     246<span style="color:red"> 
     247Issues to be discussed: 
     248<ul> 
     249 <li>coord-system (no ra/dec, no x/y, just per-model ra/dec + "bestModel" ok?). 
     250 <li>Redshift/probability distribution function. 
     251 <li>Segmentation info (parentId + number of children). Kinds of queries?  
     252 <li>Really no scalegrams?  
     253 <li>Max variation between ra/dec from different models? 
     254 <li>Extra columns to describe object variability?  
     255 <li>Queries asking for best model will be messy (case when then else end).  
     256 <li>Bounding box: (ra/dec range big near poles) 
     257</ul> 
     258</span> 
     259}}} 
     260 
     261 
     262 
     263 
    244264== !FaintSource == 
    245265 
     
    251271 
    252272 
    253 !FaintDIASources will be saved for a fairly small subset of all objects, eg these that pass alerts.  
     273FaintDIASources will be saved for a fairly small subset of all objects, eg these that pass alerts.  
    254274 
    255275 
     
    320340If we decide to split it, we need to come up with appropriate naming convention. 
    321341 
    322  
     342{{{ 
     343#!html 
     344<span style="color:red"> 
     345Issues to be discussed: 
     346<ul> 
     347  <li>only low SNR or low and high SNR? 
     348  <li>Flux/background want INT not FLOAT. 
     349  <li>Ellipses only for MovingObjects. Ok? 
     350</ul>  
     351}}} 
    323352 
    324353== Source == 
     
    459488 * chi2 
    460489 
     490{{{ 
     491#!html 
     492<span style="color:red"> 
     493Issues to be discussed: 
     494<ul> 
     495  <li>schema for synthetic sources of data 
     496</ul> 
     497}}} 
     498 
     499 
     500 
    461501 
    462502== DIASource == 
    463  
    464503 
    465504=== Identifiers and foreign keys === 
     
    623662flagClassification BIGINT NULL, 
    624663}}} 
     664 
     665 
     666 
     667{{{ 
     668#!html 
     669<span style="color:red"> 
     670Issues to be discussed: 
     671<ul> 
     672  <li>pairing diasources from the same visit 
     673</ul> 
     674}}}