1 / 13

To provide a database designed for models Focuses on application metadata

To provide a database designed for models Focuses on application metadata Optimizes storing many models in one database Supports secure data sharing and reuse To provide common model schemas Build models that relate to the application lifecycle Enable Microsoft and third-party solutions.

hija
Download Presentation

To provide a database designed for models Focuses on application metadata

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. To provide a database designed for models • Focuses on application metadata • Optimizes storing many models in one database • Supports secure data sharing and reuse • To provide common model schemas • Build models that relate to the application lifecycle • Enable Microsoft and third-party solutions • Goals of SQL Server Modeling Services

  2. Modeling Services Database: A SQL Server 2008 database with the Base Domain Library (BDL) • Modeling Services Database (1 of 2) Base Domain Library BDL SQL ServerModeling Services Database

  3. Modeling Services database features: • Contains each model in its own SQL Server schema • Organizes data hierarchically • Implements fine-grained security (row-level) • Supports localized strings and resources • Supports change tracking and audit trails • Uses a “natural” database structure that supports standard data access technologies and ad hoc queries • Modeling Services Database (2 of 2) BDL Modeling Services Database

  4. Domain Models System.Identity Microsoft.Uml2 System_Runtime BDL Microsoft.Uml2 System_Runtime System.Identity Modeling Services Database

  5. Models .NET Framework assembly metadata • Previously located in physical files • Enables new analysis possibilities and solutions • System_Runtime Domain Benefits .NET Assembly File .NET Assembly File System_Runtime System_Runtime .NET Assembly File select * from [System_Runtime].[Methods]

  6. Future Domain Models

  7. Adding Custom Models Your Models Microsoft.Uml2 System_Runtime BDL System.Identity Modeling Services Database

  8. Step 1: Write “M” Code for Your Model

  9. PatternApplication Sample: • Download Location: • http://go.microsoft.com/fwlink?LinkId=168642 • Describes which BDL features to apply • Example in Getting Started Tutorial: • http://go.microsoft.com/fwlink/?LinkId=168887 • Step 2: Apply Modeling Services Patterns

  10. Step 3: Deploy Models to Modeling Services DB Your Models “M” Code Microsoft.Uml2 “M” Command-Line Tools System_Runtime BDL System.Identity Modeling Services Database

  11. SQL Server Modeling Services: • An optimized database architecture for models • Common models focusing on the application lifecycle • Your models • SQL Server Modeling Services Summary Your Models Microsoft.Uml2 System_Runtime BDL BDL System.Identity

  12. SQL Server Modeling Services Overview: http://msdn.microsoft.com/en-us/library/dd129569(VS.85).aspx • Getting Started Tutorial: http://go.microsoft.com/fwlink/?LinkId=168887 • Data Developer Center: http://msdn.microsoft.com/data • SQL Server Modeling Services Home Page: http://msdn.microsoft.com/data/ee461169.aspx • For questions, comments, feedback: http://social.msdn.microsoft.com/Forums/en-US/oslo/threads/ • Resources

More Related