IT and Database Concepts: Hardware, Software, and AI Fundamentals

Solid-state storage (SSD)

A type of storage device that uses integrated circuit assemblies as memory to store data persistently, typically faster than traditional hard drives.

Industrial Internet of Things (IIoT)

The use of Internet of Things (IoT) technology in industrial sectors to enhance manufacturing and industrial processes.

Source code

The human-readable instructions written in a programming language that make up a computer program.

Artificial general intelligence

A form of AI that possesses the ability to understand, learn, and apply knowledge across a wide range of tasks, similar to human intelligence.

Internet of Things (IoT)

A network of physical objects that are embedded with sensors, software, and other technologies to connect and exchange data with other devices over the internet.

Storage hardware

Physical devices used to store data, including hard drives, SSDs, and optical discs.

Artificial intelligence (AI)

The simulation of human intelligence processes by machines, especially computer systems, including learning, reasoning, and self-correction.

iOS

A mobile operating system created by Apple for its hardware, primarily used on iPhones and iPads.

Generative AI

A type of AI that can generate new content, such as text, images, or music, based on the data it has been trained on.

License

A legal permission to use software or intellectual property under specified conditions.

Vertical-market application

Software designed to meet the specific needs of a particular industry or market segment.

Machine learning

A subset of AI that enables systems to learn from data and improve their performance over time without being explicitly programmed.

Machine code

The lowest-level programming language, consisting of binary code that the computer's CPU can directly execute.

Virtualization

The creation of a virtual version of something, such as a server, storage device, or network resources.

Superintelligence

A hypothetical AI that surpasses human intelligence across all fields, including creativity, problem-solving, and social skills.

macOS

The operating system developed by Apple for its line of Mac computers.

Virtual machines (vm)

Software emulations of physical computers that run an operating system and applications just like a physical machine.

Turing test

A test proposed by Alan Turing to determine whether a machine can exhibit intelligent behavior indistinguishable from that of a human.

Main memory

The primary storage area in a computer where data is temporarily stored for quick access by the CPU.

Virtual reality (VR)

A simulated experience that can be similar to or completely different from the real world, often using VR headsets.

Microsoft Windows

A group of operating systems developed by Microsoft for personal computers, known for its graphical user interface.

Volatile

Refers to memory that requires power to maintain the stored information; data is lost when the power is turned off.

Application software

Programs designed to perform specific tasks for users, such as word processing, web browsing, or database management.

Native application

Software that is developed specifically for a particular platform or operating system, utilizing its features and capabilities.

Web application

An application that runs on a web server and can be accessed through a web browser over the internet.

Augmented reality (AR)

An interactive experience where real-world environments are enhanced by computer-generated perceptual information.

Nonvolatile

Refers to memory that retains its data even when the power is turned off.

Bits

The smallest unit of data in computing, representing a binary value of either 0 or 1.

Off-the-shelf software

Commercially available software that is produced for the mass market and can be purchased and used without customization.

Access

The ability to obtain or make use of something, such as data or resources in a computer system.

Attributes

Characteristics or properties of an entity in a database that define its data.

Bring your own device (BYOD) policy

A policy that allows employees to use their personal devices for work purposes, often requiring security measures.

Off-the-shelf with alterations software

Commercial software that has been modified to meet specific user requirements.

Columns

Vertical divisions in a database table that represent attributes of the entities.

Bytes

A unit of digital information that consists of 8 bits.

Crow's feet

A notation used in entity-relationship diagrams to represent the cardinality of relationships between entities.

One-of-a-kind application

Custom software developed for a specific user or organization, tailored to their unique needs.

Crow's-foot diagram

A visual representation of entities and their relationships in a database, using crow's feet notation.

Central processing unit (CPU)

The primary component of a computer that performs most of the processing inside the computer.

Open source

Software with source code that is freely available for anyone to use, modify, and distribute.

Data integrity problem

Issues that arise when data is inaccurate, inconsistent, or not reliable within a database.

Client

A computer or application that requests services or resources from a server.

Operating system (OS)

Software that manages computer hardware and software resources and provides common services for computer programs.

Data model

A conceptual representation of data structures and the relationships between them in a database.

Computer hardware

The physical components of a computer system, including the CPU, memory, and storage devices.

Personal computers

General-purpose computers designed for individual use, typically consisting of a CPU, memory, and input/output devices.

Database

An organized collection of data that can be easily accessed, managed, and updated.

RAM

Random Access Memory, a type of volatile memory used to store data temporarily for quick access by the CPU.

Database administration

The process of managing and maintaining a database, including tasks like performance tuning and security management.

Custom-developed software

Software that is specifically designed and developed to meet the unique requirements of a particular user or organization.

Self-driving vehicle

A vehicle equipped with technology that enables it to navigate and operate without human intervention.

Database application

Software that interacts with a database to manage data and provide users with access to that data.

Server

A computer or system that provides resources, data, services, or programs to other computers, known as clients.

Financial technology (FinTech)

Innovative technology that aims to improve and automate the delivery and use of financial services.

Server farm

A collection of servers maintained by an organization to provide services and manage data.

Database management system (DBMS)

Software that interacts with end users, applications, and the database itself to capture and analyze data.

Site license

A type of software license that allows multiple users to access the software at a single location.

Horizontal-market application

Software that is designed to be used across various industries and is not specific to any one market.

DB2

A family of data management products from IBM that includes database servers and tools.

Smart device

An electronic device that is connected to the internet and can collect, send, and receive data.

Entity

A distinct object or concept in a database that can have data stored about it.

MySQL

An open-source relational database management system based on Structured Query Language (SQL).

Rows

Horizontal divisions in a database table that represent individual records.

Entity-relationship (E-R) data model

A diagrammatic representation of entities and their relationships in a database.

Normalization

The process of organizing data in a database to reduce redundancy and improve data integrity.

SQL server

A relational database management system developed by Microsoft that uses SQL for database management.

Fields

Individual data elements in a database record that represent attributes of an entity.

Foreign keys

A field in a database table that creates a link between two tables, establishing a relationship.

One-to-many relationships

A type of relationship in a database where a single record in one table can be associated with multiple records in another table.

Structured Query Language (SQL)

A standardized programming language used to manage and manipulate relational databases.

Identifier

A unique attribute or combination of attributes that distinguishes each record in a database table.

Oracle Database

A multi-model database management system produced and marketed by Oracle Corporation.

Table

A structured set of data organized in rows and columns within a database.

Key

An attribute or set of attributes that uniquely identifies a record in a database table.

Primary key

A unique identifier for a record in a database table that cannot be null.

Records

Individual entries in a database table that contain data for a specific entity.

Many-to-many relationships

A type of relationship in a database where multiple records in one table can be associated with multiple records in another table.

Relationships

Connections between entities in a database that define how data is related to one another.