The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 15, 2005
Filed:
Nov. 26, 2002
Nipun Agarwal, Santa Clara, CA (US);
Fei GE, San Jose, CA (US);
Sivasankaran Chandrasekar, Palo Alto, CA (US);
Ravi Murthy, Fremont, CA (US);
Eric Sedlar, San Francisco, CA (US);
Nipun Agarwal, Santa Clara, CA (US);
Fei Ge, San Jose, CA (US);
Sivasankaran Chandrasekar, Palo Alto, CA (US);
Ravi Murthy, Fremont, CA (US);
Eric Sedlar, San Francisco, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Techniques for managing hierarchical data include managing a link table in a relational database. The hierarchical data includes data about a hierarchy of nodes related by multiple links. The link table includes first information, second information and link information, for each link. First information indicates a first node in the hierarchical data. Second information indicates a second node that is associated with the first node by the link. Link information indicates values for link attributes of the link between the first node and the second node, and does not indicate a value for any attribute of the first node alone or any attribute of the second node alone. The techniques support directing a single SQL statement to a path database object, constructed based on the link table, in order to obtain paths that satisfy a search on link attributes.