6, 7, 8 Flashcards

1
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
2
Q

attribute

A

Characteristics or properties of an entity class.

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

backward integration

A

Takes information entered into a given system and sends it automatically to all upstream systems and processes.

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

business intelligence dashboard

A

Tracks corporate metrics such as critical success factors and key performance indicators and includes advanced capabilities such as interactive controls, allowing users to manipulate data for analysis.

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

business-critical integrity constraint

A

Enforces business rules vital to an organization’s success and often requires more insight and knowledge than relational integrity constraints.

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

business rule

A

Defines how a company performs a certain aspect of its business and typically results in either a yes/no or true/false answer.

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

content creator

A

The person responsible for creating the original website content.

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

cube

A

The common term for the representation of multidimensional information.

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

content editor

A

The person responsible for updating and maintaining website content.

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

database

A

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

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

database management system (DBMS)

A

Software through which users and application programs interact with a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
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
13
Q

data-driven website

A

An interactive website kept constantly updated and relevant to the needs of its customers through the use of a database.

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

data element (or data field)

A

The smallest or basic unit of information.

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

data governance

A

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

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

data model

A

A formal way to express data relationships to a database management system (DBMS).

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

data mart

A

Contains a subset of data warehouse information.

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

data mining

A

The process of analyzing data to extract information not offered by the raw data alone.

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

data-mining tool

A

Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making.

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

data visualization

A

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

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

data visualization tools

A

Moves beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, etc.

22
Q

data warehouse

A

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

23
Q

dynamic catalog

A

An area of a website that stores information about products in a database.

24
Q

dynamic information

A

Includes data that change based on user actions.

25
Q

entity

A

In the relational database model, a person, place, thing, transaction, or event about which information is stored.

26
Q

extraction, transformation, and loading (ETL)

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.

27
Q

foreign key

A

A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

28
Q

forward integration

A

Takes information entered into a given system and sends it automatically to all downstream systems and processes.

29
Q

informing

A

Accessing large amounts of data from different management information systems.

30
Q

information cleansing or scrubbing

A

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

31
Q

information granularity

A

Refers to the extent of detail within the information (fine and detailed or “coarse” and abstract information).

32
Q

information inconsistency

A

Occurs when the same data element has different values.

33
Q

information integrity

A

A measure of the quality of information.

34
Q

information redundancy

A

The duplication of data, or the storage of the same data in multiple places.
(see: Information integrity issues, 87)

35
Q

information redundancy

A

The duplication of data, or the storage of the same data in multiple places.

36
Q

infographics (information graphics)

A

Displays information graphically so it can be easily understood.

37
Q

integration

A

Allows separate systems to communicate directly with each other.

38
Q

integrity constraint

A

The rules that help ensure the quality of information.

39
Q

logical view of information

A

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

40
Q

metadata

A

Details about data.

41
Q

physical view of information

A

The physical storage of information on a storage device such as a hard disk.

42
Q

primary key

A

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

43
Q

query-by-example (QBE) tool

A

Helps users graphically design the answer to a question against a database.

44
Q

real-time information

A

Immediate, up-to-date information.

45
Q

real-time system

A

Provides real-time information in response to query requests.

46
Q

record

A

A collection of related data elements.

47
Q

relational database management system

A

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

48
Q

relational database model

A

A type of database that stores information in the form of logically related two-dimensional tables.

49
Q

relational integrity constraint

A

The rules that enforce basic and fundamental information-based constraints.

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

51
Q

static information

A

Includes fixed data that are not capable of change in the event of a user action.

52
Q

structured query language

A

Users write lines of code to answer questions against a database.