This presentation describes the Red Brick loader architecture and illustrates how Red Brick optimizes its loader architecture across these different hardware configurations. Conversion tasks convert data from an external representation to an internal format. In addition, they are responsible for functionality such as RI checking etc. Index tasks build and load indexes. Coordination tasks coordinate the entire load operation.
Tasks operate in parallel, dividing the work among themselves based on the load.
Tasks operate by partitioning the work based on the data. This type of parallelism is used by the index and data tasks. Segments of the table and its indexes are split among the different tasks. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment.