I am designing a website which is pretty much static. Readers of the website cant update anything on it. There will only be daily updates on the website from server side. Since my website is more about displaying content which has a preset format, i was thinking of using XML as database. But i dont know where to start from? Should i store data as .xml flat files? what abt ACID requirements then? I did have a look at some XML DBs such as baseX and eXist. But dont know whether to use them?
Also, since my website is content based, i need to create a small search engine for it. This is another reason why i was thinking of creating DB in XML files.
Please guide abt a suitable DB for my website reuirements....primarily search engine functionality and ease of updating content.
Are you delivering the content as XML? Are you going to transform it using something like XSLT? If the answer to these questions is no, then I think it's a bad idea. Just store the data in a database. Otherwise, you're going to add the overhead and reading the XML, parsing it, and post-processing the data every time it is accessed. Databases are already optimized for I/O, much better than you could probably do on your own.