Constellations

A Blackbaud Data Warehouse database is organized according to a modified star schema or constellation. In the modified star schema, fact tables reference other fact tables.

But the warehouse can be accessed as if structured according to a pure star schema using views contained in the BBDW database. Online analytical processing is accomplished through a set of features in an Infinity application such as Blackbaud CRM. Data from a Blackbaud Data Warehouse can also be exported and processed in a environment such as Microsoft Excel. For more about constellations and views in a BBDW database, see BBDW Views.