Chapter 8 Flashcards
What is OLTP?
- Online Trnsaction Processing (OLTP)
- Collects data electronically and processes the transactions online.
- The backbone of all functional, cross-functional, and inter-orgnaizational systems in an organization.
How does OLTP support decision making?
System supports decision making by providing the raw information about transactions and status for organization.
What are 2 different models of transaction Processing?
- Real-time Processing
- Batch Processing
Explain Real-time Processing.
Transactions are entered and processed immediately upon entry.
(Ex. Airline reservation system, Banking System)
Explain Batch Processing.
System waits until it has a batch of transactions before the data is processed and info is updated.
What is OLAP?
- Oline Analytical Processing (OLAP)
- Focuses on making OLTP-collected data useful for decision making.
- Able to perform arithmetic operations on groups of data.
Define a Business Intelligence System.
System provides info for improving decision making.
List the four categories of BI systems.
- Reporting Systems
- Data-mining Systems
- Knowledge-management (KM) Systems
- Expert Systems
Explain Reporting Systems.
- Integrate data from multiple sources.
- Process data by sorting, grouping, summing, averaging, and comparing.
- Format results into reports
- Improve decision making by providing right info to right user at right time.
Explain Data-Mining Systems.
- Process data using aophisticated statistical techniques. (Regression & Tree diagram analysis).
- Looks for patterns & relationships to anticipate events or predicts future outcomes. (Market Basket analysis; Predict Donations).
Explain Knowledge-Management Systems.
- Create value from intellectual capital
- Collect & share human knowledge
- Supported by the 5 components of Information Systems.
Explain Expert Systems.
- Encapsulates the knowledge of human experts in the form of IF/THEN rules.
- ex, IF condition is true, THEN initiate procedure.
- Improve diagnosis & decision making.
What is RFM analysis and what are its components?
A way of analyzing & ranking customers according to their purchasing patterns.
Technique Considers:
- How recently (R) a customer has ordered.
- How frequently (F) a customer orders.
- How much money (M) the customer spend per order.
What is a Data Warehouse?
System that is used to clean & extract data from operational systems and other sources.
What is the purpose of a Data Warehouse, and what does it store in its DBMS?
- Prepares data for BI processing
- Data-Warehouse DBMS:
- Stores data
- May also include data from external sources
- Metadata concerning data stored in data-warehouse meta database.