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