1
Enterprise Resource Planning (ERP) integrates internal business processes — finance, HR, manufacturing, supply chain — into a single system. Key vendors: SAP, Oracle. All departments share one database.
2
Supply Chain Management (SCM) manages the flow of goods and services from supplier → manufacturer → distributor → retailer → customer. Goal: reduce costs, improve efficiency, optimize inventory.
3
Customer Relationship Management (CRM) manages customer-facing interactions — sales, marketing, customer service. Goal: improve customer satisfaction and retention. Examples: Salesforce, HubSpot.
4
OLTP (Online Transaction Processing) handles day-to-day operational transactions: inserting, updating, deleting records. Optimized for high-frequency, short transactions with ACID properties. Example: banking ATM, POS.
5
OLAP (Online Analytical Processing) handles complex queries for decision support. Optimized for read-heavy, large-scale aggregations. OLAP uses multidimensional data cubes. Example: sales trend analysis.
6
A Data Warehouse is a subject-oriented, integrated, time-variant, non-volatile collection of data supporting management decision-making. The 4 characteristics (Inmon's definition): Subject-oriented (organized by subject like sales), Integrated (consistent formats), Time-variant (stores historical snapshots), Non-volatile (data is only loaded, not updated).
7
Data Mining extracts hidden patterns and knowledge from large databases. Techniques: classification, clustering, association rules, regression. Applications: market basket analysis, fraud detection.
8
Knowledge Management (KM): Tacit knowledge is personal, experience-based, hard to document (skills, intuitions). Explicit knowledge is codified, documented, easily shared (manuals, databases). KM systems aim to convert tacit to explicit.
9
Decision Support System (DSS) helps managers make semi-structured or unstructured decisions. Components: database, model base, user interface. Different from EIS (Executive IS) which serves top management.
10
Business Intelligence (BI) transforms raw data into actionable insights using OLAP, data warehousing, reporting dashboards, and data mining. Helps organizations make data-driven decisions.