Translating XML Update Language into SQL

Amornsinlaphachai, Pensri; Rossiter, Nick; Ali, M. Akhtar
June 2006
Journal of Computing & Information Technology;Jun2006, Vol. 14 Issue 2, p81
Academic Journal
Several techniques for translating XML query languages into SQL have been proposed, but no work to date translates XML update languages into SQL since XQuery has not provided any update statements. However, there is a suggestion from W3C indicating that an update version of XQuery will be proposed in the near future. Furthermore, one major advantage of updating XML documents via a relational database is that the preservation of constraints can be transferred to the database engine; thus our main contributions are translating the XML update language, extending XQuery into SQL and translating recursive updates into PL/SQL. XQuery is a functional language whereas SQL is a declarative language; therefore, translation cannot be performed directly, so several techniques such as rewriting rules and graph mapping are used in our work.


Related Articles

  • Rebuild Indexes Online. Smyk, Brian // SQL Server Magazine;Jun2009, Vol. 11 Issue 6, p31 

    The author discusses the online index job he created and used in maintaining indexes in the five nines model. He explains how he created the online index job by first identifying indexes which can be created online, as well as how he implemented the index job. The author notes that with the...

  • Join Queries Translation from SQL to XML. Bhargavi, K.; Chaithra, H. S. // International Journal of Advanced Research in Computer Science;Mar/Apr2013, Vol. 4 Issue 2, p241 

    SQL (Structured Query Language) was one of the standardized query languages for requesting information from a database. Over the past few years organizations are using SQL for storing and managing the organization specific information. At the same time there is an emerging trend towards XML...

  • The Ask Master. Babcock, Charles // Interactive Week;9/24/2001, Vol. 8 Issue 37, p48 

    Focuses on the XML query language developed by the World Wide Web Consortium. Description about XQuery; Similarity between SQL and XQuery; Creation of Web services through XQuery.

  • Using a relational database for scalable XML search. Cathey, Rebecca; Beitzel, Steven; Jensen, Eric; Grossman, David; Frieder, Ophir // Journal of Supercomputing;May2008, Vol. 44 Issue 2, p146 

    XML is a flexible and powerful tool that enables information and security sharing in heterogeneous environments. Scalable technologies are needed to effectively manage the growing volumes of XML data. A wide variety of methods exist for storing and searching XML data; the two most common...

  • DIAGRAMMATIC APPROACH FOR COMPLETE AUTOMATION OF RELATIONAL DATABASE NORMALIZATION AT CONCEPTUAL LEVEL. Patwardhan, M. S.; Dhabe, P. S.; Deshpande, Asavari A.; Londhe, Sandhya G.; Dhore, M. L.; Abhyankar, H. K. // International Journal of Database Management Systems;Nov2010, Vol. 2 Issue 4, p132 

    AER (Articulated Entity Relationship) diagrams proposed by us, are the extension of Entity Relationship (ER) diagrams to accommodate functional dependencies (FDs) as their integral part. Accommodation of FDs in ER diagram helps to achieve total and unconditional automation of relational database...

  • XML based Mediated Query Re-writing Framework.  // International Journal of Computer Applications;Jan2011, Vol. 13, p16 

    The article discusses the resolution to the problem of query optimization in XML-based data integration in hybrid peer to peer data management environment. Presented is a conceptual frame work for Information System based on XML query language, the formulation of rewriting algorithm for XML...

  • Mapping Process of Relational Data to OWL Class Instances using XSLT. Marzouk, Abderrahim // International Journal of Computer Applications;Aug2013, Vol. 75 Issue 1-17, p53 

    Ontologies are widely used in many domains and evolve as domains change [7]. From the other side, the relational database technology has ensured the best facilities for storing, updating and manipulating the information of problem domain. We propose in this paper a transformation process from...

  • Sybase leads with mobile database. Langley, Nick // Computer Weekly;9/23/2003, p49 

    Sybase Inc. is one of the big four relational database suppliers and was once a serious competitor to Oracle Corp. at the top of the market. Sybase is the fourth largest player in the market, with about 3% of sales. It provides business continuity and unstoppable computing solutions and offers a...

  • Model-independent schema translation. Paolo Atzeni; Paolo Cappellari; Riccardo Torlone; Philip Bernstein; Giorgio Gianforme // VLDB Journal International Journal on Very Large Data Bases;Nov2008, Vol. 17 Issue 6, p1347 

    Abstract��We discuss a proposal for the implementation of the model management operator ModelGen, which translates schemas from one model to another, for example from object-oriented to SQL or from SQL to XML schema descriptions. The operator can be used to generate database wrappers...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics