MSSQL教程之计划数据堆栈的注重事项(Part I)

目前的方案是用mysqlbinlog工具，增加一个Flashback参数，输出结果为一个新的binlog文件――姑且叫做flashbacklog，这个flashbacklog顺序执行，可制定某张表和执行到哪个pos，来实现数据库的闪回。计划|数据Introduction
Identifyingandunderstandingthebusinessandoperationalrequirementsthatdriveanydatawarehousingprojectareessentialtotheprojectssuccessfulcompletion.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分,十全十美,没啥对错,各抒己见,但是要有说服力的哦~

然后最好有实践机会，能够把实践到的和实践结合起来，其实理论思考是个非常困扰和痛苦的事情