Defining and transforming entity relationship-XML hybrid data models

Patent metadata

Field	Value
Publication number	US-9613067-B2
Application number	US-201414164078-A
Country	US
Kind code	B2
Filing date	Jan 24, 2014
Priority date	Jan 24, 2014
Publication date	Apr 4, 2017
Grant date	Apr 4, 2017

Abstract

An entity-relationship (ER)-eXtensible Markup Language (XML) hybrid data model includes an unmarked entity and an entity marked to be transformed as an XML column. In transforming the ER-XML hybrid data model to a physical data model, the unmarked entity is transformed to a table in the physical data model. It is determined whether the marked entity has an unmarked parent entity. If so, the marked entity, and the transitive closure of the marked entity, is transformed to an XML column in a table representing the unmarked parent entity in the physical data model, an XML schema document (XSD) for the XML column is generated, and the XSD is associated with the XML column. A relational-XML hybrid data model includes one or more XML columns marked to transform to a set of entities in the ER model by expanding the contents of the XSD associated with the XML column.

First claim

What is claimed is:

1. A method comprising:
providing an entity-relationship (ER)-extensible markup language (XML) hybrid data model of a relational database comprising XML data;
receiving a user setting of a first annotation of a first entity in the ER-XML hybrid data model marking the first entity as not to be transformed as XML data;
receiving a user setting of a second annotation of a second entity in the ER-XML hybrid data model marking the second entity as to be transformed as XML data; and
transforming, by a computing processor, the ER-XML hybrid data model to a physical data model of the relational database, comprising:
based on the first annotation of the first entity marking the first entity as not to be transformed as XML data, transforming the first entity in the ER-XML hybrid data model to a first table in the physical data model;
based on the second annotation of the second entity marking the second entity as to be transformed as XML data, determining whether the second entity has a parent entity in the ER-ML hybrid data model with a third annotation marking the parent entity as not to be transformed as XML data; and
in response to determining that the second entity has the parent entity with the third annotation marking the parent entity as not to be transformed as XML data:
transforming the second entity and a transitive closure of the second entity to an XML column in a second table in the physical data model, the second table representing the parent entity in the ER-XML hybrid data model marked as not to be transformed as XML data;
generating an XML schema document (XSD) for the XML column; and
associating the XSD with the XML column in the physical data model.

2. The method of claim 1 , wherein the generating of the XSD for the XML column comprises:
including information on the second entity in the XSD;
including information on any subtype entity of the second entity in the XSD;
including information on any supertype entity of the second entity in the XSD; and
including information on any child entity of a relationship referencing the second entity as parent in the XSD.

3. The method of claim 2 , wherein the including of the information on any subtype of the second entity in the XSD further comprises: recursively including information on any subtype entity of the subtype entity in the XSD.

4. The method of claim 2 , wherein the including of the information on any supertype of the second entity in the XSD further comprises: recursively including information on any supertype entity of the supertype entity in the XSD.

5. The method of claim 2 , wherein the including of the information on any child entity of a relationship referencing the second entity as parent in the XSD comprises: recursively including information on any child entity of a relationship referencing the second entity as parent in the XSD.

6. The method of claim 2 , wherein the including of the information on any supertype or subtype entity of the second entity comprises: recursively including information on any child entity of a relationship referencing the supertype or subtype entity as parent in the XSD.

7. The method of claim 2 , wherein the including of the information on any child entity of a relationship referencing the second entity as parent in the XSD comprises: including information on any supertype entity of the child entity in the XSD.

8. The method of claim 1 , further comprising:
providing the physical data model comprising a fourth annotation of a first XML column marking the first XML column as not to be transformed as an entity and a fifth annotation of a second XML column marking the second XML column as to be transformed as an entity; and
transforming the physical data model to a second ER-XML hybrid data model, comprising:
based on the fifth annotation of the second XML column marking the second XML column as to be transformed as an entity, transforming the second XML column to a first entity in the second ER-XML hybrid data model;
creating at least a second entity in the second ER-XML hybrid data model for contents of an XSD associated with the second XML column; and
based on the fourth annotation of the first XML column marking the first XML column as not to be transformed as an entity, transforming the first XML column as a XML attribute in a parent entity and associated with the same XSD as the second XML column.

9. A computer program product comprising:
a computer readable storage medium having computer readable program code embodied therewith, the program code executable by a processor to:
provide an entity-relationship (ER)-extensible markup language (XML) hybrid data model of a relational database comprising XML data;
receive a user setting of a first annotation of a first entity in the ER-XML hybrid data model marking the first entity as not to be transformed as XML data;
receive a user setting of a second annotation of a second entity in the ER-XML hybrid data model marking the second entity as to be transformed as XML data;
transform the ER-XML hybrid data model to a physical data model of the relational database, comprising:
based on the first annotation of the first entity marking the first entity as not to be transformed as XML data, transform the first entity marked to a first table in the physical data model;
based on the second annotation of the second entity marking the second entity as to be transformed as XML data, determine whether the second entity has a parent entity in the ER-XML hybrid data model with a third annotation marking the parent entity as not to be transformed as XML data; and
in response to determining that second entity has the parent entity with the third annotation marking the parent entity as not to be transformed as XML data:
transform the second entity and a transitive closure of the second entity to an XML column in a second table in the physical data model, the second table representing the parent entity in the ER-XML data model marked as not to be transformed as XML data;
generate an XML schema document (XSD) for the XML column; and
associate the XSD with the XML column in the physical data model.

10. The computer program product of claim 9 , wherein the program code executable by the processor to generate the XSD for the XML column comprises:
include information on the second entity in the XSD;
include information on any subtype entity of the second entity in the XSD;
include information on any supertype entity of the second entity in the XSD; and
include information on any child entity of a relationship referencing the second entity as parent in the XSD.

11. The computer program product of claim 10 , wherein the program code executable by the processor to include the information on any subtype of the second entity in the XSD further comprises: recursively include information on any subtype entity of the subtype entity in the XSD.

12. The computer program product of claim 10 , wherein the program code executable by the processor to include the information on any supertype of the second entity in the XSD further comprises: recursively include information on any supertype entity of the supertype entity in the XSD.

13. The computer program product of claim 10 , wherein the program code executable by the processor to include the information on any child entity of a relationship referencing the second entity as parent in the XSD comprises: recursively include information on any child entity of a relationship referencing the second entity as parent in the XSD.

14. The computer program product of claim 10 , wherein the program code executable by the pr

Assignees

• IBM

Inventors

• Chang Daniel T
• Kolwalkar Hemant S

Classifications

• G06F16/211 Primary

  Schema design and management · CPC title

• G06F16/288

  Entity relationship models · CPC title

• G06F17/30604

  Physics · mapped topic

• G06F17/30292 Primary

  Physics · mapped topic