← Back to Patent Explorer
US6061682A Expired / Lapsed US ⏱️ 0.0 years remaining

Method and apparatus for mining association rules having item constraints

Assignee: International Business Machines Corp
•
Filing: 1997-08-12
•
Granted: 2000-05-09
•
Expires: 2017-08-12
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract A method for discovering association rules in a database that employs item constraints for extracting desired data relationships from a data base, thereby reducing the execution time of the rule discovery process and increasing the quality of the information returned. Such constraints allow users to specify the subset of rules in which the users are interested. Given a set of transactions D and constraints represented by a boolean expression β, the invention integrates the constraints into a selected rule discovery method rather than implementing the constraints as a post-processing step. The invention quickly discovers association rules that satisfy β and have support and confidence levels greater than or equal to user-specified minimum support and minimum confidence levels, and may be implemented even when a taxonomy is present.

Inventors

  • 👤 Rakesh Agrawal
  • 👤 Ramakrishnan Srikant
  • 👤 Quoc Vu

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-10-28 17:38
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2458; G06F16/2465; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99933; Y10S707/99936; Y10S707/99937

Claims Analysis

Total Claims: 47
Claim 1
Independent Claim 94 words
A method using item constraints to discover association rules contained in a database, the method comprising: finding large itemsets in a database that satisfy defined constraints, the defined constraints involving one or more items of a mining input expression; determining subsets of large itemsets included in the itemsets, an itemset being large if its support is greater than a minimum support value, where support value for an itemset is based upon the number of times the itemset appears in the database; and finding association rules from the large itemsets that satisfy the defined constraints.
Claim 2
Independent Claim 94 words
A method using item constraints to discover association rules contained in a database, the method comprising: finding large itemsets in a database that satisfy defined constraints, the defined constraints involving one or more items of a mining input expression; determining subsets of large itemsets included in the itemsets, an itemset being large if its support is greater than a minimum support value, where support value for an itemset is based upon the number of times the itemset appears in the database; and finding association rules from the large itemsets that satisfy the defined constraints.
Claim 3
Dependent Claim 91 words
The method recited in claim 1, the method further comprising: determining a support value for subsets of large itemsets included in the database where the subsets do not satisfy the defined constraints; determining confidence values using large itemsets which satisfy the defined constraints and itemsets which do not satisfy the defined constraints, where a confidence value comprises a number of times an itemset appears in the database in relation to a number of times an associated itemset appears in the database; and outputting association rules that satisfy a minimum confidence value.
Claim 4
Dependent Claim 49 words
The method recited in claim 1, the method further comprising: generating a set of selected items from the database such that any itemset that satisfies the defined constraints contains at least one selected item; and using only itemsets that contain at least one selected item to find association rules.
Claim 5
Dependent Claim 24 words
A method according to claim 1, wherein the defined constraints involve more than one item of a mining input expression comprising a boolean expression.
Claim 6
Dependent Claim 26 words
A method according to claim 1, wherein the defined constraints are represented by a mining input expression comprising a boolean expression having more than one item.
Claim 7
Independent Claim 131 words
A method for discovering association rules using item constraints, the method comprising: generating a set of selected items from a database based on predefined constraints, the predefined constraints involving one or more items of a mining input expression; determining a support value for an itemset based upon the number of times the itemset appears in the database; entering the itemset into a set of large itemsets if the support value of the itemset is greater than a minimum support value and the itemset contains at least one of the selected items; and outputting an association rule when the number of times the entered itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 8
Independent Claim 131 words
A method for discovering association rules using item constraints, the method comprising: generating a set of selected items from a database based on predefined constraints, the predefined constraints involving one or more items of a mining input expression; determining a support value for an itemset based upon the number of times the itemset appears in the database; entering the itemset into a set of large itemsets if the support value of the itemset is greater than a minimum support value and the itemset contains at least one of the selected items; and outputting an association rule when the number of times the entered itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 9
Dependent Claim 95 words
The method recited in claim 6, further comprising: forming a second itemset by concatenating the large itemset with a set of large items in the database in accordance with a predetermined concatenation regime, where an item is large if the support value of the item is greater than a minimum support value; joining any two elements of the second itemset that have at least one item in common; generating a set of candidate itemsets including itemsets from the second itemset and joined elements; and using the set of candidate itemsets to output the association rules.
Claim 10
Dependent Claim 46 words
The method recited in claim 6, further comprising: determining whether sets contained in the large itemsets satisfy the predefined constraints; generating a set of candidate itemsets including large itemsets which satisfy the predefined constraints; and using the set of candidate itemsets to output the association rules.
Claim 11
Dependent Claim 15 words
The method recited in claim 8, the outputting association rules including pruning non-interesting association rules.
Claim 12
Dependent Claim 99 words
The method recited in claim 6, further comprising: forming a second itemset by concatenating the large itemsets with a set of large items in accordance with a predetermined concatenation regime to generate a set of candidate itemsets, where an item is large if the support value of the item is greater than a minimum support value; arranging the candidate itemsets so that each item within an itemset which is also contained in the set of selected items precedes any item not in the set of selected items; and using the set of candidate itemsets to output the association rules.
Claim 13
Dependent Claim 15 words
The method recited in claim 10, the outputting association rules including pruning non-interesting association rules.
Claim 14
Dependent Claim 20 words
The method recited in claim 6, the generating a selected set of items including pruning non-interesting items from the set.
Claim 15
Independent Claim 191 words
A method for discovering association rules using item constraints, the method comprising: determining a set of large items, where an item is large if the support value of the item is greater than a minimum support value; generating a set of large itemsets where the large itemsets satisfy a predetermined constraint, the predetermined constraint involving one or more items of a mining input expression; forming a second itemset by concatenating the large itemsets with the set of large items in accordance with a predetermined concatenation regime; dropping any set of large items from the second itemset that does not satisfy the predetermined constraint; dropping any set of large items in the second itemset that satisfies the predetermined constraint but does not have a support value greater than the minimum support value; adding an itemset to the second itemset if all non-negated elements of the second itemset are large; and outputting an association rule when the number of times an itemset in the second itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 16
Independent Claim 191 words
A method for discovering association rules using item constraints, the method comprising: determining a set of large items, where an item is large if the support value of the item is greater than a minimum support value; generating a set of large itemsets where the large itemsets satisfy a predetermined constraint, the predetermined constraint involving one or more items of a mining input expression; forming a second itemset by concatenating the large itemsets with the set of large items in accordance with a predetermined concatenation regime; dropping any set of large items from the second itemset that does not satisfy the predetermined constraint; dropping any set of large items in the second itemset that satisfies the predetermined constraint but does not have a support value greater than the minimum support value; adding an itemset to the second itemset if all non-negated elements of the second itemset are large; and outputting an association rule when the number of times an itemset in the second itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 17
Independent Claim 150 words
A method for discovering association rules in a database using item constraints and items having a hierarchial taxonomy, the taxonomy defining descendant and ancestor relationships between the items, the method comprising: generating a set of selected items from a database based on predefined constraints, the predefined constraints involving one or more of the items in a mining input expression; determining a support value for an itemset; if the support value of the itemset is greater than a minimum support value and the itemset contains at least one of the selected items, determining the number of times the itemset appears in the database; entering the itemset into a set of large itemsets; outputting an association rule when the number of times the entered itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 18
Independent Claim 150 words
A method for discovering association rules in a database using item constraints and items having a hierarchial taxonomy, the taxonomy defining descendant and ancestor relationships between the items, the method comprising: generating a set of selected items from a database based on predefined constraints, the predefined constraints involving one or more of the items in a mining input expression; determining a support value for an itemset; if the support value of the itemset is greater than a minimum support value and the itemset contains at least one of the selected items, determining the number of times the itemset appears in the database; entering the itemset into a set of large itemsets; outputting an association rule when the number of times the entered itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 19
Dependent Claim 91 words
The method recited in claim 14, further comprising: forming a second itemset by concatenating the large itemsets with a set of large items in accordance with a predetermined concatenation regime, where an item is large if the support value of the item is greater than a minimum support value; joining any two elements of the second itemset that have at least one item in common; generating a set of candidate itemsets from the second itemset and the joined elements; and using the set of candidate itemsets to output the association rules.
Claim 20
Dependent Claim 47 words
The method recited in claim 14, of further comprising: determining whether sets contained in the large itemsets satisfy the predefined constraints; generating a set of candidate itemsets including large itemsets which satisfy the predefined constraints; and using the set of candidate itemsets to output the association rules.
Claim 21
Dependent Claim 15 words
The method recited in claim 16, the outputting association rules including pruning non-interesting association rules.
Claim 22
Dependent Claim 99 words
The method recited in claim 14, further comprising: forming a second itemset by concatenating the large itemsets with a set of large items in accordance with a predetermined concatenation regime to generate a set of candidate itemsets, where an item is large if the support value of the item is greater than a minimum support value; arranging the candidate itemsets so that each item within an itemset which is also contained in the set of selected items precedes any item not in the set of selected items; and using the set of candidate itemsets to output the association rules.
Claim 23
Dependent Claim 15 words
The method recited in claim 14, the outputting association rules including pruning non-interesting association rules.
Claim 24
Independent Claim 31 words
The method according to any one of claims 6 or 14, wherein the predefined constraints are represented by a mining input expression comprising a boolean expression having more than one item.
Claim 25
Independent Claim 191 words
A method for discovering association rules using item constraints, the method comprising: determining a set of large items, where an item is large if the support value of the item is greater than a minimum support value; generating a set of large itemsets where the large itemsets satisfy a predetermined constraint, the predetermined constraint involving one or more items of a mining input expression; forming a second itemset by concatenating the large itemsets with the set of large items in accordance with a predetermined concatenation regime; dropping any set of large items from the second itemset that does not satisfy the predetermined constraint; dropping any set of large items in the second itemset that satisfies the predetermined constraint but does not have a support value greater than the minimum support value; adding an itemset to the second itemset if all non-negated elements of the second itemset are large; and outputting an association rule when the number of times an itemset in the second itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 26
Independent Claim 191 words
A method for discovering association rules using item constraints, the method comprising: determining a set of large items, where an item is large if the support value of the item is greater than a minimum support value; generating a set of large itemsets where the large itemsets satisfy a predetermined constraint, the predetermined constraint involving one or more items of a mining input expression; forming a second itemset by concatenating the large itemsets with the set of large items in accordance with a predetermined concatenation regime; dropping any set of large items from the second itemset that does not satisfy the predetermined constraint; dropping any set of large items in the second itemset that satisfies the predetermined constraint but does not have a support value greater than the minimum support value; adding an itemset to the second itemset if all non-negated elements of the second itemset are large; and outputting an association rule when the number of times an itemset in the second itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 27
Independent Claim 29 words
A method according to any one of claims 13 or 21, wherein the predetermined constraint involves more than one item of a mining input expression comprising a boolean expression.
Claim 28
Dependent Claim 150 words
An article of manufacture tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to perform a method for discovering association rules using item constraints, the method comprising: generating a set of selected items from a database based on predefined constraints, the predefined constraints involving one or more items of a mining input expression; determining a support value for an itemset based upon the number of times the itemset appears in the database; entering the itemset into a set of large itemsets if the support value of the itemset is greater than a minimum support value and the itemset contains at least one of the selected items; and outputting an association rule when the number of times the entered itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 29
Dependent Claim 150 words
An article of manufacture tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to perform a method for discovering association rules using item constraints, the method comprising: generating a set of selected items from a database based on predefined constraints, the predefined constraints involving one or more items of a mining input expression; determining a support value for an itemset based upon the number of times the itemset appears in the database; entering the itemset into a set of large itemsets if the support value of the itemset is greater than a minimum support value and the itemset contains at least one of the selected items; and outputting an association rule when the number of times the entered itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 30
Dependent Claim 99 words
The article of manufacture recited in claim 23, the method further comprising: forming a second itemset by concatenating the large itemset with a set of large items in the database in accordance with a predetermined concatenation regime, where an item is large if the support value of the item is greater than a minimum support value; joining any two elements of the second itemset that have at least one item in common; generating a set of candidate itemsets including itemsets from the second itemset and joined elements; and using the set of candidate itemsets to output the association rules.
Claim 31
Dependent Claim 50 words
The article of manufacture recited in claim 23, the method further comprising: determining whether sets contained in the large itemsets satisfy the predetermined constraints; generating a set of candidate itemsets including large itemsets which satisfy the predefined constraints; and using the set of candidate itemsets to output the association rules.
Claim 32
Dependent Claim 21 words
The article of manufacture recited in claim 25, the method further comprising outputting association rules including pruning of non-interesting association rules.
Claim 33
Dependent Claim 103 words
The article of manufacture recited in claim 23, the method further comprising: forming a second itemset by concatenating the large itemsets with a set of large items in accordance with a predetermined concatenation regime to generate a set of candidate itemsets, where an item is large if the support value of the item is greater than a minimum support value; arranging the candidate itemsets so that each item within an itemset which is also contained in the set of selected items precedes any item not in the set of selected items; and using the set of candidate itemsets to output the association rules.
Claim 34
Dependent Claim 20 words
The article of manufacture recited in claim 27, the method further comprising outputting association rules including pruning non-interesting association rules.
Claim 35
Dependent Claim 26 words
The article of manufacture recited in claim 23, the method further comprising the generating a selected set of items including pruning non-interesting items from the set.
Claim 36
Dependent Claim 209 words
An article of manufacture tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to perform a method for discovering rules using item constraints, the method comprising: determining a set of large items, where an item is large if the support value of the item is greater than a minimum support value; generating a set of large itemsets where the large itemsets satisfy a predetermined constraint, the predetermined constraint involving one or more items of a mining input expression; forming a second itemset by concatenating the large itemsets with the set of large items in accordance with a predetermined concatenation regime; dropping any set of large items from the second itemset that does not satisfy the predetermined constraint; dropping any set of large items in the second itemset that satisfies the predetermined constraint but does not have a support value greater than the minimum support value; adding an itemset to the second itemset if all non-negated elements of the second itemset are large; and outputting an association rule when the number of times an itemset in the second itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 37
Dependent Claim 209 words
An article of manufacture tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to perform a method for discovering rules using item constraints, the method comprising: determining a set of large items, where an item is large if the support value of the item is greater than a minimum support value; generating a set of large itemsets where the large itemsets satisfy a predetermined constraint, the predetermined constraint involving one or more items of a mining input expression; forming a second itemset by concatenating the large itemsets with the set of large items in accordance with a predetermined concatenation regime; dropping any set of large items from the second itemset that does not satisfy the predetermined constraint; dropping any set of large items in the second itemset that satisfies the predetermined constraint but does not have a support value greater than the minimum support value; adding an itemset to the second itemset if all non-negated elements of the second itemset are large; and outputting an association rule when the number of times an itemset in the second itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 38
Dependent Claim 181 words
A digital processing machine used to discover trends in a database, the device comprising: a database; a digital processing apparatus, the digital processing apparatus configured to receive data and commands from a signal-bearing medium tangibly embodying a program of machine-readable instructions executable by the digital processing apparatus and used to perform a method for discovering trends in a database, said method comprising: generating a set of selected items from a database based on predefined constraints, the predefined constraints involving one or more items of a mining input expression; determining a support value for an itemset based upon the number of times the itemset appears in the database; entering the itemset into a set of large itemsets if the support value of the itemset is greater than a minimum support value and the itemset contains at least one of the selected items; and outputting an association rule when the number of times the entered itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 39
Dependent Claim 181 words
A digital processing machine used to discover trends in a database, the device comprising: a database; a digital processing apparatus, the digital processing apparatus configured to receive data and commands from a signal-bearing medium tangibly embodying a program of machine-readable instructions executable by the digital processing apparatus and used to perform a method for discovering trends in a database, said method comprising: generating a set of selected items from a database based on predefined constraints, the predefined constraints involving one or more items of a mining input expression; determining a support value for an itemset based upon the number of times the itemset appears in the database; entering the itemset into a set of large itemsets if the support value of the itemset is greater than a minimum support value and the itemset contains at least one of the selected items; and outputting an association rule when the number of times the entered itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 40
Dependent Claim 104 words
The machine recited in claim 31, where the method for discovering trends in a database further comprises: forming a second itemset by concatenating the large itemset with a set of large items in the database in accordance with a predetermined concatenation regime, where an item is large if the support value of the item is greater than a minimum support value; joining any two elements of the second itemset that have at least one item in common; generating a set of candidate itemsets including itemsets from the second itemset and joined elements; and using the set of candidate itemsets to output the association rules.
Claim 41
Dependent Claim 55 words
The machine recited in claim 31, where the method for discovering trends in a database further comprises: determining whether sets contained in the large itemsets satisfy the predefined constraints; generating a set of candidate itemsets including large itemsets which satisfy the predefined constraints; and using the set of candidate itemsets to output the association rules.
Claim 42
Dependent Claim 21 words
The machine recited in claim 33, where the generating a selected set of items includes pruning non-interesting items from the set.
Claim 43
Dependent Claim 108 words
The machine recited in claim 31, where the method for discovering trends in a database further comprises: forming a second itemset by concatenating the large itemsets with a set of large items in accordance with a predetermined concatenation regime to generate a set of candidate itemsets, where an item is large if the support value of the item is greater than a minimum support value; arranging the candidate itemsets so that each item within an itemset which is also contained in the set of selected items precedes any item not in the set of selected items; and using the set of candidate itemsets to output the association rules.
Claim 44
Dependent Claim 21 words
The machine recited in claim 35, where the generating a selected set of items includes pruning non-interesting items from the set.
Claim 45
Dependent Claim 21 words
The machine recited in claim 31, where the generating a selected set of items includes pruning non-interesting items from the set.
Claim 46
Dependent Claim 190 words
A digital processing machine used to discover trends in a database, the device comprising: determining a set of large items, where an item is large if the support value of the item is greater than a minimum support value; generating a set of large itemsets where the large itemsets satisfy a predetermined constraint, the predetermined constraint represented by a boolean expression including items; forming a second itemset by concatenating the large itemsets with the set of large items in accordance with a predetermined concatenation regime; dropping any set of large items from the second itemset that does not satisfy the predetermined constraint; dropping any set of large items in the second itemset that satisfies the predetermined constraint but does not have a support value greater than the minimum support value; adding an itemset to the second itemset if all non-negated elements of the second itemset are large; and outputting an association rule when the number of times an itemset in the second itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.
Claim 47
Dependent Claim 190 words
A digital processing machine used to discover trends in a database, the device comprising: determining a set of large items, where an item is large if the support value of the item is greater than a minimum support value; generating a set of large itemsets where the large itemsets satisfy a predetermined constraint, the predetermined constraint represented by a boolean expression including items; forming a second itemset by concatenating the large itemsets with the set of large items in accordance with a predetermined concatenation regime; dropping any set of large items from the second itemset that does not satisfy the predetermined constraint; dropping any set of large items in the second itemset that satisfies the predetermined constraint but does not have a support value greater than the minimum support value; adding an itemset to the second itemset if all non-negated elements of the second itemset are large; and outputting an association rule when the number of times an itemset in the second itemset appears in the database bears a predetermined relationship to a number of times an associated itemset appears in the database and thereby satisfies a minimum confidence constraint.

References Cited (Backward Citations)

US5418948A Cited
US5644686A Cited
US5819266A Cited
US5794209A Cited
US5742811A Cited
US5727199A Cited
US5724573A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2003-05-09 2003-11-08 2004-05-09 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2007-05-09 2007-11-08 2008-05-09 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2011-05-09 2011-11-08 2012-05-09 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag