| Data allocation setting in computer system -> Monitor Keywords |
|
|
 
Data allocation setting in computer systemRelated Patent Categories: Data Processing: Database And File Management Or Data Structures, Database Schema Or Data Structure, Generating Database Or Data Structure (e.g., Via User Interface)Data allocation setting in computer system description/claimsThe Patent Description & Claims data below is from USPTO Patent Application 20060184565, Data allocation setting in computer system. Brief Patent Description - Full Patent Description - Patent Application Claims
CROSS REFERENCE TO RELATED APPLICATIONS [0001] The present application claims the priority based on Japanese Patent Application No. 2005-35863 filed on Feb. 14, 2005, the disclosure of which is hereby incorporated herein by reference in its entirety. BACKGROUND OF THE INVENTION [0002] 1. Field of the Invention [0003] The present invention relates to a technology for setting allocation of database data in a computer system. [0004] 2. Description of the Related Art [0005] In a computer system that handles database containing large amount of data, the database data is generally stored in physical storage areas (such as disks) belonging to a storage device system (such as a storage system). A database management system (hereinafter `DBMS`) that runs on a computer belonging to the computer system performs database-related processing accessing the database data stored in the physical storage areas of the storage device system. Consequently, DBMS processing performance is affected by data access performance for the physical storage areas in which the database data is stored. The data access performance for the physical storage areas fluctuates depending on the frequency with which the data stored in each physical storage area is accessed by the DBMS. Therefore, in order to increase DBMS processing performance, it is important to set allocation of the database data in the physical storage areas while taking into consideration the frequencies with which the physical storage areas are accessed. [0006] A technology is described in JP2003-150414A, for example, for estimating the access frequencies for the physical storage areas using allocation information that indicates the relationships between a table or the like composing a database and the physical storage areas in which the table or other data is stored, as well as history information regarding processing commands (such as SQL phrases) executed by the DBMS. A technology is also described in U.S. Pat. No. 6,035,306, for example, for notifying an administrator of a problem about the allocation of database data within physical storage areas using allocation information that indicates the relationships between a table or the like composing a database and the physical storage areas in which the table or other data is stored, as well as the results of monitoring of the access frequencies for the physical storage areas. [0007] In general, the data for tables or the like composing a database is divided and allocated across multiple physical storage areas. There are often variations in data storage density among the various physical storage areas, as well as variations in the frequency of DBMS access, depending on the table and other data allocated to each physical storage area. Furthermore, these variations often change during database use. Consequently, using the above prior art technologies, it is difficult to accurately monitor or estimate the access frequencies for the various physical storage areas, making it difficult to set the allocation of database data among the various physical storage areas while taking into account the physical storage area access frequencies. SUMMARY OF THE INVENTION [0008] An object of the present invention is to provide a technology to enable allocation of database data among physical storage areas to be set while taking into account the access frequencies for these various physical storage areas. [0009] In one aspect of the present invention, there is provided a computer for use in a computer system including multiple physical storage areas for storing database data. The database includes component information having a reference item having plural value ranges. The database data is dividable according to value ranges of the reference item. The computer comprises an access frequency obtaining module and a data allocation module. The access frequency obtaining module obtains, for each value range of the reference item in the component information, an estimated access frequency for data of the component information. The data allocation module allocates, based on the obtained estimated access frequency, data of the component information divided according to the value ranges of the reference item to the physical storage areas to be stored. [0010] With this computer, estimated access frequency for data of the component information is obtained for each value range of the reference item, and data of the component information divided according to the value ranges of the reference item can be allocated to the physical storage areas to be stored based on the obtained estimated access frequency. Consequently, with this computer, database data can be allocated to physical storage areas while taking into account the frequency with which each physical storage area is accessed. [0011] The present invention can be realized in a various aspects. For example, the present invention can be realized in aspects such as a computer, a computer system, a data allocation setting method and device, a data allocation management method and device, a data storage method and device, a data migration method and device, a computer program for effecting the functions of such methods or devices, a computer program set including such computer program, a recording medium for recording such computer program, and data signals in which such a computer program is carried on the carrier wave. [0012] Where the present invention is composed as a computer program or a recording medium on which such computer program is recorded, the program may comprise a program that controls the overall operation of the computer system or a program that separately controls the operation of each computer or each storage device system. [0013] These and other objects, features, aspects, and advantages of the present invention will become more apparent from the following detailed description of the preferred embodiments with the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS [0014] FIG. 1 is a block diagram showing construction of a computer system in Embodiment 1 of the present invention; [0015] FIG. 2 is a block diagram showing conceptually the hierarchical structure of the allocation of database data in the computer system 1000 in the Embodiment 1; [0016] FIG. 3 is a flow chart showing the flow of the data allocation process executed in the Embodiment 1; [0017] FIG. 4 is an explanatory drawing showing an example of a table as database component information; [0018] FIG. 5 is an explanatory drawing showing an example of a table/disk group correspondence 120; [0019] FIG. 6 is explanatory drawing showing an example of a key value access frequency 130; [0020] FIG. 7 is an explanatory drawing showing an example of the setting of data groups; Continue reading about Data allocation setting in computer system... Full patent description for Data allocation setting in computer system Brief Patent Description - Full Patent Description - Patent Application Claims Click on the above for other options relating to this Data allocation setting in computer system patent application. ###  How KEYWORD MONITOR works... a FREE service from FreshPatents1. Sign up (takes 30 seconds). 2. Fill in the keywords to be monitored. 3. Each week you receive an email with patent applications related to your keywords. Start now! - Receive info on patent apps like Data allocation setting in computer system or other areas of interest. ### Previous Patent Application: Crosslink data structure, crosslink database, and system and method of organizing and retrieving information Next Patent Application: Method and apparatus for temporal database Industry Class: Data processing: database and file management or data structures ### FreshPatents.com Support Thank you for viewing the Data allocation setting in computer system patent info. IP-related news and info Results in 0.4129 seconds Other interesting Feshpatents.com categories: Qualcomm , Schering-Plough , Schlumberger , Seagate , Siemens , Texas Instruments , 174 |
 * Protect your Inventions * US Patent Office filing 
PATENT INFO |
|
