"Perfect Trip" is a media group that works with a variety of tourism brands. The site has about 60 million members and over 170 million reviews on hotels, restaurants and various attractions.
"Perfect Trip"s repository includes information of places of interest in different cities of the world. Every year, the Vice President (VP) of Content enriches the repository by importing detailed information from the World Tourism Organization's MZ system via an XML file. For each place, the file contains a unique serial number, the name of the place, a description, the price level (high/medium/low), the corresponding landmark on Google Maps expressed as a URL, and the city in which the place is located. City codes are unique and composed of the country number and a distinctive combination of three letters representing the city's name. For example, the city code for Tel Aviv is 972TLV, where 972 denotes the State of Israel's code. Occasional users and registered members can search for places by country name and even narrow the search by city name.
Restaurants and hotels are special kinds of places. For each restaurant, the relevant kitchen styles should be kept. The styles are selected from a list that is maintained by the VP of Culture. For each hotel, besides the previously mentioned details, we aim to include its star rating (ranging from 0 to 5), supported accommodation styles (AI - all-inclusive, BB - bed & breakfast, HB - half board, FB - full board and RO - room only). Note that a hotel may offer some or all accommodation styles. The information on all places, including hotels and restaurants, is imported from the MZ system, alongside the location data, and may include updates and additions. When imported, the distances between the different places are retrieved from Google Maps and stored in the system.
Both occasional users and members can visit the "Perfect Trip" home page, browse for recommendations and details about the various places available in the repository. However, to plan trips, it is mandatory to register as a member of "Perfect Trip". The registration page requires the users first name, last name, and email address. Only if the email does not exist in the database, the user is registered as a member and gets a registration confirmation email with his/her unique member number. 
For planning a trip, the member who creates the trip should provide start and end dates. The "Perfect Trip" system automatically generates a unique 6-digit trip number. If the trip creator is not traveling alone, he/she should add the additional travelers, who are also members of "Perfect Trip". It is also possible to invite friends to register as members of Perfect Trip. In this case the friends are getting a message from the system, but their information is not stored until they register as members.
After the initial creation of a trip, the trip creator can add places and when he/she plans to visit them. The selected visiting dates should fall within the designated trip period, and it is assumed that the same place will not be revisited during different timeframes within the same trip. The system does not handle the actual reservation of places; this process is outside its scope and is conducted directly with the relevant parties. 
When adding places to a trip, the trip creator can search for places with certain characteristics, e.g., price level, kitchen styles (for restaurants), and accommodation styles (for hotels), and include them in the trip. Additionally, the trip creator can request the system to generate recommendations for supplementary places to enrich the overall experience. These suggestions compile all locations within a specified distance from those already integrated into the trip, arranging them in descending order based on the weighted score of reviews.
All members can write opinions on places which they visit. The opinion includes a (numerical) score, a comment, the time in which it was given and the member details. The opinion can be updated and, in this case, only its latest version is stored. At the end of each year, the opinions written in that year are exported in a JSON format and sent to the MZ system. For privacy reasons, only the initials of the members are sent with the opinion details.
