Application Service Platform Data Service Platform Integrated Store
CloudDB Distributed In-Memory Cache Velocity Queues Data Delivery
Identity User Management Reporting Service RS Business Intelligence
BI Storage Service Stratus Data Archiving Backup Data Warehouse
Manageability (Autopilot) External CloudDB DSP Unified Programming
Model Workflow Distributed Job Framework Distributed Query Resource
Allocation and Governance Virtualization Synch Services (Harmonica)
Data Fidelity And Cleansing Data Center Services (GFS) Billing
Networking Facilities Support Throttling and Metering
13. SQL Server Data Services :
Zurich , on-premise
CloudDB SQL Server
Dynamically add / remove partition ranges
Load balance partition ranges
Windows Live
Sitka , Stratus
Exchange Hosted Archive (EHS-A) 400
SharePoint , Data Protection Manager , BizTalk , ...
16. CloudDB Table Group Customers Row Group Orders Partition
Partitioning Key Column (OrderId)
Table : logical relation
Has a partitioning key : controls partitioning across
servers
Has a clustering key : controls ordering of rows within a
server
Table group : a set of tables with the same partitioning
key
Row group : set of rows in table group with same partitioning
key value
Always on exactly one server
But may not be clustered
., Customer->Orders->LineItems Customer ID
Each table group distributed across nodes
Each storage node assigned ranges partitions of key values
Each partition is replicated for durability
Id Name 34 John 57 92 Id Oid S 34 1 34 2 92 1
17. CloudDB Mgmt. Services Data Node SQL Server Fabric Data
Node Components Partition Manager Master Node Mgmt. Services Data
Node SQL Server Fabric Mgmt. Services Data Node SQL Server Fabric
Mgmt. Services Data Node SQL Server Fabric Deployment Health
Monitoring AutoPilot Service Management Self-Healing Master Cluster
Data Cluster Service Boundary Mid-Tier Node Integrated Client
Library Application Mid-Tier Fabric Replication Fetch Partition Map
SQL Client Mgmt. Services Data Node SQL Server Fabric Distributed
Job Framework Distributed Data Services Fabric Distributed Query
Reporting Services Caching GMV Data Node Components Partition
Manager Master Node
18.
Master Cluster Manager
( )
()
Distributed fabric
ADO.Net
Webstore 5.5 Blue
Autopilot
, ,
Distributed Job Framework
( )
19. CloudDB Client Library (ADO.Net) SQL Process Fabric Process
SQL Process Fabric Process SQL Process Fabric Process SQL Process
Fabric Process CloudDB Master Node SQL Process Fabric Process
CloudDB Master Node SQL Process Fabric Process Distributed Fabric
Physical Disks CloudDB Data Cluster CloudDB Master Cluster Manager
AP WD AP WD AP WD AP WD AP WD AP WD CloudDB Data Node CloudDB Data
Node CloudDB Data Node CloudDB Data Node SQL Replication Fabric
Messages SQLClient
20. SQL Server P S S S Replication Agent Local Partition Map
Data Node 100 Data Node 101 P S S S Data Node 102 P S S Data Node
103 P S S S Data Node 104 P S S S Data Node 105 P S S S Master Node
(Primary Master) Primary Secondary Secondary Fabric Ring Topology
Failure Detector Name Resolution Reconfiguration Agent Replica
State Monitor Fabric Hosting Fabric Fabric Hosting Leader Elector
Partition Manager Global Replica State Monitor Placement Advisor
Load Balancer SQL Server Global Partition Map Fabric
21. Data Node Device Manager Provisioning Deployment AutoPilot
Service Manager Watchdogs Management Services Deployment Services
Health Monitoring Perf Collection Backup Self Healing Perf
Collection Cluster Perf DB (CloudDB TableGroup) Reporting Off-site
Backup Trace Collection Trace DB (CloudDB TableGroup) CloudDB
Deployment Self Healing Application Deployment AutoPilot
28. SSDS CloudDB Data Cluster Fabric Replication SQL Client
TECHNOLOGY STACK DATA MODEL Sitka midtier Storage Tier SOAP or REST
Sitka Biz Logic Layer Mgmt. Services SQL Server Fabric Data Node
Data Node Mgmt. Services Data Node SQL Server Fabric Mgmt. Services
Data Node SQL Server Fabric Mgmt. Services Data Node SQL Server
Fabric Mgmt. Services Data Node SQL Server Fabric Mgmt. Services
Data Node SQL Server Fabric Client Application [CloudDB ADO.Net
client] REST SOAP Sitka Runtime
29. API
REST, SOAP
# LINQ
from e in container where e.Kind == Expo:FunCar && e[
Zip ] == 98053 && e[ Model ] == Mini Cooper select e