Information Technology in Management: Computers, MIS and DSS, Artificial Intelligence and Big Data, Data Warehousing and Mining, Knowledge Management and Managing Technological Change

The second half of Unit 9 is the information side of management: how computers came to be used in organisations and the ladder of information systems from transaction processing to executive support, what a management information system and a decision support system are, what artificial intelligence and big data mean for a manager, how a data warehouse differs from an operational database and what data mining finds in it, how knowledge is created and shared, and how technological change is managed. The paper asks for the type of system that fits a described use, the author of a model, and the meaning of a term; every item here is given with its definition and its distinguishing feature.

1. Use of computers in management: transaction processing, MIS and decision support systems

Computers entered business in the 1950s for payroll and accounting; the information systems built on them are usually arranged by the level of management they serve. Data are raw facts; information is data processed into a meaningful form for a decision; knowledge is information combined with experience and judgement. An information system has hardware, software, data, procedures, people and networks. Its applications in management are recording and processing transactions, planning and control reporting, modelling and simulation for decisions, communication and collaboration, and, increasingly, automation of judgement itself.

Types of information systems by level
SystemServesWhat it does
Transaction processing system (TPS)Operational levelRecords routine transactions — orders, payroll, billing, inventory; batch or online (OLTP); the data source for all higher systems
Office automation system (OAS)Knowledge and clerical workersWord processing, e-mail, scheduling, document management, groupware
Management information system (MIS)Middle managementPeriodic, summary and exception reports from TPS data for planning and control of structured problems
Decision support system (DSS)Middle and senior managers, analystsInteractive, model-based 'what-if' analysis of semi-structured problems; user drives it
Executive information / support system (EIS/ESS)Top managementDashboards, drill-down, external and internal data for unstructured strategic issues
Expert system / knowledge-based systemAny level, narrow domainKnowledge base + inference engine reproduce a specialist's reasoning (MYCIN, XCON); if-then rules

A management information system is an integrated user-machine system for providing information to support the operations, management and decision-making functions of an organisation (Gordon Davis). Its characteristics are management orientation, integration, a common database, planned reporting and flexibility. The Gorry and Scott Morton framework (1971) crosses Anthony's three levels of management (operational control, management control, strategic planning) with Simon's three degrees of problem structure (structured, semi-structured, unstructured): MIS serves structured problems and DSS the semi-structured. Nolan's stage model (1973, extended 1979) describes an organisation's IT growth through initiation, contagion, control, integration, data administration and maturity. Development follows the system development life cycle — feasibility, analysis, design, development, testing, implementation (direct, parallel, phased or pilot cut-over), maintenance — or prototyping and agile methods; the CIO heads the function.

  • DSS components — the database (internal and external data), the model base (statistical, financial, optimisation and simulation models), the user interface (dialogue), and in later designs a knowledge base; Sprague and Carlson's 'DDM' paradigm (dialogue, data, models).
  • DSS types (Power) — data-driven (query and OLAP over a warehouse), model-driven (optimisation, simulation, financial models), knowledge-driven (expert rules, data mining), document-driven and communication-driven (group decision support systems — GDSS — for meetings, with anonymity and parallel input).
  • Analyses a DSS runs — what-if (change an input, see the output), sensitivity (how much an output changes per unit of input), goal-seeking (what input gives a target output), and optimisation (best value subject to constraints).
  • MIS versus DSS — MIS gives scheduled, standard reports on structured problems and the system drives the flow; DSS is ad hoc, interactive and model-based on semi-structured problems and the user drives it; EIS sits above both with summarised, drill-down views for executives.
🧠 Match the system to the sentence
'Records each sale at the till' → TPS. 'Monthly sales-by-region report with variances flagged' → MIS (exception report). 'Manager changes the discount rate and sees the effect on projected profit' → DSS (what-if). 'CEO's dashboard with drill-down to any division' → EIS. 'Diagnoses a fault from if-then rules captured from a senior engineer' → expert system. 'Team votes anonymously on options during a meeting' → GDSS.

2. Artificial intelligence and big data

Artificial intelligence is the capability of a machine to perform tasks that normally require human intelligence — perceiving, reasoning, learning, deciding and using language. The term was coined at the Dartmouth workshop of 1956 (John McCarthy); Alan Turing's 1950 test asks whether a machine's conversation is indistinguishable from a human's. Narrow (weak) AI performs one task; general (strong) AI would match human breadth and does not exist. Machine learning lets systems improve from data without explicit programming: supervised learning trains on labelled examples (classification and regression — credit scoring, demand forecasting), unsupervised learning finds structure in unlabelled data (clustering for customer segmentation, association, dimensionality reduction), and reinforcement learning learns actions from rewards (dynamic pricing, robotics). Deep learning uses multi-layer neural networks and drove the advances in image recognition, speech and natural language processing after 2012; generative AI — large language models built on the transformer architecture (2017) such as those behind ChatGPT (released November 2022) — produces text, images and code and has pushed AI into every office function. Business applications include chatbots and virtual assistants, recommendation engines, fraud detection, predictive maintenance, robotic process automation and algorithmic decision-making in HR and credit. Ethical and governance concerns are bias in training data, opacity ('black box'), privacy, accountability, job displacement and deepfakes; the EU's AI Act (2024) is the first comprehensive regulation, and India's Digital Personal Data Protection Act 2023 governs personal data while the IndiaAI Mission (approved March 2024, outlay of about ₹10,372 crore over five years) builds compute capacity, datasets and skilling.

Big data: the Vs and the analytics ladder
TermMeaning
VolumeScale beyond conventional databases — terabytes to petabytes; from transactions, sensors, web, social media
VelocitySpeed of generation and need for real-time or streaming processing
VarietyStructured (tables), semi-structured (XML, JSON, logs) and unstructured (text, images, video, voice)
Veracity and value (added later)Trustworthiness of data; the business worth extracted — the original three Vs are Laney's (Gartner, 2001)
Descriptive analyticsWhat happened — reports, dashboards, OLAP
Diagnostic analyticsWhy it happened — drill-down, correlation
Predictive analyticsWhat will happen — regression, classification, forecasting, machine learning
Prescriptive analyticsWhat should be done — optimisation, simulation, recommendation

Big data technologies handle what a single machine cannot: distributed storage and processing (Hadoop's HDFS and MapReduce, 2006; Apache Spark for in-memory speed), NoSQL databases for unstructured and semi-structured data (document, key-value, column and graph stores), cloud platforms that rent elastic capacity (infrastructure, platform and software as a service), and the Internet of Things as the fastest-growing source. For managers big data underpins customer analytics and personalisation, dynamic pricing, supply-chain visibility, risk and fraud models, people analytics in HR and evidence-based strategy; its limits are data quality, privacy and consent, security, the skills gap and the danger of mistaking correlation for cause.

⚠️ Supervised or unsupervised?
If the training data carry the answer (defaulted / did not default; price paid), it is supervised — classification for categories, regression for numbers. If there is no answer and the task is to find groups or patterns (segment customers, find items bought together), it is unsupervised — clustering, association. If an agent learns by trial and reward (a pricing bot, a game player), it is reinforcement learning. Descriptive analytics reports the past; predictive forecasts; prescriptive recommends an action — the ladder rises in value and difficulty.

3. Data warehousing and data mining

A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision-making (Bill Inmon, 'the father of the data warehouse', 1992). Subject-oriented: organised around customers, products or sales rather than applications; integrated: cleaned to consistent names, units and codes from many sources; time-variant: holds history with time stamps; non-volatile: loaded periodically and not updated by transactions. Data reach it by ETL — extract from operational systems, transform (clean, standardise, aggregate), load — via a staging area; a data mart is a departmental subset; metadata describe the data. Inmon's top-down approach builds the enterprise warehouse first in normalised form and derives marts from it; Ralph Kimball's bottom-up approach builds dimensional marts and unites them by a bus of conformed dimensions. The dimensional (star) schema has a central fact table of measures (sales amount, quantity) keyed to surrounding dimension tables (time, product, store, customer); a snowflake schema normalises the dimensions into further tables. A data lake stores raw data of all types for later use; a lakehouse combines the two.

OLTP versus OLAP
FeatureOLTP — online transaction processingOLAP — online analytical processing
PurposeRun the business: record transactionsAnalyse the business: support decisions
DataCurrent, detailed, application-oriented, normalised (3NF)Historical, summarised, subject-oriented, dimensional (star)
OperationsShort read-write transactions, many usersComplex read-only queries; slice, dice, drill-down, roll-up, pivot on a data cube
Term coined by—E. F. Codd (1993), also author of the relational model (1970); MOLAP, ROLAP, HOLAP variants

Data mining is the discovery of previously unknown, valid and actionable patterns in large data sets — the analysis step of knowledge discovery in databases (KDD: selection, pre-processing, transformation, mining, interpretation). Its tasks are classification (assign to known classes — decision trees, naive Bayes, k-nearest neighbours, neural networks; credit approval, churn), regression (predict a number), clustering (group without labels — k-means, hierarchical; segmentation), association-rule mining (items that occur together — market-basket analysis by the Apriori algorithm, Agrawal and Srikant 1994), sequence and time-series analysis, anomaly or outlier detection (fraud), and text and web mining. An association rule X → Y is judged by support (fraction of transactions containing both X and Y), confidence (fraction of transactions with X that also contain Y) and lift (confidence ÷ support of Y; lift above 1 means a real association). CRISP-DM (1999) is the standard process: business understanding, data understanding, data preparation, modelling, evaluation, deployment. Overfitting — a model that memorises the training data and fails on new data — is the classic hazard, guarded against by hold-out and cross-validation.

🧠 Support, confidence and lift in one basket
Of 1,000 transactions, 200 contain bread, 150 contain butter and 100 contain both. For the rule bread → butter: support = 100/1,000 = 10%; confidence = 100/200 = 50%; lift = 0.50 ÷ (150/1,000 = 0.15) = 3.33. Lift above 1 says butter is 3.33 times as likely in a basket with bread as in a random basket — a real association worth shelf placement. Apriori prunes candidate item-sets by the rule that every subset of a frequent item-set must itself be frequent.

4. Knowledge management and managing technological change

Knowledge management (KM) is the systematic process of creating, capturing, organising, sharing and applying an organisation's knowledge to achieve its objectives. Polanyi distinguished tacit knowledge — personal, experiential, hard to articulate ('we know more than we can tell') — from explicit knowledge, which can be codified in documents, databases and procedures. Nonaka and Takeuchi's SECI model (1995, 'The Knowledge-Creating Company') describes four modes of conversion in a spiral: socialisation (tacit to tacit, by shared experience and apprenticeship), externalisation (tacit to explicit, by dialogue, metaphor and writing), combination (explicit to explicit, by systemising documents and databases) and internalisation (explicit to tacit, by learning by doing); 'ba' is the shared context in which it happens. KM strategies are codification (people-to-documents; reuse; Hansen, Nohria and Tierney 1999) and personalisation (people-to-people; expertise networks). Tools are knowledge repositories and portals, expertise directories, communities of practice (Wenger), lessons-learned and after-action reviews, storytelling, mentoring and enterprise social platforms. The learning organisation (Peter Senge, 'The Fifth Discipline', 1990) rests on five disciplines — personal mastery, mental models, shared vision, team learning and systems thinking, the fifth that integrates the rest; Argyris distinguished single-loop learning (correct the error) from double-loop learning (question the governing assumptions). Intellectual capital (Edvinsson and Malone; Stewart) is human, structural and relational capital, and the Skandia Navigator was the first attempt to report it.

Models for managing technological change
ModelWhat it says
Technology S-curve (Foster, 1986)Performance rises slowly, then rapidly, then plateaus at a technology's limit; a new technology starts a new curve below the old one and overtakes it — the discontinuity firms miss
Diffusion of innovations (Everett Rogers, 1962)Adopters over time: innovators 2.5%, early adopters 13.5%, early majority 34%, late majority 34%, laggards 16%; adoption depends on relative advantage, compatibility, complexity, trialability, observability; Moore's 'chasm' between early adopters and early majority
Technology acceptance model — TAM (Fred Davis, 1989)Perceived usefulness and perceived ease of use determine attitude, intention and actual use; UTAUT (Venkatesh, 2003) adds social influence and facilitating conditions
Disruptive innovation (Clayton Christensen, 1997)Cheaper, simpler technologies serving the low end or new markets improve until they displace incumbents who over-served their best customers ('The Innovator's Dilemma')
Technology-organisation-environment — TOE (Tornatzky and Fleischer, 1990)Firm-level adoption depends on the technology's traits, the organisation's size, slack and structure, and the environment's competition and regulation
Socio-technical systems (Trist and Bamforth, Tavistock, 1951)Technology and the social system of work must be jointly optimised; the Durham coal-mine study; basis of autonomous work groups

Managing technological change in practice follows the general change models — Lewin's unfreeze-change-refreeze, Kotter's eight steps — applied to technology: a clear business case, top-management sponsorship, user involvement in design, pilots before roll-out, training and support, redesign of jobs and processes rather than automating the old ones (Hammer's business process re-engineering), attention to resistance (fear of job loss, deskilling, loss of control, habit) and measurement of adoption. Industry 4.0 (the term from Germany's 2011 Hannover Fair) bundles the current wave — cyber-physical systems, the Internet of Things, cloud, big data, AI, additive manufacturing, robotics and digital twins; Industry 5.0 (European Commission, 2021) adds human-centricity, sustainability and resilience. Digital transformation is the reshaping of business models, not merely the digitisation of documents (converting analogue to digital) or the digitalisation of processes.

🎯 Why tacit knowledge is the hard part
A manual can be copied; a master craftsman's feel cannot. That is why KM systems built only on repositories (codification) fail in firms whose value lies in judgement — consultancies, R&D — and why Nonaka put socialisation and externalisation first: knowledge is created when tacit insight is surfaced through dialogue and then codified, not when documents are filed. It is also why leavers take knowledge with them, and why exit interviews, mentoring and communities of practice are KM tools as much as databases are.

Key takeaways

  • Information systems climb from TPS (operational, records transactions) through MIS (structured problems, scheduled reports) and DSS (semi-structured, interactive what-if, user-driven) to EIS (top management dashboards); expert systems pair a knowledge base with an inference engine.
  • Gorry and Scott Morton crossed Anthony's levels with Simon's problem structure; Nolan gave the six-stage growth model; a DSS has a database, model base and dialogue (Sprague and Carlson), and runs what-if, sensitivity, goal-seeking and optimisation.
  • AI: Dartmouth 1956, Turing test 1950; machine learning is supervised (labelled), unsupervised (clustering, association) or reinforcement (rewards); deep learning and generative AI (transformers 2017, ChatGPT 2022); big data = volume, velocity, variety (Laney 2001) plus veracity and value; analytics runs descriptive → diagnostic → predictive → prescriptive.
  • Data warehouse (Inmon): subject-oriented, integrated, time-variant, non-volatile, fed by ETL; Inmon top-down versus Kimball bottom-up; star schema = fact table plus dimensions, snowflake normalises them; OLTP runs the business, OLAP (Codd 1993) analyses it with slice, dice, drill-down, roll-up.
  • Data mining is the analysis step of KDD: classification, regression, clustering, association (Apriori; support, confidence, lift > 1), anomaly detection; CRISP-DM is the six-phase process; overfitting is the hazard.
  • Tacit versus explicit knowledge (Polanyi); Nonaka's SECI — socialisation, externalisation, combination, internalisation; Senge's five disciplines with systems thinking the fifth; technological change is read through the S-curve, Rogers' adopter categories (2.5/13.5/34/34/16), Davis's TAM, Christensen's disruption, TOE and socio-technical design, with Industry 4.0 the current wave.

Practice questions (12)

Attempt each one before opening the answer. Every explanation names the tempting wrong option as well as the right one, because that is where marks are lost.

  1. An information system that records routine daily transactions such as sales, payroll and inventory movements and serves the operational level is a:

    1. Decision support system
    2. Transaction processing system
    3. Executive information system
    4. Expert system
    Show answer

    Answer: B — Transaction processing system

    The TPS is the base of the pyramid and the data source for MIS, DSS and EIS above it. DSS supports semi-structured decisions interactively, EIS serves top management, an expert system reproduces specialist reasoning.
  2. Which statement correctly distinguishes a decision support system from a management information system?

    1. A DSS produces scheduled standard reports; an MIS is interactive and model-based
    2. A DSS is interactive and model-based for semi-structured problems; an MIS gives scheduled reports on structured problems
    3. A DSS serves only clerical staff; an MIS serves only top management
    4. There is no difference; the terms are interchangeable
    Show answer

    Answer: B — A DSS is interactive and model-based for semi-structured problems; an MIS gives scheduled reports on structured problems

    In the Gorry and Scott Morton framework MIS addresses structured problems with periodic reports driven by the system, while DSS addresses semi-structured problems with what-if analysis driven by the user.
  3. The stage model describing an organisation's growth in the use of computing through initiation, contagion, control, integration, data administration and maturity was proposed by:

    1. Richard Nolan
    2. Gordon Davis
    3. Herbert Simon
    4. Bill Inmon
    Show answer

    Answer: A — Richard Nolan

    Nolan's stages of growth model (1973, six stages by 1979). Davis defined MIS, Simon classified decisions as structured to unstructured, Inmon is the father of the data warehouse.
  4. Grouping customers into segments from purchase data that carry no pre-assigned labels is an example of:

    1. Supervised learning (classification)
    2. Unsupervised learning (clustering)
    3. Reinforcement learning
    4. Prescriptive analytics
    Show answer

    Answer: B — Unsupervised learning (clustering)

    Without labels the task is to discover structure — unsupervised learning by clustering (k-means). Classification needs labelled training data; reinforcement learning learns from rewards; prescriptive analytics recommends actions.
  5. The original three Vs used to characterise big data are:

    1. Volume, velocity, variety
    2. Value, veracity, validity
    3. Volume, value, visibility
    4. Velocity, virtue, volatility
    Show answer

    Answer: A — Volume, velocity, variety

    Doug Laney's 2001 note gave volume, velocity and variety; veracity and value were added later. Analytics on such data climbs from descriptive to prescriptive.
  6. Bill Inmon defined a data warehouse as a collection of data that is subject-oriented, integrated, time-variant and:

    1. Volatile
    2. Non-volatile
    3. Application-oriented
    4. Normalised
    Show answer

    Answer: B — Non-volatile

    Non-volatile: data are loaded periodically and not changed by transactions, so history is preserved. Operational OLTP databases are current, volatile, application-oriented and normalised — the opposite on every count.
  7. In a dimensional data warehouse design, the schema in which a central fact table is linked directly to denormalised dimension tables is called a:

    1. Snowflake schema
    2. Star schema
    3. Relational third normal form
    4. Hierarchical schema
    Show answer

    Answer: B — Star schema

    Kimball's star schema: measures in the fact table, descriptive attributes in surrounding dimensions. A snowflake further normalises the dimensions into sub-tables; 3NF is Inmon's form for the enterprise warehouse, not the marts.
  8. Of 1,000 transactions, 200 contain bread, 150 contain butter and 100 contain both. The confidence of the association rule bread → butter is:

    1. 10%
    2. 15%
    3. 50%
    4. 66.7%
    Show answer

    Answer: C — 50%

    Confidence = transactions with both ÷ transactions with bread = 100/200 = 50%. Support is 100/1,000 = 10%; lift = 0.50/0.15 = 3.33, well above 1, so the association is real. Apriori is the classic algorithm.
  9. In Nonaka and Takeuchi's SECI model, the conversion of tacit knowledge into explicit knowledge through dialogue, metaphor and documentation is called:

    1. Socialisation
    2. Externalisation
    3. Combination
    4. Internalisation
    Show answer

    Answer: B — Externalisation

    Socialisation is tacit to tacit (shared experience), externalisation tacit to explicit, combination explicit to explicit (systemising documents), internalisation explicit to tacit (learning by doing). The spiral repeats through the four.
  10. In Peter Senge's learning organisation, the 'fifth discipline' that integrates the other four is:

    1. Personal mastery
    2. Shared vision
    3. Systems thinking
    4. Team learning
    Show answer

    Answer: C — Systems thinking

    'The Fifth Discipline' (1990) names personal mastery, mental models, shared vision, team learning and systems thinking; the last sees wholes and feedback loops and binds the others together.
  11. According to Everett Rogers' diffusion of innovations, the 'early majority' constitutes approximately what share of eventual adopters?

    1. 2.5%
    2. 13.5%
    3. 34%
    4. 16%
    Show answer

    Answer: C — 34%

    Rogers (1962): innovators 2.5%, early adopters 13.5%, early majority 34%, late majority 34%, laggards 16%, following a normal curve. Moore's 'chasm' lies between the early adopters and the early majority.
  12. The Technology Acceptance Model, which explains use of a new system by perceived usefulness and perceived ease of use, was proposed by:

    1. Clayton Christensen
    2. Fred Davis
    3. Everett Rogers
    4. Michael Hammer
    Show answer

    Answer: B — Fred Davis

    Davis (1989) built TAM on the theory of reasoned action; UTAUT later extended it. Christensen gave disruptive innovation, Rogers the diffusion of innovations, Hammer business process re-engineering.