1 / 26

Welcome!

Welcome!. Pieces of the Application. Front End. Accepts user input Validates user input Required Date fields and numeric fields in proper places. Auto capitalizes where necessary Reporting Displays data returned from AppServer Sends in reporting requests Communicates with Appserver

conway
Download Presentation

Welcome!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome!

  2. Pieces of the Application

  3. Front End • Accepts user input • Validates user input • Required Date fields and numeric fields in proper places. • Auto capitalizes where necessary • Reporting • Displays data returned from AppServer • Sends in reporting requests • Communicates with Appserver • All transactional requests, searches, etc are sent to AppServer from front end. • All results (reports, list screens, acknowledgements of saved transactions are sent back to front end.

  4. Database • MS SQL Server or Interbase • Collects and stores information sent from AppServer • Send back data requested by AppServer • Lists screen searches • Reports • Detail views (Style Detail, Customer Detail, etc) • Executes functionality on data • Deducting inventory when saving a sale • Increasing inventory when receiving from a PO

  5. Anatomy of a Database • Tables • Contains the actual data (Customers, Inventory, etc) • Tables are made up of Rows (Records) and Columns (fields) • Triggers • Tiny programs that executes upon an event, typically upon • the saving of a certain record. • Stored Procedures • Small to mid sized programs that execute when requested. • Examples would be preprocessing for a report. • Database Process • Program that loads when system boots up. • Controls all database requests that comes in and helps execute them in an efficient manner.

  6. Tables are like excel spreadsheets Fields are the columns Records are the rows. Database Tables

  7. Database Tables Example Table 1 – TB_CUSTOMERS

  8. Database Tables Example Table 1 – TB_STYLES

  9. Database Triggers • Sample Triggers • Upon insert of line item on receipt, inventory is deducted • Upon insert of receiving, inventory is incremented, on order reduced • Upon insert of purchase order, quantity on order is incremented • Upon update of receiving, payable amount is modified. • Benefits • Single DB process keeps updates from over writing. • Speed benefit by executing in database vs. application

  10. Database Stored Procedures • Sample Stored Procedures • Upon update of receiving, payable amount is modified. • Comparison of a physical inventory. • Resolve of a physical inventory • Style audit screen • Benefits • Significant speed benefit by executing in database vs application

  11. Database Process Process Runs on Computer like any other service or program Receives all requests from network and enterprise Organizes these requests to balance most efficient usage of machine and response time Keeps many generations of database in the event of unintended shutdown Performs maintenance on databases

  12. AppServer Middleware – Communicates between DB and Front ends Performs business logic Translates information from front end and inserts into database Retrieves information from database and prepares in a format ready for front end Controls most communications Controls store level redundancy

  13. Basic Transaction User presses a Save button Front End pull data from screen and sends to AppServer AppServer determines the transaction intended (new receipt, update inventory, etc) and prepares data to be saved in the database AppServer writes all records to the database within a transaction AppServer sends acknowledgement back to the front end Front end displays window showing results or simply closes the current window

  14. Sample Transaction 1 User Presses Finish on Pay Screen Front end compiles data from screen and sends to AppServer Receipt.Insert?543~^0~^0~^TBRECEIPT~^70~^1~^RECEIPT_NUM~^EMPLOYEE_ID~^CUSTOMER_ID~^STORE_ID~^MACHINE_ID~^DATE_TIME~^GIFT_AMOUNT~^SUBTOTAL~^LINE_DISC_AMOUNT~^OTHER_DISC_AMOUNT~^SHIPPING_CHARGE~^ALTERATION_CHARGE~^AFTER_DISC_AMNT~^TAX1~^TAX2~^TOTAL~^PAID~^TOTAL_CREDITS~^TOTAL_DUE~^PICKUP_DATE~^COMMENTS~^CREDIT_AMOUNT~^READY_TO_PICKUP~^DATE_CLOSED~^PENALTY~^SHIP_MODE~^LAST_INSTALL~^ZIP~^EMAIL~^PARENT_ID~^TOTAL_WEIGHT~^WEB_STATUS~^WEB_NUM~^LAST_SAVE_BY~^TYP~^AVAILABLE~^GIFT_FOR_NUM~^CLOSED~^VOID_BY~^CREDIT_ISSUED~^FREE_DOLLARS_USED~^BUYCLUB_DOLLARS~^CATEGORY1~^CATEGORY2~^CATEGORY3~^DISC_REASON~^OUR_NUM~^PER_OFF~^UNITS_SHIPPED~^FREE_ITEMS_USED~^BUYCLUB_ITEMS~^OLD_ID~^HAS_CUSTOM_WORK~^CURRENT_STATE_ID~^BIN_NUM~^ORIG_RECEIPT_NUM~^VAT_AMT~^VAT_SERIAL_NUM~^VAT_REFUND_AMT~^VAT_REFUND_CHARGE~^CUSTOM_COMMENT_1~^CUSTOM_COMMENT_2~^CUSTOM_COMMENT_3~^CUSTOM_COMMENT_4~^EVENT_ID~^ORDER_TYP_ID~^IS_MULTI_SHIP~^CHARGE_UPS_ACCOUNT~_TAX_REFUND_ID~_TAX_EXEMPT_REASON~_~^305~^73673~^185~^1851~^"03/21/2007 13:23:48"~^0.00~^620.00~^930.00~^0.00~^0.0~^0.0~^670.38~^50.38~^0.00~^670.38~^670.38~^0.00~^0.00~^~^""~^0.00~^~^"03/21/2007 13:23:48"~^0.00~^0~^~^""~^""~^~^0.00~^""~^~^0~^0~^0.00~^~^"Y"~^~^0.00~^0.0~^0.0~^""~^""~^""~^""~^""~^0.00~^0.0~^0~^0.0~^~^""~^~^""~^~^0.0~^""~^0.0~^0.0~^""~^""~^""~^""~^~^~^~^~_~_""~*TBRECEIPTLINE~^40~^1~^RECEIPTLINE_ID~^EMPLOYEE_ID~^RECEIPT_NUM~^PRICE~^LOOKUP~^EXTENDED~^ORIG_PRICE~^REG_MARKDOWN~^BO_MARKDOWN~^COST~^NOTES~^SPIFF~^COMMISSION~^COMM_DTE~^AMOUNT_OFF~^MEMBER~^RETURN_REASON~^OFF_FROM~^WEB_FLAG~^UPDATE_DTE~^SKU_BUCKET_ID~^MKDN_REASON~^ORIG_RECEIPTLINE_ID~^REGISTRY_ENTRY_ID~^QUANTITY~^SHIPPED~^SERIAL_NUM~^OLD_ID~^LINK_LINE_ID~^PICKED~^SHIP_TAX_ENTRY_ID~^TAX_CODE_ID~^TAX1_AMOUNT~^TAX2_AMOUNT~^KIT_ITEM~^VAT_AMT~^SHIP_CUST_ID~^SALE_TYP~_TAX1_PER~_TAX2_PER~_-1~^305~^~^620.00~^"10923484960"~^620.00~^1550.00~^930.00~^0.00~^313.20~^""~^0.0~^0.0~^~^0.00~^""~^""~^0~^0~^~^49272~^"SALE"~^~^~^1.0~^0.0~^""~^~^~^0.00~^~^~^50.38~^0.0~^~^0.0~^~^0~_8.125~_0.0~*TBTENDERED~^14~^1~^TENDER_NUM~^PAYIN_ID~^EMPLOYEE_ID~^MACHINE_ID~^RECEIPT_NUM~^DATE_TIME~^AMOUNT~^ACTUAL~^CONVERSION~^SIGN_CAPTURE_ID~^SETUP_TENDER_ID~^IS_CHANGE~^SDTE~^TAX_REFUND_ID~_-1~^~^305~^1851~^~^"03/21/2007 13:23:27"~^670.38~^670.38~^0.00~^~^3~^""~^"2007-03-21"~^~*TBCCDETAILS~^13~^1~^TENDER_NUM~^CARD_NUM~^NAME_ON_CARD~^EXP_DATE~^OTHER_ID_1~^OTHER_ID_2~^AUTH_CODE~^TRACK2~^REF_NUM~^PIN~^DLU~^ESC_FLAG~^AUTH_RESP~_-1~^__________________- CARD_NUM HAS BEEN REMOVED FROM THE LOG -__________________~^"OFFUTT/JAMES"~^"1008"~^""~^"2405 "~^"04637B"~^""~^"04637B"~^""~^~^"0"~^"1"~*TBGIFTSUSED~^7~^0~^GIFT_NUM~^RECEIPT_NUM~^AMOUNT~^PAYIN_ID~^DTE~^GIFT_USED_ID~^MACHINE_ID~*TBCREDITUSED~^7~^0~^CREDIT_NUM~^RECEIPT_NUM~^AMOUNT~^PAYIN_ID~^DTE~^CREDIT_USED_ID~^MACHINE_ID~*TBRECEIPTSHIP~^11~^0~^RECEIPT_NUM~^CUSTOMER_ID~^CUST_SHIP_ID~^SHIP_METHOD_ID~^TAX_1~^TAX_2~^RECEIPT_SHIP_ID~^PICKUP_STORE~^VAT~^OLD_ID~^HOLD_TO_COMPLETE~*TBRECEIPTSLSMN~^3~^1~^RECEIPT_NUM~^EMPLOYEE_ID~^PERCENTAGE~_~^305~^100.00~*TBRENTALS~^24~^0~^RENTAL_ID~^SKU_BUCKET_ID~^EMPLOYEE_ID~^RECEIPT_NUM~^LOOKUP~^TIME_UNITS~^PRICE~^EXTENDED~^METHOD~^DTE_TIME_DUE~^SHIPPED~^MEMBER~^DTE_RETURN~^UPDATE_DTE~^SERIAL_NUM~^RENTAL_MODE~^LATE_FEE1~^LATE_FEE2~^SHIP_TAX_ENTRY_ID~^TAX_CODE_ID~^TAX1_AMOUNT~^TAX2_AMOUNT~^TAX1_PER~^TAX2_PER~*TBUNKNOWNLOOKUPS~^2~^0~^RECEIPTLINE_ID~^LOOKUP~*TBSCHEDPAYMENTS~^19~^0~^SCHED_PAYMENT_ID~^EMPLOYEE_ID~^MACHINE_ID~^RECEIPT_NUM~^TENDER~^DATE_TIME~^SCHED_DATE~^AMOUNT~^ACTUAL~^CONVERSION~^CARD_NUM~^NAME_ON_CARD~^EXP_DATE~^OTHER_ID_1~^OTHER_ID_2~^AUTH~^TRACK2~^REF_NUM~^SIGN_CAPTURE_ID~*TBRECPACK~^10~^0~^REC_PACKING_ID~^RECEIPT_NUM~^RECEIPTLINE_ID~^STORE_ID~^EMPLOYEE_ID~^MACHINE_ID~^TRACK_NUM~^DTE~^QUAN~_OLD_ID~*TBSMCDUSED~^7~^0~^SMCD_USED_ID~^SMART_CARD_ID~^AMOUNT~^RECEIPT_NUM~^PAYIN_ID~^DTE~^MACHINE_ID~*TBSMARTCARD~^10~^0~^SMART_CARD_ID~^SMART_CARD_NUM~^AVAILABLE~^IS_ACTIVE~^REPLENISH_DATE~^CUSTOMER_ID~^PURCHASED_BY~^TURN_ON_DATE~^TURN_OFF_DATE~^ORIG_RECEIPT_NUM~*TBSMCDREPLENISH~^5~^0~^SMCD_REPLENISH_ID~^SMART_CARD_ID~^RECEIPT_NUM~^DTE~^REPLENISH_AMOUNT~*TBRECEIPTSTATES~^7~^0~^RECEIPT_STATE_ID~^ RECEIPT_NUM~^ORDER_STATE_ID~^DATE_STARTED~^EMP_STARTED~^ DATE_COMPLETE~^EMP_COMPLETE~*TBSTORERECEIPT~^3~^1~^STORE_RECEIPT_NUM~^STORE_ID~^RECEIPT_NUM~_26522~^~^~*TBSHIPMEMO~^3~^0~^SHIP_MEMO_ID~^RECEIPT_NUM~^MEMO~*& AppServer responds to front end with a “Y” Receipt prints out

  15. Sample Transaction 2 User requests all receipts from store 19 where the date closed is 3/20/07. User Presses Search on Receipt List screen Front end sends the following to AppServer Receipt.ListAll?579~^0~^80~^A.STORE_ID=19 and A.DATE_CLOSED>='3/20/2007' and A.DATE_CLOSED<'3/21/2007'& AppServer returns the following to the front end

  16. Sample Transaction 2 TBRECEIPTLIST~^52~^19~^RECEIPT_NUM~^EMPLOYEE_ID~^CUSTOMER_ID~^STORE_ID~^MACHINE_ID~^DATE_TIME~^GIFT_AMOUNT~^SUBTOTAL~^LINE_DISC_AMOUNT~^OTHER_DISC_AMOUNT~^SHIPPING_CHARGE~^ALTERATION_CHARGE~^AFTER_DISC_AMNT~^TAX1~^TAX2~^PAID~^TOTAL_CREDITS~^TOTAL~^TOTAL_DUE~^PICKUP_DATE~^CREDIT_AMOUNT~^READY_TO_PICKUP~^DATE_CLOSED~^PENALTY~^LAST_INSTALL~^ZIP~^EMAIL~^PER_OFF~^TOTAL_WEIGHT~^UNITS_SHIPPED~^WEB_STATUS~^WEB_NUM~^LAST_SAVE_BY~^TYP~^AVAILABLE~^GIFT_FOR_NUM~^OUR_NUM~^CLOSED~^VOID_BY~^CREDIT_ISSUED~^FREE_DOLLARS_USED~^FREE_ITEMS_USED~^BUYCLUB_ITEMS~^BUYCLUB_DOLLARS~^CATEGORY1~^CATEGORY2~^CATEGORY3~^DISC_REASON~^FIRST_NAME~^LAST_NAME~^STORE_RECEIPT_NUM~^ORDER_STATE_LABEL~_577452~^648~^295865~^19~^1901~^2007-03-20 10:47:45.0~^~^139.99~^0.00~^0.00~^0.00~^0.00~^139.99~^9.80~^0.00~^149.79~^0.00~^149.79~^0.00~^~^0.00~^N~^2007-03-20 10:47:45.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^DAVID~^DREW~^29146~^~_577476~^738~^404851~^19~^1900~^2007-03-20 11:14:29.0~^~^1.99~^0.00~^0.00~^0.00~^0.00~^1.99~^0.14~^0.00~^2.13~^0.00~^2.13~^0.00~^~^0.00~^N~^2007-03-20 11:14:29.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^~^~^29147~^~_577510~^648~^404868~^19~^1901~^2007-03-20 12:01:14.0~^~^80.00~^0.00~^0.00~^0.00~^0.00~^80.00~^5.60~^0.00~^85.60~^0.00~^85.60~^0.00~^~^0.00~^N~^2007-03-20 12:01:14.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^VANESSA~^CUCCHI~^29148~^~_577534~^738~^404882~^19~^1901~^2007-03-20 12:22:39.0~^~^79.99~^0.00~^0.00~^0.00~^0.00~^79.99~^5.60~^0.00~^85.59~^0.00~^85.59~^0.00~^~^0.00~^N~^2007-03-20 12:22:39.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^SOLOMON~^SHAFFER~^29149~^~_577555~^648~^404171~^19~^1900~^2007-03-20 12:41:50.0~^~^367.96~^0.00~^0.00~^0.00~^0.00~^367.96~^25.76~^0.00~^393.72~^0.00~^393.72~^0.00~^~^0.00~^N~^2007-03-20 12:41:50.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^ANDREW~^JOHNSON~^29150~^~_577590~^648~^404902~^19~^1901~^2007-03-20 13:02:37.0~^~^329.98~^0.00~^0.00~^0.00~^0.00~^329.98~^23.10~^0.00~^353.08~^0.00~^353.08~^0.00~^~^0.00~^N~^2007-03-20 13:02:37.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^CONNER~^HENRY~^29151~^~_577617~^738~^404911~^19~^1900~^2007-03-20 13:18:31.0~^~^9.50~^0.00~^0.00~^0.00~^0.00~^9.50~^0.67~^0.00~^10.17~^0.00~^10.17~^0.00~^~^0.00~^N~^2007-03-20 13:18:31.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^~^~^29152~^~_577636~^258~^404921~^19~^1901~^2007-03-20 13:39:11.0~^~^271.85~^0.00~^0.00~^0.00~^0.00~^271.85~^19.03~^0.00~^290.88~^0.00~^290.88~^0.00~^~^0.00~^N~^2007-03-20 13:39:11.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^LUANNE~^WEBB~^29153~^~_577669~^233~^404936~^19~^1900~^2007-03-20 14:17:59.0~^~^40.00~^0.00~^0.00~^0.00~^0.00~^40.00~^2.80~^0.00~^42.80~^0.00~^42.80~^0.00~^~^0.00~^N~^2007-03-20 14:17:59.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^GAIL~^SERNERSHEIN~^29154~^~_577672~^233~^355632~^19~^1900~^2007-03-20 14:19:33.0~^~^5.99~^0.00~^0.00~^0.00~^0.00~^5.99~^0.42~^0.00~^6.41~^0.00~^6.41~^0.00~^~^0.00~^N~^2007-03-20 14:19:33.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^NOT~^INT~^29155~^~_577688~^258~^278316~^19~^1900~^2007-03-20 14:44:35.0~^~^16.00~^0.00~^0.00~^0.00~^0.00~^16.00~^1.12~^0.00~^17.12~^0.00~^17.12~^0.00~^~^0.00~^N~^2007-03-20 14:44:35.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^MR~^DECLINED~^29156~^~_577689~^258~^278316~^19~^1900~^2007-03-20 14:45:30.0~^~^3.50~^0.00~^0.00~^0.00~^0.00~^3.50~^0.25~^0.00~^3.75~^0.00~^3.75~^0.00~^~^0.00~^N~^2007-03-20 14:45:30.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^MR~^DECLINED~^29157~^~_577699~^233~^404951~^19~^1900~^2007-03-20 14:54:15.0~^~^130.00~^0.00~^0.00~^0.00~^0.00~^130.00~^9.10~^0.00~^139.10~^0.00~^139.10~^0.00~^~^0.00~^N~^2007-03-20 14:54:15.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^JESSICA~^EMMITT~^29158~^~_577744~^217~^404966~^19~^1901~^2007-03-20 15:47:39.0~^~^88.00~^0.00~^0.00~^0.00~^0.00~^88.00~^6.16~^0.00~^94.16~^0.00~^94.16~^0.00~^~^0.00~^N~^2007-03-20 15:47:39.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^CHRISTINE~^BONATZ~^29159~^~_577874~^220~^386677~^19~^1900~^2007-03-20 18:22:50.0~^~^104.89~^0.00~^0.00~^0.00~^0.00~^104.89~^7.34~^0.00~^112.23~^0.00~^112.23~^0.00~^~^0.00~^N~^2007-03-20 18:22:50.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^SHARON~^ROMEO~^29160~^~_577896~^233~^405040~^19~^1900~^2007-03-20 19:07:20.0~^~^19.95~^0.00~^0.00~^0.00~^0.00~^19.95~^1.40~^0.00~^21.35~^0.00~^21.35~^0.00~^~^0.00~^N~^2007-03-20 19:07:20.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^GENE~^ROHEG~^29161~^~_577905~^272~^405043~^19~^1901~^2007-03-20 19:26:45.0~^~^55.00~^0.00~^0.00~^0.00~^0.00~^55.00~^3.85~^0.00~^58.85~^0.00~^58.85~^0.00~^~^0.00~^N~^2007-03-20 19:26:45.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^CHARLES~^DOWNS~^29162~^~_577925~^220~^96247~^19~^1900~^2007-03-20 19:58:16.0~^~^48.93~^20.97~^0.00~^0.00~^0.00~^48.93~^3.43~^0.00~^52.36~^0.00~^52.36~^0.00~^~^0.00~^N~^2007-03-20 19:58:16.0~^0.00~^~^30066~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^WARD~^PYLES~^29163~^~_577952~^233~^399999~^19~^1900~^2007-03-20 20:50:43.0~^~^-66.40~^0.00~^0.00~^0.00~^0.00~^-66.40~^-4.65~^0.00~^-71.05~^0.00~^-71.05~^0.00~^~^0.00~^N~^2007-03-20 20:50:43.0~^0.00~^~^~^~^~^0.000~^~^~^~^~^0~^~^~^~^N~^~^0.00~^0.00~^~^~^0.00~^~^~^~^~^DIANA~^SIMAAN~^29164~^~* Front end displays the data on the list screen grid

  17. Start Transaction AppServer sends data to database record by record If everything saves properly, transaction is committed If anything fails, entire transaction rolled back. Transaction Process

  18. Front end saves data record by record A sale is comprised of 4-100 records If any one record fails, transaction still finishes Sales could have headers but miss line items or payments. Non-Transaction Processing

  19. Flow of Data

  20. Real-Time data is sent to head-office application server for permanent storage and enterprise-wide viewing As data flows on internet, it’s protected by highest security protocol Application Server/ Redundant Database

  21. If connectivity lost, store continues to function without interruption Store app server/database handles all store’s information and requests Reduce Unforeseen Problems

  22. Data is sent to head office as soon as the line is restored Reduce Unforeseen Problems

  23. Software Updates Update Process

  24. Software Updates AppServer Update Two files – CelerantEAS.jar, AppController.jar Copied into current location overwriting existing files Small file transfer (2-3 Mb) Must be done on Head Office AppServers and ALL Local AppServers New automated process copies these files automatically

  25. Software Updates Front End Update Front end copied to all machines in form of an archive (Zip) Custom files must be included in zip or copied later Large file transfer even archived – 40 meg Files extracted to every terminal overwriting existing front end New automated process does NOT address Front End updating

  26. Software Updates Database Update • Database is updated using scripts • Scripts are commands the database executes to add or alter the database structure or programs (stored procedures or triggers) • Each change to the database is made in a single script • An update can have one script or one hundred scripts • Scripts must be executed at the head office database and all local databases. • Any script that is not executed or fails to execute can cause undesired results • Procedures or triggers not functioning as intended or at all • Downloads or uploads failing due to incongruent table structures. • Scripts are a part of the new automated update process

More Related