JP2018005445A - Information processing device, method for controlling information processing device, and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a mechanism capable of simply creating a Web application which can display a graph on a screen in programming work for graphing list data in the Web application.SOLUTION: A Web application for using item definition managed by management means for managing item definition for defining items on a database to set display items of a graph, and displaying data on the database in a graph on the basis of the set display items is created. Thus, a Web application which can simply display a graph can be created.SELECTED DRAWING: Figure 4

Description

  The present invention relates to an information processing apparatus, a control method for the information processing apparatus, and a program.

  2. Description of the Related Art In recent years, business applications are rapidly becoming Web-based so that business can be performed without installing a special application on a client terminal. In such business application development sites, development tools that can easily create Web applications without programming are used to solve the shortage of development skills and the shortage of personnel. If such a development tool is used, even if the user does not have programming language knowledge, a web application can be automatically generated simply by defining basic design information using business / design know-how. Patent Document 1 discloses a mechanism that can automatically generate such a Web application.

JP, 2006-009423, A

  By the way, in such a Web application, data managed on the database can be displayed as a list screen on the Web screen, but there is a demand for confirming the data managed on such a database as a graph format. is there.

  However, in the past, in order to display a screen in the form of a graph in a Web application, a considerably complicated programming work by a developer has been required. In programming work to graph such list data, not only the direct values managed by the database but also the results calculated by the Web application may be referenced, so it is necessary to program in consideration of these. The load was quite large. Furthermore, if a specification change such as a change in calculation conditions occurs after generating a Web application that can also display a graph, the corresponding graph display program must be changed each time, resulting in a heavy load.

  In view of the above problems, an object of the present invention is to provide a mechanism that can easily generate a Web application that can display a graph on a screen.

  In order to achieve the above object, the present invention provides a management unit that manages an item definition that defines an item on a database, and a setting unit that sets a display item of a graph using the item definition managed by the management unit And a generation unit that generates a Web application in which data on the database is displayed in a graph based on the display item set by the setting unit.

  In this way, a mechanism is provided that can easily generate a Web application that can display a graph on a screen by providing a display item of a graph by using a pre-managed item definition. can do.

It is a figure which shows an example of the system configuration | structure of a web application automatic generation system (information processing system). It is a figure which shows the hardware constitutions of the terminal 101 for development, the server 102, and the terminal 103 for users. It is a figure for demonstrating the software structure of the terminal 101 for development. It is a figure for demonstrating the function structure of the terminal which produces | generates and operate | moves a Web application. It is a figure for demonstrating an example of a database definition. It is a figure for demonstrating an application definition. It is a figure for demonstrating an example of a data model definition. It is a figure for demonstrating an example of an input / output definition. (A) It is a figure explaining the item property of the input-output definition required when producing | generating a graph. (B) It is a figure which shows a mode that the kind of graph is selected from a selection list. (C) It is a figure which shows a mode that the data acquisition origin group of a graph is selected. It is a flowchart for demonstrating the flow at the time of producing | generating and displaying the selection list of FIG.9 (c). It is a figure explaining a mode that the series etc. of a graph are selected from a selection list. 12 is a flowchart for explaining a flow when the selection list of FIG. 11 is generated and displayed. It is a flowchart for demonstrating the flow at the time of producing | generating a web application automatically. 4 is an example of data managed on a database 452 of a server 450. It is an example of the list screen and graph produced | generated by the web application. It is a figure explaining the item property of the input-output definition required when producing | generating a graph. It is an example of the list screen and graph produced | generated by the web application.

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

  FIG. 1 is a diagram showing a system configuration of a Web application automatic generation system (hereinafter also referred to as an information processing system) in the present embodiment. In the Web application automatic generation system of the present invention, a development terminal 101, a server 102 (server device), and a user terminal 103 are mutually connected via a network 105 such as a LAN (Local Area Network) or a WAN (Wide Area Network). Is connected to enable data communication.

  A Web application is an application that can be used on a Web for a business application used in a company. Since a business application can be performed without installing a special application on a client terminal, it has been widely used in recent years. It has been. The Web application system of the present invention is a system that can be automatically generated without programming from requirement definition information that specifies such a Web application. By using such a system, business applications on the Web can be easily developed within each company even if development skills are insufficient.

  The development terminal 101 shown in FIG. 1 is installed with a development tool that is a terminal used by a developer when automatically generating a Web application (program) and automatically generates a program. The web application 451 (program) is generated by defining the requirements in advance on this terminal, reading the data into a development tool, and performing automatic generation processing.

  The server 102 is used to hold and operate a Web application (program) generated by the development terminal 101 and provide a business application as a production environment. The user can access the WEB application 451 (program) via the user terminal 103 and use the business application. Data generated using the Web application is stored in the database 452.

  The user terminal 103 is generally a terminal used by a user who uses a business application in a production environment. By connecting to the server 102 using the terminal, a Web application can be used.

  FIG. 2 is a diagram illustrating a hardware configuration of the development terminal 101, the server 102, and the user terminal 103.

  The CPU 201 comprehensively controls each device and controller connected to the system bus 204.

  The ROM 202 or the external memory 211 (storage means) includes a BIOS (Basic Input / Output System) or an operating system program (hereinafter referred to as OS), a development terminal 101, a server 102, and a user terminal. Various programs to be described later required for realizing the functions executed by the program 103 are stored. The RAM 203 functions as a main memory, work area, and the like for the CPU 201.

  The CPU 201 implements various operations by loading a program necessary for execution of processing into the RAM 203 and executing the program.

  An input controller (input C) 205 controls input from an input device 209 such as a keyboard or a pointing device such as a mouse (not shown).

  A video controller (VC) 206 controls display on a display device such as the display 210. The type of the display device is assumed to be a CRT or a liquid crystal display, but is not limited thereto.

  The memory controller (MC) 207 is an adapter to a hard disk (HD), flexible disk (FD) or PCMCIA card slot for storing boot programs, browser software, various applications, font data, user files, editing files, various data, and the like. Controls access to an external memory 211 such as a card-type memory connected via the.

  A communication I / F controller (communication I / FC) 208 is connected to and communicates with an external device via a network, and executes communication control processing in the network. For example, Internet communication using TCP / IP is possible.

  Note that the CPU 201 enables display on the display 210 by executing outline font rasterization processing on a display information area in the RAM 203, for example. Further, the CPU 201 enables a user instruction with a mouse cursor (not shown) on the display 210.

  Various programs used by the development terminal 101, the server 102, and the user terminal 103 of the present invention to execute various processes to be described later are recorded in the external memory 211 and loaded into the RAM 203 as necessary. As a result, it can be executed by the CPU 201.

  Furthermore, definition files and various information tables used by the program according to the present invention are stored in the external memory 211.

FIG. 3 is an example of a block diagram illustrating a software configuration of the present embodiment.
The definition information management unit 301 is a functional unit that stores and manages definition information such as input / output definitions that define items used when generating a Web application.

  The graph display condition selection unit 302 is a functional unit that extracts and selects definition information that can be used as a graph display condition from definition information already managed by the definition information management unit 301.

  The graph display condition receiving unit 303 is a functional unit that receives any of the definition information extracted by the graph display condition selecting unit 302 from the user as a display condition.

  The graph display condition setting unit 304 is a functional unit that sets the display condition received by the graph display condition receiving unit 303 as a graph display condition.

  The application generation unit 305 is a functional unit that generates a Web application using the input / output definition managed by the definition information management unit 301 and the graph display condition set by the graph display condition setting unit 304.

  FIG. 4 is a diagram for explaining the configuration of the Web application automatic generation system and the functional configuration of the generated application and the like. The development terminal 101 includes a repository definition unit (Web application definition unit) 400, a Web application generation unit 410, a graph image output code generation unit 430, and a source code compilation unit 440.

  The repository definition unit 400 creates a database definition 401, a data model definition 403, an input / output definition 404, a business process definition 405, a graph item definition 406, and any of these definition files when generating a Web application. And an application definition 402 for setting whether to use.

  The database definition 401 can define settings of a server accessed by the Web application. The data model definition 403 is information defined as schema information. The business process definition 405 is information for defining a business flow. The graph item definition 406 is information that defines which definition is used as a graph axis or value when a graph is generated.

  The Web application generation unit 410 includes a Web application base code generation unit 420 for displaying a list screen or the like on the Web application, and a graph image output code generation unit 430 for displaying a graph on the Web application. ing.

  The web application base code generation unit 420 analyzes a repository definition analysis unit 421 that analyzes definition information of the repository definition unit 400, and a web application code generation unit 422 that generates a code based on a result analyzed by the repository definition analysis unit 421. And have.

  The graph image output code generation unit 430 includes a graph definition item analysis unit 431, an SQL execution code generation unit 432, a data processing code generation unit 433, a graph aggregation code generation unit 434, and a graph imaging code generation unit 435. Have.

  The graph definition item analysis unit 431 analyzes information defined in the graph item definition 406 of the repository definition unit 400.

  As a result of the analysis by the graph definition item analysis unit 431, the SQL execution code generation unit 432 generates an SQL execution code for acquiring data from the database when the database manages the data to be displayed as a graph. To do.

  As a result of the analysis by the graph definition item analysis unit 431, the data processing code generation unit 433 is not only the data managed by the database but also the result data calculated by the screen. Generate code to process the data. Specifically, a code for processing data by calculating using a processing formula defined in an input / output definition described later is generated.

  The graph tabulation code generation unit 434 generates a code for tabulating acquired data after acquiring data necessary for graph display using the codes generated by the SQL execution code generation unit 432 and the data processing code generation unit 433.

  The graph imaging code generation unit 435 generates a code that displays data aggregated with the code generated by the graph aggregation code generation unit 434 as a graph or a table.

  The source code compiling unit 440 compiles the codes generated by the Web application base code generation unit 420 and the graph image output code generation unit 430, generates a Web application, and outputs it.

  The server 102 holds the Web application 451 generated by the source code compiling unit 440 of the development terminal 101, performs processing in response to a request from the user terminal 103, and input data input from the user terminal 103. Are stored in the database 452.

(Web application automatic generation processing)
Next, a flow when a developer automatically generates a Web application on the development terminal 101 will be described. 5 to 8 show examples of definitions preset by the developer such as the application definition 402, the data model definition 403, and the input / output definition 404 stored in the repository definition unit 400 of FIG.

  FIG. 5 shows a database definition 401 that stores settings of servers accessed by the Web application. As shown in FIG. 5, the database definition includes the server 102 code 501, server name 502, connection URL information 503, server type 504, database name 505, and user name required when the application accesses the database. A password 507 and a password 507 are defined.

  FIG. 6A illustrates an application definition 402 that defines an input / output definition used when generating a Web application. The repository definition unit can manage a plurality of application definitions 402, but a code 601 and an application name 602 can be set for each application.

  Further, the application definition 402 is set to an input / output definition to which each code belongs, as shown in the belonging definition setting screen of FIG. On the affiliation definition setting screen 610, an input / output list 611, an affiliation input / output list 612, an add button 614, and a delete button 615 are displayed.

  The input / output list 611 displays all input / output codes of the input / output definition 404 stored in the project. The user can select any desired number of input / output codes and press the add button 614 to be assigned to the application code as belonging input / output. When the addition process is performed, the input / output code is displayed in the belonging input / output list 612. The user can also remove the affiliation by selecting the input / output code displayed in the affiliation input / output list 612 and pressing the delete button 615.

  FIG. 7 shows a data model definition 403 defined as schema information. As shown in FIG. 7A, each data model definition is managed with a code 701 and a name 702, and detailed definitions are also defined. For example, in the code “STORE_BY_MONTH_SALES”, the data model definition shown in FIG. 7B is defined in detail.

  In FIG. 7B, as items received on the database, an item code 711, an item name 712, an item 713 for setting whether to allow NULL, a number of digits 714, a data type 715, and the like are defined.

  The item code 711 is a code that uniquely identifies the data model item in the data model. A name 712 is a name arbitrarily set by the user for the data model item. This is set so that the user can easily specify the data model item. An item 713 is an item for setting whether to allow the data registered in the data model item to be empty. The number of digits 714 sets the number of digits of data that can be registered in the data model item. The data type 715 is an item for setting the data type of the data model item. Specify data type such as character, number, date, etc. In this example, data model items from “STORE_ID” to “EVENT” are defined for the data model “STORE_BY_MONTH_SALES”. Each item defined here matches the column name of the database table to which the Web application is connected.

  FIG. 8 shows an input / output definition 404 of each display item arranged on the Web screen. The items set here are displayed on the display screen of the user terminal 103 and used as a screen used by the user in the production environment. As shown in FIG. 8A, each input / output definition is managed by assigning a code 801, a name 802, an input / output type 803, and the like, and a data model 804 that is the target of the input / output definition is also set. Yes.

  “IO” of the input / output type 803 selected in FIG. 8A is a type indicating an input / output screen. In addition to this, “MENU” indicating that it is a menu screen or a user instruction is accepted. “DIALOG” indicating a dialog screen, “EXPORT” indicating an export screen, “IMPORT” indicating an import screen, “MATRIX” indicating a matrix screen, and a form printing screen Various input / output types such as “PRINT_FILE” indicating “mobile phone” and “MOBILE” indicating a mobile terminal screen can be defined.

  Further, the input / output definition can define detailed items, and as shown in FIG. 8B, the item type 810, the item code 811, the name 812, the display 813, the level 814, the processing formula 815, and the transition destination. A next input / output 816 (screen information), a data model code 817, and a data model item code 818 are defined.

  The item code 811 is a code (screen information) that uniquely identifies an item in the input / output definition. A name 812 is a name arbitrarily given by the user to the input / output item. Set for easy identification of input / output items. A display 813 is a setting for whether or not to display the defined input / output item on the screen. When it is not displayed, it is not displayed on the screen, and information is held as hidden data. The next input / output 816 sets an input / output code that transitions after the button is pressed for an input / output item whose item type is set to action. That is, a transition from one screen to another screen is defined. The processing formula 815 sets a processing formula used when other input / output items are processed into the input / output items. In the example of FIG. 8B, the item code “COLINS_DATA_ITEM” is an item code that is processed by converting the value of the item code “CLOSES_DATA” into a character string, and the item code “MONTHS_AND_YEARS” This is an item code to be processed and processed to output a part of the character string output from “CLOSING_DATA_ITEM”.

  Next input / output 816 is parameter information that is passed simultaneously with screen transition after the button is pressed for an input / output item whose item type is set to action. The data model code 817 sets a data model code related to the input / output item. Similarly, the data model item code 818 sets a data model item code related to the input / output item.

  The item type “G group” represents a group item in which a level 814 indicating a hierarchy groups the lower item types. The example of FIG. 8B indicates that items from item codes “STORE_ID” to “EVENT” belong to the group “G”. In the present embodiment, the graph display condition can be set by selecting the item type “G group”. An item defined as an item type “IO input / output” is an input / output item (“field” for inputting data and displaying data). An item defined as the item type “A action” is an action item (a “button” that calls a process and changes a screen).

Next, the flow of setting the graph display conditions will be described with reference to FIGS.
FIG. 9A shows a state in which all input / output item properties 900 necessary for displaying a graph with the generated Web application are set. FIG. 9B is a diagram showing a state when the “graph type graph format” 911 is set. FIG. 9C is a diagram illustrating a state when the “data source group of the graphSource graph” 912 is set. FIG. 10 is a flowchart showing the flow of specifying items displayed in the selection list 930 displayed when setting the “data source group of graphSource graph” 912. FIG. 11 is a diagram illustrating a state when the “series of graphSeries graph” 913 is set. FIG. 12 is a flowchart showing a flow of specifying items displayed in the selection list 940 displayed when setting the “series of graphSeries graph” 913.

  The input / output item property 900 is provided so that a value 902 assigned to each property key 901 can be set. In “group Type list type” 910, by selecting GRAPH, the “G group” can be made a group for setting the display condition of the graph.

  The “graph type graph format” 911 can set items that can set the graph format. When the user selects an area having a value 902 corresponding to “graph Type graph format” 911, a selection list 920 is displayed. The user selects a desired graph format from the selection list, and is displayed in the Web application. The graph format can be specified. In the example shown in FIG. 9B, a vertical bar graph (BAR_VERTICAL), a horizontal bar graph (BAR_HORIZONTAL), a line graph (LINE), a pie chart (PIE), and a scatter diagram (SCATTER) are displayed in the selection list 920, and the user can A graph format can be selected from a selection list. The types of graph formats that can be selected from such a selection list 920 can be appropriately prepared in advance.

  The “data source group of graphSource graph” 912 can set an acquisition source group of data used for creating a graph. When the user selects an area having a value 902 corresponding to “data source group of graphSource graph” 912, a selection list 930 is displayed. By selecting a desired acquisition source group from the selection list, the user can It is possible to narrow down whether the acquisition source item is the display item of the graph. In the example shown in FIG. 9C, the selection list 930 displays “G store sales by month” and “BAR_VERTICAL column graph” in a selectable manner. Here, the group displayed so as to be selectable is an item for which “G group” is selected in the item type 810 shown in the input / output item list of FIG. That is, a group belonging to the input / output definition range to which the graph definition information belongs is displayed as selectable. If a plurality of input / output definitions belong to the application definition shown in FIG. 6, a group belonging to the range of the input / output definition to which the input / output definition belongs may be displayed as selectable.

  Next, a flow for generating and displaying the selection list 930 for selecting the “data source group of the graphSource graph” 912 will be described with reference to FIG. Such processing is realized by reading and executing a control program stored in the CPU 201 of the development terminal 101.

  In step S <b> 1001, the CPU 201 of the development terminal 101 determines whether the property key 901 corresponding to the area of the value 902 selected by the user is “graphSource graph data acquisition source group”. If it is determined in S1001 that the data source group of the graphSource graph is not determined, the process ends. If it is determined that the data source group of the graphSource graph is determined, the input / output item list is displayed. S1002 and S1003 are repeated for the number of defined input / output items.

  In S1002, the CPU 201 of the development terminal 101 is an item belonging to the group set in the “graphSource graph data acquisition source group” 912 and set in the input / output item list shown in FIG. 8B. It is determined whether the item type 810 is “G group”. If it is determined in S1002 that it is not “G group”, the process proceeds to determination of the next input / output item. If it is determined in S1002 that it is “G group”, the process proceeds to S1003.

  In step S <b> 1003, the CPU 201 of the development terminal 101 adds the input / output item to the selection list table provided on the memory as an option of the selection list 930 of “graphSource graph data acquisition source group”.

In S1004, the CPU 201 of the development terminal 101 generates and displays a selection list 930 based on the input / output items added as options.
Thereby, the user can select from a group related to the definition to which the graph belongs.

  The “series of graphSeries graph” 913 can set a series which is one of the display conditions of the graph. When the user selects an area having a value 902 corresponding to the “series of graphSeries graph” 913, a selection list 940 is displayed as shown in FIG. 11, and the user selects a desired item from the selection list 940. It is possible to set which item is a series of graphs. At this time, items belonging to the group selected in “data source group of graphSource graph” 912 are displayed in the selection list 940 so as to be selectable. When the group selected in the “data source group of graphSource graph” 912 is “G sales by store per month”, as shown in FIG. 8B, the item code “STORE_ID” belonging to the group is changed from “STORE_ID” to “ Items up to “EVENT” are displayed on the selection list 940 in a selectable manner.

  Further, although not shown in the figure, in the case of “graphItem graph item” 914 and “graphValue graph value” 915 which are display conditions of graphs other than “graphSeries graph series” 913, the “data source graph data source” Items belonging to the group selected in “Group” 912 are displayed as a selectable selection list 940.

  In the case of “value of graphValue graph” 915, items corresponding to the value are further extracted from the items belonging to the group selected in “data source group of graphSource graph” 913 and displayed as a selectable selection list. You may be made to do.

  Next, a flow of generating and displaying a selection list 940 for selecting settings such as “series of graphSeries graph” 913, “item of graphItem graph” 914, and “value of graphValue graph” 915 will be described with reference to FIG. Such processing is realized by reading and executing a control program stored in the CPU 201 of the development terminal 101.

  In step S1201, the CPU 201 of the development terminal 101 determines whether the property key 901 corresponding to the value 902 area selected by the user is a graph display item. Specifically, it is determined whether the property key is “graphSeries”, “graphItem”, or “graphValue”. If it is not determined in S1201 that the item is a graph display item, the process ends. If it is determined that the item is a graph display item, the number of input / output items defined in the input / output item list is the same. S1202 and S1203 are repeated.

  In S1202, the CPU 201 of the development terminal 101 is an item belonging to the group set in the “data source group of graphSource graph” 912 by the CPU 201 of the development terminal 101, and is shown in FIG. It is determined whether the item type 810 set in the input / output item list is “IO input / output”, “I input”, or “O output”. If it is determined in S1202 that it is not “IO input / output”, “I input”, or “O output”, the process proceeds to determination of the next input / output item, and “IO input / output”, “I input”, If it is determined that the output is “O output”, then the flow shifts to S1203.

  In step S1203, the CPU 201 of the development terminal 101 adds the input / output item to the selection list table provided on the memory as an option of the selection list 940 used when setting the graph display condition.

In S1204, the CPU 201 of the development terminal 101 generates and displays a selection list 940 based on the input / output items added as options.
Thereby, the user can select the display condition of the graph from the item types related to the definition to which the graph belongs, and can easily perform the display setting of the graph. In other words, all the input / output item properties 900 necessary for displaying the graph, that is, the graph item definition 406 are set, and the requirements necessary for generating a Web application that can display the graph on the Web screen are prepared. It will be.

  FIG. 13 shows requirement definitions such as an application definition 402, a database definition 401, a data model definition 403, an input / output definition 404, a business process definition 405, a graph item definition 406, etc. stored in the repository definition unit 400 described so far. 6 is a flowchart for explaining a flow when a Web application is automatically generated after being performed. Such processing is realized by reading and executing a control program stored in the CPU 201 of the development terminal 101.

  First, in step S1301, the CPU 201 of the development terminal 101 receives a specification of an application definition 402 for generating a Web application from a user.

  In step S <b> 1302, the CPU 201 of the development terminal 101 reads the database definition 401 from the repository definition unit 400. In S1303, the data model definition 403 is read from the repository definition unit 400. In step S1304, the business process definition 405 is read from the repository definition unit 400. In step S 1305, the input / output definition 404 including the graph item definition 406 is read from the repository definition unit 400.

  Since such a definition is described in the XML format, in S1306, the CPU 201 of the development terminal 101 functions as the repository definition analysis unit 421 and the graph definition item analysis unit 431, analyzes the structure of the XML file, and performs the necessary analysis. Save the definition as object data in memory.

  In step S1307, the CPU 201 of the development terminal 101 reads a preset source code template. In S1308, the CPU 201 of the development terminal 101 functions as the Web application code generation unit 422, the SQL execution code generation unit 432, the data processing code generation unit 433, the graph totalization code generation unit 434, and the graph imaging code generation unit 435. In step S1306, the definition data saved in the memory is embedded in the source code template, and a source code file, that is, a web application that can display a graph and a list screen on the web screen is generated.

  As described above, a Web application is automatically generated by using a predefined requirement definition and source code. The developer stores the Web application generated in this manner in the server 102 and ends the business application development work.

  Next, an example of a Web screen displayed by the generated Web application will be described with reference to FIGS. 14 and 15. FIG. 14 is an example of data stored in the database 452. FIG. 15 is an example of a Web screen displayed in the case of the data of FIG. 14, and a data list screen 1500 and a graph 1510 are displayed based on the input / output definitions shown in FIGS. 8 and 9A. It shows how it is. When the data on the database 452 is updated, the data displayed on the Web screen is also updated.

  Store ID 1501, store name 1502, closing date 1503, year / month (text) 1504, year / month 1505, sales 1506, and number of events 1507 on the list screen 1500 in FIG. 15 are defined in the input / output item list in FIG. 8B. The name corresponding to the current name 812 is displayed. The data actually reflected is the data of FIG. 14, the STORE_ID 1401 data registered in the database is displayed as the store ID 1501 data, the STORE_NAME 1402 data is displayed as the store name 1502, and the CLOSEING_DATE 1403 data is tightened. The data of the day 1503 is displayed, the data of PROCEEDS 1404 is displayed as the data of sales 1506, and the data of the EVENT 1405 is displayed as data of the number of events 1507. Year / month (text) 1504 and year / month 1505 display items obtained by processing other data based on the processing conditions set by the processing formula 815.

  Further, a series 1511 (store name), an item 1512 (year / month), and a value 1513 (sales) of the graph 1510 are displayed in the graph display condition (graph series / graph item / value) in the input / output item property 900 of FIG. Based on the setting (graph value).

  In other words, in this embodiment, since the developer can create a list screen and use the managed input / output definitions to set the graph display conditions, the Web can be displayed easily. An application can be generated. In addition, by setting the graph display conditions in this way, reprogramming work to display the graph even if there is a change in the I / O definition settings or processing formulas to generate the list screen on the way Even if you do not, you can respond just by checking the input / output definition of the diversion destination.

  It should be noted that an item “graphShowData graph data display” 915 for displaying the data itself used for graph output as shown in FIG. 16 in all the input / output item properties 900 necessary for displaying the graph of FIG. 9A. May be added. An example of the graph displayed on the Web screen in this case is shown in FIG. In this example, when the user browsing the Web screen selects the button 1520 for instructing data display or hangs over the pointer, only the data used for the graph display is displayed on the list screen 1530. Here, the graph series 1511 is displayed as the vertical item 1521 of the list screen 1530, the graph item 1512 is displayed as the horizontal item 1522 of the list screen 1530, and the graph value 1513 is displayed as the value 1523 of the list screen 1530.

  Thereby, the user who is browsing the Web screen can easily confirm what the data generating the graph is without searching for the data generating the graph on the list screen 1500.

  In the present embodiment, the example in which the list screen 1500 and the graph 1510 are displayed at the same time has been described. However, the present embodiment is also applied to the case of generating a Web application that can display a Web screen on which only the graph 1510 is displayed. It is possible to apply.

  The present invention can be implemented as a system, apparatus, method, program, storage medium, or the like, and can be applied to a system including a plurality of devices. You may apply to the apparatus which consists of one apparatus.

  Note that the present invention includes a software program that implements the functions of the above-described embodiments directly or remotely from a system or apparatus. The present invention also includes a case where the information processing apparatus of the system or apparatus is achieved by reading and executing the supplied program code.

  Therefore, the program code itself installed in the information processing apparatus implements the present invention in order to realize (executable) the functional processing of the present invention in the information processing apparatus. In other words, the present invention includes a computer program itself for realizing the functional processing of the present invention.

  In that case, as long as it has the function of a program, it may be in the form of object code, a program executed by an interpreter, script data supplied to the OS, and the like.

  Examples of the recording medium for supplying the program include a flexible disk, hard disk, optical disk, magneto-optical disk, MO, CD-ROM, CD-R, and CD-RW. In addition, there are magnetic tape, nonvolatile memory card, ROM, DVD (DVD-ROM, DVD-R), and the like.

  As another program supply method, a browser on a client computer is used to connect to an Internet home page. The computer program itself of the present invention or a compressed file including an automatic installation function can be downloaded from the homepage by downloading it to a recording medium such as a hard disk.

  It can also be realized by dividing the program code constituting the program of the present invention into a plurality of files and downloading each file from a different homepage. That is, the present invention also includes a WWW server that allows a plurality of users to download a program file for realizing the functional processing of the present invention with an information processing apparatus.

  In addition, the program of the present invention is encrypted, stored in a storage medium such as a CD-ROM, distributed to users, and key information for decryption is downloaded from a homepage via the Internet to users who have cleared predetermined conditions. Let The downloaded key information can be used to execute the encrypted program and install it in the information processing apparatus.

  Further, the functions of the above-described embodiment are realized by the information processing apparatus executing the read program. In addition, based on the instructions of the program, the OS or the like operating on the information processing apparatus performs part or all of the actual processing, and the functions of the above-described embodiments can be realized by the processing.

  Further, the program read from the recording medium is written in a memory provided in a function expansion board inserted into the information processing apparatus or a function expansion unit connected to the information processing apparatus. Thereafter, the CPU of the function expansion board or function expansion unit performs part or all of the actual processing based on the instructions of the program, and the functions of the above-described embodiments are realized by the processing.

  The above-described embodiments are merely examples of implementation in carrying out the present invention, and the technical scope of the present invention should not be construed as being limited thereto. That is, the present invention can be implemented in various forms without departing from the technical idea or the main features thereof.

101 Development terminal 102 Server 103 User terminal 451 Web application

Claims (8)

A management means for managing item definitions used when displaying data on a database on a Web screen;
Setting means for setting a display item used when displaying a graph on a Web screen using an item definition managed by the management means;
Generating means for generating a Web application in which data on the database is displayed in a graph based on the display items set by the setting means;
An information processing apparatus comprising: A selection means capable of selecting a display item of the graph from a selection list displayed based on an item definition managed by the management means;
The information processing apparatus according to claim 1, wherein the setting unit sets an item definition selected from the selection list as a display item of the graph.   The generation unit generates a Web application that displays the graph together with a list screen that displays a list of data on the database based on an item definition managed by the management unit. 2. The information processing apparatus according to 2. The item definitions managed by the management means include processing formulas for processing other item definitions,
4. The information processing apparatus according to claim 1, wherein the setting unit can also set an item definition obtained by processing data on the database by the processing formula as a display item of the graph. 5.   5. The Web application is generated so that the generation unit displays a list screen of data on the database based on an item set as a display item of the graph. The information processing apparatus according to any one of claims.   The information processing apparatus according to claim 1, wherein the graph displayed by the Web application is updated as data on the database is updated. A control method for an information processing apparatus comprising a management means for managing item definitions for defining items on a database,
Using the item definition managed by the management means, a setting step for setting the display item of the graph,
Based on the display items set in the setting step, a generation step for generating a Web application in which data on the database is displayed in a graph;
A control method comprising: A program that can be installed in an information processing apparatus having a management means for managing item definitions for defining items on a database,
The information processing apparatus;
Using the item definition managed by the management means, setting means for setting the display items of the graph,
Generating means for generating a Web application in which data on the database is displayed in a graph based on the display items set by the setting means;
A program characterized by functioning as