APPARATUS OF MANAGING DATA AND METHOD FOR MANAGING DATA FOR SUPPORTING MIXED WORKLOAD
    1.
    发明申请
    APPARATUS OF MANAGING DATA AND METHOD FOR MANAGING DATA FOR SUPPORTING MIXED WORKLOAD 审中-公开
    管理数据的装置和用于支持混合工作负载的数据管理方法

    公开(公告)号:US20150213107A1

    公开(公告)日:2015-07-30

    申请号:US14595138

    申请日:2015-01-12

    CPC classification number: G06F16/2365

    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 translation: 根据本发明的管理数据的装置包括查询处理器,页面监视器,页面布局管理器和数据存储管理器。 查询处理器处理用户查询。 在处理用户查询时,页面监视器从查询处理器收集所访问列的访问列信息和选择性信息,并从数据存储管理器收集访问页面信息以创建页面监视信息。 页面布局管理器基于页面监视信息以预定的时间间隔对每个页面彼此相邻的列进行分组来创建页面列组信息。 数据存储管理器基于页面监视信息,基于用于访问频率大于预定访问频率的候选页面的页面列组信息重新配置页面来将数据存储在主存储器中。

    COLUMN GROUP SELECTION METHOD AND APPARATUS FOR EFFICIENTLY STORING DATA IN MIXED OLAP/OLTP WORKLOAD ENVIRONMENT
    2.
    发明申请
    COLUMN GROUP SELECTION METHOD AND APPARATUS FOR EFFICIENTLY STORING DATA IN MIXED OLAP/OLTP WORKLOAD ENVIRONMENT 审中-公开
    用于混合OLAP / OLTP工作负载环境中有效存储数据的列选择方法和装置

    公开(公告)号:US20160117350A1

    公开(公告)日:2016-04-28

    申请号:US14920399

    申请日:2015-10-22

    Inventor: Kyoung Hyun PARK

    CPC classification number: G06F16/221 G06F16/283

    Abstract: Disclosed is a technology for data storage management in a database system, and more particularly, a data storage technology for a mixed OLAP/OLTP workload. A column group selection apparatus for efficiently storing data in a mixed workload processing environment includes a query processor configured to create column access information about queries that are input, a page monitoring module configured to create page-specific query pattern information using information about a page at which each of the input queries accesses and the column access information, a page layout manager configured to create page column group information in which a column group to be used to form each page is selected by applying a tree-based algorithm for selecting a column group to the page-specific query pattern information, and a data storage manager configured to create and store pages in units of column groups based on the page column group information.

    Abstract translation: 公开了一种用于数据库系统中的数据存储管理的技术,更具体地,涉及用于混合OLAP / OLTP工作负载的数据存储技术。 一种用于在混合工作量处理环境中有效地存储数据的列组选择装置,包括:查询处理器,被配置为创建关于输入的查询的列访问信息;页面监视模块,被配置为使用关于页面的信息来创建页面特定的查询模式信息 其中每个输入查询访问和列访问信息,页面布局管理器被配置为创建页列组信息,其中通过应用用于选择列组的基于树的算法来选择要用于形成每个页面的列组 涉及特定于页面的查询模式信息,以及数据存储管理器,被配置为基于页面列组信息以列组为单位创建和存储页面。

    APPARATUS FOR IN-MEMORY DATA MANAGEMENT AND METHOD FOR IN-MEMORY DATA MANAGEMENT
    3.
    发明申请
    APPARATUS FOR IN-MEMORY DATA MANAGEMENT AND METHOD FOR IN-MEMORY DATA MANAGEMENT 审中-公开
    用于内存数据管理的设备和用于内存数据管理的方法

    公开(公告)号:US20150212741A1

    公开(公告)日:2015-07-30

    申请号:US14606916

    申请日:2015-01-27

    CPC classification number: G06F3/0613 G06F3/0647 G06F3/068 G06F3/0685

    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 translation: 公开了一种用于存储器内数据管理的装置,包括具有不同特性的多种类型的存储器和存储引擎的混合存储器。 存储引擎通过监视存储在存储器中的数据的工作负载来重新排列多个存储器中的数据,并通过基于页面单元的页面单元重新配置页面布局,每个页面构成 每个多个存储器。

Patent Agency Ranking