JP2016151987A - Material preparation support system, material preparation support method and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce work time for preparing material by efficiently preparing materials such as a business report on computer system operation and maintenance.SOLUTION: A material preparation support system 10 comprises a material preparation processing device 12 which includes a data processor 20, a data analysis unit 22, and a material preparation unit 23. The data processor 20 converts entered log data into text data. The data analysis unit 22 analyzes the converted text data on the basis of an analysis instruction command for suggesting the text data analysis details. The material preparation unit 23 prepares and outputs materials in a predetermined format on the basis of an analysis result by the data analysis unit 22.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a material creation support system, a material creation support method, and a program, and more particularly, to a technique effective for support for creating a maintenance report material such as a computer system.

  In a report meeting in operation and maintenance of a computer system or the like, materials such as a report are created by a personal computer, for example, and the materials are distributed to attendees.

  To create this type of material, first, log data is collected from, for example, a log file. Then, necessary information is extracted from the collected log data. After that, it is created by processing the extracted log data. For example, an Excel function is used to process the log data.

  However, the above-described technique for creating data related to the maintenance and operation of the computer system has the following problems.

  The above-mentioned process of collecting log data, extracting necessary log data from the collected log data, and processing the extracted log data has been performed by the worker, and thus requires a lot of work time. There's a problem.

  Also, the created business reports and other materials are not made into a database. For this reason, the history of edited business reports is not managed at all, and even if problems occur in system operation etc., it takes time to search past cases or search past cases. There is a fear that it will not be possible to refer to it. As a result, it may be considered that analysis of problems in operation work becomes insufficient.

  An object of the present invention is to provide a technique capable of shortening the work time for creating a material by efficiently creating a material such as a business report concerning maintenance operation of a computer system or the like.

  The above and other objects and novel features of the present invention will be apparent from the description of this specification and the accompanying drawings.

  Of the inventions disclosed in the present application, the outline of typical ones will be briefly described as follows.

  That is, a typical material creation support system includes a data processing unit, a data analysis unit, and a material creation unit. The data processing unit converts log data into text data. The data analysis unit analyzes the converted text data based on an analysis instruction command indicating the analysis content of the text data. The material creation unit creates and outputs a material in a preset format based on the analysis result analyzed by the data analysis unit.

  Furthermore, the material creation support system includes a material management unit and a data storage unit. The material management unit performs management of the history of the material data by adding management information to the material data including the text data converted by the data processing unit and the material created by the material creating unit. The data storage unit stores material data to which management information is added by the material management unit.

  Among the inventions disclosed in the present application, effects obtained by typical ones will be briefly described as follows.

  (1) A highly accurate material can be efficiently generated in a short time.

  (2) Data can be managed efficiently.

It is explanatory drawing which shows an example of a structure in the material preparation assistance system by one Embodiment. It is a flowchart which shows an example of the material creation process by the material creation assistance system of FIG.

  In the following embodiments, when it is necessary for the sake of convenience, the description will be divided into a plurality of sections or embodiments. However, unless otherwise specified, they are not irrelevant to each other. There are some or all of the modifications, details, supplementary explanations, and the like.

  Further, in the following embodiments, when referring to the number of elements (including the number, numerical value, quantity, range, etc.), especially when clearly indicated and when clearly limited to a specific number in principle, etc. Except, it is not limited to the specific number, and may be more or less than the specific number.

  Further, in the following embodiments, the constituent elements (including element steps and the like) are not necessarily indispensable unless otherwise specified and apparently essential in principle. Needless to say.

  Hereinafter, embodiments will be described in detail.

  FIG. 1 is an explanatory diagram showing an example of the configuration of the material creation support system according to the present embodiment.

  The material creation support system 10 is a system that supports the creation of materials such as business reports related to system maintenance and system operation in an operational system in operation, for example. As shown in FIG. 1, the material creation support system 10 includes an input device 11, a material creation processing device 12, and a database 13.

  The input device 11 serving as an input unit is connected to the material creation processing device 12 and inputs data such as a log file to the material creation processing device 12. The input device 11 and the material creation processing device 12 are connected by a dedicated line or a communication line such as a LAN (Local Area Network). The communication line to which the input device 11 and the material creation processing device 12 are connected is not particularly limited, and may be configured to be connected by a communication line such as an Internet line.

  The material creation processing device 12 includes a server, for example. The material creation processing device 12 includes a data processing unit 20, a data capture unit 21, a data analysis unit 22, a material creation unit 23, a material management unit 24, and an output unit 25.

  The data processing unit 20 converts data such as a log file input from the input device 11 into, for example, CSV (Comma Separated Value) format data (or a file) so that the database 13 can capture the data.

  The data capturing unit 21 captures CSV format data processed by the data processing unit 20 into the database 13. The data analysis unit 22 analyzes the data in the CSV format that the data capturing unit 21 has captured in the database 13.

  Based on the analysis result analyzed by the data analysis unit 22, the material creation unit 23 creates a material such as a business report necessary for explaining the operation status of the operation system to the customer. The material management unit 24 performs history management of material data including materials created by the material creating unit 23 and CSV format data used at the time of material creation.

  The output unit 25 outputs the above-described material data including the material generated by the material creation unit 23 and the CSV format data used for the analysis of the material to the database 13. The database 13 serving as a data storage unit stores material data output from the output unit 25.

  Next, the operation of the material creation support system 10 will be described with reference to FIGS. 1 and 2.

  Each function of the material creation processing device 12 described below with reference to FIG. 2 is realized by execution of a CPU (Central Processing Unit) (not shown) included in the material creation processing device 12.

  Specifically, each function of the material creation processing device 12 is a function processed by the data processing unit 20, the data capture unit 21, the data analysis unit 22, the material creation unit 23, the material management unit 24, and the output unit 25. It is.

  The CPU described above executes processing of each function based on program-format software stored in a program storage memory (not shown) provided in the material creation processing device 12.

  FIG. 2 is a flowchart showing an example of a material creation process by the material creation support system 10 of FIG.

  First, customer data in the operation system provided from the customer by the input device 11 is input to the material creation processing device 12 (step S101). The customer data includes, for example, a server monitoring log in the operation system, a system user login history, and an error log that may lead to a failure.

  The type of log in the customer data, that is, the type of log input to the material creation processing device 12 is set in advance by, for example, an operator. In this setting work, for example, the type of log extracted as customer data by an input unit such as a keyboard (not shown) included in the input device 11 is set. The input device 11 extracts the type of log set in the setting operation from all the logs, and outputs it to the material creation processing device 12 as customer data.

  Note that this customer data log extraction may be performed by a device other than the input device 11. For example, customer data may be generated in a personal computer connected to a customer operation system.

  In this case, the generated customer data is input to the input device 11 via a communication line such as the Internet line. Or the structure which inputs the customer data produced | generated to the material preparation processing apparatus 12 from the personal computer connected to the operation system may be sufficient.

  In this way, the process of extracting a preset type of log and automatically importing it as customer data reduces log extraction mistakes and input mistakes, as well as the time required for input operations, etc. can do.

  The data processing unit 20 converts the customer data input from the input device 11 into, for example, CSV format data (step S102). Again, since the data processing unit 20 automatically converts customer data into CSV format data or the like, it is possible to reduce errors in data conversion and reduce man-hours related to the conversion process.

  Subsequently, the data capturing unit 21 captures the CSV format data converted by the data processing unit 20 into the database 13 (step S103). In the process of step S103, for example, each log is fetched into each log table for each operation system and updated.

  Then, the data analysis unit 22 performs a material analysis process for analyzing the CSV format data taken into the database 13 in the process of step S102 (step S104). In the process of step S104, the data analysis unit 22 analyzes and adjusts the data in the CVS format so as to match the contents of the operation report requested by each customer.

  The contents of the operation report to be analyzed are input from the input device 11 to the material creation processing device 12 as an analysis instruction command, for example. The data analysis unit 22 analyzes the data in the CVS format based on the input analysis instruction command.

  Specifically, the analysis instruction command searches for the day when the login error has occurred most in a certain period, for example, one month, and finds the user name and the number of occurrences that caused the login error most on that day. It is an instruction such as extracting.

  In this way, the data analysis unit 22 extracts data that matches the contents of the operation report requested by each customer based on the analysis instruction command, thereby reducing data entry mistakes and extraction mistakes by the creator. be able to. In addition, since it is possible to eliminate the need for data analysis and extraction by the operator, the number of work steps can be reduced.

  Thereafter, the material creation unit 23 creates and outputs materials necessary for explaining the operation status of the operation system to the customer (step S105). In the process of step S105, the material creation unit 23 creates materials necessary for explaining the operation status of the system to the customer from the data analyzed in the material analysis process of step S104.

  The material creation unit 23 converts the analyzed data into a dedicated material format or the like when creating the material. By converting to a dedicated format, items that require explanation to the customer, such as the operating status of the system, can be made easy to see and understand. In addition, the processing of step S105 eliminates the need for the creator to create materials and collect work, thereby improving the material creation efficiency.

  Note that the material creation unit 23 can convert and output not only a dedicated material format but also a file format desired by the business report material creator, such as a PDF (Portable Document Format) file. Conversion to a dedicated material format or conversion to a PDF file or the like is specified by the input device 11, for example.

  Subsequently, the material management unit 24 performs history management of the material data including the material generated by the material creating unit 23 and the data converted into the CSV format used when the material is created (step S104) (step S104). S106).

  In the process of step S106, the material management unit 24 adds management information to the material data described above. The management information includes, for example, information such as a customer number for identifying a customer and a date when the material is generated.

  Thereafter, the output unit 25 performs a process of storing the material data to which the management information is added in the database 13 (Step S107). As a result, history management of material data can be performed, and necessary material retrieval and management can be performed efficiently.

  The material data stored in the database 13 can be taken in by the input device 11, for example, and can be displayed on a display (not shown) of the input device 11 or the like. Further, for example, the material can be printed by a printer (not shown) connected to the input device 11.

  Further, the input device 11 can change / correct the material displayed on the display. The material that has been changed / modified is output from the input device 11 to the material creation processing device 12.

  In the material creation processing device 12, the material management unit 24 assigns management information to the material output from the input device 11 and outputs it to the output unit 25. The output unit 25 stores the material to which the management information is assigned in the database 13.

  Thereby, the material can be managed by the history. The history of each material such as the latest material, the material before change / correction, or the material after change / correction can be immediately determined, and the search time of the material can be shortened.

  As described above, since a desired material can be automatically created, the material creation efficiency can be improved. Further, since data input and data conversion by an operator are not necessary, input mistakes can be reduced, and highly accurate materials can be generated in a short time.

  Furthermore, since the generated material data is stored in the database 13 together with the management information, the material data can be managed efficiently.

  As mentioned above, the invention made by the present inventor has been specifically described based on the embodiment. However, the present invention is not limited to the embodiment, and various modifications can be made without departing from the scope of the invention. Needless to say.

  In addition, this invention is not limited to above-described embodiment, Various modifications are included. For example, the above-described embodiment has been described in detail for easy understanding of the present invention, and is not necessarily limited to one having all the configurations described.

DESCRIPTION OF SYMBOLS 10 Material creation support system 11 Input device 12 Material creation processing apparatus 13 Database 20 Data processing part 21 Data capture part 22 Data analysis part 23 Material creation part 24 Material management part 25 Output part

Claims (10)

A data processing unit that converts log data to text data;
A data analysis unit that analyzes the converted text data based on an analysis instruction command indicating the analysis content of the text data;
Based on the analysis result analyzed by the data analysis unit, a material creation unit that creates and outputs a document in a preset format, and
A material creation support system. In the document preparation support system according to claim 1,
Further, a material management unit that provides management information to material data composed of the text data converted by the data processing unit and the material created by the material creation unit to manage the history of the material data,
A data storage unit for storing the material data to which the material management unit has given the management information;
A material creation support system. In the document preparation support system according to claim 2,
Furthermore, the material creation support system further includes an input unit for inputting the log data and the analysis instruction command. In the document preparation support system according to claim 2 or 3,
The management information provided by the material management unit is a material creation support system that includes a customer number for identifying a customer who supplies the log data and a date when the material creation unit generates the material. A data creation support method by a computer system comprising: a data processing unit for converting log data; a data analysis unit for analyzing the converted data; and a material creation unit for creating material from the analyzed data. There,
The data processing unit converting the log data into text data;
The step of analyzing the text data converted based on an analysis instruction command indicating the analysis content of the text data;
The material creation unit creating a material in a preset format based on the analysis result of the text data; and
A material creation support method. In the document preparation support method according to claim 5,
The computer system further includes a data management unit that manages the converted data and the history of the data, and a database that stores data.
Furthermore, the material management unit gives management information to the material data consisting of the converted text data and the created material,
The material management unit storing the material data with the management information in the database;
A material creation support method. In the document preparation support method according to claim 6,
The material creation support method, wherein the management information is a customer number for identifying a customer who supplies the log data and a date when the material creation unit generates the material. In the document preparation support method according to claim 6 or 7,
The document creation support method, wherein the converted text data is CSV format data. A program for causing a computer system to execute a material creation process for analyzing log data and creating a material, and a management process for managing the history of the material,
The material creation process includes:
Converting the log data into text data;
Analyzing the converted text data based on an analysis instruction command indicating the analysis content of the text data;
Creating and outputting a document in a preset format based on the analysis result of the data; and
Have
The management process includes
Providing management information to the converted document data including the text data and the created document;
Storing the text data and the material provided with the management information in a database;
Having a program. The program according to claim 9, wherein
The management information is a program that includes a customer number for identifying a customer that supplies the log data, and a date when the material is generated in the material creation process.

Images