The New Workplace: Person-Centric, Not...

商業智慧於企業管理之新思維與新應用與

SQL Server 2014 技術應用

Derek

Agenda

公司介紹

SQL Server 2014技術特色應用

技術挑戰與解決方案

案例分享

Effective Management

Business Management Analytics & Intelligence

Enterprise

(B2B)

InfoPower Positioning

Consumer/Retailer

(B2B2C)

Enterprise

(B2B)

Consumer

Behavior

Study & Analytics

Results

Core

Value

Target

Market

InfoPower

Competency

Effective

Marketing

InfoPower Analytics Platform, Technologies,

and Consulting Knowhow

Effective

Management

Business Management

Analytics &

Intelligence

Copyright © 2013

核心價值: 創造高價值資訊 – 管理、分析、決策

U-Centric UI

Innovative Solutions

Hi ! Methodology

Information Buffet

創新觀念

前瞻技術

迅捷實施

創新應用

全方位 (From-end-to-end)

創新 + 速度個人化 + 即時性

22項軟體發明專利

Challenge: To be a Real-time Analytics Enterprise

The Im

pact

of D

ecis

ion M

akin

g

High The Executives & Middle Managers’

Needs and wants of Information:

Personalized Information

Real-Time or Right-Time Information

Directly from an application instead of

spreadsheet or exported from database.

Information security & transparency

Operational

Planning

Tactical

Planning

Strategic

Planning

Transaction

Processing

Real-Time

Operations

Minimize Latency & Increase Profits

How much is your impact to business in an hour ? ...... a month?

Business idea / event

Action taken Decision

Latency

Analysis

Latency

Data

Latency

Busines

s

Value

Value

Lost

Action Time Time

Information delivered

Data ready for

analysis

InfoPower 5Vs on Big Data

Source: InfoPower

Visualization

Value

The 3 Vs

Of

Big Data

Volume

Velocity Variety

Structured

Information

Unstructured

Information

Big Data ≠ Big Value

Current Limited Analytics Value

Potential Huge Analytics Value

Analytics

+ Visualization

+ Big Data Management

= Big Value

SQL Server 2014 特色應用

支援關鍵性任務高可用性

安全及擴充性內建記憶體內資料庫

內建記憶體內

資料庫 In-Memory Built in(1/5)

Source : Microsoft

內建記憶體內


Faster Transactions - IN-MEMORY OLTP

Up to 30x faster transaction processing with In-

Memory OLTP

Faster Queries - N-MEMORY DW

Over 100x query (提取)speed and significant data

compression with In-Memory ColumnStore

內建記憶體內



提高轉置工作的速度，縮短資料寫入的時間

ex. 一個感應器同時感應200個裝置，1秒鐘即200筆資料…etc.

0 1000 2000 3000 4000 5000 6000 7000

Delay(ms)

Delay(ms)

內建記憶體內



提高轉置工作的速度，縮短資料寫入的時間

ex. 因分析需求要做預處理，原先需要90分鐘，現才只需30分鐘。

資料剖析資料匯入資料匯出

ADB OLTP

內建記憶體內


Faster Queries - IN-MEMORY DW

縮短資料查詢的等待時間，提升用戶體驗感受

端對端完整功能 (Full Spectrum)

QuickCORE 架構說明

分析型

資料庫系統資料庫快取系統資料庫

Cubeless多維度分析模組

應用開發工具排程監控模組安全控管系統基礎元件

多維度分析查詢異常警示指標商業圖形模組

入口網站模組資料匯出模組

前端應用層

系統核心層

整合介面層

中介資料層

資料來源層

資料轉置服務模組

SQL Server

2000

SQL Server

2005

SQL Server

2008

SQL Server

2014

SQL Server

2012

資料轉置服務模組

Next Generation Information Deliverables Design & Development

SQL Server

2000

SQL Server

2005

SQL Server

2008 SQL Server

2012

SQL Server

2014

應用Demo

一般表格 HTML5圖形樞紐報表

商業智慧於企業管理之新思維與新應用

InfoPower

The New Workplace: Person-Centric, Not...

Documents

Transcript of The New Workplace: Person-Centric, Not...