Database Reference
In-Depth Information
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201204, 'ISC2301', 4, 1, 2, 2)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201205, 'ISC3311', 4, 2, 3, 2)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201206, 'ISC4301', 3, 3, 3, 1)
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(201207, 'ISC3321', 3, 1, 4, 1)
TASK 4: SPLITTING FEDER ATED TABLE
With the command SPLIT, you can split the rows in a federated table and place the parti-
tions into two federation members. Assume that you want to divide the ClassIDs into two
partitions. he irst one contains the ClassIDs starting with 2011 and the second one con-
tains the ClassIDs starting with 2012. herefore, the split point can be chosen as 201199.
Follow the below steps to split the rows in the CLASS table:
1. Assume that the Query editor is still open, in the
ClassDB
pane on the left-hand
side of your screen, click the link
[ClassDB].[Class_Federation]
, and select
Split
on the context menu. Enter the split point 201199 as shown in Figure 8.33. hen,
click the
Split
button.
2. Click the
Refresh
button on the ribbon. You should be able to see a new federation
member labeled as 201199 shown in Figure 8.34.
Figure 8.33
Split federated table.