Electronic Commerce and Transaction Processing Systems Chapter

Electronic Commerce and Transaction Processing Systems Chapter 5 Fundamentals of Information Syst ems, Second Edition 1

Learning Objectives Identify several advantages of ecommerce. Identify some of the major challenges companies must overcome to succeed in e-commerce. Identify several e-commerce applications. Fundamentals of Information Syst ems, Second Edition 2

Learning Objectives Outline the key components of technology infrastructure that must be in place for ecommerce to succeed. Discuss the key features of the electronic payments systems needed to support ecommerce. Identify the major issues that represent significant threats to the continued growth of e-commerce. Fundamentals of Information Syst ems, Second Edition 3

Learning Objectives Identify the basic activities and business objectives common to all transaction processing systems. Discuss the importance of business resumption planning and disaster recovery for key transaction processing systems. Fundamentals of Information Syst ems, Second Edition 4

Learning Objectives Define the term enterprise resource planning system and discuss the advantages and disadvantages associated with the implementation of such a system. Fundamentals of Information Syst ems, Second Edition 5

Introduction to Electronic Commerce Fundamentals of Information Syst ems, Second Edition 6

E-Commerce Business-to-consumer – Example: Bookstore selling books to customers (amazon.com) – Annual online spending in 2002 was 85 billion Business-to-business – Example: A data processing company handling data services for a company (adp.com) – 5.3 trillion impact by 2005 Consumer-to-consumer – Example: A customer selling goods to another customer (e-bay.com) Fundamentals of Information Syst ems, Second Edition 7

Why Use E-Commerce? Cut transaction costs Speed flow of goods and information Improve customer service Coordinate manufacturers, suppliers, and customers Fundamentals of Information Syst ems, Second Edition 8

Supply Chain Management Fundamentals of Information Syst ems, Second Edition 9

Value Chains in E-Commerce Conversion to e-commerce supply chain management provides businesses with an opportunity to: – increase revenues or decrease costs by eliminating time-consuming and labor-intensive steps throughout the order and delivery process – improve customer satisfaction by enabling customers to view detailed information about delivery dates and order status – reduce inventory including raw materials, safety stocks, and finished goods Fundamentals of Information Syst ems, Second Edition 10

Product and Information Flow for HP Printers Ordered Over the Web Fundamentals of Information Syst ems, Second Edition 11

E-Commerce Applications Fundamentals of Information Syst ems, Second Edition 12

E-Commerce Applications Retail and Wholesale: www.estore.com.tr/ Manufacturing: www.covisint.com/ Marketing: www.doubleclick.com Investment and Finance: www.garanti.com.tr/ Auctions: www.gittigidiyor.com Price comparison: www.google.com/froogle Fundamentals of Information Syst ems, Second Edition 13

Retail and Wholesale Electronic retailing - the direct sale from business to consumer through electronic storefronts Cybermall - a single Web site that offers many products and services at one Internet location Fundamentals of Information Syst ems, Second Edition 14

Model of an Electronic Exchange Fundamentals of Information Syst ems, Second Edition 15

Web Sites Useful to Investors Fundamentals of Information Syst ems, Second Edition 16

Popular Stock Tracker Web Sites Fundamentals of Information Syst ems, Second Edition 17

Technology, Infrastructure, and Development Fundamentals of Information Syst ems, Second Edition 18

Key E-Commerce Technical Components Fundamentals of Information Syst ems, Second Edition 19

Hardware The amount of storage capacity and computing power required of the Web server depends primarily on two things: – the software that must run on the server – the volume of e-commerce transactions that must be processed Fundamentals of Information Syst ems, Second Edition 20

Software (1) Web server software – Apache Server – Microsoft Internet Information Server Web site development tools – FrontPage, NetStudio Web page construction software – Static Web page: Always the same information (ISE 100 Web page) – Dynamic Web page: Content created based on demand (Google search results) Fundamentals of Information Syst ems, Second Edition 21

Software (2) Database management system – SQL Server – Oracle E-commerce software – Catalog software – Product configuration software – Electronic shopping cart Fundamentals of Information Syst ems, Second Edition 22

Catalog Management Software Combines product data formats into a standard format Creates a central repository of product data Catalog resides on a database Amazon’s book, music catalog Fundamentals of Information Syst ems, Second Edition 23

Product Configuration Software Allow buyers to build the products they want to buy www.dell.com lets you choose parts of the computer separately Better customization, better sales Fundamentals of Information Syst ems, Second Edition 24

Electronic Shopping Cart Track items selected for purchase Let buyers modify their choices (add or delete items) Let buyers “checkout” (begins a purchase transaction) Wish list Fundamentals of Information Syst ems, Second Edition 25

Electronic Shopping Cart Fundamentals of Information Syst ems, Second Edition 26

Electronic Payment Systems Electronic cash – Money that is “computerized” – Used as cash in e-commerce transactions Electronic wallets – Holds credit card, e-cash, address information – Automatically handles checkout Credit, charge, debit, and smart cards Fundamentals of Information Syst ems, Second Edition 27

An Overview of Transaction Processing Systems Fundamentals of Information Syst ems, Second Edition 28

TPS, MIS/DSS, and Special-Purpose Information Systems Fundamentals of Information Syst ems, Second Edition 29

Traditional Transaction Processing Methods Batch processing – method of computerized processing in which business transactions are accumulated over a period of time and prepared for processing as a single unit On-line transaction processing (OLTP) method of computerized processing in which each transaction is processed immediately and the affected records are updated Fundamentals of Information Syst ems, Second Edition 30

Batch versus On-Line Processing Fundamentals of Information Syst ems, Second Edition 31

Integration of a Firm’s TPSs Fundamentals of Information Syst ems, Second Edition 32

Transaction Processing Activities Data collection: Capturing data necessary for the transaction Data editing: Check validity and completeness – Ex: 400 hours/week instead of 40 hours/week Data correction: Correct the wrong data Data manipulation: Calculate, summarize Data storage: Update transactions Document production and reports: Create end results (paychecks) Fundamentals of Information Syst ems, Second Edition 33

Data Processing Activities Common in Transaction Processing Systems Fundamentals of Information Syst ems, Second Edition 34

Point-of-Sale Transaction System Fundamentals of Information Syst ems, Second Edition 35

Systems that Support Order Processing Order Processing System Purpose Order entry Data for order Sales configuration Ensure enough products Shipment planning Which order from which location Shipment execution Right products on time Inventory control Reflect exact quantity Invoicing and billing Generate customer invoice Customer management Monitor customer contact Routing and scheduling Best way to move products Fundamentals of Information Syst ems, Second Edition 36

Order Processing Systems Fundamentals of Information Syst ems, Second Edition 37

Business Resumption Planning The process of anticipating and minimizing the effects of disasters. Focuses primarily on two issues: – maintaining the integrity of corporate information – keeping key information systems running until normal operations can be resumed Disaster recovery – implementation of the business resumption plan Fundamentals of Information Syst ems, Second Edition 38

Enterprise Resource Planning Fundamentals of Information Syst ems, Second Edition 39

Some ERP Software Vendors Fundamentals of Information Syst ems, Second Edition 40

Commonalities Among ERP Systems Integrate data: Enter data once; access everywhere Operate in Client/Server Environment Based on Objects: – Uses object-oriented approach – Easy to extend Employ Tables: – System configuration table: Defines how the system is set up – Control table: Defines functions that help the user Does not allow a non-existing product to be purchased – Application data table: Content-related data Fundamentals of Information Syst ems, Second Edition 41

Advantages of ERP Elimination of costly, inflexible legacy systems – Single integrated system Improvement of work processes – Support best practices: Most efficient and effective way of carrying out a business process Increase in access to data for operational decision making – A sale is reflected in inventory control Upgrade of technology infrastructure – Uniform platform Fundamentals of Information Syst ems, Second Edition 42

Disadvantages of ERP Expense and time in implementation Difficulty integrating with other systems Risks in using one vendor Fundamentals of Information Syst ems, Second Edition 43

Summary E-commerce – includes business-to-business (B2B), business-toconsumer (B2C), consumer-to-consumer (C2C). Transaction Processing Systems (TPSs) - consist of all the components of a CBIS, including databases, telecommunications, people, procedures, software, and hardware devices to process transactions. Business resumption plan – anticipates and minimizes the effects of disasters. Disaster recovery – implements disaster resumption plan. Fundamentals of Information Syst ems, Second Edition 44