Transcript Abilities and Automation

DAT 100
Microsoft’s Data Platform
Vision
Agenda - What We Will Cover
History of Data Management
Microsoft SQL Server: Current and Upcoming
Offerings
Trends and Future Challenges in Data
Management
Microsoft’s Data Platform Vision and Future
Roadmap
PC and network proliferation
Explosion of digital data: documents, email, etc.
Local applications create data islands
PC server ecosystem comes of age
Storage capacity
beating Moore’s law
Disk storage now cheaper
than paper
Data must be consolidated to be managed
Processing primarily on the server
Cusp of structured vs. unstructured inflection
Scale & Availability
Complexity & TCO
Application backlogs
Real-time BI
• Relational
engine
• Client libraries
• Data Utilities
• Management
tools
Microsoft Data Management Capability
Innovation And Leadership
New RDBMS
architecture
Auto resource
management
World record
TPC-C
64-bit support
Database Mirroring
Online operations
Management
Studio
Deeper Windows
integration
Integrated XML
Integrated
Notification
Native XML
Multi-language
programmability
Service Broker
Integrated OLAP
and ETL
Integrated
Data Mining
Scalable Analysis
Reporting
Deep Data Mining
Enterprise ETL
Ad-hoc reporting
6M+ copies of CTPs downloaded
Launched at 307 events, 92 countries, 247 cities
2M+ copies of SQL Server Express downloaded
> 30% year-over-year growth in last 2 quarters
Database Mirroring
Management Studio Express
Data moving upstream:
transactional to pre-transactional
Huge data volumes from sensors
Less data being “managed”
New clients:
devices, phones, media PCs, …
New data types:
music, pictures, video, …
Connected
Single data source
Database driven
Hard coded
Monolithic & rigid
Occasionally connected
Multiple data sources
Information based
Model driven
SOA
Microsoft Data Vision
From Database To Complete Data Platform
Beyond Relational
Abilities and Automation
From “words and numbers”
to “sights and sounds”
From manual to self-tuning, self healing;
reliable, secure & compliant
Dynamic Applications
End-to-End Insight
From isolated and rigid to adaptive
and synchronized
From static and centralized to
real-time and personalized
Integration
Services
BPI &
Workflow
Documents
& Portal
Analysis
Services
Reporting
Services
Dynamic
Applications
FILE
RDBMS
OLAP
XML
Abilities And
Automation
Scale & Availability
Seamless scale-out
Always online
Insight & Automation
Health-model and policy based
monitoring & administration
Policy based and automated
application deployment & configuration
Security & Compliance
Rich, policy-based audit infrastructure
End-to-end encryption &
fine-grained security
Abilities and
Automation
Microsoft technologies
Certified partner offerings
Abilities And
Automation
AlwaysOn: Scale & Availability
Lowest TCO: Insight & Automation
Enterprise Abilities: Security & Compliance
Integrated Storage:
Platform For All Data
Documents go first class
Spatial goes mainstream
ADO.NET v3
Programming at conceptual entity level
Language Integrated Query (LINQ)
Abilities And
Automation
AlwaysOn: Scale & Availability
Lowest TCO: Insight & Automation
Enterprise Abilities: Security & Compliance
Integrated Storage: Platform For All Data
ADO.NET v3: Entity Data Services
Most Productive Development Platform
Best Visual Studio experience
Innovative data language experience
Occasionally Connected Systems
Integrated & seamless
synchronization infrastructure
Lightweight, compact, embeddable
Common management: SSMS
Common programming model: ADO.NET
Common replication / synchronization:
occasionally connected apps
Abilities And
Automation
AlwaysOn: Scale & Availability
Lowest TCO: Insight & Automation
Enterprise Abilities: Security & Compliance
Integrated Storage: Platform For All Data
ADO.NET v3: Entity Data Services
Most Productive Development Platform
SQL Server Everywhere:
Occasionally Connected Systems
Richer Information Experiences
Better business decisions through Microsoft Office
Navigation, personalization, annotation
Next Generation Data Warehousing
Abilities And
Automation
AlwaysOn: Scale & Availability
Lowest TCO: Insight & Automation
Enterprise Abilities: Security & Compliance
Integrated Storage: Platform For All Data
ADO.NET v3: Entity Data Services
Most Productive Development Platform
SQL Server Everywhere:
Occasionally Connected Systems
Richer Information Experiences
Next Generation Data Warehousing
Innovation, Value, Leadership
Through The First Data Explosion
Microsoft leadership: TCO, Development Productivity, BI
Entering The Second Data Explosion
The personal petabyte is coming
New devices, data types, architectures
Our Vision Meets Your Requirements
Abilities and Automation
Beyond Relational
Dynamic Applications
End-To-End Insight
Related Sessions
© 2006 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.
session evaluation
Appendix Information
User Capability
Development Capability
Development Tools, Enhanced productivity
Rich user experience, familiar tools
Suppliers
SOA & Process Capability
Business Process Automation, Integration
Customers
Data & BI Capability
Data Store, BI capability, DB Services
Infrastructure & Management Layer