[
Lists Home |
Date Index |
Thread Index
]
Quoting Ronald Bourret <rpbourret@rpbourret.com>:
> 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.
|
