Sql services futures
Download
1 / 30

SQL Services Futures - PowerPoint PPT Presentation


  • 149 Views
  • Uploaded on

BB14. SQL Services Futures.  Patric McElroy Group Program Manager SQL Data Services. Services Challenges SQL Data Platform. Services-based applications face unique challenges. We’ll focus on Data model/access Occasionally connected Business intelligence. Administration

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 'SQL Services Futures' - adelle


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
Sql services futures l.jpg

BB14

SQL Services Futures

 Patric McElroy

Group Program Manager

SQL Data Services


Services challenges sql data platform l.jpg
Services ChallengesSQL Data Platform

  • Services-based applications face unique challenges

  • We’ll focus on

    • Data model/access

    • Occasionally connected

    • Business intelligence

  • Administration

  • Resource governance

  • Trust

  • Reach

  • Interaction

Reporting

Integration

FILE

RDBMS

OLAP

Analysis

Sync

XML

Query

Search

Mobile/

Desktop

DataServices

Server


Azure services platform l.jpg
Azure Services Platform

Azure™ Services Platform


Scalable available data services storage and database services l.jpg
Scalable, Available Data ServicesStorage and Database Services

Windows Azure Storage

SQL Data Services

“Premium database service in the cloud”

Extends the rich capabilities of the SQL data platform to the cloud at scale

Relational data processing over structured and unstructured data

Integrate with key data platform capabilities – e.g. Data Analytics, Reporting, ETL

  • “Essential storage service in the cloud”

  • Provides a core set of non-relational storage and retrieval abstractions at massive scale


Sql services futures extending the sql data platform to the cloud l.jpg
SQL Services FuturesExtending the SQL Data Platform to the cloud

  • Data services tier of the Azure Services Platform

  • Built on SQL Server foundation

  • Broad data platform capabilities as a service

    • Friction-free provisioning, scaling

    • Significant investments in scale, HA, lights-out operation and TCO

Database

Reporting

Data Sync

Data Mining

Reference Data

ETL


Trey research media marketplace l.jpg
Trey Research Media Marketplace

  • Normalized relational data and unstructured data

  • Complex relational queries across all data

  • Query/processing on rich data types; e.g., spatial

  • Business Data Analytics on/off premise

Photos

Media Buyer

Search

Customer Web App

Trey Research

Photos andMetadata

SearchAnalytics

Trey Exec

Photographer

Photo Management App

Corporate Management App

Photos

  • Multi-master datasynchronization

  • Occasionallyconnected clients

  • Scale-free

  • High availability

  • Geo distribution

  • Broad reach

  • Agile development

Mobile App

Photographer


Data model sql data services ado net data services l.jpg
Data Model SQL Data Services & ADO.Net Data Services


Authority container entities ace data model l.jpg
Authority-Container-Entities (ACE)Data Model

  • Authority

  • Authority

    • Unit of geo-location and billing

    • Collection of containers

  • Container

    • Unit of consistency/query

    • Collection of entities

    • No schema required

  • Entity

    • Property bag of name/value pairs

    • Unit of update/change

    • Flexible shape and types

  • Container

Entity


Data and operational model l.jpg
Data And Operational Model

Data Model

Operational Model

  • Current

  • Authority, Container, Entity (ACE) Model

  • Flex Entities

    • Flexibility for multi-tenant applications

    • Flexibility for applications where the content is being created by users

    • High performance scalability

  • Structure imposed by application

Current

  • Rapid provisioning of accounts, authorities and containers

  • Relational query capabilities

  • Accessible via internet-friendly protocols and formats

  • Future

  • More flexible organization of containers

  • Additional data types & shapes

    • Nesting, hierarchy

  • Schema support

    • Type checking, storage optimizations, inheritance, schema update

  • Relationships

    • links, integrity constraints

Future

  • Relational functionality

    • Joins, projection, aggregates

    • Sub-queries

  • Distributed query

  • Integration with Windows “Strata” service hosting

  • Claims based authentication and authorization

  • Geo-services

    • Distribution, hosting, redundancy


Ado net data services alignment l.jpg
ADO.Net Data Services Alignment

ADO.Net Data Services (Astoria)

Evolves to

include

flex entities

Client Support

SQL Data Service

Data Service Support

Evolves to

include

schematized data

Flex

Entities

Schematized

Data


Entity object mapping l.jpg
Entity/Object Mapping

Auto-generated code

[OpenType (“flexProps”)]

public classImageContent

{

string Kind { get; set; }

string Id { get; set; }

long Version { get; set; }

stringSubmittedBy { get; set; }

string Title { get; set; }

Dictionary<string, object> flexProps;

}

Metadata

SSDS

Img

Author

Content

  • Kind=ImageContent

  • Id

  • Version

    • SubmittedBy

    • SubmittedOn

    • Title

    • LocationId

    • Payload

    • Description

    • Latitude

    • Longitude

Astoria processes metadata and generates CSDL

CSDL


Querying strongly typed and flex properties l.jpg
QueryingStrongly Typed and Flex Properties

  • Querying for strongly typed properties

  • var results = fromicincontext.ImageContext

  • whereic.SubmittedBy == “David Robinson”

  • selectic;

  • foreach (var c in results)

  • Console.WriteLine(c.Title);

  • Querying for flex properties

  • var results =

  • fromicincontext.ImageContext

  • whereic.Field<string>(“Description”) == “bar”

  • selectic;

Future


Ado net data services l.jpg

demo

ADO.Net Data Services


Broad reach interoperability l.jpg
Broad ReachInteroperability

Standard, Internet-friendly protocols and message formats

ADO.Net

Data Services

Open Source Client Libraries

  • Broad reach across open-source client libraries

  • Aligned with native tooling support

  • Available on: http://github.com/sdsteam

  • Entity Data Model

  • Rich tooling support

  • Symmetry across on/off premise data

  • require 'net/http'

  • require 'rexml/document'

  • require 'yaml'

  • module SSDS

  • ssds_config = "#{RAILS_ROOT}/config/ssds.yml

    • request_xml = REXML::Document.new()

    • request_xml.add_element('s:Container')

    • request_xml.root().add_attribute('xmlns:s', 'http://schemas.microsoft.com/sitka/2008/03/')

    • request_xml.root().add_element("s:Id")

    • request_xml.root().elements["s:Id"].text = container

    • req = create_post(request_xml)

    • execute_requestreq

Create Container



Sync data hub access l.jpg

demo

Sync Data Hub & Access


Enterprise data hub sharing data through data sync l.jpg
Enterprise Data HubSharing data through Data Sync

  • Sharing data via the Internet

    • Across devices and across enterprises

  • Sharing data with offline capabilities (Sync)

  • Sharing data through a sync service

Data Sharing

Occasionally Connected

Sync

Service

iPhone



Data mining service sql server analysis server ssas l.jpg
Data Mining ServiceSQL Server Analysis Server (SSAS)

  • Extension of SSAS Table Analysis Tools

  • Leverage data from SSDS or load data from Excel

  • Benefits

    • Rich “attached service” for use in building sophisticated apps

    • Zero setup/admin

    • Friction free capacity (multiple users)

  • Thin Client

  • Pull data directly from SQL Server Data Services

  • Upload your CSV files

Excel add-in

Analyze your

spreadsheet data


Sql services data mining l.jpg

demo

SQL ServicesData Mining


Bi as a service biaas l.jpg
BI-as-a-Service (BIaaS)

  • Investments to enable you to leverage cloud data in existing data processes – e.g. Reporting and ETL

  • New services based on our market-leading BI platform – e.g. data mining service

SSIS source component for SSDS

Data Provider

SQL Server

Integration Server (SSIS)

SQL Server

Analysis Server (SSAS)

SQL Server

Report Server (SSRS)


Reporting against ssds data on premise l.jpg
Reporting Against SSDS DataOn-premise

Schematized data…

  • Leverage SSDS Data from within existing processes (reporting/ETL)

  • Reports across on/off premise data

    • Using existing tools & run-time

    • Flexible report builder

    • Rich visualizations

  • Challenge to map flex entities into tooling

    • Extract schema meta-data

    • Sample overall data set for flex properties

      SSIS will work in a similar way…

Cust01

Cust04

Cust02

Cust03

+ flex entities

flex


Sql services labs l.jpg

announcing

SQL Services Labs


Sql services labs24 l.jpg
SQL Services Labs

  • Now Available

    • http://www.microsoft.com/azure/sqllabs.mspx

  • 6 incubations available

  • Aligned with Live Labs, Office Labs, Dev Labs

  • Goals and Motivations

    • Highlight innovations

    • Early look at potential futures

    • Broad public feedback


  • Summary l.jpg
    Summary

    • SQL Data Services (SDS) has been architected for flexible use within your future software+service application architectures

    • SDS is being extended in many important directions, revealing the full power of SQL Server and the SQL Server data platform in the cloud

      • Relational capabilities

      • Data model

      • Alignment to ADO.NET Data Services conventions

      • Data Synchronization

      • SQL Server platform capabilities like BI

    • Broad, cross-platform interoperability

      Sign-up is available for PDC attendees - get started today!

      Broad availability w/ public CTP in mid-Nov!



    Evals recordings l.jpg
    Evals & Recordings

    Please fill out your evaluation for this session at:

    This session will be available as a recording at:

    www.microsoftpdc.com


    Please use the microphones provided l.jpg

    Q&A

    Please use the microphones provided


    Slide29 l.jpg

    © 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

    The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.


    ad