Database Reference
In-Depth Information
understand that the examples of data preparation in this topic are only a subset of possible data
preparation approaches.
COLLATION
Suppose that the database underlying Jerry's Internet survey is designed as depicted in the
screenshot from OpenOffice Base in Figure 3-1.
Figure 3-1: A simple relational (one-to-one) database for Internet survey data.
This design would enable Jerry to collect data about people in one table, and data about their
Internet behaviors in another. RapidMiner would be able to connect to either of these tables in
order to mine the responses, but what if Jerry were interested in mining data from both tables at
once?
One simple way to collate data in multiple tables into a single location for data mining is to create a
database view. A view is a type of pseudo-table, created by writing a SQL statement which is
named and stored in the database. Figure 3-2 shows the creation of a view in OpenOffice Base,
while Figure 3-3 shows the view in datasheet view.
 
Search WWH ::




Custom Search