The SQL schema has some differences from our Objectivity schema. Arrays cannot be represented in SQL Server, so we broke out the shorter, one-dimensional arrays f as scalar fields f_1,f_2, The poor indexing in Objectivity/DB forced us to separate star and galaxy objects (for the 2x speedup), while in SQL we were able to merge the two classes and their associations. Object Associations were converted into Foreign Keys. Other than this, the schema conversion and data extraction and loading was remarkably easy.
The tables can be separated into several broad categories.
The first set of tables relate to the photometric observations.
Another set of tables is related to the hierarchy of observations and the data processing steps.
Another set of tables is related to the spectroscopic observations. They capture the process of target selection and eventual observation.
Finally, there is a table to capture
cross-reference information about SDSS objects also detected in other
catalogs, if a unique identification can be made. This cross-reference
table can evolve as the need arises.