Chapter 8: Technology Management Flashcards
What is the Head of IT sometimes known as?
CTO - Chief Technology Officer
CIO - Chief Information Officer
Who is the head of Production Support?
Reporting into CIO/CTO, responsible for server and desktop facilities
What is and what is the role of a DBA?
Who do they report to?
Database administrators, manage database, SQL, back-ups
Report to head of Production Support
Who do help-desk analysts report to?
Head of Production Support
What is the Head of Development and Implementation and who reports into them (3) and who do they report into?
Reports into CIO
Responsible for commissioning new applications internal and external
Report into Head of Development and Implementation
Business analysts
Application designers
Programmers
What is the Head of Testing? What are they responsible for? Who reports into them
Reports into CIO
Responsible for testing new software
Implementing change control procedures
Test analysts report into them
What is the Head of Change and who reports into them (2) and who do they report into?
Reports to the CIO and can report into COO
Responsible for managing major change programs and projects
Run matrix teams, staff from multiple areas
Report into Head of Change
Programme managers
Project managers
What is the Head of Information Security (or Chief Information Security Office (CISO))
What regulation do they need to be aware of?
Reports to CIO
Responsible for security of computing services in the firm
Must know GDPR, previously Data Protection Act (DPA 1998)
What is a thin and fat client?
Thin client - web based interaction
Fat client - application based interaction
What is the Application sometimes known as?
Logic engine or Business rules
validate a trade, create a customer, obtain a customer’s details
What is the Middleware/Real-Time Messaging Layer?
Software that distribute and obtain real-time data to and from other parties
internally & externally
matching updates
What is the most common type of database?
relational database
How do relational databases work?
Contain a number of tables and relationships between them.
E.g. customers, holdings, and trades
Each one will have a table
relationships will determine how these are linked.
Each trade must have a holding, each holding must have a customer etc
What kind of databases are used for massive data sets?
OODBs, Object Oriented Databases
What is the most common method used to interface with regional databases?
SQL
What does SQL stand for?
Structured Query Language
There are SQL statements to obtain, insert, update and delete rows from tables – as well as creating, deleting and altering tables and columns
What are some software products that allow non-technical users to develop reports over databases?
ORACLE, IBM’s DB2, Sybase (SAP), Microsoft’s SQLServer and the open-source product MySQL (ORACLE)
What is the flow for creating a customer using SQL?
Customer inputs details
Application component validates the data
If all valid, applications with pass data to Database where a row will be added to the relevant tables
Application can pass data to Middleware component that can send email to customer
What is a distributed system?
Hardware that is connected by some form of transmission.
What are the problems with distributed systems?
Keeping all systems sychronised
Predicting performance
Limiting risks
What is data replication?
Sharing information to ensure consistency across software or hardware.
What two categories can the governance of risk management in IT be divided into?
maintaining ‘business as usual’ activities
introducing business change
What is benefits realisation?
benefits of a project must be documented and quantified and measured
