[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: An example of database query result in XML

• From: len bullard <cbullard@h...>
• To: Jim Amsden <jamsden@u...>
• Date: Tue, 24 Mar 1998 22:43:20 -0600

Jim Amsden wrote:
>  
> So the result might be something like:
> 
> <!ELEMENT Order EMPTY>
> <!ATTLIST Order
>    OrderID ID #REQUIRED
>    CustomerID IDREF #REQUIRED
>    EmployeeID IDREF #REQUIRED
>    OrderDate CDATA #REQUIRED
>    PurchaseOrderNumber CDATA #REQUIRED
>    ContactFirstName CDATA #IMPLIED
>    ContactLastName CDATA #REQUIRED
>    ShipName CDATA #REQUIRED
>    ShipAddress CDATA #REQUIRED
>    ShipCity CDATA #REQUIRED
>    ShipStateOrProvince CDATA #REQUIRED
>    ShipPostalCode CDATA #REQUIRED
>    ShipCountry CDATA #REQUIRED
>    ShipPhoneNumber CDATA #REQUIRED
>    ShipDate CDATA #REQUIRED
>    ShippingMethodID CDATA #REQUIRED
>    FreightCharge CDATA "2.0000"
>    SalesTaxRate CDATA "0.0
> >
> 
> <Order>
>    OrderID="1"
>    CustomerID="1"
>    EmployeeID="5"
>    OrderDate="1995-02-02 00:00:00"
>  PurchaseOrderNumber="52">
>  ContactFirstName="Jaime"
>  ContactLastName="Yorres"
>  ShipName="Let's Stop N Shop"
>  ShipAddress="87 Polk St.
> Siite 5"
>  ShipCity="San Francisco"
>  ShipStateOrProvince="CA"
>  ShipPostalCode"94117"
>  ShipCountry="USA"
>  ShipPhoneNumber="(415) 555-5938"
>  ShipDate="1995-02-03 00:00:00"
>  ShippingMethodID="1"
>  FreightCharge="2.0000"
>  SalesTaxRate="0.0"
> </Order>

There is a long history of debate on the issue of usings 
attibutes vs elements for describing data in SGML.  
The DTD models frequency and occurrence.  In a 
representation where there are not duplicates 
there is no benefit to modeling frequency and occurrence.
In that case, the better representation is the 
simpler one if the query is simplified by this.

Len Bullard

xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@i...
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo@i... the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo@i... the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa@i...)

• References:
  • Re: An example of database query result in XML
    • From: Jim Amsden <jamsden@u...>

• Prev by Date: Re: An example of database query result in XML
• Next by Date: Re: Relational Tables and structured document
• Previous by thread: Re: An example of database query result in XML
• Next by thread: Re: An example of database query result in XML
• Index(es):
  • Date
  • Thread