A method implemented on a computing device having at least one processor, storage, and a communication platform connected to a network for recommending personalized content to a user, the method comprising: acquiring one or more historical orders associated with a user within a predetermined time interval; retrieving a first set of points of interests associated with the user based on the one or more historical orders, each POI of the first set of POIs comprising a POI name and a geographic location; storing the first set of POIs associated with the user in a first database, which is not updated in real-time; retrieving a second set of POIs from a second database which is updated in real-time, each POI of the second set comprising a POI name and a geographic location, and wherein each of the second set of POIs bears the same POI name as one of the first set of POIs; updating the first set of POIs in the first database comprising: updating the geographic location of each POI of the first set of POIs in the first database to unify the geographic locations with the geographic location of the respective POI bearing the same name in the second set of POIs; and concurrently, based on comparisons of both a geographic distance and an edit distance between any two POIs of the first set of POIs with respective thresholds, performing redundancy reduction of the first set of POIs by merging any two POIs in the first database when it is determined that both distances between the two POIs are less than the respective thresholds; receiving location information of the user from a user equipment; determining one or more personalized content items based on the updated first set of POIs and the location information of the user; and transmitting the one or more personalized content items to the user equipment. acquiring one or more historical orders associated with a user within a predetermined time interval; retrieving a first set of points of interests associated with the user based on the one or more historical orders, each POI of the first set of POIs comprising a POI name and a geographic location; storing the first set of POIs associated with the user in a first database, which is not updated in real-time; retrieving a second set of POIs from a second database which is updated in real-time, each POI of the second set comprising a POI name and a geographic location, and wherein each of the second set of POIs bears the same POI name as one of the first set of POIs; updating the first set of POIs in the first database comprising: updating the geographic location of each POI of the first set of POIs in the first database to unify the geographic locations with the geographic location of the respective POI bearing the same name in the second set of POIs; and concurrently, based on comparisons of both a geographic distance and an edit distance between any two POIs of the first set of POIs with respective thresholds, performing redundancy reduction of the first set of POIs by merging any two POIs in the first database when it is determined that both distances between the two POIs are less than the respective thresholds; receiving location information of the user from a user equipment; determining one or more personalized content items based on the updated first set of POIs and the location information of the user; and transmitting the one or more personalized content items to the user equipment. updating the geographic location of each POI of the first set of POIs in the first database to unify the geographic locations with the geographic location of the respective POI bearing the same name in the second set of POIs; and concurrently, based on comparisons of both a geographic distance and an edit distance between any two POIs of the first set of POIs with respective thresholds, performing redundancy reduction of the first set of POIs by merging any two POIs in the first database when it is determined that both distances between the two POIs are less than the respective thresholds; receiving location information of the user from a user equipment; determining one or more personalized content items based on the updated first set of POIs and the location information of the user; and transmitting the one or more personalized content items to the user equipment.