[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?


black soap
Quoting Ronald Bourret <rpbourret@r...>:

> David Lyon wrote:
>
> > 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:
>
> Makes sense. But that also means you're storing the data twice...

True....

> which makes updates a bit of a pain.

That part is black boxed. It's automatic and there's no pain.

> Do you send the XML documents so often
> that the performance gain of having them cached is worth the update
> pain?

It's only about 20 bytes top to put on the wire...

and some fields change more than others, some not at all.

Document reference details don't change that much - ie invoice number

Invoice amounts probably do, so it's possible to update those.

The protocol goes a bit like this:

 "update Invoice#=204565 Amount$=67.23"

Yes, it should be a soap packet I know, or a WS. But that makes
it much more complicated. We just put it on one transmission line.

> Or do you only store data as XML that is never updated?

No they are dynamic documents that change over time.

> Also, did you consider using a native XML database as a way to store the
> data?

Those are the new-high tech fangly things... they weren't around back then and
to this day I sadly profess that I don't have any idea how they work.

Hey, don't forget, I'm obsolete and have been offshored also.. :-)

> That would allow you to store it as XML and query it without
> having to break out fields for storage in relational columns.

Maybe...

but I like sql databases like mysql, oracle, db2, sql-server etc..  while I
might be a critical of isam inspired accounting system designs.. to me, sql is
a perfect solution to making that ugly old world of isam go away, or at least
be hidden from view.

Doing inventory purely in xml is not nice. I can't see any easy way to make that
happen.

No matter how many good ideas there are, it's still a swamp... and it's always
going to be a swamp... I can't see any way past that no matter how many nice
walkways somebody wants to install...



David


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.