Object Oriented System and Method for Optimizing the Execution of Marketing Segmentations

• US 20080027788A1
• Filed: 07/27/2007
• Published: 01/31/2008
• Est. Priority Date: 07/28/2006
• Status: Active Grant

• Current Assignee: Aprimo Marketing Operations UK Ltd. (Memo Global Holdings LP)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Burrous, Paul, Lawrence, John, Kelsey, Matthew, Sublette, Tim, Knapp, Curtis
• Granted Patent: US 7,991,800 B2
• Time in Patent Office: Days
• US Class Current: 705/10
• 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

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

segmenting the marketing information;

creating a plurality of nodes from the segmented marketing information;

concatenating nodes; and

accessing the marketing information via the concatenated nodes.

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

8. The method of claim 7 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.

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

10. The method of claim 6 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.

11. A system executed on a computer that optimizes an entire marketing segmentation scheme from a marketing database made up of a number of parent and child segments and represented in a plan, tree, hierarchy, flowchart, grid or other visual presentation into at least one concatenated relational database query to return an array of counts or a set of record keys for each node.

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 organizer for maintaining concatenated nodes defining a subset of data from one of said at least one database.

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 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.

12. The system of claim 11 wherein the system includes software that returns an array of counts in response to the query.

13. The system of claim 11 wherein the system includes software that creates results into a table storing an array of results tagged with the node id and record key.

14. The system of claim 11 wherein the system generates a single output table in response one relational SQL statement having multiple nodes concatenated together.

15. The system of claim 14 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.

16. The system of claim 11 further comprising universe display software enabling an external user to view said database and said nodes.

17. The system of claim 11 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.

14-1. The system of claim 11 wherein said system includes a dataset node for creating a subset of said database according to query criteria.