Saturday, August 05, 2006

Magic Tables, Constraints and Columns

It's been frantic - as the low-level engine edges ever closer to completion my attention has been squarely focused on that mainstay of RDBMS systems known affectionately as tables!

As it happens the table implementation has not proved too difficult to implement thus far and currently support is in-place for the following;


  • Overflow table definition pages

  • Column constraints

  • Data page-splitting



The row block writer and row block reader objects have an initial implementation and the internal row organisation is finished!

The work required to finish the row block persistence can only continue when the Table Index Page/Table Index Manager logic has been completed. This will take a bit longer now that an implementation of clustered indices is required plus the Index Delete/Index Page Combine operations have yet to be written - yet more work!

No comments: