Database management program, a database managing method and an apparatus therefor

Abstract

Database optimizing method and system are provided to optimally locate data. Only data satisfying conditions desired by a user is extracted among an access log. Values of a part of the data are translated on the basis of a translation table, and aggregated on the basis of aggregation condition rules. The obtained aggregation result is presented to the user. In addition, data in the database are optimally relocated on the basis of the obtained aggregation result.

1 - 16 . (Canceled).  
   
   
       17 . A computer-executable database management program implementing a method for managing a database, said method comprising the steps of: 
 extracting log information satisfying predetermined conditions from among log information of an application program having accessed a database; and    creating an index for an object in accordance with predetermined rules on the basis of commands included in said extracted log information.    
   
   
       18 . The computer-executable database management program according to  claim 17 , wherein said method further comprises the step of obtaining an existence time of data to be accessed by said commands included in said extracted log information, and change stored positions of data to be accessed by said application program in accordance with said existence time and commands to be executed in said existence time.  
   
   
       19 . A computer-executable database management program implementing a method for managing a database, said method comprising the steps of: 
 extracting log information satisfying predetermined conditions from among log information of an application program having accessed a database; and    relocating an object column or line in accordance with predetermined rules on the basis of commands included in said extracted log information.    
   
   
       20 . The computer-executable database management program according to  claim 19 , wherein said method further comprises the step of obtaining an existence time of data to be accessed by said commands included in said extracted log information, and change stored positions of data to be accessed by said application program in accordance with said existence time and commands to be executed in said existence time.  
   
   
       21 . A method for managing a database comprising the steps of: 
 extracting log information satisfying predetermined conditions from among log information of an application program having accessed a database; and    creating an index for an object in accordance with predetermined rules on the basis of commands included in said extracted log information.    
   
   
       22 . The method according to  claim 21 , further comprising the step of obtaining an existence time of data to be accessed by said commands included in said extracted log information, and change stored positions of data to be accessed by said application program in accordance with said existence time and commands to be executed in said existence time.  
   
   
       23 . A method for managing a database comprising the steps of: 
 extracting log information satisfying predetermined conditions from among log information of an application program having accessed a database; and    relocating an object column or line in accordance with predetermined rules on the basis of commands included in said extracted log information.    
   
   
       24 . The method according to  claim 23 , further comprising the step of obtaining an existence time of data to be accessed by said commands included in said extracted log information, and change stored positions of data to be accessed by said application program in accordance with said existence time and commands to be executed in said existence time.  
   
   
       25 . A system comprising: 
 a client terminal which executes applications;    a database managing terminal which accesses a database in accordance with a command sent from said client terminal;    a database managing portion which extracts log information satisfying predetermined conditions from among log information of an application program executed by said client terminal and having accessed a database and creates an index for an object in accordance with predetermined rules on the basis of commands included in said extracted log information.    
   
   
       26 . A system: 
 a client terminal which executes applications;    a database managing terminal which accesses a database in accordance with a command sent from said client terminal;    a database managing portion which extracts log information satisfying predetermined conditions from among log information of an application program executed by said client terminal having accessed a database; and    relocating an object column or line in accordance with predetermined rules on the basis of commands included in said extracted log information.