JP2008276462A - Data file creation management system and data file creation management device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable a user to read his or her desired data from a plurality of servers by a simple designation operation using terminal equipment without affecting a network, and to quickly prepare a data file for operation analysis by freely combining them, and to consolidate the data of a plurality of servers by one terminal equipment, and to uniquely update the terminal equipment, and to prevent any other costs. <P>SOLUTION: In a WEB server 32 connected to servers 12-1 to 12-n and personal computer terminal equipment 34-1, data acquisition conditions obtained by arbitrarily combining the database names, table names, and item names of DB11-1 to 11-n of the respective severs are embedded in a relational database operation language sentence to prepare a data acquisition instruction, and data are acquired from the corresponding DB11-1 through a DB connection engine selected in response to this instruction, and the acquired data are combined to prepare a data file, and output to the terminal equipment 34-1 for display. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention sets a data acquisition condition such as a period specified by a user, a maximum value and a minimum value by a terminal device such as a personal computer (PC), and operates a production amount of a factory in accordance with the set contents. The present invention relates to a data file creation management system and a data file creation management device for reading necessary data from a database storing data related to the above into a terminal device and creating a data file for operation analysis.

Conventionally, there is a data file creation management system 10 shown in FIG. 17, for example, as a system for creating and managing data files by reading necessary data from a database.
The data file creation management system 10 includes a plurality of servers 12-1, each having a dedicated DB (database) 11-1, 11-2, 11-3,. 12-2, 12-3,..., 12-n, and personal computer terminal devices 14-1, 14 connected to the servers 12-1 to 12-n via the communication network 13 in a one-to-one relationship. , 14-3,..., 14-n.

Each personal computer terminal device 14-1 to 14-n has a DB connection engine 15-1, 15-2, 15-3,..., 15-n for connecting to a dedicated server DB on a one-to-one basis. , 16-n are provided with data file creation devices 16-1, 16-2, 16-3,..., 16-n for creating data files based on data acquired from the DB of the dedicated server.
The personal computer terminal devices 14-1 to 14-n may be installed in different places other than the same place. In this example, the personal computer terminal devices 14-1 and 14-2 are installed in the office 17-1. The personal computer terminal devices 14-3, ..., 14-n are installed in the office 17-n. Further, printers 18-1, 18-n connected to the network 13 are also installed in the offices 17-1, 17-n, and data files created by the personal computer terminal devices 14-1 to 14-n. 19-1, 19-2, 19-3,..., 19-n are printed out.

By operating the desired personal computer terminal devices 14-1 to 14-n by the data file creation management system 10 having such a configuration, the DBs 11-1 to 11-11 of the predetermined servers 12-1 to 12-n are operated. The necessary data can be read from -n to create a desired data file, which can be displayed on the screen or printed out.
As this type of prior art, for example, there is an apparatus described in Patent Document 1. This feature is intended to provide a user-friendly display without requiring a complicated and troublesome procedure when processing form data to generate a form. To achieve this, in a form server connected to a client terminal device via a network and storing form data for display as a form, it is included in an area selected by the user of the client terminal device from the form data The area data is extracted, and the extracted area data is repeatedly used an arbitrary number of times to create an export record.
JP 2005-190436 A

By the way, according to the above-mentioned patent document 1, the form data stored in the form server can be read into the terminal device, and a desired data file can be created and output by freely combining them. In other words, it is possible to create a data file by combining only the form data previously formed into a form.
However, since data other than the form data on the form server cannot be selected, the necessary data is read into the terminal device from the server that stores all the data related to operations such as the production volume of the factory, and operations can be freely combined. There is a problem that a data file for analysis cannot be created.

Also, when reading the form data into the terminal device, a specific instruction operation is required for each form data. If there is a lot of form data to be read, it will take time to collect data and create a data file. There is a problem of adversely affecting the network.
Further, when there are a plurality of form servers, it is necessary to prepare a terminal device for each server, and the data of each server cannot be aggregated by one terminal device. That is, since one terminal device can acquire only the data of one server associated therewith, the data output for each server cannot be centrally managed. For this reason, when the installation locations of each terminal device are distributed, it takes time and effort to collect data from each terminal device, or when comparing the data of each server efficiently. There is a problem that you can not go.

  Further, when creating a form by directly collecting data from the server DB at the terminal device, as described above, it is necessary to install a DB connection engine for connecting to the server DB on the terminal device. Since the DB connection engine may depend on the model of the terminal device and the OS (Operating System), the desired terminal device cannot be updated alone as necessary. To explain further, even when one terminal device is updated, the hardware and software of necessary parts must be updated while maintaining the consistency of the entire system, and there is an extra cost besides updating the terminal device. There is a problem that it occurs.

  The present invention has been made in view of such problems, and allows a user to read desired data from a plurality of servers without adversely affecting the network with a simple designation operation on a terminal device, and freely combine them. The data file for operation analysis can be created in a short time, the data of multiple servers can be centrally managed by one terminal device, and the terminal device can be updated independently. It is an object of the present invention to provide a data file creation management system and a data file creation management device that can eliminate the occurrence of extra costs.

  To achieve the above object, a data file creation management system according to claim 1 of the present invention includes a plurality of servers having a database storing data, and communication information connected to these servers via a communication network. In a data file creation management system having a plurality of terminal devices for processing and acquiring data from a database of a server by these terminal devices to create a data file, the terminal device is subjected to information reception browsing processing A WEB browser and spreadsheet software for displaying, editing, and managing data received via the network by the processing of the WEB browser, and the WEB of the terminal device is provided in the network between the server and the terminal device. Connect a WEB server that transmits data to the terminal device according to the browser command, A definition information sharing folder having a master definition file in which the database names of the plurality of servers and the table names of the data tables existing in the database are registered, and the master server when connected from the terminal device. Reads data from the definition file and displays a list of database names, table names, and item names in the table on the terminal device, and is arbitrarily combined from the list contents on the displayed terminal device, and an arbitrary condition is designated for this. A screen setting processing unit that receives the acquired data acquisition conditions and requests data acquisition, and a plurality of DBs that are assigned one-to-one for each of the databases of the plurality of servers and that connect to only the assigned databases Connection engine and the data acquisition condition at the time of the data acquisition request are relational database. A data file creation processing unit that creates a data acquisition instruction by incorporating it into the operation language sentence, acquires data from the corresponding database via the DB connection engine selected according to the instruction, and creates a data file by incorporating this acquired data The terminal device receives the data file with the WEB browser, and edits and manages the data file with the spreadsheet software.

  According to this configuration, the database name of the acquisition destination, the table name, and the item name in the table are displayed in a list on the terminal device, and the user can arbitrarily combine the data desired to be acquired from the list contents on the displayed terminal device. In addition, it is possible to obtain desired data from multiple servers with a simple specification operation such as setting data acquisition conditions that specify arbitrary conditions (data acquisition period, maximum value, minimum value, range, arrangement order, grouping, etc.). Data files for operation analysis can be created in a short time by reading and combining them freely.

  In addition, since one terminal device can instruct a database of an arbitrary connection destination (connection destination instruction) and receive a data file from the database in the corresponding server by the terminal device, each terminal device can Server database data can be received and centrally managed. This makes it possible to easily collect data stored in the database of each server in any terminal device even when the installation locations of the terminal devices are distributed, and to compare and examine the data of each server. Can also be done easily.

  Further, the configuration in which data is collected from each server by one terminal device and data is created in this way is connected to one WEB server in the network, and each terminal device is represented as a standard WEB browser. Since it is realizable only by mounting calculation software, it is realizable at low cost. Furthermore, since it is not necessary to mount a DB connection engine for each terminal device as in the prior art, a desired terminal device can be independently updated as necessary. In this case, conventionally, when updating one terminal device, other necessary parts of the entire system had to be updated, and there was an extra cost other than the update of the terminal device. Since there is no occurrence, it can be realized at a lower cost.

  A data file creation management system according to claim 2 of the present invention is the data file creation management system according to claim 1, wherein the screen setting processing unit calculates the size of the data file based on the received information when the data acquisition condition is received. When the calculated size exceeds a preset upper limit value, a message requesting the terminal device to review the data acquisition condition is displayed. If the calculated size is equal to or smaller than the upper limit value, the data acquisition condition is displayed. And making a data acquisition request to the data file creation processing unit.

  According to this configuration, when the calculation size of the data file requested in the data acquisition condition exceeds a predetermined upper limit value, the data acquisition is not performed and the review of the acquisition condition is prompted again. There is a reduction effect. Therefore, a user can read desired data from a plurality of servers without adversely affecting the network with a simple designation operation on the terminal device, and can freely combine them to create a data file for operation analysis in a short time. it can.

The data file creation management system according to claim 3 of the present invention is the data file creation management system according to claim 1 or 2, wherein the data file creation processing unit has a size of data acquired from the database exceeding a predetermined upper limit value. A message for reviewing the data acquisition condition is displayed on the corresponding terminal device, and if the size of the acquired data is equal to or smaller than the upper limit value, the acquired data is incorporated to create a data file.
According to this configuration, when the size of acquired data from the database exceeds a predetermined upper limit value, subsequent data file creation and transmission to the terminal device are not performed, and the review of the acquisition conditions is prompted again. There is an effect of reducing work load and network load.

According to a fourth aspect of the present invention, in the data file creation management system according to any one of the first to third aspects, the data acquisition condition is registered in the definition information sharing folder as a macro that can be freely called. When the macro name is designated by the terminal device, the screen setting processing unit reads the macro definition file having the designated macro name from the definition information shared folder and obtains the contents thereof. It is characterized as a condition.
According to this configuration, it is possible to easily input data acquisition conditions.

  According to a fifth aspect of the present invention, there is provided a data file creation management apparatus comprising: a plurality of servers having a database storing data; and a WEB that is connected to these servers via a communication network and performs information reception browsing processing. A plurality of terminal devices having spreadsheet software that performs editing and management processing of data received and processed by the browser and the processing of the WEB browser, and a network between these terminal devices and a plurality of servers, and according to a command of the WEB browser In the data file creation management device having a Web server function for transmitting data to the corresponding terminal device, a master definition file in which the database names of the databases of the plurality of servers and the table names of the data tables existing in the databases are registered A definition information sharing folder, and the terminal device At the time of connection, data is read from the master definition file and displayed on the terminal device as a list of database names, table names, and item names in the table, and the displayed terminal device is arbitrarily combined from the list contents. A screen setting processing unit that receives a data acquisition condition in which an arbitrary condition is specified and makes a data acquisition request, and is assigned one by one to each database of the plurality of servers, and is connected only to the assigned database. A plurality of DB connection engines for processing, and a data acquisition instruction is created by incorporating the data acquisition conditions at the time of the data acquisition request into a relational database operation language sentence, and the corresponding database is selected via the DB connection engine selected according to the instruction. Data file that acquires data from and creates a data file by incorporating this acquired data And forming unit, characterized in that the created form file and a created form shared folder that receivable held by the WEB browser of the terminal device.

  According to this configuration, the database name of the acquisition destination, the table name, and the item name in the table are displayed in a list on the terminal device, and the user can arbitrarily combine the data desired to be acquired from the list contents on the displayed terminal device. In addition, it is possible to obtain desired data from multiple servers with a simple specification operation such as setting data acquisition conditions that specify arbitrary conditions (data acquisition period, maximum value, minimum value, range, arrangement order, grouping, etc.). Data files for operation analysis can be created in a short time by reading and combining them freely. In addition, the data of the database of each server can be received and centrally managed by one terminal device. Further, the configuration in which data is collected from each server by one terminal device and data is created in this way is connected to one WEB server in the network, and each terminal device is represented as a standard WEB browser. Since it is realizable only by mounting calculation software, it is realizable at low cost.

  The data file creation management device according to claim 6 of the present invention is the data file creation management device according to claim 5, wherein the screen setting processing unit calculates the size of the data file based on the received information when the data acquisition condition is received. When the calculated size exceeds a preset upper limit value, a message requesting the terminal device to review the data acquisition condition is displayed. If the calculated size is equal to or smaller than the upper limit value, the data acquisition condition is displayed. And making a data acquisition request to the data file creation processing unit.

  According to this configuration, when the calculation size of the data file requested in the data acquisition condition exceeds a predetermined upper limit value, the data acquisition is not performed and the review of the acquisition condition is prompted again. There is a reduction effect. Therefore, a user can read desired data from a plurality of servers without adversely affecting the network with a simple designation operation on the terminal device, and can freely combine them to create a data file for operation analysis in a short time. it can.

The data file creation management device according to claim 7 of the present invention is the data file creation management device according to claim 5 or 6, wherein the data file creation processing unit has a size of acquired data from the database exceeding a predetermined upper limit value. A message for reviewing the data acquisition condition is displayed on the corresponding terminal device, and if the size of the acquired data is equal to or smaller than the upper limit value, the acquired data is incorporated to create a data file.
According to this configuration, when the size of acquired data from the database exceeds a predetermined upper limit value, subsequent data file creation and transmission to the terminal device are not performed, and the review of the acquisition conditions is prompted again. There is an effect of reducing work load and network load.

According to claim 8 of the present invention, the data file creation management device according to any one of claims 5 to 7 registers the data acquisition condition in the definition information shared folder as a macro that can be freely called. When the macro name is designated by the terminal device, the screen setting processing unit reads the macro definition file having the designated macro name from the definition information shared folder and obtains the contents thereof. It is characterized as a condition.
According to this configuration, it is possible to easily input data acquisition conditions.

  As described above, according to the present invention, a user can read desired data from a plurality of servers without adversely affecting the network by a simple designation operation with a terminal device, and can freely combine these data for operation analysis. Files can be created in a short time, data from multiple servers can be centrally managed by a single terminal device, and the terminal device can be updated independently, resulting in additional costs. There is an effect that it can be eliminated.

Hereinafter, embodiments of the present invention will be described with reference to the drawings. However, parts corresponding to each other in all the drawings in this specification are denoted by the same reference numerals, and description of the overlapping parts will be omitted as appropriate.
FIG. 1 is a block diagram showing a configuration of a data file creation management system according to an embodiment of the present invention.
The data file creation management system 30 shown in FIG. 1 is different from the conventional data file creation management system 10 in that a WEB (World Wide Web) server 32 is provided on the network 13 as a data file creation management device that is a characteristic element of the present invention. FIG. 2 shows the personal computer terminal devices 34-1, 34-2, 34-3,..., 34-n that are connected and installed in the offices 17-1, 17-n and connected to the network 13. A web browser 41 and spreadsheet software 42 are provided. However, FIG. 2 shows the personal computer terminal device 34-1 as a representative of the personal computer terminal devices 34-1 to 34-n.

The WEB browser 41 is software that executes processing for transmitting / receiving data by connecting to the WEB server 32 via the network 13 and for instructing the user for that purpose.
The spreadsheet software 42 is software that performs processing for starting, editing, and printing the data file 43 downloaded from the WEB server 32.
The WEB server 32 is a computer that transmits and receives data via the WEB browser 41 and the network 13, and includes a macro management processing unit 51, a screen setting processing unit 52, a data file creation processing unit 53, and a data file output process. Unit 54, a plurality of DB connection engines 55-1 to 55-n, a definition information sharing folder 56, and a created data file sharing folder 57.

Each DB connection engine 55-1 to 55-n has a DB connection engine 55-1 assigned to the DB 11-1, ..., a DB connection engine 55-n assigned to the DB 11-n, and will be described in detail later. As described above, in response to an item name acquisition instruction or data acquisition instruction in the WEB server 32 corresponding to an operation input instruction of a personal computer terminal device (for example, 34-1), the personal computer terminal apparatus 34-1 is connected via the WEB server 32. And connect to the assigned DB 11-1.
In the definition information sharing folder 56, macro definition file groups 61A and 61B corresponding to a plurality of users A and B, a DB master definition file 62, and a table master definition file 63 are stored. The data file 43 is stored in the created data file sharing folder 57. The DB master definition file 62 and the table master definition file 63 constitute a master definition file.

  An example of the DB master definition file 62 is shown in FIG. In the DB master definition file 62, as the DB names of the respective DBs 11-1 to 11-n in which the operation data of the first to nth factories are individually stored, the factories 1, factories 2,. Factory n is registered, and further, table master 1, table master 2, and table master n are registered as file names of the table master definition file 63 corresponding to each DB 11-1 to 11-n to which the factory names are assigned. ing.

  Furthermore, as an example of the table master definition file 63, FIG. 4 shows the definition file 63-1 of the table master 1 described above. The definition file 63-1 of the table master 1 corresponds to the table master 1 defined at the head of the table master name of the DB master definition file 62 shown in FIG. In addition, table master names 2 and 3 are defined in the table master name of the same DB master definition file 62, but there are definition files (not shown) for the table masters 2 and 3 as well. To do. That is, the table master name of the DB master definition file 62 is the file name of the table master definition file 63.

Further, as shown in the definition file 63-1 of the table master 1 in FIG. 4, the contents of the table master definition file 63 are registered with a DB name and a table name (table name) existing in this DB. The table names to be registered are determined according to the user's request, but basically all table names are registered.
FIG. 5 shows a macro definition file 61C-1 of terminal information of the factory 1 as an example of the macro definition file. This is the macro definition file 61C-1 of the user C newly registered by pressing the new buttons 65a and 65b on the data acquisition condition setting screen 65 displayed on the personal computer terminal device 34-1 as shown in FIG. Yes, it is newly added to the definition information shared folder 56. This master definition file includes data of a process control name, a search column, a period condition, and other conditions.

  The macro is a general computer language, and is a function for registering a series of predetermined processes and calling and executing them later. More specifically, it is a function for automating the operation of application software, and is installed in spreadsheet software, word processing software, and the like. By using such a macro, a plurality of operations can be processed at a time. In this example, for each user, the DB name, table name, item name, and acquisition condition are stored as a macro.

  Returning to FIG. 2, the macro management processing unit 51 holds the macro user names stored in the macro definition file groups 61 </ b> A and 61 </ b> B in a folder, and is a data acquisition condition setting screen displayed on the personal computer terminal device 34-1. When a macro call operation is performed in 65, the macro corresponding to the user name being saved is read from the macro definition file groups 61A and 61B, and the DB name, table name, item name, and acquisition of the read macro are read. Processing for displaying the condition on the corresponding data acquisition condition setting screen 65 is performed.

  In addition, the macro management processing unit 51 performs processing for adding and deleting a corresponding user name and macro in response to an instruction to add or delete a macro by a user operation on the data acquisition condition setting screen 65. This deletion process is executed on the data acquisition condition setting screen 66 for the administrator displaying the macro deletion buttons 66c and 66d shown in FIG. 7 so that the macro and the user name are not deleted without permission. It can only be opened. In this deletion process, the user name folder stored in the macro management processing unit 51 is deleted, and the macro definition file group 61A corresponding to the deletion target user name held in the definition information sharing folder 56 is also deleted. , 61B are deleted.

  When the personal computer terminal device 34-1 connects to the WEB server 32 via the WEB browser 41, the screen setting processing unit 52 stores the DB master definition file 62 and the table master definition stored in the definition information shared folder 56. With reference to the file 63, the display information of the data acquisition condition setting screen 65 including the table name for each factory name (DB name) is transmitted to the personal computer terminal 34-1. In addition, when the connection destination DB name and the table name are specified on the data acquisition condition setting screen 65 displayed on the personal computer terminal device 34-1 by the transmission, an acquisition request for the item name of the specified table is sent to the data file. This is performed for the creation processing unit 53.

  When receiving an item name acquisition request from the screen setting processing unit 52, the data file creation processing unit 53 instructs the corresponding DB connection engines 55-1 to 55-n to acquire the item name of the specified table, and further When the item name of the specified table is acquired from the connection destination DB 11-1 to 11-n by the DB connection engine 55-1 to 55-n according to this instruction, this item name is notified to the screen setting processing unit 52. . The notified item name is transmitted from the screen setting processing unit 52 to the corresponding personal computer terminal device 34-1.

The screen setting processing unit 52 calculates the size of the data file based on the received information when receiving the table name, the item name, and the acquisition condition specified by the personal computer terminal device 34-1. When the calculated size exceeds the preset upper limit value, a message 71 for requesting a review of the conditions is displayed on the corresponding personal computer terminal device 34-1 as shown in FIG. If it is equal to or less than the upper limit value, a data acquisition request is sent to the data file creation processing unit 53.
When other macros are used, the screen setting processing unit 52 receives the DB name, table name, item name, and acquisition conditions registered in the macro called by the personal computer terminal 34-1 from the macro definition file groups 61A and 61B. Data acquisition request to the data file creation processing unit 53 based on the received information.

  In the case of any of these data acquisition requests, the data file creation processing unit 53 issues a data acquisition instruction to the corresponding DB connection engine 55-1 to 55-n, and after completion of data acquisition according to this instruction, the completion is performed. The data file output processing unit 54 is notified. Further, the acquired data is created as a file (data file), the size of the data file is confirmed, and when the preset upper limit value is exceeded, the corresponding personal computer terminal device 34 is passed through the screen setting processing unit 52. A message 72 for requesting a review of the conditions is displayed at -1, as shown in FIG. If the value is not more than the upper limit value, the previously created data file 43 is stored in the created data file shared folder 57.

  When the data file output processing unit 54 is notified of the completion of data acquisition from the data file creation processing unit 53, the data file output processing unit 54 transmits the display information of the data file download notification screen 73 shown in FIG. To do. When the download button 73a is clicked on the screen 73, the display information of the data file download determination screen 74 shown in FIG. 11 is selected as a screen for selecting whether to display or save the data file. It transmits to the apparatus 34-1.

  Here, when the open button 74a is clicked on the data file download determination screen 74 displayed on the personal computer terminal device 34-1, the data file 43 is downloaded from the created data file shared folder 57 by the spreadsheet software 42, and A data file list 75 is displayed as shown in FIG. When the save button 74b is clicked, the data file 43 is downloaded by the spreadsheet software 42 and stored in the designated save location. When the cancel button 74c is clicked, the display of the data file download determination screen 74 is ended.

Next, the operation when creating and managing the data file 43 by the data file creation and management system 30 having such a configuration will be described. However, DB11-1 to 11-n of each server 12-1 to 12-n includes a first factory in DB11-1, a second factory in DB11-2, a third factory in DB11-3, It is assumed that each information of the nth factory is stored in the DB 11-n.
First, the operation when a macro is not used will be described.

In step S1 indicated by a broken line arrow in FIG. 2, an initial operation for data file creation management by the user is performed in the personal computer terminal device 34-1, and after connection to the WEB server 32 via the WEB browser 41 accordingly. Assume that there is a connection to the WEB address of the display information on the data acquisition condition setting screen 65 of the screen setting processing unit 52.
In this case, in step S2, the screen setting processing unit 52 causes the DB master definition file 62 shown in FIG. 3 and the table master 1 of the factory 1 which is the DB name registered at the top of the file 62 to be shown in FIG. The definition file 63-1 of the table master 1 shown is read, and in step S3, the files 62 and 63-1 are transmitted to the personal computer terminal device 34-1 together with the display information of the data acquisition condition setting screen 65.

Then, the data acquisition condition setting screen 65 shown in FIG. 6 is displayed on the personal computer terminal device 34-1 and “factory 1” which is the top information of the DB master definition file 62 is displayed in the DB name frame 65e, and the table name “A table” which is the top information of the definition file 63-1 of the table master 1 is displayed in the frame 65f.
In the displayed data acquisition condition setting screen 65, when "A table" is selected in step S4, the items in the A table are sent from the screen setting processing unit 52 to the data file creation processing unit 53 in step S5. Request to get a list of names.

  In response to this item name acquisition request, the data file creation processing unit 53 incorporates information of “factory 1” as the connection destination DB and “A table” as the table name into the relational database operation language sentence. Based on the information, in step S6, an item name acquisition instruction is issued to the server 12-1 via the DB connection engine 55-1 corresponding to the connection destination DB “factory 1”. In response to this instruction, the item name “A table” is acquired from the DB 11-1 of the server 12-1 in step S 7, and notified to the screen setting processing unit 52 in step S 8.

  Upon receipt of this notification, the screen setting processing unit 52 transmits information of the list of item names of “A table” to the personal computer terminal device 34-1 in step S9. As shown in FIG. A list of item names of “A table” is displayed in the item name selection frame 65g of 65. This item name also displays the period during which the data, which is the data acquisition condition for the update hour / minute / second, date, is acquired in the DB. As the data acquisition condition, an arbitrary condition such as a data acquisition period, a maximum value, a minimum value, a range, an arrangement order, and a grouping may be set.

  By the way, when a different DB name is selected in the DB name frame 65e on the data acquisition condition setting screen 65 displayed on the personal computer terminal device 34-1 in steps S3 and S4, the same flow as in steps S4 to S9. Then, the table master file corresponding to the DB name is read, the table name registered at the head of the table master file is displayed in the table name frame 65f, and the item name list of the table is displayed in the item name selection frame 65g. Is done.

Similarly, in step S3 and S4, when a different table name is selected in the table name frame 65f on the data acquisition condition setting screen 65, the item name list of the selected table is displayed in the item name selection frame 65g in step S9. Is displayed.
After this display, in the data acquisition condition setting screen 65 in step S10, the item name that the user wants to acquire is selected (clicked) from the item name selection frame 65g, and the selection is made by pressing the selection >>>> button 65h in the center of the screen. The item name is copied to the completed column frame 65i. Here, the item selected by the user by mistake is deleted by selecting (clicking) the item name to be deleted in the selected column frame 65i and then pressing the deselect button 65j.

  After all necessary items are copied to the selected column frame 65i by the above operation, conditions are input to the acquisition condition frame 65k at the lower left of the screen. For example, when extracting a record in which the value of item 1 is −FM, select item 1 in the upper row of the acquisition condition frame 65k, select = as a mathematical symbol in the lower left row, and in the lower right row. After inputting FM− as a value, the acquisition condition set in the acquisition condition frame 65k is converted and displayed as a sentence in the set acquisition condition frame 65n by pressing the setting >> button 65m at the lower center of the screen. To add more conditions, select “or” or “ka” above the acquisition condition frame 65k using the keyboard OR or AND, select the item and symbol values again in the acquisition condition frame 65k, and select Settings> By pressing the >> button 65m, the acquisition condition set in the acquisition condition frame 65k is converted and displayed as a text in the set acquisition condition frame 65n. By this operation, data extraction conditions such as the maximum value and minimum value of data to be acquired are also set.

However, the text in the set acquisition condition frame 65n can be directly edited, and complicated acquisition conditions can be described. If the user wants to erase the entire sentence, the user presses the clear button 65p.
If there is no change after setting the selected column frame 65i and the set acquisition condition frame 65n, the download button 65q at the upper right of the screen is pressed.
By this pressing, the screen setting processing unit 52 receives a download instruction, and in step S11, a data acquisition request with the data acquisition condition set on the data acquisition condition setting screen 65 in step S10 is sent to the data file creation processing unit 53. To be done.

In response to this data acquisition request, the data file creation processing unit 53 analyzes the data acquisition conditions, and acquires information on the connection destination DB, table name, data item name, and acquisition conditions accordingly.
Here, as the data size upper limit check in the previous stage, the number of items to be extracted is calculated, and the product with the data size of one predetermined item is calculated, thereby calculating the total data size. When the calculated size exceeds the upper limit value, the message 71 is displayed on the personal computer terminal device 34-1 according to the upper limit value check under the acquisition condition shown in FIG. 8, and the subsequent processing is stopped and acquired again. A review of the conditions is encouraged.
As a result, the subsequent processing is stopped, so that there is an effect of reducing work load and network load.

  On the other hand, if the upper limit check is passed, the corresponding DB connection engine 55-1 is selected by the data file creation processing unit 53, and the data acquisition condition information is incorporated into the relational database operation language sentence. Based on the information, in step S12, a data acquisition instruction is issued to the server 12-1 via the DB connection engine 55-1. In response to this instruction, in step S13, target data is acquired from the DB 11-1 of the server 12-1.

  Then, in the data file creation processing unit 53, the acquired data is changed to a CSV (Comma Separated Value) format, and the actual size of the CSV file is compared with the data size upper limit value in the subsequent stage and checked. As a result, when the actual size of the CSV file exceeds the upper limit value, the message 72 is displayed on the personal computer terminal 34-1 according to the upper limit value check by the actual file shown in FIG. 9, and the subsequent processing is stopped. It is prompted to review the acquisition conditions again.

On the other hand, if it is equal to or less than the upper limit value, the created data file 43 is stored in the created data file shared folder 57 as, for example, a file name “DL 20061130 7510, csv” in step S14.
Since the subsequent stop function based on the upper limit check stops the download, it has the effect of reducing the network load. However, if the sharing setting of the created data file shared folder 57 is enabled and the contents of the folder can be operated, it is possible to acquire data files exceeding the upper limit value.

Further, if the upper limit check is passed, the data file creation processing unit 53 sends a completion notification to the data file output processing unit 54 in step S15.
In response to the completion notification, the data file output processing unit 54 displays the information for display on the data file download notification screen 73 shown in FIG. 10 in step S16 as a notification that the data file 43 has been created under the above data acquisition conditions. The data is transmitted to the corresponding personal computer terminal device 34-1, whereby the screen 73 is displayed.

  When the download button 73a is clicked on the screen 73 in step S17, the data file output processing unit 54 shows in FIG. 11 a screen for selecting whether to display or save the created data file 43 in step S18. The display information of the data file download determination screen 74 is transmitted to the corresponding personal computer terminal device 34-1 and the screen 74 is displayed.

In this screen 74, when the open button 74a is clicked in step S19, the data file 43 is downloaded from the data file shared folder 57 created in step S20 by the spreadsheet software 42, and the data file as shown in FIG. A list 75 is displayed. If the save button 74b is clicked in step S19, the data file 43 is downloaded by the spreadsheet software 42 in step S21 and stored in the designated save location.
When the cancel button 74c is clicked, the display of the data file download determination screen 74 is ended.

Next, the operation when using a macro will be described.
In both cases of new registration of a user name and macro name, calling of a registered macro, and deletion, the macro management processing unit 51 responds to a user operation on the personal computer terminal device 34-1.
First, in the case of new registration, when the user presses the new button 65a next to the user name frame 65r at the top of the data acquisition condition setting screen 65 in step S22, a new user registration screen 81 shown in FIG. When "User C" is input on this screen 81 and the OK button 81a is pressed, a new user C is registered in step S23.

In step S22, when the new button 65b next to the macro name frame 65s at the top of the data acquisition condition setting screen 65 is pressed, a new macro registration screen 82 shown in FIG. When the terminal information of factory 1] is input and the OK button 82a is pressed, a new macro is registered in step S23.
At the time of registration, a folder for user C is created in the definition information sharing folder 56, and a macro definition file 61C-1 named [factory 1 terminal information] shown in FIG. 5 is created in this folder.

  Next, when calling a registered macro, in step S24, the user and the macro registered in step S22 are called on the data acquisition condition setting screen 65. As a result, the user list is displayed in the user name frame 65r at the top of the data acquisition condition setting screen 65. When the user C is selected from these, the macro list registered by the user C is displayed in a list in the macro name frame 65s in step S25. When the [Factory terminal information] is selected from among these and the setting call button 65t beside the user name frame 65r is pressed, the data acquisition condition is displayed in the set acquisition condition frame 65n.

In this way, when the macro acquisition condition is called on the data acquisition condition setting screen 65 and the download button 65q is pressed in step S26, the load for setting the condition described in step S10 is reduced. Acquisition becomes possible. Of course, you may review the conditions and download them.
In addition, if it is desired to change part of the data acquisition condition and save it again, after the condition called in step S24 is corrected in step S22, the user presses the setting save button 65u next to the macro name frame 65s to select the user. The changed acquisition condition is overwritten on the user name and macro name displayed in the name frame 65r and the macro name frame 65s.

Further, since only the administrator can delete the user and the macro, in step S28, the administrator address is specified by the administrator, for example, at the personal computer terminal device 34-1, and the WEB browser 41 is connected to the WEB server 32. Then, the manager data acquisition condition setting screen 66 shown in FIG. 7 is displayed.
Since delete buttons 66c and 66d are prepared in the upper part of the screen 66, when a macro is deleted, the macro to be deleted is displayed in advance by pressing the setting call button 65t, and the delete button 66c is pressed. A macro deletion screen 83 shown in FIG. 15 is displayed. By pressing the OK button 83a on this screen 83, the selected macro is deleted.

Also, if all macros under the user are deleted, the user can also be deleted. Similarly, by pressing the delete button 66d, a user delete screen 84 shown in FIG. 16 is displayed. By pressing the OK button 84a on this screen, the selected user is deleted.
As described above, according to the data file creation management system 30 of the present embodiment, the user can network desired data from the plurality of servers 12-1 to 12-n with a simple designation operation using the personal computer terminal device 34-1. The data file 43 for operation analysis can be created in a short time by reading the data without adversely affecting the data 13 and combining them freely.
In addition, the data of the plurality of servers 12-1 to 12-n can be centrally managed by a single personal computer terminal device 34-1, and the personal computer terminal device 34-1 can be independently updated, thereby making it unnecessary. Cost generation can be eliminated.

It is a block diagram which shows the structure of the data file creation management system which concerns on embodiment of this invention. It is a figure which shows the block structure of the characteristic element in the said data file creation management system, and the flow of control and data. It is a figure which shows the example of a DB master definition file. It is a figure which shows the example of the definition file of the table master. It is a figure which shows the example of the macro definition file of the terminal information of the factory. It is a figure which shows the example of a data acquisition condition setting screen. It is a figure which shows the example of the data acquisition condition setting screen for administrators. It is a figure which shows the example of a message display when the result of the upper limit check in data acquisition conditions exceeds. It is a figure which shows the example of a message display when the result of the upper limit check by a real file is over. It is a figure which shows the example of a data file download notification screen. It is a figure which shows the example of a data file download determination screen. It is a figure which shows the example of a data file list. It is a figure which shows the example of a new user registration screen. It is a figure which shows the example of a new macro registration screen. It is a figure which shows the example of a macro deletion screen. It is a figure which shows the example of a user deletion screen. It is a block diagram which shows the structure of the conventional data file creation management system.

Explanation of symbols

11-1 to 11-n DB (database)
12-1 to 12-n server 13 network 17-1, 17-n office 18-1, 18-n printer 30 data file creation management system 32 WEB server (data file creation management device)
34-1 to 34-n PC terminal device 41 WEB browser 42 Spreadsheet software 43 Data file 51 Macro management processing unit 52 Screen setting processing unit 53 Data file creation processing unit 54 Data file output processing unit 55-1 to 55-n DB Connection engine 56 Definition information shared folder 57 Created data file shared folder 61A, 61B Macro definition file group 62 DB master definition file 63 Table master definition file 63-1 Table master 1 definition file 61C-1 Factory 1 terminal information macro Definition file 65 Data acquisition condition setting screen 65a, 65b New button 65e DB name frame 65f Table name frame 65g Item name selection frame 65h Select >>>> button 65i Selected column frame 65j Deselect button 65k Acquisition condition Frame 65m Setting >>>> button 65n Set acquisition condition frame 65p Clear button 65q Download button 66 Data acquisition condition setting screen for administrator 66c, 66d Delete button 71, 72 Message 73 Data file download notification screen 73a Download button 74 Data file Download decision screen 74a Open button 74b Save button 74c Cancel button 75 Data file list 81 New user registration screen 81a OK button 82 New macro registration screen 83 Macro delete screen 83a OK button 84 User delete screen 84a OK button

Claims (8)

A plurality of servers having databases for storing data, and a plurality of terminal devices for communication information processing connected to these servers via a communication network, and data from the database of the server at these terminal devices In a data file creation management system that creates a data file by acquiring
The terminal device includes a WEB browser that performs information reception browsing processing, and spreadsheet software that performs processing of displaying, editing, and managing data received via the network in the processing of the WEB browser,
A network between the server and the terminal device is connected to a WEB server that transmits data to the terminal device according to a command of the WEB browser of the terminal device,
A definition information sharing folder having a master definition file in which database names of the databases of the plurality of servers and table names of data tables existing in the database are registered, and the master server when connected from the terminal device. Reads data from the definition file and displays a list of database names, table names, and item names in the table on the terminal device, and is arbitrarily combined from the list contents on the displayed terminal device, and an arbitrary condition is designated for this. A screen setting processing unit that receives the acquired data acquisition conditions and requests data acquisition, and a plurality of DBs that are assigned one-to-one for each of the databases of the plurality of servers and that connect to only the assigned databases Connection engine and the data acquisition condition at the time of the data acquisition request are relational database. A data file creation processing unit that creates a data acquisition instruction by incorporating it into the operation language sentence, acquires data from the corresponding database via the DB connection engine selected according to the instruction, and creates a data file by incorporating this acquired data And
In the terminal device, the data file is received by the WEB browser, and the data file is edited and managed by the spreadsheet software.   The screen setting processing unit, when receiving the data acquisition condition, calculates the size of the data file based on the received information, and if the calculated size exceeds a preset upper limit value, 2. A message requesting a review of the data acquisition condition is displayed, and if the calculated size is equal to or smaller than the upper limit value, a data acquisition request is made to the data file creation processing unit under the data acquisition condition. The data file creation management system described in 1.   The data file creation processing unit displays a message requesting the terminal device to review the data acquisition condition when the size of the acquired data from the database exceeds a predetermined upper limit, and the size of the acquired data The data file creation management system according to claim 1 or 2, wherein the data file is created by incorporating the acquired data if the value is equal to or less than the upper limit value.   In the definition information shared folder, a macro definition file registered by making the data acquisition condition into a macro that can be freely called is stored, and the screen setting processing unit is configured to store the macro definition file when the macro name is designated by the terminal device. The data file creation management system according to any one of claims 1 to 3, wherein a macro definition file having a specified macro name is read from the definition information sharing folder, and the content is used as the data acquisition condition. A plurality of servers having a database for storing data, a WEB browser connected to these servers via a communication network, and a process of receiving and browsing information, and editing and management of data received by the processing of the WEB browser A plurality of terminal devices having spreadsheet software for processing, and a data file connected to a network between these terminal devices and a plurality of servers, and having a Web server function for transmitting data to the corresponding terminal device according to a command from a WEB browser In the creation management device,
A definition information sharing folder having a master definition file in which a database name of the database of the plurality of servers and a table name of a data table existing in the database are registered, and data from the master definition file at the time of connection from the terminal device A data acquisition condition in which a database name, a table name, and an item name in the table are displayed in a list on the terminal device and are arbitrarily combined from the contents of the list in the displayed terminal device, and an arbitrary condition is specified for this. A screen setting processing unit that receives a data acquisition request, a plurality of DB connection engines that are assigned one-to-one for each database of the plurality of servers, and that perform processing of connecting only to the assigned database; Incorporate data acquisition conditions when requesting data acquisition into relational database operation language statements A data file creation processing unit for creating a data acquisition instruction, acquiring data from the corresponding database via the DB connection engine selected according to the instruction, and creating a data file by incorporating the acquired data, A data file creation management apparatus, comprising: a created form shared folder that holds a form file so that the form file can be received by a WEB browser of the terminal device.   The screen setting processing unit, when receiving the data acquisition condition, calculates the size of the data file based on the received information, and if the calculated size exceeds a preset upper limit value, 6. A message for requesting a review of the data acquisition condition is displayed, and if the calculated size is equal to or less than the upper limit value, a data acquisition request is made to the data file creation processing unit under the data acquisition condition. The data file creation management device described in 1.   The data file creation processing unit displays a message requesting the terminal device to review the data acquisition condition when the size of the acquired data from the database exceeds a predetermined upper limit, and the size of the acquired data The data file creation management device according to claim 5 or 6, wherein if it is equal to or less than the upper limit value, the data file is created by incorporating the acquired data.   In the definition information shared folder, a macro definition file registered by making the data acquisition condition into a macro that can be freely called is stored, and the screen setting processing unit is configured to store the macro definition file when the macro name is designated by the terminal device. 8. The data file creation management apparatus according to claim 5, wherein a macro definition file having a designated macro name is read from the definition information sharing folder, and the contents are used as the data acquisition condition.

Images