Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


Share this Page URL
Help

5.2 Computing the Spread to Use > 5.2.5 Partial Reorganization - Pg. 132

120 CHAPTER 5: FREQUENT INSERTION TREES or a table of the form: CREATE TABLE EmpDivisors (emp_id CHAR(10) NOT NULL PRIMARY KEY, divisor INTEGER NOT NULL); The first version uses the depth to determine the divisor, so there is an assumption that all nodes at the same level behave approximately the same in regard to subordinates. The second version uses the employee to determine the divisor, so there is an assumption that some nodes are expected to have more or fewer subordinates than other nodes. 5.2.5 Partial Reorganization The traditional approach to return the table to the original nested sets model uses a simple UNION-ed VIEW that puts the lft and rgt values in a single column. CREATE VIEW LftRgt (seq)