Ask the Expert

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.

    Requires Free Membership to View


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 first published in October 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: