The old Bolton Institute for Higher Education (BIHE) building
My final year project consisted of an ORACLE SQL-forms designed GUI interface running under an MS-DOS operating system. The GUI interface provided insert, update, delete and transaction rollback facilities for recording information about students attending courses at BIHE, along with their module assignment and exam result details.
The student data was held in an ORACLE SQL database set-up on a PC local to the application. The tables were designed in accordance with Third Normal form (TNF) design methodology in order to cancel out repeating student data. The resulting application catered for both snapshot and historical reports. System analysis work was carried out using SSADM (Structured Systems Analysis and Design Methodology).
HP NonStop refers to the line of fault-tolerant servers and software originally developed by Tandem Computers and now owned by Hewlett Packard Enterprise (HPE). These systems are designed for continuous operation and uninterrupted transaction processing by using redundant hardware components and independent processors to automatically failover in the event of a failure, ensuring high availability for critical applications in banking, telecommunications, and healthcare.
Origins and Evolution
Tandem Computers: Founded in 1974, Tandem introduced the NonStop system, a pioneering fault-tolerant computer with no single point of failure, revolutionizing continuous availability for online transaction processing.
Acquisitions: Tandem Computers was acquired by Compaq in 1997, and Compaq was later acquired by Hewlett-Packard (HP) in 2001.
Current Ownership: After the split of HP into Hewlett Packard Enterprise (HPE) and HP Inc. in 2015, the NonStop product line became part of HPE.
Key Features and Uses
Fault Tolerance: The systems are built with redundant components, including identical processors and storage devices, allowing them to automatically detect and recover from hardware or software failures without interruption.
High Availability: This fault-tolerant architecture is ideal for mission-critical applications that require constant uptime, such as financial transactions, emergency services, and large-scale banking systems.
Scalability: NonStop systems are designed for scalability, able to handle large commercial workloads by adding independent processors.
Specialized Database: The line includes NonStop SQL (currently SQL/MX), a relational database designed for the high availability and scalability needs of these systems.
(building below demolished 2007 and now rebuilt at the Leigh Sports Village – 1, 2, 3, 4 article by Julie McKiernan courtesy of PastForward, produced by Wigan Archives & Museums, Issue No. 97, August – November 2024, Marking 50 years of the borough, Wigan and Leigh’s local history magazine – Address: Past Forward, Archives, Wigan & Leigh, Leigh Town Hall, Mark Street, Leigh, WN7 1DY)
My ‘A’ Level Computing Project was developed on a Amstrad PC 1512 and was written in Turbo Pascal. The software provided a means for a local town newspaper to store, track and calculate the money payable to delivery staff based on paper round metrics. These metrics related to size of round, papers delivered and any leaflets attached to a delivery for that week.
My ‘O’ Level Computing Project was developed on a LINK 480Z Research Machine and was written in Extended BASIC. Three submissions were required with appropriate design and testing. The excerpts here show details of a BASIC program for storing and displaying student exam results.