Re: C# pure xml database?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Mark,

While I understand your point (since I need easily accessible storage), I dont need a database solution, I need an XML solution.

My intention is to investigate how I could use and XML database as a tool to work on large amounts of XML more efficently.

Let me give you an example to illustrate my point:

Lets say a customer changes an address and I need to check if the new address is within a servicable area.

There is a 250k xml file associated with the customer (or a large array of database columns), but all I want is to check an address node with a business rule inside BizTalk's Business Rules engine. Rather than store all the data for the customer relationally and have to return it (or part of it) as XML, might it be more efficent to just pull that node from the XML store, validate it, update it and slap it back in?

Those are the kinds of questions I am trying to answer.

Dont get me wrong, I'm not trying to sound like an advocate here, I am interested in experiementing, thats all.

BA
http://biztalkia.blogspot.com/


I've never thought of XML as anything other than a very flexible data
transport - it's certainly not a database, nor was it ever intended to
be one.

If you were writing a letter, you wouldn't use Excel because that
simply wouldn't be the right product. You could, of course, write a
letter in Excel if you really wanted to... Same goes for using XML as
a database.

If you need a database solution, then use a database.



.

Relevant Pages

  • Re: DISCOVER_XML_METADATA
    ... expansion of ASSL XML returned by the server. ... You could do ExpandObject for the server in step 1. ... you could request ExpandObject for that database -- this is step ... all cubes and nothing else. ...
    (microsoft.public.sqlserver.olap)
  • Re: Preservation of namespace prefixes in XML datatype
    ... representation well beyond merely preserving the logical meaning. ... > Now the ANSI/ISO SQL-2003 standard makes it pretty clear that the XML ... all the guarantee the database gives you is that we preserve the ... >> makes changes in namespace prefixes, will I the user/developer have the ...
    (microsoft.public.sqlserver.xml)
  • Re: Wanted:MAIL.MAI structure definition
    ... a relational database is more flexible in the retrival of data. ... Perhaps this impact has been softened as hardware has gotten faster, but, overhead is overhead, and if you weren't using the advances in hardware for overhead, those designs that have less overhead would also gain from the faster hardware. ... RFC822 header because your XML parser wouldn't be able to understand new ...
    (comp.os.vms)
  • Re: Rework [Was: Static vs. Dynamic typing...]
    ... Agile projects have an extraordinarily low chance of a big change. ... Suppose you start with XML files, and by Iteration 6 the ... Switching to a database is now cheaper than morphing XML files into a ...
    (comp.programming)
  • Re: Data source options
    ... > customer to access the app and own the data. ... and by keeping the "main database" closer to the "web application ... I've been watching the "maturation" of the XML space. ... Visage ISN'T free - but it is cheap as chips ...
    (comp.databases.pick)