METHOD AND SYSTEM FOR IMPLEMENTING EFFICIENT UPDATABLE RELATIONAL VIEWS OVER XML DATA
First Claim
Patent Images
1. A computer implemented method for implementing an update relational view over XML data, comprising:
- generating an updateable relational view, wherein the updateable relational view maps row and columns for XML data; and
using a processor to generate a structure for identifying a node address within the XML data that corresponds to a row value in the updateable relational view, wherein the node address is usable to implement an update operation to a node associated with the row value and the update operation comprises a database query language statement.
1 Assignment
0 Petitions
Accused Products
Abstract
Disclosed is a method, system, and program product for providing an efficient mechanism to provide updateable relational views over XML. This will allow application developers to write both queries and updates using a relational (SQL) syntax, even though the underlying data is stored as XML. According to some approaches, this is accomplished by implementing a reverse mapping from the data within the views to the node addresses of the corresponding data in the underlying XML document.
-
Citations
37 Claims
-
1. A computer implemented method for implementing an update relational view over XML data, comprising:
-
generating an updateable relational view, wherein the updateable relational view maps row and columns for XML data; and using a processor to generate a structure for identifying a node address within the XML data that corresponds to a row value in the updateable relational view, wherein the node address is usable to implement an update operation to a node associated with the row value and the update operation comprises a database query language statement. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer program product embodied on a computer usable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a method for implementing an update relational view over XML data, the method comprising:
-
generating an updateable relational view, wherein the updateable relational view maps row and columns for XML data; and generating a structure for identifying a node address within the XML data that corresponds to a row value in the updateable relational view, wherein the node address is usable to implement an update operation to a node associated with the row value and the update operation comprises a database query language statement. - View Dependent Claims (11, 12, 14, 15, 16, 17, 18)
-
-
13. The computer program product of claim 13 in which a row expression expressed with either XPath or XQuery is used to construct the index table.
-
19. A computer-based system for implementing an update relational view over XML data, comprising:
-
a computer processor to execute a set of program code instructions; a memory to hold the program code instructions, in which the program code instructions comprises program code to generate an updateable relational view, wherein the updateable relational view maps row and columns for XML data and use the processor to generate a structure for identifying a node address within the XML data that corresponds to a row value in the updateable relational view, wherein the node address is usable to implement an update operation to a node associated with the row value and the update operation comprises a database query language statement. - View Dependent Claims (20, 21, 22, 23, 24, 25, 26, 27)
-
-
28. A computer implemented method for updating data within an update relational view that is constructed over XML data, comprising:
-
identifying an updateable relational view for an update operation, wherein the updateable relational view maps row and columns for XML data; receiving instruction to perform an update operation on data within the updateable relational view, wherein the update operation comprises a database query language statement; and using a processor to perform the update operation, wherein a reverse lookup is performed of a node address within the XML data to perform the update operation. - View Dependent Claims (29, 30, 31, 32, 33, 34, 35)
-
-
36. A computer-based system for updating data within an update relational view that is constructed over XML data, comprising:
-
a computer processor to execute a set of program code instructions; a memory to hold the program code instructions, in which the program code instructions comprises program code to identify an updateable relational view for an update operation, wherein the updateable relational view maps row and columns for XML data, receive instruction to perform an update operation on data within the updateable relational view, wherein the update operation comprises a database query language statement, and use the processor to perform the update operation, wherein a reverse lookup is performed of a node address within the XML data to perform the update operation.
-
-
37. A computer program product embodied on a computer usable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a method for updating data within an update relational view that is constructed over XML data, the method comprising:
-
identifying an updateable relational view for an update operation, wherein the updateable relational view maps row and columns for XML data; receiving instruction to perform an update operation on data within the updateable relational view, wherein the update operation comprises a database query language statement; and using a processor perform the update operation, wherein a reverse lookup is performed of a node address within the XML data to perform the update operation.
-
Specification