The use of XML schema based object types

• Main Author: Oblak, Roman
• Format: Thesis
• Language: unknown
• Published: 2011
• Subjects: Computer and Information Science; DML
• Online Access: http://eprints.fri.uni-lj.si/1363/; http://eprints.fri.uni-lj.si/1363/1/Oblak1.pdf

XML data is not new and we meet with it in every corner in the world of information technology. Advanced approaches and methods for importing, reading and processing XML documents are a novelty. Oracle database offers different approaches of storing XML data. It offers unstructured, structured, binary and hybrid storage. Many different approaches are shown in this thesis, but the emphasis is on hybrid storage option, which we upgraded with using object types, that were created upon registering the XML schema on the database. We performed two comparisons between mentioned different approaches. The first was based on executing DML statements, like SELECT, INSERT, DELETE and UPDATE statements. The comparison confirmed the claims that are true for each different method of storage, while it also confirmed the rapid and efficient execution of DML statements in the case of hybrid storage. The second comparison was the performance comparison of the conversion of XML documents to different data types used in each method of storage. Despite the fact that larger XML files should be dealt with in other ways, it has been shown that when a certain large XML file is used, using object types is not appropriate. This thesis presents possible ways of storing and processing XML data, however, which one is suitable for you, mostly depends on the technology you use or the business process, which you have to implement.