APPARATUS OF MANAGING DATA AND METHOD FOR MANAGING DATA FOR SUPPORTING MIXED WORKLOAD
First Claim
1. An apparatus of managing data, the apparatus comprising:
- a query processor configured to process a user query;
a page monitor configured to collect accessed column information and selectivity information of accessed columns from the query processor at the time of processing the user query and collect access page information at the time of processing the user query from a data storage manager to create page monitoring information;
a page layout manager configured to create 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; and
the data storage manager configured to store 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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
15 Claims
-
1. An apparatus of managing data, the apparatus comprising:
-
a query processor configured to process a user query; a page monitor configured to collect accessed column information and selectivity information of accessed columns from the query processor at the time of processing the user query and collect access page information at the time of processing the user query from a data storage manager to create page monitoring information; a page layout manager configured to create 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; and the data storage manager configured to store 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. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method of managing data, the method comprising:
-
creating page monitoring information by collecting accessed column information, selectivity of accessed columns, and access page information at the time of processing a user query; creating page column group information at a predetermined time interval by grouping columns adjacent to each other for each page based on the page monitoring information; reconfiguring a candidate page of which an access frequency is more than a predetermined access frequency based on the page column group information, the candidate page reconfigured being selected based on the page monitoring information; and storing data in a main memory based on the reconfigured page column group information. - View Dependent Claims (9, 10, 11, 12, 13, 14, 15)
-
Specification