Chapter 4 Flashcards
What are the two types of online processing sYstems
An online transaction processing ( OLTP )
Online analytical processing ( OLAP)
OLTP are
systems that supports the core business functions
OLAP are
Systems focus on leveraging the data info
What , how and when does OLTP process
What : Process transaction
How : Modifies database by changing transaction data
When : real time
What how and when does OLAP process
What : process reports and analytics
How : Queries the database to answer real question
When real time
What are the level of info systems
Executive support systems ( ESS)
Decision support systems ( DSS)
Management information systems (MIS)
Transaction processing systems ( TPS)
Executive support systems ( ESS) is and who use them
support strategic decision making and are subset of decision support systems. and its use by executive leadership
Decision support systems (DSS) is and who use them
assist in solving nonroutine problems and unstructured decision making and is use by upper level management
Management information systems ( MIS) is and who use them
assist in routine management activities and is use by middle management
Transaction processing systems is and who use them
process day to day business activities and provide a foundation for other systems (capture data) and is use by workers
What is Batch Processing
is when the data is collected but process later
What are the three main benefits of Batch processing
Efficiency
Simplicity
Quality data
What are the step of batch processing
business events
create file
update file
schedule batch
update database
What is software
the interface between the component and the users
What is systems software
specialized software that runs a computer hardware and other hardware
What are the type of systems software
Database management systems ( DBMS)
Data communication software
Utility programs
Describe Database management systems
used to defined manipulate, retrieve and manage data in the databases : ex: oracle,SQL server
Describe Data communication software
provide remote access to exchange data between computer and user ex: email, file transfer protocol
Describe utility programs
use for analyzing configuring and optimizing and maintaining a computer ex: antivirus, disk cleaners
What are the risk when buying software from third party
Copyright
Data breaches
Disruptions
Updates
What are the risk to in house developping software
Budgeting
Scheduling
Technical specifications
External market
Fraud
What is cloud computing
provides access to shared resources over
the internet
Allows company to minimize computer resources kept on hand
What are the three cloud deployment models
Private (customized, high security)
Public ( readily available , lower cost
Hybrid ( moderate cost and security ,increase flexibility )
What are the cloud computing services models
Software as service (SAAS)
Platform as service ( PAAS)
Infrastructure as a service ( IAA)
Software as services does
Utilizes the internet to provide customers with
applications that are managed by the third-party
provider. (ex: google drive, microsoft office)
Platform as service does
Provides customers a platform for software
development that is delivered remotely. ex: google app engine , Openshift
Infrastructure as service does
Provides customers with fully self-service
computers, networking, storage, and operating
systems through virtualized environments. Ex : amazon wen service, microsoft azure
What are the risk as a SaaS cloud provider
Reliability, privacy and security
What are control activities for small business
segregation of duties, physical access and logical access
What are the two ways a company can grow
Organic and acquisition based growth
Whats is acquisition
when one company take control of the other
What is a merger
when the new company is a combines of the two business
Explain systems integration
The process of joining different systems or substems into one larger system and ensuring that hey function as one systems
Explain a lift and shift
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
Explain immediate integration
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
What us a centralized systems
connect all users to one central location built around a server that all authorized users can acess
What are the advantages of centralized systems
easier to set up
Data is easy to access
Consistency in processing
Cost is lower
What are the disadvantage of centralized systems
risk of disruption is greater
may experience transaction bottlenecks if traffic is high
Other location may experience lag time
What is decentralized systems
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
What are the advantage of decentralized systems
processing power and data storage needed is reduced
higher responsiveness
Processing bottlenecks are reduced
if one systems fail there are others
What are the disadvantage of decentralized systems
increase of security risk
Cost of installing is higher
What is distributed system
all the users and systems are directly connected to one another across the network, the processing and database are distributed among several business locations
What are the advantage of distributed system
communication among the users
Real time transaction details are more readily
Reduction or complete elimination of expensive central processing site
What are the disadvantage of distributed system
expensive
difficult to implement
What could be solution for disparate systems that cannot easily communicate
ERP ( enterprise resource planning )
ERP is
solution that integrate multiple system into single cohesive communication system
