Data model and applications

• US 7,523,133 B2
• Filed: 12/20/2002
• Issued: 04/21/2009
• Est. Priority Date: 12/20/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Mackie, Kevin
• Primary Examiner(s): NGUYEN, CAM LINH T
• Application Number:
  US10/327,464
• Publication Number:
  US 20040122826A1
• Time in Patent Office: 2,314 Days
• Field of Search: 707/100, 707/104.1, 707101-103 R, 705/1
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

Systems and methods relating to a data model are described. The data model includes aspects of both static and dynamic data structures. In a typical implementation the dynamic data structures are used to store information whose organization and values may change responsive to the values of other data stored in the data model. The static data structures are used to store information whose structure and content are relatively more static. Tables within the static and dynamic data structures include a unique key configured to interrelate information stored in each data structure. The data model is illustrated using a customer relationship management (CRM) example. In this example, roles and relationships between business objects are stored in the dynamic data structures.

Claims

1. A method for storing data for access by an application program being executed on a data processing system, comprising:

storing in a first table a unique business object identifier and attribute data characterizing static attributes of a business object identified by the unique business object identifier, wherein the first table is a static data structure, and whereby an entity relationship model is implemented by the static data structure;

varying data fields within each data record of the dynamic data structure in response to a data value stored in another data record, the dynamic data structure being configured to implement the entity relationship model by storing in a second table a role of the business object, wherein the second table is a dynamic data structure having data fields within each data record of the second table which is variable in response to the data value stored in another data record, whereby the entity relationship model is implemented by the dynamic data structure, the business object being identified by the unique business object identifier in the static data structure, the role being indexed by the unique business object identifier in the static data structure, the role of the business object being responsive to a type of the business object;

determining at least one relationship between the business object and another business object and storing the at least one relationship in the second table; and

specifying in metadata an allowed type of the business object, an allowed role for the business object, and an allowed relationship for the business object, whereby the entity relationship model is implemented by the metadata.

2. The method of claim 1, wherein the at least one relationship being responsive to a type of the role of the business object.

3. The method of claim 2, wherein the type of the business object is a person or an organization.

4. The method of claim 2, wherein the business object has attributes of contact method.

5. The method of claim 4, wherein the contact method is configured for selection responsive to the relationship between the business object and another business object.

6. The method of claim 2, wherein the relationship between the business object and another business object is temporal.

7. The method of claim 1, wherein the type of the business object is of a business object type selected from a group consisting of a person, an organization, a purchase order, a task, a process and a transaction.

8. A computer program product stored on a computer-readable medium configured to store code operational by a processor of a computer system for storing data for access by an application program being executed on a data processing system, the computer program product comprising:

code for storing in a first table a unique business object identifier and attribute data characterizing static attributes of a business object identified by the unique business object identifier, wherein the first table is a static data structure, and whereby an entity relationship model is implemented by the static data structure;

code for varying data fields within each data record of the dynamic data structure in response to a data value stored in another data record, the dynamic data structure being configured to implement the entity relationship model by storing in a second table a role of the business object, wherein the second table is a dynamic data structure having data fields within each data record of the second table which is variable in response to a data value stored in another data record, whereby the entity relationship model is implemented by the dynamic data structure, the business object being identified by the unique business object identifier in the static data structure, the role being indexed by the unique business object identifier in the static data structure, the role of the business object being responsive to a type of the business object, and the relationship being responsive to a type of the role of the business object;

code for determining at least one relationship between the business object and another business object and storing the at least one relationship in the second table; and

code for specifying in metadata an allowed type of the business object, an allowed role for the business object, and an allowed relationship for the business object, whereby the entity relationship model is implemented by the metadata.

9. The computer program product of claim 8, wherein the relationship between the business object and another business object is configured to determine a contact method purpose.

10. The computer program product of claim 9, wherein the business object includes a contact method attribute, the contact method attribute configured for selection using the contact method purpose.

11. A customer relation management system for storing data for access by an application program being executed on a data processing system, the customer relation management system comprising:

a processor; and

a memory coupled to the processor, wherein the memory is configured to store a plurality of code modules which when executed by the processor cause the processor to;

implement an entity relationship model by storing in a first table a unique business object identifier and attribute data characterizing static attributes of a business object identified by the unique business object identifier, wherein the first table is a static data structure;

vary data fields within each data record of the dynamic data structure in response to a data value stored in another data record, the dynamic data structure being configured to implement the entity relationship model by storing in a second table a role of the business object, wherein the second table is a dynamic data structure having data fields within each data record of the second table which is variable in response to the data value stored in another data record, whereby the entity relationship model is implemented by the dynamic data structure, the business object being identified by the unique business object identifier in the static data structure, the role being indexed by the unique business object identifier in the static data structure, the role of the business object being responsive to a type of the business object, and the relationship being responsive to a type of the role of the business object;

determine at least one relationship between the business object and another business object and store the at least one relationship in the second table; and

specifying in metadata an allowed type of the business object, an allowed role for the business object, and an allowed relationship for the identified business object, whereby the entity relationship model is implemented by the metadata.

12. The customer relation management system of claim 11, further including a contact method configured for selection responsive to the relationship between business objects.

13. The customer relation management system of claim 11, wherein at least one of the business objects has attributes of a person.

14. The customer relation management system of claim 11, wherein at least one of the business objects is of a type task or is of a type process.