AU2021107468A4

AU2021107468A4 - A method and system for implementing xml and xquery to perform read and writre operations in minumum number of calls

Info

Publication number: AU2021107468A4
Application number: AU2021107468A
Authority: AU
Inventors: Harshal Damodar Dalvi; Arjun Krishnakumar Jaiswal; Neha Abhishek Katre
Original assignee: Individual
Current assignee: Individual
Priority date: 2021-08-25
Filing date: 2021-08-25
Publication date: 2021-12-23
Anticipated expiration: 2029-08-25

Abstract

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. 11 CN 0 0 0)0 -Cu CO) (L-4y 0 u> E~ x c 0 CL ~ 0 ~0 4- 4-1* 4-- +a C: Ln . $ WWC@ U 0 -C a ~-&~ E nC0 -J 00 41 4a 4a E CUC C-AC . X (U a 54- E .0 0)0+a. a) cu w E- w -Q CL L-~ ~ L C CU 4-

Description

CN 0 0

0)0 -Cu CO)

(L-4y 0 u> E~ x c 0 CL

~ 0 ~0 4- 4-1*

4-- +a C: Ln . $

WWC@ U 0 -C a

~-&~ E

nC0 -J 00 41 4a 4a E

CUC

C -AC . X (U a

54- E

.0 0)0 +a. a) cu w E- w -Q

CL L-~ ~ L C CU 4-

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

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.

BACKGROUND OF THE INVENTION

The applications needs to reads from and writes a large amount of data to the database. The speed and performance of the application depends on how fast the read and write process is. The reading and writing process is generally achieved using database calls. The performance optimization can be done by decreasing the database calls and it also increases the user experience. Nowadays applications have started using XML for the modeling of unstructured and structured data. The SQL statements are used for the non-XML data and XQuery is sued for XML data, wherein XQuery provides really better performance and programming facilities than SQL.

The conventional operation of reading and writing to the database is achieved using database calls require more memory, process and time which makes it expensive to use specially when the data to be write and read is of a large quantity and this also might result in inconsistency in getting the data. The benefits of using XML over the conventional read and write operation are improved performance, prevention of SQL injection attack, and saving the database roundtrip time, wherein all this is done by reducing the database calls. Therefore there is a need of a method and system for implementing XML and XQuery to perform read and write operations in minimum number of calls.

SUMMARY OF THE INVENTION

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. In this disclosure the implementation of XML and XQuery is discussed when working with the huge data of an academic institution, wherein the operator need to enter new student details and update the existing students info continuously, and wherein it is required that the operator can enter multiple information of students and save them at once instead of entering and saving individual records. The number of database calls for performing the operation of reading and writing to the database is reduced by implanting XML and XQuery which makes the process fast with limited amount of memory and gives a better user experience and keeps the data consistent. The implementation using XQuery language serializes the object to and from the XML file, wherein the proof of concept is developed using .NET framework for making the serialization easy, wherein after the implantation the XML to class mapping is done in which an entity class is created which includes the student property, wherein this class is added to studentList collection when the class gets populated after every update. The advantages of the problem implementation using the XQuery language are passing of data to the database using a single parameter of XML type, large amount of data can be processed in one go, and effortless changes can be done at data access layer.

The present disclosure seeks to provide a method 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 property of students for inserting, updating and deleting the same into the database, wherein the class is filled with the information of students and a collection of these classes is formed dynamically; translating the created collection into the XML format by using the concept of reflection; and passing the organized XML to the stored procedure, wherein the XML is passes as a parameter and then the required operation can be performed using the XQuery.

The present disclosure also seeks to provide a system for implementing XML and XQuery to perform read and write operations in minimum number of calls. The system comprises: a generation unit for generating a class which contains the property of student for inserting, updating and deleting them into or from the database, wherein the class is filled with information of students for making a studentList collection dynamically; a translating unit for translating the created collection into the XML format using the concept of reflection; and a storing unit for parsing the XML data using XQuery and carrying out many CRUD operations, wherein the generated XML are passed to the database stored procedure.

An objective of the present disclosure is to provide a method and system for implementing XML and XQuery to perform read and write operations in minimum number of calls.

Another object of the present disclosure is to implement the XML and XQuery for solving the problem of inserting and editing the large amount of data into the database by reducing the number of database calls.

Another object of the present disclosure is to provide a solution wherein an operator needs to enter and update the student's data continuously and could enter multiple data in a single go.

Another object of the present disclosure is to provide a method in which data can be easily passes on to the database by using a single parameter of XML type.

Yet, another object of the present disclosure is to provide an idea of the powerful facilities provided by the use of XQuery language over the traditional SQL method.

To further clarify advantages and features of the present disclosure, a more particular description of the invention will be rendered by reference to specific embodiments thereof, which is illustrated in the appended drawings. It is appreciated that these drawings depict only typical embodiments of the invention and are therefore not to be considered limiting of its scope. The invention will be described and explained with additional specificity and detail with the accompanying drawings.

BRIEF DESCRIPTION OF FIGURES

These and other features, aspects, and advantages of the present disclosure will become better understood when the following detailed description is read with reference to the accompanying drawings in which like characters represent like parts throughout the drawings, wherein:

Figure 1 illustrates a flow chart of a method for implementing XML and XQuery to perform read and write operations in minimum number of calls in accordance with an embodiment of the present disclosure;

Figure 2 illustrates a block diagram of a system for implementing XML and XQuery to perform read and write operations in minimum number of calls in accordance with an embodiment of the present disclosure;

Figure 3 illustrates the application dashboard interface in accordance with an embodiment of the present disclosure;

Figure 4 illustrates the tables of time taken for inserting, updating, and deleting the records in accordance with an embodiment of the present disclosure;

Further, skilled artisans will appreciate that elements in the drawings are illustrated for simplicity and may not have been necessarily been drawn to scale. For example, the flow charts illustrate the method in terms of the most prominent steps involved to help to improve understanding of aspects of the present disclosure. Furthermore, in terms of the construction of the device, one or more components of the device may have been represented in the drawings by conventional symbols, and the drawings may show only those specific details that are pertinent to understanding the embodiments of the present disclosure so as not to obscure the drawings with details that will be readily apparent to those of ordinary skill in the art having benefit of the description herein.

DETAILED DESCRIPTION:

For the purpose of promoting an understanding of the principles of the invention, reference will now be made to the embodiment illustrated in the drawings and specific language will be used to describe the same. It will nevertheless be understood that no limitation of the scope of the invention is thereby intended, such alterations and further modifications in the illustrated system, and such further applications of the principles of the invention as illustrated therein being contemplated as would normally occur to one skilled in the art to which the invention relates.

It will be understood by those skilled in the art that the foregoing general description and the following detailed description are exemplary and explanatory of the invention and are not intended to be restrictive thereof.

Reference throughout this specification to "an aspect", "another aspect" or similar language means that a particular feature, structure, or characteristic described in connection with the embodiment is included in at least one embodiment of the present disclosure. Thus, appearances of the phrase "in an embodiment", "in another embodiment" and similar language throughout this specification may, but do not necessarily, all refer to the same embodiment.

The terms "comprises", "comprising", or any other variations thereof, are intended to cover a non-exclusive inclusion, such that a process or method that comprises a list of steps does not include only those steps but may include other steps not expressly listed or inherent to such process or method. Similarly, one or more devices or sub-systems or elements or structures or components proceeded by "comprises...a" does not, without more constraints, preclude the existence of other devices or other sub-systems or other elements or other structures or other components or additional devices or additional sub-systems or additional elements or additional structures or additional components.

Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The system, methods, and examples provided herein are illustrative only and not intended to be limiting.

Embodiments of the present disclosure will be described below in detail with reference to the accompanying drawings.

Figure 1 illustrates a flow chart of a method for implementing XML and XQuery to perform read and write operations in minimum number of calls in accordance with an embodiment of the present disclosure. At step 102 the method 100 includes, generating the class which includes the property of students for inserting, updating and deleting the same into the database, wherein the class is filled with the information of students and a collection of these classes is formed dynamically.

At step 104 the method 100 includes, translating the created collection into the XML format by using the concept of reflection.

At step 106 the method 100 includes, passing the organized XML to the stored procedure, wherein the XML is passes as a parameter and then the required operation can be performed using the XQuery.

In an embodiment, the method future comprises XML to class mapping, wherein the populated class is added to the studentList collection, and wherein the generated XML is passed to the database stored procedure, wherein the XML data is parsed using XQuery and many CRUD operations are also carried out.

In an embodiment, the development of the proof of concept is carried out using .NET framework to make the serialization of the objects to and from an XML file easy due to the reflection concept.

In an embodiment, an analysis for basic insertion, update, and deletion operation for both XQuery and SQL is carried, wherein the results showed that the implemented XQuery is way faster than the traditional SQL method which uses statements.

Figure 2 illustrates a block diagram of a system for implementing XML and XQuery to perform read and write operations in minimum number of calls in accordance with an embodiment of the present disclosure. The system 200 includes, a generation unit 202 for generating a class which contains the property of student for inserting, updating and deleting them into or from the database, wherein the class is filled with information of students for making a studentList collection dynamically.

In an embodiment, a translating unit 204 is used for translating the created collection into the XML format using the concept of reflection.

In an embodiment, a storing unit 206 is used for parsing the XML data using XQuery and carrying out many CRUD operations, wherein the generated XML are passed to the database stored procedure.

Figure 3 illustrates the application dashboard interface in accordance with an embodiment of the present disclosure. The dashboard is need to be built for an academic institution where an operator need for enter and modify the data of students continuously, wherein the amount of data is very large and the need is that the operator can enter multiple information and save them in one go instead of saving one by one. The figure shows the application interface, wherein the operator can add multiple students by clicking add more link and the bulk insertion is carried out by the save using buttons.

Figure 4 illustrates the tables of time taken for inserting, updating, and deleting the records in accordance with an embodiment of the present disclosure. The figure (a) shows the table for inserting the records using both XQuery and SQL statements method, wherein the figure shows that the XQuery is much faster than the traditional SQL method. The figure (b) shows the table of updating the records using both XQuery and SQL method, wherein the figure shows that the XQuery is much faster than the conventional SQL statements. The figure (c) shows the table of deleting the records using XQuery and SQL statement method, wherein the figure clearly shows that the XQuery is very much faster than the traditional SQL statement method.

In an embodiment, the method used in the XML to class mapping is more object oriented then the XmlWriter approach and in this case more is coding is required as well. Here the instance of XmlDocument object is used for creating a new element using the CreatElemento method. In a situation where only few values are needed to be changed in an XML document then using the XmlWriter will make the process long since then the method will include: reading the information usingthe XmlReader; storing it and then changing it; and writing the information back using XmlWriter. On the other hand when the XmlDocument is used, then it will keep everything in the memory which makes the whole process a lot easier then the XmlWriter.

In an embodiment, the implementation discussed in the present disclosure which uses basic XQuery for various CRUD operations is really simple and can be used for working with the more complex projects for achieving a better performance, wherein in the analysis of the implemented XQuery for many basic operations, it is found that the XQuery is 200 times faster than the normal SQL statement method.

The drawings and the forgoing description give examples of embodiments. Those skilled in the art will appreciate that one or more of the described elements may well be combined into a single functional element. Alternatively, certain elements may be split into multiple functional elements. Elements from one embodiment may be added to another embodiment. For example, orders of processes described herein may be changed and are not limited to the manner described herein. Moreover, the actions of any flow diagram need not be implemented in the order shown; nor do all of the acts necessarily need to be performed. Also, those acts that are not dependent on other acts may be performed in parallel with the other acts. The scope of embodiments is by no means limited by these specific examples. Numerous variations, whether explicitly given in the specification or not, such as differences in structure, dimension, and use of material, are possible. The scope of embodiments is at least as broad as given by the following claims.

Benefits, other advantages, and solutions to problems have been described above with regard to specific embodiments. However, the benefits, advantages, solutions to problems, and any component(s) that may cause any benefit, advantage, or solution to occur or become more pronounced are not to be construed as a critical, required, or essential feature or component of any or all the claims.

Claims

We CLAIM:

1. A method 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 property of students for inserting, updating and deleting the same into the database, wherein the class is filled with the information of students and a collection of these classes is formed dynamically; translating the created collection into the XML format by using the concept of reflection; and passing the organized XML to the stored procedure, wherein the XML is passes as a parameter and then the required operation can be performed using the XQuery.

2. The method as claimed in claim 1, wherein the method future comprises XML to class mapping, wherein the populated class is added to the studentList collection, and wherein the generated XML is passed to the database stored procedure, wherein the XML data is parsed using XQuery and many CRUD operations are also carried out.

3. The method as claimed in claim 1, wherein the development of the proof of concept is carried out using .NET framework to make the serialization of the objects to and from an XML file easy due to the reflection concept.

4. The method as claimed in claim 1, wherein an analysis for basic insertion, update, and deletion operation for both XQuery and SQL is carried, wherein the results showed that the implemented XQuery is way faster than the traditional SQL method which uses statements.

5. A system for implementing XML and XQuery to perform read and write operations in minimum number of calls, the system comprises:

a generation unit for generating a class which contains the property of student for inserting, updating and deleting them into or from the database, wherein the class is filled with information of students for making a studentList collection dynamically; a translating unit for translating the created collection into the XML format using the concept of reflection; and a storing unit for parsing the XML data using XQuery and carrying out many CRUD operations, wherein the generated XML are passed to the database stored procedure.

generating the class which includes the property of students for inserting, 102 updating and deleting the same into the database, wherein the class is filled with the information of students and a collection of these classes is formed dynamically 104 translating the created collection into the XML format by using the concept of reflection

passing the organized XML to the stored procedure, wherein the XML is passes as a 106 parameter and then the required operation can be performed using the XQuery.

Figure 1 generation unit 202 translating unit 204 storing unit 206

Figure 2

Figure 3

(a) (b) Time (in µsec) Time (in µsec) Records Using times times Using XQuery Records Updated Using XQuery Using SQL Written SQL faster faster

1 17.7 3286.1 185.66 1 25.5 3791.8 148.70 2 21.7 4025.9 185.53 2 28.1 4096.8 145.79 3 25.5 5716.3 224.17 3 29.9 6296.9 210.60

4 31.6 6624.1 209.62 4 33.4 7521.4 225.19 5 34.2 9563.1 279.62 5 33.1 8541.6 258.05

(c) Time (in µsec)

times Records Deleted Using XQuery Using SQL faster

1 22.8 2996.6 131.43 2 27.3 4684.7 171.60 3 32.7 5292.4 161.85 4 34.5 6142.5 178.04 5 35.2 8814.2 250.40

Figure 4