Information processing system

Abstract

To provide an information processing system that enables immediate retrieval of analytical information useful for business management utilizing a multidimensional database.SOLUTION: An information processing system comprises: a multidimensional database having at least a project dimension, a process dimension, and a personnel dimension; a planning creation unit that creates a work plan including at least project information, process information, and personnel information contained in each dimension of the database; and a performance management unit that inputs work start time and work completion time for the work plan. The multidimensional database stores hierarchical structure data containing at least the project information, process information, personnel information, work start time, and work completion time.SELECTED DRAWING: Figure 3

Description

Technical Field

[0001] The present invention relates to an information processing system that enables immediate acquisition of analytical information contributing to business management using a multidimensional database.

Background Art

[0002] Conventionally, there have been information processing systems for managing business plans and business results. For example, Patent Document 1 describes an invention of a production plan management system that enables the side managing the production results and the production site side to share the production results in real time while simplifying the input work of the production results on the production site side.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] In such a general information processing system in a business plan management system, in proceeding with business in order, in order to ensure data consistency and orderliness, a design method using a single-dimensional database that repeatedly performs the design of "combining a file set with one table structure and a file set with another table structure to create a new file set" has been mainstream. As a result, almost all of the components required for the system have been built manually.

[0005] However, with such a design approach, as the scale and complexity of the system increase, it becomes inefficient, and there is an issue of investing a large amount of human resources to build the system. Also, from the perspective of business execution, although it has a suitable data structure, from another perspective (such as concepts like personnel evaluation or resource management other than business execution), there is an issue that the data must be reconfigured to conform to another dimension.

[0006] Regarding the latter issue, from the perspective of another dimension, although means such as creating a program and a data structure separately and then using them as inputs for other operations can be taken, this means has a problem of causing a time lag. That is, in business plan management, it does not have a mechanism to achieve the output speed of analysis results and the frequency of refreshing analysis results required for business management.

[0007] On the other hand, in order to solve the above-mentioned problems, a design approach that uses a multi-dimensional database instead of a single-dimensional database can be considered. In a multi-dimensional database, data is represented in a "cube" structure, and this cube has multiple dimensions, and each dimension represents a specific category or hierarchy. For example, data with different dimensions such as time, region, and product can be represented in an integrated view.

[0008] As a result, the need for data reconstruction and manual construction is significantly reduced. According to different business needs and analysis perspectives, it becomes possible to instantly slice and dice (cut and analyze) the data, so that data analysis from different perspectives such as business planning, personnel evaluation, and resource management can be quickly performed.

[0009] However, in a multidimensional database, in order to create a system with a multidimensional database structure, it is necessary to define multidimensional business requirements (reports for proceeding with business in order, information forms necessary for human resource management, information forms necessary for cost management) in advance, design the minimum data unit of the multidimensional database, and attach additional data to satisfy the multidimensional business requirements for that minimum data unit. Then, for designers of multidimensional databases, both the ability to define multidimensional business requirements and system construction ability are required.

[0010] However, it is very difficult to acquire both of these abilities (it is necessary to be proficient in various types of business, and it is necessary to be able to construct a system based on a design concept different from the previous one). Although the design concept itself has existed since before, it has not been possible to reach the design definition.

[0011] The inventor of the present invention has found that in the design of a business management system, by creating vessels such as a project dimension, a process dimension, and a personnel dimension, and inputting information such as "work start · work end", which is the minimum unit of data, into each vessel so that it can be used in each vessel, a multidimensional database that can be easily utilized can be constructed.

[0012] (1) Based on the above findings, the information processing system according to the present invention includes a multidimensional database having at least a project dimension, a process dimension, and a personnel dimension as dimensions, a plan creation unit that creates a business plan including at least project information, process information, and personnel information included in each dimension of the database, and a performance management unit that inputs a work start time and a work completion time for the business plan. The multidimensional database stores hierarchical structure data including at least the project information, the process information, the personnel information, the work start time, and the work completion time.

[0013] In this information processing system, by utilizing a multidimensional database, it is possible to easily create a business plan based on the project dimension, process dimension, and personnel dimension. Also, analysis can be performed for each dimension, contributing to the efficiency improvement of project management, resource management, etc. This enables a more detailed and efficient plan.

[0014] (2) Furthermore, in the above-described information processing system, which has a product dimension, the plan creation unit creates a business plan including product information in addition to the project information, process information, and personnel information, and the multidimensional database records hierarchical structure data including at least the project information, process information, personnel information, work start time, work completion time, and product information.

[0015] In this information processing system, in particular, the personnel dimension has a hierarchical structure in the order of worker information, work start time, work completion time, project information, and process information, enabling individual-level progress tracking and centralized personnel management.

[0016] (3) In the above-described information processing system, in the case dimension of the multidimensional database, it has a hierarchical structure in the order of project information, process information, worker information, work start time, and work completion time.

[0017] (4) In the above-described information processing system, in the case dimension of the multidimensional database, it has a hierarchical structure in the order of the project information, the category information, the process information, the worker information, the work start time, and the work completion time.

[0018] (5) In the above-described information processing system, in the process dimension of the multidimensional database, it has a hierarchical structure in the order of the category information, the process information, the project information, the worker information, the work start time, and the work completion time.

[0019] (6) In the above-described information processing system, the product dimension of the multidimensional database has a hierarchical structure in the order of the product information, the process information, the project information, the operator information, the work start time, and the work completion time.

Effect of the Invention

[0020] According to the information processing system of the present invention, business plans and business results can be efficiently managed using a multidimensional database. Specifically, a report screen that thoroughly eliminates the hassle of work reports, a function that allows the results of work reports to be viewed weekly for each person, a function that allows the work content of team members for one day to be viewed, a function that visualizes the progress of projects and the status of working hours spent based on work reports, a display of the "degree of effort" obtained by quantifying the efforts of the reporter himself / herself for the projects subject to work reports, functions such as aggregating standard time, average planned time, and planned vs. actual performance in task units for each project and each product classification (category) can be provided.

[0021] That is, the present invention can acquire business results in real time using such a multidimensional database, manage information necessary for improving work performance such as optimizing personnel allocation, improving processes, improving estimates, and personnel evaluations with high performance, and provides a new information processing system that improves work performance.

Brief Description of the Drawings

[0022]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Figure 18

Figure 19

Figure 20

Figure 21

Figure 22

Embodiments for Carrying Out the Invention

[0023] <Device Configuration of Information Processing System>

[0024] The information processing system S according to the embodiment of the present invention will be described with reference to the drawings.

[0025] The information processing system S is configured to include at least a server 1, an administrator terminal 2, and a worker terminal 3. The server 1, the administrator terminal 2, and the worker terminal 3 are interconnected via a network N such as the Internet.

[0026] The server 1 is a server 1 that manages the operations of the administrator terminal 2 and the worker terminal 3, and executes various processes for providing process management related to business and office work.

[0027] The administrator terminal 2 is an information processing device operated by an administrator who performs process management, and is configured by, for example, a PC (Personal Computer), a tablet, a smartphone, or the like.

[0028] The worker terminal 3 is an information processing device operated by a worker in a business site or a work site, and is configured by, for example, a tablet, a smartphone, or the like.

[0029] As shown in FIG. 2, the server 1 includes a CPU 11 (Central Processing Unit) 11, a ROM 12 (Read Only Memory), a RAM 13 (Random Access Memory), a bus 14, an input / output interface 15, an output unit 16, an input unit 17, a storage unit 18, a communication unit 19, and a drive DD.

[0030] The CPU 11 executes various processes according to a program stored in the ROM 12 or a program loaded from the storage unit 18 into the RAM 13. The RAM 13 also appropriately stores data and the like necessary for the CPU 11 to execute various processes.

[0031] The CPU 11, ROM 12, and RAM 13 are interconnected via the bus 14. The input / output interface 15 is also connected to this bus 14. The output unit 16, input unit 17, storage unit 18, communication unit 19, and drive D are connected to the input / output interface 15.

[0032] The output unit 16 is composed of a display, a speaker, etc., and outputs various information as images and sounds. The input unit 17 is composed of a keyboard, a mouse, etc., and inputs various information. The storage unit 18 is composed of a hard disk, a DRAM 13 (Dynamic Random Access Memory), etc., and stores various data.

[0033] The communication unit 19 communicates with other devices (for example, the server 1 and the administrator terminal 2 or the worker terminal 3) via a network including the Internet. The storage unit 18 is a storage device such as a conventionally known HDD (Hard disc Drive) or SSD (Solid State Drive), and stores the digitized information. However, the server 1 may use the drive D on the cloud as the storage unit 18.

[0034] Although not shown in the drawings, the administrator terminal 2 and the worker terminal 3 in the information processing system S of FIG. 1 may also be a PC (Personal Computer), a smartphone, or a tablet having the hardware configuration shown in FIG. 2. When the administrator terminal 2 or the worker terminal 3 is configured by a smartphone or a tablet, it has a touch panel as the output unit 16 and the input unit 17.

[0035] Next, the functional blocks for executing the business support process in the information processing system S will be described. Here, the business support process is a series of processes for realizing business support, and is composed of various sub-processes such as pre-registered information registration process, business plan creation process, business performance registration process, etc. It is possible to centrally manage information related to various businesses in real time.

[0036] <Functions of the information processing system>

[0037] As shown in FIG. 3, in the information processing system S, each component of the server 1 cooperates to construct a business support system having a registration reception unit 21, a plan creation unit 22, a performance management unit 23, a performance calculation unit 24, a display control unit 25, a communication unit 19, a pre-information database DD, and a multidimensional database DB.

[0038] The registration reception unit 21 receives pre-information necessary for using the business support system. The received pre-information is stored and managed in the pre-information database DD. The pre-information includes, for example, information regarding "instruction number", "customer name", "project name", "main person in charge", "quantity", "scheduled completion date", "scheduled delivery date", "project summary", and "acceptance conditions" for each project, information regarding "process" for the process, information regarding "worker (person in charge)" for the personnel, and information regarding "product" for the product. However, what information is included in the pre-information is not particularly limited.

[0039] Regarding prior information, specifically, the "instruction number" is an independent number that can identify a case, the "customer name" is the name of the customer (requesting party) for each case, the "case name" is the name for each case, the "main person in charge" is the name of the person in charge for each case, the "quantity" is information regarding the deliverables for each case, the "scheduled completion date" is the scheduled completion date for each case, the "scheduled delivery date" is the scheduled delivery date for each case, the "case summary" is the summary for each case, the "acceptance conditions" are the conditions for accepting a case, the "product" is the name of the product related to the business, the "process" is the content of the process (business), and the "person in charge" indicates the name of the person in charge of executing the process (business).

[0040] The planning department 22 creates a business plan consisting of a combination of one or more processes for executing the business. Specifically, the planning department 22 creates a business plan corresponding to the case based on a combination of one or more processes based on prior information. The created business plan is stored and managed in the prior information database DD.

[0041] <Multidimensional database>

[0042] Next, the operation of the multidimensional database DB will be described. The multidimensional database DB organizes data in a plurality of "dimensions" in order to analyze data from multiple perspectives, and stores hierarchical structure data in which each dimension has a hierarchical structure. Among the present embodiments, a first embodiment regarding a three-dimensional database and a second embodiment regarding a four-dimensional database will be described below. <Three-dimensional database>

[0043] In the first embodiment, as shown in FIG. 4, the multidimensional database DB has at least three dimensions: a case dimension, a process dimension, and a personnel dimension.

[0044] In the multi-dimensional database DB, as minimum data, date information, operator information, work start time, work completion time, project information, and process information are transmitted. As shown in FIG. 5, the minimum data input into the multi-dimensional database DB is sent in parallel to each dimension and organized according to the hierarchical structure in each dimension, and stored as hierarchical structure data.

[0045] In the first embodiment, in the personnel dimension, personnel hierarchical structure data is stored; in the project dimension, project hierarchical structure data is stored; and in the process dimension, process hierarchical structure data is stored.

[0046] The multi-dimensional database DB according to the first embodiment that has received the minimum data, as shown in FIG. 5, in the personnel dimension, generates and stores personnel hierarchical structure data in the order of date information, operator information, work start time, work completion time, project information, and process information. Also, in the project dimension, it generates and stores project hierarchical structure data in the order of date information, project information, process information, operator information, work start time, and work completion time. Further, in the process dimension, it generates and stores process hierarchical structure data in the order of date information, process information, project information, operator information, work start time, and work completion time.

[0047] By organizing and storing data according to the above hierarchies, the multi-dimensional database DB can, for example, easily track, based on the personnel dimension, the projects the operator was involved in from the operator information and the working hours in the processes within the project. Thereby, it is possible to analyze the work performance of the operator and clarify how much time the operator spent on which project and process.

[0048] Also, for example, according to the project dimension, it is possible to analyze which processes were carried out, who was involved in the work, and the time taken for the work for a specific project. Furthermore, according to the process dimension, for example, it is possible to analyze in which project a specific process was involved, which operator was involved, and what the working hours were.

[0049] As shown in FIG. 6, the multidimensional database DB according to the first embodiment cooperates with the pre-information database DD to add information to each hierarchical structure data of each dimension and store it. Each hierarchical structure data constructs hierarchical structure data by adding information related to the operator, information related to the case, and information related to the process stored in the pre-information database DD in addition to the operator information, personnel information, case information, process information, and date information of the minimum data.

[0050] For example, the personnel information may include information about the operator such as name, age, gender, date of birth, etc. related to the "operator (person in charge)". The case information may include information about the case such as instruction number, customer name, case name, main person in charge, quantity, scheduled completion date, scheduled delivery date, case summary, case conditions, etc. The process information may include information about the process such as work type.

[0051] <Operation of the business management system according to the first embodiment>

[0052] Next, the operation of the business management system constructed by the information processing system S in the first embodiment will be described based on the screen displayed on a display device (not shown) such as the monitor of the output unit 16.

[0053] FIG. 7 shows the "work instruction management" screen. The "work instruction management" screen can confirm a list of each registered work. The "work instruction management" screen has items for "instruction number", "customer name / case name", "main person in charge / quantity", "scheduled completion date / scheduled delivery date", and "status" for each work, and also has "edit", "instruction sheet", and "detail" buttons for each work (instruction number / case name).

[0054] The information related to the items of "instruction number", "customer name", "case name", "main person in charge", "quantity", "scheduled completion date", and "scheduled delivery date" on the "work instruction management" screen can be input by the "work instruction creation" screen described later.

[0055] Figure 8 shows the "Work Instruction Details" screen that appears when the "Details" button on the work management screen is clicked. The "Work Instruction Details" screen displays columns for "Basic Information" and "Process Information".

[0056] In addition to the "Instruction Number", "Customer Name", "Project Name", "Main Person in Charge", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date" displayed on the "Work Instruction Management" screen, the "Basic Information" column also shows items such as "Project Summary" and "Acceptance Conditions", allowing details of each work to be confirmed.

[0057] The "Work Information" column displays the item names of "Work Instructions" corresponding to each work and the "Total Work Time" required (or taken) for the work. In this embodiment, as item names of "Work Instructions", items such as "Design" and "Initial Environment Setup" are displayed, and buttons (vertical "..." buttons) for showing details are provided to the right of them. Also, an item with "04:30" is displayed as the "Total Work Time", indicating that the work related to this screen took 4 hours and 30 minutes.

[0058] Figure 9 is displayed by clicking on the items of "Work Instruction Details" that appear when the cursor is placed on the vertical "..." button at the right end of the item name of "Work Instruction". It is the "Work Instruction Details" screen. The "Work Instruction Details" screen displays items such as "Work" (work name), "Person in Charge", "Preparation Time", "Work Time / Page", and "Total Work Time", and a "× Close" button is provided. In this embodiment, the "Work Instruction Details" screen shows the "Work" related to "Design", and information on each item related to the design work is displayed.

[0059] Figure 10 shows the "Work Instruction" screen displayed when the "Instruction Sheet" button on the work management screen is clicked. The "Work Instruction" screen allows the details of the work instruction to be confirmed. In addition to the items of "Instruction Number", "Customer Name", "Project Name", "Project Summary", "Acceptance Conditions", "Main Person in Charge", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date", a [QR Code (registered trademark)] is displayed on the "Work Instruction" screen. The work instruction can be printed by a printer that functions as the output unit 16. Also, the [QR Code (registered trademark)] on the "Work Instruction" screen or the printed work instruction can be read by a smartphone or the like of the worker terminal 3.

[0060] Figure 11 shows the "Work Record" screen when the [QR Code (registered trademark)] on the "Work Instruction" screen is read. In this embodiment, it shows the screen of "Business Report" in STEP.3 of the "Work Record". Note that the "Work Record" screen can also be displayed by clicking on the item of "Work Record" that is displayed when the cursor is placed on the vertical "···" button in the "Work" item of the "Work Instruction Details" screen. In this case, the display proceeds from STEP.1 of the "Work Record" screen.

[0061] When the [QR Code (registered trademark)] is read, since the information regarding the reporting target in STEP.1 and the process in STEP.2 of the "Work Record" is embedded in the [QR Code (registered trademark)], the screen of STEP.3 of the "Business Report" of the "Work Record" is displayed without inputting the information regarding the reporting target (work) in STEP.1 and the process in STEP.2 of the "Work Record" and without displaying the screens of STEP.1 and STEP.2 of the "Work Record".

[0062] The "Business Report" screen of the "Work Record" allows the past records of each work to be confirmed. The "Business Report" screen of the "Work Record" can confirm the past records of each work and at the same time, the work start time and work end time can be stamped. In addition to the columns of "◆Reporting Target", "Reporting Process", and "◆Stamping History", a column for "Comment" and buttons for "Start" and "End" (of the process), and a button for "[+]Add Comment" are provided.

[0063] The "Report Target" displays the items of "Instruction Number", "Customer Name", and "Project Name" in the work instruction sheet. When you click the "[+] Add Comment" button, you can enter comments made when actually performing the "Report Process" in the "Comment" column. The "◆ Punch History" column displays the "Responsible Person", "Date", "Start" time, and "End" time of the work performed so far in the "Report Process".

[0064] When you click the "Start" button, the "Start" time in the "◆ Punch History" of the work is memorized, and when you click the "End" button, the "End" time of the work is memorized. The "Responsible Person" column memorizes the user of the worker terminal 3 that has read the QR code, and the "Date" memorizes the date when the QR code was read. The "Date", "Responsible Person", "Start" time, and "End" time are transmitted to the multidimensional database DB as date information, worker information, work start time, and work completion time, respectively. At the same time, the case information and process information are also transmitted to the multidimensional database DB.

[0065] Figure 12 shows the "Basic Information and Process Information" screen related to a new work instruction displayed when you click the menu button (vertical "---" button, so-called hamburger button) of the work management screen and then click "New Creation". The "Basic Information and Process Information" screen related to the new work instruction displays the "Basic Information" column and the "Process Information" column. On the "Basic Information and Process Information" screen related to the new work instruction, a new work instruction can be created.

[0066] In addition to the "Instruction Number", "Customer Name", "Project Name", "Main Responsible Person", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date" displayed on the "Work Instruction Management" screen, the "Basic Information" column also displays input items for "Project Summary" and "Acceptance Conditions". It can be confirmed that information is input by the registration reception unit 21 through the input unit 17 for each item. The "Work Information" column can be input by selecting from the work information registered in the master information (not shown).

[0067] Figures 13 and 14 show the "Business Report Management" screen. On the "Business Report Management" screen, modifications can be made to the already registered "businesses". Figure 13 shows the screen with the "(1) Persons to be Modified" tab of "Business Report Management" opened. The screen with the "(1) Persons to be Modified" tab opened has columns provided for "User ID", "Name", "Department", "Authority", and "Retirement" for each business modification target person. The information of each modification target person is stored in the master information (not shown) in the database.

[0068] Figure 14 shows the screen with the "(2) Report Time Modification" tab of "Business Report Management" opened. The screen with the "(2) Report Time Modification" tab opened has buttons for "Modification" and "Deletion" provided in addition to the items of "Instruction Number", "Case Name", "Process Name", "Report Date", "Start Time", "End Time", and "Modification" for the person to be modified ("Takeo Oshima" in Figure 14).

[0069] When the "Modification" button is clicked, the "Start Time" or "End Time" of each process can be modified. Also, when a modification is made, a check mark is displayed in the "Modification" item as a record thereof.

[0070] Figure 15 shows the "Everyone's Movements" screen. The "Everyone's Movements" screen displays the daily schedules (past and future) of each worker. In the multidimensional database DB, since it is stored by the hierarchical structure data of each dimension, data analysis and processing can be easily and quickly executed, so a display like "Everyone's Movements" can be performed in real time.

[0071] <Operation of the Business Management System According to the Second Embodiment>

[0072] In the second embodiment, the multidimensional database DB has four dimensions of at least a case dimension, a process dimension, a personnel dimension, and a product dimension (not shown).

[0073] In the multidimensional database DB, as minimum data, in addition to date information, worker information, work start time, work completion time, project information, and process information, product information is transmitted. The minimum data input into the multidimensional database DB is sent in parallel to each dimension and organized according to the hierarchical structure in each dimension, and is stored as hierarchical structure data.

[0074] In the second embodiment, in the personnel dimension, personnel hierarchical structure data is stored; in the project dimension, project hierarchical structure data is stored; and in the process dimension, process hierarchical structure data is stored.

[0075] As shown in FIG. 16, the multidimensional database DB according to the second embodiment that has received the minimum data generates and stores personnel hierarchical structure data in the order of date information, worker information, work start time, work completion time, project information, process information, and product information in the personnel dimension. Also, in the project dimension, it generates and stores project hierarchical structure data in the order of date information, project information, product information, process information, worker information, work start time, and work completion time. Further, in the process dimension, it generates and stores process hierarchical structure data in the order of date information, process information, product information, project information, worker information, work start time, and work completion time.

[0076] Furthermore, the multidimensional database DB according to the second embodiment generates and stores process hierarchical structure data in the order of product information, process information, project information, worker information, date information, work start time, and work completion time in the product dimension.

[0077] By organizing and storing data according to the above hierarchies, the multidimensional database DB can, for example, easily track, based on the personnel dimension, the projects the worker was involved in from the worker information and the working hours in the processes within the project. As a result, it is possible to analyze the work performance of the worker and clarify how much time the worker spent on which project and process.

[0078] Also, for example, according to the case dimension, for a specific case, it is possible to analyze which processes are carried out, who is involved in the work, and the time taken for the work. Furthermore, according to the process dimension, for example, it is possible to analyze in which cases a specific process is involved by which workers and what the working hours were.

[0079] Also, for example, it is possible to analyze in which processes, in which cases, which workers are involved in a specific product and what the working hours were.

[0080] As shown in FIG. 17, the multidimensional database DB according to the second embodiment cooperates with the pre-information database DD to add information to each hierarchical structure data of each dimension and store it. Each hierarchical structure data constructs hierarchical structure data by adding information on workers, personnel information, case information, process information, date information of the minimum data, and in addition, information on workers, information on cases, information on processes, and information on products stored in the pre-information database DD.

[0081] For example, for personnel information, it may include information on workers such as name, age, gender, date of birth, etc. regarding the "worker (person in charge)". For case information, it may include information on cases such as instruction number, customer name, case name, main person in charge, quantity, scheduled completion date, scheduled delivery date, case summary, case conditions, etc. For process information, it may include information on processes such as work type. Information on products may include information on the composition of the products.

[0082] Next, the operation of the business management system constructed by the information processing system S in the second embodiment will be described based on the screen displayed on a display device (not shown) such as the monitor of the output unit 16.

[0083] FIG. 18 shows the "Work Instruction Management" screen. The "Work Instruction Management" screen can display a list of each registered work. The "Work Instruction Management" screen has columns for "Instruction Number / Product", "Customer Name / Project Name", "Main Person in Charge / Quantity", "Scheduled Completion Date / Expected Delivery Date", and "Status" for each work, and also has "Edit", "Instruction Document", and "Details" buttons provided for each work.

[0084] Information regarding the columns of "Instruction Number", "Customer Name", "Product", "Project Name", "Project Summary", "Receiving Conditions", "Main Person in Charge", "Quantity", "Scheduled Completion Date", and "Expected Delivery Date" on the "Work Instruction Management" screen can be input by the "Work Instruction Creation" screen described later.

[0085] FIG. 19 shows the "Work Instruction Details" screen displayed when the "Details" button on the work management screen is clicked. The "Work Instruction Details" screen has a column for "Basic Information" and a column for "Process Information" displayed.

[0086] The column for "Basic Information" displays, in addition to "Instruction Number", "Product", "Customer Name", "Project Name", "Main Person in Charge", "Quantity", "Scheduled Completion Date", and "Expected Delivery Date" displayed on the "Work Instruction Management" screen, columns such as "Project Summary" and "Receiving Conditions", and details for each work can be confirmed.

[0087] The column for "Work Information" displays the item name of the "Work Instruction" corresponding to each work and the "Total Work Time" required (or taken) for the work. In this embodiment, as the item name of the "Work Instruction", columns for "Design" and "Initial Environment Construction" are displayed, and buttons for showing details (vertical "..." buttons) are provided on the right side thereof. Also, a column for "04:30" is displayed as the "Total Work Time", that is, it is shown that the work related to this screen took 4 hours and 30 minutes.

[0088] FIG. 20 shows a "Work Instruction" screen that is displayed when the "Instruction Book" button on the work management screen is clicked. The "Work Instruction" screen allows the details of the work instruction to be confirmed. In addition to the items of "Instruction Number", "Customer Name", "Product", "Project Name", "Project Summary", "Acceptance Conditions", "Main Person in Charge", "Quantity", "Scheduled Completion Date", and "Scheduled Delivery Date", a [QR Code (registered trademark)] is displayed on the "Work Instruction" screen. The work instruction can be printed by a printer that functions as the output unit 16. Also, the [QR Code (registered trademark)] on the "Work Instruction" screen or the printed work instruction can be read by a smartphone or the like of the worker terminal 3.

[0089] FIG. 21 shows a "Work Record" screen when the [QR Code (registered trademark)] on the "Work Instruction" screen is read. In this embodiment, it shows the screen of "Process" in STEP.3 of the "Work Record". Note that the "Work Record" screen can also be displayed by clicking on the item of "Work Record" that is displayed when the cursor is placed on the vertical "···" button of the "Work" item on the "Work Instruction Details" screen. In this case, the display progresses from STEP.1 of the "Work Record" screen.

[0090] When the [QR Code (registered trademark)] is read, since the information regarding the reporting target (work) in STEP.1 and the process in STEP.2 of the "Work Record" is embedded in the [QR Code (registered trademark)], the screen of STEP.3 of the "Business Report" of the "Work Record" is displayed without inputting the information regarding the reporting target (work) in STEP.1 and the process in STEP.2 and without displaying the screens of STEP.1 and STEP.2 of the "Work Record".

[0091] The "Business Report" screen of the "Work Record" allows the past records of each work to be confirmed. The "Business Report" screen of the "Work Record" can confirm the past records of each work and at the same time, the work start time and work end time can be stamped. In addition to the columns of "◆Reporting Target", "Reporting Process", and "◆Stamp History", a column for "Comment" and buttons for "Start" and "End" (of the process), and a button for "[+]Add Comment" are provided.

[0092] The "Report Target" displays the items of "Instruction Number", "Customer Name", "Product", and "Project Name" in the work instruction. Clicking the "[+] Add Comment" button allows comments made during the actual "Report Process" to be entered in the "Comment" column. The "◆ Punch History" column displays the "Responsible Person", "Date", "Start" time, and "End" time of the work performed so far in the "Report Process".

[0093] Clicking the "Start" button stores the "Start" time in the "◆ Punch History" of the relevant work, and clicking the "End" button stores the "End" time of the relevant work. The "Responsible Person" column stores the user of the worker terminal 3 that has read the QR code, and the "Date" stores the date when the QR code was read. The "Date", "Responsible Person", "Start" time, and "End" time are transmitted to the multidimensional database DB as date information, worker information, work start time, and work completion time, respectively. At the same time, the project information and process information are also transmitted to the multidimensional database DB.

[0094] Figure 22 shows the "Basic Information and Process Information" screen related to a new work instruction that is displayed when the menu button (vertical "---" button, so-called hamburger button) of the work management screen is clicked and "New Creation" is clicked. The "Basic Information and Process Information" screen related to the new work instruction displays the "Basic Information" column and the "Process Information" column. In the "Basic Information and Process Information" screen related to the new work instruction, a new work instruction can be created.

[0095] In addition to the "Instruction Number", "Product", "Customer Name", "Project Name", "Main Responsible Person", "Quantity", "Planned Completion Date", and "Planned Delivery Date" displayed on the "Work Instruction Management" screen, the "Basic Information" column also displays input items for "Project Summary" and "Receiving Conditions", and it can be confirmed that information is input by the registration reception unit 21 via the input unit 17 for each item. The "Work Information" column can be input by selecting from the work information registered in the master information (not shown).

[0096] In the second embodiment, while the first embodiment is three-dimensional in terms of the personnel dimension, the project dimension, and the process dimension, it is four-dimensional with the addition of the product dimension. As a result, analysis can be performed from the product dimension, and the perspectives of analysis can be increased.

[0097] In this embodiment, the form of the multidimensional database being a three-dimensional database having three dimensions and a four-dimensional database having four dimensions has been described. However, the multidimensional database may be a five-dimensional or higher-dimensional database having five or more dimensions.

[0098] The information processing system for constructing the business management system according to this embodiment has been described above. However, the information processing system is not limited to the above embodiment and can have other configurations within the scope of achieving the object of the invention.

Industrial Applicability

[0099] The present invention can be used in an information processing system for performing business support and the like.

Explanation of Reference Numerals

[0100] S Information processing system N Network DD Pre-information database DB Multidimensional database 1 Server 2 Administrator terminal 3 Operator terminal 19 Communication unit 21 Registration reception unit 22 Plan creation unit 23 Performance management unit 24 Performance calculation unit 25 Display control unit

Claims

1. A multidimensional database having at least dimensions of project dimension, process dimension, and personnel dimension, A planning unit that creates a business plan including at least project information, process information, and personnel information included in each dimension of the database, A performance management unit that inputs a work start time and a work completion time for the business plan, and The multidimensional database stores hierarchical structure data including at least the project information, the process information, the personnel information, the work start time, and the work completion time. An information processing system.

2. Further having a product dimension, The planning unit creates a business plan including product information in addition to the project information, the process information, and the personnel information, The multidimensional database records hierarchical structure data including at least the project information, the process information, the personnel information, the work start time, and the work completion time, and also including product information. The information processing system according to claim 1.

3. The personnel dimension of the multidimensional database has a hierarchical structure in the order of worker information, work start time, work completion time, project information, category information, and process information. The information processing system according to claim 1.

4. The project dimension of the multidimensional database has a hierarchical structure in the order of the project information, the category information, the process information, the worker information, the work start time, and the work completion time. The information processing system according to claim 1.

5. The process dimension of the multidimensional database has a hierarchical structure in the order of the category information, the process information, the project information, the worker information, the work start time, and the work completion time. The information processing system according to claim 1.

6. The product dimension of the multidimensional database has a hierarchical structure in the order of the product information, the process information, the project information, the worker information, the work start time, and the work completion time. The information processing system according to claim 2.

Images