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

Re: XML faster than mySQL database ?

mysql xml support
3/6/2002 12:17:27 PM, "Marksman" <chris_ziel@y...> wrote:

>What is faster ?
>a XML bases database or a mySQL database ?
>i want to use it for the web. I think mySQL is
>faster, because its written excpecially for such
>this jobs. Its this true, or is XML faster (serverside parsing) ?

I'm not quite sure what you are asking.  There is a common
misconception that an XML document can substitute for a database.
That's true only in the very narrow sense that XML can 
easily represent some common business "data" formats such
as invoices, orders, and catalogs that would require 
multiple database tables, and a DBMS that at least supported
the relational join operation, to handle.  The limitations
of doing this in the filesystem are obvious -- limited
queries, no transactions, no backup/restore or other administration.
A mySQL-based application would almost certainly be faster and
"better" once any substantial amound of data was put in the system.

On the other hand, there is a class of products called "native XML
databases" (NXDB) that DO support (as a general rule) the features of
any database system, but use XML documents and interfaces rather
than tables and SQL.  Whether an NXDB or an RDBMS is more suitable
to a particular application is highly dependent on the details of
the application.  As a general rule, the more "data-like" the data,
i.e. easily "shredded" to a manageable number of tables, the more
appropriate the RDBMS will be; the more "document-like" the data
(with deep recursion, mixed content, and irregularity in general),
the better an NXDB solution will be.  Also, if your data is shared
by other RDBMS applications, the RDBMS solution is generally preferred;
if your data is used by other XML applications, an NXDB is preferred.

At the high end, the distinction is blurred because all the major
RDBMS vendors are promising "native" XML support Real Soon Now, but
as far as I know, mySQL has nothing to ease the burden of working
with XML on top of its tables and interfaces.


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.
First Name
Last Name
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.