Maintenance and SupportUser TrainingTraining MethodologiesTraining the end-usersSupporting the End-userMaintenance PhaseMaintenance Life Cycle Design ConceptMaintenance StepsMaintenance Phase/TestingSlide 10Other things to considerReview of Oracle DesignerOracle DesignerSlide 14The Last ExamWhat I changed from last semester:So – did we have fun or what?!Maintenance and SupportWeek 15CMIS570User TrainingUser TrainingNeed to consider the same 2 groups:End usersUse the system to achieve the business purposeCreating, modifying, deleting recordsGenerating reportsQuerying the dataSystem operatorsPerform administrative functions and routine maintenance to keep the system operatingStarting and stopping the systemRunning backup and recoveryTraining MethodologiesDetermine best training method given end-users and system:Instructor LedOne-on-OneUser-LedExternal sourcesTraining the end-usersWhat do users want?Training early onTraining manualStraightforward teaching techniques1. How to get started2. Where to turn for help3. Who to see when they want to learn more about the features and functionalitySupporting the End-userInformation Center / Help deskAutomating supportResident expertOther things to consider:Providing recovery and backupDisaster recoveryPC maintenanceMaintenance PhaseMaintenance:Changes made to a system to fix or enhance its functionalityWhy is this needed?CorrectivePerfectiveAdaptivePreventiveMaintenance Life Cycle Design Concept PlanAnalysisDesignImplementMaintainMaintenance StepsObtain maintenance requestsSSR, SMR, CRControlling maintenance requests How is decision made on which maintenance requests to work on?Planning stepsSecure resourcesTransform requests into formal changesDevelop test criteria and a test planMaintenance Phase/TestingStart with “production copy” of modules to be changedCheck out production version of source codeUnit testingREGRESSION testingTo ensure changes have not created new problems in the systemAccomplished by running a subset of previously executed integration and system testsSmart IS shops keep a regression “test bucket” of selected test cases to run on a system when changes are made to any module in that systemMaintenance StepsImplement changesMonitor changesUpdate documentationOther things to considerCost of maintenanceCASE tools to aid in maintenanceCost factorsWho does maintenance in an organizationReview of Oracle Designer ANALYSIS•Process Models•ERD•FHDTransformers•Database•ApplicationDESIGN•Design EditorGenerators•Database•Table API•Forms•ReportsOracle DesignerOracle Designer end result:Actual application databaseWorking prototypes of screens and reportsAnalysis and design documentationERDs, process models, etc.PROCESSMODELE-RDIAGRAMFHDEntity UsagesADTDDTDBDESIGNCANDIDATEAPPLSColumn Display PropertiesDB andTable APIOracle DatabaseGenerateDBGenerateApplsREPORTFORMDesign EditorORACLE DESIGNERORACLE DESIGNERThe Last ExamNot ComprehensiveSimilar in format to 1st exam – but will try to make it shorterWhat I changed from last semester:Modified the examsChanged the point allocation for the homeworks.Consider major research paper rather than Oracle.So – did we have fun or what?!Your reactions, feedback, suggestions for improvement are always welcome…SDLC, Project, Oracle Designer stuff, other aspects of the