To provide a database designed for models focuses on application metadata
This presentation is the property of its rightful owner.
Sponsored Links
1 / 13

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


  • 55 Views
  • Uploaded on
  • Presentation posted in: General

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.

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.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

  • 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


To provide a database designed for models focuses on application metadata

  • 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


To provide a database designed for models focuses on application metadata

  • 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


To provide a database designed for models focuses on application metadata

  • Domain Models

System.Identity

Microsoft.Uml2

System_Runtime

BDL

Microsoft.Uml2

System_Runtime

System.Identity

Modeling Services Database


To provide a database designed for models focuses on application metadata

  • 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]


To provide a database designed for models focuses on application metadata

  • Future Domain Models


To provide a database designed for models focuses on application metadata

  • Adding Custom Models

Your Models

Microsoft.Uml2

System_Runtime

BDL

System.Identity

Modeling Services Database


To provide a database designed for models focuses on application metadata

  • Step 1: Write “M” Code for Your Model


To provide a database designed for models focuses on application metadata

  • 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


To provide a database designed for models focuses on application metadata

  • 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


To provide a database designed for models focuses on application metadata

  • 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


To provide a database designed for models focuses on application metadata

  • 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


  • Login