Distributed in-memory database system and method for managing database thereof

Abstract

Disclosed herein is a distributed in-memory database system for partitioning a database and allocating the partitioned database to a plurality of distributed nodes, wherein at least one of the plurality of nodes includes a plurality of central processing unit (CPU) sockets in which a plurality of CPU cores are installed, respectively; a plurality of memories respectively connected to the plurality of CPU sockets; and a plurality of database server instances managing allocated database partitions, wherein each database server instance is installed in units of CPU socket groups including a single CPU socket or at least two CPU sockets.

Description

CROSS-REFERENCE TO RELATED APPLICATION[0001]This application claims priority to and the benefit of Korean Patent Application No. 10-2016-0165293 filed in the Korean Intellectual Property Office on Dec. 6, 2016, the entire contents of which are incorporated herein by reference.BACKGROUND OF THE INVENTION(a) Field of the Invention[0002]The present invention relates to a distributed in-memory database system and a method for managing a database thereof. More particularly, the present invention relates to a method for managing a distributed in-memory database having a shared-nothing architecture in distributed nodes environment including multiple processors having a non-uniform memory access (NUMA) architecture.(b) Description of the Related Art[0003]A database system is different in an optimal system architecture and a data storage management method depending on whether a workload is based on transactional processing or analytical processing.[0004]A distributed in-memory database syste...

AI Technical Summary

Benefits of technology

The present invention provides a distributed in-memory database system and a method for managing a database in such a system that enhances the analytical query processing rate. The system takes into account the cost of load balancing and the local memory access proportion to optimize its performance. The method involves a two-step process of hardware resource allocation adjustment and partition allocation adjustment, starting with a group with low database access cost and progressing to a group with low cost for partition transfer. This invention improves the efficiency and speed of data processing in distributed in-memory database systems.

Problems solved by technology

However, in cases where a multi-processor system constituting a node has a non-uniform memory access (NUMA) architecture, a data access delay to rate and a data transfer bandwidth are varied depending on a memory position in which data is stored and a core position in which a query processing thread is executed, and thus, a method for managing data within a node is required to be reconsidered.

That is, the core-based shared-nothing architecture is difficult to extendedly apply to the existing transaction centric-database system in which several threads simultaneously access data.

In the shared-nothing architecture, when a load balance of database server instances may be lost according to a utilization situation of each partition, and thus, when a specific instance is overloaded, overall query processing performance is degraded.

As the number of partitions and the number of database server instances are increased, the searching space for an optimal partition reconfiguring method is increased and it makes a time and computing resource consumption for deriving an optimal method increase.

Also, as reconfigured database server instances are increased, an entire database service is delayed.

To this end, a candidate group set is limited in reconfiguring partitions to shorten a partition plan establishment time, but research into a method for limiting a candidate group set with consideration for even cost incurred for partition reconfiguration has not been conducted yet.

Images