Abstract
Databases should be able to manage a huge amount of data, and for this, managing structural information should be supported. Many XML-enabled and XML-native databases are available which help in information storage and management in the form of XML based documents. One such example is the Oracle Berkley XML database [1] (containing an embedded XQuery [2] engine), which provides a database library and an API interface to this database library, using which XML and XQuery-based applications can be developed.
This Master Project makes use of the above mentioned API interface (APIs and commands) from the database library to develop an application, which can help students to learn and understand the various features of the XQuery, hiding the complexities of learning and using the complex XQuery commands directly. And also hiding the details specific to the Oracle Berkley XML database, exposing mainly only those features of XQuery engine that are standard and recognized by the World Wide Web Consortium [3]. This application builds a user-friendly interface, using the Visual C++ environment, to the database library to be able to execute XQuery commands and be able to create containers, documents, insert and delete data into the documents and also to be able to query and update data and information in the documents and the containers. The application provides case studies for building and querying the XML database. The provided case studies help can students to understand operations over XML, such as creating a document, inserting data into a document, deleting a document and deleting data from a document, updating a document, as well as querying the documents for information retrieval.