JP4568262B2 - Data collection system - Google Patents

Description

  The present invention relates to a data collection system, and more particularly to a technique for generating a program without a user directly inputting source code.

  Computers are now an integral part of everyday life. The computer is mounted on various devices such as a terminal device, a mobile phone, and a home appliance, and appropriately controls hardware included in these devices to realize a predetermined function. For example, a terminal device is used for business management in a company, used for analysis of experimental results in a research institution, and used for sending / receiving e-mails and browsing web pages at an individual level. Generally, in order to realize a predetermined function using a computer, it is necessary to execute the program on the computer.

In order to create such a program, high expertise is required. For example, by creating a source program in a programming language such as C language, C ++ language, JAVA (registered trademark), and compiling it with a compiler, a machine language program executable by a computer is created. There is a technique for automatically generating such a source program based on a tabular program specification (Patent Document 1).
JP 2003-208307 A

  With the spread of computers and the diversification of computer application fields, the required number of programs is increasing year by year. In addition, the development period of such programs tends to be shortened. However, due to chronic programmer shortages, rapid development of program technology, rapid development of devices that execute programs, etc., it often happens that programs cannot be supplied when needed.

  The present invention has been made in view of the above circumstances, and the purpose of the present invention is to shorten the program development period, reduce the labor required for program development, and facilitate the program without requiring advanced knowledge. It is to provide a data collection system that can be created.

According to the present invention, a user terminal that performs a survey based on a predetermined survey content including a plurality of survey items and transmits a survey result ;
A collection device for collecting the survey results transmitted from the user terminal via a network;
A database for storing the investigation results collected by the collection device;
A database server for accumulating the survey results received from the collection device in the database;
The user for realizing a function of forming an input interface for inputting the survey result to the user terminal and transmitting the survey result input via the input interface using the user terminal to the collection device A program generation device for generating a data collection program executable by the terminal;
A data collection system comprising:
The user terminal has a display unit that displays a work screen on which a plurality of input interfaces for inputting answers to the plurality of survey items of the predetermined survey content are formed when the data collection program is executed. ,
The program generation device further generates a table generation program for generating in the database a data table having a data structure corresponding to the survey item of the data collection program,
The program generation device includes:
A screen display unit for displaying a screen for forming the data collection program ;
When the user terminal executes the data collection program, on the work screen displayed on the display unit of the user terminal to display information indicating the contents of the plurality of investigation items of the predetermined investigation contents A plurality of survey item instruction areas, and information necessary for forming components for forming a survey result input area in which the plurality of input interfaces for inputting answers to the plurality of survey items are formed. Component setting area to be input by the user and accepted as a parameter, used when adding the survey item to the work screen, and suitable for the survey item to be added to the work screen from among a plurality of types of the component Allowing the user to select a type of the component and before the selected type A component addition operation button group for receiving an instruction to add a component, and an instruction to generate source code using information necessary for forming the component corresponding to the type, which is input by the user's operation Information for forming an input screen having a generation button for generating the information, and each time the component addition operation button group is operated, information necessary for forming the component corresponding to the selected type is generated. An input screen information generating unit that generates information for forming the input screen in which the component setting areas for receiving as a parameter are input by a user;
A plurality of components for inputting a plurality of parameters for forming a plurality of components suitable for the plurality of survey items on the work screen based on the information generated by the input screen information generation unit A display processing unit for displaying the input screen in which a setting area is formed on the screen display unit;
When the information input by the user operation via the input screen displayed by the display processing unit is managed as a plurality of parameters for forming the work screen, and when the operation of the generation button is received, The plurality of parameters necessary for forming the plurality of components input to the plurality of component setting areas corresponding to the plurality of survey items formed on the input screen, the plurality of parameters corresponding to the plurality of components A parameter management unit that outputs in association with type information that identifies the type,
A reception unit that receives the plurality of parameters output from the parameter management unit ;
The program code for forming each of the components is associated with the type information for specifying the type of the component, and a plurality of types of templates with the parameters as arguments are used for the data collection program and the table generation A template storage for each program,
Corresponding to each type information of the plurality of components from the model storage unit based on each type information of the plurality of components corresponding to the plurality of survey items included in the plurality of parameters received by the receiving unit Selecting and combining a plurality of templates for the data collection program or the table generation program for forming each component to be configured, and setting the parameter in the argument of each template, the data collection program or Generating a source code for each of the table generating programs, and generating a source code completion notification when generating the source code;
When the source code of the data collection program is completed in the generation unit, the source code of the data collection program is compiled to automatically generate a data collection program executable by the user terminal , and the generation A compiling unit that compiles the source code of the table generating program to generate the table generating program when the source code of the table generating program is completed in a unit;
For each data collection program, an identifier assigning unit that assigns a program identifier for associating the data collection program with the data table and the table generation program;
A storage processing unit that outputs the data collection program generated by the compiling unit to the collection device via the network;
A first execution unit that transmits the table generation program generated by the compilation unit to the database server via the network, and instructs the execution of the table generation program;
Only including,
The collector is
A registration unit that receives the data collection program from the program generation device;
A program storage unit for storing the data collection program received by the registration unit;
In response to a request from a user terminal, a program providing unit that provides the data collection program stored in the program storage unit;
There is provided a data collection system including a presentation unit that displays a plurality of data collection programs generated by the program generation device together with the program identifier and presents a list screen for centralized management .

  According to the present invention, a data collection program forming an input interface for inputting data, and a user terminal generates a table for storing predetermined data collected by executing the data collection program in a database. Can automatically generate a table generation program. As a result, the data collection program and the table generation program are automatically generated only by the user inputting the parameters for forming the data collection program.

That is, the user can generate a data collection program and a table generation program without directly inputting source code without requiring advanced program design techniques and knowledge. Further, since each program is automatically generated, debugging of the program becomes unnecessary as compared with creation of source code manually input by a programmer, and the number of man-hours for program creation can be greatly reduced.
Further, according to this configuration, the user can automatically generate the data collection program, the data table, and the table generation program only by inputting the parameters via the input screen.
Furthermore, according to this configuration, the user can automatically generate a data collection program, a data table, and a table generation program simply by determining the survey contents and inputting the corresponding survey item and the answer options. .

In the data collection system, the identifier assignment part of the front SL program generation apparatus, when the first execution unit to generate the data tables in the database to perform the table generation program, the data table the program identifier And the user terminal executes the data collection program, and when the second execution unit executes the data collection program and collects the investigation result , A collection data generation unit that generates a survey result including an identifier; and a transmission unit that transmits the survey result to the collection device via the network. The collection device is transmitted from the user terminal. a receiver for receiving the survey results, accessing the database, the receiving section receives Serial findings from acquiring the program identifier, and a storage unit for storing the survey results in the data table corresponding to the program identifier may include.

According to this configuration, data collected by the user terminal can be automatically stored and accumulated in the corresponding data table of the database.
Furthermore, in the data collection system, the list screen may have a new creation button that accepts a request for new creation of the data collection program when pressed, and when the pressing of the new creation button is accepted, the input screen Is displayed on the screen display unit, the creation of the data collection program is started, and the data collection program created on the input screen can be displayed on the list screen.
In the data collection system, the list screen may include a status display field indicating whether the data collection program is being published or unpublished.

The data collection system may further include an analysis device that analyzes the investigation result stored in the data table of the database, and the program generation device is executed by the analysis device and the data table of the database. And generating a table access program for reading out the accumulated investigation results. In the program generation device, the model storage unit further includes program codes for forming the components, respectively. In association with the type information identifying the type of component, a plurality of types of templates with the parameters as arguments are held for the table access program, respectively, and the generation unit receives the reception unit received by the reception unit Included in multiple parameters The table access for forming each component corresponding to each type information of the plurality of components from the model storage unit based on each type information of the plurality of components corresponding to the plurality of survey items. When a plurality of program templates are selected and combined, the parameters are set in the arguments of each template, the source code of the table access program is generated, and the generation of the source code is completed, Is output as a source code completion notification, and the compiling unit can compile the source code of the table access program and execute the analysis device when the generation unit completes the source code of the table access program Automatic table access program automatically And, before Symbol identifier providing unit, the each data collection program, the program identifier may be applied to correspondence between said table access program and the data collection program.

According to this configuration, a data collection program that forms an input interface for inputting data, a table generation program, and a table access program for accessing data stored in a database are automatically generated. Can do. As a result, the data collection program, the table generation program, and the table access program are automatically generated only by the user inputting the parameters for forming the data collection program.
Further, according to this configuration, the user can automatically generate a data collection program, a data table, a table generation program, and a table access program simply by inputting parameters via the input screen.
Furthermore, according to this configuration, a user automatically determines a survey content and inputs a corresponding survey item and an answer option to automatically generate a data collection program, data table, table generation program, and table access program. Can be made.

  That is, the user can generate a data collection program, a table generation program, and a table access program without directly inputting source code without requiring advanced program design techniques and knowledge. As a result, a data collection system that can perform everything from data input to collection, storage, and analysis can be easily provided. Further, since each program is automatically generated, debugging of the program becomes unnecessary as compared with creation of source code manually input by a programmer, and the number of man-hours for program creation can be greatly reduced.

In the data collection system, the analysis device includes a third execution unit that executes the table access program and the data in the database using the program identifier as a key when the third execution unit executes the table access program. A data file generation unit for accessing the table, reading the investigation result stored in the data table, and generating a data file of a predetermined file format, and an analysis unit for analyzing the investigation result stored in the data file And can be included.

  According to this configuration, the data collected from the portable terminal and stored in the database can be written into a data file having a predetermined file format that is easy to analyze.

  In the data collection system, the list screen may have a plurality of operation buttons including an edit button, an operation button, a copy button, and a delete button for each of the data collection programs. A processing unit that performs each process when a press of each operation button is received can be further provided.

  Furthermore, in the data collection system, when the pressing of the operation button on the list screen is accepted, an operation screen including information on the data collection program in which the operation button is pressed may be displayed on the screen display unit. .

Further, in the data collection system, when the data collection program is unpublished, the operation screen can have a publish button for publishing the data collection program by pressing, and when the press of the publish button is accepted The program providing unit can publish the data collection program so that the user terminal can download it.
  In the above data collection system,
  When the data collection program is unpublished, the operation screen can have an application creation button that causes the generation unit to generate the table access program by pressing, and when the pressing of the application creation button is accepted, The generation unit can generate the table access program.

  Further, in the data collection system, when the data collection program is open to the public, the operation screen can include the investigation result or the information of the table access program.
  In the above data collection system,
  The apparatus may further comprise a program providing device having the registration unit, the program storage unit, the program providing unit, and the presenting unit, wherein the program providing device stores the data collection program generated by the program generating device. The program can be stored in a program storage unit, and the data collection program can be provided to the user terminal via the network.

  Although the configuration of the present invention has been described above, any combination of these configurations, or a conversion of the expression of the present invention between a method, an apparatus, a system, a recording medium, a computer program, and the like is also applicable to the present invention. It is effective as an embodiment.

  According to the present invention, a data collection system is provided in which a program development period is short, a labor required for program development is small, and a program can be easily created without requiring advanced knowledge.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. In all the drawings, the same reference numerals are given to the same components, and the description will be omitted as appropriate.

  FIG. 1 is a schematic block diagram showing the configuration of a survey system 10 according to an embodiment of the present invention. The data collection system (survey system 10) of the present embodiment includes a user terminal (terminal device 50), a collection device 220 that collects predetermined data transmitted from the user terminal via a network, and the collection device 220 collects the data. A database for storing predetermined data (survey data database 340) and an input interface for inputting data to the user terminal are formed, and the data input via the input interface is transmitted to the collection device using the user terminal. A data collection system (investigation system 10) that includes a program generation device 100 that generates a data collection program that can be executed by a user terminal for realizing a function. The program generation device 100 forms a data collection program. Accepting part that accepts input of parameters for 110) and the parameters, the source code of the data collection program is dynamically generated, and the data collection program executable by the user terminal is automatically generated by compiling the source code of the data collection program Data collection program generation unit (the generation unit 112 in FIG. 4 and the survey program generation unit 140 in FIG. 7) and a table that dynamically generates a data table having a data structure corresponding to the data collection program in the database based on the parameters. A table generation program generator (generator 112 in FIG. 4) that dynamically generates a source code of the generation program, compiles the source code of the table generation program, and automatically generates a table generation program executable by the collection apparatus. The table generation program generation unit 142) of FIG. For each data collection program, including a data collection program, an identifier assigning unit that applies a program identifier for associating the data table and the table generating program and (survey ID adding unit 146 in FIG. 7), the.

  Further, in the data collection (survey system 10) system of the present embodiment, the system further includes an analysis device 300 that analyzes the collected data stored in the data table of the database (survey data database 340). Based on this, the source code of the table access program for accessing the data table of the database is dynamically generated, and the source code of the table access program is compiled to automatically generate the table access program executable by the analysis apparatus. 4 includes a table access program generation unit (the generation unit 112 in FIG. 4 and the table access program generation unit 144 in FIG. 7), and the identifier adding unit (the survey ID adding unit 146 in FIG. 7) of each data collection program. In The program identifier to impart to associate the data collection program and table access program.

  Specifically, in the investigation system 10 of the present embodiment, the first terminal device 50a, the second terminal device 50b, the third terminal device 50c, and the fourth terminal device 50d (hereinafter simply referred to as “terminal device 50”) The program generation device 100, the program provision device 200, the collection device 220, the analysis device 300, the database server 320, and the survey data database 340 are provided.

  The terminal device 50 is a portable terminal such as a mobile phone or PDA (Personal Digital Assistants). The terminal device 50 may be a device in which an upper limit is set for the data size of the program as a program execution condition, and the memory size is smaller than that of a general terminal. The terminal device 50 includes, for example, a GPS (Global Positioning System) unit that receives a GPS signal from a GPS satellite and acquires position information, a CCD camera, a microphone, and the like. Each terminal device 50 is connected to the first network 12 via the base station 14 and has a function of communicating with the program providing device 200, the collection device 220, and the analysis device 300.

  The program generation device 100 displays the survey content on the display unit 52 of the terminal device 50, generates a survey program for accepting the survey result, and stores it in the program providing device 200. The program providing device 200 provides the investigation program to the terminal device 50 via the first network 12. The investigator conducts a survey based on the survey content displayed on the display unit 52 by executing the survey program. For example, the investigator moves while holding the terminal device 50 to the designated survey point, and conducts the survey on the spot.

  The terminal device 50 acquires position information of the moving point (hereinafter simply referred to as “survey position information”) using a GPS unit. The acquisition instruction may be performed based on an instruction from the investigator, may be automatically performed by an investigation program inside the terminal device 50, or may be performed based on other external signals. . The investigator takes an image of the specified object using the CCD camera of the terminal device 50, and inputs items in accordance with the contents of the investigation to the terminal device 50 using the operation unit 54 such as a key button. Or

  The information acquired by the terminal device 50 other than the survey position information, images, and other information input directly by the investigator is not only used as the survey result, but also determines the reliability of the survey result. It is used as information for That is, since data obtained from the GPS, CCD camera, microphone, etc. of the terminal device 50 cannot generally be rewritten arbitrarily by the investigator, it can be used as information for assuring the reliability of the investigation result. The terminal device 50 transmits the items input by the investigator, the images obtained by each device, the survey position information, and the like to the collection device 220 as the survey results.

  The collection device 220 receives the survey result from the terminal device 50 via the first network 12 and passes the survey result to the database server 320 via the second network 16. The collection device 220 collects survey results associated with survey position information from a plurality of terminal devices 50. The collection device 220 collects the survey results from the terminal device 50 in a format associated with, for example, a CSV format or a parameter name indicating the survey item. In the present embodiment, the second network 16 is preferably an intranet limited to a company or the like.

  FIG. 2 shows an example of the data format of the survey result 190 received from the terminal device 50 by the collection device 220 of this embodiment. Survey result 190 includes, for example, survey ID, surveyor number, surveyor name, machine number, sales department code, sales department name, prefecture code, prefecture name, GPS acquisition date, GPS acquisition time, latitude, longitude, Koei X, Koei Y, answer completion date, answer completion time, transmission date, transmission time, electric field strength, remaining battery level, GPS positioning mode, GPS altitude, and multiple survey item responses can be included.

  Returning to FIG. 1, the database server 320 creates a table in the survey data database 340 for storing data collected by the survey program having a predetermined survey ID by executing a table generation program to be described later. The database server 320 accesses the survey data database 340, receives the survey result received by the collection device 220 from the terminal device 50 via the second network 16, and stores it in the survey data database 340. At this time, the database server 320 finds a corresponding data table in the survey data database 340 using the survey ID included in the received survey result data as a key, and stores the data. The program providing apparatus 200 and the collection apparatus 220 may be the same apparatus.

  The analysis device 300 accesses the survey data database 340, acquires the survey results, determines the reliability of each survey result, and then performs a predetermined analysis. The analysis apparatus 300 acquires a survey result associated with the survey position information. The analysis apparatus 300 can access a data table storing data of any investigation result by executing a table access program described later. The analysis apparatus 300 finds the corresponding data table from the survey data database 340 using the survey ID designated by the user as a key, and reads the data in, for example, CSV format.

  FIG. 3 is a diagram illustrating an example of the transition of the work screen 400 displayed on the display unit 52 of FIG. 1 when the investigation program is executed by the terminal device 50 of the present embodiment. By executing the investigation program, the first work screen 400a is first displayed on the display unit 52 in FIG. 1, and the second work screen 400b, the third work screen 400c, the fourth work screen 400d, and the fifth work screen 400e. , And the sixth work screen 400f. The first work screen 400a includes a title area 402, an input start button 404, and a data transmission button 406. The title area 402 is an area for displaying, for example, a survey name and is displayed at the top of the work screen 400.

  The work screen 400 includes a survey item instruction area 440 for displaying information indicating the survey contents, and a survey result input area 442 for the investigator to input survey results for the survey contents. Although details will be described later, in order to clearly convey the survey content to the investigator, the survey item instruction area 440 includes, for example, a survey content character string 434 representing the survey content, an appearance of a product related to the survey content, An image 420 for explaining the technical terms included in the survey content is included. The survey result input area 442 includes components such as a text box, a radio button, and a check box, which will be described later, and is formed so that, for example, an answer can be selected from options in order to perform an answer efficiently and accurately. The

  The input start button 404 is a button for receiving an instruction for starting an investigation. By selecting the input start button 404, the survey item is displayed on the display unit 52. Here, the survey content is composed of a plurality of survey items. The data transmission button 406 is a button for transmitting the response to the analysis apparatus 300 in FIG. 1 after completing the response to each survey item as the survey result. By pressing or selecting the data transmission button 406, the investigation result is transmitted to the analysis apparatus 300.

  The second work screen 400b is displayed when the input start button 404 is pressed. In the present embodiment, a page is provided for each survey item, and a component for answer input suitable for the survey item is arranged. The page number area 408 is an area for displaying the page number. The answer content character string 410 is an area for displaying a character string indicating the answer content to be input to a text input area 412 described later. The text input area 412 is a text box for inputting an answer, and an arbitrary character string can be input. The radio button group 422 of the fourth work screen 400d is a component for selecting one answer from previously prepared options. Although not shown, a check box for selecting an arbitrary number of answers from options prepared in advance may be provided in the survey result input area 442.

  Returning to the second work screen 400b, the next screen display button 414a is a button for proceeding to the next investigation item, and the work screen 400 is switched by pressing this button. When the next screen display button 414a of the second work screen 400b is pressed, the third work screen 400c is displayed. At this time, the terminal device 50 acquires position information using the GPS unit. When the acquisition of the position information is completed, the fourth work screen 400d is displayed. When the survey item on the fourth work screen 400d is answered and the next screen display button 414b on the fourth work screen 400d is pressed, the fifth work screen 400e is displayed. In this way, the investigator inputs answers to a series of survey items while sequentially switching the work screen 400.

  The shooting start button 430 on the fifth work screen 400e is a button for performing shooting using the CCD camera included in the terminal device 50 of FIG. By pressing the shooting start button 430, the CCD camera becomes active and shooting is possible. As described above, the survey program provided by the program providing device 200 of FIG. 1 is coded so that data obtained by using hardware such as a GPS unit or a CCD camera included in the terminal device 50 can be used as the survey result. Has been.

  In the figure, the sixth work screen 400 f which is the last work screen 400 has a save button 432. The save button 432 is a button for saving the answer input on each work screen 400. By pressing the save button 432, the result is saved as a survey result in the storage area of the terminal device 50. When the investigator selects the data transmission button 406 on the first work screen 400a, the terminal device 50 transmits the saved investigation result to the collection device 220 in FIG.

  In this way, by storing the survey result and then transmitting it, it is possible to conduct a survey in a place where radio waves do not reach, for example, and transmit the survey result in a location where radio waves reach. In other words, since it is possible to investigate without worrying about the radio wave condition, it is possible to investigate in various places. In addition, by implementing these survey items and an input interface for responding through a program, an input interface suitable for the survey items can be provided, so that human errors such as input mistakes can be prevented and rapid surveys can be performed. Is possible. In addition, for example, the number of accesses to the server is significantly reduced as compared with the case where the survey items are provided on a web page, so that the load on the server can be reduced.

  The program for displaying such a work screen 400 may be a program created in a programming language such as JAVA (registered trademark), for example. If the programmer created this program for each survey, it may not be possible to conduct a quick survey, for example, because a necessary survey cannot be performed at the necessary timing due to a problem in the development period. Also, due to human error, wrong survey items and options may be included. It may also be possible to refrain from investigation due to the problem of program development costs.

  Therefore, it is necessary to automatically generate such a program in order to operate the survey system 10 of FIG. Generally, a program is generated by compiling source code. Programmers create source code using various development tools. However, since a high level of knowledge is required for the work, ordinary people cannot easily create source code.

  The present inventor assumed various surveys and studied the input interface. As a result, by unifying the input interface for each survey item and creating a model, the combination processing of the model and the character string in the model It was conceived that the source code can be automatically generated by the process of substituting with another character string. The program generation apparatus 100 in FIG. 1 automatically generates a program by generating source code and compiling in accordance with this method.

  The programs generated by the program generation apparatus 100 include the above-described investigation program, table generation program, and table access program. The table generation program is executed by the database server 320 in accordance with an instruction from the program generation apparatus 100 and creates a data table in the survey data database 340 for storing the collected survey results in the survey data database 340. is there.

  In the data collection system (investigation system 10) of the present embodiment, the program generation device 100 includes a first execution unit (execution instruction unit 134 in FIG. 4) that executes a table generation program, and an identifier assignment unit of the program generation device 100. (Survey ID assigning unit 146 in FIG. 7) assigns a program identifier (survey ID) to the data table when the first execution unit executes the table generation program to generate a data table in the database (survey data database 340). The user terminal (terminal device 50) includes a second execution unit (not shown) that executes the data collection program and a program identifier when the second execution unit executes the data collection program and collects predetermined data. A collection data generation unit (not shown) that generates collection data including A transmission unit (not shown) that transmits to the collection device 220 via the network 12). The collection device 220 receives a collection data transmitted from the user terminal (terminal device 50) (not shown). And a storage unit (database server) that accesses the database (survey data database 340), acquires a program identifier (survey ID) from the collected data received by the receiving unit, and stores the collected data in a data table corresponding to the program identifier 320).

  The table access program is executed by the analysis apparatus 300 to read out the investigation results stored in the investigation data database 340 and write it in a predetermined file format.

  FIG. 4 is a functional block diagram showing the configuration of the program generation device 100 of FIG. The program generation device 100 includes a display unit 102, a display processing unit 104, an operation unit 108, a reception unit 110, a generation unit 112, a compilation unit 114, a storage processing unit 118, and an input screen information generation unit 124. A content storage unit 126, a model storage unit 128, a basic function storage unit 130, an execution instruction unit 134, a first interface unit 136, and a second interface unit 138.

  Each component of the program generation device 100 is centered on a CPU of a computer, a memory, a program that realizes the components of this figure loaded in the memory, a storage unit such as a hard disk that stores the program, and a network connection interface. However, it will be understood by those skilled in the art that there are various modifications in the implementation method and apparatus. Each drawing described below shows a functional unit block, not a hardware unit configuration.

  The input screen information generation unit 124 forms an input screen on the display unit 102 for inputting various information necessary for forming the above-described investigation program (hereinafter simply referred to as “investigation program”). Is generated and output to the display processing unit 104. The display processing unit 104 causes the display unit 102 to display the content of the notification from the input screen. The operation unit 108 is an input device such as a keyboard or a mouse, for example. The operation unit 108 receives an operation from the user and outputs various information regarding the input screen to the parameter management unit 109. The parameter management unit 109 manages the input information as a parameter in association with a parameter name or the like. Then, the input screen information generation unit 124 reads the parameters managed by the parameter management unit 109, and reflects the newly input parameters on the input screen. The parameter management unit 109 outputs the parameter being managed to the reception unit 110 at a predetermined timing.

  FIG. 5 is a diagram showing an example of the input screen 450 displayed on the display unit 102 of FIG. The various information input area 460 is an area for inputting various information necessary for the investigation program to realize the functions described above. “Survey ID” is information for identifying a survey program. For example, when a survey result is transmitted to the analysis apparatus 300 in FIG. 1, the survey ID is transmitted in association with the survey result. For example, a survey ID assigning unit, which will be described later, can automatically assign a survey ID to the survey program with a serial number when creating the survey program. “Survey name” is a name for each survey, and is displayed in the title area 402 of FIG. The “data transmission URL” is an area for inputting information for identifying the analysis apparatus 300 in FIG. 1 as the transmission destination of the investigation result on the first network 12. For example, the URL (Uniform Resource) of the collection apparatus 220 is used. Locator) is set.

  The component addition operation button group 462 is used when adding a survey item. The type selection component 470 is a component for designating the type of component used for inputting the answer of the survey item to be added. As a component type that can be selected by the type selection component 470, for example, a radio button (indicated as “SA” in the drawing) that can select one answer from a plurality of options, any number of options from a plurality of options There is a check box (indicated as “MA” in the figure) that can select an answer, and a text box (indicated as “Text” in the figure) for inputting text. By selecting an arbitrary type from the type selection component 470 and pressing a component addition button 472, a component setting area 464 corresponding to the selected type is added.

  Each component setting area 464 has, for example, text so that information necessary for forming the survey item instruction area 440 in FIG. 3 and information necessary for forming the survey result input area 442 in FIG. 3 can be input. It consists of components such as boxes and check boxes.

  The first component setting area 464a is added when “text box” is selected as the component type. The type display area 476 displays the component type. In the first component setting area 464a, a question sentence input area 480 and an image selection component 486 are provided in order to form the survey item instruction area 440 of FIG. In addition, an answer input area 482, a maximum character number specifying area 488, and an input character type specifying box 490 are provided to form the survey result input area 442 of FIG.

  The question sentence input area 480 is an area for inputting a document for instructing a matter to be investigated by the investigator, for example. The character string input here is displayed as the survey content character string 434 in FIG. The image selection component 486 is a component for selecting image content to be displayed as the image 420 in FIG. 3, and is formed so that any image content can be selected from a list, for example. Although the details will be described later, the content storage unit 126 in FIG. 4 stores image content, and the input screen information generation unit 124 generates a list of image contents stored in the content storage unit 126, and FIG. The image selection component 486 is formed.

  The answer input area 482 is an area for inputting a character string displayed around the text box. This character string is arranged on the upper, lower, left, or right side of the text box for inputting an answer. The maximum number of characters designation area 488 is an area for setting an upper limit of the number of characters that can be entered in the text box. The input character type designation box 490 is a check box for designating a character type that can be entered in the text box. In the present embodiment, only a number can be input by checking, and any character type such as hiragana, katakana, kanji, alphabet, and numbers can be input by removing the check. Note that the answer input area 482, the maximum character number specifying area 488, and the input character type specifying box 490 are associated with each other.

  In this figure, “input vending machine ID” is entered in the answer input area 482, “4” is entered in the maximum character number designation area 488, and the input character type designation box 490 is checked. Thereby, the second work screen 400b of FIG. 3 is formed. That is, “Enter vending machine ID” is displayed in the response content character string 410 above the text input area 412. In the text input area 412, only numbers can be input, and the maximum number is 4 characters.

  Returning to FIG. 5, the answer addition button 478 adds an answer input area 482. That is, when a plurality of text boxes are provided as the survey result input area 442 in FIG. 3, the answer addition button 478 is pressed a desired number of times. As a result, as many answer input areas 482 as the answer add button 478 is pressed are newly added to the first component setting area 464a. A character string can be individually set for each added answer input area 482. Of course, the maximum character number designation area 488 and the input character type designation box 490 associated with each answer input area 482 can be individually set. In addition, an answer addition button 478 in a second component setting area 464b and a third component setting area 464c described later adds an answer input area 482 for a radio button and a check box, respectively.

  The answer deletion component 494 is a component for deleting the answer input area 482. By pressing the answer deletion component 494, the corresponding answer input area 482 is deleted.

  The radio button 474 is a component for designating whether to associate position information with the survey result, that is, whether to use the GPS unit of the terminal device 50 in FIG. When the radio button 474 is checked, position information is associated with the survey result. In the present embodiment, when the radio button 474 of any one of the component setting areas 464 is checked, the position information is acquired at any timing after executing the investigation program.

  The survey item deletion component 496 is a component for deleting a survey item. By pressing the survey item deletion component 496, the component setting area 464 of the corresponding survey item is deleted.

  The second component setting area 464b is added when “radio button” is selected as the component type. The character string input in the answer input area 482 of the second component setting area 464b is displayed in association with each radio button. That is, each option is input to each answer input area 482. The link designation area 492 is a component for designating whether or not to display other survey items specified as link destinations instead of displaying survey items in order when the answer is selected. For example, the link designation area 492 is formed so that an arbitrary survey item can be selected from the list of survey items. Then, when the radio button is selected, the screen of the survey item designated as the link destination is displayed.

  The third component setting area 464c is added when “check box” is selected as the component type. The character string input in the answer input area 482 of the third component setting area 464c is displayed in association with each check box. That is, each option is input to each answer input area 482.

  Such display processing is realized by the input screen information generation unit 124 rewriting information for forming the input screen 450 as needed based on parameters updated in accordance with a user operation on the operation unit 108 in FIG.

  The generation button 452 is a button for instructing generation of source code using various information input on the input screen 450. The cancel button 454 is a button for canceling input to the input screen 450. When the generation button 452 is pressed, the parameter management unit 109 in FIG. 4 outputs the parameter being managed to the reception unit 110. Although there are various output forms of parameters, in the present embodiment, the parameter management unit 109 sends each parameter to the reception unit 110 as an XML (eXtensible Markup Language) format file (hereinafter simply referred to as “parameter file”). Output.

  FIG. 6 is a diagram illustrating an example of a data structure of the parameter file 150 output from the parameter management unit 109 of FIG. 4 to the reception unit 110. All parameters for generating one investigation program are held by being surrounded by a parameter start tag 151a indicating the start of the parameter and a parameter end tag 151b indicating the end of the parameter. Each parameter is held by being surrounded by a tag indicating the name of the parameter. The survey ID field 152, the name field 154, and the URL field 156 hold the “survey ID”, “survey name”, and “data transmission URL” input in the various information input area 460 of FIG. Further, various information input to the component setting area 464 in FIG. 5 is held in the page configuration information column 160 surrounded by tags. In the present embodiment, information for forming one page, that is, one work screen 400 in FIG. 3 is included in one page configuration information column 160.

  The page number column 162 holds page identification information for identifying pages, and may hold the order of display, for example. That is, the generation unit 112 in FIG. 4 described later determines the order in which each page is displayed based on the page identification information, and generates source code so that each page is displayed in that order. This page identification information is assigned to each component setting area 464 in ascending order, for example, by the parameter management unit 109 in FIG. 4 when the component setting area 464 is added by operating the component addition button 472 in FIG.

  The component column 174 holds various information for forming the survey result input area 442 of FIG. The data name column 164 holds a data name for specifying an answer input or selected by the component. The terminal device 50 in FIG. 1 transmits a response in association with the data name when transmitting the survey result to the analysis device 300. In another example, when the survey result is transmitted in the CSV format, the data name need not be set.

  The type column 166 is a type for specifying the type of component such as text (indicated as “Text” in the figure), radio box (indicated as “SA” in the figure), check box (indicated as “MA” in the figure), and the like. Keep information. Information for identifying components for controlling the hardware of the terminal device 50 such as a GPS component that acquires position information and a photographing component that captures an image using a CCD camera is also stored in the type column 166 as type information. Is done.

  The character string column 168 holds the character string input in the answer input area 482 of FIG. The character type column 170 holds information for specifying the types of characters that can be input. In the present embodiment, “numeric” is set when the input character type designation box 490 of FIG. 5 is checked, and information indicating an arbitrary character type is set when it is not checked. The number-of-characters column 172 holds the number input in the maximum number-of-characters designation area 488 of FIG.

  When text is held in the type field 166, the component field 174 includes a character type field 170 and a character number field 172 to form a text box. In addition, when “SA” indicating a radio box or “MA” indicating a check box is held in the type column 166, a character string column 168 corresponding to the number of branches of options is formed to form a radio box or a check box. included.

  The question sentence column 180 holds the character string input in the question sentence input area 480 of FIG. The image file name column 182 holds the file name of the image file selected by the image selection component 486 of FIG. In another example, the image file name column 182 may hold a path or URL indicating the storage location of the image file.

  Returning to FIG. 4, the parameter management unit 109 holds the parameters for forming the work screen 400 of FIG. 3 in groups for each survey item, that is, for each page configuration information column 160. The parameter file is output to the reception unit 110 in FIG.

  The receiving unit 110 receives a parameter file from the parameter management unit 109. As illustrated in FIG. 7, the generation unit 112 includes a survey program generation unit 140, a table generation program generation unit 142, a table access program generation unit 144, and a survey ID assignment unit 146.

  The investigation program generation unit 140 dynamically generates a source code of the investigation program based on the parameters received by the reception unit 110 and passes the generated source code to the compilation unit 114. The table generation program generation unit 142 dynamically generates the source code of the table generation program based on the parameters received by the reception unit 110 and passes the generated source code to the compilation unit 114. The table access program generation unit 144 dynamically generates a source code of the table access program based on the parameter received by the reception unit 110 and passes it to the compilation unit 114. The survey ID assigning unit 146 assigns a survey ID for associating the survey program, the table generating program, and the table access program to each survey program for which the survey program generating unit 140 generates the source code.

  Returning to FIG. 4, the template storage unit 128 holds a plurality of types of templates for generating source code. In the present embodiment, the template storage unit 128 holds necessary templates for each of various programs such as a survey program, a table generation program, and a table access program. The generation unit 112 reads a template corresponding to the program to be generated, and the generation unit 112 combines the templates and inserts the parameters included in the parameter file at predetermined positions of each template, or in the template A source code is generated by substituting a predetermined character string with a parameter.

  The model storage unit 128 associates and stores a model and information for specifying a function and an input interface realized by the model. For example, the model storage unit 128 stores program codes for realizing these components in the terminal device 50 as templates, in association with the type information.

  In general, various program languages are provided with functions for realizing predetermined processing in advance as an API (Application Program Interface). The source code is created by combining those APIs according to the grammar for each programming language. The model may be, for example, a program code combining a plurality of functions, or may be a program code composed of one function. In short, the model storage unit 128 may store the component type and the model in association with each other.

  Various algorithms for generating the source code based on the parameter file can be considered. The model held by the model storage unit 128 is appropriately prepared according to the algorithm.

  For example, a template for generating a work screen 400 having a text box as the survey result input area 442 in FIG. 3 includes a character string display function for displaying a character string and a text box function for displaying a text box. Is included. Then, for example, a predetermined variable name is assigned to the argument so that the information held in the character string field 168, the character type field 170, and the character number field 172 in FIG. . For example, the generation unit 112 may generate a source code by substituting a parameter corresponding to the variable, or may generate a source code by replacing the variable with a parameter.

  The template for generating the work screen 400 having radio boxes and check boxes as the survey result input area 442 in FIG. 3 includes a character display function, and displays a radio box function or check box for displaying the radio box. Include at least one of the checkbox functions. The program code included in such a template may be appropriately described according to an algorithm for generating source code based on the parameter file. In short, the generation unit 112 may specify a function or template for forming the component based on the type information included in the parameter file, and set a parameter for the argument.

  When the parameter file includes the image file name field 182 of FIG. 6, the generation unit 112 reads the corresponding image content from the content storage unit 126 and outputs it to the compilation unit 114 together with the source code at a predetermined timing. For example, the timing may be when the compiling unit 114 described later performs a compiling process.

  When the generation unit 112 finishes generating the source code, the generation unit 112 outputs the fact to the compile unit 114 as a source code completion notification. For example, the generation unit 112 sequentially performs a process of converting into the source code in units of the page configuration information column 160 of the parameter file. The source code is completed when the conversion is completed for all the page configuration information fields 160. At this time, that is, when the conversion for all the page configuration information fields 160 is completed, the generation unit 112 may output the fact to the compilation unit 114. In addition, the generation unit 112 performs a process of sequentially converting the source code based on each parameter from the parameter start tag 151a to the parameter end tag 151b of the parameter file, and ends the conversion process when the parameter end tag 151b is reached. A source code completion notification may be output to the compiling unit 114.

  The basic function storage unit 130 holds various files necessary for compilation. The compiling unit 114 uses a file held in the basic function storage unit 130 to convert the source code into an object code, and generates an investigation program, a table generation program, or a table access program.

  The storage processing unit 118 outputs the investigation program generated by the compiling unit 114 to the program providing apparatus 200 so that it can be distributed. Further, the storage processing unit 118 delivers the table generation program to the execution instruction unit 134. The execution instruction unit 134 transmits the table generation program to the database server 320 on the second network 16 via the first interface unit 136 and instructs the execution of the table generation program. Further, the storage processing unit 118 transmits the table access program to the analysis device 300 on the third network 18 via the second interface unit 138.

  With this program generation device 100, a user simply inputs a survey item using the input screen 450 in FIG. 5 to generate a source code and automatically compile the survey code, a table generation program, and a table access A program can be generated.

  FIG. 8 is a functional block diagram showing the configuration of the program providing apparatus 200 of FIG. The registration unit 202 receives a survey program from the program generation device 100. Then, the registration unit 202 stores the accepted survey program in the program storage unit 204. The program providing unit 206 provides an investigation program stored in the program storage unit 204 in response to a request from the terminal device 50. When providing the survey program, the program providing unit 206 authenticates the investigator using, for example, identification information uniquely assigned to the terminal device 50, and when the authentication is successful, the program providing unit 206 transmits the survey program to the terminal device 50. May be provided.

  The operation of the survey system 10 of the present embodiment configured as described above will be described below. FIG. 9 is a flowchart showing an example of the operation of the investigation system 10 of the present embodiment. Hereinafter, a description will be given with reference to FIGS.

  First, in the program generation device 100 of FIG. 4, the input screen 450 of FIG. 5 is displayed on the display unit 102 (S10). The user inputs “survey ID”, “survey name”, and “data transmission URL” in the various information input area 460 according to the input screen 450. Further, the component addition button 472 in FIG. 5 is operated to add the component setting area 464, select the component type, and form the survey item instruction area 440 in FIG. The question text input and the presence / absence of the image selection component 486 are selected. Furthermore, at least one answer can be entered in the answer input area 482. In this way, the parameters input by the user using the input screen 450 are received by the parameter management unit 109 in FIG. 4 from the operation unit 108 in FIG. 4 and transferred to the reception unit 110 in FIG.

  Then, the receiving unit 110 in FIG. 4 receives a parameter file from the parameter management unit 109 in FIG. 4 (S12). Then, the generating unit 112 in FIG. 7 selects a model for the survey program from the model storage unit 128 based on the parameters included in the parameter file received by the receiving unit 110 (S14), and the survey program in FIG. The generation unit 140 replaces the predetermined argument in the template with the parameter in the parameter file, and generates the source code of the investigation program (S16).

  Furthermore, when the survey program source code of the survey program generation unit 140 in FIG. 7 is completed, the compiling unit 114 in FIG. 4 compiles the source code of the survey program (S18). At this time, a file name including the survey ID is given to the compiled survey program by the survey ID assigning unit 146.

  The compiled survey program is output to the storage processing unit 118 in FIG. 4, and the storage processing unit 118 outputs the survey program to the program providing device 200 in FIG. 1 so that it can be provided to the terminal device 50 in FIG. (S20). For example, as will be described later, the terminal device 50 can access the program providing apparatus 200 and download it by publishing the investigation program on the first network 12.

  Subsequently, the table generation program generation unit 142 in FIG. 7 replaces predetermined arguments in the template for the table generation program selected from the template storage unit 128 with parameters in the parameter file, and the source of the table generation program A code is generated (S22). Then, when the table generation program source code 142 in FIG. 7 completes the source code of the table generation program, the compiling unit 114 in FIG. 4 executes compilation of the source code of the table generation program (S24). At this time, a file name including the survey ID is given to the compiled table generation program by the survey ID giving unit 146.

  Then, the compiled table generation program is transferred to the execution instruction unit 134 of FIG. 4 and transmitted to the database server 320 on the second network 16 via the first interface unit 136. Then, the execution instruction unit 134 instructs the database server 320 to execute the table generation program (S26). At this time, the database server 320 executes the received table generation program, and a data table is created in the survey data database 340 by the table generation program.

  The data table created here is a table having a data structure corresponding to the survey item of the survey program. A file name including a survey ID is assigned to the data table. When the database server 320 stores the survey result data collected by the collection device 220, the database server 320 searches for a data table storing data using the survey ID included in the survey result data as a key, and stores the survey result in the corresponding data table. Store the data. The data of the survey result 190 has the format shown in FIG. 2 and is accumulated in the data table in the order received by the collection device 220.

  Furthermore, the table access program generation unit 144 in FIG. 7 replaces predetermined arguments in the template for the table access program selected from the template storage unit 128 with parameters in the parameter file, and the source code of the table access program Is generated (S28). Then, when the source code of the table access program is completed in the table access program generation unit 144 of FIG. 7, the compiling unit 114 of FIG. 4 executes compilation of the source code of the table access program (S30). At this time, the compiled table access program is given a file name including a survey ID by the survey ID assigning unit 146.

  10 and 11 show an example of the source code of the table access program 500. FIG. The table access program 500 can include a server name 502, a table name 504, survey common information 506, a plurality of survey items 508, and options 510. As shown in the survey item 508 and the options 510, the character string of the survey item when the survey is executed on the work screen 400 of FIG. 3 is used.

  The survey item 508 and the options 510 can be used as, for example, field names when survey result data is read from the data table of the survey data database 340 and written into a file of a predetermined format. As a result, the survey result data read by the table access program is not a simple list of data, but a record group having a particularly easy-to-understand meaning. The survey results read out in this way become data that can be handled more easily by various analyzes thereafter. For example, if it is written out in CSV format as it is, it can be easily tabulated and charted by reading it into spreadsheet software or the like, and various analyzes are possible.

  Then, the compiled table access program is transmitted to the analysis apparatus 300 of FIG. 1 on the third network 18 via the second interface unit 138 of FIG. 4 (S32). In the analysis apparatus 300, a table access program can be stored in a program storage unit (not shown) and executed in response to a user request. Alternatively, similar to the investigation program, the table access program is also registered in the program providing apparatus 200, and the analysis apparatus 300 accesses the program providing apparatus 200 to download the necessary table access program to the analysis apparatus 300. You can also. In this case, the analysis apparatus 300 in FIG. 1 is connected to the program providing apparatus 200 via the third network 18. In the present embodiment, the third network 18 is preferably an intranet limited to a company or the like.

  FIG. 12 is a diagram showing an example of a survey list screen 530 for creating and editing a plurality of survey programs in the survey system 10 of the present embodiment. In the present embodiment, the survey system 10 can include a presentation unit (not shown) that presents a survey list screen 530 that centrally manages a plurality of survey programs. The survey list screen 530 includes a new creation button 532, and when the new creation button 532 is pressed, creation of a survey program is started. That is, the input screen 450 in FIG. 5 is displayed on the display unit 102 of the program generation device 100.

  For example, in the program generation device 100, the operation unit 108 receives the press of the new creation button 532, and the display processing unit 104 responds to the request for new creation of the survey program and the display unit 104 responds to the request for new creation. An input screen 450 is displayed on 102.

  As described above, the survey program created on the input screen 450 can be displayed on the survey list screen 530 as a survey list, and can be managed centrally. The survey list screen 530 corresponds to the registration unit 202 and the program providing unit 206 of the program providing apparatus 200. The survey list includes a survey ID 534, a survey name 536, a creation date 538, a situation 540, and an operation menu 542 for each survey program. Examples of the operation menu 542 include an edit button 544, an operation button 546, a copy button 548, and a delete button 550. The program generation apparatus 100 can further include a processing unit (not shown) that accepts pressing of these various buttons via the operation unit 108 and performs each process. For example, when the operation button 546 of the survey program arbitrarily selected by the user is accepted, a later-described survey operation screen is displayed on the display unit 102, and various information on the selected survey program can be confirmed.

  FIG. 13 is a diagram illustrating an example of a survey operation screen 560 displayed when the operation button 546 is pressed on the survey list screen 530 of FIG. 12 in the survey system 10 of the present embodiment. FIG. 13 shows a case where an investigation program whose status 540 in FIG. 12 is “unpublished” is selected. The survey operation screen 560 includes a disclosure button 562 and an application creation button 564. In the survey operation screen 560, the survey operation information of the survey program includes statuses such as “public” and “unpublished”, release date, survey release name, release target, release end date, application name, and application update date. Further, the survey operation screen 560 includes a survey ID, survey name, data transmission URL, creator name, creation date, update date, etc. as survey program survey information. The survey ID, survey name, data transmission URL, and the like are information input in the various information input area 460 of FIG. 5 when the survey program is created.

  By accepting the pressing of the application creation button 564, the table access program generation unit 144 of the generation unit 112 in FIG. 7 generates a table access program. Also, by accepting the press of the release button 562, the program providing unit 206 of the program providing apparatus 200 in FIG. 8 makes the terminal apparatus 50 public so that the investigation program can be downloaded from the first network 12.

  FIG. 14 is a diagram showing an example of a survey operation screen 570 for a survey program being released. The data information of the survey program being disclosed includes the file name of the compressed file of the response data, its update date, and the SAS program (table access program). As described above, various types of information regarding each survey program can be confirmed on the survey operation screen 560 and the survey operation screen 570, and operations such as editing can be performed.

  As described above, according to the investigation system 10 of the present embodiment, the data collection program that forms the input interface for inputting data, and the predetermined data collected by the user terminal executing the data collection program A table generation program for generating a table for storing data in the database can be automatically generated. As a result, the data collection program and the table generation program are automatically generated only by the user inputting the parameters for forming the data collection program.

  That is, the user can generate a data collection program and a table generation program without directly inputting source code without requiring advanced program design techniques and knowledge. As a result, a data collection system that can perform everything from data input to collection, storage, and analysis can be easily provided. Further, since each program is automatically generated, debugging of the program becomes unnecessary as compared with creation of source code manually input by a programmer, and the number of man-hours for program creation can be greatly reduced.

  As mentioned above, although embodiment of this invention was described with reference to drawings, these are the illustrations of this invention, Various structures other than the above are also employable.

  For example, in the above-described embodiment, the investigation program is described as an example. However, not only the investigation program but also various programs such as a questionnaire and a quiz may be used.

It is a schematic block diagram which shows the structure of the investigation system which concerns on embodiment of this invention. In the investigation system of FIG. 1, it is a figure which shows an example of the data format of the investigation result transmitted from a terminal device. It is a figure which shows an example of the transition of the work screen displayed on the display part of the terminal device of the investigation system of FIG. It is a functional block diagram which shows the structure of the program generation apparatus of FIG. It is a figure which shows an example of the input screen displayed on the display part of the program generator of FIG. FIG. 5 is a diagram illustrating an example of a data structure of a parameter file output from a parameter management unit of the program generation device of FIG. 4 to a reception unit. It is a functional block diagram which shows the structure of the production | generation part of the program production | generation apparatus of FIG. It is a functional block diagram which shows the structure of the program provision apparatus of FIG. It is a flowchart which shows an example of operation | movement of the investigation system of this embodiment. It is a figure which shows an example of the source code of a table access program. It is a figure which shows the continuation of an example of the source code of the table access program of FIG. It is a figure which shows an example of the investigation list screen for creating and editing a some investigation program in the investigation system of FIG. In the investigation system of this embodiment, it is a figure which shows an example of the investigation operation screen displayed when the operation button is pressed in the investigation list screen of FIG. It is a figure which shows an example of the investigation operation screen of the investigation program currently open | released.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Investigation system 12 1st network 14 Base station 16 2nd network 18 3rd network 50 Terminal device 52 Display part 54 Operation part 100 Program generation apparatus 102 Display part 104 Display processing part 108 Operation part 109 Parameter management part 110 Reception part 112 Generation Unit 114 compiling unit 118 storage processing unit 124 input screen information generation unit 126 content storage unit 128 model storage unit 130 basic function storage unit 134 execution instruction unit 136 interface unit 138 interface unit 140 survey program generation unit 142 table generation program generation unit 144 Table access program generation unit 146 Survey ID assigning unit 150 Parameter file 190 Survey result 200 Program providing device 202 Registration unit 204 Program storage unit 206 Program provision Unit 220 Collection Device 300 Analysis Device 320 Database Server 340 Survey Data Database 400 Work Screen 450 Input Screen 500 Table Access Program 530 Survey List Screen 560 Survey Operation Screen 570 Survey Operation Screen

Claims (12)

A user terminal that conducts a survey based on a predetermined survey content including a plurality of survey items and transmits a survey result ;
A collection device for collecting the survey results transmitted from the user terminal via a network;
A database for storing the investigation results collected by the collection device;
A database server for accumulating the survey results received from the collection device in the database;
The user for realizing a function of forming an input interface for inputting the survey result to the user terminal and transmitting the survey result input via the input interface using the user terminal to the collection device A program generation device for generating a data collection program executable by the terminal;
A data collection system comprising:
The user terminal has a display unit that displays a work screen on which a plurality of input interfaces for inputting answers to the plurality of survey items of the predetermined survey content are formed when the data collection program is executed. ,
The program generation device further generates a table generation program for generating in the database a data table having a data structure corresponding to the survey item of the data collection program,
The program generation device includes:
A screen display unit for displaying a screen for forming the data collection program ;
When the user terminal executes the data collection program, on the work screen displayed on the display unit of the user terminal to display information indicating the contents of the plurality of investigation items of the predetermined investigation contents A plurality of survey item instruction areas, and information necessary for forming components for forming a survey result input area in which the plurality of input interfaces for inputting answers to the plurality of survey items are formed. Component setting area to be input by the user and accepted as a parameter, used when adding the survey item to the work screen, and suitable for the survey item to be added to the work screen from among a plurality of types of the component Allowing the user to select a type of the component and before the selected type A component addition operation button group for receiving an instruction to add a component, and an instruction to generate source code using information necessary for forming the component corresponding to the type, which is input by the user's operation Information for forming an input screen having a generation button for generating the information, and each time the component addition operation button group is operated, information necessary for forming the component corresponding to the selected type is generated. An input screen information generating unit that generates information for forming the input screen in which the component setting areas for receiving as a parameter are input by a user;
A plurality of components for inputting a plurality of parameters for forming a plurality of components suitable for the plurality of survey items on the work screen based on the information generated by the input screen information generation unit A display processing unit for displaying the input screen in which a setting area is formed on the screen display unit;
When the information input by the user operation via the input screen displayed by the display processing unit is managed as a plurality of parameters for forming the work screen, and when the operation of the generation button is received, The plurality of parameters necessary for forming the plurality of components input to the plurality of component setting areas corresponding to the plurality of survey items formed on the input screen, the plurality of parameters corresponding to the plurality of components A parameter management unit that outputs in association with type information that identifies the type,
A reception unit that receives the plurality of parameters output from the parameter management unit ;
The program code for forming each of the components is associated with the type information for specifying the type of the component, and a plurality of types of templates with the parameters as arguments are used for the data collection program and the table generation A template storage for each program,
Corresponding to each type information of the plurality of components from the model storage unit based on each type information of the plurality of components corresponding to the plurality of survey items included in the plurality of parameters received by the receiving unit Selecting and combining a plurality of templates for the data collection program or the table generation program for forming each component to be configured, and setting the parameter in the argument of each template, the data collection program or Generating a source code for each of the table generating programs, and generating a source code completion notification when generating the source code;
When the source code of the data collection program is completed in the generation unit, the source code of the data collection program is compiled to automatically generate a data collection program executable by the user terminal , and the generation A compiling unit that compiles the source code of the table generation program to generate the table generation program when the source code of the table generation program is completed in a unit;
For each data collection program, an identifier assigning unit that assigns a program identifier for associating the data collection program with the data table and the table generation program;
A storage processing unit that outputs the data collection program generated by the compiling unit to the collection device via the network;
A first execution unit that transmits the table generation program generated by the compilation unit to the database server via the network, and instructs the execution of the table generation program;
Only including,
The collector is
A registration unit that receives the data collection program from the program generation device;
A program storage unit for storing the data collection program received by the registration unit;
In response to a request from a user terminal, a program providing unit that provides the data collection program stored in the program storage unit;
A data collection system comprising: a presentation unit that displays a plurality of data collection programs generated by the program generation device together with the program identifier and presents a list screen for centralized management . The data collection system according to claim 1,
The identifier assigning unit before Symbol program generation apparatus, when the first execution unit to generate the data tables in the database to perform the table generation program, to grant said program identifier to said data table,
The user terminal is
A second execution unit for executing the data collection program;
The second execution unit to execute the data collection program, when collecting the survey results, the collected data generator for generating a survey including the program identifier,
A transmission unit that transmits the survey result to the collection device via the network,
The collector is
A receiving unit for receiving the investigation result transmitted from the user terminal;
A data collection system comprising: a storage unit that accesses the database, acquires the program identifier from the survey result received by the receiving unit, and stores the survey result in the data table corresponding to the program identifier.   The data collection system according to claim 1 or 2,
  The list screen has a new creation button that, when pressed, accepts a request for new creation of the data collection program,
  When the pressing of the new creation button is accepted, the input screen is displayed on the screen display unit, the creation of the data collection program is started, and the data collection program created on the input screen is displayed on the list screen. Data collection system to display.   The data collection system according to any one of claims 1 to 3,
  The data collection system, wherein the list screen includes a status display field indicating whether the data collection program is being published or not published. The data collection system according to any one of claims 1 to 4 ,
An analysis device for analyzing the investigation results stored in the data table of the database;
The program generation device includes:
The analysis device executes, accesses the data table of the database, and further generates a table access program for reading the accumulated investigation results,
In the program generation device,
The template storage unit further associates the program code for forming each of the components with the type information specifying the type of the component, and as a plurality of types of templates using the parameters as arguments, Each for the table access program,
The generating unit is configured to receive the plurality of components from the model storage unit based on the type information of the plurality of components corresponding to the plurality of survey items included in the plurality of parameters received by the receiving unit. A source of the table access program by selecting and combining a plurality of templates for the table access program to form each component corresponding to each type information, and setting the parameter in the argument of each template When the code is generated and the source code is generated, a message to that effect is output as a source code completion notification.
The compiling unit automatically compiles the source code of the table access program when the source code of the table access program is completed by the generation unit, and automatically generates a table access program executable by the analysis apparatus. And
Before Symbol identifier assigning unit is configured for each data collection program, the data acquisition system to impart said program identifier to associate with the table access program and the data collection program. The data collection system according to claim 5 , wherein
The analysis device includes:
A third execution unit for executing the table access program;
When the third execution unit executes the table access program, it accesses the data table of the database using the program identifier as a key, reads the investigation result stored in the data table, A data file generator for generating a data file;
A data collection system comprising: an analysis unit that analyzes the investigation result stored in the data file.   The data collection system according to claim 5 or 6,
  The list screen has a plurality of operation buttons including an edit button, an operation button, a copy button, and a delete button for each data collection program,
  The program generation apparatus further includes a processing unit that performs each process when receiving a press of each operation button.   The data collection system according to claim 7,
  A data collection system in which an operation screen including information on the data collection program in which the operation button is pressed is displayed on the screen display unit when the operation button on the list screen is pressed.   The data collection system according to claim 8,
  When the data collection program is unpublished, the operation screen has a publish button for publishing the data collection program when pressed,
  A data collection system in which the program providing unit publishes the data collection program so that the user terminal can be downloaded when the release button is received.   The data collection system according to claim 8 or 9,
  When the data collection program is unpublished, the operation screen has an application creation button that causes the generation unit to generate the table access program when pressed.
  A data collection system in which the generation unit generates the table access program when receiving a press of the application creation button.   The data collection system according to any one of claims 8 to 10,
  When the data collection program is open to the public, the operation screen is a data collection system in which the investigation result or information on the table access program is included.   The data collection system according to any one of claims 1 to 11,
  A program providing apparatus including the registration unit, the program storage unit, the program providing unit, and the presentation unit;
  The program providing apparatus comprises:
    Storing the data collection program generated by the program generation device in the program storage unit;
    A data collection system that provides the user terminal with the data collection program via the network.

Images