Appeal 2007-1062
Application 10/034,438
The Examiner acknowledges that “Iyer et al. do not explicitly disclose
wherein the second values differ from the first values by at least one free
space management parameter value, thereby producing non-uniform
distribution of free space in the database file” (Answer 5).
Pereira describes a method and apparatus for determining the
condition of a database table as a condition for reorganization of that table
(Abstract; col. 2, ll. 14-30). Several of the elements that determine the
condition of the database table are average free space in a block unused and
average free released free space (col. 2, ll. 30-34). According to Pereira, a
database administrator (DBA) “makes a decision regarding the management
of a row allocation within blocks of a table by setting a percentage of blocks
free (PCTFREE) or percentage of blocks used (PCTUSED)” (col. 4, ll. 3- 6).
The PCTFREE variable is set depending on how the database table is to be
used, “so that enough space is available to allow any necessary row
migration to occur within the same block” (col. 4, ll. 12-16). The
PCTUSED parameter “determines whether a new row may be inserted in a
block,” and it “comes into effect when used space becomes free due to
deletes” from the block (col. 4, ll. 37-39).
Eberhard describes a method of estimating the costs of an application
program accessing a database (Abstract). A graphical user interface is
displayed in which a user can select at 211 the percent free space to be left
on each page, and can specify at 212 the number of pages before a
completely empty page is left (Figure 2B; col. 7, ll. 43 and 44 and col. 7, l.
65 to col. 8, l. 3). Using the Figure 2B user interface, the user can generate
an expanded partial definition of a table (Figure 2C; col. 8, ll. 22-25). In the
4
Page: Previous 1 2 3 4 5 6 Next
Last modified: September 9, 2013