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

如今，我们在数据库系统方面面临着两个挑战。首先，数据库系统必须将在线事务处理(OLTP)和在线分析处理(OLAP)工作负载结合起来，以实现实时商业智能。需要实时商业智能来提高创建的报告和分析的质量，因为在传统数据库系统中处理的是最新数据而不是历史数据。其次，计算机系统变得越来越异构化，以提供更好的硬件性能。因此，计算机系统的体系结构正在从单核CPU向协处理器支持的多核CPU转变。数据库系统必须考虑这两种趋势，以改善系统质量，提高性能，并确保数据库系统能够应对未来的需求(例如，更复杂的查询或增加的数据量)。遗憾的是，目前的研究方法仅限于其中一种挑战，要么将OLTP/OLAP工作负载组合在基于传统CPU的系统中，要么在具有多个限制的单一工作负载类型上使用协处理器。因此，到目前为止，还没有考虑到这两个挑战的整体方法。在这个项目中，我们希望面对数据库系统的两个挑战，以支持在混合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.