Respuesta :

raphealnwobi

Answer:

The answer is below

Explanation:

An OLTP (Online transaction processing) database is a database that allows for quick transaction processing. It involves inserting, deleting, updating data in the database.

OLTP has many drawbacks like if the system fails, all transactions are going to have problems. Also, since multiple users are allowed to access the data, it makes it prone to hackers.

The solution to the problems associated to the OLTP database is the OLAP (online analytical processing) database.

The OLAP systems allow users to analyze database information from multiple database systems at one time thereby allowing analysis for business decisions.

Martebi

The 2 cons of an OLTP database is that:

  • It has high Staff Dependency as it needs IT professionals and business people to implement and manage the running of OLTP database systems.
  • The risk of Data Loss is one that is very eminent.

What are the challenges faced in OLTP systems?

The OLTP system is one that is widely used business staffs. But it has its own issues such as:

  • It gives room for multiple users to access and alter the same data at the same time.
  • It needs concurrency control and recovery methods to avoid any unforeseen issues.
  • The data needed via OLTP systems are not really needed for decision making.

Learn more about database from

https://brainly.com/question/518894

Otras preguntas