6
Market Basket Architecture and Database Design
Market Basket Analysis has the connotation of a single database the size of China, a query engine the size of Mexico, and a result set the size of Rhode Island. This is definitely not true of this Market Basket Analysis solution design. On the contrary, this solution is designed to leverage the strengths, and avoid the weaknesses, of a Relational Database Management System (RDBMS) platform. To achieve both goals, this solution design incorporates the following elements:
Market Basket Table—The one and only function of this table is to perform a recursive join. That recursive join is invoked during a batch ETL process. Therefore, the recursive join is never modified by analysts. As a result, ...
Get Data Warehouse Designs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
