JP2006268793A - Travel commodity retrieval server and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a travel commodity retrieval system, capable of performing detailed condition setting such as "to visit a specified sightseeing spot at a specified date", easily retrieving and selecting an optimum travel commodity according to the need of an individual traveller, and improving the reduction in cost, reduction in business load and customer satisfaction of a travel company. <P>SOLUTION: The travel commodity retrieval server connected to a retrieval terminal through a communication line comprises a travel commodity database storing travel commodity information; a determination means determining information received from the retrieval terminal; a retrieval means retrieving, when the determination means detects receipt of a retrieval condition and a retrieval start instruction from the retrieval terminal, the travel commodity database based on the retrieval condition, and extracting travel commodity information matched to the retrieval condition; and a first display information generation means generating display information for displaying list information of the travel commodity information matched to the retrieval condition on the retrieval terminal. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

The present invention relates to a travel product search server and a program for searching for a travel product based on a search condition requested from a terminal device capable of data communication via a network.

Conventionally, in the travel product search system, travel products are searched by travel direction, departure date, departure place, travel price, presence / absence of a tour operator, hotel, etc., and details of the travel products that were hit (schedule etc.) are confirmed on a separate screen. He selected travel products by referring to paper brochures. Patent Document 1 discloses a travel information processing system that can specify any of a departure date, a budget, a travel area, and a travel type on a screen and search for a corresponding travel product.

JP 2003-196307 A

  According to the prior art, it has been difficult to find a tour that can visit a specific sightseeing spot (sightseeing spot) on a specific day. The reason is that the travel summary data does not include the detailed contents of the travel, while the travel pamphlet data includes a lot of text data. Even if a full-text search is performed using the key, it is not possible to immediately determine whether a specific tourist spot can be visited on a specific day. This is because it is necessary to calculate and confirm the day.

  As a result, for example, this is my second trip to Italy, and I want to see some of the most famous sightseeing spots that I could not see last time. However, in order to meet the need to tour the neighborhood of the site on days other than the date of use (the need to search for travel products that are free-run in a specific city on a specific day) I had to rely on.

  To meet such needs, there was only one choice: whether to deal with a large amount of cost and let veteran staff check several travel brochures or not. Otherwise, on overseas visits where there is business on a specific day, the traveler will make an aircraft flight and hotel reservation on his own without applying for a tour with the travel agency. It was a loss of product sales opportunities.

  Furthermore, when you apply for a tour, even if you see individual pamphlets, there are multiple departure dates for the same travel product. Each day is different, and there are often situations where it is not possible to visit the inside of a particular tourist spot.

For example, a tourist who places an emphasis on visiting a specific museum visited the museum of interest on a tour, but it happened to be closed, or it was closed early due to winter, etc. The situation that it was only possible to see from happened. In such a case, a strong complaint against the travel agency is generated.

Furthermore, even if you visit a specific sightseeing spot, tourists may choose to take a half-day view, just look inside for about 30 minutes, look from the outside of the building, or just look at the distant view from the car window. Satisfaction varies greatly. For a tourist who wants to see half a day, a tour of only 30 minutes only results in dissatisfaction. Also, tourists who want to visit at night will be dissatisfied if they choose a travel product that visits the same sightseeing spot during the day.

Therefore, in order to avoid such complaints and dissatisfaction, the staff of the travel agency should understand the tourist spots that each traveler values and refer to the latest travel guide etc. Accordingly, it was necessary to check whether the visit was possible on the visit date of the sightseeing spot calculated from the departure date, or even if it was possible. Since such confirmation work takes a lot of time and effort, it was practically impossible to execute it.

The present invention has been made in order to solve the above-mentioned problems, and it is possible to set detailed conditions such as “visiting a specific sightseeing spot on a specific day”, which is optimal for the needs of individual travelers. It is an object of the present invention to provide a travel product search system that can easily search and select travel products and can greatly reduce the cost and work load of a travel agency and greatly improve customer satisfaction.

In order to achieve the above object, the travel product search server of the present application has the following configuration.
That is,
A travel product search server connected to a search terminal via a communication line,
A travel product database that stores travel product information;
Determining means for determining information received from the search terminal;
When the determination means determines that a search condition and a search start command have been received from the search terminal, the travel product database is searched based on the search condition, and travel product information that matches the search condition is extracted. Search means to
First display information generating means for generating display information for causing the search terminal to display list information of travel product information that matches the search condition;
The search condition includes tourist spot condition information for designating a condition relating to a tourist spot.

In order to achieve the above object, the travel product search server control method of the present application has the following configuration.
That is,
A method for controlling a travel product search server connected to a search terminal via a communication line, comprising:
A determination step of determining information received from the search terminal;
When the determination step determines that a search condition and a search start command are received from the search terminal, the travel product database is searched based on the search condition, and travel product information that matches the search condition is extracted. Search process;
Including a first display information generating step of generating display information for displaying list information of travel product information that matches the search conditions on the search terminal;
The search condition includes tourist spot condition information for designating a condition relating to a tourist spot.

In order to achieve the above object, a control program for a travel product search server of the present application has the following configuration.
That is,
A travel product search server control program connected to a search terminal via a communication line,
The travel product search server,
A travel product database that stores travel product information;
Determining means for determining information received from the search terminal;
Sightseeing for specifying a condition relating to a sightseeing spot by searching the travel product database based on the search condition when the determination means determines that a search condition and a search start command are received from the search terminal Search means for extracting travel product information that matches the search conditions including location condition information;
It functions as a first display information generating means for generating display information for causing the search terminal to display list information of travel product information that matches the search conditions.

According to the present invention, it becomes possible to quickly select a travel product tailored to the circumstances, interests, and preferences of each individual travel participant, and the customer satisfaction can be greatly improved at low cost.

  Hereinafter, the present invention will be described in detail according to preferred embodiments with reference to the accompanying drawings.

[First Embodiment]
FIG. 1 is a block diagram showing a functional configuration of a system according to the present embodiment. As shown in the figure, the system according to this embodiment includes a product management server 100 that stores a product DB 105 in the hard disk 28 of FIG. 2, and a business that stores an order DB 115 that stores travel product application data in the hard disk. Management server 110, travel company Web server 130 storing travel product DB 135 on a hard disk, client A 140 installed at a customer's home or customer company, client B 150 installed at a travel company's window, tourist destination It consists of business PC-A160 installed at the office of a sightseeing base (for example, a museum), business PC-B170 installed at an overseas base of a travel agency, and business PC-C180 used by a travel agency product planner. ing.

These computers are connected to each other by a communication line 190, and data communication with each other is possible. The communication line 190 is typically a network such as the Internet or an intranet. However, the communication line 190 is not limited to this and may be any data communication. Further, a CD / DVD drive device is connected to the client A 140 and the client B 150, and a CD / DVD drive device is also connected to the product management server 100.

  The above-described units constituting the system will be described below.

The merchandise management server 100 is installed in a travel company or in a data center outsourced by the travel company. The travel product DB 105 of the product management server 100 stores travel product information including in-process and unapproved travel products. The client B 150 is installed at a travel agency window, transmits search conditions to the travel product DB 105 of the product management server 100, displays a list of relevant travel products returned from the product management server 100, and details of the travel product. Or apply for travel. When the application information is registered from the client B 150, the application information is transferred from the product management server 100 to the business management server 110 and registered in the order DB 115.

  The business PC-B 170 is installed at an office of an overseas base of a travel agency, and transmits information on overseas sightseeing spots to the business PC-C 180 using e-mail or FTP.

The business PC-C 180 is a personal computer used by a travel product planner at a travel agency, and is used for planning and inputting travel products and registering the input travel product data in the travel product DB 105 of the product management server 100. . When the travel product is approved, the approval flag of the travel product in the travel product DB 105 is updated from 0 to 1 according to the approval information transmitted from the client terminal of the approver, and the travel product data is stored in the travel company Web server 130. The travel product DB 135 is transferred and registered. When a certain travel product is approved and the approval flag is updated, the approved travel product can be searched and applied from the client A 140 and the client B 150.

  The travel product DB 135 of the travel company Web server 130 stores approved travel products, is connected to the client A 140 via the Internet, searches for travel products based on the search conditions transmitted from the client A 140, and applies. When the information is received, the application information is transferred to the business management server 110 and the application information is registered in the order receiving DB 115.

  Next, the business PC-A 160 is a personal computer installed in an office or the like of a sightseeing spot in a sightseeing spot, receives an inquiry mail from the business PC-C 180 or business PC-B 170, and returns a reply mail to these personal computers. . The main contents of the inquiry are holidays, business hours, and the highlights of the sightseeing spots (famous works for museums and popular menus for restaurants). Each of the clients and business PCs described above is actually connected to a plurality of units (several tens to thousands), not limited to those illustrated.

  Next, the hardware configuration of the product management server will be described with reference to FIG.

  The CPU 21 performs various operations such as four arithmetic operations and comparison operations and hardware control based on an operation system program and an application program. The RAM 22 stores an operation system program, an application program, and the like read from a storage medium such as a CD-ROM or CD-R mounted in the hard disk 28 or the CD-ROM drive 29, and these are controlled by the CPU 21. Performed originally.

The ROM 23 stores a so-called BIOS that manages input / output to / from a hard disk or the like in cooperation with the operation system. The LAN adapter 24 communicates with the outside through a network in cooperation with an operation system communication program controlled by the CPU. The video adapter 25 generates an image signal to be output to the display device, and the keyboard 26 and the mouse 27 are used for inputting an instruction to the information processing device.

The hard disk 28 stores an operation system, application programs shown in FIGS. 5 to 8, various masters shown in FIGS. 4 and 10 to 14, and a travel product DB 105 shown in FIG.

The CD-ROM drive 29 is used for installing a storage medium such as a CD-ROM, CD-R, or CD-R / W and installing an application program on the hard disk 28. Needless to say, a DVD + -R drive, a DVD + -R / W drive, a DVD-RAM drive, an MO drive, or the like may be used instead of the CD-ROM drive.

The system bus 20 connects the CPU 21 to the CD-ROM drive 29 to each other, and includes data lines, address lines, and various control signal lines. The bus format is typically a so-called PCI bus or AGP bus, but is not limited thereto. In FIG. 2, a so-called chip set is omitted.

The above description of the hardware configuration is the same not only for the merchandise management server 100 but also for the travel agency Web server 130. Also, the client A140, client B150, business PC-A160, business PC-B170, business PC shown in FIG. -C170 is the same except that hard disk 38 stores not only various masters, travel product DBs and server application programs but also e-mail software, so-called browsers and various client softwares. Detailed description is omitted.

Next, the details of the product search and application process of the present application will be described with reference to FIGS.

FIG. 5 is a flowchart showing the product search / application process of the present invention, FIG. 6 is a flowchart showing details of the search process (step S524) of the present invention, and FIG. 7 shows a search condition input screen for travel product search of the present invention. FIG. 8 is a view showing a search result list screen for travel product search according to the present invention.

In FIG. 5, steps S501 to S513 are executed under the control of the CPU 31 of the client B150. Steps S521 to S533 are executed under the control of the CPU 21 of the merchandise management server 100. Steps S541 to S543 are executed under the control of the CPU 31 of the business PC-B 170.

First, before executing the processing of FIG. 5, a connection request is transmitted from the client B 150 to the product management server 100, an authentication request screen is transmitted from the product management server 100 to the client B 150, and the product management server 100 from the client B 150. The user ID and password are sent to the user ID and the authentication is completed, and the session information of the session (including the session ID, user ID and password, IP address of the client B 150, etc.) is stored in the work area of the RAM 22 of the product management server 100. Is remembered. In addition, search conditions, operation information, inquiry information, etc. received from the client B 150 and stored in the work area of the RAM 22 in the following steps are stored together with or associated with this session ID.

  First, in step S521, the product management server 100 transmits display information (HTML or the like) for displaying the travel product search screen shown in FIG. 7 on the client B 150 to the client B 150 via the communication line 190. In step S501, the client B 150 receives the display information and displays the travel product search screen shown in FIG. In FIG. 7, the direction, country, departure place, type of schedule, specific schedule (start and end), travel price, hotel, city, tourism schedule (start and end) of the city, name of the sightseeing spot, and sightseeing spot You can specify or select the sightseeing schedule (start and end), time zone, and tour method. Although FIG. 7 shows that only one city and only two sightseeing spots can be designated or selected, a plurality of cities and sightseeing spots may both be designated.

  In step S502, the client B 150 transmits operation information to the product management server 100. The operation information is, for example, an operation of selecting “Europe” from the list in “Direction” of FIG. 7, “Departure date” in “Schedule”, and 04 and 01, 04 and 05 in the input field of the month and day. This means information to input or information to press the search button 710.

  In step S522, the merchandise management server 100 receives the operation information and stores it in the work area of the RAM 22. In step S522, the operation information stored in the work area of the RAM 22 is referred to, and it is determined whether the operation information means that the search button 710 is pressed.

  If it means that the search button 710 is pressed, the process proceeds to step S524. If the search button 710 is not pressed, the process returns to step S521, and the display information of the search screen corresponding to the operation information is transmitted to the client B150. The display information on the search screen corresponding to the operation information is, for example, when operation information indicating an operation of selecting “Europe” from the list in “Direction” of FIG. 7 is received, “Country” in FIG. It means display information for displaying a list of countries belonging to Europe, such as “UK”, “France”, “Germany”, “Italy”, “Spain”.

In step S524, the travel product DB 105 is searched based on the search conditions stored in the work area of the RAM 22, information on the travel products (brand, year, course number, and degree of match) that matches the search conditions is extracted. Is stored in the work area. Details of step S524 will be described with reference to the flowchart of FIG.

  In step S525, the work area of the RAM 22 is referred to and it is determined whether there is a travel product that matches the search condition as a result of the search. If there is no corresponding travel product, the process proceeds to step S526. If there is a corresponding travel product, the process proceeds to step S527.

In step S526, error information indicating that there is no travel product corresponding to the designated search condition is transmitted to client B150. In step S503, the client B 150 receives the error information, displays the error information on the screen, and advances the process to step S501. In step S501, the search condition screen is displayed again and the search condition input operation waits.

In step S527, the course name / night number of the travel product DB 105 and the departure date of the course master are read based on the travel product information (brand, year, course number, degree of match) stored in the work area of the RAM 22. After being sorted in descending order (for example, if there are two sightseeing spots, sorted in the order of 〇, 〇 △, 〇 ×, △△, △ ×, xx) Display information for displaying the search result list screen of FIG. 8 is generated and transmitted.

In step S504, the search result list screen of FIG. 8 is displayed on the screen of the client B150. The list screen displays the brand, course name, departure date, course number, sightseeing spot (one or more) and the degree of matching thereof, and a “detailed display” button is displayed for each detail line. If the “detail display” button is pressed, the process proceeds to step S505. Instead of the “detail button”, the course name or course number display portion may be used as a link, and when this link is clicked, detailed information on the travel product may be displayed.

In step S505, selection information indicating which item has been selected is transmitted to the product management server 100. In step S528, the merchandise management server 100 receives the selection information and stores it in the work area of the RAM 22.

In step S529, the travel product DB 105 is searched based on the selection information, and the course master (FIG. 11) and the itinerary master (FIG. 13) are referred to using the course number in the travel product DB 105 as a key, and the departure date ( from to), charge code, number of days and itinerary No., city code, sightseeing spot code, sightseeing time, tour method and travel method of each sightseeing spot. Further, the basic fee is read by referring to the fee master based on the fee code of the course master, and further the name of the tourist location is read by referring to the tourist location master using the city code and the tourist location code of the itinerary master as keys. Display information for displaying the detailed information is generated and transmitted to the client B150.

In step S506, detailed information such as the itinerary, accommodation, and meals of the travel product is displayed.
On the detailed information screen (not shown), the course name, fee, and itinerary (name of sightseeing spot and staying time, tour method, travel method between sightseeing spots, name) of the travel product are displayed and the inquiry content is entered. An “inquiry” button for displaying and a “previous screen” button for returning to the previous list display screen are also displayed. The name of the hotel to stay is usually specified by the city code and the tourist code of the last itinerary of the day. That is, a hotel is also recorded in the sightseeing spot master of FIG. 4, and it is distinguished whether it is a hotel by type (for example, a type = 8 means a hotel).

In addition, the sightseeing spot master also stores a night in the car (for example, overnight in a Siberian railway car). In addition, you may memorize | store a hotel and a night in a car as another master file.

In step S507, it is determined whether the “inquiry” button has been pressed. If it is determined that the “inquiry” button has been pressed, the process proceeds to step S508. If it is determined that the “inquiry” button has not been pressed, the process proceeds to step S512. In step S512, it is determined whether the “Previous screen” button has been pressed. If the button has been pressed, the process proceeds to step S504. If not, the process proceeds to step S506.

In step S508, an inquiry request for requesting an inquiry is transmitted to the product management server 100. In step S530, the merchandise management server 100 receives the inquiry request and stores it in the work area of the RAM 22. In step S531, display information for displaying a screen for inputting inquiry contents on client B 150 is transmitted to client B 150.

In step S509, the client B150 displays a screen for inputting inquiry contents, and the process proceeds to step S510. On the screen for entering the inquiry content, an inquiry content input field, a reply destination e-mail address input field, and a “Send” button are displayed. In step S510, it is determined whether characters have been entered in the inquiry content input field and the reply destination e-mail address input field and the "Send" button has been pressed. If no, the process proceeds to step S513. If yes, the process proceeds to step S511.

In step S513, it is determined whether the “Previous screen” button has been pressed. If the button has been pressed, the process proceeds to step S506. If not, the process proceeds to step S509.

In step S <b> 511, the inquiry data input in the inquiry content input field is transmitted to the product management server 100. In step S532, the inquiry data is stored in an inquiry table (not shown), and in step S533, the sightseeing spot master is searched with the keyword in the inquiry data to identify the corresponding city code, or the travel product DB 105 with the course name. To identify the course number, create the body text of the e-mail in a predetermined format based on the inquiry data, and the person-in-charge master (city code and course number not shown) with the city code or course number. The person-in-charge code and inquiry mail address are stored as keys, and an e-mail is transmitted to the person-in-charge mail address. In this embodiment, since there is an inquiry about an overseas sightseeing spot, an e-mail is transmitted to the business PC-B 170 installed at the overseas base of the travel agency.

In step S541, the business PC-B 170 receives the inquiry e-mail at the inquiry dedicated address.

In step S542, when a new mail is received at the inquiry-dedicated address, a predetermined part of the body of the e-mail is registered in the inquiry DB of the hard disk 38.

In step S543, the person in charge at the overseas base transmits an inquiry e-mail to the business PC-A 160 installed in the office of the sightseeing spot. This is the end of the description of FIG.

Next, details of the search processing will be described with reference to FIG. The flowchart in FIG. 6 shows details of step S524 in FIG. 5, and steps S621 to S634 are executed under the control of the CPU 21 of the merchandise management server 100.

In step S621, the arrays A and B stored in the work area of the RAM 22 are initialized. The array A is a work array used in step S524, and the array B is a work array used in the processing from step S524 and step S525. The array A stores product codes (unique codes consisting of the brand, year, and course number of the travel product DB 105), and the array B stores the product codes and the degree of matching between the product codes (up to 5). . The degree of match is determined for each sightseeing spot based on whether each sightseeing spot is visited under the desired conditions with the travel product when up to five sightseeing spots are designated. Note that the number of matches is not limited to a maximum of 5, but may be about 10 or more.

When it is an itinerary for visiting a certain sightseeing spot on a desired sightseeing day with a desired time zone and a tour method, the degree of coincidence of the sightseeing spot is “◯”. If it is an itinerary that allows you to freely visit a tourist spot on the desired sightseeing day, or if it is an itinerary that visits a certain tourist spot on the desired sightseeing day, but it is not the desired tour method, or It is an itinerary to visit a certain sightseeing spot on the desired sightseeing day, but it is not the desired time zone, or it is in the same city on the desired day but it is an itinerary to visit another sightseeing spot, so it is desirable In the case of an itinerary that does not visit any tourist spot, the degree of match of the tourist spot is “△”. If it is an itinerary to visit a designated sightseeing spot on a day other than the desired sightseeing date, the degree of coincidence of the sightseeing spot is “×”. Note that “matching conditions” and “◯ Δx” are not limited to the above. For example, when the tour method does not match, “x” may be used instead of “Δ”. The degree of match is not limited to “◯”, “△”, “×”, but may be displayed as “A”, “B”, “C”, “1”, “2”, “3”, or different icons. Or symbols and characters may be associated. Further, it can be used in combination with a method of displaying each row of the list display with a different background color according to the degree of match. Or you may change the display color of a character according to a matching degree.

In step S622, the travel product DB 105 is specified on the screen of FIG. 7 of the client B 150 and stored in the work area of the RAM 22 of the product management server 100. Of the search conditions, the direction, departure place, departure date, travel price, and surcharge The search is performed under the conditions of the staff member, the airline company, and the hotel, and the corresponding product codes (brand, year, course number) are stored in the array A.

In step S623, it is determined whether one or more sightseeing spots are specified in the search condition stored in the work area of the RAM 22. If one or more sightseeing spots are designated, the process proceeds to step S624. When the sightseeing spot is not designated, the process proceeds to step S625. In step S625, the product codes of all the elements stored in the array A and the degree of coincidence = “◯” are copied to the array B, and the process ends.

In step S624, the product codes of all the elements stored in the array A are read and stored in the work area of the RAM 22, and the process proceeds to step S626.

In step S626, it is determined whether or not the product codes of all the elements stored in the array A have been successfully read. If the reading is successful (when not all the elements of array A have been processed), the process proceeds to step S627. If reading fails (when all elements of array A have been processed), the process ends.

In step S 627, one sightseeing spot designated by the search condition stored in the work area of the RAM 22 is read and stored in another part of the work area of the RAM 22.

In step S628, it is determined whether all designated sightseeing spots have been processed. If all the sightseeing spots have been processed, the process proceeds to S624. If not all the sightseeing spots have been processed, the process proceeds to S629.

In step S629, the travel product DB 105 is searched based on the selection information, and the course master (FIG. 11) and the itinerary master (FIG. 13) are referenced using the course number of the travel product DB 105 as a key, and the departure date ( from to), price code, number of days and itinerary No., city code, sightseeing spot code, sightseeing time, tour method and travel method of each sightseeing spot, and collate with the conditions of the relevant sightseeing spot specified in the search conditions . There are three ways to visit: admission, getting off, and car window.

Further, using the city code and the tourist location code of the itinerary master as a key, the holiday set date and business hours are read with reference to the holiday classification master (FIG. 10), and it is verified whether the business is operating at the tourist time of the relevant tourist location.

In step S630, based on the collation result in step S629, if it is an itinerary to visit a certain sightseeing spot on a desired sightseeing day with a desired time zone and entrance method, the process proceeds to step S631, and The degree of match = “◯”. If it is an itinerary that allows you to visit a certain sightseeing spot freely on the desired sightseeing day, or if it is an itinerary that visits a certain sightseeing spot on the desired sightseeing day, but it is not the desired entry method, or there is It is an itinerary to visit a sightseeing spot on the desired sightseeing day, but it is not in the desired time zone, or it is in the same city on the desired day but it is an itinerary to visit another sightseeing spot, so it is desired In the case of an itinerary that does not visit a tourist spot, the process proceeds to step S632, and the degree of match of the tourist spot is “Δ”. If it is an itinerary to visit a certain sightseeing spot on a day other than the desired sightseeing day, the process proceeds to step S633, and the degree of coincidence of the sightseeing spot is “x”. When the designated sightseeing spot is not visited and the free action date is not set or the place of the free action date is different, the process returns to step S627 (in this case, since it is not stored in the array B, the travel product is not hit, (Does not appear in the list).

In step S634, the product code and the matching degree are copied to the array B when processing the first sightseeing spot, and the matching degree is copied to the elements of the same array B when processing the second and subsequent sightseeing spots, and the process proceeds to step S627. .

This is the end of the description of FIG. According to the processing of FIG. 5 and FIG. 6, it is possible to set detailed conditions such as “visit a specific tourist spot at a specific time zone on a specific day with a desired tour method”, and according to the needs of individual travelers It is possible to easily search for and select the optimal travel product, and to greatly reduce the cost and workload of the travel agency and greatly improve customer satisfaction.

  Next, the data items of the sightseeing spot master in FIG. 4 will be described. The city code is a code that uniquely identifies a city in the world. Note that a city master (not shown) is stored in the hard disk 28 and records a city code and a city name, a staff employee code, and an inquiry e-mail address. The sightseeing spot code is a code for designating a sightseeing spot in a specific city, and can be uniquely specified by combining with the city code.

The type specifies the type of sightseeing spot. For example, 1: park, 2: museum or museum, 3: castle, 4: mountain / lake, 5: coast / island, 6: theme park, 8: hotel, etc. It has become. Deletion is a flag when the sightseeing spot is deleted. The registration date is the date when the data of this sightseeing spot is registered. In addition, the update date and the deletion date may be stored. The name is the Japanese name of the sightseeing spot, and the name of the local language may be further stored as name 2.

  Next, data items in the travel product DB in FIG. 9 will be described. A brand is a name given to a group of travel products with common characteristics. Years such as 2004 and 2005 are entered in the fiscal year, but eras such as H17 may be used. The course number is a code attached to one travel product, and the brand, year, and course number are combined and used as a product code. Approval means the approval flag, and is changed from 0 to 1 when the approval of the person in charge is obtained.

  The registration date is the date when this travel product data was registered. The direction code means a travel direction, for example, “erp” for the European direction and “afr” for the African direction. The departure place is a city name that identifies the departure place of the trip. For example, if the departure place is Nagoya, “Ngy” is set. The number of nights is a number indicating the number of nights on a trip.

  Next, data items of the holiday category master in FIG. 10 will be described. Since the city code, the sightseeing spot code, and the deletion and registration date are the same as those in FIG. If the holiday setting date is 99999999, it means a weekday. Further, when the business hours start and the business hours end are 9999, it means a holiday.

  Next, data items of the course master in FIG. 11 will be described. The brand, year, and course number are the same as in FIG. 9, but the branch number of the course number is also stored. The branch number is a number for distinguishing when the itinerary and fee differ depending on the departure date of the course. The charge code is the charge code in FIG. The event classification is 0 when the course is held and 1 when the course is canceled.

  Next, data items of the charge master in FIG. 12 will be described. The fee code is a code for uniquely identifying the fee, and the adult basic fee means a travel fee for one adult. The difference between the adult room charge and the basic adult charge is stored. The number of people in one room is stored as the number of people. The difference between the child fee difference and the adult basic fee is stored.

  Next, data items of the itinerary master in FIG. 13 will be described. The brand, year, course number, and branch number are the same as in FIG. The number of days means the day of the trip. No. means the number of trips in the trip. Meals, hotel stays and overnight stays are included in the itinerary. In addition, when the movement itself such as the Orient Express is important, a sightseeing spot code of the movement itself is assigned and stored as one itinerary.

  The city code and the sightseeing spot code are the same as those in FIG. The start and end of time means the beginning and end of the tour time for the sightseeing spot. The tour is a tour method, 1 is a car window (viewing from the window of a bus or train) 2 is getting off (getting off the bus etc., relatively looking at the appearance of the sightseeing spot, but not inside) 3 is entering (sightseeing Move means the means to move from the tourist spot to the next tourist spot, for example, 1 is walking, 2 is a bus, 3 is a train, 4 is an aircraft, 5 is a ship To do.

  Next, data items of the sub sightseeing spot master in FIG. 14 will be described. City code Same as FIG. The parent code means a tourist spot code of a parent tourist spot. The subcode is a code for specifying a subtour spot. The type means a type of sub-tourist spot, for example, 1 means a theme park attraction, 2 means a work of art, and 3 menu.

  The name means the name of the sub sightseeing spot, and the start of use and the end of use mean the beginning and end of the date when the sub sightseeing spot can be used. A plurality of use start and use start ends may be designated.

[Second Embodiment]
In the first embodiment described above, the case where the client B 150 installed at the travel agency window and the product management server 100 are connected via the communication line 190 and the travel product DB 105 is searched has been described. Client A140 used by travel application customers (individuals and individuals belonging to corporations) and travel company Web server 130 are connected via communication line 190 and search travel product DB 135 based on the search conditions transmitted from client A140. The same can be applied to the case. The difference between the two is that the merchandise management server is installed in the in-house LAN of the travel agency, whereas the travel company Web server 130 is connected to the external LAN and the client A 140 is connected.

[Third Embodiment]
In addition to the first or second embodiment, a sub-tour sightseeing spot master as shown in FIG. 14 in which a city code is linked by a sightseeing spot code is provided below the sightseeing spot information in FIG. The sub sightseeing spot master is stored in the hard disk 28 of the merchandise management server 100, and the sub sightseeing spot master specified in step 629 in FIG. By checking the number of days of the itinerary information and the departure date, it is determined whether or not it can be used.

For example, in the case of a museum, a sub-tourist spot is a famous painting work. For example, it can be determined whether or not a particular painting work is rented out and cannot be viewed. If the tourist spot is a theme park, the sub-tour spot is an individual attraction, and if the tourist spot is a restaurant, the sub-tour spot is an individual menu (recording the start and end of the provision date of a specific menu) To do).

By having these sub-tourist information, for example, “Departure date is February 1 to February 10, and I want to see YY's work at the XX Museum” or “I want to eat YY food in XX city”. It is possible to search for travel products that meet your needs. In addition, an e-mail address (e-mail address of business PC-A 160) for inquiring about a sightseeing spot is further recorded in the sightseeing spot master, and if the location of the above-mentioned YY work is unknown, the inquiry e-mail is sent in step S533 in FIG. When sending an e-mail, the e-mail is sent directly to the inquiry window (business PC-A 160) of the sightseeing spot.

When a reply mail addressed to the product management server 100 is received from the business PC-A 160, the content of the email body is analyzed to determine whether or not it can be viewed, and to the email address of the prospective traveler who entered the inquiry (step in FIG. 5) The reply e-mail is transmitted to the page 53 (see paragraph 53 explaining S510 to S511). In the reply e-mail, a process for entering the URL for exclusive use of the tour along with whether or not to visit the sub sightseeing spot is performed (this part is not shown in FIG. 5). By comprising in this way, it becomes possible to respond efficiently to the question about the travel content according to the interest of each tourist.

[Other Embodiments]
Also, an object of the present invention is to supply a recording medium (or storage medium) in which a program code of software that realizes the functions of the above-described embodiments is recorded to a system or apparatus, and the computer (or CPU or Needless to say, this can also be achieved when the MPU) reads and executes the program code stored in the recording medium. In this case, the program code itself read from the recording medium realizes the functions of the above-described embodiment, and the recording medium on which the program code is recorded constitutes the present invention.

  Further, by executing the program code read by the computer, not only the functions of the above-described embodiments are realized, but also an operating system (OS) running on the computer based on the instruction of the program code. It goes without saying that a case where the function of the above-described embodiment is realized by performing part or all of the actual processing and the processing is included.

  Furthermore, after the program code read from the recording medium is written into a memory provided in a function expansion card inserted into the computer or a function expansion unit connected to the computer, the function is based on the instruction of the program code. It goes without saying that the CPU or the like provided in the expansion card or the function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

  When the present invention is applied to the recording medium, program code corresponding to the flowchart described above is stored in the recording medium. Each of the aforementioned program codes is usually in a so-called execution format (machine language format), but may be in an intermediate language format or source code format that is interpreted and executed by an interpreter, a so-called JVM (Java Virtual Machine) or the like at the time of execution.

It is a figure which shows the system configuration | structure of the travel goods search system of this invention. It is a figure which shows the hardware constitutions of the merchandise management server of this invention. It is a figure which shows the hardware constitutions of the merchandise management server of this invention. It is a figure which shows the data structure and data example of the sightseeing spot master of this invention. It is a flowchart which shows the goods search and application process of this invention. It is a flowchart which shows the detail of the search process (step S524) of this invention. It is a figure which shows the search condition input screen of the travel goods search of this invention. It is a figure which shows the search result list screen of the travel product search of this invention. It is a figure which shows the data structure and data example of travel goods DB of this invention. It is a figure which shows the data structure and data example of the holiday division | segmentation master of this invention. It is a figure which shows the data structure and data example of the course master of this invention. It is a figure which shows the data structure and data example of the charge master of this invention. It is a figure which shows the data structure and data example of the itinerary master of this invention. It is a figure which shows the data structure and data example of the sub sightseeing spot master of this invention.

Explanation of symbols

100 product management server 105 travel product DB
110 Business management server 115 Order DB
130 Travel Agent Web Server 135 Travel Product DB
140 Client A
150 Client B
160 Business PC-A
170 Business PC-B
180 Business PC-C
190 Communication line

Claims (7)

A travel product search server connected to a search terminal via a communication line,
A travel product database that stores travel product information;
Determining means for determining information received from the search terminal;
When the determination means determines that a search condition and a search start command have been received from the search terminal, the travel product database is searched based on the search condition, and travel product information that matches the search condition is extracted. Search means to
First display information generating means for generating display information for causing the search terminal to display list information of travel product information that matches the search condition;
The travel product search server characterized in that the search condition includes tourist spot condition information for specifying a condition relating to the tourist spot. A second display information generating means for displaying detailed information on the travel product on the search terminal;
The travel product information database includes travel itinerary information or includes reference information to the travel itinerary information;
The display information for displaying the list information generated by the display information generating means on the search terminal includes information for displaying a detailed reference button of the travel product,
When the determination means determines that information indicating that the detail reference button has been pressed is received from the search terminal,
2. The travel product search server according to claim 1, wherein the second display information generating means generates display information for displaying the travel itinerary information. The sightseeing spot condition information includes at least one of a sightseeing date, a sightseeing time zone, and a tour method of the sightseeing spot,
The search means executes a search including the tourist spot condition information, extracts travel product information that matches the search condition, and a degree of match according to the match or mismatch of the tourist spot condition information for each travel product Produces
The travel product search server according to claim 1, wherein the first display information generation unit generates display information including the degree of match. 4. The first display information generation unit generates display information for displaying each detailed information of the list information with different display attributes according to the degree of match. Travel product search server The first display information generating means uses a plurality of different numbers, a plurality of different icons, or a plurality of different marks or symbols according to the degree of coincidence according to the match or mismatch of the tourist spot condition information. Display information is generated for display in any one of the above, using a plurality of different characters, or displaying each line of the list display with a different background color according to the degree of matching The travel product search server according to claim 3 or 4. A method for controlling a travel product search server connected to a search terminal via a communication line, comprising:
A determination step of determining information received from the search terminal;
When the determination step determines that a search condition and a search start command are received from the search terminal, the travel product database is searched based on the search condition, and travel product information that matches the search condition is extracted. Search process;
Including a first display information generating step of generating display information for displaying list information of travel product information that matches the search conditions on the search terminal;
A search method for a travel product search server, wherein the search condition includes tourist spot condition information for designating a condition relating to a tourist spot. A travel product search server control program connected to a search terminal via a communication line,
The travel product search server,
A travel product database that stores travel product information;
Determining means for determining information received from the search terminal;
Sightseeing for specifying a condition relating to a sightseeing spot by searching the travel product database based on the search condition when the determination means determines that a search condition and a search start command are received from the search terminal Search means for extracting travel product information that matches the search conditions including location condition information;
Program for functioning as first display information generating means for generating display information for displaying list information of travel product information matching the search condition on the search terminal