Stave is a column based repository. Data is stored in columns. Stave offers better data compression, and extremely fast data retrieval.
Double click a Stave Universe from the folder tree to open it in the Universe Designer.
The Universe Designer displays as shown in Figure 5.18, “Universe Designer for a Stave Universe”:
Before the Stave columns can be used, you need to map them to a logical table.
Click the Mapping
tab. For each row, enter a name for the Universe table
and a name for the column as shown in Figure 5.19, “Table Mapping for a Stave Universe”.
Observe how Stave automatically names the Date columns once you enter a name for the Universe
table for the column marked Date
. This occurs since Date in Stave is internally represented as multiple rows, one each for
Day, Day of Week, Month, Quarter and Year.
Similarly, Stave automatically names the Time columns once you enter a name for the Universe
table for the column marked Time
. This occurs since Time in Stave is internally represented as multiple rows, one each for
Hour and Minute.
Once you finish Mapping, click the Tables
tab.You will see the mapped Universe table as shown in Figure 5.20, “Mapped Table for a Stave Universe”.
Click the table and proceed with the operations as specified in the section called “Repository Universe”.