RE: [xml-dev] Re: What Does SOAP/WS Do that A REST System Can't?

["Dare Obasanjo" <dareo@microsoft.com>]

Is there some legal requirement to keep a full fidelity copy of the document? If not, I can't see why you don't just generate the XML as needed from the database when export is needed. Most major database products have had SQL<->XML mapping functionality for years. 
 
-- 
PITHY WORDS OF WISDOM
Experience is something you don't get until just after you need it. 

________________________________

From: David Lyon [mailto:david.lyon@computergrid.net]
Sent: Mon 4/4/2005 2:56 PM
To: xml-dev@lists.xml.org
Subject: Re: [xml-dev] Re: What Does SOAP/WS Do that A REST System Can't?



On Mon, 4 Apr 2005 12:46 am, Ronald Bourret wrote:
> Can you query the XML documents?

From an accounting perspective you can, as the important fields from within
the document are broken out to the sql database to enable such queries. ie:

 aged debtor analysis :  select name, a_c, a_30, a_60, a_90 from trader
                                  where trading_relationship = "Customer"

 list of invoices :           select document_type,document_reference,
                                  document_date,document_amount  from
                                  trader_documents where document_type =
                                  "Invoice"

etc... etc....

It makes it very simple to do the normal sort of accounting queries.

Also makes it possible to use traditional rdms report writers to build
reports.

> If not -- for example, if they're
> stored as BLOBs -- it seems this would make sense only if the only thing
> you wanted to do with your accounting data is to ship it somewhere else.

A copy of the entire document is stored in a text-memo field.

It is designed so that the xml document can be shipped off as created
to the Customer (xml Invoices) or Supplier (xml Purchase Orders).

> Doesn't strike me as very likely...

Sending xml purchase orders and invoices is becoming much more
common.... it certainly does happen in the real world in increasing
amounts...

Best Regards

David


--
Computergrid : The ones with the most connections win.

-----------------------------------------------------------------
The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
initiative of OASIS <http://www.oasis-open.org>

The list archives are at http://lists.xml.org/archives/xml-dev/

To subscribe or unsubscribe from this list use the subscription
manager: <http://www.oasis-open.org/mlmanage/index.php>