OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

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

[ Lists Home | Date Index | Thread Index ]

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.




 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS