An Accounts Receivable Star Schema For A Data Mart

Abstract

Data warehouses, or smaller data marts, are becoming crucial for analyzing the enormous amount of data generated by a typical business. This article describes a useful design for organizing accounts receivable data to facilitate analysis. While the relational system might be ideal for processing transactions, a star schema is proposed to support the ad hoc queries common in a data warehouse environment.