JP5605231B2 - Information processing apparatus and information processing program - Google Patents

Description

  This case relates to an information processing apparatus and an information processing program.

  In recent years, development of Web systems for clouding office work has been promoted. Recently, in order to improve the service, a service that provides an interface of a Web system equipped only with a function suitable for a customer's business is being realized.

  In such an input field (such as a search condition display form) of an interface for using the Web system, a function for displaying options such as a pull-down display is provided in order to assist the user in inputting. Patent Document 1 discloses a technique for rearranging items specified in the past in the upper level of a pull-down menu in order to facilitate selection of item names to be repeatedly used in selection processing using a pull-down menu. .

JP 2006-113705 A

  However, the presence or absence of the option display function in the interface has to be set by the service provider based on interviews with the customer or the customer himself / herself. For this reason, there is a possibility that it takes time and effort to set the option display.

  Accordingly, the present invention has been made in view of the above problems, and an object thereof is to provide an information processing apparatus and an information processing program capable of easily performing appropriate input support.

The information processing apparatus described herein, on the display device, data for one or more items comprising a display unit that displays an input field for inputting character data for a given item, the predetermined item The acquisition unit that acquires the number of data types related to the item in the input field with reference to the database in which is stored, and whether the number of data types acquired by the acquisition unit is smaller than a predetermined threshold value and a determination unit for determining, the display unit, the result of determination by the determination unit, when the number of types of said data is smaller than said threshold value, and choice of the type of the data, the display device It is an information processing apparatus displayed on top.

The information processing program described in this specification displays an input field for inputting character data on a display device , and corresponds to the input field by referring to a database in which data corresponding to a predetermined item is stored. get the number of types of data items to the number of kinds of data the acquired determines whether less than a predetermined threshold value, a result of the determination, the number of types of the data than the threshold value If it is smaller, the information processing program causes the computer to execute the process of selecting the data type of the item corresponding to the input field stored in the database and displaying it on the display device .
In addition, the information processing program described in the present specification refers to a database in which an item to which data is input and data associated with the item are stored in association with each other. A computer that obtains the number of data types and controls whether to display the data type as a choice on a screen for inputting data to the item based on the obtained number of data types Is an information processing program to be executed.

  The information processing apparatus and the information processing program described in this specification have an effect that appropriate input support can be easily performed.

1 is a diagram schematically illustrating a configuration of a Web system according to an embodiment. This is the hardware configuration of the server. FIG. 3A is a functional block diagram of the server, and FIG. 3B is a display example of a search condition input screen. It is a flowchart which shows a CSV import process. It is a figure which shows an example of the data (CSV file) input into a server. It is a flowchart which shows the specific process of step S20 of FIG. FIG. 7A and FIG. 7B are diagrams illustrating examples of SQL used in step S104. It is a figure which shows an example of a threshold value. It is a figure for demonstrating the method of determining the value n of FIG. It is a figure which shows an example of SQL preserve | saved in a database in step S22 of FIG. It is a flowchart which shows a display process. It is FIG. (1) for demonstrating a modification. It is FIG. (2) for demonstrating a modification.

  Hereinafter, an embodiment will be described in detail with reference to FIGS. FIG. 1 schematically shows a configuration of a Web system 100 including a server 10 as an information processing apparatus.

  As shown in FIG. 1, the Web system 100 includes a server 10 and a plurality of user terminals 12. The server 10 and the user terminal 12 are connected to a network (such as the Internet) 14. In the Web system 100, data used in the user terminal 12 is centrally managed in the database of the server 10, and the server 10 displays the user terminal 12 on the basis of input (such as search condition input) from the user terminal 12. Data is displayed on the device 12A. The user terminal 12 is a terminal that can be connected to a network, such as a PC (Personal Computer), a mobile phone, a smartphone, a PHS (Personal Handy-phone System), or a PDA (Personal Digital Assistant). The user terminal 12 includes a display device 12A including a liquid crystal display, a control device 12B including a CPU, a ROM, a RAM, and the like, and an input device 12C including a keyboard, a touch panel, and the like.

  The server 10 performs processing (CSV import processing) for managing data input from the outside. Further, in response to a request from the user terminal 12, the server 10 performs processing (display processing) for displaying a screen for searching for data on the display device 12A of the user terminal 12 and displaying a search result.

  FIG. 2 shows the hardware configuration of the server 10. As shown in FIG. 2, the server 10 includes a CPU 90, a ROM 92, a RAM 94, a storage unit (HDD (Hard Disk Drive)) 96, an input / output unit 97, a portable storage medium drive 99, and the like. Each component of the server 10 is connected to the bus 98. In the server 10, the CPU 90 executes a program (information processing program) stored in the ROM 92 or the HDD 96 or a program (information processing program) read from the portable storage medium 91 by the portable storage medium drive 99. 3 functions are realized.

  FIG. 3A shows a functional block diagram realized by the server 10 executing the program. As illustrated in FIG. 3A, the server 10 has functions as an acquisition unit, a CSV (Comma Separated Values) import unit 20 as a determination unit, an instruction input reception unit 22, and a display unit 24. In FIG. 3A, the database 26 stored in the HDD 96 (see FIG. 2) of the server 10 is also illustrated.

  The CSV import unit 20 acquires data (for example, data (CSV file) of spreadsheet software as shown in FIG. 5) possessed by a company using the user terminal 12 and stores it in the table of the database 26 (import) ) The data may be acquired from the user terminal 12 via the network 14, or data possessed by a company or the like using the user terminal 12 may be acquired via a storage medium or the like. The specific processing of the CSV import unit 20 will be described later.

  The instruction input receiving unit 22 receives an instruction input from the user terminal 12. The instruction input from the user terminal 12 includes an instruction for displaying a screen (search condition) for searching for data stored in the database 26, and a search result based on the search condition input on the user terminal 12. Instructions for displaying are included.

  The display unit 24 includes a search condition display unit 28 as a first display unit, a pull-down display unit 30 as a second display unit, and a search result display unit 32. The search condition display unit 28 reads the screen data of the search condition stored in the database 26 based on the instruction from the instruction input receiving unit 22 and displays the search condition screen on the display device 12 </ b> A of the user terminal 12. The pull-down display unit 30 performs pull-down display on the display device 12 </ b> A of the user terminal 12 based on the pull-down item (SQL sentence) stored in the database 26. More specifically, the search condition display unit 28 displays items such as “name”, “sex”, “age”, “profession”, etc. shown in FIG. 3B, and character data (letters, numbers, symbols, etc.). An input field 40 for inputting (data) is displayed. The pull-down display unit 30 displays pull-down menus (buttons and options indicated by downward triangles) attached to the items “sex” and “age” shown in FIG. The specific processing of the pull-down display unit 30 will be described later. The search result display unit 32 searches the database 26 based on the contents input for each item in FIG. 3B on the user terminal 12, and displays the search result on the display device 12A.

  Next, the process of the CSV import unit 20 (CSV import process) will be described with reference to the flowchart of FIG. In the process of FIG. 4, first, in step S10, the CSV import unit 20 uploads a file (CSV file). Here, as an example, it is assumed that a file as shown in FIG. 5 created in a company to which a user who uses the user terminal 12 belongs is uploaded.

  Next, in step S12, the CSV import unit 20 checks the columns. Specifically, the CSV import unit 20 checks column items (such as “name” and “gender”). Next, in step S14, the CSV import unit 20 determines the data type for each column. Here, it is determined whether the data in each column is a numeric string or a character string.

  Next, in step S16, the CSV import unit 20 generates and executes a Create Table statement. As a result, a table composed of the column item checked in step S12 and the field defined by the data type determined in step S14 is generated in the database 26.

  Next, in step S18, the CSV import unit 20 generates and executes an Insert SQL statement. As a result, CSV file data is input (added) to each item of the table generated in step S16.

  Next, in step S20, the CSV import unit 20 executes pull-down determination processing (subroutine). Specifically, the CSV import unit 20 executes processing according to the flowchart of FIG.

  In the process of FIG. 6, first, in step S <b> 102, the CSV import unit 20 extracts one column (for example, a column of items “name” and “gender”) from the table. Next, in step S104, the CSV import unit 20 acquires the number of data types (cardinality) of the extracted column. In this case, the CSV import unit 20 generates and executes an SQL statement as shown in FIG. 7 (a) or FIG. 7 (b). As a result, for example, in the column of the item “name”, since the data types are various, a value close to the number of data (1000) is obtained as the value of the number of data types. On the other hand, in the column of the item “gender”, since the data types are only “male” and “female”, “2” is obtained as the value of the number of data types.

  Next, in step S106, the CSV import unit 20 determines whether the number of data types acquired in step S104 is equal to or less than a predetermined threshold value. Here, the threshold value will be specifically described.

  FIG. 8 shows an example of the threshold value. As shown in FIG. 8, in this example, the threshold value changes according to the total number (x) of data included in the column. In the example of FIG. 8, when the total number x of data is less than a, the threshold value is 0, and when the total number x satisfies a ≦ x ≦ b, the threshold value is x · (n / b ) And changes in a proportional linear manner depending on x. Furthermore, when the total number x is larger than b, the threshold value is a threshold value n (a constant value) obtained from the maximum value b of the range (a or more and b or less). Note that the values of a and b may be fixed values, or may be set by a user, a developer of the Web system 100, or the like.

  Here, n is, for example, as shown in FIG. 9, β is the vertical resolution (number of pixels) of the display screen area in the display device 12A of the user terminal 12, and the size of the character (pixels) displayed on the display screen. This is a value represented by β / α, where α is the number. That is, the value n in this case means the maximum number of display characters in the vertical direction of the display screen of the user terminal 12. Note that the value of n is not limited to this, and may be set by a user or the like, for example, or may be a value obtained by adding a predetermined number of 1 or less to the maximum number of display characters.

  As shown in FIG. 8, the threshold is made different depending on the total number x of data when the total number x of data is extremely small (less than a), the threshold = x · (n / B), the accuracy of determining whether or not to pull down deteriorates. On the other hand, if the total number x is larger (greater than b), the pull-down is performed even though the number of data types is very large. This is because there is a possibility that the usability is deteriorated by being converted into a simple structure.

  Returning to FIG. 6, if the determination in step S106 is affirmative, the process proceeds to step S108. In step S108, the CSV import unit 20 determines to pull down the extracted row data. On the other hand, if the determination in step S106 is negative, the process proceeds to step S110, and the CSV import unit 20 determines that the extracted row data is not to be pulled down.

  Thereafter, when the process proceeds to step S112, the CSV import unit 20 determines whether or not all the rows of the table have been extracted. If the determination is negative, the process returns to step S102 and the above-described processing is repeated. Then, when the determination in step S112 is affirmed, the entire process in FIG. 6 is terminated, and the process proceeds to step S22 in FIG.

  In step S <b> 22 of FIG. 4, the CSV import unit 20 stores the pull-down items in the database 26. In this case, an SQL sentence as shown in FIG. 10 is created and stored in the database 26 only for the line that is determined to be pulled down in the processing of FIG.

  By performing the above processing, the CSV file import processing is completed.

  Next, the process (display process) executed by the display unit 24 will be described with reference to FIG. In the process of FIG. 11, first, in step S30, the search condition display unit 28 waits until there is an input regarding the display instruction of the search condition input screen from the user terminal 12 and the instruction input receiving unit 22 receives the instruction input. To do. Then, when the instruction input receiving unit 22 receives an instruction input, the process proceeds to step S32.

  In step S32, the search condition display unit 28 displays a search condition input screen on the display device 12A of the user terminal 12. Next, in step S34, the pull-down display unit 30 searches for pull-down items. Specifically, the pull-down display unit 30 searches the database 26 to determine whether there is an SQL sentence (see FIG. 10) stored in step S22 of FIG. Next, in step S36, when an SQL sentence is retrieved in step S34, the pull-down display unit 30 executes the SQL sentence and performs pull-down display. By performing the processing as described above, it is possible to display a search condition input screen (including a pull-down display) as shown in FIG. 3B on the display device 12A of the user terminal 12.

  The search result display unit 32 searches the table of the database 26 based on the data content that the user has entered in the input field on the search condition input screen of FIG. Display on 12A.

  As described above in detail, according to the present embodiment, the search condition display unit 28 has the input field 40 for inputting character data related to a predetermined item on the display device 12A (display screen) of the user terminal 12. The CSV import unit 20 refers to the database 26 in which data relating to one or more items including a predetermined item is stored, acquires the number of types of data (cardinality) relating to the item in the input field 40, and It is determined whether the number of data types is smaller than a predetermined threshold. When the number of data types is smaller than the threshold, the pull-down display unit 30 converts the data types into options (pull-down) and displays them on the display device 12A. As described above, in the present embodiment, the pull-down is performed only when the number of types of data input to the input field 40 is limited to a certain number (below the threshold value). With this, an appropriate amount of options can be displayed. Thereby, a user's input support can be performed simply.

  In this embodiment, since the threshold value is changed based on the total number of data stored in the table of the database 26 (FIG. 8), it is determined whether to pull down regardless of the total number of data. Can be done appropriately.

  Further, in this embodiment, when the total number of data (total number of cases) is within a predetermined range (a or more and b or less), the threshold value changes proportionally linearly. In addition, it is possible to appropriately determine whether or not to pull down.

  In the present embodiment, when the total number of data is smaller than a predetermined range (a or more and b or less) (that is, smaller than the minimum value (a) of the range), the threshold value is set to zero (0). In this way, it is possible to suppress a decrease in the accuracy of determining whether to pull down when the total number of data is extremely small. However, the present invention is not limited to this, and when the total number of data is smaller than the predetermined reference value (a), the threshold may be set to a number close to zero (0) (for example, 2). In this embodiment, when the total number of data is larger than a predetermined range (a or more and b or less) (that is, larger than the maximum value (b) of the range), the threshold value is set to a value n obtained from b. Therefore, it is possible to suppress the number of data to be pulled down from being excessively increased according to the total number of data.

  In the present embodiment, the threshold is set based on the display screen size (resolution) of the display device 12A and the display size (number of pixels) of the character data. As a result, a pull-down menu (option display) adapted to the size of the display screen becomes possible. In the present embodiment, since the maximum threshold value n is the number of characters that can be displayed on the display screen in the vertical direction, all options can be viewed without scrolling the pull-down menu. Thereby, it becomes possible to improve a user's visibility and usability.

  In the above embodiment, the threshold is set based on the size of the display screen of the display device 12A. However, the size of the display screen of the user terminal 12 may vary. In such a case, the CSV import unit 20 may appropriately acquire information on the display screen of the user terminal 12 and change the threshold based on the information.

  In the above embodiment, when the number of types of data exceeds the threshold value, the pull-down is not performed uniformly. However, the present invention is not limited to this. For example, even when the number of types of data exceeds a threshold, if the data size (number of data characters, etc.) of each column (each item) is larger than a predetermined size, processing such as pulling down may be performed. Good. Specifically, for example, it is assumed that the distribution of the number of characters of data included in a certain column (item) is as shown in FIG. In such a case, the CSV import unit 20 pulls down the data if the number of data exceeding the predetermined number of characters d (number of cases) exceeds a certain value. By doing in this way, when the number of characters of data to be input in the input field is relatively large, the input field can be pulled down, so that user input support can be performed appropriately. Note that the above determination (determination using FIG. 12) may be performed only when the number of types of data exceeds the threshold by a predetermined ratio of the threshold.

  In the above description, the CSV import unit 20 determines whether to perform pull-down based on the number of data exceeding the predetermined number of characters d. However, the present invention is not limited to this. For example, the CSV import unit 20 may determine whether to perform pull-down based on the median value, average value, or maximum value of the number of characters of data.

In the above embodiment, a case has been described in which the threshold value has a value as illustrated in FIG. 8 with respect to the total number of data items. However, the present invention is not limited to this. For example, as shown in FIG. 13, the threshold value may change logarithmically when the total number x is in the range of a ≦ x ≦ b. In the example of FIG. 3, the threshold in the range of a ≦ x ≦ b is log _a x. The threshold value in the range of x> b is a threshold value n (= log _a b) obtained from the maximum value b of the range.

  In the above embodiment, the case where the threshold value changes according to the total number of data has been described. However, the present invention is not limited to this, and the threshold value may be a constant value. The threshold value in this case may be β / α described with reference to FIG. 9, or a value based on β / α (for example, a value obtained by adding a number less than 1 to β / α). Also good. Further, the threshold value may be a value (for example, threshold value = 20) predetermined by the user or the like.

  In the above-described embodiment, the case where the selection is the pull-down has been described. However, the selection is not limited to this, and “auto-complete” that predicts the next input content and displays it in advance may be used. .

  In the above-described embodiment, the case of automatically selecting options (pull-down etc.) on the search condition input screen of the Web system 100 has been described as an example. However, the present invention is not limited to this. For example, the present invention can be applied to a case where it is automatically determined whether or not to use the autocomplete function in a Web page (Web site).

  The above processing functions can be realized by a computer. In that case, a program describing the processing contents of the functions that the processing apparatus should have is provided. By executing the program on a computer, the above processing functions are realized on the computer. The program describing the processing contents can be recorded on a computer-readable recording medium.

  When the program is distributed, for example, it is sold in the form of a portable recording medium such as a DVD (Digital Versatile Disc) or a CD-ROM (Compact Disc Read Only Memory) on which the program is recorded. It is also possible to store the program in a storage device of a server computer and transfer the program from the server computer to another computer via a network.

  The computer that executes the program stores, for example, the program recorded on the portable recording medium or the program transferred from the server computer in its own storage device. Then, the computer reads the program from its own storage device and executes processing according to the program. The computer can also read the program directly from the portable recording medium and execute processing according to the program. Further, each time the program is transferred from the server computer, the computer can sequentially execute processing according to the received program.

  The above-described embodiment is an example of a preferred embodiment of the present invention. However, the present invention is not limited to this, and various modifications can be made without departing from the scope of the present invention.

In addition, the following additional notes are disclosed regarding the above description.
(Supplementary note 1) A first display unit that displays an input field for inputting character data relating to a predetermined item on a display device, and a database storing data relating to one or more items including the predetermined item With reference to, an acquisition unit that acquires the number of types of data related to the item in the input field, a determination unit that determines whether the number of types of data acquired by the acquisition unit is smaller than a predetermined threshold, An information processing apparatus comprising: a second display unit configured to select the data type and display on the display device when the number of data types is smaller than the threshold as a result of determination by the determination unit.
(Additional remark 2) The said predetermined threshold value changes according to the data total number of the item corresponding to the said input column stored in the said database, The information processing apparatus of Additional remark 1 characterized by the above-mentioned.
(Supplementary Note 3) When the total number of data items corresponding to the input field stored in the database is within a predetermined range, the predetermined threshold value changes in a proportional or logarithmic curve. The information processing apparatus according to appendix 2, characterized by:
(Additional remark 4) When the total number of data of the item corresponding to the said input column stored in the said database is smaller than a predetermined range, the said predetermined threshold value is zero, It adds to 2 or 3 characterized by the above-mentioned The information processing apparatus described.
(Supplementary Note 5) When the total number of data items corresponding to the input field stored in the database is larger than a predetermined range, the predetermined threshold value is a threshold value for the maximum total data number in the predetermined range. The information processing apparatus according to any one of appendices 2 to 4, wherein the information values are the same.
(Supplementary note 6) The information processing according to any one of supplementary notes 1 to 5, wherein the predetermined threshold value is set based on a screen size of the display device and a display size of the character data. apparatus.
(Additional remark 7) Even if the said data type number is larger than the said threshold value as a result of determination by the said determination part, the said 2nd display part is the magnitude | size of the data of the item corresponding to the said input column stored in the said database The information processing apparatus according to any one of appendices 1 to 6, wherein the data type is displayed as alternatives based on the data.
(Additional remark 8) The input column for inputting character data is displayed on the display device of the display device, and the data of the item corresponding to the input column is referred to by referring to the database storing the data corresponding to the predetermined item. The number of types of data is acquired, and it is determined whether the number of types of acquired data is smaller than a predetermined threshold. If the number of data types is smaller than the threshold as a result of the determination, An information processing program for causing a computer to execute a process of selecting a data type of an item corresponding to the stored input field and displaying it on the display screen.
(Supplementary note 9) The information processing program according to supplementary note 8, wherein the predetermined threshold value changes in accordance with a total number of data items stored in the database and corresponding to the input field.
(Additional remark 10) When the data total number of the item corresponding to the said input column stored in the said database exists in a predetermined range, the said predetermined threshold value changes in a proportional linear or logarithmic curve. The information processing program according to appendix 8, characterized by:
(Supplementary note 11) The supplementary note 9 or 10, wherein the predetermined threshold value is zero when the total number of data items corresponding to the input field stored in the database is smaller than a predetermined range. The information processing program described.
(Additional remark 12) When the data total number of the item corresponding to the said input column stored in the said database is larger than a predetermined range, the said predetermined threshold value is the threshold value in the maximum data total number in the said predetermined range. The information processing program according to any one of appendices 9 to 11, characterized by having the same value.
(Supplementary note 13) The information processing according to any one of supplementary notes 8 to 12, wherein the predetermined threshold value is set based on a screen size of the display device and a display size of the character data. program.
(Supplementary Note 14) In the process of selecting the option and displaying it on the display screen, even if the number of data types is larger than the threshold value as a result of the determination, it corresponds to the input field stored in the database. 14. The information processing program according to any one of appendices 8 to 13, wherein the data type is displayed as an option based on the size of the item data.

12A display device 10 server (information processing device)
20 CSV import unit (acquisition unit, determination unit)
28 Search condition display section (first display section)
30 Pull-down display (second display)

Claims (9)

On the display device, and a display unit that displays an input field for inputting character data for a given item,
An acquisition unit that acquires the number of types of data related to the items in the input field with reference to a database that stores data related to one or more items including the predetermined items;
A determination unit that determines whether the number of types of data acquired by the acquisition unit is smaller than a predetermined threshold ;
Information the display unit as a result of the determination by the determination unit, which when the number of types of said data is smaller than said threshold value, and choice of the type of the data, and displaying on said display device Processing equipment.   The information processing apparatus according to claim 1, wherein the predetermined threshold changes according to a total number of data items stored in the database and corresponding to the input field.   When the total number of data items corresponding to the input field stored in the database is within a predetermined range, the predetermined threshold value changes proportionally or logarithmically. The information processing apparatus according to claim 2.   4. The information according to claim 2, wherein the predetermined threshold value is zero when the total number of items corresponding to the input field stored in the database is smaller than a predetermined range. Processing equipment.   When the total number of data items corresponding to the input field stored in the database is larger than a predetermined range, the predetermined threshold value is the same value as the threshold value of the maximum total data number in the predetermined range. The information processing apparatus according to claim 2, wherein the information processing apparatus is provided.   The information processing apparatus according to claim 1, wherein the predetermined threshold value is set based on a screen size of the display device and a display size of the character data. . The display unit is based on the data size of the item corresponding to the input field stored in the database even when the number of types of the data is larger than the threshold as a result of the determination by the determination unit. The information processing apparatus according to any one of claims 1 to 6, wherein the data type is displayed as a choice. An input field for inputting character data is displayed on the display device,
Referring to a database in which data corresponding to a predetermined item is stored, obtain the number of data types of the item corresponding to the input field,
Determining whether the number of types of acquired data is less than a predetermined threshold;
As a result of the determination, if the number of types of data is smaller than the threshold, the type of data corresponding to the input field stored in the database is selected and displayed on the display device. the information processing program for executing the processing to the computer.   By referring to a database in which an item to which data is input and data associated with the item are stored in association with each other, the number of types of data associated with the item is acquired,
  Based on the number of types of acquired data, control whether to display the data type as a choice on the screen for inputting data to the item,
An information processing program that causes a computer to execute processing.

Images