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.: US12599606
    Application Date: 2008-04-30
  • Publication No.: US08280876B2
    Publication Date: 2012-10-02
  • Inventor: Qiang MaYoshihide Ishiguro
  • Applicant: Qiang MaYoshihide 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
System, method, and program product for database restructuring support
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.
Information query
Patent Agency Ranking
0/0