XML with databases
Hello I have a friend that is working in a project where all the data is stored in a XML repository.
He has to make a query and some updates, but at the moment is very slow, so he has three options.
1) To improve the XML system
2) To use ORACLE 8i
3) To improve the XML system and also use Oracle 8i (relational database)
Which one do you think is the best solution? What advantages and disadvantages there are when combining the XML data and the databases?
He asked me this and didn´t have an aswer so I came to you:)
Thanks as always
Nicolas Escobar J.
http://www.developy.com
Free resources for webmasters in spanish
Peter J. Boettcher posted this at 13:45 — 7th December 2000.
They have: 812 posts
Joined: Feb 2000
Nico,
XML is a great "staging" area for data but it is not meant to replace an Enterprise Database system like Oracle or SQL Server 2000, while the XML parser is fast and efficient it could never compete with a full fledged database server when dealing with large recordsets.
If he moved to Oracle 8i or SQL 2000 he could still keep his XML structure since these database systems support reading and writing of XML documents.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.