JP2007323552A - Schedule reservation coordination method, system, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a technology for allowing reservation of a schedule by a proxy member even when an inputted schedule overlaps with other schedules. <P>SOLUTION: This schedule reservation coordination method for making a schedule reservation and coordinating schedules includes steps for: reading pieces of information showing the degrees of importance of schedules from a storage device and comparing them mutually for deciding a schedule with the low degree of importance among overlapping schedules if there is a schedule overlapping with an inputted schedule as to a main member inputted in reservation of the schedule; and reading information about the proxy member serving as a proxy of the main member from the storage device as to the decided overlapping schedule with the low degree of importance for deciding the proxy member attending the overlapping schedule. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a schedule reservation adjustment technique for adjusting a schedule reservation.

  Conventionally, when deciding the schedule of a meeting, etc., the time when all the members who are scheduled to participate are vacant based on the information indicating the desired date, desired time, host member and desired location, etc. The time zone when there is no plan to use the belt or conference room is checked and the schedule is reserved. As such a conventional schedule reservation system, as described in Patent Document 1, a system that schedules the date and time when there are few absentees without removing important members, or a schedule that preferentially attends major members. A system to change is known.

JP-A-6-4540 JP 2004-295789 A

  In the case of a normal schedule reservation, it is unlikely that the main member can attend, but there are many cases where a conference can be established if a proxy member who is always present in the conference can participate. There is a problem that the reservation cannot be adjusted.

  An object of the present invention is to solve the above-described problem and provide a technique capable of reserving a schedule by a proxy member even when an input schedule overlaps with another schedule.

  The present invention is a schedule reservation adjustment system that performs schedule reservation and adjustment, and determines a proxy member that acts as a proxy for a main member when a schedule input at the time of reservation overlaps with other schedules.

  In the present invention, as a function for providing optimum reservation information to a reservation system function linked with an existing schedule management system, a function for storing reservation information in a database of a search system and a function for assigning a proxy member from the stored data provide. Furthermore, in order to realize the above object, each function is consistently constructed by a computer.

  In the schedule reservation adjusting system according to the present invention, when information such as a meeting name, a desired date, a desired time, a desired time zone, and a host member is input at the time of schedule reservation, the date and member information is stored in a database. Compare with the information of other stored schedules, and check whether there is a schedule that overlaps with the input schedule for the main member of the input schedule. As a result, if there are overlapping schedules, information indicating the importance of these schedules is read from the database and compared to determine a schedule with low importance.

  Then, for the determined duplication schedule with low importance, information on the surrogate member acting as a surrogate of the main member is read from the database, and the surrogate member attending the duplication schedule is determined. At that time, with regard to past schedules whose names are similar to those of the duplicate schedule, the members of the schedule whose attending members include the main member are read from the database to determine the substitute members, or the schedule members whose attending members include the main member are determined. A process of determining a proxy member from members whose attendance ratio with the main member is a predetermined value or more is performed.

  According to the present invention, it is possible to reserve a schedule by a proxy member even when the input schedule overlaps with another schedule.

  Hereinafter, a schedule reservation adjustment system according to an embodiment that determines a proxy member serving as a proxy for a main member when a schedule input at the time of reservation overlaps with another schedule will be described.

  FIG. 1 is a diagram showing the configuration of the schedule reservation / management system of this embodiment. As shown in FIG. 1, the schedule reservation adjustment system according to the present embodiment includes a schedule reservation system 119, a schedule management system 120, and a user side device 111 via a network 112.

  The schedule reservation system 119 includes a schedule reservation adjustment system 103, a reservation condition history database 109, and a member information database 110. The schedule management system 120 includes a schedule management server 113, a schedule database 117, and a user / facility information management table 118.

  The schedule reservation adjustment system 103 includes an input information registration unit 104, a schedule result analysis unit 105, and a result display unit 108, and holds a reservation condition history database 109 and a member information database 110.

  The schedule management server 113 includes a schedule reservation / edit management unit 114, a user / facility management unit 115, and a schedule search unit 116, and holds a schedule database 117 and a user / facility information management table 118.

  The user apparatus 111 can access the schedule reservation adjustment system 103 via the network. Here, it is assumed that the schedule reservation adjustment system 103 also provides a GUI (Graphical User Interface) function to the user. The GUI input screen and the result output screen are shown in detail in FIGS.

  The input information registration unit 104 implements a GUI function in the user side device 111 via the network. Here, based on information input by the user using the GUI function, data for registration in the reservation condition history database 109 and confirmation of the schedule in the schedule management server 113 are created. Further, it is assumed that a login function for confirming the identity of the user by using a user ID, a password or the like when the user operates the GUI function is provided.

  The schedule result analysis unit 105 analyzes the member reservation information acquired from the schedule management server 113, and the member adjustment unit 106 that analyzes members who can attend on behalf of the main member when the main member cannot participate. A duplicate reservation analysis unit 107 is provided, and information on an empty schedule is acquired based on the search result acquired from the schedule management server 113. Then, the schedule analysis is performed by comparing the vacant schedule with the reservation input information from the user. If there is a vacant schedule corresponding to the desired condition specified by the user side device 111 for both the date and time and the participating members, the condition display unit 108 processes the condition and notifies the user side device 111 via the network. The screen at this time is shown in FIG.

  The member adjustment unit 106 determines whether or not a representative of the main member exists, and adjusts the proxy member. The proxy member is obtained from the table data for managing the reserved conference and the history information of the participating members stored in the member information database 110. As for this acquisition method, a conference with a conference name similar to the conference name specified by the user is acquired from the history information in which the user who needs to specify the proxy member is registered, and the members in the conference join together. Do that by searching for people. In the case of determining a proxy by the value of the ratio of participating together, the threshold is determined for each system. Once the agent has decided, adjust the agent's schedule. Details of the member information database 110 are shown in FIGS.

  The duplicate reservation analysis unit 107 adjusts the schedule of each conference by comparing the priority of the conference based on the importance and status of the data conference in the reservation condition history database 109 when there is a duplicate schedule in the main member, that is, A process is performed to determine which schedule the main member attends and which schedule the substitute member attends. For the data comparison contents, use the value specified for each system. Details of the reservation condition history database 109 are shown in FIG.

  The analysis unit, registration unit, and display unit are application programs that are loaded into the memory 102 of the schedule reservation adjustment system 103 and executed by the CPU 101 to realize the functions.

  The schedule management server 113 includes a schedule reservation / edit management unit 114 that performs editing from schedule reservation management, a user / facility management unit 115 that manages user and facility information, and searches for registered schedules based on search conditions. The schedule search part 116 to perform is comprised. The schedule management server 113 is connected from the user side device 111 through the client server system via the network 112, or is connected from the schedule reservation adjustment system 103 via the network 112. This schedule management server 113 has a schedule database 117 and a user / facility information management table 118, and stores and manages schedule information of each user / conference room.

  These management units are application programs that are loaded into the memory 102 of the schedule management server 113 and executed by the CPU 101 to realize the functions.

  The schedule reservation / edit management unit 114 accesses the schedule database 117, acquires the schedule information of the user or facility designated from the schedule reservation adjustment system 103 or the user side device 111, and stores it in the schedule database 117. The schedule management of each user / conference room is performed by referring to or updating data in the schedule database 117. The user / facility management unit 115 registers and references the user / facility information management table 118.

  The schedule search unit 116 acquires search conditions from the user side device 111 via the schedule reservation adjustment system 103 or the client server, acquires information from the schedule database 117 and the user / facility information management table 118, and meets the conditions. To extract. The schedule search unit 116 searches the schedule database 117 for data that meets the conditions requested by the schedule reservation adjustment system, for example, and provides a search result. The search result is transferred to the schedule result analysis unit 105 in the schedule reservation adjustment system 103 and used for processing for displaying the result.

  The schedule database 117 is a database that stores schedule information. Details of the table of data stored here are shown in FIG. This database includes a plurality of tables other than those shown in FIG. The user / facility information management table 118 is a database that stores user / facility information for schedule management. Details of the table stored here are shown in FIG. In this database, there are a plurality of tables other than those shown in FIG.

  In the present embodiment, a program for causing a computer to function as each processing unit such as the input information registration unit 104, schedule result analysis unit 105, and result display unit 108 is recorded on a recording medium such as a CD-ROM. It is assumed that the data is stored in the memory and then loaded into the memory and executed. The recording medium for recording the program may be a recording medium other than the CD-ROM. The program may be used by installing it from the recording medium into the information processing apparatus, or the program may be used by accessing the recording medium through a network.

  FIG. 2 is a diagram showing a table data format for managing facility information in the user / facility information management table 118 of this embodiment. As shown in FIG. 2, the facility information table according to the present embodiment includes at least data items of name 201, ID 202, and reservation ID 203. This data is used as a table for managing users and facilities managed by the schedule database 117.

  FIG. 3 is a diagram showing a table data format for managing schedule reservation information in the schedule database 117 of this embodiment. As shown in FIG. 3, the schedule information table of this embodiment holds a reservation ID 301, a reservation name 302, a date 303, a time 304, and a member 305. Here, reservation information is held for each reservation ID 301 and is updated when a reservation is added or changed.

  FIG. 4 is a diagram showing a table data format for managing reservation member information in the reservation condition history database 109 of the present embodiment. As shown in FIG. 4, the member information table of this embodiment holds at least a reservation ID 401 and a conference name 402, a desired period 403, a member 404, a facility ID 405, a conference importance 406, a conference type 407, and a state 408.

  The conference importance 406 stores a value when the user specifies at the time of reservation. This time, it is divided into “normal”, “important”, and “most important” levels, but it may be expressed as a percentage or numerical value. When the main member meetings overlap, this importance is used for weighting when the main member meetings overlap.

  The conference form 407 represents a meeting using a conference room, a TV conference using a conference room, a TV conference using a personal computer, a conference using an electronic bulletin board function on the Web, and the like. It is good also as what proposes according to the request from the user side apparatus 111, and a member's schedule.

  The status 408 indicates the status of the current conference, and status such as rescheduling, attendance confirmation, determination, etc. is entered. In view of this situation, it is used to propose reschedules and weight the key members when overlapping meetings.

  FIG. 5 is a diagram showing a table data format for managing reserved member information in the member information database 110 of the schedule reservation adjusting system 103 of this embodiment. As shown in FIG. 5, the member information table of this embodiment holds at least a reservation ID 501, a member 502, a state 503, and an importance 504.

  The state 503 is registered when the schedule management server 113 is inquired about a schedule answer state after a certain period of time, and is used as a rescheduling element. The importance 504 specifies the role of the user in the reserved conference and whether it is a main member. For example, “required” or not specified (blank notation) is used, but an expression using a numerical value or the like may be used.

  FIG. 6 is a diagram showing a table data format for managing reserved conferences and history information of participating members in the member information database 110 of the present embodiment. As shown in FIG. 6, the history information table of this embodiment holds at least a meeting name 601 and members 602. This data is used to search for proxy members based on similar conference names and participating member information. As for the search system, existing functions such as concept search can be used. In the example of FIG. 6, a simple conference name is illustrated for convenience. However, in actual cases, a specific conference name is used so that a similar conference and a conference that is not so can be sufficiently distinguished. To do.

  FIG. 7 is a flowchart showing a processing procedure of the schedule result analysis unit 105 of this embodiment. As shown in FIG. 7, the schedule result analysis unit 105 receives information such as a conference name, a desired date, a desired time, a desired time zone, and a host member from the input information registration unit 104 when a schedule is reserved. A process of comparing the information managed by the schedule management server 113 and determining a proxy member to act as a proxy for the main member when the schedule input at the time of reservation overlaps with other schedules. I do.

  First, in step 701, the schedule result analysis unit 105 compares the schedule information input by the input information registration unit 104 with the information in the schedule database 117 managed by the schedule management server 113, and the period input as the desired date. Judge whether there is a day that can be reserved by the specified desired time (meeting length) or the conditions of the desired time zone. If NO exists, the process proceeds to step 702.

  In step 702, the information on the holding member of the schedule input by the input information registration unit 104 is compared with the information on the holding member of the schedule duplicated in the schedule database 117, and whether or not there is a duplicate schedule in the main member. If the duplication schedule does not exist in the main member, the process is terminated. If the duplication schedule exists in the main member, the process proceeds to step 703.

  In step 703, information in the reservation condition history database 109 and the member information database 110 is read out, a value indicating the importance of each meeting in the overlapping schedule is calculated, and the priorities of these overlapping schedules are compared. In step 703, the priority of the overlapping conference is determined. At this time, weighting is performed by weighting the value of the conference importance column 406 in FIG. 4 and the importance 504 of the member for the conference in FIG. To do. An example of this weight is shown. Each importance is converted into points, and the schedule with the larger total value is determined to be more important. Regarding the importance of the conference, “most important” is 1, “important” is 0.6, and “normal” is 0.3. Further, the total value is calculated as 1.2 if the member is essential, and as 0 when the member is not essential. It is assumed that the setting of the weighting coefficient can be changed for each system.

  In step 704, when priority is given to the schedule determined to be high in step 703, for the schedule determined to be low in importance, the specified desired time or desired time during the desired date It is determined whether there is a day that can be reserved according to the band condition. If there is a day that can be reserved, the process ends. If there is no day that can be reserved, the process proceeds to step 705.

  In step 705, for the schedule determined in step 704 that there is no day that can be reserved, it is determined by referring to the member information database 110 whether there is a representative of the main member that has become the duplicate schedule. If there is no agent, the schedule is terminated as a schedule cannot be reserved, and if there is an agent, the process proceeds to step 706. The processing content of step 705 will be described in detail with reference to FIG.

  In step 706, a proxy member is acquired from the result of step 705, and the schedule management server 113 is inquired as to whether or not the member can attend as a proxy. Using the result as a new search condition, the process returns to step 701 to continue the determination.

  FIG. 8 is a diagram showing an outline of a conference reservation screen displayed by the schedule reservation adjustment system 103 of this embodiment. This screen shows an example of conference reservation, but it is also possible to handle schedules other than conferences. The conference reservation screen includes at least a conference name 801, a desired duration 802, a desired time 803, a desired time zone 804, a host member 805, a desired location 806, a conference form 807, a conference importance 808, and a rate of matching input conditions 809. Consists of. This screen is input by the user. The items of the conference name 801 and the desired place 806 are required input items, but if no other items are specified, values with better conditions are adopted from the default values and search results.

  FIG. 9 is a diagram showing an outline of the conference reservation information result screen displayed by the search result display unit 108 of the present embodiment. This screen includes a meeting name 901 and reservation plans 906, 907, and 908. For each of the reservation plans 906, 907, and 908, the number of cases displayed varies depending on the status of the search result. This number is not specified in particular.

  The reservation plans 906, 907, and 908 include at least a reservation plan number and status 902, a date and time 903, a member 904, and a venue 905. Here, when a member's proxy proposal is made, the reservation plan number and the status 902 in 907 are bolded or the target portion of the member 904 is highlighted. Similarly, for the conference form, the reservation plan number in 908, the state 902, and the venue 905 are highlighted. Here, an example is shown in which the font size is changed by enclosing the highlighted portion with bold or border lines, but this highlighting method may be a method such as distinction by display color or highlighting with an icon.

  FIG. 10 is a diagram showing a detailed flow of step 705 in FIG. 7 of the present embodiment. FIG. 10 shows processing for determining whether or not a representative of a main member having a duplicate schedule exists with reference to the member information database 110.

  In step 1001, the member information database 110 of FIG. 6 is referred to, data in which the main member is included in the member 602 of the table and the name similar to the conference name 601 is searched, and the result is returned. If no member that is a proxy candidate, that is, a member other than the main member, exists in the searched conference member 602, the process ends. If a member that is a proxy candidate exists, the process proceeds to step 1002.

In step 1002, the participation rate of each member other than the main member is calculated from the member information in the result of step 1001. This is calculated for each member by “the number of conferences in which similar members are participating / the total number of similar conferences searched”, and if the participation rate is 80% or more, the member is a proxy candidate. We will admit as.
In step 1003, the proxy candidates acquired in step 1002 are collected in descending order of participation rate, the proxy candidate information is passed to the caller, and the process ends.

  As described above, according to the schedule reservation adjusting system of the present embodiment, when the schedule input at the time of reservation overlaps with other schedules, the proxy member serving as the proxy for the main member is determined. Even when the schedule overlaps with other schedules, it is possible to reserve the schedule by the proxy member.

It is a figure which shows the structure of the schedule reservation and management system of this embodiment. It is a figure which shows the table data format for managing the facility information in the user and the facility information management table 118 of this embodiment. It is a figure which shows the table data format for managing the schedule reservation information in the schedule database 117 of this embodiment. It is a figure which shows the table data format for managing the member information of the reservation in the reservation condition log | history database 109 of this embodiment. It is a figure which shows the table data format for managing the reservation member information in the member information database 110 of the schedule reservation adjustment system of this embodiment. It is a figure which shows the table data format for managing the conference which reserved in the member information database 110 of this embodiment, and the historical information of a participating member. It is a flowchart which shows the process sequence of the schedule result analysis part 105 of this embodiment. It is a figure which shows the outline | summary of the conference reservation screen which the schedule reservation adjustment system 103 of this embodiment displays. It is a figure which shows the outline | summary of the conference reservation information result screen which the search result display part 108 of this embodiment displays. It is a figure which shows the detailed flow of step 705 of FIG. 7 of this embodiment.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 101 ... CPU, 102 ... Memory, 103 ... Schedule reservation adjustment system, 104 ... Input information registration part, 105 ... Schedule result analysis part, 106 ... Member adjustment part, 107 ... Duplicate reservation analysis part, 108 ... Result display part, 109 ... Reservation condition history database, 110: Member information database, 111: User side device, 112 ... Network, 113 ... Schedule management server, 114 ... Editing management unit, 115 ... Facility management unit, 116 ... Schedule search unit, 117 ... Schedule database, 118 ... User / facility information management table, 119 ... Schedule reservation system, 120 ... Schedule management system, 201 ... Name, 202 ... ID, 203 ... Reservation ID, 301 ... Reservation ID, 302 ... Reservation name, 303 ... Date, 304 ... Time, 305 ... member, 401 ... About ID, 402 ... conference name, 403 ... desired period, 404 ... member, 405 ... facility ID, 406 ... conference importance, 407 ... conference form, 408 ... state, 501 ... reservation ID, 502 ... member, 503 ... state, 504 ... Importance, 601 ... Meeting name, 602 ... Member, 801 ... Meeting name, 802 ... Desired holding period, 803 ... Desired time, 804 ... Desired time zone, 805 ... Holding member, 806 ... Desired place, 807 ... Meeting Form, 808 ... Conference importance, 809 ... Ratio of matching input conditions, 901 ... Conference name, 902 ... Reservation proposal number and status, 903 ... Date and time, 904 ... Member, 905 ... Holding place, 906 to 908 ... Reservation plan.

Claims (5)

In a schedule reservation adjustment method in a schedule reservation adjustment system that includes a storage device and performs schedule reservation and adjustment,
When there is a schedule that overlaps with the input schedule for the main member input at the time of schedule reservation, information indicating the importance of these schedules is read from the storage device and compared, and Determine a less important schedule within
A schedule reservation adjustment method, wherein information on a proxy member acting as a proxy for the main member is read from a storage device and the proxy member attending the overlap schedule is determined for the determined duplicate schedule with low importance.   2. The schedule reservation adjustment according to claim 1, wherein a member of a schedule whose name is similar and whose attending member includes a main member is read from a storage device and a substitute member is determined from the read members. Method.   3. The schedule reservation adjusting method according to claim 1, wherein highlighting indicating the content of the member change by the determined proxy member is performed by an output device. In the schedule reservation adjustment system that performs schedule reservation and adjustment,
When there is a schedule that overlaps with the input schedule for the main member input at the time of schedule reservation, information indicating the importance of these schedules is read from the storage device and compared, and Duplicate reservation analysis section that determines the less important schedule in the
A member adjustment unit that reads information on a proxy member serving as a proxy for the main member from the storage device and determines a proxy member who attends the overlap schedule for the determined duplication schedule of low importance. Schedule reservation adjustment system. In a program for causing a computer to execute a schedule reservation adjustment method for scheduling and adjusting a schedule,
When there is a schedule that overlaps with the input schedule for the main member input at the time of schedule reservation, information indicating the importance of these schedules is read from the storage device and compared, and Determining a less important schedule within
A step of causing a computer to execute, with respect to the determined duplication schedule of low importance, a step of reading information of a surrogate member serving as a surrogate of the main member from a storage device and determining a surrogate member attending the duplication schedule; Program to do.

Images