Week 2 (Ch. 5, 12) Flashcards

(46 cards)

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
what is diagnostic analytics
'why did it happen?'
25
what is predictive analytics
'what might happen?'
26
what is prescriptive analytics
'what to do next?'
27
what is data governance
managing availability, usability, integrity and security of data
28
what are legacy systems
outdated information systems
29
what are canned reports
reports that provide regular summaries of information
30
what are ad hoc reporting tools
tools that allow users to create their own reports
31
what is online analytical procession (OLAP)
computing method that enables users to select and extract data for analysis from numerous perspectives (used by managers, analysts)
32
what is a data cube
storage for OLAP
33
what is data mining
process of analyzing data for previously unknown trends
34
what are the two conditions for effective data mining
clean and consistent data, data should reflect current and future trends
35
what is a data warehouse
set of databases
36
what is a data mart
subset of data warehouse focused on specific set of information
37
what is a relational data model
data is organized into inter related tables
38
what is a flat file database
only one file/table of data
39
what is a record in relational database
a row
40
what is an attribute in relational database
a column
41
organize bit, field, record, file and byte by order of size
file, record, field, byte, bit
42
what is normalizing data
reducing data redundancy and ensuring data integrity
43
why do people use databases
control over redundant data, data integrity, data sharing and security/recovery
44
what is sql
language used to manipulate and communicate with databases
45
what is OLTP
OLAP for recent data, smaller and used for day to day activities