Ch 1-4 (from notes in slides, textbook, & Pearson DSM) Flashcards

1
Q

What is Moore’s Law?

[Ch.1]

A

(MOORE TRANSISTORS) The number of transistors per square inch on an integrated chip doubles every 18 months.

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

What are the implications of Moore’s Law?

[Ch.1]

A

Computers are getting exponentially faster. The cost of data processing is approaching zero.

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

What is Metcalfe’s Law?

[Ch.1]

A

(NET CAFE = # of users) The value of a network is equal to the square of the number of users connected to it.

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

What are the implications of Metcalfe’s Law?

[Ch.1]

A

More digital devices are connected together. The value of digital and social networks is increasing exponentially.

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

What is Nielsen’s Law?

[Ch.1]

A

(N for NETWORK speed) Network connection speeds for high-end users will increase by 50 percent per year.

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

What are the implications of Nielsen’s Law?

[Ch.1]

A

Network speed is increasing. Higher speeds enable new products, platforms, and companies.

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

What is Kryder’s Law?

[Ch.1]

A

(Kryder = storage) The storage density on magnetic disks is increasing at an exponential rate.

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

What are the implications of Kryder’s Law?

[Ch.1]

A

Storage capacity is increasing exponentially. The cost of storing data is approaching zero.

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

What is Bell’s Law?

[Ch.1]

A

A new class of computers establishes a new industry each decade.

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

What skills will be marketable during your career?

[Ch.1]

A

Non-routine skills are: Abstract, collaboration, system of thinking, and ability to experiment. (the 4 Reich Components)

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

What are the five components of an Information System?

[Ch.1]

A

Hardware, Software, Data, Procedures, People.

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

What is information?

[Ch.1]

A

Processed data that has context and meaning and compared to data is generally a broader statement.

–here’s an example:
“The average hourly rate… is $8.25”
→ Information (aggregates data to show wage trends, explains what it is).

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

What is Data?

[Ch.1]

A

Raw, unprocessed facts that need context to become useful.

–here’s an example:
“Janet Carr receives four weeks of vacation”
→ Data (single fact without broader context).

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

What is the difference between Information Technology (IT) and Information Systems (IS)?

[Ch.1]

A

IT drives development of new IS. IT components = Hardware + Software + Data; IS = IT + Procedures + People.

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

What constitutes a strong password?

[Ch.1]

A

At least 12 characters; 14 is even better. It should not contain your username, real name, or a word in the dictionary.

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

What are the characteristics needed for quality information?

[Ch.1]

A

Accurate, Timely, Relevant, Just Barely Sufficient, Worth Its Cost.

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

Best describes the characteristic of ‘worth its cost’ in terms of good data

[Ch.1]

A

appropriate relationship must exist between the cost of data and its value.

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

What is the focus of Executive/Strategic management?

[Ch.1]

A

Long-term goals, environment scanning, strategy improvement.

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

What is the focus of Managerial/Tactical management?

[Ch.1]

A

Short-term planning, operational management, effectiveness improvement.

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

What is the focus of Operational management?

[Ch.1]

A

Day-to-day tasks, efficiency improvement.

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

How do information systems help at the Strategic level?

[Ch.1]

A

They enable SMARTER planning, decision-making, and risk/financial management.

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

How do information systems help at the Managerial level?

[Ch.1]

A

They provide BETTER performance monitoring, reporting, and resource allocation.

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

How do information systems help at the Operational level?

[Ch.1]

A

They facilitate FASTER automation, communication, and real-time data access.

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

Abstract Reasoning (4 Reich Components)

[Ch.1]

A

CONSTRUCT / MANIPULATE model or representation

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

System Thinking (4 Reich Components)

[Ch.1]

A

MODEL and SHOW how components interact/relate to each other (inputs and outputs)

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

whats a cheap and easy information system?

[Ch.1]

A

saves data in a batch and then processes it some hours later

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

What are the Five Forces that determine industry structure?

[Ch.2]

A

Porter’s 5 Forces:
1. Bargaining power of customers
2. Threat of substitutions
3. Bargaining power of suppliers
4. Threat of new entrants
5. Rivalry

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

Threat of new entrants (a Porter 5 force)

[Ch.2]

A

How easy it is for new businesses to enter a market and disrupt the existing players

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

Bargaining power of customer (a Porter 5 force)

[Ch.2]

A

influence they have when negotiating with suppliers, vendors, or sellers

ex. Toyota’s purchase of auto paint relies on consumer choice

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

Bargaining Power of suppliers (a Porter 5 force)

[Ch.2]

A

Suppliers can apply pressure to companies by lowering product quality or availability, or raising product prices.

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

Rivalry (a Porter 5 force)

[Ch.2]

A

measure of the extent of competition among existing firms

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

Ability to Experiment (4 Reich Components)

[Ch.1]

A

CREATE / TEST new promising alternatives

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

“Worth its cost” in terms of good data is:

[Ch.1]

A

An appropriate relationship must exist between the cost of data and its value.

[more ans coming soon]

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

Skills to develop to obtain a job in the MIS field

[Ch.1]

A

Abstract reasoning, collaboration, systems thinking, and experimentation

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

Information systems and computer technology provide job and wage benefits for…..

[Ch.1]

A

IS, business management, sales and support professionals, and beyond

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

MIS (Management Information Systems)

[Ch.1]

A

Help company achieve their strategies through people, technology, and organizations within a business setting, with the primary goal of utilizing computer-based information systems

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

Bill’s Hardware is a hardware store in a small community. Bill Snyder is the owner, and he employs 11 people who work various hours, six days a week. Bill has software that tracks his inventory, finances, and so on.

What data (not information) might you expect to find?

[Ch.1]

A

Bill pays his employees 11 holidays.

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

Information

[Ch.1]

A
  1. Knowledge derived from data
  2. Meaningfully presented data
  3. Data is processed by summing, ordering, averaging, or other similar operations.
  4. difference makes a difference
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

IS (Information System)

[Ch.1]

A

hardware, software, data.. etc.. used for purpose of producing information

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

Information Technology (IT)

[Ch.1]

A

Products, methods, inventions, standards used for purpose of producing information

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

Tech Skills Gap

[Ch.1]

A

Mismatch between high level of tech skills demanded by employees and low level of tech skills held by employees

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

Good Data is..

[Ch.1]

A
  1. Accurate
  2. Timely
  3. Relevant
    - to context/subject
  4. Just barely sufficient - ex. too much data -> need to ignore
  5. Worth it’s cost
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

What are Porter’s Four Competitive Strategies?

[Ch.2 (in wrong spot trying to fix)]

A

Cost leadership (broad focus), Differentiation (broad focus), Cost focus (narrow), Differentiation focus (narrow).

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

Collaboration (4 Reich Components)

[Ch.1]

A

Act of two or more people to create IDEAS/PLANS to achieve a COMMON GOAL

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

What is a Value Chain?

[Ch.2]

A

A network of value-creating activities transforming inputs into outputs.

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

Low-code-system

[Ch.2]

A

Quickly building applications in a visual way that requires less programming

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

Switching cost

[Ch.2]

A

Will have to pay a fee to their old job or supplier if they find work/alternatives at a different location.

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

BPMN Notation - Square

[Ch.2]

A

activity (i.e., select vendor product)

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

BPMN Notation - Rectangle with + symbol

[Ch.2]

A

subprocess (i.e,. setup product offering on website)

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

BPMN Notation - Parallelogram (leaning rectangle)

[Ch.2]

A

data repository where data can be read and written.

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

BPMN Notation - Diamond

[Ch.2]

A

a decision.

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

BPMN SYMBOLS

Circle -

Bolded Circle -

Labeled Dash Lines-

Solid Arrow -

[Ch.2]

A

Circle - Start

Bolded circle - end symbol

Labelled dashed lines - data flow.

Solid arrow - sequence flow

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

What is VALUE?

[Ch.2]

A

Amount of money that a customer is willing to pay for a resource, product, or service

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

Here’s value chain discussion example from DSM ;)

“Fill out this form, and bring it to me over here when you’re done.” is ________

“Bikes are over there. Help yourself.” is _______

“Show me the bike.” “OK, you owe $23.50. Pay up.” is ______

“You wanna bike?” is _______

[Ch.2]

A

“Fill out this form, and bring it to me over here when you’re done.” is RENT BIKE

“Bikes are over there. Help yourself.” is DETERMINE NEEDS

“Show me the bike.” “OK, you owe $23.50. Pay up.” is RETURN BIKE AND PAY

“You wanna bike?” is GREET CUSTOMER

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

What are the Primary Activities in the Value Chain?

[Ch.2]

A
  1. Inbound logistics,
  2. outbound logistics,
  3. operations/manufacturing,
  4. sales & marketing,
  5. customer service.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q

What are the Support Activities in the Value Chain?

[Ch.2]

A

Facilitate the primary activities and contribute only indirectly to the production, sale, and service of the product. –> Procurement, technology, HR, infrastructure.

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

What is Business Process?

[Ch.2]

A

Activities that transform inputs into outputs, adding value.

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

A competitor that replicates a business (ex. same hot dog stand as yours) is an example of a weak or strong example of threat of NEW ENTRANTS

[Ch.2]

A

STRONG! Because it is an easy business to replicate

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

A well-established business’s threat of new entrants is weak or strong? Ex. NBA number of teams

[Ch.2]

A

Weak! Hard to establish

(these kinds of questions can be answered with weak, medium or strong)

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

Startups

[Ch.2]

A

New businesses that require little capital and experience to begin operations (i.e., open corner latte stand)

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

Linkage

[Ch.2]

A

Interaction across value activities.

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

linkages (not to be confused with “linkage”)

[Ch.2]

A

Used by manufacturing systems to reduce inventory cost

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

How does Porter define a margin?

[Ch.2]

A

The difference between the value that an activity generates and the cost of the activity

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

a Unicorn is a

[Ch.2]

A

a tech company that reaches a $1 billion valuation in a short period of time. (REMEMBER $1 BILLION!!!)

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

Robotic process automation (aka RPA)

[Ch.2]

A

uses software robots to automate routine business processes.

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

Intelligent automation

[Ch.2]

A

combination using RPA to automate buissness/AI processes to improve decision making

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

Knowledge Workers

A

– Professionals who analyze, interpret, and apply data-driven insights to make informed decisions in an organization.

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

Business Intelligence (BI) Systems

[Ch.3]

A

Systems that process operational and other data to identify PATTERNS (not just identify), relationships, and trends for use by business professionals and other knowledge workers.

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

Business intelligence
(BI) - by itself

[Ch.3]

A

The process of using operational and other data to CREATE (instead of identify) information that exposes patterns, relationships, and trends of importance to the organization.

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

What are the three primary activities in the BI process?

[Ch.3]

A

Data Sources, Acquire Data, Perform Analysis, Publish Results.

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

What is a Data Warehouse?

[Ch.3]

A

A facility for managing an organization’s BI data, obtaining, cleansing, organizing, and cataloging data.

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

What are the main differences between Data Warehouses and Data Marts?

[Ch.3]

A

The main difference is cost; Data Marts are smaller.

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

What are the types of BI Analysis?

[Ch.3]

A

Reporting, Data Mining, Big Data.

74
Q

First-mover advantage

[Ch.2]

A

being first to develop new tech in market -> gaining market share

75
Q

What is Reporting Analysis?

[Ch.3]

A

Creating information about past performance by processing structured data.

76
Q

What is Data Mining?

[Ch.3]

A

Application of statistical techniques to find patterns and relationships among data for classification and prediction.

77
Q

What is Big Data?

[Ch.3]

A

Data is characterized by (3 V’s) volume, velocity, variety

78
Q

Data Swamp

[Ch.3]

A

Large amounts of data, that may never be used

79
Q

Data Lake

[Ch.3]

A

Storage (large) repositories that hold vast amounts of raw data in its native format until it is needed.

80
Q

Data Mart

[Ch.3]

A

Smaller, (not used as much for big org) more focused data collections that address the needs of a particular department or functional area of the business.

81
Q

What is the definition of a CPU?

[Ch.4]

A

Central Processing Unit - the brain of the computer.

82
Q

What is the difference between volatile and non-volatile memory?

[Ch.4]

A

Volatile memory loses contents when power is lost; non-volatile storage retains contents even with lost power.

83
Q

What is Augmented Reality (AR)?

[Ch.4]

A

The altering of reality by overlaying digital information on real-world objects.

84
Q

What is Mixed Reality (MR)?

[Ch.4]

A

The combination of the real physical world with interactive virtual images or objects.

85
Q

What is Virtual Reality (VR)?

[Ch.4]

A

A completely computer-generated virtual world with interactive digital objects.

86
Q

What is Financial Technology (FinTech)?

[Ch.4]

A

Designed to provide automated financial services, including cryptocurrencies and digital wallets.

87
Q

What is the definition of a Byte?

[Ch.4]

A

Number of bits (8 bits per 1 byte) to represent one character.

88
Q

What is the size of a Kilobyte?

[Ch.4]

A

1,024 bytes.

89
Q

What is the size of a Megabyte?

[Ch.4]

A

1,024 KB or 1,048,576 bytes.

90
Q

What is the size of a Gigabyte?

[Ch.4]

A

1,024 MB or 1,073,741,824 bytes.

91
Q

What is the size of a Terabyte?

[Ch.4]

A

1,024 GB or 1,099,511,627,776 bytes.

92
Q

What is the size of a Petabyte?

[Ch.4]

A

1,024 TB or 1,125,899,906,842,624 bytes.

93
Q

What is the size of an Exabyte?

[Ch.4]

A

1,024 PB or 1,152,921,504,606,846,976 bytes.

94
Q

What is the size of a Zettabyte?

[Ch.4]

A

1,024 EB or 1,180,591,620,717,411,303,424 bytes.

95
Q

Which of the following occurs when a server hosts many versions of desktop operating systems?

[Ch.4]

A

DESKTOP virtualization

96
Q

HORIZONTAL-market application software?

[Ch.4]

A

(off-the-shelf not customized) Provides capabilities common across all organizations and industries

97
Q

Firmware

[Ch.4]

A

Computer software that is installed on devices such as printers, print servers, and various types of communication devices (on Read Only Memory (ROM))

  • Software for hardware to make the hardware work
98
Q

VERTICAL-market application software?

[Ch.4]

A

“Off-the-shelf” specialized/customized (not just off-the-shelf like Horizontal) software designed to meet the specific needs of a particular industry or market segment.

99
Q

True or false?

Is 2D printing a disruptive force that has the power to change business?

[Ch.4]

A

FALSE

Limited Scope of Impact, already established.. etc..

100
Q

What is Andriod?

[Ch.4]

A

Google’s licensed OS for mobile devices

101
Q

What are Clients in tech?

[Ch.4]

A

Devices or applications (like tablets and smartphones) that request services or resources from a server.

102
Q

PC virtualization

[Ch.4]

A

Virtualization using a Personal Computer E.g.

Amanda uses only Linux at work, but her desktop (PC) at home hosts both Windows and Linux.

Her pc can virtualize both operating systems through her PERSONAL computer, hence PC virtualization

103
Q

Server

[Ch.4]

A

Computer or software system that provides data, services, or programs to OTHER COMPUTERS, called clients

(generalized definition: stationed computer system providing info to other computers)

104
Q

Open source code

[Ch.4]

A

Software that is typically free and modifiable, and its source code is publicly available

105
Q

GNU

[Ch.4]

A

Set of tools used to create a free Unix-like operating system.

106
Q

BENEFITS of cryptocurrencies?

[Ch.4]

A

Protected from Inflation

Difficult for governments to monitor

Typically have little to no fees

107
Q

FinTech innovations include

[Ch.4]

A

digital wallets &
peer-to-peer lending & cryptocurrency & online-only banks & financial robo-advisors

108
Q

Internet of Things (IoT)

[Ch.4]

A

Idea that objects are BECOMING CONNECTED to the INTERNET so that they can INTERACT with other DEVICES, applications, or services

109
Q

Operating System (OS)

[Ch.4]

A

Software that supports a computer’s basic functions

(A program that controls the computer’s resources)

110
Q

Bits

(remember a byte is 8 of this, as a bit is the lowest value)

[Ch.4]

A

used for computer data because they are easy to represent physically. A bit is either a zero or a one.

111
Q

Thin-client application

[Ch.4]

A

Application that runs on a server instead of on a client device

e.g. Google Docs runs on your browser and is not an installed app

(web applications would be the answer to the Dynamic study module)

112
Q

[Ch.4] Open-source applications and their type:

A Big Data Processing System: ______

A mobile-device operating system: _______

A Web server: ______

A NoSQL DBMS: _______

A browser: _______

A DBMS: ________

A

A Big Data processing system - Hadoop

A mobile-device operating system -Andriod

A Web server - Apache

A NoSQL DBMS - Cassandra

A browser - Firefox

A DBMS - MySQL

113
Q

DBMS

[Ch.4]

A

DBMS - is a Database Management System, to create, manage, and manipulate databases

114
Q

NoSQL

[Ch.4]

A

NoSQL - is a type of database that stores data in a non-tabular format

115
Q

one-of-a-kind application

[Ch.4]

A

Developed for a specific, unique need and custom-developed

116
Q

What is the first primary activity in the BI process?

[ch.3 additions onward]

A

Acquiring Data: Involves obtaining data from various sources, cleaning, organizing, and cataloging it.

117
Q

What is the second primary activity in the BI process?

A

Processing Data: Includes sorting, filtering, and aggregating data to transform it into meaningful information.

118
Q

What is the third primary activity in the BI process?

A

Publishing Data: Sharing the processed data with relevant stakeholders through reports, dashboards, and other visualization tools.

119
Q

What is dirty data?

A

Data with errors or irrelevant values, such as incorrect gender, age, phone numbers, or email addresses, which can hinder business intelligence (BI) analysis.

120
Q

What is missing data?

A

Purchased data often lacks certain elements, which can bias BI analysis if critical data points are missing.

121
Q

What is inconsistent data?

A

Data collected over time may have inconsistencies, such as changes in area codes or part codes, requiring recoding for consistency.

122
Q

What is nonintegrated data?

A

BI analysis may need data from various sources (internal systems, ecommerce, social networks), which must be integrated by data warehouse personnel.

123
Q

What is wrong granularity?

A

Data may be too fine or too coarse. Fine granularity can be aggregated, but coarse granularity cannot be disaggregated.

124
Q

What does too much data refer to?

A

Excessive attributes or data points can complicate analysis. The curse of dimensionality makes it easier to create models that fit sample data but are poor predictors. Statistical sampling can help manage large datasets.

125
Q

What is structured data?

A

Structured data is organized in rows and columns, typically found in relational databases or spreadsheets.

126
Q

What are exception reports?

A

Exception reports are generated when data falls outside predefined parameters.

127
Q

What are dynamic reports?

A

Dynamic reports are increasingly common with the use of mobile systems, as opposed to static printed reports.

128
Q

What is Machine to machine (M2M)?

A

M2M refers to direct communication between devices using a communication channel.

129
Q

What is Edge Computing?

A

Edge Computing places computing at the smart device, closer to the source of data.

This reduces the volume of data transmitted, processed, and stored in the cloud.

130
Q

What are the goals of GE’s Industrial Internet?

A

The goals are to increase efficiencies, reduce waste, and improve decision making.

It has the greatest potential for smart devices in hospitals, power grids, manufacturing plants, and transportation.

131
Q

What issues do smart buildings identify?

A

Smart buildings identify problems like wasteful lighting, competing heating and cooling systems, and rogue fans.

132
Q

Supervised Data Mining

A

Creating a model before analysis

133
Q

Data warehouse DBMS

A

Business intelligence applications and tools acquire data

134
Q

Static Report

A

data that is relevant to a specific point in time -> BI context, most static reports are published as PDF documents.

135
Q

MapReduce

A

Processes large amounts of data in parallel across a cluster of computers

136
Q

BI servers major functions

A

management and delivery

137
Q

Cluster Analysis

A

find groups of similar customers from customer order and demographic data.

138
Q

Data Acquisition

A

In business intelligence systems, the process of obtaining, cleaning, organizing, relating, and cataloging source data.

139
Q

Dynamic Report

A

a way to generate reports that automatically update when data changes. (opposed to static)

140
Q

first step in the development of a data warehouse

A

Extract data

141
Q

Decision-making BI / Decision support systems

A

older term that refers to which business intelligence task

142
Q

Final step in data warehouse

A

Cataloging the data

143
Q

push publishing process

A

(auto) forced given results

144
Q

pull publishing process.

A

need to request

145
Q

publish publishing process.

A

delivering to knowledge workers

146
Q

Data Discovery

A

User-friendly for users to view data in an easy way

147
Q

Regression Analysis

A

Type of supervised data mining that estimates values of parametres in linear equations

148
Q

Subscription

A

User makes scheduled or responsive requests for data

149
Q

upskill

A

teaching employees new skills to match new org needs

150
Q

Native application

A

app runs on computer not web only

151
Q

What is a database?

A

An organized connection of data; a collection of integrated records.

152
Q

What is the purpose of databases?

A

To organize and keep track of multiple themes, such as grades or emails.

153
Q

What is the general rule for data storage?

A

Single theme - store in a spreadsheet; Multiple themes - store in a database.

154
Q

Why is it important to learn about databases?

A

Databases are ubiquitous in commerce and help turn data into useful information.

155
Q

Hierarchy of Data Elements

A

Table or File (student number
student name HW1..), Records or Rows, Fields or Columns, and bytes or characters

156
Q

What are the components of a database?

A

Hierarchy of data elements and relationships among rows. So. Tables or files+ Relationship Among Rows in Tables + Metadata.

157
Q

What is a Database Management System (DBMS)?

A

A system that creates, processes, and administers databases.

158
Q

What are the functions of a DBMS?

A
  1. Creating the Database and its structures
  2. Processing the database
  3. Administering the database.
159
Q

What are some licensed DBMS vendors?

A

IBM, Microsoft, Oracle, and others.

160
Q

What is an example of an open-source DBMS?

A

MySQL: License-free for most applications.

161
Q

What are the DBMS process operations?

A
  1. Read
  2. Insert
  3. Modify
  4. Delete data.
162
Q

What is Structured Query Language (SQL)?

A

An international standard language for creating and processing databases.

163
Q

Provide an example of an SQL command.

A

INSERT INTO Student ([Student Number], [Student Name], H W1, H W2, MidTerm) VALUES (1000, ‘Franklin, Benjamin’, 90, 95, 100);

164
Q

What are the four elements of a database application?

A

Purposes, Forms, Reports, Queries, Application programs.

165
Q

What are the purposes of forms in a database application?

A

To view data, insert new, update existing, and delete existing data.

166
Q

What do reports do in a database application?

A

Provide a structured presentation of data using sorting, grouping, filtering, and other operations.

167
Q

What are queries used for in a database application?

A

To search using values provided by the user.

168
Q

What do application programs provide in a database application?

A

Security, data consistency, and special purpose processing.

169
Q

What are nontraditional DBMS products designed for?

A

To store new data differently with ACID properties.

170
Q

What does ACID stand for in database transactions?

A

Atomic, Consistent, Isolated, Durable.

171
Q

Other Nontraditional DBMS Product Traits

A
  • CONSISTENT, ISOLATED, DURABLE
    -Transactions processed in same manner; data in valid state (consistent).
  • Whether processed alone or in presence of millions of other transactions (isolated).
  • Once a transaction is stored it never goes away–even in the presence of failure (durable)
172
Q

New Internet Applications (i.e. Twitter) relationship with Nontraditonal DBMS Products

A

They don’t need ACID

173
Q

What is NoSQL?

A

Nonrelational DBMS that support high transaction rates without ACID transaction support.

174
Q

What is Dynamo?

A

Amazon-developed nonrelational data store.

175
Q

What is Bigtable?

A

Google-developed nonrelational data store.

176
Q

What is Cassandra?

A

Facebook-developed nonrelational data store using concepts from both Dynamo and Bigtable.

177
Q

What is a Top-Level Project (TLP)?

A

Open-source Cassandra by Apache.

178
Q

What are New SQL DBMS?

A

DBMS that process high levels of transactions but provide ACID support.

179
Q

What are in-memory DBMS using SQL extensions?

A

SAP HANA, Tableau.

180
Q

What is the current trend in data management?

A

CIOs looking to merge storage and analysis of cloud-based data.

181
Q

What was Laredo Petroleum’s old approach to data management?

A

Used numerous spreadsheets and manual calculations.

182
Q

What is the benefit of the new approach used by Laredo Petroleum?

A

Uses cloud storage and cloud analytics to enhance data analysis.