A METHOD AND SYSTEM FOR IMPLEMENTING XML AND XQUERY TO PERFORM READ AND WRITRE OPERATIONS IN MINUMUM NUMBER OF CALLS

The present disclosure relates to a method and system for implementing XML and XQuery to perform read and write operations in minimum number of calls. The method comprises: generating the class which includes the student's property and creating a collection; translating the created collection into the XML format; and passing the organized XML to the stored procedure. In this disclosure the implementation of XML and XQuery is discussed when working with the huge data of an academic institution. The implementation of XML and XQuery reduces the number of database call for which are needed for performing reading and writing operations. The proof of concept is developed using the .NET framework for making the serialization of the object to and from the XML file easy. The analysis for the basic operations for the Xquery and traditional SQL method shows that the XQuery is way faster than the traditional SQL method. 0)0 -Cu CO) (L-4y 0 u> E~ x c 0 4- 4-1* 4-- +a C: Ln . $ WWC@ U 0 -C a ~-&~ E nC0 -J 00 41 4a 4a E C-AC . X (U a 54- E .0 0)0+a. a) cu w E- w -Q L-~ ~ L C CU 4-