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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Landberg, A., Rahayu, J., Pardede, E.: Extending XML Triggers with Path-Granularity. In: Benatallah, B., Casati, F., Georgakopoulos, D., Bartolini, C., Sadiq, W., Godart, C. (eds.) WISE 2007. LNCS, vol. 4831, pp. 410–422. Springer, Heidelberg (2007)
Shao, F., Novak, A., Shanmugasundaram, J.: Triggers over XML views of relational data (2005)
Do, W.V., Pardede, E.: On Developing Methods for XML Databases. In: Gervasi, O., Murgante, B., Laganà , A., Taniar, D., Mun, Y., Gavrilova, M.L. (eds.) ICCSA 2008, Part II. LNCS, vol. 5073, pp. 1194–1203. Springer, Heidelberg (2008)
Abiteboul, S., Benjelloun, O., Milo, T.: The Active XML project: an overview. The VLDB Journal The International Journal on Very Large Data Bases 17(5), 1019–1040 (2008)
Gunathunga, J., Umagiliya, A., Kodituwakku, S.: Leverage the use of XML in dynamic GUI parsing and database stored procedures (2007)
Rys, M.: XML and relational database management systems: inside Microsoft® SQL ServerTM. ACM, New York (2005)
Grineva, M.P., Grinev, M.N.: Query triggers for XML DBMS: Efficient implementation on shadow mechanism. Programming and Computer Software 33, 204–213 (2007)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Alahmari, F., Pardede, E. (2012). The Development of XML Stored Procedures in XML Enabled Databases. In: Wang, L., Jiang, J., Lu, J., Hong, L., Liu, B. (eds) Web-Age Information Management. WAIM 2011. Lecture Notes in Computer Science, vol 7142. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-28635-3_14
Download citation
DOI: https://doi.org/10.1007/978-3-642-28635-3_14
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-28634-6
Online ISBN: 978-3-642-28635-3
eBook Packages: Computer ScienceComputer Science (R0)