1 / 30

SQL Services Futures

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

adelle
Download Presentation

SQL Services Futures

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. BB14 SQL Services Futures  Patric McElroy Group Program Manager SQL Data Services

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

  3. Azure Services Platform Azure™ Services Platform

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

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

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

  7. Data Model SQL Data Services & ADO.Net Data Services

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

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

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

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

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

  13. demo ADO.Net Data Services

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

  15. Data Sync

  16. demo Sync Data Hub & Access

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

  18. Business Intelligence

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

  20. demo SQL ServicesData Mining

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

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

  23. announcing SQL Services Labs

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

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

  26. Related Sessions

  27. Evals & Recordings Please fill out your evaluation for this session at: This session will be available as a recording at: www.microsoftpdc.com

  28. Q&A Please use the microphones provided

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

More Related