Efficient cross-device OLTP/OLAP processing in hybrid CPU/co-processor database systems

目前，我们在数据库系统中面临两个挑战。首先，数据库系统必须结合联合收割机联机事务处理（OLTP）和联机分析处理（OLAP）工作负载，以实现实时商业智能。需要真实的商业智能来提高创建的报告和分析的质量，因为最新的数据被用于分析，而不是在传统的数据库系统中处理的历史数据。因此，计算机系统的架构正在从单核CPU向由协处理器支持的多核CPU转变。数据库系统必须考虑这两种趋势，以提高系统的质量，提高性能，并确保数据库系统能够科普未来的需求（例如，不幸的是，当前的研究方法仅限于这些挑战之一，要么在传统的基于CPU的系统中组合OLTP/OLAP工作负载，要么在具有若干限制的单个工作负载类型上使用协处理器。因此，到目前为止，还没有一种综合办法来考虑这两项挑战。在这个项目中，我们希望面对数据库系统的两个挑战，以便在混合CPU/协处理器系统中有效处理混合OLTP/OLAP工作负载，这是高效实时商业智能所必需的。因此，主要的挑战是在混合系统中保证OLTP和混合OLTP/OLAP工作负载所需的ACID属性，同时确保混合工作负载的有效处理。

Nowadays, we face two challenges in database systems. First, database systems must combine online transactional processing (OLTP) and online analytical processing (OLAP) workloads to enable real-time business intelligence. Real time business intelligence is needed to improve the quality of created reports and analyses, because up-to-date data is used for analysis instead of historical data, processed in traditional database systems.Second, computer systems become increasingly heterogeneous to provide better hardware performance. Therefore, the architecture of computer systems is changing from single-core CPUs to multi-core CPUs supported by co-processors. Database systems must consider both trends to improve the quality of the systems, to increase the performance, and to ensure that database systems can cope with future requirements (e.g., more complex queries or increased data volume).Unfortunately, current research approaches are restricted to one of these challenges, either combining OLTP/OLAP workloads in traditional CPU-based systems or using co-processors on a single workload type with several restrictions. Therefore, up to now, no holistic approach considering both challenges exists. In this project, we want to face both challenges of database systems to enable efficient processing of mixed OLTP/OLAP workloads in hybrid CPU/co-processor systems, necessary for efficient real-time business intelligence. Hereby, the main challenge is to guarantee the ACID properties, needed for OLTP and mixed OLTP/OLAP workloads, in hybrid systems, while ensuring efficient processing of the mixed workloads.