Download
1 / 13

To provide a database designed for models Focuses on application metadata - PowerPoint PPT Presentation


  • 87 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' To provide a database designed for models Focuses on application metadata' - hija


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  • 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


  • Modeling Services Database (1 of 2)

Base Domain Library

BDL

SQL ServerModeling Services Database


  • 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


System.Identity

Microsoft.Uml2

System_Runtime

BDL

Microsoft.Uml2

System_Runtime

System.Identity

Modeling Services Database


  • System_Runtime Domain Benefits

.NET Assembly File

.NET Assembly File

System_Runtime

System_Runtime

.NET Assembly File

select * from [System_Runtime].[Methods]



Your Models

Microsoft.Uml2

System_Runtime

BDL

System.Identity

Modeling Services Database



  • 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


Your Models

“M” Code

Microsoft.Uml2

“M” Command-Line Tools

System_Runtime

BDL

System.Identity

Modeling Services Database


  • SQL Server Modeling Services Summary

Your Models

Microsoft.Uml2

System_Runtime

BDL

BDL

System.Identity


  • 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


ad