File Chap 4 Flashcards
System supports core business function by handling sales, accounting, purchasing and more.
What: Processes Transactions
How: Modifies the database by adding and changing transaction data
When: Real Time
Online transaction Processing (OLTP)
System supports leveraging the data for information (i.e. turning that data into information)
What: Processes reports and analytics
How: Queries the database to answer question
When: Real Time
Online Analytical Processing (OLAP)
Who: Exec
Why: Strategic Decision
How: Helps with strategic planning and corporate culture.
Executive Support System
Who: Upper-level mgmt
Why: Nonroutine Decision
How: 2-3 years timeframe of evaluation and decision-making.
Decision Support System
Who: Middle Mgmt
Why: Routine Decision
How: Plan to produce daily. 1mo-1yr timeframe to support transaction workers to achieve objectives.
Management Information System
Who: Workers
Why: Capturing Data
How: It is the foundation for everything else. They capture day to day activity.
Transaction Processing System
AIS is Transaction Processing System
TPS should be?
Be available - When people need it and want it
Ensure Data Integrity - (Accurate, Completeness, and Consistency)
Data is collected as it is generated and processed later at a scheduled time (periodic processing)
Batch
Currency of Information: Has delay of information
Efficiency: More efficient (gather data, organize, then process)
Simplicity: More simple
Quality of Data: Higher quality (can check data, fix, clean, and organize it)
Example: payroll, depreciation
Batch
Currency of Information: Has instantenous information (always up to date)
Efficiency: Less efficient (constantly updating; open database, save data, close data, start-over)
Simplicity: Less simple (have to block everyone out while updating)
Quality of Data: Lower quality(no time in fixing or organizing it)
Example: Sales transactions, venmo
Real Time
Interface between components and users
Created by programmers using programming language
Software
Written set of coded instructions that the system understands
Programming Language