Design & Implementation Of Campaign Subsystem In The Securities System

The securities industryhas a rather high degree of usingcomputer. Thestorage and processing of stock information and user information, theprocessing of managers'operation, the analysis of stock trend, as well asuser's query and so on, all is using the computer to carry out the real-timeimplementation. Because the flow of capital related to the securities system,therefore the stability and security of the system is very important. Whendevelop the securities system we should make a full pre-design and compiledetailed design documents. We should be strictly to the code quality indevelopment process. After theyhave completed also need a detailed test toensurethatthesystemcanbecorrectwithoutanyerrorinthelong-termrun.Foreign securities industry's development has been very mature, andthe competition veryintense. How to provide more and better services, howtomakecustomersfeeltheactualbenefitthustobefaithfultotheenterprise,involvestoenterprise'sprofit,survivalanddevelopment,isquiteimportant.Take this as the goal and take the securities system the backing, theenterprise develops Campaign subsystem to complete the function ofreturning benefits to some customers. This system considered from theapplication that altogether divides into the Front Operation WindowSubsystem, the Middle Database Interface Subsystem and the BackgroundAuto Batch Run Subsystem. Three subsystems may carryon the design, thedevelopment and the test independently, thus to reduce developmentdifficulty, save development time, and enhance development efficiency andquality. The subsystems communicate with each other by the uplinktelegram text and the downlink telegram text to convey the necessaryinformation. Considering the consistent and stability, the system uses themiddleware TP1, which the enterprise already has, to deal with thetransmissionofthetelegramtextandchecktheformatofdata.The Front Operation Window Subsystem programs byJsp, divides intothe business planning information edit(input, update, confirm, cancelconfirm, delete, etc.) window, customer's information edit window, displaythe customers who win a prize window, appoint the type of merchandisewindow, show the business department information window and so on,operate by the different managers and complete the whole flow of thecampaign. This subsystem sends out the operation request(query, update,delete)totheMiddleDatabaseInterfaceSubsystemwiththeuplinktelegramtext and receive the return downlink telegram text data, then displays theresult(obtainfromthedownlinktelegramtextdata)real-time.The Middle Database Interface Subsystem programs by Pro*C, mainlyprovides services for the Front Operation Window Subsystem. In view ofeach function request of operating database, this subsystem divides into thebusiness planning information query, business planning information Exceloutput, business planning information edit, customer's information query,customer's information Excel output, customer's information insert,customer's information confirm and cancel confirm, customer's informationdelete, riffle information edit and so on of more than 10 code files.According to the operation request received in the uplink telegram text, thissubsystem uses the SQL sentences embedded in the code to complete thevarious operation, and then return the operation results using the way ofdownlinktelegramtext.The Back ground Auto Batch Run Subsystem programs by Pro*C and Cshell, divides into the customer's information edit, campaign, resultsconfirmed, calculate the sum and taxes, make out the gift coupon amounts,mailing data edit, receive the return data and so on many functions, runsregular and automatically. First, check the business planning information.Second, query and edit customers'information from the sales database.Third, random select some people in the customers who match the businessplanning's request and send off the gift coupon. A period of time later,receivethereturndataandupdatethedatabase.In the entire processing flow, the system depends on the systemrunning status code saves in the database to judge what operation should beexecuted. All of the system's run stages, including the planning informationoperating stage, the customer information operating stage, the campaignstageandthesendingstage,havemorethantenkindsofdifferentconditions.Afteranoperationcompletes,thesystemcanrewritetherunningstatuscodein accordance with the situation, thus enables the subsequent processing toruncorrectly.Because the data quantity of the customers and exchange is huge, andat the same time the security request is very high, there must be anoutstanding database system to take the strut. Take into account the maturetechnology and stability of Oracle, ultimately using Oracle as thebackgrounddatabase.In view of stability, this system runs on the UNIX system. Butconsidering the convenience of programming, the initial code completelyprogramsundertheWindowsenvironment,andcarryonthepreliminarytest.Make sure nothing error, and then pass on to UNIX for compiling anddebugging.Thinking that the system is very large, involves lots of data and has avery high request for stability, therefore the whole basic design, detaileddesign, coding and testing, as well as the project progress all needs tocompile detailed documents, which must submit to the specialist in thebeginning and finishing of every stage. After it is confirmed, we can carryonthenextstep.After finishing the system, we also make several updates so that everysystem could communicate and work together effectively. Now it has beenpracticallyapplied.