资源描述：
《Consolidating Microsoft SQL Server Databases into an Oracle 11g Cluster_Dylan Ku》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、ConsolidatingMicrosoftSQLServerDatabasesintoanOracle11gClusterDylanKucera Director–DataArchitecture OntarioTeachers’PensionPlanOracleOpenWorld2010–S313546 SundaySeptember19,2010 3:00pm-4:00pmAgendaGainingbuy-inforaDWmigrationAdoptionofanewDWOracleMigrationWorkbenchViewsoverTransparentGa
2、tewayStoredProcedurestubsoverTGOracleStreamsGainingbuy-inforaDWmigrationPatienceisn’tjustavirtue,itisarequirementStartthinkingaboutmetricsbeforeanythingelseTieeverymessageabouttheDWtobusinessrequirementsGainingbuy-inforaDWmigrationScalabilityDon’tjustfocusonRACLockingModelWritersdonotbl
3、ockReadersNoLockEscalationWorkloadBalancingAvailabilityRACExtprocsandlinkstoforeignDB’srunoutofprocessFlashbackGainingbuy-inforaDWmigrationEnvironmentCapabilityPL/SQLcapabilitiesmaysimplifyyourdeployments(Languageconstructs,packages)AdvancedDWfeatureseg.MaterializedViewsMaintainabilityO
4、racleEnterpriseManagerLessreplication=lowersupportcostsFitwithstrategicdeploymentBest,ifyouareluckyenough!AnewDataWarehouse–Ifwebuildit,willtheycome?PromotionSkillsDevelopmentMentoringStandardsArchitecturalReviewsControlsOracleMigration(Workbench)OMWcanhelpfast-trackcodemigrationResultm
5、aynotconformtoyourstandardsCanbeusedfortablesaswell,butDoyouwanttoadjustmodel?WhataboutthelegacyDW?OMW–CapturingaSQLServermodelOMW–CapturedT-SQLProcedureOMW–ConvertedPL/SQLProcedureOMW–Butwhataboutthelegacy?Bigbang–notpossibleorriskyMigratingconsumerswilltaketimeTakeastagedapproachTrans
6、parentGatewayOracleStreamsViewsemployingTransparentGatewayCREATEORREPLACEVIEWPLAY.VALUE_TABLE_SAMPLEASSELECT"IDENTIFIER"ASID_,"VALUE"ASVALUE_,FILE_DATEASFILE_DATEFROMSampleLegacyTable@MSSQLPitfallsofTransparentGateway-ViewsDECLAREtDateDATE:='2008-12-31';BEGININSERTINTOPLAY.TEMP_SAMPLE_7
7、445(ID_,NAME_,PREV_VALUE,CURR_VALUE,VALUE_SUPPLIER,DATE_VALUE_CHANGED)SELECTID_,'','','','SAMPLE',MAX(FILE_DATE)FROMPLAY.VALUE_TABLE_SAMPLEWHEREFILE_DATE<=tDateGROUPBYID_;END;ResultsinORA-03113:end-of-fileoncommunicationchannelAlertlogsaysORA-07445:exceptionencountered:coredump
