IT Infrastructure, Software, and Database Management

Comprehensive vocabulary flashcards covering IT infrastructure, hardware components, input/output technologies, software categories, database systems, and business intelligence analytics.

IT Infrastructure

The shared technology resources that provide the platform for supporting all information systems in a business, consisting of computer hardware, software, data management technology, networking and telecommunications technology, and technology services.

Data Center

A dedicated facility that houses computer systems and associated components, including telecommunications systems, storage devices, security systems, and backup power supplies.

Computer Hardware

The physical devices associated with a computer system that support the core operational activities of input, processing, output, and storage.

Bit

A binary digit representing a single $0$ or $1$, which serves as the smallest unit of data that a computer can process.

Byte

A group of $8$ or $16$ bits representing one natural language character, number, or symbol.

ASCII

An $8$-bit binary coding scheme used primarily in microcomputers to translate natural language characters into binary format.

EBCDIC

An $8$-bit binary coding scheme used primarily in mainframe computer systems to represent characters.

Unicode

A $16$-bit binary coding scheme capable of representing thousands of characters across various international languages.

Central Processing Unit (CPU)

The core hardware component (or microprocessor) that interprets and executes program software instructions while coordinating how all other hardware devices interact.

Control Unit

The component of the CPU that interprets software instructions and directs the operations of other hardware components based on those instructions.

Arithmetic-Logic Unit (ALU)

The CPU component responsible for executing arithmetic calculations (such as addition and subtraction), logical comparisons (such as sorting numbers), and storage and retrieval operations.

Registers

The smallest and fastest temporary storage locations situated directly inside the CPU that hold data, instructions, and memory addresses during execution.

Cache Memory

A small, fast temporary storage area located on or near the CPU that holds frequently accessed data and instructions to minimize retrieval delays from slower main memory or disk storage.

Machine Cycle Time

The time required by the CPU to execute a single instruction, involving the four steps of fetching, decoding, retrieving, and storing, typically measured in fractions of a second (such as nanoseconds).

System Clock

An internal electronic component that generates precise, recurring electrical pulses (clock signals) to synchronize all computer processing operations.

Clock Speed

The operating rate of the system clock, measured in gigahertz ($\text{GHz}$), indicating the number of execution pulses or cycles a CPU can perform per second.

Multicore Processor

An integrated circuit that incorporates two or more distinct processing cores on a single chip to boost computing performance and lower power consumption.

Server

A computer optimized to support a network by storing shared files, managing network resources, supporting client/server processing, and serving as the hardware platform for e-commerce.

Client/Server Computing

A distributed computing model that divides processing work between user client devices (which handle user interface and request data) and remote servers (which process and store shared resources).

Supercomputer

A highly complex, powerful computer designed to execute massive mathematical calculations with thousands of variables and millions of measurements using parallel processing.

Parallel Processing

The simultaneous execution of two or more distinct computing tasks by linking multiple physical processors to work together on the same problem.

Grid Computing

A computing paradigm that connects geographically dispersed computers over a network to combine their idle processing capacity into a single virtual supercomputer.

Random Access Memory (RAM)

The computer's primary working semi-conductor memory, which directly holds active program instructions and data; it is volatile and loses all stored data when electrical power is turned off.

Read-Only Memory (ROM)

Nonvolatile semi-conductor memory that permanently retains essential startup instructions, including the system BIOS and boot commands, even when power is turned off.

Sequential Access Storage Device (SASD)

A secondary storage device, such as magnetic tape, that requires stored records to be accessed in the linear order in which they were originally recorded.

Direct Access Storage Device (DASD)

A secondary storage device (such as a hard disk or solid-state drive) where data can be retrieved instantly in any order because each storage location has a unique address.

Magnetic Tape

A sequential storage medium composed of plastic mylar that stores bits as magnetized spots; primarily used for data backups and long-term archival storage.

RAID (Redundant Array of Independent Disks)

A secondary storage configuration that integrates multiple physical disk drives into an array to improve read/write speed, capacity, and fault tolerance via data redundancy.

Solid State Drive (SSD)

A secondary storage device that uses nonvolatile flash memory and transistors rather than rotating magnetic platters, providing faster access times, lower power consumption, and shock resistance.

Storage Area Network (SAN)

A dedicated, high-speed subnetwork that interconnects and manages different types of shared enterprise storage devices (such as RAID arrays, tape libraries, and optical storage).

Ergonomics

The study of the interaction between people and machines in the workplace, focused on designing and positioning equipment to safeguard employee health and prevent injuries like carpal tunnel syndrome.

Optical Character Recognition (OCR)

An automated input technology that scans printed or handwritten text documents and translates them into editable, machine-readable digital characters.

Optical Mark Recognition (OMR)

An automated input technology that reads and processes human-created pencil or ink marks on standardized paper forms, such as surveys and bubble exam sheets.

Magnetic Ink Character Recognition (MICR)

An automated data entry technology used in the banking sector to read encoded routing, account, and check numbers printed with magnetic ink.

Radio Frequency Identification (RFID)

An automated input system that uses microchips and radio frequency signals to transmit data wirelessly over short distances to track assets and read contactless payment cards.

Pixel

Short for picture element; the smallest individual dot that makes up an image on a display monitor, where higher pixel densities (pixels per inch) produce sharper images.

Dot Pitch

The physical measurement of space between adjacent pixels on a display screen, where a smaller distance results in clearer, sharper image quality.

Video RAM (VRAM)

Specialized, high-speed memory on video cards that temporarily stores image and display data to accelerate rendering speed on display monitors.

Cloud Computing

A computing model in which firms and individuals obtain virtualized processing power, storage, and software resources over a network (typically the Internet) on an on-demand, utility basis.

Green Computing

Practices and technologies aimed at manufacturing, operating, and disposing of computer equipment to minimize ecological impact, focusing on energy conservation and e-waste recycling.

Software-Hardware Relationship Model

A layered architecture showing that users interact directly with application software, which must work through underlying system software (operating systems, translators, utilities) to control computer hardware.

System Software

The collection of programs that manage and control the basic functions of computer hardware and coordinate resources between application software and physical components.

Operating System (OS)

The foundational system software that manages computer activities, provides a graphical user interface (GUI), allocates resources, schedules processing tasks, and coordinates hardware devices.

Utility Programs

System software programs that carry out common housekeeping and maintenance tasks, including virus protection, file compression, data sorting, and disk optimization.

Application Software

Programs created to perform specific informational or productive tasks requested by end users, such as word processing, financial accounting, and inventory tracking.

Object-Oriented Programming (OOP)

A programming methodology that bundles discrete data elements and the specific procedures (methods) that act upon them into modular software units called objects.

Hypertext Markup Language (HTML)

A web page description language used to structure web content, format text and media elements, and establish hyperlinks to external web pages and objects.

HTML5

The current standard version of HTML, designed to natively embed rich audio, video, and multimedia content into web pages without third-party browser plugins.

Web Services

Loosely coupled software components that communicate and exchange information across platforms using universal web communication standards and protocols.

Extensible Markup Language (XML)

A flexible, tag-based markup language that provides standard data descriptors to support web services and automate data exchange between incompatible systems.

Software as a Service (SaaS)

A cloud delivery model in which vendors host application software remotely over the Internet, allowing users to access features on demand through a web browser.

Open Source Software

Software provided with accessible, publicly available source code that allows developers across the globe to inspect, modify, improve, and redistribute it freely.

Total Cost of Ownership (TCO)

A financial model used to evaluate the comprehensive direct and indirect costs of acquiring, operating, supporting, and maintaining hardware and software assets over their entire lifecycle.

Garbage In, Garbage Out (GIGO)

A fundamental principle of information systems stating that inaccurate, incomplete, or flawed data inputs inevitably lead to poor or misleading decision-making outputs.

Data Hierarchy

The organizational structure of data within a computer system, progressing from bits to bytes, fields, records, files, and ultimately databases.

Field

A grouping of related characters or bytes representing an individual data element or specific attribute (such as a supplier name or part number) of an entity.

Record

A collection of related fields that captures all the relevant attributes describing a single instance of an entity (such as a specific employee or product).

Entity

A general category representing a person, place, or thing (such as a customer, employee, or supplier) about which an organization stores and maintains data.

Relational Database

A database model that structures data into two-dimensional tables (relations) made up of rows (records) and columns (fields/attributes).

Primary Key

A unique identifier field in a relational database table that ensures each individual record (row) can be distinctly identified.

Foreign Key

A field in one relational database table that serves as a lookup key by referencing the primary key of another table, establishing a relationship between them.

Database Management System (DBMS)

Specialized software that manages the storage, organization, creation, and retrieval of data in a database while separating logical and physical data views.

Logical View

The way in which data is presented to and perceived by end users or application programs based on their individual business requirements (multiple logical views can exist).

Physical View

The actual physical layout, organization, and location of data as stored on underlying magnetic, optical, or solid-state storage media (only one physical view exists).

Data Dictionary

An automated repository within a DBMS that stores detailed definitions, technical characteristics, formats, data types, and allowable ranges for all data elements.

Structured Query Language (SQL)

The standard data manipulation language used by relational database systems to write queries, retrieve information, and manipulate database records.

Relational DBMS Operations

The three core mathematical operations used to extract data from tables: select (filters rows meeting criteria), join (combines related tables), and project (extracts specified columns).

Big Data

Massive datasets characterized by the '3Vs' (extreme Volume, Variety, and Velocity) that exceed the capacity of traditional relational database systems to capture, store, and analyze.

NoSQL DBMS

Non-relational database management software built with flexible data models to store, query, and process vast quantities of unstructured or semi-structured data across distributed clusters.

Blockchain

A distributed, decentralized transaction database that maintains a tamper-resistant digital ledger of cryptographically linked blocks shared across a network without a central authority.

Data Warehouse

A central database storing standardized current and historical data ($3$ to $10$ years) consolidated from internal operational systems and external sources to support management reporting and analytical queries.

Data Mart

A focused, customized subset of a data warehouse containing highly summarized or specific data intended to support the decision-making needs of a single business department or user group.

Data Lake

A vast, centralized repository that stores enormous volumes of raw, unprocessed data in native structured, semi-structured, or unstructured formats until needed for analytics.

Hadoop

An open-source Apache software framework designed for big data that breaks large computational tasks into smaller sub-problems and distributes their processing across clusters of inexpensive computing nodes.

In-Memory Computing

A high-speed analytical architecture that stores and processes entire datasets directly in primary random access memory (RAM), eliminating disk retrieval bottlenecks.

Online Analytical Processing (OLAP)

A business intelligence capability that allows users to perform multidimensional data analysis, viewing data through multiple dimensions (such as product, pricing, region, and time period).

OLAP Cube

A multidimensional data model in Online Analytical Processing where each axis represents a business dimension (such as product, sales region, and projected versus actual sales), allowing users to view data from multiple angles.

Data Mining

The discovery-driven analytical process of analyzing large databases, data warehouses, or data lakes to uncover hidden patterns, trends, associations, and rules for predicting future outcomes.

Text Mining

The application of analytical techniques to extract valuable insights, patterns, and structured knowledge from large volumes of unstructured textual data such as emails, call transcripts, and customer memos.

Sentiment Analysis

A text mining process that parses online text (such as reviews, social media comments, and surveys) to detect and quantify favorable or unfavorable opinions and emotional attitudes toward a subject.

Web Mining

The automated discovery and analysis of meaningful patterns, content, and hyperlink structures from the World Wide Web to extract user behavioral insights.

Data-Driven Web Site

An interactive web site that acts as a dynamic interface to back-end organizational databases, enabling continuous, real-time data updates for applications like e-commerce catalogs.