proposed VODataService changes

Doug Tody dtody at nrao.edu
Tue May 20 06:46:17 PDT 2008


On Tue, 20 May 2008, Ray Plante wrote:
> There is at least one place I would recommend some flattening: I'm
> wondering if we really need to capture the database schema as a new
> element layer (<schema>) between a <catalog> and <table>.  Can we instead
> do something like this?
>
>     <catalog>
>       <name>The X survey catalog</name>
>       <description>...</description>
>       <table>
>          <schema>...</schema>
>          <name>...</name>
>          <description>...</description>
>          <column>...</column>
>          <column>...</column>
>          ...
>       </table>
>       <function>                      <!-- optional -->
>          <schema>...</schema>
>          <name>...</name>
>          ...
>       </function>
>       <join>                          <!-- optional -->
>          ...
>       </join>
>     </catalog>
>
> In this case, if the <schema> element is omitted, the default schema is
> assumed.

The above suggestion is also the way this is addressed in the SQL
information schema.  Another option, which we were considering before
there was mention of explicitly adding a separate "schema" element,
is to include this information in the table name as in "<schema>.<table>".

	- Doug



More information about the registry mailing list