Abstract:
An apparatus of managing data according to the present invention includes a query processor, a page monitor, a page layout manager and a data storage manager. The query processor processes a user query. At the time of processing the user query, the page monitor collects accessed column information and selectivity information of accessed columns from the query processor and collects access page information from a data storage manager to create page monitoring information. The page layout manager creates page column group information by grouping columns adjacent to each other for each page at a predetermined time interval based on the page monitoring information. The data storage manager stores data in a main memory by reconfiguring a page based on the page column group information for a candidate page of which an access frequency is greater than a predetermined access frequency based on the page monitoring information.
Abstract:
A merge join method by a merge join system including a database is provided. The merge join system unequally divides data after a current position of a join column participating in merge join in the database into K partitions, K being greater than 2, and compares the first value of each of remaining partitions excluding the first partition from the K partitions with a value to be searched for the merge join, in order to check whether the first value and the value to be searched satisfy a specific condition. Further, the merge join system determines a partition in which the value to be searched is expected to exist based on a comparison result, and applies a k-ary search to the determined partition.
Abstract:
Disclosed is an apparatus for in-memory data management includes a hybrid memory including a plurality of types of memories with different characteristics and a storage engine. The storage engine rearranges data among the plurality of memories by the unit of a page by monitoring workloads for data stored in the memories and reconfigures a page layout by the unit of the page based on a data access characteristic of an application for each of pages constituting each of the plurality of memories.
Abstract:
Disclosed herein are a method and an apparatus for processing a query based on a heterogeneous computing device. The method includes generating, by the apparatus for processing a query, an optimal query execution plan for processing the query using all of a plurality of computation resources included in a heterogeneous computation resource and dividing data corresponding to the query depending on a data division ration included in the query execution plan and allocating the divided data to each computation resource. Further, the divided data are each processed based on each computation resource.