Re^2: updating big XML files

Thanks for the comments! I know eXist I worked with it same years ago (in a Java context). I have done mapping of XML to relational and back myself and it can be tricky! FYI: I have a good document on the topic.

I think the best way forward is a RDBMS. It was probably a mistake in the first place to do it in XML. Especially since the files get relatively big and updates are necessary. Transactions are not an issue the application is stand alone.

Comment on Re^2: updating big XML files

Replies are listed 'Best First'.
Re^3: updating big XML files by pajout (Curate) on Jul 21, 2008 at 22:47 UTC
Another point of view: If the data structure is well defined and it will not change (or it will change when new release occurs), sql database can fit the data structure very well. But, if the character of the data structure is, for instance, "we know that the tree have following base structure, and some nodes could be enhanced by some data from time to time, some layer keeping generic xml structure could be better than never-ending story of changing definitions of sql tables. In this case, you can choose eXist or implement xml layer in RDBMS.	[reply]

Replies are listed 'Best First'.

Re^3: updating big XML files
by pajout (Curate) on Jul 21, 2008 at 22:47 UTC

If the data structure is well defined and it will not change (or it will change when new release occurs), sql database can fit the data structure very well.

But, if the character of the data structure is, for instance, "we know that the tree have following base structure, and some nodes could be enhanced by some data from time to time, some layer keeping generic xml structure could be better than never-ending story of changing definitions of sql tables. In this case, you can choose eXist or implement xml layer in RDBMS.

[reply]