Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

Free Oracle Tips

HTML Text

 Home
 E-mail Us
 Oracle Articles


 Oracle Training
 Oracle News

 Oracle Forum
 Class Catalog


 Our Staff
 Our Prices
 Help Wanted!

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 UNIX
 Oracle UNIX
 Linux
 Oracle Linux
 Monitoring
 Remote help

 Remote plans
 Remote
services
 Oracle C++
 Oracle Java
 Apache
 JDeveloper
 App Server

 Applications
 Oracle Forms
 Oracle Portal
 11i Upgrades
 SQL Server
 Oracle Concepts
 HTML-DB Tips
 Software Help

 Remote Help  
 Development  

 Implementation


 Financials Training
 Oracle 11i
 Oracle Apps 11i
 Oracle Workflow
 Oracle AR 11i Class
 Oracle AP 11i class
 Oracle GL 11i class
 Oracle HR 11i class
 Oracle FA 11i class
 11i Project Mgt
 11i procurement
 11i collections


 Oracle Posters
 Oracle Books

 Oracle Tuning Book
 Oracle RAC Book
 Oracle Security
 Easy Oracle Books
 Oracle Scripts
 SQL Server DBA
 SQL Design Patterns
 Ion
 Excel-DB   


 BC Oracle News


 Rednecks!
 Dress code
 Arabian Stallion

 Burleson Arabians
 Guide Horses
 Don Burleson Blog
 Golf & Travel


 Privacy Policy
 

 

 
 

All about beer and diapers

Oracle Tips by Burleson Consulting
Match 3, 2008

 

The use of "illustrative examples" is very well-known among teachers who do not want to confuse beginners.  For example, almost everyone who read my "Oracle 911" article clearly understood that these were deliberately over-simplified illustrations, used to emphasize each correct concept.

Yet some people still criticized the article for using illustrative examples, calling them fabrications (Really, I’m not making this up).  In database consulting, everyone knows that you cannot copy your client’s schema and data for “evidence”, and only a beginner would suggest this.

 

In sum, I agree with the statement “Trust but Verify”.  Personally, I trust folks who are out-there tuning Oracle every day, and I don't need proof from someone that I trust.  To discredit an important statement from a real-world database just because it is impossible to provide a “reproducible” proof is not a good practice.
 

Let’s take a closer look at the “Beer and Diapers” concept:

 

Beer and Diapers

 

Teachers MUST create illustrative examples and it is a common practice among professors to use simple illustrations to reinforce a concept. Take the famous “beer and diapers”.  This example is used to explain the concept of data mining to countless University students, and I’ve used it myself when teaching Grad School.

 

The professor admitted that his story was an illustrative example, but it’s not fair to call academic examples “fabrications” or “lies”.

 

http://www.govexec.com/dailyfed/0103/013103h1.htm

 

A number of convenience store clerks, the story goes, noticed that men often bought beer at the same time they bought diapers. The store mined its receipts and proved the clerks' observations correct. So, the store began stocking diapers next to the beer coolers, and sales skyrocketed.

 

The story is a myth, but it shows how data mining seeks to understand the relationship between different actions."

 

http://dssresources.com/newsletters/66.php

 

What is the "true story" about using data mining to identify a relation between sales of beer and diapers?

 

This is one of those recurring questions related to a famous decision support example. The story of using data mining to find a relation between "beer and diapers" is told, retold and added to like any other legend or "tall tale". I can't recall exactly when I first heard a version of the tale, but I have used the story and added to it myself on occasion. The following are some versions of the tale

...

 

An article in The Financial Times of London (Feb. 7, 1996) stated, "The oft-quoted example of what data mining can achieve is the case of a large US supermarket chain which discovered a strong association for many customers between a brand of babies nappies (diapers) and a brand of beer.

 

Hermiz and Manganaris (1999) stated "One of the most repeated (though likely fabricated) data mining stories is the discovery that beer and diapers frequently appear together in a shopping basket.
 

The explanation goes that when fathers are sent out on an errand to buy diapers, they often purchase a six-pack of their favorite beer as a reward."
 

 

If you like Oracle tuning, you might enjoy my book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.


 

 

  
 

 Oracle cruise
 
 
 
Oracle performance tuning software
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.
 
 


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

 

Remote DBA Services


 

Copyright © 1996 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle © is the registered trademark of Oracle Corporation.