PPB Module CChapter Notes4–6 Marks Expected

Essentials of Bank Computerisation

Principles & Practices of Banking | Module C · Chapter 42

Module C begins with the technology backbone of modern banking. This chapter traces computerisation from the 1983 Rangarajan Committee, through stand-alone to multi-user systems, LAN/WAN networking, network topologies and devices, UPS protection, Core Banking Solution (CBS), and data warehousing and mining.

By Bankopedia.co.inUpdated 2026JAIIB PPB · Module C

📌 Why This Chapter Matters in JAIIB

Expect 4–6 questions from this chapter. Key focus areas: Rangarajan Committee (1st report 1984 — bank mechanisation; 2nd committee 1988 — 5-year plan 1990–94); 4 objectives of bank computerisation(customer service, housekeeping, decision-making, productivity & profitability); network topologies (bus = single cable, ring = closed loop one-direction, star = central master, tree = hierarchical); CSMA/CD vs Token Ring; UPS types (online vs offline); CBS payment system interfaces (SFMS, RTGS, NEFT, CTS, NACH, IMPS, UPI); OLTP vs OLAP (CBS = OLTP; data warehouse = OLAP); data warehouse characteristics (subject-oriented, non-volatile, integrated, time-variant — 5–10 years); data mart vs data lake vs data warehouse.

Key Facts & References — Chapter 42 at a Glance

Bank computerisation started:1980–81 (conceptual); brisk adoption after 1983 Rangarajan Committee

1st Rangarajan Committee:1983 (chaired by Dr. C. Rangarajan, Deputy Governor RBI); report in 1984 — 'First Rangarajan Committee Report on bank mechanisation'

2nd Rangarajan Committee:1988; drew 5-year computerisation plan for 1990–94

4 objectives of computerisation:Customer service; Housekeeping; Decision-making; Productivity & profitability

Stand-alone systems (ALPM):Automatic Ledger Posting Machines; advantages: low cost, simple software, easy training; disadvantages: slow speed, low storage

LAN distance (Cat5e):Does not generally extend beyond 100 metres

Bus topology:Single continuous cable; easy setup; one node failure does NOT affect rest; limited geographic spread

Ring topology:Closed loop; data in ONE direction; breakdown of ANY ONE station disables entire LAN

Star topology:All nodes connected to central master; one node failure does NOT affect network; cannot handle large traffic

Tree topology:Hierarchical — root → intermediate → leaf nodes; any node can have any number of child nodes

CSMA/CD (Ethernet):Carrier-Sense Multiple Access with Collision Detection; listen-before-transmit; on collision, halt and retry after random wait

Token Ring:Deterministic media-access; token circulates when idle; station seizes token to transmit; data does full round then token freed

Key network devices:NIC, Switch, Bridge, Router, Gateway, Firewall, WAP, Multiplexer (MUX)

Router vs Gateway:Router: forwards data packets between similar networks. Gateway: connects two dissimilar networks; acts as gate/node entry point

WAN microwave range:Dish-to-dish max ~40 km; broadband transmission

Online UPS:Always converts mains AC → DC → AC; instant (no interruption) switchover on power failure

Offline UPS:Normal use: mains supply; switches to battery via electronic changeover in milliseconds on failure

UPS protects from:Blackouts, brownouts (voltage dip), swells (overvoltage), sags (10%+ drop), surges

CBS payment interfaces:SFMS, RTGS, NEFT, CTS, NACH, IMPS, UPI

CBS primary WAN link:Leased lines / MPLS (Multi-Protocol Label Switching); backup: Leased Lines, VSAT, RF (different vendor)

Disaster Recovery Site (DRS):Maintains CBS continuity during central system or network failures; ensures non-stop branch/delivery channel operation

CBS = OLTP:On-line Transaction Processing: insert/update/delete; large number of users, large number of transactions

Data Warehouse = OLAP:Online Analytical Processing: analytical queries; historical data; subject-oriented, non-volatile, integrated, time-variant (5–10 years)

Data Mart:Simple form of data warehouse; single subject/line of business (sales, finance, marketing); fewer sources

Data Lake:Stores raw data without predefined structure; for real-time analytics, data science, machine learning

Data Mining:Process of automatically finding patterns and relations in large databases (data warehouses); used for credit risk, customer analytics, stock portfolio, insurance risk

History, Objectives & Types of Computerisation

Free

42.2 History of Bank Computerisation

Pre-1983:Banks had a passive view on computerisation; most functions were manual.

1980–81:Concept of bank computerisation practically began.

1983:First Rangarajan Committee constituted under Dr. C. Rangarajan (then Deputy Governor, RBI) to study possibilities and stages of bank computerisation.

1984:Committee submitted its report — known as the First Rangarajan Committee Report on bank mechanisation. Computerisation gained momentum from 1983–84.

1988:Second committee constituted under Dr. C. Rangarajan to draw up a perspective plan for bank computerisation for a five-year period: 1990–94.

42.2.1 Four Objectives of Bank Computerisation

👤

Customer Service

📚

Housekeeping

🎯

Decision-making

📈

Productivity & Profitability

42.2.2 Stand-alone Computer Systems (ALPMs)

Initial phase — Automatic Ledger Posting Machines

Advantages

✓Low equipment cost
✓Less complicated software
✓Easy operational training
✓Better security & control

Disadvantages

✗Slow processing speed
✗Low data storage capacity
✗Cannot be used in multi-user environment

42.2.3 Multi-User Systems & Centralised Processing

▸Central server processes information; multiple terminals (clients/nodes) connect through a network.
▸All information stored and processed centrally; works on time-sharing basis.
▸OS: typically UNIX; database: RDBMS.
▸Centralised advantages: anywhere/anytime banking; corporate data at branch level; full resource utilisation.
▸Phase 1: Branch-level mechanisation (ALPMs — not interconnected, General Ledger still manual).
▸Mid-90s: Total Branch Automation — single window concept; EFT (Electronic Fund Transfer); online updates with no time lag.

Networking Technologies — LAN, Topologies & WAN

Free

42.3.1 Local Area Network (LAN)

A LAN is an interconnected system of autonomous computers within a limited area (generally not beyond 100 metres for Cat5e cables). Each computer is a node; one central node (Server) provides and controls all network services. Clients route requests to the server. Key elements: sharing common cabling and pooling resources within a workgroup.

LAN Advantages

✓Single window concept
✓Resource sharing (printers, scanners)
✓Central server data available to all — no database duplication
✓Processing load distributed — no overloading

LAN Disadvantages

✗Complicated data management software
✗Higher security risks (each user accesses host independently)
✗High maintenance cost

42.3.2 Network Topologies

Bus Topology

▸All devices connected to a SINGLE CONTINUOUS CABLE.
▸Transmission travels entire cable in both directions; received by all.
▸Easy to set up.
▸One workstation failure does NOT affect the rest.
▸Disadvantages: limited geographic spread; limited flexibility.

Ring Topology

▸Devices connected in a CLOSED LOOP.
▸Data passes from one node to another IN SERIES.
▸Data transmission in ONE DIRECTION only.
▸Destination recognises its address and copies packet.
▸Breakdown of ANY ONE station disables the entire LAN.

Star Topology

▸Central node acts as MASTER; all other nodes connect to it.
▸One node failure does NOT affect the network.
▸Centralised control.
▸Disadvantage: CANNOT handle large traffic (all transactions pass through central node).

Tree Topology

▸HIERARCHICAL structure — root → intermediate → leaf nodes.
▸Root node is the head; leaf nodes have no child nodes.
▸Any node can have any number of child nodes.
▸Resembles a tree; used in distributed organisations.

42.3.4 Wide Area Network (WAN)

▸Covers sizeable geographic area using telecommunication networks; lower speed/capacity than LAN.
▸In banks: connects branches → regional/zonal offices → head office.
▸Each computer needs: telecom line + modem + communication software; modem converts digital ↔ analog.
▸Microwave: dish-to-dish, broadband, max ~40 km per relay station; each relay boosts signal.
▸Satellite: radio waves to satellite → earth station/antenna; text, data, voice, video; transmission in a fraction of a second.
▸Dial-up networks and VSAT are also options for connectivity.

Network Protocols, Devices & UPS

Members Only

42.3.3 Network Protocols

CSMA/CD (Ethernet)

Carrier-Sense Multiple Access with Collision Detection

▸Listen-before-transmit: stations transmit only when channel is clear.
▸If two stations try to transmit simultaneously → collision occurs.
▸On collision: all stations halt transmission and wait for a RANDOM period before retransmitting.
▸Used in Ethernet (LAN) systems.

Token Ring

Deterministic Media-Access Control

▸Token circulates continuously when all stations are idle.
▸Station wishing to transmit waits for token, seizes it, transforms it into start-of-packet.
▸Data packet makes a complete round on the ring; destination copies data bits.
▸When packet returns to source, data bits removed and token is freed.
▸Data travels in ONE direction only.

Network Devices

Device	Function
NIC (Network Interface Card)	Hardware component connecting a computer to a network (also called Network Interface Controller or Network Adapter).
Switch	Hardware connecting multiple devices on a single network; routes information to the correct destination.
Bridge	Creates a single aggregate network from multiple networks; connects two separate networks as if one.
Router	Forwards data packets between computer networks; directs internet traffic; routes via similar networks.
Gateway	Connects two DISSIMILAR networks; acts as gate/entry node; unlike router (routes similar networks).
Firewall	Network security system monitoring and controlling incoming/outgoing traffic based on security rules; barrier between trusted and untrusted networks.
WAP (Wireless Application Protocol)	Communication protocol standard for wireless devices (mobile phones, radio transceivers) to access internet services.
Multiplexer (MUX)	Sends digital/analog signals at higher speed on a single shared line; recovers separate signals at receiving end; boosts/amplifies signals.

42.4 Uninterrupted Power System (UPS)

A UPS protects IT assets (servers, electrical equipment, network equipment) at branches and data centres from power blackouts, brownouts (voltage dip then return), swells (overvoltage lasting seconds/minutes), sags (short drop of 10%+ below nominal), and surges (electricity interrupted then restarted). On power failure, UPS automatically takes over supply to prevent data loss. General feature: inverter + battery charger with automatic changeover (mains ↔ battery).

Online UPS

Mains AC (230V) is continuously converted → DC → AC even when mains supply is available. On power failure, batteries supply the Data Centre instantly with NO interruption. Returns to normal automatically when mains recovers. Used in bank data centres.

Offline UPS

Normal supply: mains powers the system. On failure: electronic changeover switches to battery supply. Changeover takes a few milliseconds (brief interruption). Less expensive than online UPS; suitable for workstations and terminals.

Core Banking Solution (CBS)

Members Only

Core Banking uses a centralised branch computerisation model. Branches connect to a central host that incorporates branch automation modules and online multiple delivery channels (ATM, debit card, telebanking, mobile banking, internet banking) under one roof. A single banking software operates on the bank's intranet infrastructure using a WAN. Transactions are done online centrally; integrated products and services are offered to customers round the clock.

42.5.1 Business Components of CBS

▸Retail customer banking modules

▸Deposits, loans, bills, remittances, locker, clearing

▸Trade finance / forex modules

▸Government business modules

▸Corporate finance and service branch modules

▸Enhanced MIS modules; business intelligence modules

▸Integration with ATMs, POS, telebanking, internet banking, mobile banking, debit cards, kiosks

▸Any branch banking, internet banking, call centre

▸Interface with corporate systems: treasury, IBR, centralised accounting, HRMS, ALM, credit appraisal/monitoring, NPA management

▸Interface with payment systems: SFMS, RTGS, NEFT, CTS, NACH, IMPS, UPI

42.5.2 Benefits of CBS

✓24×7 services from any branch/delivery channel
✓Reliable centralised data repository
✓Enables data warehousing and data mining
✓Centralised MIS, DSS, Executive Info Systems, ALM, Risk Management
✓Integrated customer-centric services (online ATMs, telebanking, internet, mobile, kiosk)
✓Standardisation — single version of branch software; changes only at central level
✓Alternative delivery channels are cheaper
✓Core infrastructure reusable for future expansions

Primary Data Centre Requirements

▸Houses central servers for online transactions
▸Redundant power backup: Generators + UPS
▸Communication network connecting all branches
▸Central database for all customer-centric delivery channel services
▸Manned 24×7 for system administration, network monitoring, backups, troubleshooting

Disaster Recovery Site (DRS)

▸Maintains continuity of CBS branches during central system or network failures.
▸Ensures non-stop functioning of branches and online delivery channels.
▸Many multinational IT companies have presence in such DRS centres.
▸Business Process Re-engineering (BPR): realigns existing business processes to leverage the new technology platform and deliver enhanced customer value.

CBS Communication Infrastructure

▸Primary WAN link: Leased lines / MPLS (Multi-Protocol Label Switching) cloud — for efficiency and redundancy.
▸Backup lines (from a different vendor): Leased Lines, VSAT (Very Small Aperture Terminal), RF (Radio Frequency).
▸Adequate redundancies built in to address any network failures.

Data Warehousing, Data Mining & Related Concepts

Members Only

CBS = OLTP (On-line Transaction Processing)

▸Large number of users doing large number of transactions.
▸Involves inserting, updating, and deleting small amounts of data.
▸Focused on availability and speed of banking services.
▸Data is constantly updated and dynamic.

Data Warehouse = OLAP (Online Analytical Processing)

▸Databases queried for analytical purposes.
▸Helps banks extract insights from transaction data for informed decisions.
▸Historical data stored in a subject-oriented manner conducive for queries.
▸Data from CBS stored in data warehouse for analytics and reporting.

42.6 Data Warehouse — 4 Characteristics

Subject-Oriented

Organised around key subjects like customers, products — stores all data including transactions of all types pertaining to a customer.

Non-Volatile

Instances of data at various points in time (e.g. daily) are stored statically. Unlike OLTP where data is constantly updated.

Integrated

Data is integrated from multiple sources — no inconsistencies; uniform naming conventions and formats.

Time-Variant

Time zone is significantly longer — typically 5 to 10 years of historical data stored, enabling trend analysis.

Data Mart vs Data Lake vs Data Warehouse

Concept	Scope	Data Structure	Use Case
Data Warehouse	Entire organisation	Structured; well-defined purpose	Business intelligence, analytics, regulatory reports
Data Mart	Single subject or line of business (sales, finance, marketing)	Structured; fewer sources	Departmental analytics; simpler form of warehouse
Data Lake	Enterprise-wide	Raw, unstructured — no predefined schema	Real-time analytics, data science, machine learning; data ingested in original form

Data Mining

Data mining is a technique to reveal strategic information hidden in data warehouses. It is the process of automatically finding patterns and relations in large databases. Patterns can be: organised into a concise model; provide summaries of large data; used to refine an existing model. Provides insight on: sound predictions of customer behaviour; highly targeted market focus; maximised operational effectiveness; optimal return on investment.

Banking applications of data mining:

▸Credit card analysis — determine whom to solicit, whether to approve each transaction, and credit limits to assign.
▸Credit risk analysis — risk assessment for issuing cards and approving transactions.
▸Stock portfolio creation — analyse performance of securities and company fundamentals.
▸Customer demographic analysis — helps banks focus on particular customer segments.
▸Risk analysis — used by insurance companies and banks.

Chapter Summary & Flashcards

Members Only

Chapter 42 in 6 Lines

Computerisation started 1980–81; First Rangarajan Committee (1983, report 1984 — bank mechanisation); Second committee (1988 — 5-year plan 1990–94). Four objectives: customer service, housekeeping, decision-making, productivity & profitability.
Phase 1: stand-alone ALPMs — low cost, simple software, easy training; but slow and no multi-user. Phase 2: multi-user/centralised (UNIX, RDBMS, time-sharing). Mid-90s: Total Branch Automation — single window, EFT, online updates with no time lag.
LAN (max 100m Cat5e): server + nodes; key: shared cable, pooled resources. Topologies — Bus: single cable, one failure safe; Ring: closed loop, one direction, any-station failure disables whole LAN; Star: central master, one failure safe; Tree: hierarchical root/intermediate/leaf.
Protocols — CSMA/CD (Ethernet): listen-before-transmit, random retry on collision; Token Ring: deterministic, seize token, data full round, then token freed. Key devices: NIC, Switch, Bridge, Router, Gateway, Firewall, WAP, MUX. WAN: telecom, microwave (40 km), satellite.
CBS: centralised host, single software on intranet/WAN, 24×7; interfaces with SFMS, RTGS, NEFT, CTS, NACH, IMPS, UPI; primary WAN = MPLS; backup = VSAT/RF; DRS ensures continuity. UPS: Online (no interruption) vs Offline (milliseconds changeover); protects from blackouts, brownouts, swells, sags, surges.
CBS = OLTP (insert/update/delete, dynamic data). Data Warehouse = OLAP (subject-oriented, non-volatile, integrated, time-variant 5–10 years). Data Mart: single subject, fewer sources. Data Lake: raw unstructured data for ML/data science. Data Mining: automatically finds patterns — used for credit risk, customer segments, stock portfolios, insurance risk.

Flashcards — Chapter 42

1. When did the First Rangarajan Committee on bank computerisation submit its report and what was it known as?▼

The First Rangarajan Committee was constituted in 1983 under Dr. C. Rangarajan (Deputy Governor, RBI) and submitted its report in 1984. It was known as the First Rangarajan Committee Report on bank mechanisation.

2. When was the Second Rangarajan Committee set up and what was its scope?▼

The Second Rangarajan Committee was constituted in 1988 under Dr. C. Rangarajan to draw up a perspective plan for bank computerisation for a five-year period: 1990–94.

3. What are the four objectives of bank computerisation?▼

(a) Customer service; (b) Housekeeping; (c) Decision-making; (d) Productivity and profitability.

4. What were ALPMs, and what were the main advantages and disadvantages of stand-alone systems?▼

ALPMs = Automatic Ledger Posting Machines (first-phase stand-alone systems). Advantages: low equipment cost, simpler software, easy training, better security/control. Disadvantages: slow processing speed, low data storage capacity, cannot be used in a multi-user environment.

5. What is the maximum distance for a LAN using Cat5e cables?▼

A LAN will generally not extend beyond 100 metres for Cat5e cables.

6. Describe Bus Topology and its key characteristics.▼

All devices connect to a single continuous cable. Transmission travels the full cable length in both directions and is received by all. Easy to set up. One workstation failure does NOT affect the rest. Disadvantages: limited geographic spread; limited flexibility.

7. Describe Ring Topology and what happens when one station fails.▼

Devices are connected in a closed loop; data passes from one node to another in series in ONE direction only. The destination recognises its address and copies the packet. If ANY ONE station breaks down, the entire LAN is disabled.

8. Describe Star Topology and its main limitation.▼

All nodes connect to a central master node by separate medium. One node failure does NOT affect the network. Main limitation: cannot handle large traffic, as every transaction must pass through the central node.

9. What is Tree Topology?▼

A hierarchical topology with a root node, intermediate nodes, and leaf nodes. The root is the head node; leaf nodes have no child nodes. Any node can have any number of child nodes.

10. What is CSMA/CD and how does it handle collisions?▼

Carrier-Sense Multiple Access with Collision Detection (used in Ethernet). Listen-before-transmit: stations transmit only when the channel is clear. If two stations transmit simultaneously — collision occurs; both halt and wait for a RANDOM period before retransmitting.

11. How does a Token Ring network work?▼

A token circulates continuously when all stations are idle. A station wishing to transmit waits for the token, seizes it, and transforms it into a start-of-packet sequence. The data packet makes a complete round; destination copies data bits. When the packet returns to source, data bits are removed and the token is freed. Data travels in ONE direction.

12. What is the difference between a Router and a Gateway?▼

Router: forwards data packets between similar networks (e.g. internet routing). Gateway: connects two DISSIMILAR networks; acts as a gate/entry node between very different network types. Routing lets networks communicate independently while remaining separate; bridging/gateway connects them as one.

13. What is a Firewall?▼

A network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules. It establishes a barrier between a trusted internal network and an untrusted external network (such as the internet).

14. What is the difference between Online UPS and Offline UPS?▼

Online UPS: mains AC is continuously converted to DC and back to AC (even when mains supply is available); on power failure, batteries take over INSTANTLY with no interruption. Offline UPS: normally passes mains supply; on failure, switches to battery via electronic changeover in a FEW MILLISECONDS (brief interruption).

15. What power disturbances does a UPS protect against?▼

Blackouts (complete power failure); brownouts (voltage dips then returns); swells (overvoltage lasting seconds/minutes); sags (short drop of 10% or more below nominal); surges (flow interrupted then restarted).

16. What payment systems does CBS interface with?▼

SFMS, RTGS, NEFT, CTS, NACH, IMPS, and UPI.

17. What is the primary WAN link for CBS and what are the backup options?▼

Primary: Leased lines / MPLS (Multi-Protocol Label Switching) cloud. Backup (from a different vendor): Leased Lines, VSAT (Very Small Aperture Terminal), RF (Radio Frequency).

18. What is a Disaster Recovery Site (DRS) in the context of CBS?▼

A DRS maintains continuity of business activities for CBS branches during central system or network failures, ensuring non-stop functioning of branches and online delivery channels.

19. What is the difference between OLTP and OLAP, and which environment does CBS fall under?▼

OLTP (On-line Transaction Processing): insert/update/delete operations; large number of users/transactions; data is dynamic — CBS is an OLTP environment. OLAP (Online Analytical Processing): databases queried for analytical purposes; historical data. Data Warehouses are OLAP environments.

20. What are the four characteristics of a Data Warehouse?▼

(1) Subject-oriented — organised around key subjects (customers, products); (2) Non-volatile — data stored statically at points in time, not constantly updated; (3) Integrated — consistent data from multiple sources, no inconsistencies; (4) Time-variant — stores 5–10 years of historical data for trend analysis.

21. What is a Data Mart and how does it differ from a Data Warehouse?▼

A data mart is a simple form of a data warehouse focused on a SINGLE SUBJECT or line of business (e.g. sales, finance, marketing). It draws data from fewer sources than a full data warehouse.

22. What is a Data Lake and how does it differ from a Data Warehouse?▼

A data lake stores VAST AMOUNTS OF RAW DATA without a predefined structure. Organisations need not know how data will be used in advance. Unlike a data warehouse (structured, defined purpose), a data lake stores data in its original form — suitable for real-time analytics, data science, and machine learning.

23. What is Data Mining and what are its applications in banking?▼

Data mining is the process of automatically finding patterns and relations in large databases (data warehouses). Banking applications: credit card analysis (who to solicit, approval decisions, credit limits); credit risk analysis; stock portfolio creation; customer demographic analysis (targeted marketing); risk analysis for insurance/banks.

Discussion

No comments yet. Be the first to share your thoughts.

←Ch 41: Self-Help Groups PPB Overview Ch 43: Operational Aspects of CBS Environment→