View Name | Contents | Description |
PhotoFamily | These are in PhotoObj, but neither PhotoPrimary or Photosecondary. | These objects are generated if they are neither primary nor secondary survey objects but a composite object that has been deblended or the part of an object that has been deblended wrongfully (like the spiral arms of a galaxy). These objects are kept to track how the deblender is working. It inherits all members of the PhotoObj class. |
PhotoObj | All primary and secondary objects in the PhotoObjAll table, which contains all the attributes of each photometric (image) object. | It selects PhotoObj with mode=1 or 2. |
PhotoPrimary | These objects are the primary survey objects. | Each physical object on the sky has only one primary object associated with it. Upon subsequent observations secondary objects are generated. Since the survey stripes overlap, there will be secondary objects for over 10% of all primary objects, and in the southern stripes there will be a multitude of secondary objects for each primary (i.e. reobservations). |
PhotoSecondary | Secondary objects are reobservations of the same primary object. | |
PhotoTag | The most popular columns from PhotoObjAll. | This view contains the most popular columns from the PhotoObjAll table, and is intended to enable faster queries if they only request these columns by making use of the cache. Performance is also enhanced by an index covering the columns in this view in the base table (PhotoObjAll). |
Index Type | Key or Field List |
primary key | objID |
foreign key | Field(fieldID) |
covering index | mode, cy, cx, cz, htmID, type, flags, ra, dec, u, g, r, i, z |
covering index | htmID, cx, cy, cz, type, mode, flags, ra, dec, u, g, r, i, z |
covering index | htmID, run, camcol, field, rerun, type, mode, flags, cx, cy, cz, g, r |
covering index | field, run, rerun, camcol, type, mode, flags, rowc, colc, ra, dec, u, g, r, i, z |
covering index | fieldID, objID, ra, dec, r, type, flags |
covering index | SpecObjID, cx, cy, cz, mode, type, flags, ra, dec, u, g, r, i, z |
covering index | cx, cy, cz, htmID, mode, type, flags, ra, dec, u, g, r, i, z |
covering index | run, mode, type, flags, u, g, r, i, z, Err_u, Err_g, Err_r, Err_i, Err_z |
covering index | run, camcol, rerun, type, mode, flags, ra, dec, fieldID, field, u, g, r, i, z |
covering index | run, camcol, field, mode, parentID, q_r, q_g, u_r, u_g, fiberMag_u, fiberMag_g, fiberMag_r, fiberMag_i, fiberMag_z |
covering index | run, camcol, type, mode, cx, cy, cz |
covering index | ra, [dec], type, mode, flags, u, g, r, i, z, psfMag_u, psfMag_g, psfMag_r, psfMag_i, psfMag_z |
covering index | phototag |
covering index | parentid, mode, type |
Index Type | Key or Field List |
primary key | fieldID |
covering index | field, camcol, run, rerun |
covering index | run, camcol, field, rerun |
Index Type | Key or Field List |
primary key | objID, bin, band |
foreign key | PhotoObjAll(objID) |
Index Type | Key or Field List |
primary key | fieldID, bin, band |
foreign key | Field(fieldID) |
Index Type | Key or Field List |
primary key | objID, NeighborObjID |
foreign key | PhotoObjAll(objID) |
Index Type | Key or Field List |
primary key | plateID |
covering index | htmID, ra, dec, cx, cy, cz |
View Name | Contents | Description |
SpecObj | A view of Spectro objects that just has the clean spectra. | The view excludes QA and Sky and duplicates. Use this as the main way to access the spectro objects. |
Index Type | Key or Field List |
primary key | specObjID |
foreign key | PlateX(plateID) |
covering index | htmID, ra, dec, cx, cy, cz, sciencePrimary |
covering index | BestObjID, sourceType, sciencePrimary, class, htmID, ra, dec |
covering index | class, zWarning, z, sciencePrimary, plateId, bestObjID, targetObjId, htmID, ra, dec |
covering index | targetObjID, sourceType, sciencePrimary, class, htmID, ra, dec |
covering index | ra, [dec], class, plate, tile, z, zErr, sciencePrimary, plateID, bestObjID |
View Name | Contents | Description |
SpecPhoto | A view of joined Spectro and Photo objects that have the clean spectra. | The view includes only those pairs where the SpecObj is a sciencePrimary, and the BEST PhotoObj is a PRIMARY (mode=1). |
Index Type | Key or Field List |
primary key | specObjID |
foreign key | SpecObjAll(specObjID) |
covering index | objID, sciencePrimary, class, z, targetObjid |
covering index | targetObjID, sciencePrimary, class, z, objid |
View Name | Contents | Description |
sdssTile | A view of sdssTileAll that have untiled=0 | The view excludes those sdssTiles that have been untiled. |
Index Type | Key or Field List |
primary key | tile |
foreign key | sdssTilingRun(tileRun) |
covering unique index | tileRun, tile |
covering index | htmID, racen, deccen, cx, cy, cz |
Index Type | Key or Field List |
primary key | targetID |
covering index | htmID, ra, dec, cx, cy, cz |
View Name | Contents | Description |
sdssTilingBoundary | A view of sdssTilingGeometry objects that have isMask = 0 | The view excludes those sdssTilingGeometry objects that have isMask = 1. See also sdssTilingMask. |
sdssTilingMask | A view of sdssTilingGeometry objects that have isMask = 1 | The view excludes those sdssTilingGeometry objects that have isMask = 0. See also sdssTilingBoundary. |
Index Type | Key or Field List |
primary key | tilingGeometryID |
foreign key | sdssTilingRun(tileRun) |
foreign key | StripeDefs(stripe) |
Index Type | Key or Field List |
primary key | specObjID |
Index Type | Key or Field List |
primary key | specObjID |
Index Type | Key or Field List |
primary key | specObjID |
Index Type | Key or Field List |
primary key | specObjID |
Index Type | Key or Field List |
primary key | specObjID |
We have build a spatial indexing scheme called the Hierarchical Triangular Mesh (HTM) that spatially decomposes the region of the sky that is covered by the SDSS data and enables much faster spatial searches of the data by coordinate cuts.
In addition to the HTM, which is an overall indexing scheme for multidimensional spatial data, the DBMS itself has the capability to define indices for fast searches on each table. We have defined indices on all the major tables.
An index is a tree representation of a subset of the columns in a table that enables much faster searches of the table (compared to sequential scans of the table data) when constraints involving those columns are included in the query. All tables have an index on their primary key (unique row identifier), but the larger tables have indexes in addition to the primary key index. In all there are 3 kinds of indices: