发明申请
- 专利标题: Proactive space allocation in a database system
- 专利标题(中): 在数据库系统中主动分配空间
-
申请号: US11880917申请日: 2007-07-24
-
公开(公告)号: US20090030956A1公开(公告)日: 2009-01-29
- 发明人: Wei Zhang , Amit Ganesh , Sujatha Muthulingam , Niloy Mukherjee
- 申请人: Wei Zhang , Amit Ganesh , Sujatha Muthulingam , Niloy Mukherjee
- 申请人地址: US CA REDWOOD SHORES
- 专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人地址: US CA REDWOOD SHORES
- 主分类号: G06F12/00
- IPC分类号: G06F12/00
摘要:
A method and apparatus for proactively allocating space to a logical layer of a database is provided. Allocation of space to a logical layer of a database is an expensive operation that should be minimized. The allocation of space includes discovering free space in all the higher layers in the logical storage hierarchy. It also includes cross-domain system calls and cleansing disk-write operations. In prior approaches, the allocation processes were triggered on-demand, only a certain logical layer was discovered to be at full capacity when an insert-row operation was attempted. In one embodiment of the invention, space needs are statistically predicted based on prior rates of space consumption. The database server pre-allocates space as needed, based on the statistical predictions. Rates of consumption are examined periodically. Space is pre-allocated before any logical layer reaches full capacity by a combination of proactive background processes; foreground-triggered, background processes; and classic foreground allocation.
公开/授权文献
- US07716177B2 Proactive space allocation in a database system 公开/授权日:2010-05-11
信息查询