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:
Dec. 01, 2009
Filed:
Nov. 29, 2004
Namit Jain, San Jose, CA (US);
Fei GE, Palo Alto, CA (US);
Ravi Murthy, Fremont, CA (US);
Subramanian Muralidhar, Seattle, WA (US);
Nipun Agarwal, Santa Clara, CA (US);
Eric Sedlar, San Francisco, CA (US);
Namit Jain, San Jose, CA (US);
Fei Ge, Palo Alto, CA (US);
Ravi Murthy, Fremont, CA (US);
Subramanian Muralidhar, Seattle, WA (US);
Nipun Agarwal, Santa Clara, CA (US);
Eric Sedlar, San Francisco, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A method and apparatus for processing path-based database operations is provided. According to one aspect, a 'parent row ID' column is added to a directory links table. For each row in the table, the value of the 'parent row ID' column indicates the row ID, in the table, of the node that is that row's node's parent in the file hierarchy. To determine whether a particular node is within a specified path of the file hierarchy, the particular node's pathname is derived by visiting child-to-parent links indicated in the table and prepending, to the front of a pathname being constructed for the particular node, node names indicated in the visited rows. Each parent node's row in the directory links table is located using the “parent row ID” column of the child node's row. The resulting pathname is compared with the specified path to determine whether the particular node exists therein.