Access vs XML

Ray Turner
Ray Turner used Ask the Experts™
on
I'm developing a web application using Microsoft ASP.NET.  Should I use Access or XML for the data store?  What are the Pros and Cons of each of these?

I'm currently using XML; which appears to work quite well.  Is this the best choice?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Team Lead
Commented:
As a developer for more than 15 yrs, I seldom heard people storing their data in XML format, unless the data that being stored is in small quantity. Personally, I would prefer a standard DBMS to manage the data instead of using XML. So I would choose Access (or a higher end DBMS).

some considerations:

1. concurrence of access & updating

can XML handle scenario of 2 concurrent write requests, which can prevent a write access deadlock, etc?

2. security

how important the data itself? how easy the data can be accessed/compromised? do we have user access matrix/ privileges settings for the data source?

3. maintenance

as data are defined and stored in different ways, how easy we can maintain our data?

but for a matured DBMS will provide tools to monitor and streamline the processes/activities which relevant to the data itself. It makes developer's life easier. On contrary, I'm not too sure for XML related tools.

Anyway, I found a good article to read which seems useful:
http://www.rpbourret.com/xml/XMLAndDatabases.htm
Ray TurnerSenior Consultant

Author

Commented:
Thanks for your comments.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial