Invention Grant
US08280876B2 System, method, and program product for database restructuring support
有权
用于数据库重组支持的系统,方法和程序产品
- Patent Title: System, method, and program product for database restructuring support
- Patent Title (中): 用于数据库重组支持的系统,方法和程序产品
-
Application No.: US12599606Application Date: 2008-04-30
-
Publication No.: US08280876B2Publication Date: 2012-10-02
- Inventor: Qiang Ma , Yoshihide Ishiguro
- Applicant: Qiang Ma , Yoshihide Ishiguro
- Applicant Address: JP Tokyo
- Assignee: NEC Corporation
- Current Assignee: NEC Corporation
- Current Assignee Address: JP Tokyo
- Agency: Foley & Lardner LLP
- Priority: JP2007-127261 20070511
- International Application: PCT/JP2008/058273 WO 20080430
- International Announcement: WO2008/139936 WO 20081120
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
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.
Public/Granted literature
- US20100217759A1 SYSTEM, METHOD, AND PROGAM PRODUCT FOR DATABASE RESTRUCTURING SUPPORT Public/Granted day:2010-08-26
Information query