Oracle International Corporation

Bea Systems, Inc.

Gregory P Smith

Jalpesh Patadia

James Owen

Rodney McCauley

Joseph Conti

Todd Guay

Timothy Breeden

Brodi Beartusk

Alexander Toussaint

Gaylen D Royal

Shane Pearson

Thomas Carl Stamm

Manish Devgan

Christopher Jolley

Daryl B Olander

Edward K O'Neil

Kevin Blair Frender

Thomas A Cook

Richard Feit

Chris Jolley

Geoffrey Wilson

Chang Choe

Alexandre Toussaint

Cheryl Mrozienski

Jonathan Riel

A system and method for providing collaboration communities in a computer portal environment. The system comprises a community portal tool for creating community portals, portal applications, or portal web applications. In one embodiment, the portal can be one of a number of enterprise applications on server software. The portal can include a community context that can have an indication of members of the community. The indication can be, for example, a list of the members or pointer to a list of members. The community portal can be constructed from portal elements and the community context. The community portal tool can also be used to select a community portal template from a portal component library. The template can include standard elements from the construction of a community portal. A standardized look and feel, layout, and components such as a calendars can be in a community template.

System and method for providing collaboration communities in a computer portal environment

A system and method comprising, sharing information between a plurality of participants in a collaboration; and exposing a set of functions that enable a participant in the plurality of participants to share the information, the set of functions comprising: first functions to facilitate establishing a context in which to interact with the plurality of participants; and second functions to facilitate storing and retrieving values from a shared state, wherein the shared state is accessible within the context.

Systems and methods for collaboration shared state management

A method for integrating a plurality of content repositories into a virtual content repository (VCR), comprising providing credential information to each one of said plurality of content repositories, receiving authorization information from each one of said plurality of content repositories, wherein the authorization information indicates whether or not an authorization procedure succeeded, integrating into the VCR each one of said plurality of content repositories whose authorization information indicates successful authorization, and wherein each one of said plurality of content repositories exposes a first set of services to enable its integration into the VCR.

Federated management of content repositories

An application program interface (API) embodied on one or more computer readable media, comprising a first group of services related to integrating content repositories into virtual content repositories (VCRs), a second group of services related to manipulating information in VCRs, a third group of services related to searching VCRs, a forth group of services related to configuring VCRs, and wherein the application program interface is compatible with a content repository service provider interface (SPI).

Virtual content repository application program interface

An approach for automatically determining database tables that are best suited for index tuning involves analyzing query performance data that specifies an average amount of time required to execute a plurality of queries on the database tables. One or more particular queries are selected from the plurality of queries based upon the query performance data. Data tables required to process the one or more particular queries are selected for index tuning.

Automatically determining data that is best suited for index tuning

A method for providing persistent, dynamic external control of rule-based decision making through inherited user defined rules (UDRs) within a computer controlled relational database management system (RDBMs). Within the novel system, objects are grouped together in a parent-child hierarchy where a child has one parent and each parent can have multiple children. Each object can have one or more pre-defined ('hardcoded') rules associated with it; these hardcoded rules are executed in a sequence to arrive at parameter values which, when applied, tune the database environment. The novel system provides a mechanism for creating UDRs which are associated with a particular object and used by particular hardcoded rules which process the particular object. For a given hardcoded rule, if a processed object does not have a UDR defined within, then a search is made up the object's ancestry (e.g., its parentage) until a defined UDR is located within an ancestor object; this value is then used to modify the behavior of the hardcoded rule. The root of the object hierarchy contains defined UDRs ('base UDRs') for all hardcoded rules, so the above search is effective for all user rules. Before a hardcoded rule is executed, it automatically allows its associated UDR to customize data and/or execute a procedure. The UDRs offer a mechanism for customizing the performance tuning session based on external (user supplied) information and defining the scope of the attribute represented by the UDR from different levels of the object hierarchy.

Dynamic external control of rule-based decision making through user rule

A method for non-recursive data driven parameter evaluation within an information management system (e.g., a relational database management system, RDBMS). Parameters are attributes within an RDBMS system whose value can be modified to influence the manner in which a database environment responds. Depending on the character of the data within a database environment or the hardware resources allocated to the database, the parameter values have a large influence on the performance efficiency of the database. For instance, a parameter value may influence the memory size of certain data storage areas within a database environment and, if set too small, can cause an inefficiently large amount of input/output accesses to occur as data is moved in and out of disk storage. Also, many parameters are data dependent on other parameters. The novel system presents an automated system for evaluating parameters using a non-recursive evaluation process. By using a non-recursive approach, the evaluation process is streamlined in that only one pass yields an optimum parameter evaluation and the results are reproducible. The novel system identifies a set of parameters within an environment to be tuned, eliminates cyclic dependencies, and orders the parameters based on independence, levels of dependence, impact on system performance and common data usage. The present invention is data driven because rules within a respective parameter are then evaluated based on data availability to arrive at a set of parameter value recommendations. In one embodiment instance, tablespace, system environment, and schema parameters can be evaluated within a RDBMS tuning session.

Non-recursive method for parameter evaluation within an information

Growing community of inventors

Westminster, CO, United States of America

Gregory P Smith