1/61
Vocabulary practice flashcards covering data quality, relational database management systems, business intelligence, data warehouses, and blockchain technology from Chapter 6.
Transactional Data
Encompasses all of the data contained within a single business process or unit of work, with the primary purpose of supporting the performing of daily operational tasks.
Analytical Data
Encompasses all organizational data, with the primary purpose of supporting the performing of managerial analysis tasks.
Quantitative Data
Data that includes integers, decimals, or floating-point numbers used to represent quantities, measurements, or calculations.
Categorical Data
Textual data consisting of alphanumeric characters used to store textual information such as names, addresses, descriptions, or comments.
Boolean Data
Data that represents binary values, typically 'true' or 'false,' used for logical conditions, flags, yes/no, or on/off states in database operations.
Real-Time Data
Immediate, up-to-date data.
Real-Time System
A system that provides real-time data in response to requests.
Data Inconsistency
Occurs when the same data element has different values.
Data Integrity Issues
Occur when a system produces incorrect, inconsistent, or duplicate data.
Data Governance
The overall management of the availability, usability, integrity, and security of company data.
Data Steward
A role responsible for ensuring data policies and procedures are implemented across an organization.
Data Validation
Includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.
Database
Maintains data about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).
Data Element
The smallest or basic unit of data.
Data Model
Logical data structures that detail the relationships among data elements using graphics or pictures.
Metadata
Details about data.
Data Dictionary
Compiles all of the metadata about the data elements in the data model.
Relational Database Model
Stores data in the form of logically related two-dimensional tables.
Relational Database Management System (RDBMS)
Allows users to create, read, update, and delete data in a relational database.
Structured Query Language (SQL)
Asks users to write lines of code to answer questions against a database.
Entity
A person, place, thing, transaction, or event about which data is stored; represented by the rows in a table.
Attribute
The data elements associated with an entity, also known as a field or column; represented by the columns in each table.
Record
A collection of related data elements.
Primary Key
A field (or group of fields) that uniquely identifies a given entity in a table.
Foreign Key
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables.
Physical View
Deals with the physical storage of data on a storage device, of which a database has only one.
Logical View
Focuses on how individual users logically access data to meet their own particular business needs, allowing multiple views in a database.
Scalability
Refers to how well a system can adapt to increased demands.
Performance
Measures how quickly a system performs a certain process or transaction.
Data Latency
The time it takes for data to be stored or retrieved.
Data Redundancy
The duplication of data or storing the same data in multiple places.
Relational Integrity Constraint
Rules that enforce basic and fundamental information-based constraints, such as not allowing the creation of an account for a nonexistent customer.
Business-Critical Integrity Constraint
Enforces business rules vital to an organization's success and often requires more insight and knowledge than relational integrity constraints (e.g., return windows, valid grading bounds).
Identity Management
A broad administrative area that deals with identifying individuals in a system and controlling their access.
Data Warehouse
A logical collection of data gathered from many different operational databases that supports business analysis activities and decision-making tasks.
Data Aggregation
The collection of data from various sources for the purpose of data processing.
Extraction, Transformation, and Loading (ETL)
A process that extracts data from internal and external databases, transforms the data using a common set of enterprise definitions, and loads the data into a data warehouse.
Data Mart
Contains a subset of data warehouse data.
Data Lake
A storage repository that holds a vast amount of raw data in its original format until the business needs it.
Dirty Data
Erroneous or flawed data.
Data Cleansing (Scrubbing)
A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete data.
Data Cube
The common term for the representation of multidimensional data.
Collaborative Filtering
A technique used in recommendation systems to provide personalized recommendations to users based on their similarity to other users.
Recommendation Engine
A data mining algorithm that analyzes a customer's purchases and actions on a website and then uses the data to recommend complementary products.
Estimation Analysis
Determines values for an unknown continuous variable behavior or estimated future value.
Affinity Grouping Analysis
Reveals the relationship between variables along with the nature and frequency of the relationships.
Cluster Analysis
A technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible.
Classification Analysis
The process of organizing data into categories or groups for its most effective and efficient use.
Data Visualization
Describes technologies that allow users to 'see' or visualize data to transform data into a business perspective.
Infographic
A representation of information in a graphical format designed to make the data easily understood at a glance.
Business Intelligence Dashboard
Tracks corporate metrics such as critical success factors and key performance indicators, including advanced capabilities like interactive controls allowing users to manipulate data for analysis.
Consolidation
The aggregation of data from simple roll-ups to complex groupings of interrelated information (e.g., rolling up sales data from rep, to office, to state, to regional level).
Drill-Down
Enables users to view details, and details of details, of information; the reverse of consolidation.
Slice-and-Dice
The ability to look at information from different perspectives, often performed along a time axis to analyze trends and find time-based patterns.
Pivot (Rotation)
Rotates data to display alternative presentations of the data, such as swapping the rows and columns of a report.
Distributed Computing
Processes and manages algorithms across many machines in a computing environment.
Ledger
A record book that tracks transactions, who did what, when, and how much; records classified and summarized transactional data.
Blockchain
A type of distributed ledger consisting of blocks of data that maintain a permanent and tamper-proof record of transactional data.
Genesis Block
The first block created in a blockchain, which contains no previous hash.
Hash
A function that converts an input of letters and numbers into an encrypted output of a fixed length, acting as a block's unique identifier like a fingerprint.
Proof-of-Work
A requirement to define an expensive computer calculation (mining) that must be performed to create a new group of trustless transactions (blocks) on a distributed ledger.
Proof-of-Stake
A way to validate transactions and achieve a distributed consensus.