MSSQL教程之计划数据堆栈的注重事项(Part I)
目前的方案是用mysqlbinlog工具，增加一个flashback参数，输出结果为一个新的binlog文件――姑且叫做flashbacklog，这个flashbacklog顺序执行，可制定某张表和执行到哪个pos，来实现数据库的闪回。计划|数据IntroductionIdentifyingandunderstandingthebusinessandoperationalrequirementsthatdriveanydatawarehousingprojectareessentialtotheprojectssuccessfulcompletion.Youcannotmeetyourclients?needsifyouhavenotassessedandanalyzedwhatthoseneedsareandhowyoucanaddressthem.
WhoKnows?
Themostimportantpartofthebusinessrequirementsprocessisfindingoutwhoknowswhattherequirementsshouldbe.Inmostcases,theanswerto"Whoknowswhatweneedtoknow?"isthatnobodyknowsitall,buteveryoneknowsapart.
AndWhatDoTheyKnow?
Theanswertothisquestionistheyknowfarmorethantheyimagine.Inmostcasesyoursourcesdonotknowtheyhavevaluableinformationandtowhatextenttheyaretheonlypossiblesourceforvitalinformationthatwillhelpinsuretheprojectssuccess.
TheBiologicalKnowledgeBase
Systemsaredesigned,created,maintainedandoperatedbypeoplewhohavefirsthandsysteminformation.Thisgroupofexpertsiscollectivelyidentifiedasthebiologicalknowledgebasethatyoumusttapeffectivelyinordertoextracttheinformationyourequire.
PlaybytheRules
Yourorganizationsbusinessrules(functionalrequirements)andoperationalcharacteristics(non-functionalrequirements)aretheessenceofthedesignrequirementsforyourproject.Theymustbecarefullycatalogedandanalyzedtoinsureinternalconsistency.Wheninconsistenciesarefound,youneedtoidentifythecauseoftheinconsistencies(youwillfindthatinsomecasestheinconsistenciesareperfectlyvalidandreasonable)anddeterminethepropermethod(s)foradjustingtheproject.
HowItHastoWorkandWhy
Foreachcomponentofyourproject,youwillneedtoidentifytheoperationalandbusinessrequirements.Forexample,therewillbetimeswhentheneedfor24X7availabilitywillsupercedetheneedfortotalaccuracy.Situationssuchasthismustbetakenintoconsiderationandincludedinyourdevelopmentplan.
Cultural/PoliticalConstraints
Culturalandpoliticalconstraintswillhaveaseriousimpactonyoursuccess,sotheymustbeaddressedwhilecollectingthebusinessrequirementsthatdefinetheproject.Eveninthosecaseswherethepoliticalenvironmentisopposedtotheneedsoftheprojectteam,youcanusepoliticalrelationshipstoincreasethevisibilityandacceptanceofyourproject,butonlyifyouhaveaclearunderstandingofthedynamicsinvolved.
Assessing/AddressingRisks
Everyprojectfacesrisks,someareminor,somesevere.Thesuccessfulprojectisbasedonidentifyingwhatthoserisksare,howlikelytheyaretooccur,howserioustheyareandwhatactionsarebesttopreventtheissuesfromarising.Identifythetacticstobeusedindealingwiththeissueswhentheydoarise,because,despiteyourbestefforts,somewillstilloccur.
MinetheBiologicalKnowledgeBase
Thebiologicalknowledgebaseisthecompletebodyofhumanknowledgeandintelligenceavailable.Thereadilyaccessiblebiologicalknowledgebaseprimarilyconsistsof:designersanddevelopers,knowledgeworkers,endusers,management,systemstaff,securitystaffandphysicalmaintenancestaff.
Everythingyoulearnfromthebiologicalknowledgebaseshouldbecomeapartofthebusinessrequirementsforyourprojectandbefullydocumentedtoserveasvaluablematerialforsubsequentprojects.
Designers/Developers
Designanddevelopmentstaffmembersarethosewhoareorhavebeenresponsibleforcreatingandmaintainingexistingsystemsandaretaskedwithintegratingfuturesystems.Youwillneedtogatherbusinessrequirementsandfunctionalconstraintinformationfromarchitects(business,dataandsystem),databaseadministrators,databaseanalystsandprogrammeranalysts.Eachwillhavetheirownperspectiveonyourprojectandontheinformationneededinordertomakeitsuccessful.
Effectivelyinterviewingthedesignersanddeveloperswillprovideyouwithbackgroundinformationthatwillgiveyourprojectaheadstarttowardasuccessfulcompletion.Theirknowledgewillprovideafoundationuponwhichtobuildthefinalbusinessrequirementsthatyourbusinesspartnersidentify.
Architects
Architectscreatethedesignsfortheenvironmentsinwhichapplicationsandsystemsfunction.Theyareseldomdirectlyinvolvedinbuildingtheapplications,systemsordatabases,butprovidetheblueprintsfromwhichsuchstructuresarecreated.
Architectscandetailinformationcontainedinthedesigndocumentationaswellastheenterprisestandards,logicallimitationsandbusinessfunctionality.Architectsalsobegingatheringthedatarequirementsfortheproject.
DBAs
Databaseadministratorsandanalystsareexpertswhenitcomestocreating,maintainingandoptimizingthedatastructurebehindinformationmanagementapplications.TheseDBAsareaninvaluableresource.
DBAscanprovideyourteamwithnearlyeverythingitneedstoknowaboutdatabasemanagementsystems,structure,security,resourcerequirements(hardware,softwareandpersonnel),enterprisestandards,physicallimitationsandhowothershaveintegratedbusinessrulesintotheirdatabaseimplementations.
ProgrammerAnalysts
Programmeranalystsaretheoneswhocreatethecodethatmakesapplicationswork.Theirjobistotakeaconceptandturnitintoafunctioningsystemthatprovidesthedesiredcapabilities.
Thesespecialistsshouldbeinterviewedwiththeintentionofderivinginformationonoperationlimitationsintheirapplications,structuralstandardsthatconstrainedthedesignanddevelopmentoftheapplications,howtheyenforcethebusinessrulesthatdefinedtheirprojectsandalistingofthedesignrequirementsfromwhichtheyworked.
KnowledgeWorkers(SubjectMatterExperts)
Knowledgeworkersarethosewhoworkwiththebaseinformationforyourproject.Theyconsistofbusinessanalysts,actuaries,accountantsandbusinessconsultants,aswellasmarketing,sales,clericalandproduction.
BusinessAnalysts
Businessanalystsareyourbestresourceforunderstandingthetruebusinessmeaningforaparticulardataelementorsetandforidentifyingthelogiconwhichtheapplicationisbased.
Theywillprovideyouwithinformationonwhichbusinessquestionsneedtobeansweredandwheretofindthedatathatwillhelptoanswerthem.Theywillalsoprovideyouwiththespecificationsonfunctionalreportingrequirements?theinformationtheyneedtohaveinordertodevelopthereportsuponwhichdecisionsarebased.
Actuaries
Actuariesarestatisticalanalysisspecialistswhodeterminethelikelihoodthatsomethingwillhappenaspecificnumberoftimeswithinanidentifiedgroupduringagiventimeperiod.Theycanalsobecalledriskanalystsbecausetheyjobidentifyrisksthebusinessfaces.
Theyprovideyourteamwithinformationonthedataelementstheyrequireinordertoperformthestatisticalanalysisuponwhichtheirpredictionsaredependent.Theycanalsoidentifymanyofthederivedanddependentmeasuresthatwillassisttheminpreparinganalysesasneedsanddemographicschange.
Accountants
Accountantsarethetruenumberscrunchersoftheorganization.Theyaretheoneswhodeterminetowhatextenttheorganizationisprofitable.Theymakesurethebooksbalance.Theytendtobedetailorientedtotheexclusionofnearlyeveryotherconsideration.
Youwillgetspecificinformationregardingthedatathatfeedstheprofit/lossanalysestheyuseinbuildingfinancialreportsandbudgetmanagementreports.Theywillalsoprovidedetailonthederivedandcalculatedmeasuresfromwhichtheybuildthesereports.
BusinessConsultants
Businessconsultants,whetherinternalorexternal,specializeinidentifyingwaystoimprovebusinessfunctionalityandpreparingplansforimplementingthenewprocesses.Inordertoaccomplishtheirtasks,theymustreceiveclearandreliableinformationregardingthecurrentandhistoricalviewsofthebusinessaswellasdevelopingtrends.
Theconsultantswillidentifythebusinessquestionstheyneedanswerstoinordertoidentifythecurrentstate,whichtheybasetheirtrendanalyseson.Inmanycases,themostimportantpiecesofinformationarederivedfromprofit/lossreports.
MarketingStaff
Themarketingteamisprimarilyinterestedinidentifyingpotentialcustomers,learningwhatproductsorservicestheywantanddetermininghowyourorganizationcanfillallorpartofthatneed.Inordertoperformtheirtasksmosteffectively,theyneedtohavesales,productionandcustomersupportdata.
Themarketingteamwillbeabletoprovideyouwithinformationonthefollowingtopics:clientsegmentation,testmarketingrequirements,marketingprogrameffectiveness,customerrelationshipmanagementandvaluechainmanagement.
SalesStaff
Thesalesstaffisresponsibleforactuallyturningamarketingplanintofinancialtransactions.Theyneedtojudgetheeffectivenessofsalesstrategiesandtacticsonanearreal-timebasisinordertoadjusttomarketconditions.
Yoursalesprofessionalswillidentifytheinformationtheyneedinordertosupportbothsalesandproductionreporting.Theywillneedthisinformationonaperiodicbasis(salesforaspecificdate,weekormonth)aswellasonaperiodtodatebasis(productionsofarthisyearormonth).Theywillalsoneedreportsdetailingprojectedproduction,inventorylevelsandsalesinqueue.
ClericalStaff
Theclericalstaffisprimarilyresponsibleforalldataentryoperations.Theyareusuallyhourlyemployeeswhodonothaveahighlydevelopedtechnicalskillset.Theyoftenoverlookedindeterminingthedesignrequirementsforabusinessintelligencedatastore.However,theycanbeafontofknowledgeregardingproductivityreportinganddataqualityissues.
Wheninterviewingtheseteammembers,focusonthedataissuesthateffecttheirproductivity.Theywillbeabletohelpyouidentifytheelementswhichareessentialtodevelopingacomprehensivedataqualityprogramaswellasstaffproductivityreporting.
ProductionStaff
Yourproductionstaffismostintimatelyinvolvedindeveloping,producinganddeliveringyourorganizations?productsandservices.Theinformationthatmostdirectlyaffectsproductionincludes:pendingorders,inventory(currentandprojected),changesinproductionrequirements(especiallyspecialmarketing)andpersonalproductivity.
Productionisanothergroupthatisfrequentlyunderutilizedindeterminingdatawarehouserequirements.Theycanprovidevitalinformationonthedataelementssuchasinventorycontrolandorderprocessingreportingsystems.Theywillalsobeyourbestresourcesforvalidatingthattheproductivityrequirementsyouhaveidentifiedareinfactthosethathavethehighestvaluefortheorganization.
Other
Dependinguponthestructureofyourorganizationandthebusinessyouarein,youmayhaveseveralothercategoriesofknowledgeworkersyouwillneedtointerview.Someexamplesinclude:legal,politicalactionteams,environmentalimpactspecialists,medicalpractitionersandproductdesignprofessionals.Ineachcase,takethetimetogettoknowthejobaswellasthepersondoingit,soyoucanunderstandthecontextinwhichtherequiredinformationisused.
操作被同步到从库上后，则主从都“回天无力”。 如果我们从集合论（关系代数）的角度来看，一张数据库的表就是一组数据元的关系，而每个SQL语句会改变一种或数种关系，从而产生出新的数据元的关系（即产生新的表）。 Mirror可以算是SQLServer的Dataguard了。但是能不能被大伙用起来就不知道了。 入门没那么困难，精通没那么容易 也可谈一下你是怎么优化存储过程的? 也可谈一下你是怎么优化存储过程的? 而写到本地,我又考虑到效率问题.大家来讨论讨论吧,分数不打紧,就给10分,十全十美,没啥对错,各抒己见,但是要有说服力的哦~ 然后最好有实践机会，能够把实践到的和实践结合起来，其实理论思考是个非常困扰和痛苦的事情
页:
[1]