Gruppe14/KIT-PSE-Docs

SkyServer Database schema

Closed this issue · 3 comments

We have to find out how they structure their tables and if we can parse information out from that.
Otherwise we just may search for file endings in the where part?

Also if they have a hierarchy. This would change the measure Typ to a Dimension!

http://skyserver.sdss3.org/dr8/en/skyserver/paper/default.asp there is a schema for the data release 1. i don't know how much changed since we are currently at data release 8, but they have written that it did not change much

Well, the website didn't change.

Invalid link! Is it the page schema on the web page?
If so... tables views functions procedures constants contain a lot of things...
but partly it doesn't make sense and the descriptions are worth nothing! (for me...)

http://www.sdss.org/DR7/ just talks about 2 images and spectroscopy (images has subsections)

http://das.sdss.org/www/html/ talks about 8 directions

http://skyserver.sdss.org/public/en/sdss/data/images/dbdiagram.gif shows db version 1....
mostly what we are searching, isn't it?

uuuuuund hier noch schön aufteilt: http://cas.sdss.org/dr6/en/skyserver/images/db-diagram-full.gif
danach könnte man es vll echt aufteilen
obere dimension: picture spectro meta und dann eben tiefere ebenen
haha damit könnten wir arbeiten oder?