Backend Systems Flashcards
What’s a transaction?
any business event that generates data worthy of being captured and stored in a database
What is Transaction Processing system (TPS)
process that supports monitoring, collection, storage, and processing of data from orgs
There’s OLTP, batch, and source data automation
think of it like the middle between a transaction happening and the database of the company
What is Online transaction processing (OLTP)
business transactions are processed online as soon as they occur
what is batch processing
collects data from transactions as they occur, placing them in groups, or batches. The system then prepares and processes the batches periodically.
Difference between OLTP and batch processing
OLTP its processed as soon as it occurs but for batch it collects the data and places it into batches and then processes each batch
What are the characteristics of a TPS
- continuous real time data collection
- Efficiently handles high volumes of data and large variations in those volumes
- Avoids errors and downtime
- Records results accurately and securely
- Maintains privacy and security
What are Enterprise Resource Planning (ERP) Systems
ERP systems adopt a business process view of the overall organization to integrate the planning, management, and use of all of an organization’s resources, employing a common software platform and database.
ERP compared to FAIS
ERP systems are an evolution of FAIS. That is, ERP systems have much the same functionality as FAIS, and they produce the same reports. ERP systems simply integrate the functions of the individual FAIS.
What are core ERP modules and extended ERP modules
Core: Financial, operations, and HR management
Extended: Customer relationship management, supply chain management, business intelligence, and e-business
Benefits of ERP systems
- Org flexibility and agility
- Decision support
- Quality and efficiency
What are limitations of ERP systems
- ERP is based on best practices so the business might need to change their ways
- ERP can be complex, costly, and time consuming
ERP implementation failure
- failure to involve employees affected
- Too much too fast
- Insufficient training
- Failure to perform proper data conversion and testing
Implementing ERP systems (2 ways)
On-premis ERP implementation and Software-as-a-service (SaaS)
What is the on premise ERP
- Vanilla approach standard ERP package, using built-in configuration. makes implementing quick, but limited in adapting to the org
- Custom approach:More custom by developing new ERP functions designed for the firm. Decisions concerning ERP degree of customization are specific to each org. Expensive and risky.
- Best of breed approach: combines benefits of vanilla and customized while avoiding extensive costs and risks with complete customization.
What is the SaaS
- System can be used from any location that has internet access
- Companiesusing cloud-based ERP avoid the initial hardware and software expenses that are typical of on-premise implementations
- Cloud based ERP solutions are scalable
