System, method, and program product for database restructuring support
AssigneeNEC Corporation
InventorsQiang Ma, Yoshihide Ishiguro
Life of this patent
Estimating the term…
Loading patent…
AssigneeNEC Corporation
InventorsQiang Ma, Yoshihide Ishiguro
Estimating the term…
A database restructuring support system that enables a user to flexibly design the structure of a database after a restructure. A storage cost estimate unit 112 calculates storage cost before and after restructure by using catalog information included in a database 122. In the case of calculating the storage cost of the restructure, tuples of a new schema is calculated and the storage cost is calculated by using the tuples. The access cost estimate unit 113 uses the catalog information and the log DB 121 included in the database 122 to calculate each access cost before and after restructure. In the case of calculating the access cost after restructure, the number of types of values of an attribute in the new schema is calculated to calculate the access cost by using the number of types. The integrated cost estimate unit 111 calculates the integrated cost by integrating the access cost and the storage cost.
A database restructuring support system that calculates an evaluation value in the case of changing a structure of a database by using a storage cost and an access cost, the storage cost indicating a capacity of a storage device necessary to store data and the access cost indicating a capacity of the storage device accessed by a relation operation, the database restructuring support system comprising:
A method of supporting a restructure of a database applied to a database restructuring support system that calculates an evaluation value in the case of changing a structure of a database by using a storage cost and an access cost, the storage cost indicating a capacity of a storage device necessary to store data and the access cost indicating a capacity of the storage device accessed by a relation operation, the database restructuring support system comprising a database storage unit that stores a database, the database being a set of schemata which are tables or views;
A non-transitory computer readable storage medium storing a database restructuring support program mounted to a computer that calculates an evaluation value in the case of changing a structure of a database by using a storage cost and an access cost, the storage cost indicating a capacity of a storage device necessary to store data and the access cost indicating a capacity of the storage device accessed by a relation operation, the computer comprising a database storage unit that stores a database, the database being a set of schemata which are tables or views;
Dependencies are inferred from the claim text.