Deriving Accounts Receivable In An Events-Based, Relational Database System

Abstract

Database designers face certain challenges in seeking to derive accounting numbers, such as accounts receivable, from an events-based relational database system.  An ideal solution would record raw events uniquely in events tables, where the data are nonredundant and normalized.  The actual implementation of this solution is not trivial, but it can be a rewarding exercise.