微软经典PPT模板4(图形篇续2)(内部资料).doc

ebhouse pptWAPTXT Upgrade Architecture SQL 2000 Available Downtime SQL 2005 Partial Available SQL 2005 Full Available SQL 2000 Uninstall SQL 2005 Multi User SQL 2000 Shutdown SQL 2005 Full Install Transfer Settings SQL 2005 Single User Core Upgrade Component Upgrade Lazy Upgrade FullFull-Text Installer Commit Point of no return Time How Unified Install Evolved SQL Server 2000 Media Unified on the Media SQL Server Analysis Services Reporting Services Unified Experience Unified with no restrictions DTS SQL Analysis Tools Just Make it Work Unified with restrictions SQL Notification Services DTS Tools SQL Server 2000 64-bit 64Technical Dependency Unified with restrictions Analysis Services SQL Server Notification Reporting Analysis Reporting SQL Server 2005 Beta2 SQL Server 2005 Beta1 Tools help migration VB6 Application Prepare for upgrade VB6 VB6 VB6 VB6 VB6 VB6 Code Advisor VB.NET Upgrade and fix issues Migration Wizard Enhance with new features Threat Trees Theft of Auth Cookies Obtain auth cookie to spoof identity OR AND Unencrypted Connection Cookies travel over unencrypted HTTP AND CrossCross-Site Scripting Attacker possesses means and knowledge Eavesdropping Attacker uses sniffer to monitor HTTP traffic XSS Vulnerability Application is vulnerable to XSS attacks Web Farm Deployment Data Sources Report Metadata And Cache Failover Cluster Report Server Web Farm IIS Report Server Oracle SQL Server 2000 Windows Server SQL Server Report Server SQL Server 2000 DB2 Windows Server IIS Flat Files, OLE DB, ODBC, .N ET Report Server Windows Server Windows Server Windows Server IIS Clients NLB SQL Server Comprehensive, Integrated Data Platform Reporting Services Data Platform Pillars: Enterprise Reporting Data Life Cycle Analysis Services OLAP & Data Mining Development Tools Birth to retirement Business Value throughout Management Tools Notification Services Notifications & Alerts All forms of data Relational SemiSemi-structured Replication Services Object Data Replication Programming against the Datamoving bits Transformation Services ETL Service Oriented Database Architecture SQL Server Engine Eliminating Relational Database Engine business latency Microsoft BI Architecture Office System Microsoft Business Solutions Financial Analytics BI Solution Accelerators Business Scorecards AddExcel Add-in for SQL Server ? ? ? ? Portals Dashboards Data Analysis Visualization SQL Server Relational Engine Developer Tools Messaging Services ? Project Management Reporting Services Analysis Services OLAP & Data Mining Windows Server Management Tools Windows Client Business Intelligence And Reporting User Profiles SQL Server Analysis Services 5-10% of users Analysts Information 15-25% of users Explorers SQL Server Reporting Services Information Consumers 65-80% of users OLAP Queries Atlanta Chicago Denver Dallas Q1 Q2 Q3 Time Dimension Sales Fact Grapes Cherries Melons Apples Q4 About Scorecards What is the strategy trying to achieve? How will the performance of the objectives be monitored? What performance level is required? What are the actions or programs to achieve the target? Objectives Increase customer confidence in our advice KPIs % of customers surveyed who rate us as their top source of advice Targets Initiatives Website Resource Center Consultative Selling Training Program 65% #1 90% #1 or #2 KPIs = Key Performance Indicators Quantifiable measurements that reflect the critical success factors of an organization Load Balancer Network Hardware Web servers Internet Information Server 6.0 ASP.NET 1.1 Business Logic Tier Data Access Tier Process Boundary Database server SQL Server 2000 Data Tier C Stored Procedures Windows And SFU Architecture UNIX Applications Windows Applications server X11 R6 Windows Applications Tcl/Tk, bash, etc. Open Source tools: Apache, Motif X11 U N I X S D K Windows Windows GUI SFU/Interix Windows system admin, commands and networking Windows command Shell UNIX, XPG, POSIX.2 commands and utilities UNIX shells telnetd (gcc) 3rd Party Color Legend UNIX /POSIX APIs BSD Sockets Windows APIs winsock Interix Subsystem Win32 Subsystem Windows Kernel Other device drivers CDFS FAT NTFS Client win32k.sys NFS Server Gateway Hardware Abstraction Layer UNIX And Windows Interoperability Evolved Hybrid App Integration Methods Direct invocation Pipes Sockets Shared memory COM Web service .NET App Windows App UNIX App .NET Framework Interix Subsystem Win32 Subsystem Windows Kernel Common Services Security File System Directory Reference Architecture What it looks like Write-Ahead Logging Data L Log 5 Rows Affected Server Log After the log entries are made and the locks are released Cache Sequential writes Change Change Change Change Transaction Recovery & Checkpoints Transactions 1 2 L D L/D L/D L Action Required if restart recovery None Roll forward Roll back 3 4 5 L Roll forward Roll back Checkpoint System Failure Time Report Execution And Delivery Execute on-demand or via schedule onQueries are executed and the result sets are merged with the report layout On-demand pull or server-based push delivery OnserverView reports from the included web-based front-end or subscribe to webfrontreports for delivery Authoring Management Execution & Delivery End Users Report Definition Managed Report Generated Report Delivery Targets Reporting Services Architecture Browser Microsoft Office Custom Applications Web UI Programmatic Interfaces Report Server Report Processing Report Sources Output Formats Data Processing Rendering Security Delivery Security Services Delivery Channels Report Server Database Reporting Server & Catalog Report Server ASP.NET Web Service (Report Processing): Services report requests ? Execute, process, render report ? Manage sessions NT Service (Scheduling / Delivery): Scheduled requests (subscriptions & snapshots) ? Delivery (e-mail / fileshare) Report Server Catalog ReportServer: ? ? ? ? Report definitions Data sources Users, policies and roles Report snapshots & history ReportServerTempDB: Session data ? Cached reports Deployment (Local Catalog) User SMTP IIS Report Manager Report Server MSSQL Visual Studio .NET Report Designer Report Author Client Report Server Catalog Deployment (Remote Catalog) User IIS Report Manager Report Server SMTP MSSQL Report Server Catalog Deployment (Clustered Web Farm) User Clustered Web Farm - Virtual Report Server MSRS IIS Report Manager Re