WO2001031506A3 - System for tracking and analyzing data changes in computer databases - Google Patents

System for tracking and analyzing data changes in computer databases Download PDF

Info

Publication number
WO2001031506A3
WO2001031506A3 PCT/US2000/029169 US0029169W WO0131506A3 WO 2001031506 A3 WO2001031506 A3 WO 2001031506A3 US 0029169 W US0029169 W US 0029169W WO 0131506 A3 WO0131506 A3 WO 0131506A3
Authority
WO
WIPO (PCT)
Prior art keywords
segments
members
segment
probe
data
Prior art date
Application number
PCT/US2000/029169
Other languages
French (fr)
Other versions
WO2001031506A2 (en
Inventor
Charles Nicholls
Ranvir Wadera
Original Assignee
Customatics Inc
Charles Nicholls
Ranvir Wadera
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Customatics Inc, Charles Nicholls, Ranvir Wadera filed Critical Customatics Inc
Priority to AU80306/00A priority Critical patent/AU8030600A/en
Publication of WO2001031506A2 publication Critical patent/WO2001031506A2/en
Publication of WO2001031506A3 publication Critical patent/WO2001031506A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/02—Marketing; Price estimation or determination; Fundraising
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2358—Change logging, detection, and notification

Abstract

A system allowing a business users and analysts to use software to track and analyze segments, joiners, leavers, and define probes and other mechanisms to facilitate real-time analysis of data changes in a computer database. Joiners are members who have recently joined a segment. Leavers are members who have recently left a segment. Probes are re-usable expressions for deriving a value from properties of a segment member, joiner, leaver or other item. A probe can be a flag, simple or complex relational expression, or other expression. An example of a probe value is the average purchase interval for a given segment. Probe values are typically tracked over time to provide meaningful analysis data. Probe expressions can be associated with segments' member, joiners, leavers and / or associated with individual members of segments and other aspects of the system. By using probes in combination with segments or individual segment members, the need for running slow, expensive queries against large amounts of detailed data is reduced or eliminated. This allows important analytical data to be available in real-time. Alerts and actions can be triggered according to probe values or other conditions, called ChangeAgents. Such alerts and actions can result in email messages being sent; or mail, fax or other communications being sent to members of a company or to customers. A graphical user interface is provided to provide an efficient and intuitive means for an analyst or operator to implement the above features. Other aspects of the system include monitors for associating rules to segments with scheduled activation, and vectors for indicating the direction that a data item (e.g., a customer) is moving over time.
PCT/US2000/029169 1999-10-22 2000-10-19 System for tracking and analyzing data changes in computer databases WO2001031506A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU80306/00A AU8030600A (en) 1999-10-22 2000-10-19 System for tracking and analyzing data changes in computer databases

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
US16092199P 1999-10-22 1999-10-22
US60/160,921 1999-10-22
US49845400A 2000-02-04 2000-02-04
US09/498,454 2000-02-04

Publications (2)

Publication Number Publication Date
WO2001031506A2 WO2001031506A2 (en) 2001-05-03
WO2001031506A3 true WO2001031506A3 (en) 2003-11-20

Family

ID=26857342

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2000/029169 WO2001031506A2 (en) 1999-10-22 2000-10-19 System for tracking and analyzing data changes in computer databases

Country Status (2)

Country Link
AU (1) AU8030600A (en)
WO (1) WO2001031506A2 (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030172368A1 (en) * 2001-12-26 2003-09-11 Elizabeth Alumbaugh System and method for autonomously generating heterogeneous data source interoperability bridges based on semantic modeling derived from self adapting ontology
US8407176B2 (en) 2006-05-05 2013-03-26 British Telecommunications Plc Data processing method for controlling a network
US8583645B2 (en) 2008-01-18 2013-11-12 International Business Machines Corporation Putting items into categories according to rank

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5734720A (en) * 1994-11-29 1998-03-31 Salganicoff; Marcos System and method for providing digital communications between a head end and a set top terminal
WO1999012115A1 (en) * 1997-08-28 1999-03-11 Catalina Marketing International, Inc. Method and apparatus for generating purchase incentive mailing based on prior purchase history

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5734720A (en) * 1994-11-29 1998-03-31 Salganicoff; Marcos System and method for providing digital communications between a head end and a set top terminal
WO1999012115A1 (en) * 1997-08-28 1999-03-11 Catalina Marketing International, Inc. Method and apparatus for generating purchase incentive mailing based on prior purchase history

Also Published As

Publication number Publication date
AU8030600A (en) 2001-05-08
WO2001031506A2 (en) 2001-05-03

Similar Documents

Publication Publication Date Title
Glencross et al. CD45‐assisted PanLeucogating for accurate, cost‐effective dual‐platform CD4+ T‐cell enumeration
US20020072951A1 (en) Marketing support database management method, system and program product
US6640226B1 (en) Ranking query optimization in analytic applications
Garfinkle Occupations of women and black workers, 1962-74
Shao et al. Applying data mining to detect fraud behavior in customs declaration
US20080133478A1 (en) Systems and methods for data management
WO2001031506A3 (en) System for tracking and analyzing data changes in computer databases
Jones et al. Current practices in management information systems
Rafferty Equal pay: The evolutionary process 1984-1994
Chen et al. An integrated query and mining system for temporal association rules
Lee et al. A Business Application of the Business Intelligence and the Big Data Analytics
Misdolea Decision support system and customer relationship management as components of the cybernetic system enterprise
Domingo-Ferrer Advances in inference control in statistical databases: An overview
Shaw by-article citation analysis of medical journals
Tallis et al. The analysis of survival data from a central cancer registry with passive follow‐up
Summit In search of the elusive end user: Delivered at the EUSIDIC Annual Conference, Abano Terme, Italy 16–19 October 1989
Slutsky et al. Automatic approaches to clustering occupational description data for prediction of probability of workplace exposure to beryllium
Xu et al. Caucus-based transaction clustering
Rosyida A SYSTEMATIC LITERATURE REVIEW AND BIBLIOMETRIC ANALYSS OF WORK FAMILY CONFLICT
Bao et al. The Influence of Working in Non-working Time Through Information and Communication Technologies on Job Engagement
Kamaruddin The relationship between compensation systems and employee performance at Cosmopoint College in peninsular Malaysia
Jonathan Analysis of Financial Perormance After the Adoption of Financial Technology in Telecommunication Industry in Indonesia from Year 2012-2016
Ilderton Evaluation of samples with few non-zero items.
Soongswang The perceived importance and implementation of internal controls in a database environment.
van Solingen et al. Applying Software Measurement to Organizational Issues

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CR CU CZ DE DK DM DZ EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: JP