Management Information Systems - Sacramento State

Transaction Processing Systems Manual or automatic all businesses systematically process transactions Function: process routine, day-to-day business activities Computerized TPS: Batch Online (real-time, OLTP) The foundation of business systems MIS 175 Spring 2002 Chapter 9 MIS 221 1 Batch TPS

Originally, the only available option Transactions accumulated over period of time Time period day, week, month Transaction records accumulated in files When batches are processed, what happens? Update databases Generate reports Generate transactions for other systems MIS 175 Spring 2002 Chapter 9 MIS 221

2 Batch Processing Pros and Cons Pros Relatively easy to program, install and maintain Batches can be processed during low-activity periods Cons Information is delayed MIS 175 Spring 2002 Chapter 9 MIS 221

3 Online TPS (OLTP) Transactions are processed in real time Required for any modern application where time is critical Well supported by client/server computing model MIS 175 Spring 2002 Chapter 9 MIS 221 4 Hybrid TPS OLTP applications can feed transactions to batch systems

Examine: GL only updated once per day Real time order capture with delayed processing MIS 175 Spring 2002 Chapter 9 MIS 221 5 TPS Requirements Capture, process and store transactions Produce reports and information about transactions Produce transactions for other TPS Be accurate and timely Be efficient require less labor

Increase customer service Increase competitive advantage MIS 175 Spring 2002 Chapter 9 MIS 221 6 TPS Activity Model Data capture From online entry or external system Data validation Should be done as close to source as possible Processing Data manipulation Database updating

Generation of transactions for other systems Archive Transaction Create documents and reports MIS 175 Spring 2002 Chapter 9 MIS 221 7 Management Issues Uptime How long can the system be down before significant costs are incurred? Processing Delays / Response Times How quickly must a transaction be processed?

What is the worst online response time that is acceptable MIS 175 Spring 2002 Chapter 9 MIS 221 8 Management Issues (2) Disaster Recovery What plans are in place to recover lost business data? What plans are in place to resume business processing in case of disaster? Audit Can you verify the integrity of the system? How will you know if transactions are not

processed or are processed incorrectly? MIS 175 Spring 2002 Chapter 9 MIS 221 9 TPS By Function Order Processing Procurement & Inventory Control Accounting MIS 175 Spring 2002 Chapter 9 MIS 221 10 Order Processing TPS

Order capture Variety of means Configuration Shipment planning and inventory allocation Prioritize orders, select shipment locations, allocate inventory to orders Shipping and warehousing Picking, packing, invoicing, reporting MIS 175 Spring 2002 Chapter 9 MIS 221 11 Procurement

Inventory Control Raw materials, WIP, FGI, etc Purchase Order Processing Generating, transmitting, maintaining purchase orders Receiving Accounts Payable Boundary between procurement and accounting MIS 175 Spring 2002 Chapter 9 MIS 221 12 Accounting

Accounts Payable Accounts Receivable Budget Payroll General Ledger Asset Management MIS 175 Spring 2002 Chapter 9 MIS 221

13 Disadvantages of Functionally Organized TPS Processing inefficiency Data redundancy Causes integrity problems Inefficient Temporal integrity problems Caused by different times at which processing occurs Lack of information coherence MIS 175 Spring 2002 Chapter 9 MIS 221

14 Enterprise Resource Planning Systems Key word is Enterprise: solution designed for entire enterprise All processes organized around one enterprise-wide data model MIS 175 Spring 2002 Chapter 9 MIS 221 15 Advantages of ERP Elimination of costly legacy systems Old systems are expensive to maintain and

reduce business agility Improvement of processes ERP may have implemented best-in-class processes Improve data access and data integrity Provide complete, consistent view of enterprise data MIS 175 Spring 2002 Chapter 9 MIS 221 16 Disadvantages of ERP Implementation cost Software and hardware

Expertise Opportunity costs Time to implementation Lengthy and difficult process MOC (management of change) challenges System integration difficulties Vendor dependence MIS 175 Spring 2002 Chapter 9 MIS 221 17 Current ERP Vendors

SAP Baan PeopleSoft Oracle J. D. Edwards Manugistics MIS 175 Spring 2002 Chapter 9 MIS 221 18

R/3 Architecture Functionally rich More functional options than a business will ever need Logical Built around information model 10,000 tables Control tables Application data tables Heavily parameterized MIS 175 Spring 2002 Chapter 9 MIS 221 19

R/3 Architecture (cont) Hardware PC Clients Application server Database server Public interfaces BAPI Customization ABAP Development System MIS 175 Spring 2002 Chapter 9 MIS 221 20

Recently Viewed Presentations

  • Windows Server 2008 R2 TDM - download.microsoft.com

    Windows Server 2008 R2 TDM - download.microsoft.com

    An arrow goes from the TS Web Access Server to the client. ... protected DNS zone include a set of private keys that are sent as DNS resource records from the DNS Server services on Windows Server 2008 R2 and...
  • Muhammad (peace be upon him) Mercy to Mankind

    Muhammad (peace be upon him) Mercy to Mankind

    Muhammad (peace be upon him) Mercy to Mankind
  • SSEMI1a. Illustrate the flow of goods and services by means ...

    SSEMI1a. Illustrate the flow of goods and services by means ...

    markets for goods and services. Firms buy the resources they need to produce— factors of production— in. factor markets. Money. is anything . that is used to determine value during the exchange of goods and services.
  • Aligning learning and assessment - Western Sydney University

    Aligning learning and assessment - Western Sydney University

    Paul Parker, UWS Student Learning Unit ''But it's not really user friendly' Student perceptions of criteria & standards and exemplars Learning guides should include: 29(d) Annotated models of student essays or reports, or marking guides, to clarify expectations about what...
  • Verbals - Freshman Literature and Composition

    Verbals - Freshman Literature and Composition

    Verbals are words that seem to carry the idea of action or being but do not function as a true verb. They are sometimes called "nonfinite" (unfinished or incomplete) verbs. Because time is involved with all verb forms, whether finite...
  • Jane Schaeffer Writing Model

    Jane Schaeffer Writing Model

    A Jane Schaffer Paragraph is a five (5) sentence paragraph that has a definite structure and transition from one idea to the next. You must follow the guidelines specifically. Topic Sentence (TP): A broad sentence that mentions key details. Concrete...
  • East Asian Monetary Union - University of Western Ontario

    East Asian Monetary Union - University of Western Ontario

    East Asian Monetary Union. The good, the Bad and the Ugly . ... Economic Integration is the unification of economic policies with the primary purpose of increasing efficiency and productivity. This can involve. Elimination of Trade Barriers. Establishment of Free...
  • loconav.com

    loconav.com

    commissioning of test facilities. To this end, the erstwhile Ministry of Surface Transport (MoST) has constituted a permanent Automotive Industry Standards Committee (AISC) vide order No. RT-11028/11/97-MVL dated September 15, 1997. The standards prepared by AISC will be approved by...