The development of XML stored procedures in XML enabled databases

Authors:
Fahad Alahmari;Eric Pardede
Affiliations:
Department of Computer Science & Information Technology, RMIT University, Melbourne, VIC, Australia;Department of Computer Science and Computer Engineering, La Trobe University, Melbourne, VIC, Australia
Venue:
WAIM'11 Proceedings of the 2011 international conference on Web-Age Information Management
Year:
2011

Citing 4
Cited 0

Query triggers for XML DBMS: Efficient implementation based on shadow mechanism

Programming and Computing Software
The Active XML project: an overview

The VLDB Journal — The International Journal on Very Large Data Bases
On Developing Methods for XML Databases

ICCSA '08 Proceedings of the international conference on Computational Science and Its Applications, Part II
Extending XML triggers with path-granularity

WISE'07 Proceedings of the 8th international conference on Web information systems engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

In Relational Databases (RDB), the concept of stored procedures is quite familiar to users, these being procedural methods that can be used for data retrieval and manipulation. When users want to query or manipulate data, they can utilize these methods and pass in the parameters. By doing so, the users do not need to perform ad-hoc queries every time they want to perform typical actions. In contrast, XML databases offer no support for such methods as yet, meaning that users have to write ad-hoc XQuery or XPath, which can be time consuming, prone to errors and not user-friendly. This paper investigates how SQL stored procedures can be developed to effectively conduct various XQuery and XPath against XML data within the enabled databases. For implementation, we use SQL Server 2008.