13 IT Software, Data, & Contingency Planning Flashcards
What is systems software?
Systems software performs the fundamental tasks needed to manage computer resources.
What are the 3 most common pieces of systems software?
- Operating system - which is the “traffic cop” of any computer system. The operating system negotiates the conversation between the computer’s hardware, the application the user is running, and the data that the application is working with.
- Utility programs - perform basic functions that are not particular to a certain application, such as anti-virus, file management, and network utilities.
- Device driver programs - operate or control a particular type of device that is attached to the computer. Ex - a printer requires a printer driver to function.
What is application software?
Programs designed to help people perform an activity that can manipulate text, numbers, graphics, or a combination of these elements. Ex - word processors, spreadsheets, graphics, and databases. Applications found on dedicated servers are payroll, human resources, purchasing, accounts payable, general ledger, treasury, etc.
What is machine learning?
A form of artificial intelligence that enables computers, when exposed to new data, to learn, grow, change, and develop by themselves. The ability to adapt to new data by learning from previous computations and identifying trends in order to produce reliable results.
What is a blockchain?
A type of digital database (or ledger) that provides proof of who owns what at any moment in time as each transaction has been added to the ledger. The ledger is encrypted, public, and distributed widely for anyone to view. Every transaction makes the ledger grow larger. It is an innovative technology that has the potential to revolutionize accounting.
What is cryptocurrency?
Cryptocurrency is a digital asset designed to be a medium of exchange using cryptography (encryption) to secure the transactions, control the creation of additional units of the currency, and verify the transfer of funds. Bitcoin is a type of cryptocurrency.
What is a consensus mechanism?
A key element of a blockchain is a consensus mechanism. It is a cryptographic process that takes control of the ledger from one party (the firm) and allows it to be examined and maintained by multiple independent entities. No centralized organization controls the chain. The official chain is agreed upon by a majority of the participating miners. Ex - blockchains and consensus mechanisms are similar to google Docs. Users in a Google Doc can edit documents at the time, and the most updated versions are always available. All users of the document must agree to any changes made.
What is a key in a database?
A key contains enough information to uniquely identify each record, there can be no two records with the same key.
What is a flat file?
The oldest file structure is the flat file, in which all records are stored sequentially, one after the other, as on a reel of magnetic tape. To find a certain record, every record on the tape has to be searched and bypassed until the desired one is found.
What are hierarchical databases?
Instead of records being strung out one after the other, they form “branches” and “leaves” extending from a “root”. The hierarchical, or tree, database model was a major development in file organization. The tree structure improves speed and storage efficiency for related data. Ex - a parent record consisting of a customer may directly index the child records containg the customer’s orders.
What are relational databases?
Relational databases are tables, and the columns are attributes.
What is structured query language (SQL)?
Structured query language is a database management language used to manage data in a relational database. Ease data element is stored as few times as necessary. This reduction in data redundancy is accomplished through a process called normalization.
What is cardinality?
Cardinality refers to how close a given data element is to being unique. A data element that can only exist once (a unique element) in a given table has high cardinality. A data element that is not unique in a given table but that has a restricted range of possible values is said to have normal cardinality. A data element that has a very small range of values is said to have low cardinality.
What is referential integrity?
Referential integrity means that for a record to be entered in a given table, there must already be a record in some other table.
What are primary keys?
The data fields in a table that uniquely identify the records in the table.
What are foreign keys?
The data fields or groups of data fields that reference a primary key in another table.
What are the three relationships referenced between primary and foreign keys?
- one-to-one - a foreign key can only link to one primary key, and vice versa.
- one-to-many - a foreign key can link to many primary keys, but a primary key can only link to one foreign key.
- many-to-many - a foreign key can link to many primary keys, and a primary key can also link to many foreign keys
What are non-relational databases?
Non-relational databases provide a mechanism for storage and retrieval of data other than the tabular relations used in relational databases. The data structures used by NoSQL databases do not require joining tables, which allow operations to run much faster.
What is an object-oriented database?
An object-oriented database stores objects along with the executable code that directs the behavior of the object. An object-oriented database is a response to the need to store graphics and multimedia applications used by object-oriented programming languages such as C++ and Java.
What are data lakes?
Data lakes store all structured, semi-structured, and unstructured data, regardless of format or source into one data repository. The stored data are raw data that have not already bee processed for a particular reason.
What are the two types of loading data?
Initial load and incremental load
What is initial load?
Initial load involves processing data from the source database for the first time and may require an extensive amount of time to load into the target database depending on the volume of data.
What is incremental load?
Incremental load is representative of the process of loading data from the source database to the target database subsequent to the initial load such as new or revised data. Maintenance of load dates is vital to ensure only new or revised data are loaded to the target database after the most recent data extraction from the source database.
What is full refresh?
Full refresh completely wipes out data of one or multiple sections of the database and loads new data into the database.
What is load verification?
Load verification involves examining the data before and after loading to the target database to determine whether the data completely loaded and whether any discrepancies exist.
What is a database management system (DBMS)?
A DBMS is an integrated set of software tools superimposed on the data files that helps maintain the integrity of the underlying database.
What is a schema?
A particular database’s design. A schema consists of the layouts of the tables and the constraints on entering new records. To a great extent, a DBMS automates the process of enforcing the schema.
What are the two vital parts of any DBMS (database management system)?
- A data definition language (DDL) - allows the user to specify how the tables will look and what kinds of data elements they will hold
- A data manipulation language (DML) - which the DBMS retrieves, adds, deletes, or modifies records and data elements.
Both of these roles are commonly fulfilled in the current generation of database management systems by SQL or one of its many variants.
What is the data dictionary?
The data dictionary contains the physical and logical characteristics of every data element in a database. The data dictionary contains the size, format, usage, meaning, and ownership of every data element as well as what persons, programs, reports, and functions use the data element.
What is an organizational needs assessment?
A detailed process of study and evaluation of how information systems can be deployed to help an organization meet its goals.
What are the steps of an organizational needs assessment?
- determine whether current systems support organizational goals
- determine needs unmet by current systems
- determine the capacity of current systems to accommodate projected growth
- propose a path for information systems deployment to achieve organizational goals within budgetary constraints
What is business process reengineering?
Business process reengineering involves a complete rethinking of and changes to how business functions are performed to provide value to customers, that is, radical innovation instead of mere improvement and a disregard for current jobs, hierarchies, and reporting relationships.
What is process automation?
Process automation refers to the automation of business processes and performance of routine tasks by mimicking the actions of humans. It involves incremental changes to how existing tasks are handled, as opposed to business process reengineering, which involves a complete and radical redesign of all tasks.
What are the roles and responsibilities of the IT steering committee?
- engaging high-level management in planning information systems and setting IT policies
- facilitating the implementation of information systems
- overseeing the control over the information systems
What is a killer application?
A killer application is one that is so useful that it may justify widespread adoption of a new technology
What is the systems development life cycle (SDLC)?
The SDLC approach is the traditional methodology applied to the development of large, highly structured application systems. A major advantage of the life-cycle approach is enhanced management control of the development process.
What are the 5 stages of the systems development life cycle (SDLC)?
- systems strategy - which requires understanding of the organization’s needs
- project initiation - the process by which systems proposals are assessed
- in-house development - generally chosen for unique information needs
- commercial packages - generally chosen for common needs rather than developing a new system from scratch
- maintenance and support - involves ensuring the system accommodates changing user needs
Once the need for a new system has been recognized, what are the 7 steps of the SDLC?
- need for new system recognized
- requirements analysis/definition
- system design
- build/development
- testing/quality control
- acceptance/installation/implementation
- operations/maintenance
What is the first phase and component step of the traditional SDLC?
- initiation, feasibility, and planning - recognizing the need for a new system, understanding the situation to determine whether it is feasible to create a solution, and formulating a plan.
What is the second phase and component step of the traditional SDLC?
- requirements analysis and definition - a formal proposal is submitted to the IT steering committee, describing the need for the application and the business function(s) that it will affect. Feasibility studies are conducted to determine - what technology the new system will require, what economic resources must be committed to the new system, how the new system will affect current operations. The steering committee gives its go-ahead for the project.
What is the third phase and component step of the traditional SDLC?
- system design - logical design consists of mapping the flow and storage of the data elements that will be used by the new system and the new program modules that will constitute the new system. Data flow diagrams, system interface diagrams, and structured flowcharts are commonly used in this step. Some data elements may already be stored in existing databases. Good logical design ensures that they are not duplicated.
Physical design involves planning the specific interactions of the new program code and data elements with the hardware platform (existing or planned for purchase) on which the new system will operate.
Systems analysts are heavily involved in these two steps.
What is the fourth phase and component step of the traditional SDLC?
- build and development - the actual program code and database structures that will be used in the new system are writte. Hardware is acquired and physical infrastructure is assembled.