An example of database query result in XML

[len bullard]

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 at ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo at ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo at ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa at ic.ac.uk)