Mastering Data Management: A Battle of Transactional and Analytical Systems

• Transactional systems: Transactional systems are the ones where we deal with day-to-day data or present data. In such systems, we mostly talk about Inserts, updates, etc.?

Ex: ATM [when you withdraw Some amount then don't you feel that your current balance is updated]?

A single monolithic system is best suited- (Monolithic means one big system holding a lot of power. Ideally this is the best way to design a transactional system.)?

"RDBMS" is the best-suited system for Transactional systems. Because this handles transactions in a proper way. Ex: MySQL, Oracle, etc.?

?

• Analytical Systems: Analytical systems are the ones where we deal with historical data for some analysis. In such systems, we mostly talk about reads.? For the analytical system, since we deal with historically large amounts of data. A single system cannot handle the data anymore. We require a cluster of machines or distributed systems.???? "Data warehouses" are the best-suited systems for analytical systems. Ex: Teradata.?

Summary:

• If you want to handle transactional things then a database is the best Ex: MySQL, Oracle, etc.
• If you want to handle analytical things, then a data warehouse is the best Ex: Teradata