ISDS 351 exam 2 vocab

Scope

all work required for project

deliverable

output produced during project

WBS (work breakdown structure)

breakdown of project into smaller tasks

Scope baseline

approved scope + WBS

Scope creep

uncontrolled scope changes

Variance

difference between planned and actual

Requirements

conditions systems must meet

Requirements Traceability Matrix

tracks requirements

WBS dictionary

detailed explanation of WBS items

DBMS (design structure matrix)

software to manage databases

Entity

object being stored

Attribute

characteristics of entity

Primary key

unique identifier

Foreign key

link tables

Field

single data item

Record

collection of fields

Schema

structure of database

SQL (structure query language)

language to manage data

DDL (data defintion language)

defines database structure

DML (definitive media library)

modifies data

DQL (declared quality language)

queries datad

data dictionary

metabase about data

Data cleansing

fixing incorrect data

Relational Database

table-based database

DaaS (desktop as a service)

cloud-based database service

BI (business intelligence)

data analysis for decisions

Big data

large complex datasets

ETL

extract, transform, and load

Data warehouse

central data storage

Data Mart

smaller subset

Data Lake

raw data storage

NOSQL

non-relational database

Hadoop

big data processing tool

Descriptive Analytics

what happened

Diagnostic analytics

why it happened

predictive analytics

what will happen

Prescriptive analytics

what to do

Data Mining

pattern discovery

KPI (key performance indicators)

performance measure

Metric

quantifiable measure

Network topology

network structure

LAN

local network

WAN

large network

PAN

personal network

TCI/IP

internet protocol

DNS (domain name system)

convert name to IP

URL

web address

VPN

secure internet connection

Client/server

clients request from servers

Intranet

internal network

Extranet

external partner network

Surface web

public internet

Deep web

private data

Dark web

anonymous network

B2B

business to business

B2C

business to consumer

C2C

consumer to consumer

E-commerce

online transactions

M-commerce

mobile transactions

SWOT

Strengths, Weaknesses, Opportunities, Threats

TPS

transaction processing system

ERP

integrated business system

CRM

customer management system

SCM

supply chain management

PLM

product lifecycle management

Asset management

managing company’s assets

Systems analysis

define requirements

requirements elicitation

gathering needs

Feasibility

project viability

Technical feasilbility

tech capability

Economic feasibility

cost/benefits

Legal feasibility

legal compliance

Operational feasibility

user adoption

Schedule feasibility

timeline

Agile

iterative development

Waterfall

sequential development

DevOps

Dev + operations

Integration testing

test components together

System testing

test full system

UAT

user testing

Cutover

switching systems

Direct conversion

immediate switch

Parallel conversion

run both systems

Pilot

small group testing

Phase-in

gradual rollout

Patch

small fix

New Release

major update