Fact-oriented modelling for data analysis

Abstract. Although entity-relationship modelling is the most popular means of specifying the conceptual schema for the data perspective of an information system, an alternative design approach known as fact-oriented modelling appears to offer advantages. This paper provides an overview of fact-oriented modelling, including some recent revisions and an evaluation of how the method has coped with large-scale practical applications. One distinguishing feature of the approach is its emphasis on natural verbalization of information examples in terms of elementary facts. This notion of elementarity is clarified to cater for a problematic case involving compositely identified object types. Finally, the algorithm for mapping a conceptual to a relational schema is revised to cater for lazy object types.