Exam 2 Flashcards

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

real-time systems

A

provide real-time information in response to requests

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

info quality

A
timeliness
accuracy
relevancy
completeness
consistent
uniqueness
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

costs of low quality information

A

time, money, reputations and even jobs

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

data steward

A

responsible for ensuring the polices and procedures are implemented across the organization and acts as a liaison between the mis department and the business

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

SQL

A

strutted query language

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

QBE

A

query-by-example

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

primary key

A

a field that uniquely identifies a given record in a table

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

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

data warehouse

A

a type fo database that integrates copies of transaction data from disparate source systems and provisions them for analytical use

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

ETL

A

extraction, transformation and loading
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

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

SLA

A

service level agreements
many db can be subject to application SLAs that require 99.99% uptime. system failure can result in chaos and lawsuits. data warehouses may not have SLAs

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

purposes of a DW

A

descriptive
diagnostic
predictive
prescriptive

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

some reasons for DW failure

A
lack of executive support
lave of companion
lack of vision and imagination
lack of resources 
failure to understand magnitude and complexity
biting off too much 
no data steward function 
not understanding proper business objectives
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

cube

A

common term for the representation of multidimensional information
pre defined calculations
difficult back up and recovery
more security

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

OLAP

A

on-line analytical processing

cubes ofter refereed to as OLAP cubes

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

dimensional model

A

contains the same information as normalized model, but packages the data in a format that delivers user understandability, query performance and resilience to change

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

dimension

A

a particular attribute of information

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

data cleansing / scrubbing

A

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

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

data broker

A

a business that collects personal information about consumers and sells that information to other organizations

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

big data

A
more data than your firm can comfortably handle 
volume
velocity 
variety 
veracity
complexity
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

size of a terabyte

A

1000 gigabytes

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

size of a petabyte

A

1000 terabytes

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

two dominant sources

A

CGM - consumer generated media

IOT - internet of things

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

taxonomies

A

a scheme of classification

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

ontologies

A

a set of concepts and categories in a subject area that shows their properties and the relations between them

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

BLOB

A

binary large object

DB data type

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

percent of major corporation decisions by gut

A

40%

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

percent of major corporation decisions done correctly

A

50%

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

percent improvement using data directed approaches

A

5-6%

33
Q

hadoop

A

used to process big data

massive paralusm by parsing your data set across a cluster of computers

34
Q

map reduce

A

google, yahoo and facebook
index serach
translations
counting, summing, collating, filtering, parsing and sorting

35
Q

simple map and reduce

A
input
map and combine
shuffle and sort
reduce
output
36
Q

big data example failures

A

thatched roofs

watson and cancer

37
Q

hippo

A

highest paid persons opinion

38
Q

most disruptive technology identified by executives

A
artificial intelligence / machine learning
digital tech / internet of things
fin tech solutions
cloud computing
blackchain
39
Q

oakland a’s

A

analyze data for baseball team

on-base percentage and slugging percentage

40
Q

tableau

A

visual and popular
data access / manipulation
analysis
reporting

41
Q

distributed computing

A

processes and manages algorithms across many machines in a computing environment

42
Q

virtualization

A

the creation of a virtual version of computing resources

43
Q

data blending

A

altered
results in a dataset with the purpose of supporting analysis for a specific business question and is created by business and data analysts

44
Q

data mining

A

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

45
Q

recommendation engine

A

a data-mining algorithm that analyzes a consumers purchases and actions on a website and then uses the data to recommend complementary products

46
Q

affinity grouping analysis

A

reveals the relationship between variables along with the nature and frequency of the relationships

47
Q

market basket analysis

A

evaluates such items as websites and checkout scanner info to detect customers buying behavior and predict future behavior by identifying affinities among customers choices of products and services

48
Q

POI

A

point of interest

49
Q

POI example

A

digital yellow pages, name, address (lat and long)

50
Q

cluster analysis

A

a technique use to divide an information set into manually 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

51
Q

prediction

A

a statement about what will happen or might happen in the future

52
Q

data scientist

A

extracts knowledge from data by performing statistical analysis, data mining and advanced analytics on big data to identify trends, market changes and other relevant information

53
Q

analysis paralysis

A

occurs when the user goes into an emotional state of over-analysis a situation so that the decision or action is never taken, in effect paralyzing the outcome

54
Q

information system

A

software that helps you organize and analyze data

intersection of technology, people and process with an organization

55
Q

system

A

collection of parts that work together to achieve a goal or task

56
Q

systems analysis

A

a problem-solving or creative technique that composes a system of requirements into its component pieces for the purpose of studying how well those component parts work and interact to accomplish their purpose

57
Q

systems design

A

a complementary technique that reassembles a systems component pieces back into a complete system

58
Q

SDLC

A

systems development life cycle
planning, analysis, design, implementation/ preliminary investigation, system analysis, system design , development, implementation, maintenance

59
Q

output at each stage

A

planning - project plan
analysis - system proposal
design - system specification
implementation - new system and maintenance plan

60
Q

purposes at four stages

A

planning - initiate, feasibility, schedule, approval
analysis - business needs and requirements
design - define solution system
implementation - construct, test, train, install

61
Q

planning tasks

A

initiation - develop request and feasibility analysis

project management - work plan, staff, control and direct project

62
Q

analysis tasks

A

develop analysis strategy
gather requirements
develop a system proposal

63
Q

implementation

A

construct system
install system - training plan
establish a support plan

64
Q

system anaysis skills

A
technical 
business
analytical 
communications
interpersonal 
ethics
65
Q

system flowchart symbols

A

trapezoid - manual input
rectangle - process
triangle - off line strorage
squiggle - document

66
Q

CASE

A

computer-aided software engineering

67
Q

feasibility

A

economic
technical
operational

68
Q

implementation

A

direct - simply abandoning the old and staring up the new
parallel - old and new systems are operated side bu side util the new one proves to be reliable
pilot - new system is tried out in only one part of the organization
phased - new system is implemented gradually over a period of time

69
Q

prototyping

A

to build a model or prototype that can be modified before the actual system is installed

70
Q

RAD

A

rapid application development

71
Q

top down

A

divide and conqueror
break down
to identify the programs processing steps called modules

72
Q

pseudocode

A

an outline of the voice of the program you will write, summary of the program before it is written

73
Q

flowcharts

A
graphically present the detailed sequence of steps needed to solve a programming problem 
rectangle - process
quadrangle - input / output
diamond - decision
circle - connector 
rounded rectangle - terminal
74
Q

logice structures

A

sequence - 1..2..3..
selection - if -yes -no
repetition - describes a process that may be repeated as long as certain condition remains true

75
Q

debugging

A

the process of testing and then eliminating errors

76
Q

syntax errors

A

a violation of the rules of programming language

77
Q

logic errors

A

occur when the programmer uses incorrect calculation or leave out a programming procedure

78
Q

OOPs

A

object-oriented programming - process by which a program is organized into objects