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.: US12430156Application Date: 2009-04-27
-
Publication No.: US08676769B2Publication 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

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.
Public/Granted literature
- US20090271427A1 METHOD FOR DEFRAGMENTING INDEXES IN A RELATIONAL DATABASE AND SYSTEM FOR PERFORMING THE METHOD Public/Granted day:2009-10-29
Information query