making data work for everyonedownload.microsoft.com/download/c/6/0/c60e2bd0-8a7c-479f-851e... ·...
Post on 02-Nov-2019
3 Views
Preview:
TRANSCRIPT
Making Data Work
for Everyone
Jack Tang
WW Data Insights Business Lead
Microsoft Corporation
Big data
40ZBthe size of digital universe by 2020, of which 90% will be unstructured data
Devices
more than halfof information workers across 17 countries report using 3+ devices for work
Apps
one quarterof external app implementation spending will be on mobility, cloud, analytics & social, by 2016
Cloud
nearly halfof total IT spend will be cloud-related by 2020
Devices: “Info Workers Will Erase Boundary Between enterprise And Consumer Technologies.” Forrester Research. August 30, 2012
Apps: Gartner: “Predicts 2013: Business Impact of Technology Drives the Futures Application Services Market.” Nov. 21, 2012
Big data: Compiled from IDC digital universe forecasts
Cloud: “Prepare For 2020: Transform Your IT Infrastructure And Operations Practice.” Forrester Research. Oct. 24, 2012
Industry transformation
Microsoft transformation
Mobile (行動)-first Cloud-first
Data-driven
Microsoft transformation
Cloud-firstMobile-first
Cloud OS: Making data work for everyone
The evolution of the Microsoft data platform
12 months of data platform innovation
ANNOUNCINGSQL Server 2014
General availability
200,000 evaluations
100+ early adopters
Making data work for everyone
Breakthrough in-memory performance
Transformational hybrid cloud scenarios
Real-timeinsights onany data
Making data work for everyone
Breakthrough in-memory performance
Transformational hybrid cloud scenarios
Real-timeinsights onany data
Analysis Services
In-Memory
In-Memory
ColumnStore
PowerPivot
In-Memory for Excel
The Journey to Complete In-Memory (記憶體)
PowerPivot
In-Memory for Excel
20122008 R2
Enhanced In-Memory
ColumnStore
In-Memory OLTP (線上交易處理)
Analysis Services
In-Memory
PowerPivot
In-Memory for Excel
In-Memory in
the cloud
2014
11
Key trends impacting in-memory designCPU Performance Flattening OutDecreasing Cost of Memory
$/GB of Memory
1
10
100
1,000
10,000
100,000
1,000,000
1990
1991
1992
1993
1994
1994
1995
1996
1997
1998
1999
2000
2000
2001
2002
2004
2005
2007
2008
2009
2011
US$
/GB
0
1
10
100
1,000
10,000
100,000
1,000,000
10,000,000
1970 1975 1980 1985 1990 1995 2000 2005 2010
Drive real-time business
with real-time insights
Over 100x query (提取)speed and
significant data compression with
In-Memory ColumnStore
Up to 30x faster transaction
processing with In-Memory OLTP
Greater
performance
with In-Memory
Analysis Services
Billions of rows
per second with
PowerPivot
In-Memory for
Excel
Faster InsightsIN-MEMORY ANALYTICS
Faster QueriesIN-MEMORY DW (資料倉儲)
Faster TransactionsIN-MEMORY OLTP
On average 10x faster, without having rewrite entire app
Leverage full SQL Server capabilities
Select only highly-utilized tables to be in-memory
Optimize in-memory to fit existing hardware
In-memory performance across OLTP, DW & BI
All in a single SKU
Breakthrough in-memory performance (效能) SQL Server 2014
In-memory built into core engine
Uses industry-standard hardware
Best-of-breed in-memory by workload (工作負載)
Up to 30XOLTP performance gains
Up to 100XFaster star join queries
90%Disk space savings
In-memory built-in
固態式硬碟)
Business transformation with in-memory
Business Challenge
Key Benefits
DEMOSQL Server 2014 In Memory OLTP
Mark Chen
Data Platform Technology Solution Professional
Microsoft Taiwan
Beyond breakthrough in-memorySQL Server 2014
Efficient
Increased availability
Networking
Compute
Storage
Most widely-deployed database in the world
Least vulnerable database
Ecosystem of SQL Server Partners
8 Advantages (優勢) of SQL Server OLTP
Applications:Breakthrough
performance
without rewrites
Hardware:Use your industry-
standard HW
for in-memory
Utilization:Take full advantage
of your database
capabilities
Value:In-memory
at lower TCO
Workloads: Best in-memory
tech for each
workload
Time: Faster time
to value with easy
set up
Experience:Most widely-
deployed database
worldwide
As compared to SAP HANA (1-8) and Oracle TimesTen (3-5, 7) offerings
Performance:100X for DW
Up to 30X for OLTP
Making data work for everyone
Breakthrough in-memory performance
Transformational hybrid cloud scenarios
Real-timeinsights onany data
Find, combine, analyze any data
Visualize (視覺化) & get results with
familiar tools
Share insights in new ways
Scale & operationalize across organization
Real-time insights (見解) on any data
Excel as the BI tool for everyone
Built to scale for enterprise BI & DW
Power BI for collab & new experiences
Searchable catalog for public & corp data
Easy access to data, big and smallEmpower all users to find, combine, manage
Use your historical and
ongoing transactional
data to your
advantage
Data types:
Social sentiment
Audio
Video
Handwritten
TB Streaming
HDInsight, APS, HDP
Use your historical and
ongoing transactional
data to your advantage
Data types:
CEP
Weblogs
Sensor data
PB Unstructured
StreamInsight
Use your historical and
ongoing transactional
data to your
advantage
Data types:
ERP
CRM
GB Structured
Microsoft SQL Server
Unstructured
Streaming
Use your historical and
ongoing transactional
data to your
advantage
Data types:
ERP
CRM
GB Structured
Microsoft SQL Server
UnstructuredStructured
Streaming
Use your historical and
ongoing transactional
data to your
advantage
Data types:
Social sentiment
Audio
Video
Handwritten
TB Streaming
Use your historical and
ongoing transactional
data to your
advantage
Data types:
ERP
CRM
GB Structured
Microsoft SQL Server HDInsight, APS, HDP
Use your historical and
ongoing transactional
data to your
advantage
Data types:
ERP
CRM
UnstructuredStructured
Streaming
Use your historical and
ongoing transactional
data to your advantage
Data types:
CEP
Weblogs
Sensor data
GB Structured PB Unstructured
StreamInsightMicrosoft SQL Server
Use your historical and
ongoing transactional
data to your
advantage
Data types:
Social sentiment
Audio
Video
Handwritten
TB Streaming
HDInsight, APS, HDP
Drive business in
real time, from apps to
insights
Data types:
ERP/CRM
Payroll
Sales pipeline
Inventory
Monitor, manage, and
mine data for defects
and opportunities
Data types:
Financial trading
Web analytics
Operational analytics
Store, process, and
analyze any type or
size data
Data types:
Log files
Sensors, RFID, devices
Spatial and GPS
Weather
Structured (結構化) Streaming (串流)Unstructured (非結構化)
StreamInsight
Analytics Platform System,
HDInsightSQL Server
Analyze in Excel
Power BI for collaboration& new experiences
Excel as the BI tool for everyone
十億)
Scalable, Manageable, Trusted
DEMOPower BI for Office 365
Angi Wang
Data Platform Technology Solution Professional
Microsoft Taiwan
General availability
ANNOUNCINGMicrosoft Analytics Platform System
Relational (關係) or Non-relational, on premises & cloud
Integrated relational & non-relational query with T-SQL
Scale out relational data to multi-petabytes with APS
Scale out non-relational data with HDInsight
In-memory query performance (up to 100x)
Near real-time insights on streaming data
Built to scale on enterprise BI & DW platform
Any Data
All Volumes
Real-time
PolyBase
Hadoop distribution
StreamInsight
In-memory ColumnStore (欄位儲存)
Massively-parallel processing
architecture
DashboardsPerformance
management dashboards
& scorecards with
SharePoint
AnalysisSingle semantic model
& scalable analytics
engine with
Analysis Services
ReportingPixel perfect operational
& embedded
reporting with
Reporting Services
Manage data across the enterprise
Master DataAccurate & trustworthy
data with
Master Data Services
Data IntegrationIntegrated deployment
& management with
Integration Services
Data QualityData cleansing &
matching with
Data Quality Services
DEMOIn Memory ColumnStore
Mark Chen
Data Platform Technology Solution Professional
Microsoft Taiwan
Identify outbreaks in minutes
手寫輸入
4 Advantages of Microsoft BI
Speed:
Get employees
using BI quickly
with familiar tools
in Excel
Scale:
Deploy BI across
enterprise with
scalable, complete
solution
Access:
Discover & combine
both structured
& unstructured data
Savings:
Won’t cost
thousands per user
for specialized BI
tools
As compared to BI point-solution from Tableau Software
Making data work for everyone
Breakthrough in-memory performance
Transformational hybrid cloud scenarios
Real-timeinsights onany data
Insights on data where it lives
Flexible, scalable HA
Cost-effective, global DR
Fast time to market, elastic scale
Transformational hybrid cloud scenarios
Simplify backup (備份)& Disaster Recovery (DR - 災害復原)
Analytics for on-premises (本地的) data
Extend on-premises apps
Optimize applications
…from an enterprise-grade cloud
Data files in
Microsoft Azure
on premises Microsoft Azure storage
Cloud backup & Disaster Recovery
Backup to
Microsoft Azure
on premises Microsoft Azure storage
SQL Server 2005-2014
AlwaysOn
Secondaries
on premises Microsoft Azure virtual machine
Primary
Secondary
SQL database service is a
“game changer” Leads to greater revenue
Easy on-ramp to cloud
DEMOMicrosoft Hybrid Cloud SQL Scenarios
Mark Chen
Data Platform Technology Solution Professional
Microsoft Taiwan
Hybrid solution cuts data recovery time from minutes to seconds
Data-driven
Microsoft transformation
Cloud-firstMobile-first
The
Microsoft
Data
Platform
Complete and consistent data platform
Innovation at enterprise scale
* IDC Server Workloads Study 2013 ** IDC 2013 WW Server Tracker
93%of the Fortune 1000
use Active Directory
67%servers worldwide run
on Windows Server**
45%worldwide share:
SQL Server most
widely-deployed
database*
66%of enterprise seats
covered with System
Center
12B+weekly Microsoft
Azure AD
authentications
50%of Fortune 500 use
Microsoft Azure
280%year-over-year
database growth in
Microsoft Azure
29K+organizations
already use
Windows Intune
1B+Office users, 1 in 4
enterprise customers
now has Office 365
Microsoft Azure runs
on Windows Server 8.5T objects
stored in Microsoft Azure
Bing runs on Windows
Server 5.5B+ global
queries per month
Microsoft Azure
Making data work for everyone
Making data work for everyone…
…by unlocking insights on any data
top related