Best performance by separating OLTP and OLAP workload
How to achieve best performance by separating OLTP and OLAP workload by Real-Time Data Replication.Measuring the database performance allows you to answer the question, in which part (in percentage) the database is utilized by OLTP and OLAP operations and how their occurrence in one database instance influences each other. To improve the performance and reliability of the database, the best way is to separate these tasks using Real-Time Data Replication software solution. The result is a complete separation of OLTP operations from OLAP operations and at the same time guarantees that OLAP operations will be performed on real data. The implementation project of the Real-Time Data Replication system should be completed with a comparison of the performance of the database that supports OLTP processes before and after the implementation of Real-Time Data Replication mechanism.
Der Vortrag findet am Dienstag, den 15. Mai 2018 um 09:15 Uhr statt.
Der Referenten sind Dariusz Markowski, DBPLUS und Michael Roedeske, DBPLUS c/o webtelligence IT consulting GmbH
Mehr:
https://programm.doag.org/datenbank/2018/#/scheduledEvent/558787