Method and mechanism for identifying transaction on a row of data
First Claim
Patent Images
1. A method for accessing data within a relational database, the method comprising steps of:
- receiving, at a relational database system that includes a database server and the relational database, a request including a Uniform Resource Locator (URL) wherein the URL includes an Xpath expression, wherein the Xpath expression specifies a particular relational table of the relational database and a particular column, of the particular relational table, that stores target data;
the relational database system determining, based at least on the Xpath expression, the particular column of the particular relational table of the relational database that corresponds to the target data; and
the relational database system retrieving the target data from the particular column of the particular relational table of the relational database;
wherein retrieving the target data includes converting the Xpath expression into a Structured Query Language (SQL) statement that selects data from the particular column of the particular relational table;
wherein the method is performed by a computer system programmed to be a special purpose machine pursuant to instructions from program software.
2 Assignments
0 Petitions
Accused Products
Abstract
Techniques are provided for using XML syntax in exchanging data in relational databases. According to certain embodiments of the invention, one or more portions of the relational database is visualized as an XML document. A standard Uniform Resource Locator (URL) mechanism is provided to access data stored in the relational database by defining the URL as an XPath expression over the visualized XML document.
95 Citations
38 Claims
-
1. A method for accessing data within a relational database, the method comprising steps of:
-
receiving, at a relational database system that includes a database server and the relational database, a request including a Uniform Resource Locator (URL) wherein the URL includes an Xpath expression, wherein the Xpath expression specifies a particular relational table of the relational database and a particular column, of the particular relational table, that stores target data; the relational database system determining, based at least on the Xpath expression, the particular column of the particular relational table of the relational database that corresponds to the target data; and the relational database system retrieving the target data from the particular column of the particular relational table of the relational database; wherein retrieving the target data includes converting the Xpath expression into a Structured Query Language (SQL) statement that selects data from the particular column of the particular relational table; wherein the method is performed by a computer system programmed to be a special purpose machine pursuant to instructions from program software. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method for accessing data in a relational database, the method comprising computer-implemented steps of:
-
establishing a mapping in which Uniform Resource Locators (URLs) point to data items that are stored in rows of one or more relational tables within the relational database, wherein the URLs include XPath expressions that identify at least the one or more relational tables and one or more columns, of the one or more relational tables, in which the data items corresponding to the URLs reside; and locating the data items within the relational database based on location data that is determined based on the Uniform Resource Locators and the mapping, wherein the step of locating includes; a database server receiving a URL that is mapped to a particular data item, wherein the URL includes an XPath expression that indicates a particular column, in a particular relational table, in which the particular data item resides; and converting the XPath expression into a Structured Query Language (SQL) statement that operates on data items from the particular column of the particular relational table; wherein the method is performed by a computer system programmed to be a special purpose machine pursuant to instructions from program software. - View Dependent Claims (12, 13, 14, 15, 16, 17)
-
-
18. A method for accessing a data item stored in a relational database, the method comprising the steps of:
-
generating, within a database server that manages the relational database, a Uniform Resource Locator (URL) that points to the data item based on where the data item resides within a row of a relational table of the relational database; wherein the URL includes an XPath expression that specifies;
(a) the relational table, (b) a particular column of the relational table, and (c) a particular condition on the particular column;the database server providing the URL to an entity that resides outside the database server; receiving, at the database server, the URL; and in response to receiving the URL, resolving the URL within the database server to locate the data item within the row of the relational table; wherein resolving the URL includes converting the XPath expression into a Structured Query Language (SQL) statement that operates only on rows in the relational table where data in the particular column satisfies the particular condition; wherein the method is performed by a computer system programmed to be a special purpose machine pursuant to instructions from program software. - View Dependent Claims (19)
-
-
20. A computer-readable non-transitory storage medium storing instructions for accessing data within a relational database, the computer-readable medium comprising instructions executable by one or more processors to perform steps of:
-
receiving, at a relational database system that includes a database server and the relational database, a request that including a Uniform Resource Locator (URL) wherein the URL includes an Xpath expression, wherein said Xpath expression specifies a particular relational table of the relational database and a particular column, of the particular relational table, that stores target data; the relational database system determining, based at least on the Xpath expression, the particular column of the particular relational table of the relational database that corresponds to the target data; and the relational database system retrieving the target data from the particular column of the particular relational table of the relational database; wherein retrieving the target data includes converting the Xpath expression into a Structured Query Language (SQL) statement that selects data from the particular column of the particular relational table. - View Dependent Claims (21, 22, 23, 24, 25, 26, 27, 28, 29)
-
-
30. A computer-readable non-transitory storage medium storing instructions for accessing data in a relational database, the computer-readable medium comprising instructions executable by one or more processors to perform steps of:
-
establishing a mapping in which Uniform Resource Locators (URLs) point to data items that are stored in rows of one or more relational tables within the relational database, wherein the URLs include XPath expressions that identify at least the one or more relational tables and one or more columns, of the one or more relational tables, in which the data items corresponding to the URLs reside; and locating the data items within the relational database based on location data that is determined based on the Uniform Resource Locators and the mapping, wherein the step of locating includes; a database server receiving a URL that is mapped to a particular data item, wherein the URL includes an XPath expression that indicates a particular column, in a particular relational table, in which the particular data item resides; and converting the XPath expression into a Structured Query Language (SQL) statement that operates on data items from the particular column of the particular relational table. - View Dependent Claims (31, 32, 33, 34, 35, 36)
-
-
37. A computer-readable non-transitory storage medium storing instructions for accessing a data item stored in a relational database, the computer-readable medium comprising instructions executable by one or more processors to perform steps of:
-
generating, within a database server that manages the relational database, a Uniform Resource Locator (URL) that points to the data item based on where the data item resides within a row of a relational table of the relational database; wherein the URL includes an XPath expression that specifies;
(a) the relational table, (b) a particular column of the relational table, and (c) a particular condition on the particular column;the database server providing the URL to an entity that resides outside the database server; receiving, at the database server, the URL; and in response to receiving the URL, resolving the URL within the database server to locate the data item within the row of the relational table; wherein resolving the URL includes converting the XPath expression into a Structured Query Language (SQL) statement that operates only on rows in the relational table where data in the particular column satisfies the particular condition. - View Dependent Claims (38)
-
Specification