Oracle International Corporation

Laurence W Becker

Diane L Boross

Mark Alan Kleidon

Anupama Ramesh

Brent Thomas Jenkins

Shirphone Kuo

A system and method adapted to facilitate efficient sorting and displaying of data in a table. An example method includes displaying a table with a first portion of data and a second portion of data; simultaneously applying a first sort rule to the first portion of data (primary database object(s)) and a second sort rule to the second portion of data (secondary database object(s)) in response to user selection of a sort option; and illustrating sorted data via the table, wherein the first sort rule is adapted to cause the first portion of data to appear in one or more predetermined locations in the table relative to the second portion of data. The second portion of data is sorted according to the second sort rule. In a more specific embodiment, primary database objects are sorted via the first sort rule and are not subject to the second sort rule. The first sort rule includes a specification that primary database objects be displayed at a predetermined location in the table, such as in an uppermost position in the table or in an upper most position in a purpose group section of the table.

Method and system for sorting and displaying data

Setting and displaying primary objects for one or more purposes in a table for enterprise business applications

Information is stored in a data pattern. The data pattern includes an identity table, a version table that includes at least one reference to the identity table, and an audit table that includes at least one reference to the version table. The identity table stores information identifying the information. The version table stores version information identifying one or more versions of the information identified in the identity table. The audit table stores audit information identifying when each of the one or more versions of the information was modified. The audit table may also store effectiveness information identifying when each of the one or more versions of the information is in effect.

Data pattern for storing information, including associated version and audit information for use in data management

Growing community of inventors

Mountain View, CA, United States of America

Laurence W Becker