how to measure performance of tow diff xml databases
Date:
2005-01-03 08:43:46
From:
amolee
am gona compare between differnt databases in storing and querying XML documents, and really need some help .
what i need is 2 know how to measure the performance for all those databases?? do i have built an application that is well suited for native XML database and used it to benchmark the two types of databases?? and does any body have bulit that application be4 so i can use directly and save more time...
With respect to relational databases, you may be interested in reading article "Which Storage XML?"
by Sean Dillon, Oracle Magazine, March/April 2005.
Article discusses performance implications while using BLOB vs. XMLType as storage data type.
If you'd like to compare various SQL databases, you may consider having same comparison baseline: same database object(s) definition, same XML schema(s), same set of input XML files (and different schema-database tables mapping xmls - if any). The client code would rely on database packages/APIs. [Note: with x-Persistent Utility
your client code will remain unchanged]. As for native XML database as a benchmark one - it could be, probably, a separate task to identify the database that would suite your performance criteria(s).
Well, Im a student doing a project to compare between (Oracle-Tamino) databases in storing and querying XML documents, I already generated the xml documents and loaded them to the databases ( I used XMark benchmark) BUT now am facing problem with measuring query response time .
what i need is 2 know how u measure the performance for those databases?? Is there a tool I can use to measure the performance?? or can I use se timing on function from Oracle and _duration=on function in Tamino???
Can I relay on those functions to measure the query time response ???