Question On Association Models: MINIMUM_ITEMSET_SIZE
Jan 6, 2007
I've been experimenting with the algorithm parameters for a market basket association model. The default MINIMUM_ITEMSET_SIZE is 1. This doesn't seem to make sense: what is the point of a single-member itemset? However changing the value to 2 substantially reduces the proportion of good recommendations obtained (which I'm testing via a holdout approach).
So I'm obviously misunderstanding what the parameter means. Can someone explain it please, and also explain the observation above)?
View 1 Replies
ADVERTISEMENT
Jan 10, 2007
Hi all ,
this is my first post here hope i will find help.
I'm facing problems in understanding some topics .. and i searched on the net but every time i read an article i find new things and topics.
i think i need just a good way to start from the following topics.
-recovery models (full,simple,..).
-fullback and differntial back up.
waiting for your help or even links to external articles may also help.
thanks in adavance
View 4 Replies
View Related
May 16, 2007
Hello,
Let€™s say (for simplicity), in my site you can do one of two things €“ look at products and buy products.
I want to build an association structure between my products based on those two actions, but(!) when a user looks at two products it creates less important association than when the user actually bought those two products.
So basically, I want to give a different factor base on different actions occurred on my products.
How do I build my structure? How do I query it?
View 3 Replies
View Related
May 14, 2007
I'm trying to figure out how to build a personalization engine.
If my structure is built with users as case, and products as nested - I€™d like to predict best products per user (rather than associated products), and If possible, ignoring products he already bought.
How do I do it?
View 7 Replies
View Related
Jul 24, 2007
Hi,
I am working on a table that has following fields transaction_id, product_name,product_brand,product_size,product_quantity.
fyi, If a customer purchases 3 items, all have same transaction_id.
I need to use this table (in BIDS) for finding associations between different products,, but I am unable to do so.
Can anyone help me as to which fields should be used as input so that I can predict the association.
Thanks a lot.
Aashutosh Magdum
View 6 Replies
View Related
May 14, 2006
When i use the MS association rules ,i don't know how it is worked on the background .I stuy the Fp-Growth algorithm , but there're some questions , I don't kown what's the meaning of transcation database. who can give me one example ? thanks .I know we can store the data in relation database,but in basket Analysis ,how a transaction stroed in relation database?
View 3 Replies
View Related
May 29, 2007
I am entering to administration of
SS2005 SP1 (Windows 2003) having files mdf, ndf, ldf in
C:Program FilesMicrosoft sql serverMSSQLData
This dir also has two *.cer files.
Apparently no encryption is used
How can I get known what these *.cer files are for?
View 4 Replies
View Related
Aug 10, 2006
Hi,
I have a product basket scenario in where I have to recommend contracts to a customer based on the product and the quantity he/she buys. Product Quantity is an important factor which administers the user in the purchase of a particular contract
I have the following tables with me.
Customer product transaction table, Customer Contract transaction table but there is no direct relationship between contract and product in the database. The only way the two can be linked is through the customer.
If I create a mining structure with Customer-Product information as the nested table and Customer-Contract information as the nested table with customer being the link between the two, the model is showing some irreverent contract recommendations.
what is the solution for the above problem? Is it because the is no direct relationship between the product and the contract?
How can I overcome this problem?
View 6 Replies
View Related
Dec 3, 2006
1) I use the identifier of transaction and attribute in one table.
Do I can to build a association rules structure without the use of the nested tables?
I tried - did not turn out...
2) As it is necessary to use a main and child table, can not build a prediction query.
When I try to add the predict column in a criteria/argument (Field=PredictSupport), i'll given message:
"Nested table column cannot be used as an argument in a data mining function."
I can not use other columns, because they are not predicable.
View 4 Replies
View Related
May 31, 2007
I'm wondering if anyone can give me some help with an association model I'd like to setup. It's a typical market-basket analysis, but rather than grouping by individual customers, I'd like to group by customer grouping. (In our database, customers are grouped into categories like: large, small, medium) If this is possible, I'd like to generate the most popular items (so just querying the most probable itemsets), for each customer grouping (I'll refer to this as 'segments' from here on out), and then create a listing of customers in each segment which do not have the most popular items for their segment. I know for this last part I can use reporting services to tackle that problem, however, I'm not really sure how I can really do the rest of this with an association model in SSAS.
Our table structure looks like this:
Code Snippet
CustomerTable PurchasesTable
------------- --------------
CustomerName(key) CustomerName
CustomerGroup PurchasedProduct
And the data is arranged in this fashion:
Code SnippetCustomer Table:
CustomerName CustomerGroup
------------- -------------
A large
B large
C small
Purchases Table:
CustomerName PurchasedProduct
------------ ----------------
A ProductA
A ProductB
B ProductA
C ProductC
C ProductD
I know this is a lot of information but any help you guys may be able to offer would be great! Thanks!
View 5 Replies
View Related
Jul 6, 2001
Any one knows if the recovery models in SQL7.0 same as in SQL2000, if not the same do you know them and which one is the default.
Saad
View 1 Replies
View Related
Apr 12, 2006
Hi,
If I'm using a transactional replication and the publisher's recovery model is se to FULL, can the subscribers use simple recovery model?
Thanks.
View 1 Replies
View Related
Dec 5, 2007
Hello Everybody , I have Some questions and I am sure that this is the best place for them to not be questions any more.
Here are My Questions:
What is the difference between full recovery model and simple recovery model?
My database has an mdf file about 400mb and a log file about 5GB.
Is this caused because of full recovery model?
What can I do in order to make my log file smaller?
Which recovery Model Do you Suggest for Use and Why?
Thank you So Very Much
I sell my mother in law.Is anybody interested?
View 12 Replies
View Related
Jul 20, 2005
Hi.Does anyone know any web site with common database models presented andexplained.Database models like calendar, adressbook, storehouse...Thnx in advance
View 1 Replies
View Related
Jan 25, 2007
I am using the Excel 2007 data mining add-in, and don't have write perms on the Analysis Services server. Can I store datamining models in an alternate location?
View 1 Replies
View Related
Jun 6, 2007
I have a Sharepoint integrated Reporting Services server. I have created Report models based on Data Sources. I then created Report Builder Reports to make some BI Charts and Graphs. They look great and work fine for a few days then all of a sudden I get a rsItemNotFound error saying it cannot find the Report Model which is clearly there.
An error has occurred during report processing. (rsProcessingAborted)
The item 'IT Reports/PWPDB_Prod_Model.smdl' cannot be found. (rsItemNotFound)
If I open the Report Model from Report Builder it loads the data fields, but also fails to run reports with the same error
If I try to regenerate the model from the library I get an error stating that the model needs to be a generated model.
The model specified must be a generated model.
(rsModelNotGenerated)
Even after rebooting all of the servers in the farm I get the same messages. I can regenerate a model from the data source and it doesn't work. I am seeing no errors in the logs of my app server at all regarding reporting services.
It looks as though I will have to de-integrate Reporting Services as it is not viable for a business critical application.
View 8 Replies
View Related
Apr 16, 2007
Need a little help here. I would like to utilize the ad-hoc capabilities of Reporting Services to grant the users of one of my web apps the ability to create all sorts of crazy reports that I don't have to develop.
Basically, this web app is a flexible survey engine. My vision is to have the users select questions from a survey that they wish to generate statistics on. My application would create a view in the database that transposes the data into a tabular format. They would then get kicked over to the reporting services web client, where they can regenerate a report model, and then fire up report builder to create their crazy statiscal abomination. (Aren't users grand!)
This process sounds wonderful, but I'm not aware of any way to get the report model to regenerate and pickup any views. I can get it to pick up any new tables that are added as long as a primary key is created for them, but I want the automated dynamic data rendering that comes with a view. Hopefully, some of you out there have tried to do this already and have some ideas that may help me. Thanks!
View 2 Replies
View Related
May 10, 2007
Hello
I've created models with Decision Tree and Neural Network algorithms that predict continous target. But I don't know how to interpret scores that occure under scatter accuracy plot. How should I interpret scores under scatter accuracy plot?
How can I estimate occuracy of model created with Time Series? How can I compare accuracy of model created with Time Series with models created with Decision Trees and Neural Network algorithms?
Thanks in advance.
View 5 Replies
View Related
Aug 8, 2007
Hi there,
it has been a long i'm trying to execute Microsoft Association Rules on my database.
I solved memory leak problem now, but i still can't understand output rules.
Database contain all the italian student who took a degree last year. Here in Italy, they have to compile a summary where they speak about universitary experience. ie: they talk about experience with teachers (pointage from 1 to 5); they says if they want to continue in the universitary field or not, and so on.
Most of the rules, says:
Int_Stud=1-2, RapDoc>4
Int_Stud is the column where i store student intention to continue university. 1 means they want to go on, 2 means they do not want to continue to study. So, this rules has no sense, because it relates all the student (in my mind): the one who wants to continue university and the one who do not want to.
I think problem is that visual studio 2005 and analysis service has no understanding of Int_Stud world, they've no idea that Int_Stud can have just 2 values and that they're opposite each other. Is there a solution to this problem? Can i discretize this column?
Even if I know not to have perfect english, I hope to be understandable
View 10 Replies
View Related
Jun 3, 2007
Hello Developers,
I used the add mining model to mining structure to modify a model so that maximum itemset =2, min prob=.01, min support= 2.
When i select maximum rows to anything higher than 2000 (default) i get duplicate rules.
The maximum rules returns is exactly16000 even though i set it higher than that.
Any ideas on the causes?
Thanks
Davy
View 4 Replies
View Related
Jan 20, 2007
What is the algorithm that generates the itemsets in the Association model? I'm looking to possibly use this part of the Association algorithm (i.e. the grouping into itemsets) in a separate plug-in algorithm.
View 1 Replies
View Related
May 21, 2007
Why do association itemsets have probabilities associated with them when its rules that generate probabilities? Any queries I do against my model are using these itemset probabilities rather than the probabilities that the rules generate. More over, the probabilities generated for these itemsets are far less than the MINIMUM_PROBABILITY tag in the algorithm properties menu.
View 3 Replies
View Related
Jan 28, 2008
I note that there exist three web viewers for data mining algorithms, namely, DMNaiveBayesViewer, DMDecisionTreeViewer and DMClusterViewer. How come there are no viewers for association rules (itemsets, rules, dependency network)? Can you suggest any alternative way of showing such valuable information in a web application?
View 1 Replies
View Related
May 2, 2007
Hello,
How do I get n and only items predicted by a specific item(s) either directly or indirectly as shown in the dependency network diagram?
For instance, the predict function won€™t work for me - because running this query on AdvantureWorks:
SELECT PREDICT([Association].[Products], 5)
From [Association]
NATURAL PREDICTION JOIN
(SELECT (SELECT 'Touring Tire Tube' AS [Model]) AS [Products]) AS t
Returns Sport-100 as a second result, although it is not predicted by any mean by Touring Tire Tube as shown in the dependency network diagram.
My query should have returned just one row - Touring Tire.
View 1 Replies
View Related
Feb 14, 2008
I understand Mr. MacLennan's explanation provided at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=282651&SiteID=1 and appreciate the time he took to explain how importance works. However, like the user with username "sang", I also ran the data in BI 2005 and got the same results listed by the aforementioned user. I did this using the following data:
donut
muffin
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
y
n
y
n
y
n
y
n
y
n
y
etc.
The rule muffin -> donut has an importance of -0.105302438, which is not the same as Mr. MacLennan's results. I tried switching the roles of a and b in a -> b and using different bases on the logarithms. I don't get the result of -0.105302438 with any of these. I also tried to calculate importance with a small data set I have and can't get the results using Mr. MacLennan's explanation with that data set either. Any thoughts on the descrepancy?
View 5 Replies
View Related
Feb 20, 2008
Hi!
I need to deploy several Association algorithms, so I want to do it using ISS. Can anyone help me telling me which task should I have to use to do it?
Thanks!
Ezequiel
View 1 Replies
View Related
Jul 17, 2007
Hi
I am doing the Market basket analysis for a retailer using association rule. The whole data set is huge which contains grocery, clothes and books etc. If I want to check out the relationship between several different clothes brands, (e.g. LEVI'S and adidas), should I just remove all the grocery and books transactions, use the subset which only contains clothes transactions to re-run the association rules? Is this gonna work?
Thanks in advance!
View 3 Replies
View Related
Jun 20, 2007
Hi
I got a question about the data preparation of market basket analysis.
There are always some transactions with only one single SKU product. It seems that these kind of transactions have nothing to do with association. Shall I just exclude them or what?
Thanks in advance.
View 4 Replies
View Related
Apr 12, 2007
hi,
i have a exercise using association datamining
my database have 350 records,
i use 90 records for datamining and it release some rules which i choose on top of mSOLAP_NODE_SCORE,
but when i use select statement to check my result i have 1 records, the same as my result, and 5 records not true;
for example:
rules A=a,B=b-> C=c
select * from <my_table> where A='a' and B='b' and C='c'; ==>1 record return
select * from <my_table> where A='a' and B='b' and C<>'c'; ==>5 records return
C with 3 values c1,c2,c
with the second statement C includes 2 c1 and 3 c2
i don't understand how they work.
i want to choose some best rules can present my database.
how can i choose importance and probability to get best rules.
with database have 90 records and a database have 350 records which values i should use for minimum_probability, Minimum_Support, Minimum_importance...
when i choose rules i should choose on importance or probability.
thanks for your help
View 4 Replies
View Related
Aug 15, 2006
Hello,
I want to score my data by only the assoziation rules I filtered in Mining-Model-Viewer.
Is this possible?
I recognized that MiningModel Predictionquery uses the generated Model (all rules).
Is there any way to influence the model at generating time.
Thanks a lot.
Hi,
I specified the point to solve my problem but I did not understand why MS SQL Server didn't recognize the Association parameters I but in. It uses the Minimum_Probability I put in, but the Minimum_Importance i wrote didn't care it, it use the default value.
I want to paste a screenshot here but it isn't possible. By the way I'm using the evaluation version, which should be same as the enterprise edition.
Hope for a soon answer.
Best Regard
View 6 Replies
View Related
Nov 26, 2006
Hello everybody,
I am interested in mining association rules field
I have found some posted statements but I didn't undertand them. I need your help badly.
Just tell from where should I start?
Thanks alot
View 1 Replies
View Related
Nov 22, 2007
I need to create a set of cases for a project that uses the Microsoft Association Rules algorithm to make recommendations for products to customers. My question is: the set of scenarios must include all transactions of customers for training?. or is it sufficient some percentage of total transactions? If i do not use all transactions of customers, could be that the algorithm does not consider some products in their groups or rules and could not make recommendations about these?
thanx
Diego B.
View 3 Replies
View Related
Dec 19, 2006
Hi .Net Guru’s,I have an urgent requirement for my project; the issue is mentioned below;Using .Net(C#/VB.Net) I need to generate/created Database objects from XML schemas.I don't have any sample xml schema file to give you. You just imagine you have a sample .xsd file and this .xsd file will be used to create database tables.Please let me know if you have any queries. Thanks,nick
View 1 Replies
View Related
