Chapter 4 Flashcards

1
Q

What are the two types of online processing sYstems

A

An online transaction processing ( OLTP )

Online analytical processing ( OLAP)

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

OLTP are

A

systems that supports the core business functions

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

OLAP are

A

Systems focus on leveraging the data info

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

What , how and when does OLTP process

A

What : Process transaction
How : Modifies database by changing transaction data
When : real time

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

What how and when does OLAP process

A

What : process reports and analytics
How : Queries the database to answer real question
When real time

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

What are the level of info systems

A

Executive support systems ( ESS)
Decision support systems ( DSS)
Management information systems (MIS)
Transaction processing systems ( TPS)

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

Executive support systems ( ESS) is and who use them

A

support strategic decision making and are subset of decision support systems. and its use by executive leadership

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

Decision support systems (DSS) is and who use them

A

assist in solving nonroutine problems and unstructured decision making and is use by upper level management

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

Management information systems ( MIS) is and who use them

A

assist in routine management activities and is use by middle management

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

Transaction processing systems is and who use them

A

process day to day business activities and provide a foundation for other systems (capture data) and is use by workers

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

What is Batch Processing

A

is when the data is collected but process later

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

What are the three main benefits of Batch processing

A

Efficiency
Simplicity
Quality data

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

What are the step of batch processing

A

business events
create file
update file
schedule batch
update database

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

What is software

A

the interface between the component and the users

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

What is systems software

A

specialized software that runs a computer hardware and other hardware

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

What are the type of systems software

A

Database management systems ( DBMS)
Data communication software
Utility programs

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

Describe Database management systems

A

used to defined manipulate, retrieve and manage data in the databases : ex: oracle,SQL server

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

Describe Data communication software

A

provide remote access to exchange data between computer and user ex: email, file transfer protocol

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

Describe utility programs

A

use for analyzing configuring and optimizing and maintaining a computer ex: antivirus, disk cleaners

20
Q

What are the risk when buying software from third party

A

Copyright
Data breaches
Disruptions
Updates

21
Q

What are the risk to in house developping software

A

Budgeting
Scheduling
Technical specifications
External market
Fraud

22
Q

What is cloud computing

A

provides access to shared resources over
the internet
Allows company to minimize computer resources kept on hand

23
Q

What are the three cloud deployment models

A

Private (customized, high security)
Public ( readily available , lower cost
Hybrid ( moderate cost and security ,increase flexibility )

24
Q

What are the cloud computing services models

A

Software as service (SAAS)
Platform as service ( PAAS)
Infrastructure as a service ( IAA)

25
Q

Software as services does

A

Utilizes the internet to provide customers with
applications that are managed by the third-party
provider. (ex: google drive, microsoft office)

26
Q

Platform as service does

A

Provides customers a platform for software
development that is delivered remotely. ex: google app engine , Openshift

27
Q

Infrastructure as service does

A

Provides customers with fully self-service
computers, networking, storage, and operating
systems through virtualized environments. Ex : amazon wen service, microsoft azure

28
Q

What are the risk as a SaaS cloud provider

A

Reliability, privacy and security

29
Q

What are control activities for small business

A

segregation of duties, physical access and logical access

30
Q

What are the two ways a company can grow

A

Organic and acquisition based growth

31
Q

Whats is acquisition

A

when one company take control of the other

32
Q

What is a merger

A

when the new company is a combines of the two business

33
Q

Explain systems integration

A

The process of joining different systems or substems into one larger system and ensuring that hey function as one systems

34
Q

Explain a lift and shift

A

is when the acquiring company moves the acquired systems, placing it in the data center maintaining the existing systems as they are and the users have access to all the systems at the same time

35
Q

Explain immediate integration

A

that when multiples systems requires converting existing data in the system to be retired and migrating it into the new systems and the original systems are then eliminated

36
Q

What us a centralized systems

A

connect all users to one central location built around a server that all authorized users can acess

37
Q

What are the advantages of centralized systems

A

easier to set up
Data is easy to access
Consistency in processing
Cost is lower

38
Q

What are the disadvantage of centralized systems

A

risk of disruption is greater
may experience transaction bottlenecks if traffic is high
Other location may experience lag time

39
Q

What is decentralized systems

A

utilizes multiples locations that each maintain a copy of the data needed for its connected systems. Not all users are connected to all acess points

40
Q

What are the advantage of decentralized systems

A

processing power and data storage needed is reduced
higher responsiveness
Processing bottlenecks are reduced
if one systems fail there are others

41
Q

What are the disadvantage of decentralized systems

A

increase of security risk
Cost of installing is higher

42
Q

What is distributed system

A

all the users and systems are directly connected to one another across the network, the processing and database are distributed among several business locations

43
Q

What are the advantage of distributed system

A

communication among the users
Real time transaction details are more readily
Reduction or complete elimination of expensive central processing site

44
Q

What are the disadvantage of distributed system

A

expensive
difficult to implement

45
Q

What could be solution for disparate systems that cannot easily communicate

A

ERP ( enterprise resource planning )

46
Q

ERP is

A

solution that integrate multiple system into single cohesive communication system