Search
Search Results
-
INVESTIGATION OF APPLICABILITY OF MULTIMODEL DATA WAREHOUSES IN GAMING INDUSTRY
А.А. Koblov , О.М. Romakina , А.S. Klemesheva , А. Z. Arseneva105-1212025-12-30Abstract ▼This paper examines the feasibility and effectiveness of using multi-model databases for storing and processing data in the gaming industry. Modern gaming projects are characterized by highly complex and heterogeneous data: from strictly structured information about players, items, and quests to semi-structured and tightly coupled data, such as recipe systems, dialog trees, clan relationships, and in-game encyclopedias. Existing approaches based on relational or single-model NoSQL storage systems often fail to provide the necessary flexibility, performance, and development ease for such complex scenarios. The aim of this study is to design and comparatively analyze the performance of a multi-model solution for typical gaming mechanics. The authors developed a multi-model storage structure based on the ArangoDB DBMS that integrates document, graph, and key-value data models. The solution architecture encompasses key RPG game components: player and inventory management, quest systems, dialogue, crafting recipes, loot tables, clan relationships, and full-text search of the in-game encyclopedia using ArangoSearch. The experimental section includes a detailed performance comparison of the developed multi-model storage system with the PostgreSQL relational DBMS and the MongoDB document DBMS on realistic datasets and queries. The results demonstrate a significant advantage of the multi-model approach when performing operations that require traversing complex relationships: for example, searching for hostile players through a clan relationship graph in ArangoDB is, on average, 11 times faster than a similar JOIN query in PostgreSQL. However, for scenarios with frequent modifications to linearly organized data (e.g., updating quest status), the multi-model storage system exhibits slightly lower performance compared to the relational model, which, however, is acceptable within the context of the overall game project architecture. The study confirms that multi-model DBMSs, particularly ArangoDB, represent a promising solution for the gaming industry, enabling efficient combination of different data models within a single platform, simplifying development, and achieving high performance on complex data, which is critical for modern multiplayer games.








