The difference between a transactional and reporting database

Question

A friend commented like this:

I would recommend separating your transaction data and your report data into a separate database

And another said to me:

I would execute an ER schema in transactional data and an asterisk for a report database

Can anyone make it so clear to me? I ask because I really did not understand the difference?

Answer 1

This is a transactional database : a transactional database is a DBMS in which write operations in the database can be discarded if they are not completed correctly.

If the transactional database system loses electricity halfway through the transaction, the partially completed transaction will be discarded and the database will be restored to the state in which it was before the transaction began.

This is a reporting database : a database used for reporting applications. Reporting databases often duplicate transactional databases used to process reports using transactions from a transactional database.