Chapter 6: Data Flashcards

1
Q

Transactional Information

A

Encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Analytical Information

A

Encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Real Time Information

A

Immediate up to date information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Real Time System

A

Provides real time information in response to requests

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Low Quality Information

A

Missing information, incomplete information, duplicate information, wrong information, inaccurate information, incomplete information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Database

A

Maintains information about various types of objects, events, people, and places

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Database Management Systems

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Data Model

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Metadata

A

Details about data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Data Dictionary

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Entity

A

A person, place, thing, transaction, or event about which information is stored

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Attribute

A

The data elements associated with an entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Record

A

A collection of related data elements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Primary Key

A

A field that uniquely identifies a given entity in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Foreign Key

A

A primary Key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Physical View

A

Deals with the physical storage of information on a storage device

17
Q

Logical View

A

Focuses on how individual users logically access information to meet their own particular business needs

18
Q

Scalability

A

Refers to how well a system can adapt to increased demands

19
Q

Performance

A

Measures how quickly a system performs a certain process or transaction

20
Q

Information Redundancy

A

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

21
Q

Information Integrity

A

Measures the quality of information

22
Q

Integrity Constraint

A

Rules that help ensure the quality of information

23
Q

Password

A

Provides authentication of the user

24
Q

Access Level

A

Determines who has access to the different types of information

25
Q

Access Control

A

Determines types of user access, such as read only access

26
Q

Data Warehouse

A

A logical collection information that supports business analysis activities and decision making tasks

27
Q

Extraction, Transformation, and Loading

A

A process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse

28
Q

Data Mart

A

Contains a subset of data warehouse information

29
Q

Information Cleansing or Scrubbing

A

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

30
Q

Data Mining

A

The process of analyzing data to extract information not offered by the raw data alone. Advanced methods for exploring patterns and modeling relationships in large amounts of data

31
Q

Structured Data

A

Contains a defined length, type, and format and includes numbers, dates, or strings

32
Q

Unstructured Data

A

Not defined, does not follow a specified format, and is typically free form text such as emails and text messages

33
Q

Big Data

A

A collection of large complex data sets including structured and unstructured data which can’t be analyzed using traditional database methods and tools