BAM Dynamic Infrastructure
The BAM infrastructure consists of SQL Server tables, BAM views, stored procedures, and Data Transformation Services (DTS) packages in the BAM databases (Primary Import, Archive, Star Schema, and Analysis) as configured and managed through incremental deployments of BAM definitions. The infrastructure is where, at run time, events are correlated, aggregated, and then made available for querying by users.
This section describes some of these infrastructure processes. For example, once you extract the data of interest from your applications (the BAM definition), you can store it so that it is available for queries. Additionally, you can maintain certain pre-created aggregations of the data for faster aggregated queries.
Typically, you achieve such functionality by an extensive development effort to implement a data warehouse. BAM in Microsoft BizTalk Server greatly simplifies this process, however, by automatically generating the SQL and OLAP infrastructure based on your activity and view definitions.