ABSTRACT

Delivering data to users requires operationalizing the various data controls and features put into place in the last few chapters against the full Gamma version warehouse that is being loaded. The traditional view of data warehousing as giving users the ability to query and report data in the warehouse is true, but it’s a generalization. More specifically, users are given access to subsets of information in the warehouse to which they have legitimate rights of access for well-defined purposes. What the data users see in the warehouse will often differ based on why they are looking. Satisfying all of these requirements involves taking advantage of features explicitly included in the warehouse design, as well as capabilities of the operating environment, particularly the database management system. Each warehouse implementation will be somewhat different based on differences in those environmental features, but the underlying requirements being addressed will remain common among the wide range of possible environmental implementations, many of which are unique to biomedicine.