Data Model > UNICOM Intelligence Data Model samples > Sample data > The Trips sample
 
The Trips sample
The Trips sample provides an example of database questions with hierarchical data. Unlike the Museum and Short Drinks samples, which are based on real surveys, the Trips sample has been created to demonstrate database questions with hierarchical data. The Trips sample is a small data set that includes a very small number of cases at each level. This is to make it easy to understand what happens when you aggregate the data at the different levels.
The Trips sample comes in the following formats:
UNICOM Intelligence Data File. This consists of the UNICOM Intelligence metadata model (MDM) file called trips.mdd and case data in the form of a UNICOM Intelligence Data File called trips.ddf. By default, this data set is installed into the [INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Data\Data Collection File\ folder.
The Trips sample represents the data collected using the following fictitious survey:
Basic questions. Respondents are first asked a number of personal questions, such as their name, date of birth, country lived in (database question), city lived in (database question), language spoken (database question), and occupation (database question).
Trip questions. Respondents are then asked a number of questions regarding recent trips, such as number of trips taken this year, departure dates, number of days away from home, purpose of each trip, countries visited, number of days in each country, cities visited, and a rating for each city.
A loops called Countries is used to ask the days in country, cities visited (database question), and city rating questions (database question), respectively. The loop is iterated (and therefore the questions are asked) as many times as necessary.
Basic questions
Name
Description
Type
Name
Respondent's name
Text
DOB
Respondent's date of birth
Date/Time
CountryLiveIn
Respondent's resident country
Single response database question
Language Spoken
Respondent's spoken language
Multiple response database question
Occupation
Respondent's occupation
Single response database question
CityLiveIn
Respondent's resident city
Single response database question
Trip questions
Name
Description
Type
TripCount
Number of trips taken this year
Numeric
DaysInCountry
Number of days spent in each country
Numeric
CitiesVisited
Cities visited in each country
Multiple response database question
CitiesGrid
Cities in each country
Grid database question
Rating
Rating for each city
Single response
See also
Sample data