Object oriented system and method for optimizing the execution of marketing segmentations

• US 7,991,800 B2
• Filed: 07/27/2007
• Issued: 08/02/2011
• Est. Priority Date: 07/28/2006
• Status: Active Grant

• Current Assignee: Aprimo Marketing Operations UK Ltd. (Memo Global Holdings LP)
• Original Assignee: Aprimo, Inc. (Teradata Corporation)
• Inventors: Sublette, Tim A., Kelsey, Matthew J., Knapp, Curtis A., Burrous, Paul J., Lawrence, John A.
• Primary Examiner(s): Lu; Kuen S
• Assistant Examiner(s): Rayyan; Susan F
• Application Number:
  US11/829,635
• Publication Number:
  US 20080027788A1
• Time in Patent Office: 1,467 Days
• Field of Search: 707/791, 707/999.003, 707/999.1, 707/999.102, 707/999.107, 707/803, 705 8- 9, 705/10
• US Class Current: 707/803
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data
• CPC Class Codes: G06Q 30/0204 Market segmentation

Abstract

The present invention involves a computer system and method which implements a marketing management system. The computer comprises a processor, at least one database containing marketing information, and a database segmentation manager the segmentation manager is coupled to the processor and database. The database segmentation manager includes a node organizer for maintaining concatenated nodes defining a subset of data from the database. The node organizer includes a dataset node for creating a subset of said database according to query criteria and creating a temp table storing a portion of the fields and rows obtained by the query criteria. The segmentation manager further includes universe display software enabling an external user to view the database and nodes. The computer further has a graphic workflow manager capable of providing a visual representation with a plurality of items from the database and having a place and an order of a plurality of work tasks relating to the database.

Claims

1. A computer for implementing a marketing management system, said computer comprising:

a processor;

at least one database containing marketing information; and

a database segmentation manager coupled to said processor and said at least one database, said database segmentation manager including a node definition module and a node organizer, said node definition module for allowing user definition of a node as segments of said database, each said segment having associated criteria, said node organizer for maintaining concatenated nodes defining a subset of data from one of said at least one database, said node organizer being capable of creating a temp table and populating said temp table with results from a concatenation of a plurality of queries of said at least one database to create one of said concatenated nodes satisfying said associated criteria from said one of said concatenated nodes, said node organizer further manifesting said concatenated node and associating said concatenated node in the temp table with a tag for use in further queries.

2. The computer of claim 1 wherein said node organizer includes a dataset node for creating a subset of said database according to query criteria.

3. The computer of claim 2 wherein said database includes a plurality of fields and rows, and said dataset node includes software for creating a temp table storing a portion of said fields and rows obtained by the query criteria.

4. The computer of claim 1 wherein said segmentation manager includes universe display software enabling an external user to view said database and said concatenated nodes.

5. The computer of claim 1 further comprising a graphic workflow manager capable of providing a visual representation with a plurality of items from said database and having a place and an order of a plurality of work tasks relating to said database.

6. The computer according to claim 1 wherein said node organizer is capable of excluding predetermined entries in said temp table.

7. The computer according to claim 1 wherein said node organizer is capable of combining a plurality of concatenated nodes as part of said temp table creation.

8. The computer according to claim 1 wherein said node organizer is capable of splitting a plurality of temp tables from said temp table.

9. The computer according to claim 8 wherein said node organizer is capable of splitting said temp tables based on any combination of queries or criteria, random sort order, or sorted on an attribute or multiple attribute with no limits, limited by percentage, or limited by number of records for each temp table.

10. The computer according to claim 1 wherein said node organizer is capable of de-duplicating said temp tables in order to select one or some number of records that are in a same match group with a preference for a one target record based on a sort.

11. In computer, a method of managing marketing information in at least one database, said method comprising the steps of:

segmenting the marketing information from the at least one database;

creating a plurality of nodes from the segmented marketing information, at least one node being defined as a plurality of segments of said database, each said segment having associated criteria;

concatenating nodes by creating a temp table and populating the temp table with results from a concatenation of a plurality of queries of the at least one database satisfying the associated criteria from the concatenated nodes, and manifesting the concatenated node with the temp table and associating the temp table with a tag for use in further queries; and

accessing the marketing information via the tag of the concatenated nodes.

12. The method of claim 11 wherein said creating step includes creating a dataset node for generating a subset of said database according to query criteria.

13. The method of claim 12 wherein the marketing information is stored in a database including a plurality of fields and rows, and said accessing step includes creating a temp table for storing a portion of said fields and rows obtained by said accessing step.

14. The method of claim 11 further including the step of displaying a universe view enabling an external user to view the information and the nodes.

15. The method of claim 11 further comprising the step of providing a visual representation with a plurality of items from the marketing information and having a place and an order of a plurality of work tasks relating to the marketing information.

16. The method of claim 11 wherein the marketing information is stored in a database including a plurality of fields and rows, and said node creating step includes creating a temp table for storing a portion of said fields and rows of the temp table.

17. The method of claim 16 wherein said node creating step includes creating splitter nodes creating a plurality of temp tables from the temp table.

18. The method of claim 17 wherein said splitter node creates the plurality of temp tables based on any combination of queries or criteria, random sort order, or sorted on an attribute or multiple attribute with no limits, limited by percentage, or limited by number of records for each temp table.

19. The method of claim 11 wherein said node creating step includes creating a de-duplicating node for selecting one or some number of records that are in a same match group with a preference for a one target record based on a sort.