- Taking a Preference SQL approach, a context-aware vacation planner for on-site activities is proposed to automatically generate vacation plans based on user preferences and situational aspects. Using different levels of abstraction, the result of the corresponding preference queries is always optimal and the result size is minimal. It consists of stereotype-specific and contextaware activities which are combined to create daily or even multi-day plans of activities. The correctness, completeness and optimality are assured by a preference calculus of strict partial orders. User preferences are initially collected and defined by a feedback questionnaire. The application is modelled by adequate preference compositions and the Preference SQL runtime system efficiently evaluates the resulting preference queries. The prototype proves that soft runtime requirements are met. Initial tests with real data from the industry-leading outdooractive platform indicate that the database-drivenTaking a Preference SQL approach, a context-aware vacation planner for on-site activities is proposed to automatically generate vacation plans based on user preferences and situational aspects. Using different levels of abstraction, the result of the corresponding preference queries is always optimal and the result size is minimal. It consists of stereotype-specific and contextaware activities which are combined to create daily or even multi-day plans of activities. The correctness, completeness and optimality are assured by a preference calculus of strict partial orders. User preferences are initially collected and defined by a feedback questionnaire. The application is modelled by adequate preference compositions and the Preference SQL runtime system efficiently evaluates the resulting preference queries. The prototype proves that soft runtime requirements are met. Initial tests with real data from the industry-leading outdooractive platform indicate that the database-driven preference technology can successfully be employed to provide added value for vacation planning.…