微軟經(jīng)典模板4(圖形篇續(xù)2)

UpgradeArchitectureSQL2000AvailableSQL2000ShutdownSQL2005FullInstallTransferSettingsDowntimeSQL2005SingleUserCoreUpgradeSQL2005MultiUserComponentUpgradeSQL2005PartialAvailable“LazyUpgrade〞Full-TextSQL2005FullAvailable“Pointofnoreturn〞InstallerCommitTimeSQL2000UninstallSQLServer2000SQLServer200064-bitSQLServer2005Beta1SQLServer2005Beta2ReportingServicesSQLServerAnalysisServicesAnalysisServicesSQLServerSQLDTSAnalysisNotificationReportingSQLReportingAnalysisHowUnifiedInstallEvolved“Media〞UnifiedontheMedia“TechnicalDependency〞Unifiedwithrestrictions“JustMakeitWork〞Unifiedwithrestrictions“UnifiedExperience“UnifiedwithnorestrictionsDTSNotificationServicesToolsToolsToolshelpmigrationVB6ApplicationVB6VB6VB.NETPrepareforupgradeVB6CodeAdvisorUpgradeandfixissuesMigrationWizardEnhancewithnewfeaturesVB6VB6VB6ReplaceADOwithADO.NETReplaceActiveXcontrolsReflectionWeb-enableMobilefrontendAddgraphicsThreatTreesTheftofAuthCookiesObtainauthcookietospoofidentityUnencryptedConnectionCookies

traveloverunencryptedHTTPEavesdroppingAttackerusessniffertomonitorHTTPtrafficCross-SiteScriptingAttackerpossessesmeansandknowledgeXSSVulnerabilityApplicationisvulnerabletoXSSattacksORANDANDWebFarmDeploymentDataSourcesFlatFiles,OLEDB,ODBC,.NETOracleSQLServerDB2ClientsReportServerWebFarmWindowsServerSQLServer2000ReportMetadataAndCacheFailoverClusterNLBReportServerWindowsServerIISWindowsServerSQLServer2000ReportServerWindowsServerIISReportServerWindowsServerIISSQLServer

Comprehensive,IntegratedDataPlatformDataPlatformPillars:DataLifeCycleBirthtoretirementBusinessValuethroughoutAllformsofdataRelationalSemi-structuredObjectProgrammingagainstthemovingbitsServiceOrientedDatabaseArchitectureEliminatingbusinesslatencyNotificationServicesNotifications&AlertsDataTransformationServicesETLSQLServerEngineRelationalDatabaseEngineReportingServicesEnterpriseReportingManagementToolsDevelopmentToolsReplicationServicesDataReplicationAnalysisServicesOLAP&DataMiningMicrosoftBIArchitectureManagementToolsDeveloperToolsPortalsDashboardsDataAnalysisVisualizationMessagingServicesProjectManagementWindowsServerWindowsClientMicrosoftBusinessSolutions

FinancialAnalyticsBusinessScorecardsExcelAdd-inforSQLServerBISolutionAcceleratorsSQLServerRelationalEngineReportingServicesAnalysisServicesOLAP&DataMiningOfficeSystemBusinessIntelligenceAndReportingUserProfilesAnalystsInformationConsumersInformationExplorers5-10%ofusers15-25%ofusers65-80%ofusersSQLServerReportingServicesSQLServerAnalysisServicesQ4Q1Q2Q3Time

DimensionProducts

DimensionDallasDenverChicagoRegion

DimensionApplesCherriesGrapesAtlantaSales

FactMelonsOLAPQueriesAboutScorecardsWhatisthestrategytryingtoachieve?Howwilltheperformanceoftheobjectivesbemonitored?Whatperformancelevelisrequired?Whataretheactionsorprogramstoachievethetarget?Increasecustomer

confidencein

ouradvice%ofcustomers

surveyedwhorate

usastheirtop

sourceofadvice

65%#1

90%#1or#2WebsiteResource

CenterConsultativeSelling

TrainingProgramObjectivesKPIsTargetsInitiativesKPIs=KeyPerformanceIndicatorsQuantifiablemeasurementsthatreflectthecriticalsuccessfactorsofanorganizationDataAccessTierBusinessLogicTierDataTier–StoredProceduresProcessBoundaryWebserversDatabaseserverInternetInformationServer6.0ASP.NET1.1SQLServer2000Web1SQLWeb2LoadBalancerNetworkHardwareSFU/InterixColorLegend3rdPartyWindowsApplicationsWindowsApplicationsX11R6serverUNIXApplicationsOpenSourcetools:Apache,Tcl/Tk,bash,etc.MotifWindowsAndSFUArchitectureWindowsKernelwin32k.sysHardwareAbstractionLayerFATNTFSOtherdevicedriversCDFSClientNFS

ServerGatewayWindowsAPIswinsockWin32SubsystemWindowssystemadmin,commandsandnetworkingWindowscommandShellWindowsGUIInterixSubsystemUNIX/POSIXAPIsBSDSocketsU

NIXSDK(gcc)UNIXshellstelnetdUNIX,XPG,POSIX.2commandsandutilitiesX11WindowsUNIXAndWindowsInteroperabilityWin32Subsystem.NETFrameworkFileSystemSecurityDirectoryCommonServices.NETAppUNIXAppWindowsAppWindowsKernelEvolvedHybridAppIntegrationMethodsDirectinvocation PipesSocketsSharedmemoryCOMWebserviceInterixSubsystemReferenceArchitectureWhatitlookslike

Write-AheadLoggingLDataLogServer…Cache~~~~~~~~~~~~~~~~~~~~~~~~~~~SequentialwritesChangeChangeChangeChange…Log5RowsAffectedAfterthelogentriesaremadeandthelocksarereleased…TransactionRecovery&Checkpoints

Transactions…ActionRequired

ifrestartrecoveryNoneCheckpointSystemFailure12345RollforwardRollbackRollforwardRollbackLDL/DL/DLLTimeReportExecution

AndDeliveryExecuteon-demandorviascheduleQueriesareexecutedandtheresultsetsaremergedwiththereportlayoutOn-demand“pull〞orserver-based“push〞deliveryViewreportsfromtheincludedweb-basedfront-endorsubscribetoreportsfordeliveryReportDefinitionManaged

ReportGeneratedReportDeliveryTargetsEndUsersAuthoringManagementExecution&DeliveryReportSourcesDeliveryChannelsSecurityServicesOutputFormatsReportingServicesArchitectureReportServerDataProcessingRenderingSecurityDeliveryReportProcessingProgrammaticInterfacesWebUIMicrosoftOfficeCustomApplicationsReportServerDatabaseBrowserReportingServer&CatalogReportServerNTService(Scheduling/Delivery):Scheduledrequests(subscriptions&snapshots)Delivery(e-mail/fileshare)ASP.NETWebService(ReportProcessing):ServicesreportrequestsExecute,process,renderreportManagesessionsReportServerCatalogReportdefinitionsDatasourcesUsers,policiesandrolesReportsnapshots&history…ReportServerTempDB:ReportServer:SessiondataCachedreportsClientReportAuthorUserIISReportManagerReportServerDeployment(LocalCatalog)SMTPReportDesignerVisualStudio.NETReportServerCatalogMSSQLUserDeployment(RemoteCatalog)ReportServerCatalogSMTPIISReportManagerReportServerMSSQLUserDeployment(ClusteredWebFarm)ClusteredWebFarm-VirtualReportServerMSRSSMTPIISReportManagerRe