Why We Created Yet Another Memory Framework: Understanding MGA's Role in Next-Gen Database Systems

2026-08-24

AI Summary

为解决现代数据库系统中高效内存管理的问题，本文提出了一种名为MGA的共享内存抽象方法，该方法在保证性能的同时减少了内存碎片和数据复制。

Abstract

Despite the presence of multiple memory regions in modern database systems, supporting an efficient form of memory remains a challenge under production constraints. In enterprise-grade data systems, existing abstractions impose a trade-off between coarse-grained global sharing and strict process isolation, resulting in data copying, memory fragmentation, and limited support for controlled sharing. These challenges become more pronounced as workloads grow more diverse, and systems must tolerate process failures while maintaining predictable performance. This paper introduces the Managed Global Area (MGA), a scoped shared-memory abstraction in Oracle AI Database that addresses these limitations. MGA allows components to explicitly define allocation source, membership, and coordination semantics across selected processes while integrating with a production database engine. Unlike fully shared memory regions in Oracle, such as the System Global Area (SGA), MGA supports dynamic process membership and modular memory usage without imposing system-wide visibility. We evaluate MGA on analytical and AI workloads that stress shared-memory execution, including TPC-H hash joins and ONNX Runtime inference. Under concurrent execution, MGA reduces latency for join-intensive TPC-H queries by up to 35%. For ONNX- based inference, MGA-enabled model sharing reduces memory footprint by up to 90% and lowers large-model inference latency by up to 37%. These results demonstrate that dynamically scoped shared memory can improve both efficiency and predictability in production database systems.

Problem

• memory regions
• production constraints
• data copying
• memory fragmentation
• controlled sharing

Innovation

• Managed Global Area
• scoped shared-memory abstraction
• dynamic process membership
• modular memory usage
• predictable performance