University of Arkansas

Walton College

The Sam M. Walton College of Business

Sam's Club

Sam's Club, a division of Wal-Mart Stores, Inc., is a warehouse club that specializes in selling to small businesses. A membership-based store, Sam's Club offers goods and services for consumers and business owners as well as affordable luxury merchandise. Sam's Club keeps prices low by selling merchandise in bulk and at very low profit margins.

sams club logo

Accessing the Sam's Club Dataset

The Sam's Club dataset is contained within the Walton College of Business's Enterprise Systems.

The dataset can be accessed with SQL queries within the University of Arkansas's Remote Desktop environment. The best way to access the dataset would be within the University's Teradata SQL Assistant software or Microsoft SQL Management Studio (Systems).

Once an account is obtained, the Sam's Club database can be queried as fit by the user.

Access To These Datasets

Access to these datasets is for educational use and Systems Access must be requested and approved prior to use. Once access has been approved, the Data Dictionary and Entity Relationship Diagram is available by logging into the requested system and selecting the Instructions tab.

Note: By legal agreement, It is forbidden to download the data from the University of Arkansas systems. This will be strictly enforced.

Request Systems Access


Behind the Data

The Sam's Club Database contains retail sales information gathered from sales at Sam's Club stores. The process used to gather this information begins with a Sam's Club member gathering all of the items they intend to purchase during the current visit to Sam's Club. The member then proceeds to a register to check out. A Sam's Club associate scans the member's Sam's Club card, at which point a visit number (visit_nbr) is generated and stored in the store_visits table. The associate proceeds by scanning each item with a barcode reader. When all of the items have been scanned, summary information about each individual type of product (i.e. 6 packages of sop) purchased during that visit is recorded in the item_scan table. When payment is tendered for items purchased on that visit, summary information for the total order (transaction time & date, amount spent, number of unique items purchased, etc) is recorded in the store_visits table. Other tables are used to store information about stores, products, and members.

The Dataset

The retail sales information in the UA_SAMSCLUB database was provided to the Walton College of Business by Wal-Mart Stores, Inc. The database consists of 6 tables with more than 55 million rows populated and ready for use.

This is a gifted dataset that is based on real operational data. Like many real databases, integrity problems may be noted. This can provide a unique opportunity not only to expose students to real data but also to illustrate the effects of data integrity problems.

The UA_SAMSCLUB consists of six tables which include STORE_VISITS (Store visits by member), ITEM_SCAN (Information collected when item is scanned), STORE_INFORMATION (Information about store), MEMBER_INDEX (Member's information), ITEM_DESC (Item description), and SUB_CATEGORY_DESC (Item's secondary information).

Data Dictionary and Entity Relationship Diagram for WCOB_SAMS_STOREVISITS, WCOB_SAMS_SALES AND WCOB_SAMS_INTERATED will be made available once the "Request Systems Access" has been approved.

Metadata information can be downloaded once you have obtained access to the University of Arkansas system.

UA_SAMSCLUB contains sales transaction data for 18 Sam's Club stores between January 1 and January 31, 2000.

Sam's Club Integrated

Table Name Time Frame Rows Attributes Size (GB)
ITEM_DESC 1/28/1983 to 10/1/2017 1,863,843 86 1.479
ITEM_SCAN 1/1/2014 to 3/31/2014 964,534,590 9 140.761
STORE_INFO 12/15/1982 to 12/31/2049 1,034 34 1.320
TENDER 1/1/2014 to 3/31/2014 367,741,511 6 38.903
VISIT 1/1/2007 to 4/20/2014 180,567,699 13 18.813
5 TABLES     148 199.958
Platform data is currently available: Yes

Sam's Club Visits

Table Name Time Frame Rows Attributes Size (GB)
STORE_INFO 12/15/1982 to 12/31/2049 1,304 34 0.001
TENDER 1/1/2007 to 4/30/2014 10,226,711,544 6 1,082.298
VISIT 1/1/2007 to 4/30/2014 5,049,399,530 13 526.105
3 TABLES     53 1,608.405
Platform data is currently available: Yes

Sam's Cub Sales

Table Name Time Frame Rows Attributes Size (GB)
ITEM_DESC 1/28/1983 to 10/1/2017 1,863,843 86 1.479
ITEM_SCAN 7/1/2014 to 12/31/2015 6,106,076,262 9 809.794
STORE_INFO 12/15/1982 to 12/31/2049 1,038 34 0.001
3 TABLES     129 811.275
Platform data is currently available: Yes