Week 2 (Ch. 5, 12) Flashcards

1
Q

what is metadata

A

“data about data”

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

what is big data

A

large data sets that conventional data processing technologies do not have sufficient power to analyze

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

what is a database

A

organized collection of related information

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

what is a DBMS (database management system)

A

software for creating, storing, maintaining and accessing database files

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

what are the three categorizations of big data

A

volume, variety and velocity

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

what is volume in the context of big data

A

size

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

what is variety in the context of big data

A

number of data types

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

what is velocity in the context of big data

A

processing speed

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

what is velocity in the context of big data

A

processing speed

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

what are heursitics

A

mental shortcut

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

what are structured decisions

A

decision based solely on inputs

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

what are unstructured decisions

A

non programmed decision involving lots of unknowns

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

what are semi structured decisions

A

factors are known but human experience and outside factor influences decisions

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

what are operational decisions

A

decisions that employees make to make the organization run

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

what are strategic decisions

A

set the course of an organization

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

what are tactical/managerial decisions

A

decisions about how things will get done

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

what are decision support systems (DSS)

A

interactive computer system that helps managers make decisions

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

what are executive information systems (EIS)

A

similar to DSS (decision support system) but customized for executives

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

what are expert systems

A

systems that give managers advice such as a human consultant would

19
Q

what is ‘what if’ analysis

A

outlines impact of the change in a variable in a model

20
Q

what is sensitivity analysis

A

outlines the impact when one variable is changes repeatedly

21
Q

what is goal seek analysis

A

finds inputs necessary to achieve goal

22
Q

what is optimization analysis

A

finds the optimum value for a target variable by changing other variables

23
Q

what is descriptive analysis

A

‘what happened?’

24
Q

what is diagnostic analytics

A

‘why did it happen?’

25
Q

what is predictive analytics

A

‘what might happen?’

26
Q

what is prescriptive analytics

A

‘what to do next?’

27
Q

what is data governance

A

managing availability, usability, integrity and security of data

28
Q

what are legacy systems

A

outdated information systems

29
Q

what are canned reports

A

reports that provide regular summaries of information

30
Q

what are ad hoc reporting tools

A

tools that allow users to create their own reports

31
Q

what is online analytical procession (OLAP)

A

computing method that enables users to select and extract data for analysis from numerous perspectives (used by managers, analysts)

32
Q

what is a data cube

A

storage for OLAP

33
Q

what is data mining

A

process of analyzing data for previously unknown trends

34
Q

what are the two conditions for effective data mining

A

clean and consistent data, data should reflect current and future trends

35
Q

what is a data warehouse

A

set of databases

36
Q

what is a data mart

A

subset of data warehouse focused on specific set of information

37
Q

what is a relational data model

A

data is organized into inter related tables

38
Q

what is a flat file database

A

only one file/table of data

39
Q

what is a record in relational database

A

a row

40
Q

what is an attribute in relational database

A

a column

41
Q

organize bit, field, record, file and byte by order of size

A

file, record, field, byte, bit

42
Q

what is normalizing data

A

reducing data redundancy and ensuring data integrity

43
Q

why do people use databases

A

control over redundant data, data integrity, data sharing and security/recovery

44
Q

what is sql

A

language used to manipulate and communicate with databases

45
Q

what is OLTP

A

OLAP for recent data, smaller and used for day to day activities