Application instantiation based upon attributes and values stored in a meta data repository, including tiering of application layers objects and components

• US 6,574,635 B2
• Filed: 03/03/1999
• Issued: 06/03/2003
• Est. Priority Date: 03/03/1999
• Status: Expired due to Term

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Stauber, Christopher, Rothwein, Thomas M., Ambrose, Jesse
• Primary Examiner(s): Millin, Vincent
• Assistant Examiner(s): Colbert, Ella
• Application Number:
  US09/261,771
• Publication Number:
  US 20020161734A1
• Time in Patent Office: 1,553 Days
• Field of Search: 707/1, 707/10, 707/103, 707/9, 707/101, 345/329, 345/330-332, 345/594, 345/663, 345/678, 709/225
• US Class Current: 707/704
• CPC Class Codes: G06F 9/465 Distributed object oriented systems remote method invocation [RMI] G06F9/548
• CPC Class Codes: Y10S 707/944 Business related
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

Instantiation of tiered software applications running on an Internet or Intranet computer system, including a method of instantiation and a program product for instantiation. The method, and program product are particularly useful in instantiation of multi-tiered applications having a user interface tier on the client, browser, or remote computer, from a meta data repository containing attributes and values of the attributes.

Claims

1. A program product having machine-readable program code for establishing a multi-layered, object-oriented software application, comprising:

an object repository containing a plurality of object attributes and definitions, along with associated values;

a data manager layer connected to the object repository, running on a first computer and operable to maintain an object-oriented abstraction of data within the object repository;

an object manager layer connected to the object repository and the data manager layer, running on the first computer and operable to maintain a plurality of business objects, wherein the plurality of business objects are organizable into projects and wherein the projects can be locked, checked-out, or checked-in;

an applet manager layer running on at least two computers separate from the first computer and operable to maintain a plurality of user-interface objects including applet objects,

wherein each of the layers contains at least one interface for communications between the layers, a user, or an external application, and

further wherein the object repository contains an executable file for instantiating the user-interface objects in accordance with their corresponding attributes, definitions and values whenever a user of at least one of the two separate computers utilizes the user-interface objects.

2. The program product of claim 1, wherein one of said at least one interface is an application programming interface by which third-party application access the business objects through standard protocols.

3. The program product of claim 1, wherein the applet manager layer further comprises:

applet objects having applet object definitions stored in the object repository and representing interactive visual components for interfacing with a user; and

view objects having view object definitions stored in the object repository,

wherein the applet manager layer reads the view object definition to determine which applet objects are required in response to a user view request, reads the applet object definitions and instantiates the applet objects to thereby draw associated interactive visual components based on the applet object definition and compatible with a one of the two separate computers running the instantiated applet objects.

4. The program product of claim 3, wherein the applet manager layer manages interactions between the applet objects and the business objects based on the object attributes, definitions and values stored within the object repository.

5. The program product of claim 4, wherein the business objects are mapped to their data sources in the object repository, and further wherein the data manager layer creates SQL objects that in turn generate the SQL necessary to deliver appropriate data to an applet object calling for the data from the repository through the business object.

6. The program product of claim 5, wherein the SQL objects dynamically construct an efficient SQL statement to retrieve or update the data appropriately.

7. The program product of claim 6, further comprising a plurality of data bases in addition to the object repository to which the data manager layer has access.

8. The program product of claim 7, further comprising a universal data exchange layer operable to translate the SQL statement into compatible SQL statements with one of the plurality of databases from which data is obtained.