假日度假村

喀拉拉邦是印度的一个邦，被称为“上帝自己的国家”。它以背水、房船、美食和文化而闻名。喀拉拉邦有许多度假村、酒店和民宿。此应用程序提供了一种有趣且互动的方式来找到您选择的度假村。

CREATE (zuri:Resort{name : 'The Zuri Kumarakom', address : 'V-235 A1 to A54, Karottukayal, Kumarakom, Kerala 686563 India', avg_rate: 7650})
CREATE (vivanta:Resort{name : 'Vivanta by Taj - Kumarakom', address : '1/404 Kamarakom Kottayam, Kumarakom, Kerala 686 563 India', avg_rate: 10000})
CREATE (paradise:Resort{name : 'Paradise Resorts', address : 'Kumarakom South P.O, Kottayam, Kumarakom, Kerala 686563 India', avg_rate: 3753})
CREATE (leCelestium:Resort{name : 'Le Celestium', address : 'Colony Road KDTC Hill Resort, Munnar, Kerala 685612 India', avg_rate: 2085})
CREATE (glenmore:Resort{name : 'Glenmore Resorts', address : 'Near Recreation Club Pallivasal, Munnar, Kerala 685665 India', avg_rate: 1918})
CREATE (worldBackWaters:Resort{name : 'The World Backwaters', address : 'Kannankara Post, Alleppey, Thanneermukkom, Kerala 688527 India', avg_rate: 4169})
CREATE (rainbowCruises:Resort{name : 'Rainbow Cruises', address : 'V.C.N.B.Road, Opp.Boat Jetty Alleppey, Cochin, Alappuzha, Kerala 688013 India', avg_rate: 10271})
CREATE (wildCorridor:Resort{name : 'Thekkady Wild Corridor', address : 'Murikkady P.O. Kumily, Thekkady, Kerala 685535 India', avg_rate: 5837})
CREATE (spiceVillage:Resort{name : 'Spice Village', address : 'Kumily - Thekkady Road, Thekkady, Kerala 685536 India', avg_rate: 14176})
CREATE (windHaven:Resort{name : 'WindHaven Resort', address : 'Ramakkal Tourist Center, Idukki, Ramakkalmedu, Kerala 685 552 India', avg_rate: 1376})

CREATE (family:Category{name : 'Family', description:'Family Resort'})
CREATE (beach:Category{name : 'Beach', description:'Beach Resort'})
CREATE (hillStation:Category{name : 'Hill Station', description:'Hill Station Resort'})
CREATE (backWaters:Category{name : 'Back Waters', description:'Kerala Back Waters Resort'})
CREATE (holiday:Category{name : 'Holiday Park', description:'Holiday Park with Play-Area'})
CREATE (romantic:Category{name : 'Romantic', description:'Romantic Destination'})
CREATE (wildlife:Category{name : 'Wild Life', description:'Wild Life and Forest'})

CREATE (january:Season{name : 'January'})
CREATE (febraury:Season{name : 'Febraury'})
CREATE (march:Season{name : 'March'})
CREATE (april:Season{name : 'April'})
CREATE (may:Season{name : 'May'})
CREATE (june:Season{name : 'June'})
CREATE (july:Season{name : 'July'})
CREATE (august:Season{name : 'August'})
CREATE (septemberr:Season{name : 'September'})
CREATE (october:Season{name : 'October'})
CREATE (november:Season{name : 'November'})
CREATE (december:Season{name : 'December'})

CREATE (swimmingPool:Facility{name : 'Swimming Pool'})
CREATE (carParking:Facility{name : 'Car Parking'})
CREATE (freeWifi:Facility{name : 'Free Wi-Fi Access'})
CREATE (freeBreakfast:Facility{name : 'Free Breakfast'})
CREATE (childCare:Facility{name : 'BabySitting or Child Care'})
CREATE (garden:Facility{name : 'Garden'})
CREATE (spa:Facility{name : 'Spa'})
CREATE (cafe:Facility{name : 'Cafe'})
CREATE (medicalAssistance:Facility{name : 'Medical Assistance'})
CREATE (barbecue:Facility{name : 'Barbecue grill(s)'})
CREATE (fitness:Facility{name : 'Fitness facilities'})
CREATE (library:Facility{name : 'Library'})
CREATE (frontDesk:Facility{name : '24-hour front desk'})
CREATE (billiards:Facility{name : 'Billiards or pool table'})

CREATE (rating2_5:Rating{rating : 2.5})
CREATE (rating3_0:Rating{rating : 3.0})
CREATE (rating3_5:Rating{rating : 3.5})
CREATE (rating4_0:Rating{rating : 4.0})
CREATE (rating4_5:Rating{rating : 4.5})
CREATE (rating5_0:Rating{rating : 5.0})

CREATE (raju:Person{name : 'Raju', email: 'rajur79@gmail.com'})
CREATE (diya:Person{name : 'Diya', email: 'diya0908@gmail.com'})
CREATE (geeta:Person{name : 'Geeta', email: 'gp0908@gmail.com'})

CREATE (kumarakom:Place{name : 'Kumarakom', details: 'Kumarakom is home to a wide variety of flora and fauna. Kumarakom Bird Sanctuary is a noted bird sanctuary where many species of migratory birds visit. The Vembanad Lake, the largest backwater in Kerala, is habitat for many marine and freshwater fish species'})
CREATE (alleppey:Place{name : 'Alleppey', details: 'The Backwaters of Alleppey are the most popular tourist attraction in Kerala'})
CREATE (thekkady:Place{name : 'Thekkady', details: 'Situated in Kerala, close to the Kerala - Tamil Nadu border town - Kumily, it is located about 257 km (160 mi) from Trivandrum, 114 km from Madurai City and Madurai Airport, 185 km from Cochin International Airport and 114 km from Kottayam railway station.'})
CREATE (munnar:Place{name : 'Munnar', details: 'Munnar is a hill station on the Western Ghats, a range of mountains situated in the Idukki district of the Indian state of Kerala.'})

CREATE (kerala:State{name : 'Kerala', details: 'Gods own country'})

CREATE (vembanadLake:Attraction{name : 'Vemabanad Lake'})
CREATE (kumarakomBirdSanctuary:Attraction{name : 'Kumarakom Bird Sanctuary'})
CREATE (aruvikkuzhi:Attraction{name : 'Aruvikkuzhi Waterfall'})
CREATE (tigerReserve:Attraction{name : 'Periyar Tiger Reserve'})
CREATE (periyarLake:Attraction{name : 'Periyar Lake'})
CREATE (gaviForest:Attraction{name : 'Gavi Forest'})
CREATE (teaGardens:Attraction{name : 'Tea Gardens'})
CREATE (roseGarden:Attraction{name : 'Rose Garden'})
CREATE (mattupetty:Attraction{name : 'Mattupetty Dam'})
CREATE (keralaBackWaters:Attraction{name : 'Kerala Back Waters'})
CREATE (marariBeach:Attraction{name : 'Marari Beach'})
CREATE (kathakaly:Attraction{name : 'Kathakaly'})

CREATE vembanadLake-[:ATTRACTION_IN]->kumarakom
CREATE kumarakomBirdSanctuary-[:ATTRACTION_IN]->kumarakom
CREATE aruvikkuzhi-[:ATTRACTION_IN]->kumarakom
CREATE tigerReserve-[:ATTRACTION_IN]->thekkady
CREATE periyarLake-[:ATTRACTION_IN]->thekkady
CREATE gaviForest-[:ATTRACTION_IN]->thekkady
CREATE teaGardens-[:ATTRACTION_IN]->munnar
CREATE roseGarden-[:ATTRACTION_IN]->munnar
CREATE mattupetty-[:ATTRACTION_IN]->munnar
CREATE keralaBackWaters-[:ATTRACTION_IN]->alleppey
CREATE marariBeach-[:ATTRACTION_IN]->alleppey
CREATE kathakaly-[:ATTRACTION_IN]->alleppey

CREATE zuri-[:CATEGORY]-> family
CREATE zuri-[:CATEGORY]-> holiday
CREATE zuri-[:CATEGORY]-> backWaters
CREATE vivanta-[:CATEGORY]-> holiday
CREATE vivanta-[:CATEGORY]-> family
CREATE vivanta-[:CATEGORY]-> beach
CREATE paradise-[:CATEGORY]-> holiday
CREATE paradise-[:CATEGORY]-> family
CREATE leCelestium-[:CATEGORY]-> family
CREATE leCelestium-[:CATEGORY]-> hillStation
CREATE leCelestium-[:CATEGORY]-> holiday
CREATE glenmore-[:CATEGORY]-> family
CREATE glenmore-[:CATEGORY]-> hillStation
CREATE glenmore-[:CATEGORY]-> holiday
CREATE worldBackWaters-[:CATEGORY]-> backWaters
CREATE worldBackWaters-[:CATEGORY]-> holiday
CREATE worldBackWaters-[:CATEGORY]-> romantic
CREATE rainbowCruises-[:CATEGORY]-> backWaters
CREATE rainbowCruises-[:CATEGORY]-> romantic
CREATE wildCorridor-[:CATEGORY]-> wildlife
CREATE wildCorridor-[:CATEGORY]-> holiday
CREATE wildCorridor-[:CATEGORY]-> family
CREATE spiceVillage-[:CATEGORY]-> holiday
CREATE windHaven-[:CATEGORY]-> holiday
CREATE windHaven-[:CATEGORY]-> beach

CREATE kumarakom-[:BEST_SEASON]->january
CREATE kumarakom-[:BEST_SEASON]->febraury
CREATE kumarakom-[:BEST_SEASON]->march
CREATE kumarakom-[:BEST_SEASON]->september
CREATE kumarakom-[:BEST_SEASON]->october
CREATE kumarakom-[:BEST_SEASON]->november
CREATE kumarakom-[:BEST_SEASON]->december
CREATE alleppey-[:BEST_SEASON]->january
CREATE alleppey-[:BEST_SEASON]->febraury
CREATE alleppey-[:BEST_SEASON]->march
CREATE alleppey-[:BEST_SEASON]->september
CREATE alleppey-[:BEST_SEASON]->october
CREATE alleppey-[:BEST_SEASON]->november
CREATE alleppey-[:BEST_SEASON]->december
CREATE thekkady-[:BEST_SEASON]->january
CREATE thekkady-[:BEST_SEASON]->febraury
CREATE thekkady-[:BEST_SEASON]->march
CREATE thekkady-[:BEST_SEASON]->september
CREATE thekkady-[:BEST_SEASON]->october
CREATE thekkady-[:BEST_SEASON]->november
CREATE thekkady-[:BEST_SEASON]->december
CREATE munnar-[:BEST_SEASON]->january
CREATE munnar-[:BEST_SEASON]->febraury
CREATE munnar-[:BEST_SEASON]->march
CREATE munnar-[:BEST_SEASON]->april
CREATE munnar-[:BEST_SEASON]->may
CREATE munnar-[:BEST_SEASON]->august
CREATE munnar-[:BEST_SEASON]->september
CREATE munnar-[:BEST_SEASON]->october
CREATE munnar-[:BEST_SEASON]->november
CREATE munnar-[:BEST_SEASON]->december

CREATE kumarakom-[:STATE]->kerala
CREATE alleppey-[:STATE]->kerala
CREATE thekkady-[:STATE]->kerala
CREATE munnar-[:STATE]->kerala

CREATE zuri-[:PLACE]->kumarakom
CREATE vivanta-[:PLACE]->kumarakom
CREATE paradise-[:PLACE]->kumarakom
CREATE leCelestium-[:PLACE]->munnar
CREATE glenmore-[:PLACE]->munnar
CREATE worldBackWaters-[:PLACE]->alleppey
CREATE rainbowCruises-[:PLACE]->alleppey
CREATE wildCorridor-[:PLACE]->thekkady
CREATE spiceVillage-[:PLACE]->thekkady
CREATE windHaven-[:PLACE]->thekkady

CREATE zuri-[:RATING]->rating4_5
CREATE vivanta-[:RATING]->rating5_0
CREATE paradise-[:RATING]->rating3_5
CREATE leCelestium-[:RATING]->rating4_5
CREATE glenmore-[:RATING]->rating4_0
CREATE worldBackWaters-[:RATING]->rating4_5
CREATE rainbowCruises-[:RATING]->rating3_0
CREATE wildCorridor-[:RATING]->rating2_5
CREATE spiceVillage-[:RATING]->rating4_5
CREATE windHaven-[:RATING]->rating4_0

CREATE zuri-[:FACILITY]->swimmingPool
CREATE zuri-[:FACILITY]->carParking
CREATE zuri-[:FACILITY]->freeWifi
CREATE zuri-[:FACILITY]->childCare
CREATE zuri-[:FACILITY]->freeBreakfast
CREATE zuri-[:FACILITY]->garden
CREATE vivanta-[:FACILITY]->swimmingPool
CREATE vivanta-[:FACILITY]->carParking
CREATE vivanta-[:FACILITY]->frontDesk
CREATE vivanta-[:FACILITY]->garden
CREATE vivanta-[:FACILITY]->freeWifi
CREATE paradise-[:FACILITY]->swimmingPool
CREATE paradise-[:FACILITY]->frontDesk
CREATE paradise-[:FACILITY]->garden
CREATE leCelestium-[:FACILITY]->spa
CREATE leCelestium-[:FACILITY]->medicalAssistance
CREATE leCelestium-[:FACILITY]->carParking
CREATE glenmore-[:FACILITY]->medicalAssistance
CREATE glenmore-[:FACILITY]->barbecue
CREATE glenmore-[:FACILITY]->carParking
CREATE glenmore-[:FACILITY]->spa
CREATE worldBackWaters-[:FACILITY]->spa
CREATE worldBackWaters-[:FACILITY]->fitness
CREATE worldBackWaters-[:FACILITY]->garden
CREATE worldBackWaters-[:FACILITY]->freeWifi
CREATE rainbowCruises-[:FACILITY]->library
CREATE wildCorridor-[:FACILITY]->frontDesk
CREATE wildCorridor-[:FACILITY]->garden
CREATE wildCorridor-[:FACILITY]->childCare
CREATE wildCorridor-[:FACILITY]->freeWifi
CREATE spiceVillage-[:FACILITY]->carParking
CREATE spiceVillage-[:FACILITY]->billiards
CREATE spiceVillage-[:FACILITY]->cafe
CREATE spiceVillage-[:FACILITY]->freeBreakfast
CREATE windHaven-[:FACILITY]->spa
CREATE windHaven-[:FACILITY]->freeWifi

CREATE raju-[:VISITED{month: 'October'}]->zuri
CREATE raju-[:VISITED{month: 'September'}]->paradise
CREATE raju-[:VISITED{month: 'January'}]->glenmore
CREATE diya-[:VISITED{month: 'October'}]->zuri
CREATE diya-[:VISITED{month: 'September'}]->paradise
CREATE diya-[:VISITED{month: 'December'}]->spiceVillage
CREATE diya-[:VISITED{month: 'November'}]->windHaven
CREATE geeta-[:VISITED{month: 'October'}]->zuri
CREATE geeta-[:VISITED{month: 'October'}]->rainbowCruises

RETURN kerala;

用例

喀拉拉邦的度假目的地

查找喀拉拉邦的所有度假目的地。此数据集目前仅包含4个目的地。

MATCH p:Place-[:STATE]->kerala
RETURN p.name as Destinations

Zuri酒店附近的景点

查找位于库马拉科姆的Zuri酒店附近的旅游景点。

MATCH r:Resort-[:PLACE]->p:Place<-[:ATTRACTION_IN]-a:Attraction
WHERE r.name = 'The Zuri Kumarakom'
RETURN a.name as Attractions_Near_Zuri

12月可前往的山区度假村

查找所有位于山区，我可以在12月访问的度假村。返回度假村名称和地址，按评分最高排序。

MATCH r1:Resort-[:CATEGORY]->c:Category,
      r1:Resort-[:PLACE]->p:Place,
      p:Place-[:BEST_SEASON]->s:Season,
      r1:Resort-[:RATING]->r2:Rating
WHERE c.name = 'Hill Station' AND s.name='December'
RETURN r1.name as Resort, r2.rating as Rating, r1.address as Address
ORDER BY r2.rating desc

浪漫度假村（3星级及以上），每日预算为9000印度卢比，提供水疗设施

查找符合我每日9000印度卢比预算的所有浪漫度假村。他们需要提供水疗设施，并且至少为3星级评级。

MATCH r1:Resort-[:CATEGORY]->c:Category,
      r1:Resort-[:RATING]->r2:Rating,
      r1:Resort-[:FACILITY]->f:Facility
WHERE c.name = 'Romantic' AND r1.avg_rate <= 9000 AND f.name = 'Spa' AND r2.rating >= 3
RETURN r1.name as Resort, r2.rating as Rating, r1.avg_rate as Rate_Per_Day
ORDER BY r2.rating desc

推荐引擎：向拉朱推荐1月可去的度假村

推荐引擎首先计算拉朱与其他用户的相似度。如果其他用户至少在拉朱在同一时间段内入住过的2家酒店入住过，则该用户与拉朱相似。从相似的用户中，确定他访问了哪些度假村。获取这些度假村的位置，并在这些位置找到最适合在1月访问的度假村。返回度假村名称、位置、评分。按评分最高排序。

MATCH a:Person-[v1:VISITED]->r1:Resort,
      b:Person-[v2:VISITED]->r1:Resort,
      a:Person-[v3:VISITED]->r2:Resort,
      b:Person-[v4:VISITED]->r2:Resort,
      b:Person-[v5:VISITED]->r3:Resort,
      r3:Resort-[:PLACE]->p:Place,
      r4:Resort-[:PLACE]->p:Place,
      r4:Resort-[:RATING]->r5:Rating,
      p:Place-[:BEST_SEASON]->s:Season
WHERE a.name = 'Raju' AND a.name <> b.name
      AND r1.name <> r2.name AND r1.name <> r3.name
      AND v1.month = v2.month AND v3.month = v4.month
      AND s.name = 'January' AND r5.rating >= 4
RETURN DISTINCT r4.name as Resort, p.name as Place, r5.rating as Rating
ORDER BY r5.rating DESC

此页面是否有帮助？

GraphGists