Implementation Project, Phase 3: Sort-Merge Join
Due: August 19, 1998
In this assignment, you will implement the sort-merge join algorithm.
You should begin by reading the chapter on Implementation of Relational Operations, in particular, the section on Sort-Merge Join.
class sortMerge { public: sortMerge( char *filename1, // Name of heapfile for relation R. int len_in1, // # of columns in R. AttrType in1[], // Array containing field types of R. short t1_str_sizes[], // Array containing size of columns in R. int join_col_in1, // The join column number of R. char *filename2, // Name of heapfile for relation S int len_in2, // # of columns in S. AttrType in2[], // Array containing field types of S. short t2_str_sizes[], // Array containing size of columns in S. int join_col_in2, // The join column number of S. char* filename3, // Name of heapfile for merged results int amt_of_mem, // Number of pages available for sorting TupleOrder order, // Sorting order: Ascending or Descending Status& s // Status of constructor ); ~sortMerge(); };
The sortMerge constructor joins two relations R and S, represented by the heapfiles filename1 and filename2, respectively, using the sort-merge join algorithm. Note that the columns for relation R (S) are numbered from 0 to len_in1 - 1 (len_in2 - 1). You are to concatenate each matching pair of records and write it into the heapfile filename3. The error layer for the sortMerge class is JOINS.
You will need to use the following classes which are given: Sort, HeapFile, and Scan. You will call the Sort constructor to sort a heapfile. To compare the join columns of two tuples, you will call the function tupleCmp (declared in sort.h). Once a scan is opened on a heapfile, the scan cursor can be positioned to any record within the heapfile calling the Scan method position with an RID argument. The next call to the Scan method getNext will proceed from the new cursor position.
Information on setting up the code and the error protocol to follow.
You should turn in hardcopies of your code together with hardcopies of the output produced by running the tests provided by me. A solution will be made public after the due date, and solutions turned in after that time will not receive any credit. So be sure to turn in whatever you have, even if it is not working fully, at that time.