Hello,
I am interested in understanding the pros and cons of storing billions of rows for real-time access in XML DB or in a traditional relational DB. The logical data model for this solution has two dozen or so relations, each not more than a dozen of so columns wide, however, some are very long. The primary interface for insertion and consumption of the structured data uses XML messages.via Java Services.
There will be a significant amount of business logic employed to determine if an insert to the data repository should occur. Heavy lifting involves frequent comparisons between new incoming message values with existing stored DB values.The result of the comparisons will determine if an insert need be made.
Since the incoming data is in the form of an XML message from a Java services layer, I am curious if the large amount of stored data should exist in an object oriented XML DB or if the stored data should exist in a more traditional relational format. The latter would require that the incoming XML messages be transformed into something compatible with the native relational format for input, as well as translation for data consumption by the service.
I'm interested in knowing the performance capabilities of XML DB structured storage when using somewhat large amounts of data: 1-100 billion rows, are involved in this solution as opposed to relational storage.
I am currently thinking that the best route to take would be to have the DB store its data in a traditional relational structure that utilizes a pl/sql interface to transform the service requests to and from XML. However, that is what I want feedback on: is that a correct assumption?
The question I pose is: If all the data, 5 TB or so, are stored in a structured object XML DB configuration, will that exhibit a performance that is less then that of one using an XML translation interface that accesses a traditional relational storage schema?
Note: Obviously I am unfamiliar with XML DB.
Solution Technical info: AIX OS; WebSphere application server (w/MQ); Oracle 11g. More details if needed.
Domain: Healthcare - Eligibility.
Thank you very much in advance.
