RelationalRegistryDM < IVOA

IVOA Web>IvoaResReg>RegistryInterface>RestfulRegistryInterfaceReq>RelationalRegistryDM (2012-08-30, MarkusDemleitner) (raw view)

EditAttach

<small>Jumps: IvoaResReg :: [[http://www.ivoa.net/forum/registry/][registry mail archive]] :: RegistryMetadata :: VOResourceV10 <br /> Meetings: InterOpMay2011Registry </small>

---+ Relational Registry DM

(Note there's now a page for [[RI2Discussion]]).

This page describes efforts towards creating a "relational" Registry DM that will express the same data model that is implicit within the resource XML schema, in order that the new DM definition could be used with a next generation Registry interface which might be more TAP-like.

One of the most desirable features of a relational DM is that it contain a few tables as possible to make querying it easier. I have tried to model the VOResource, VODataService and SIA schema (only) to achieve this aim and the result is shown below.

<img alt="regDM.png" src="/internal/IVOA/RelationalRegistryDM/regDM.png" />

As can be seen this still involves the creation of 22 tables if the current element multiplicities that are in the XML schema are to be fully supported, as well as full round-trip to XML, and note that this number will increase when other schema are included.

The methodology for mapping the XML to relational schema involved the following transformations.

   1 Type hierarchies are all collapsed into a single table with a KIND column to distinguish the types. This also means that sub-type properties must be allowed to be nullable.
   1 An XML type is embedded directly within its parent whenever it has a cardinality of 1:1 (e.g. Content, Curation and then within those PUBLISHER_IVOID)
   1 Lists of enumerations e.g. !ContentLevel have been transformed to a single field with a delimited list of enumeration values
   1 For elements where the cardinality is one to many a separate table has been created with a foreign key reference on the many side.

A Java library of objects that represent the Registry metadata models along with standard XML schema mapping (via JAXB) and the above relational mapping (via JPA) is available at http://software.astrogrid.org/doc/ivoa-objects/

<br /> -- IVOA.PaulHarrison - 13 Jun 2011 <!--
      * Set ALLOWTOPICRENAME = IVOA.TWikiAdminGroup
-->

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
png	regDM.png	r3 r2 r1	manage	314.2 K	2012-05-12 - 08:48	PaulHarrison	VOResource Relational model

Topic revision: r6 - 2012-08-30 - MarkusDemleitner

IVOA

Log in or Register

IVOA.net
Wiki Home
WebChanges
WebTopicList
WebStatistics

Twiki Meta & Help
IVOA
Know
Main
Sandbox
TWiki

TWiki intro
TWiki tutorial
User registration
Notify me

Working Groups

Interest Groups

Time Domain

Committees

Stds&Procs

www.ivoa.net
Documents
Events
Members
XML Schema