Problem solve Get help with specific problems with your technologies, process and projects.

How do I map tables with two/more fields as the primary key to an XDR schema?

My question is regarding mapping of database tables to XDR schemas.

A table is represented as an element in a XDR schema. XDR schema Datatype "ID" corresponds to a database table primary-key field. An element in a XDR schema is allowed to have only one attribute of datatype ID hence tables with one field as a primary key are easily mappable to a XDR schema.

But how do I map tables which have combinations of two/more fields as the primary key to a corresponding XDR schema ?

Could you please suggest a solution if possible? I am using the MSXML3.0 parser. Will using XSD schemas here help me?
W3C XML schema's composite fields functionality should suite your needs. See http://www-106.ibm.com/developerworks/xml/library/x-sbsch.html.
This was last published in October 2002

Dig Deeper on Development implications of microservices architecture



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.