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

Re: Re: What Does SOAP/WS Do that A REST System Can't?

• To: xml-dev@l...
• Subject: Re: Re: What Does SOAP/WS Do that A REST System Can't?
• From: David Lyon <david.lyon@c...>
• Date: Mon, 4 Apr 2005 17:56:58 -0400
• In-reply-to: <4250C692.9070001@r...>
• References: <15725CF6AFE2F34DB8A5B4770B7334EE07206D59@h...> <200504031010.47678.david.lyon@c...> <4250C692.9070001@r...>
• User-agent: KMail/1.7.1

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.

• Follow-Ups:
  • Re: Re: What Does SOAP/WS Do that A REST System Can't?
    • From: Ronald Bourret <rpbourret@r...>

• References:
  • Re: Re: What Does SOAP/WS Do that A REST System Can't?
    • From: David Lyon <david.lyon@c...>
  • Re: Re: What Does SOAP/WS Do that A REST System Can't?
    • From: Ronald Bourret <rpbourret@r...>

• Prev by Date: Re: Problem parsing XML file with Xerces-J
• Next by Date: Re: Problem parsing XML file with Xerces-J
• Previous by thread: Re: Re: What Does SOAP/WS Do that A REST System Can't?
• Next by thread: Re: Re: What Does SOAP/WS Do that A REST System Can't?
• Index(es):
  • Date
  • Thread