Invention Grant
US08676769B2 Method for defragmenting indexes in a relational database and system for performing the method 有权
关系数据库中的索引进行碎片整理的方法和执行该方法的系统

  • Patent Title: Method for defragmenting indexes in a relational database and system for performing the method
  • Patent Title (中): 关系数据库中的索引进行碎片整理的方法和执行该方法的系统
  • Application No.: US12430156
    Application Date: 2009-04-27
  • Publication No.: US08676769B2
    Publication Date: 2014-03-18
  • Inventor: Marco Costaglio
  • Applicant: Marco Costaglio
  • Applicant Address: DE Munich
  • Assignee: Siemens Aktiengesellschaft
  • Current Assignee: Siemens Aktiengesellschaft
  • Current Assignee Address: DE Munich
  • Agent Laurence A. Greenberg; Werner H. Stemer; Ralph E. Locher
  • Priority: EP08007989 20080425
  • Main IPC: G06F17/30
  • IPC: G06F17/30
Method for defragmenting indexes in a relational database and system for performing the method
Abstract:
A method and a system defragment indexes in a relational database. The relational database contains a set of tables, in which each table contains a set of indexes, in which, for each index, a fragmentation parameter is associated indicating the fragmentation level of the index. The method includes the following steps: getting a list of the set of tables; for each table of the list, getting the fragmentation parameter associated to each index of the table; and depending on the value of the fragmentation parameter, defragmenting the associated index.
Information query
Patent Agency Ranking
0/0