Tracking method for storing event data using database-objects

• US 6,668,259 B1
• Filed: 09/05/2000
• Issued: 12/23/2003
• Est. Priority Date: 04/07/2000
• Status: Expired due to Term

• Current Assignee: Rockwell Automation Technologies Incorporated (Allen-Bradley Co., Inc.), The Ultimate Software Consultants
• Original Assignee: Rockwell Automation Technologies Incorporated (Allen-Bradley Co., Inc.), The Ultimate Software Consultants
• Inventors: Ventura, David, Santell, Michael P.
• Primary Examiner(s): Mizrahi, Diane D.
• Assistant Examiner(s): Mofiz, Apu M
• Application Number:
  US09/654,755
• Time in Patent Office: 1,204 Days
• Field of Search: 707/2, 707/3, 707/9, 707/100, 707/101, 707/103.R, 707/103.Y, 707/103.Z, 709/201, 709/202
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

Business transactions or other events may be structured as a series of database-objects formed of combinations of sub-objects which in turn may depend on yet a lower level of objects. By creating object templates for the objects that progressively group inter-correlated data and inter-correlated objects, large amounts of event data may be captured with modest data storage requirements. The system is particularly well suited for capturing sales events comprised of a large range of data of different attributes.

Claims

1. A method for organizing an object-oriented database comprising the steps of:

(a) providing at least two first customer database-objects having attributes associated with a customer;

(b) defining at least one second customer database-objects as a composite of first customer database-objects

(c) providing at least two first product database-objects having attributes associated with a product;

(d) defining at least one second product database-object as a composite of first product database-objects; and

(e) defining at least one sales event database-object as a composite of at least one second customer database-object and at least one second product database-object;

wherein at least one of the attributes of the first customer database-objects is selected from the group consisting of data describing customer locations, customer agents, and customer enterprises.

2. The method of claim 1 further including the step of:

(d) capturing a sales event by instantiating a sales event database-object.

3. The method of claim 2 wherein the instantiated sales event database-object uses at least one previously instantiated second customer database-object.

4. The method of claim 2 wherein the instantiated sales event databsse-object uses at least one previously instantiated first customer databaso-object.

5. The method of claim 2 wherein the instantiated sales event database-object uses at least one previously instantiated second product database-object

6. The method of claim 2 wherein the instantiated sales event database-object uses at least one previously instantiated first product database-object.

7. The method of claim 1 further including the steps of

providing at least two first fulfillment database-objects having attributes associated a customer fulfillment of product to customers;

defining at least one second fulfillment database-object as a composite of first fulfillment database-objects; and

wherein the sales event database-object is defined as a composite of at least one second customer database-object and at least one second product database-object and at least one second fulfillment database-object.

8. The method of claim 7 further including the step of:

(d) capturing a sales event by instantiating a sales event database-object

9. The method of claim 8 wherein the instantiated sales event database-object uses at least one previously instantiated second fulfillment database-object.

10. The method of claim 9 wherein the instantiated sales event database-object uses at least one previously instantiated first fulfillment database-object.

11. The method of claim 1 wherein the attributes of the first customer database-objects are selected from the group consisting of data describing customer locations, customer agents, and customer enterprises.

12. The method of claim 1 wherein the attributes of the first product database-objects are selected from the group consisting of data describing product information, product business, and product designs.

13. The method of claim 1 wherein the attributes of the first fulfillment database-objects are selected from the group consisting of data describing fulfillment logistics, fulfillment services, and a fulfillment manufacturing support chain.

14. A method of accessing strategic sales data associated with products sold to customers and the fulfillment thereof comprising the step of:

(a) modeling a sales transaction as an intersection of a customer object, a product object and a fulfillment object;

(b) defining, in an object-oriented database, a sales event database-object referencing a customer database-object, a product database-object and a fulfillment database-object corresponding to the modeled customer object, the product object and the fulfillment object;

(c) recording each sales transaction as a sales event database-object; and

(d) accessing strategic sales data of a sales transaction by accessing a sales event database-object;

wherein the customer database-object directly or indirectly references at least one attribute that is selected from the group consisting of data describing customer locations, customer agents, and customer enterprises.

17. The method of claim 14 wherein the product object is further modeled as an intersection of three additional product objects, each of which is also implemented as a database-object corresponding to the additional product object and referenced by the product database-object.

18. The method of claim 17 wherein the three additional product objects are product information, product business, and product design and wherein the product database-object is defined as referencing a product information database-object a product business database-object, and a product design database-object corresponding to the product information, product business, and product design.

19. The method of claim 14 wherein the fulfillment object is further modeled as an intersection of three additional fulfillment objects, each of which is also implemented as a database-object corresponding to the additional fulfillment object and referenced by the fulfillment database-object.

20. The method of claim 19 wherein the fine additional fulfillment objects are fulfillment logistics;

fulfillment services; and

fulfillment manufacturing support chain and wherein the fulfillment database-object is defined as referencing a fulfillment logistics database-object, a fulfillment services database-object, and a fulfillment manufacturing support chain database-object corresponding to the fulfillment logistics, fulfillment services, and fulfillment manufacturing support chain.

21. A data structure comprising:

first customer database-objects each having attributes associated with a customer;

at least one second customer database-object defined as a composite of first customer database-objects;

first product database-objects each having attributes associated with a product; and

at least one second product database-object defined as a composite of first product database-objects; and

a sales event database-object defined as a composite of at least one second customer database-object and at least one second product database-object;

wherein at least one of the attributes of the first customer database-objects is selected from the group consisting of data describing customer locations, customer agents, and customer enterprises.

15. The method of claim 21 wherein the customer object is further modeled as an intersection of three additional customer objects, each of which is also implemented as a database-object corresponding to the additional customer object and referenced by the customer database-object.

16. The method of claim 15 wherein the three additional customer objects are customer location, customer agent, and customer enterprise and wherein the customer database-object is defined as referencing a customer location database-object;

a customer agent database-object; and

a customer enterprise database-object corresponding to the customer location, customer agent, and customer enterprise.

22. The data structure of claim 21 further including

first fulfillment database-objects having attributes associated with a customer fulfillment of product to customers;

at least one second fulfillment database-object defined as a composite of first fulfillment database-objects,; and

wherein the sales event database-object is defined as a composite of at least one second customer database-object and at least one second product database-object and at least one second fulfillment database-object.

23. The data structure of claim 21 wherein the attributes of the first customer database-objects an selected from the group consisting of:

data describing customer locations, customer agents, and customer enterprises.

24. The data structure of claim 21 wherein the attributes of the first product database-objects are selected from the group consisting of:

data describing product information;

product business; and

product designs.

25. The data structure of claim 21 wherein the attributes of the first fulfillment database-objects are selected from the group consisting of:

data describing fulfillment logistics;

fulfillment services; and

fulfillment manufacturing support chain.

26. A method of capturing sales event data of events over time using an object-oriented database having database-objects that may reference either or both of attributes of the event data and other database-objects, wherein the database-objects are instanceable to create database-object instances referencing either or both of data of the attributes of the database-objects and instances of the other database-objects, the method comprising the steps of:

(a) defining a set of underlying database-objects, each referencing at least a portion of the attributes of the event data;

(b) defining an event database-object referencing at least a portion of the underlying database-objects;

p1 (c) upon each event having given event data,

(i) instancing given ones of the set of underlying database-objects referencing new attributes of the given event data; and

(ii) instancing an event database-object referencing the instanced given ones of the set of underlying database-objects;

wherein the underlying database-objects include;

(1) a CUSTOMER database-object in turn referencing other database-objects;

(2) a PRODUCT intermediate database-object in turn referencing other database-objects; and

(3) a FULFILLMENT intermediate database-object in turn referencing other database-objects;

wherein at least one of the attributes referenced, directly or indirectly, by the CUSTOMER database-object is selected from the group consisting of data describing customer locations, customer agents, and customer enterprises.

27. The method of claim 26 wherein the CUSTOMER intermediate database-object in turn references:

(a) a LOCATION underlying database-object referencing attributes indicating

(b) an AGENT underlying database-object referencing attributes indicating customer agents; and

(c) an ENTERPRISE underlying database-object referencing attributes indicating customer enterprises.

28. The method of claim 26 wherein the PRODUCT intermediate database-object in turn references:

(a) a PRODUCT INFORMATION underlying database-object referencing attributes indicating product information;

(b) a PRODUCT BUSINESS underlying database-object referencing attributes indicating product business; and

(c) a PRODUCT DESIGN underlying database-object referencing attributes indicating product designs.

29. The method of claim 26 wherein the FULFILLMENT intermediate database-object in turn references:

(a) a FULFILLMENT LOGISTICS underlying database-object referencing attributes indicating fulfillment logistics;

(b) a FULFILLMENT SERVICES underlying database-object referencing attributes indicating fulfillment services; and

(c) a FULFILLMENT MANUFACTURING SUPPORT CHAIN underlying database-object referencing attributes indicating fulfillment manufacturing support chain.

30. The method of claim 26 wherein the CUSTOMER intermediate database-object in turn references:

(a) a LOCATION underlying database-object referencing attributes indicating customer locations;

(b) an AGENT underlying database-object referencing attributes indicating customer agents; and

(c) an ENTERPRISE underlying database-object referencing attributes indicating customer enterprises; and

wherein the PRODUCT intermediate database-object in turn references;

(a) a PRODUCT INFORMATION underlying database-object referencing attributes indicating product information;

(b) a PRODUCT BUSINESS underlying database-object referencing attributes indicating product business; and

(c) a PRODUCT DESIGN underlying database-object referencing attributes indicating product designs; and

wherein the FULFILLMENT intermediate database-object in turn references;

(a) a FULFILLMENT LOGISTICS underlying database-object referencing attributes Indicating fulfillment logistics;

(b) a FULFILLMENT SERVICES underlying database-object referencing attributes indicating fulfillment services; and

(c) a FULFILLMENT MANUFACTURING SUPPORT CHAIN underlying database-object referencing attributes indicating fulfillment manufacturing support chain.