SQL Server 2000 Notification Services박명은 Senior Technology Specialist mepark@microsoft.com Microsoft Corporation
SQL Server 2000 Notification Services
박명은 Senior Technology Specialist mepark@microsoft.com Microsoft Corporation
Agenda
Notification Application이란 ?
SQL Server Notification Services Architecture
Application Building
Security and Deployment
Demo
사례
Getting Information Today
Web Sites Newsgroups
LOB Applications
Information
Sources You Browse
Request
A New Model
Web Sites Newsgroups
LOB Applications
Information
Sources You Information
Push
Notification Applications
Web Sites Newsgroups
LOB Applications
Information
Sources You Information
Push Notification Application Personalized
Timely
Any Device
Notification Applications
A new class of web application that delivers personalized and timely information to any device. Personal Any device Timely Internet scale applications Intranet applications
Notification Applications Value in Push Applications
Line of Business:
Package delivery alerts
소포가 도착했을때 E-mail로 알려줄것을 요청함
History관리와 함께 연기됐다면 Alert를 보낼것을 요청 Business To Employee:
Library news subscriptions
데이터베이스에 대한 특정문서에대한 관심
Hi Tech경쟁사 정보에 대한 관심
매일 오후 5시에 이러한 정보를 e-mail로 보낼것을 요청
Business To Consumer :
Stock market alerts
MSFT가 80을 지났을때 Alert을 요청
핸드폰으로 알림을 받을것을 지정
Allow me to browse back and sell my MSFT stock
하루에 한번만 Alert를 보냄
매일 보유하고 있는 주식포트폴리오에 대한 주식시세를 일정 시간에 알려줌 LOB: immediate information flow B2E: targeted information flow B2C:
Looking out for the customer
Browse back drives site traffic Vision: every web service/site will have a push component
Events (thousands) Notifications (millions) Match Subscriptions (millions) Activity Notification Applications How does notification application work ?
SQL Server Notification Services
A platform for developing and deploying highly scalable rich push applications
A rich yet simple declarative model (based on XML, SQL, CLR) used to describe pub-sub applications
알림 응용프로그램을 실행하기 위해 안정적이고 확장 가능한 고성능 서버(.NET Framework과 SQL Server 2000) 기반제공
간단한 어플리케이션 코드 작성으로 구현가능 - Notification Server hosts it
Agenda
Notification Application이란 ?
SQL Server Notification Services Architecture
Application Building
Security and Deployment
사례
Architecture
Events Notification Generator
Notifications Subscription ASP.Net application Subscriptions Subscriber Content Formatting & Distribution
Event Provider
SMS E-mail Microsoft Alerts Outside activity Subscriber Devices
Architecture
Subscription Management Application Subscriptions Subscribers Custom Event Collector Event Provider Host File System SQL Server Notification Generator
SQL Match
Rules Custom
Formatter Distributor .NET Alerts Email File Custom Events Notifications Event Batches Notification Batches Subscriber Devices App. specific Standard XSLT
Formatter
Activity Generation Delivery Receipt SQL Server on Windows,
Oracle on Solaris,
DB2 on S/390.
Custom Data Store. SQL Server 2000 Notification Services Exchange Server,
WinRTC,
SMS Aggregator,
Custom Mechanism. Outlook,
XP Messenger,
Pocket PC,
SmartPhone 2002,
SMS capable phone,
Custom Mechanism. Information flow Notification Services Generation vs. Delivery
Activity Generation Delivery Receipt SQL Server on Windows,
Oracle on Solaris,
DB2 on S/390.
Custom Data Store. SQL Server 2000 Notification Services Exchange Server,
WinRTC,
SMS Aggregator,
Custom Mechanism. Outlook,
XP Messenger,
Pocket PC,
SmartPhone 2002,
SMS capable phone,
Custom Mechanism. Information flow Notification Services Generation vs. Delivery
Agenda
Notification Application이란 ?
SQL Server Notification Services Architecture
Application Building
Security and Deployment
사례
Programming Elements
Core Notification Application Custom Components (Event Provider / Formatter / Protocol) Subscriber/Subscription Application XML ADF NS Compiler SQL
DB Tables, Views, SPs HTML
C#, VB ASP.NET Code Managed Compiler ASP.NET on IIS C#
VB
C++ Managed Code Managed Compiler Managed Assembly DLL
Event Providers에 의해 수집되어 지는 데이터가 이벤트임
어플리케이션은 하나이상의 Provider를 사용할수 있도록 구성가능
standard providers을 제공함
사용자 지정 이벤트 공급자 사용가능
이벤트를 전송할때 다음의 API사용가능 : Managed API, COM API, XML API, SQL API
Event Provider는 데이터를 여러 개의 일괄처리로 나눠 이벤트 테이블에 기록함
Event Object Submissions
Events events Write
Write
Write
Commit Provider Host Event
Collector Provider Event IBM 102 ½
MSFT 65 ¼
ORCL 13 ½
CSCO 19 ½
AAPL 20 ¼
10 1/2 SUNW 102 1/2 IBM 65 1/4 MSFT A Provider
May be hosted by the Notification Server Provider Host
외부소스로 부터 이벤트 데이터를 가져옴
이벤트 데이터와 함께 이벤트 오브젝트를 Create하고 Populate함
각각의 이벤트에서 Event Collector “Write”을 콜함
일괄작업을 처리하기 위해 Event Collector “Commit”을 콜함
EventLoader Object Submissions
Events events LoadXML Provider Host XML
Event Provider A Provider
May be hosted by the Notification Server Provider Host
외부소스로 부터 이벤트 데이터를 가져옴
Creates an EventLoader object; optionally initialized with SQL annotated XML event schema
Called with an XML document or stream
Batch size == the number of events within the document or stream
Comments