SQL Server Modeling Services Architecture
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
The SQL Server Modeling Services database provides a robust storage location for a variety of data. For data-driven applications, the storage and manipulation of models are a major focus. This section describes the Modeling Services database architecture and discusses many of the features required of an enterprise-ready model and configuration database.
Modeling Services uses Microsoft SQL Server 2008, which provides a solid foundation for the storage for data models. SQL Server 2008 supports databases that are highly scalable, available, and secure. SQL Server 2008 features include clustering, database mirroring, resource governor, backup and restore, replication, reporting services, change data capture, and change tracking.
In This Section
To understand the Modeling Services database architecture, you should first understand how the Modeling Services database is organized with SQL schemas and how to access the data in those schemas through security views. This provides a framework for understanding the architecture of specific Modeling Services features. The following topics use this strategy for exploring the Modeling Services architecture: