Databases and Information Management - Business Driven Information Systems

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/61

flashcard set

Earn XP

Description and Tags

Vocabulary practice flashcards covering data quality, relational database management systems, business intelligence, data warehouses, and blockchain technology from Chapter 6.

62 Terms

1
New cards

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.

2
New cards

Analytical Data

Encompasses all organizational data, with the primary purpose of supporting the performing of managerial analysis tasks.

3
New cards

Quantitative Data

Data that includes integers, decimals, or floating-point numbers used to represent quantities, measurements, or calculations.

4
New cards

Categorical Data

Textual data consisting of alphanumeric characters used to store textual information such as names, addresses, descriptions, or comments.

5
New cards

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.

6
New cards

Real-Time Data

Immediate, up-to-date data.

7
New cards

Real-Time System

A system that provides real-time data in response to requests.

8
New cards

Data Inconsistency

Occurs when the same data element has different values.

9
New cards

Data Integrity Issues

Occur when a system produces incorrect, inconsistent, or duplicate data.

10
New cards

Data Governance

The overall management of the availability, usability, integrity, and security of company data.

11
New cards

Data Steward

A role responsible for ensuring data policies and procedures are implemented across an organization.

12
New cards

Data Validation

Includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.

13
New cards

Database

Maintains data about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).

14
New cards

Data Element

The smallest or basic unit of data.

15
New cards

Data Model

Logical data structures that detail the relationships among data elements using graphics or pictures.

16
New cards

Metadata

Details about data.

17
New cards

Data Dictionary

Compiles all of the metadata about the data elements in the data model.

18
New cards

Relational Database Model

Stores data in the form of logically related two-dimensional tables.

19
New cards

Relational Database Management System (RDBMS)

Allows users to create, read, update, and delete data in a relational database.

20
New cards

Structured Query Language (SQL)

Asks users to write lines of code to answer questions against a database.

21
New cards

Entity

A person, place, thing, transaction, or event about which data is stored; represented by the rows in a table.

22
New cards

Attribute

The data elements associated with an entity, also known as a field or column; represented by the columns in each table.

23
New cards

Record

A collection of related data elements.

24
New cards

Primary Key

A field (or group of fields) that uniquely identifies a given entity in a table.

25
New cards

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.

26
New cards

Physical View

Deals with the physical storage of data on a storage device, of which a database has only one.

27
New cards

Logical View

Focuses on how individual users logically access data to meet their own particular business needs, allowing multiple views in a database.

28
New cards

Scalability

Refers to how well a system can adapt to increased demands.

29
New cards

Performance

Measures how quickly a system performs a certain process or transaction.

30
New cards

Data Latency

The time it takes for data to be stored or retrieved.

31
New cards

Data Redundancy

The duplication of data or storing the same data in multiple places.

32
New cards

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.

33
New cards

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).

34
New cards

Identity Management

A broad administrative area that deals with identifying individuals in a system and controlling their access.

35
New cards

Data Warehouse

A logical collection of data gathered from many different operational databases that supports business analysis activities and decision-making tasks.

36
New cards

Data Aggregation

The collection of data from various sources for the purpose of data processing.

37
New cards

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.

38
New cards

Data Mart

Contains a subset of data warehouse data.

39
New cards

Data Lake

A storage repository that holds a vast amount of raw data in its original format until the business needs it.

40
New cards

Dirty Data

Erroneous or flawed data.

41
New cards

Data Cleansing (Scrubbing)

A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete data.

42
New cards

Data Cube

The common term for the representation of multidimensional data.

43
New cards

Collaborative Filtering

A technique used in recommendation systems to provide personalized recommendations to users based on their similarity to other users.

44
New cards

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.

45
New cards

Estimation Analysis

Determines values for an unknown continuous variable behavior or estimated future value.

46
New cards

Affinity Grouping Analysis

Reveals the relationship between variables along with the nature and frequency of the relationships.

47
New cards

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.

48
New cards

Classification Analysis

The process of organizing data into categories or groups for its most effective and efficient use.

49
New cards

Data Visualization

Describes technologies that allow users to 'see' or visualize data to transform data into a business perspective.

50
New cards

Infographic

A representation of information in a graphical format designed to make the data easily understood at a glance.

51
New cards

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.

52
New cards

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).

53
New cards

Drill-Down

Enables users to view details, and details of details, of information; the reverse of consolidation.

54
New cards

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.

55
New cards

Pivot (Rotation)

Rotates data to display alternative presentations of the data, such as swapping the rows and columns of a report.

56
New cards

Distributed Computing

Processes and manages algorithms across many machines in a computing environment.

57
New cards

Ledger

A record book that tracks transactions, who did what, when, and how much; records classified and summarized transactional data.

58
New cards

Blockchain

A type of distributed ledger consisting of blocks of data that maintain a permanent and tamper-proof record of transactional data.

59
New cards

Genesis Block

The first block created in a blockchain, which contains no previous hash.

60
New cards

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.

61
New cards

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.

62
New cards

Proof-of-Stake

A way to validate transactions and achieve a distributed consensus.