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. 07, 2006
Filed:
Apr. 11, 2000
Anil Nori, San Jose, CA (US);
Tze-pin Cheng, Milpitas, CA (US);
Chin Hong, Hillsborough, CA (US);
Joyo Wijaya, Menlo Park, CA (US);
Vicky L. Kool, Lafayette, CA (US);
Anil Nori, San Jose, CA (US);
Tze-Pin Cheng, Milpitas, CA (US);
Chin Hong, Hillsborough, CA (US);
Joyo Wijaya, Menlo Park, CA (US);
Vicky L. Kool, Lafayette, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A method and apparatus for presenting and modifying data from a set of tables in a database is provided. A view that is defined is based on a set of one or more tables that may include relational tables or object tables. The view defines a presentation of data from the one or more tables as a set of objects that reside in the database. Data is read from the one or more rows of the tables based on the view, and is presented as a set of objects that reside in the database. An object id that is based on data from the one or more rows is generated and associated with each object presented. The view may specify which columns from the one or more tables contain values used to generate the object ids. A trigger may associated with the view. The set of objects presented may be presented as objects having an attribute that is a column object. Column objects include user specified object types, collection objects (e.g. nested tables and variable arrays), or references to objects.