JP2005292998A - Data management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data management system that increases working efficiency and problem solving capability by extracting data individually managed by a plurality of organizations to provide not only an overall view of organizational management items of the organization to which a user belongs but also a view of the same management items across organizations. <P>SOLUTION: The system 10, which extracts and manages data stored and managed in databases (first local DB etc.) at a plurality of organizations respectively, when a username together with a user code is inputted, registers them in a user information table 16 of a server 10a, when management items are set and inputted, registers them in a management item table 22 in association with the user code as assigning IDs, and uses the IDs to extract and transfer organizational object data corresponding to the management items from a business database and restructures and stores them as information on the management items. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a data management system, and more particularly to a data management system that manages data of a plurality of organizations.

As an apparatus for extracting and managing data from a plurality of organizations, for example, techniques described in Patent Documents 1 and 2 below are known.
JP 2001-282818 A JP 2001-297184 A

  In the technology described in Patent Document 1, an apparatus that extracts and analyzes data from a file used by a data management system of a plurality of organizations, an analyst can freely select and set analysis items, and an analysis result A device has been proposed that can manage (save) as a history.

  In addition, in the technology described in Patent Document 2, a system has been proposed in which daily sales reports of sales representatives are aggregated and analyzed so that the sales representatives can use them for consulting of client companies. .

  In companies with multiple organizations, data is stored and managed individually in each organization's database, etc. From the viewpoint of improving work efficiency and problem solving ability, It is desirable not only to be able to overlook the management items of the business axis but also to be able to browse a plurality of organizations across the same management item. In addition, it is desirable that the management items can be arbitrarily selected.

  In that respect, the prior art described in Patent Document 1 described above has been limited to extracting and analyzing data of a plurality of tissues. Even with the prior art described in Patent Document 2, daily reports of sales representatives are only aggregated and analyzed, and can be used for consulting of client companies.

  Accordingly, the object of the present invention is to solve the above-mentioned problems, extract data individually managed by a plurality of organizations, and overlook the management items of a plurality of business axes of the organization to which the user belongs, as well as the same It is an object of the present invention to provide a data management system that can improve the work efficiency and problem solving ability by allowing a plurality of organizations to browse across the management items.

  In order to solve the above object, the present invention is the system according to claim 1 for extracting and managing data individually stored and managed in a database in a plurality of organizations, In a data management system comprising a client server system connected to a database, when a user name is entered together with a user code, the entered user name is appended with the user code and a predetermined table of the server User information registration means for registering to a management item when an item to be managed is set and inputted, and the inputted management item is associated with the user code and registered with an ID in a predetermined table of the server Target data corresponding to the management item from the database of the plurality of organizations using the registration means and the ID Data extraction and transfer means for transferring extracted for each of the plurality of tissues, and the extraction and transfer data was composed as a data storage means for storing reconstructs the information for each of the management items.

  In the data management system according to claim 2, when the name of a predetermined organization is input together with the organization code, the name of the input predetermined organization is added to the predetermined code of the server. Organization information registration means for registering in the table, and the user information registration means is configured to associate the organization code with the user code and register it in a predetermined table of the server.

  The data management system according to claim 3 further includes a user input unit that allows the user to input at least one of the management item and data via a client-side device. .

  In the data management system according to claim 4, the management item registration means attaches the ID to the input management item, determines the display position thereof, and registers it in a predetermined table of the server. Configured.

  In the data management system according to claim 5, when a reference value is set and input for the management item, the reference for registering the input reference value together with the ID in a predetermined table of the server A value registering unit is provided, and a display unit for calculating the degree of achievement of the management item by comparing the input data with the reference value and displaying it on the display.

  In the data management system according to claim 6, the reference value includes at least a target value and a threshold value corresponding thereto, and the display means sets the input data to a threshold value corresponding to the target value. The achievement degree of the management item is calculated as compared with the above.

  In the data management system according to claim 1, when an item to be managed is set, the ID is used to correspond to a management item from a plurality of organizations, more specifically, from the database of the data management system. Since the target data is extracted and transferred for each organization and reconfigured and stored as information for each management item, the user can not only overlook the management items of multiple business axes of the organization to which he belongs, A plurality of organizations can be viewed across the same management item, and the status of the organization to which the user belongs and the status of the entire plurality of organizations can be easily grasped.

  As a result, the user can reduce daily management work man-hours and concentrate more on the original work, thereby improving work efficiency and problem solving ability. In addition, since appropriate measures can be quickly taken according to the grasped situation, the constitution of the organization can be strengthened, thereby improving the productivity.

  In addition, since the configuration is such that the items to be managed are set arbitrarily, the management items can be freely selected as necessary, which makes it easier to grasp the situation and work efficiency and problem solving Since the force can be further improved and can be arbitrarily changed, the change can be easily followed at low cost.

  Here, the “business axis” means an organic relationship with respect to various business operations (production activities, budget management, etc.) performed by an organization.

  In the data management system according to claim 2, the name of a predetermined organization is registered in a predetermined table of the server with an organization code, and the organization code is registered in the predetermined table of the server in association with the user code. As a result, the user can not only see the management items of multiple business axes of the organization to which the user belongs, but also can cross-view multiple organizations for the same management item, and the situation of the organization to which the user belongs. And the situation of a plurality of organizations as a whole can be grasped more easily.

  Furthermore, by registering the organization code in association with the user code, it is possible to manage information about the user as the organization, and people belonging to the same organization are automatically used when another person in charge uses the organization code. Therefore, the same data is displayed, which makes it easy to check the contents, and also when setting security according to the hierarchy of the organization, the setting work becomes easy.

  The data management system according to claim 3 is configured to include user input means that allows a user to input at least one of management items and data via a client-side device. In addition to the effects, the management items or data can be easily modified to improve the work efficiency and problem solving ability, and the change can be tracked more easily and at a lower cost.

  In the data management system according to claim 4, since it is configured to add an ID to the input management item and determine its display position and register it in a predetermined table of the server, in addition to the effects described above, By determining and registering the display position, it becomes easier to grasp, understand or modify the management items.

  In the data management system according to claim 5, when a reference value is set and input for a management item, the input reference value is registered in a predetermined table of the server together with the ID, and the input data is Since the degree of achievement of the management item is calculated by comparison with the reference value and displayed on the display, the user can determine whether the plurality of organizations or the self is based on the degree of achievement of the desired management item calculated and displayed. The situation of the organization to which it belongs can be grasped more easily and accurately.

  In the data management system according to claim 6, the reference value includes at least a target value and a threshold value corresponding to the target value, and the input data is compared with the threshold value corresponding to the target value to achieve the management item. Since the degree is calculated, the achievement degree can be calculated more clearly.

  The best mode for carrying out a data management system according to the present invention will be described below with reference to the accompanying drawings.

  FIG. 1 is a schematic diagram showing the overall data management system.

  As will be described below, the data management system 10 according to this embodiment includes a plurality of organization databases, more precisely, a plurality of organization data management systems (local systems 12, which will be described later) databases (local DBs 1, 2, 3 which will be described later). ), And the server 10a includes various table (database) groups, that is, an organization information table 14, a user information table 16, a display position table 20, a management item table 22, and a target value table 24. And a threshold value table 26, a calculation method table 30, and a performance data table 32, and a personal computer 10b of each user (described later) connected to the server 10a via a Web screen as a client side device (illustrated) For simplicity Le computer 10b shows only one).

  As shown in the figure, the configuration of the data management system 10 displays, as “means”, steps on the flow chart showing the operation, which will be described later with reference to FIG.

  In this specification, “organization” means, for example, production bases such as manufacturing plants and factories in terms of production, branch offices, branch offices, sales offices, etc. in terms of sales, general affairs department, accounting in terms of general affairs and accounting. A group that performs some kind of business, such as a department or human resources department, and belongs to the same or common corporation or organism, but stores the same kind of business data in each database and manages them individually Is used to mean

  In this embodiment, a plurality of organizations are aggregates related to production in the above, specifically, finished products (four-wheeled vehicles, two-wheeled vehicles, etc.) or production bases for producing parts thereof, more specifically, place names, etc. It is used to mean the three production bases consisting of the A, B, and C factories.

  For simplicity of explanation, the number of tissues is three in this embodiment, but it is needless to say that the number of tissues should not be limited thereto. The number of tissues may be any number, for example, about several tens.

  A database of the data management system of the A factory is referred to as a local DB 1, that of the B factory is a local DB 2, and that of the C factory is a local DB 3. Note that the data management systems of the three organizations indicated by the local DB 1 and the like are referred to as “local systems” and are denoted by reference numeral 12 as described above.

  Next, the operation of the data management system according to this embodiment will be described with reference to the flowchart of FIG. Here, the “operation” includes a preparation process (design or construction) and its use process.

  FIG. 2 is a main flow chart showing the entire operation.

  First, preparation processing 1 is executed in S10. This means preparation processing on the data management system 10 side, that is, design or construction processing of the data management system.

  FIG. 3 is a sub-routine flowchart showing the operation.

  Referring to FIG. 3, in S100, three (a plurality of) organizations (production bases) composed of the A, B, and C factories are designated (or specified) by the manager in charge, and the personnel department and the like are designated. When automatically registered using organization information (organization code) registered in the database or input via the personal computer 10b, the input is accepted and the three specified organizations are configured. The hierarchized organization (predetermined organization described above) is registered in the organization information table (predetermined table) 14 of the server 10a with the above organization code attached. Show.

  FIG. 4 is an explanatory diagram showing the organization information table 14. The organization is a pyramid in which each production base (Manufacturer A) has one or a plurality of factories, each of which has a plurality of work departments, and further, each work team is arranged below. As shown in the figure, the organization information table 14 includes, in order from the bottom, the name of the production base (for example, A factory), the name of the factory located there (for example, the finished vehicle factory), and the like. Are displayed (description) in a hierarchical manner, such as the name of a work department (for example, an assembly section) and the name of a work group (for example, a door assembly group). Although illustration is omitted, the same kind of table is also created for other production bases (B and C).

  Production bases, factories, work departments, and work groups are each identified with an organization code as shown in the figure. In the figure, “parent / organization code” means an organization corresponding to an upper hierarchy of the organization.

  Next, the process proceeds to S102, where the person in charge (the above-mentioned user) belonging to the above-described hierarchical organization is specified by the manager in charge, and automatically using user information registered in advance in a database such as the personnel department. When the user is registered or entered through the personal computer 10b, the name of the user who receives the input is given a user code (employee number) and the organization code to which the user belongs (the above-mentioned organization) Are registered in the user information table (predetermined table) 16 of the server 10a. This process is shown as user information registration means 42 in FIG.

  FIG. 5 is an explanatory diagram showing the user information table 16. As shown in the figure, user information is registered by identifying one or more persons (for example, managers) and attaching employee numbers (user codes) in each of the organizations from the production base to the end work team. Done. The example shown in the figure is for the work team at the end. The user (name) is registered with an employee number (user code) and an organization code, so that the user and the organization to which the user belongs can be easily associated. It means that you have been granted the right to use it.

  Next, in S104, when a desired item (management item) to be managed is set by a person in charge of management or a user and inputted via the personal computer 10b, the inputted management item is accepted by the server 10a. The management item table (predetermined table) 22 is registered, and the process proceeds to S106, where an ID (item ID or management item ID) is assigned (attached) to the set management item. This process is shown in FIG. 1 as management item registration means 44 and item ID provision means 46.

  FIG. 6 is an explanatory diagram showing the management item table 22. The contents and number of management items are arbitrarily set by a manager or a user. The management items are not limited to items common to all three organizations (production bases), but may be items common only to some of the production bases, and some production bases among them. The item may be unique only to an organization in a certain hierarchy among the hierarchized organizations in.

  However, in this embodiment, the management items are items common to all three organizations (production bases), and are items that should be viewed after the achievement level is calculated. For example, the number of defects, production / processing More specifically, as shown in the figure, the number of processing failures for part A, the number of processing failures for part B, and the like are shown.

  The set management item is given an ID, and the display position is determined and registered in the display position table (predetermined table) 20 of the server 10a. FIG. 7 is an explanatory diagram of the display position table 20. This display position indicates the vertical position and the horizontal position on the screen displayed on the display of the user's personal computer 10b, so that when the user (or the person in charge of management) changes the management item, the work is performed. There is an advantage that becomes easy.

  Next, the process proceeds to S108, where the target value and threshold value (reference value to be used for calculating the achievement level) for the management item are set by the manager or the user and input via the personal computer 10b. And the threshold value corresponding to it and the threshold value corresponding thereto are registered in the target value table (predetermined table) 24 and threshold value table (predetermined table) 26 of the server 10a together with the ID described above. This process is shown as target value / threshold value registration means 50 in FIG.

  FIG. 8 is an explanatory diagram showing the target value table 24, and FIG. 9 is an explanatory diagram showing the threshold value table 26. As illustrated, the target value and the threshold value (reference value) are shown as specific numerical values. In the threshold table 26, a threshold type, a determination symbol, and a display color are also determined and registered. The threshold type is an index indicating that the degree or quantity described above is smaller or inferior in terms of the above or the quantity. For example, as shown in the figure, “below” is registered.

  In FIG. 8 and FIG. 9, “application start date” indicates a point in time when the application starts. As will be described later, data extracted from three organizations and transferred (input) (referred to as “actual data”) is compared with a threshold value, and the degree of achievement is determined based on the comparison result. The day means the day when the processing (application) is started.

  Next, the process proceeds to S110, and when the calculation method of the management item is set by the manager or the user and input via the personal computer 10b, the input is accepted and the calculation method table (predetermined table) of the server 10a together with the ID is received. Register 30. This process is shown as calculation method registration means 52 in FIG. FIG. 10 is an explanatory diagram showing the calculation method table 30. The calculation method is registered as a sum (addition) as shown in the figure, for example.

  Returning to the description of the flow chart of FIG. 2, the process proceeds to S <b> 12 and the preparation process 2 is executed. This is a preparation process on the local system 12 side.

  FIG. 11 is a sub-routine flowchart showing the operation.

  Referring to FIG. 11, a data extraction unit is created in S200. That is, a data extraction program for extracting target data from the database of the local system 12 (local DBs 1, 2, and 3) using the ID by the manager is created and installed on the local system 12 (data extraction means). Create). This process is shown as data extraction means 1, 2, and 3 in FIG. The program is created so as to extract target data for each hierarchical organization that constitutes data of each business axis managed by the three organizations.

  Next, in S202, a data transfer unit is constructed. That is, a data transfer program for transferring the data extracted by the manager in accordance with the data extraction program is created and installed on the local system 12 (data transfer means is constructed). This process is shown as data transfer means 1, 2, and 3 in FIG.

  Returning to the description of the flow chart of FIG. 2, the preparation process is completed. Note that the above processing is processing through an artificial operation by a manager or a user.

  Next, the process proceeds to S14, and the use process of the data management system 10 is executed.

  FIG. 12 is a sub-routine flowchart showing the operation.

  Referring to FIG. 12, the actual data extracted / transferred from the local system 12 in S300 is input, the process proceeds to S302, the calculation is performed according to the calculation method registered in the calculation method table 30, and the actual data table 32, that is, the extracted and transferred data is input, reconfigured into information for each management item, and stored. This process is shown in FIG. FIG. 13 is an explanatory diagram showing the processing.

  Next, the process proceeds to S304, and when a browsing command is input from the user through the keyboard or mouse from the personal computer 10b, a screen as shown in FIG. 14 is displayed on the screen of the personal computer 10b. The processing of S304 is shown as data display means 60 in FIG.

  That is, as shown in the figure, the data display means 60 compares the calculated (or accumulated) result data with the corresponding threshold value to determine the achievement level of the management item. More specifically, the data display means 60 inputs actual data extracted / transferred for each organization from a plurality of organizations according to the data extraction / transfer program described above, and the input actual data is based on the reference value described above. The degree of achievement of the management item is calculated, and the degree of achievement calculated is displayed on the display screen of the personal computer 10b according to the user's browsing command.

  In S304, when printing or downloading to another file is instructed in accordance with the user's instruction, it is executed. This process is shown as data download means 62 in FIG.

  Further, in S304, when a management item other than the management item set via the keyboard of the personal computer 10b or the like is additionally input from the user, the management item is accepted and set as in S104 and S106. In addition to registering in the item table 22, an ID is assigned, and the display position is determined and registered in the display position table 20.

  Further, when data other than the data extracted / transferred from the local system 12 is additionally input from the user via the keyboard of the personal computer 10b or the like by the user, it is accepted and the data extracted and transferred in S300 is received. As in the case, it is calculated according to the calculation method and written in the result data table 32. The additional input processing by these users is shown as data input means 64 in FIG.

  In this embodiment, as described above, when the item to be managed is set, the ID is used, and the target data corresponding to the management item is retrieved from the database of a plurality of organizations, more specifically from the database of the data management system. Since it is configured to be extracted and transferred for each organization and reconfigured and stored in information for each management item, the user can not only see the management items of multiple business axes of the organization to which they belong, but also about the same items The entire plurality of organizational systems can be browsed across, and the status of the entire plurality of organizations and the status of the organization to which the self belongs can be easily grasped.

  As a result, the user can reduce daily management work man-hours and concentrate more on the original work, thereby improving work efficiency and problem solving ability. In addition, since appropriate measures can be quickly taken according to the grasped situation, the constitution of the organization can be strengthened, thereby improving the productivity.

  In addition, since the configuration is such that the items to be managed are set arbitrarily, the items can be freely selected as needed, which makes it easier to grasp the situation and improve work efficiency and problem-solving ability. Can be further improved, and can be arbitrarily modified, thereby making it easy and low-cost to follow changes.

  In addition, since the data input means 64 is provided, the management items or data can be modified more easily, work efficiency and problem solving ability can be further improved, and change tracking can be made simpler and lower. Cost.

  In addition, by calculating and displaying the degree of achievement of a desired item, the user can more easily and accurately grasp the situation of the entire plurality of organizations or the organization to which the user belongs.

  As described above, this embodiment is stored in a database in each of a plurality of organizations, and more specifically, stored in a database (local DB1, DB2, DB3) in each of the data management systems (local systems 12) of the plurality of organizations. In the data management system 10 comprising a client server system connected to the databases of the plurality of organizations, the user name is input together with the user code. At this time, user information registration means (42, S10, S102) for registering the inputted user name in the predetermined table (user information table 16) of the server 10a with the user code, items to be managed are When set and input, the input management item is changed to the user code. Management item registration means (44, 46, S10, S104, S106) for registering a predetermined table (management item table 22) of the server 10a with an ID (item ID or management item ID) associated therewith, the ID The data extraction / transfer means (data extraction means 1, 2, 3 and data transfer means 1) for extracting the target data corresponding to the management item from the databases of the plurality of organizations for each of the plurality of organizations and transferring them. , 2, 3, S12, S200, S202), and data storage means for reconstructing and storing the extracted / transferred data into information for each management item (actual calculation means 54, actual data tables 32, S14) , S300, S302).

  Further, when the name of a predetermined organization is input together with the organization code, the organization name to which the input name of the predetermined organization is added and registered in a predetermined table (organization information table 14) of the server 10a. In addition to providing information registration means (40, S10, S100), the user information registration means is configured to associate the organization code with the user code and register it in a predetermined table of the server (S102).

  Furthermore, user input means (data input means 64, S14, S304) that enables the user to input at least one of the management items and data via the client side device (personal computer 10b) is provided. Configured.

  The management item registering unit is configured to attach the ID to the input management item, determine a display position thereof, and register it in a predetermined table (display position table 20) of the server.

  Further, when a reference value (reference value to be used for calculating the achievement level) is set and inputted for the management item, the inputted reference value is registered in the predetermined table of the server 10a together with the ID. Reference value registration means (target value / threshold value registration means 50, S10, S108) is provided, and the degree of achievement of the management item is calculated by comparing the input data with the reference value for display (personal A display means (data display means 60, S14, S304) for displaying on the display of the computer 10b is provided.

  The reference value includes at least a target value and a threshold value corresponding to the target value, and the display means compares the input data with a threshold value corresponding to the target value to determine the achievement level of the management item. The calculation is performed (S304).

  In the above description, the management items, target values, threshold values, determination symbols, and the like are examples, and it goes without saying that the present invention is not limited to the illustrated configuration.

1 is a schematic diagram showing an overall data management system according to an embodiment of the present invention. It is a main flow chart which shows operation | movement (process) of the data management system shown in FIG. FIG. 3 is a sub-routine flow chart showing preparation processing on the data management system side in the operation shown in FIG. 2 flow chart; 3 is an explanatory diagram of an organization information table used in the processing of the flow chart. 3 is an explanatory diagram of a user information table used in the processing of the flow chart. 3 is an explanatory diagram of a management item table used in the processing of the flow chart. 3 is an explanatory diagram of a display position table used in the processing of the flowchart. 3 is an explanatory diagram of a target value table used in the processing of the flow chart. 3 is an explanatory diagram of a threshold value table used in the processing of the flow chart. 3 is an explanatory diagram of a calculation method table used in the processing of the flow chart. FIG. 3 is a sub-routine flow chart showing preparation processing on the local system (data management system of a plurality of organizations) side in the operation shown in FIG. 2 flow chart; FIG. 3 is a sub-routine flow chart showing use processing of the data management system according to the embodiment in the operation shown in the flow chart of FIG. 2. It is explanatory drawing which shows the utilization process of the data management system which concerns on an Example in operation | movement shown in FIG. It is explanatory drawing which shows the screen on the display of a user's personal computer browsed (displayed) by data browsing operation | movement among the operations shown in FIG.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Data management system 10a Server 10b Personal computer 12 Local system (Data management system of several organizations)

Claims (6)

A system for extracting and managing data individually stored and managed in a database in a plurality of organizations, the data management system comprising a client server system connected to the databases of the plurality of organizations,
a. User information registration means for registering the input user name in the predetermined table of the server with the user code when the user name is input together with the user code;
b. A management item registration means for registering an input to a predetermined table of the server that associates the input management item with the user code when an item to be managed is set and input;
c. Data extraction / transfer means for extracting and transferring target data corresponding to the management item for each of the plurality of organizations from the database of the plurality of organizations using the ID;
And d. Data storage means for reconstructing and storing the extracted / transferred data into information for each management item,
A data management system comprising: further,
e. Organization information registration means for registering the inputted name of the predetermined organization in the predetermined table of the server with the organization code when the name of the predetermined organization is inputted together with the organization code;
The data management system according to claim 1, wherein the user information registration unit registers the organization code in a predetermined table of the server in association with the user code. further,
f. User input means for enabling the user to input at least one of the management items and data via a client-side device;
The data management system according to claim 1, further comprising:   4. The management item registration unit adds the ID to the input management item, determines a display position thereof, and registers the management item in a predetermined table of the server. The data management system described. further,
g. Reference value registration means for registering the input reference value in the predetermined table of the server together with the ID when a reference value is set and input for the management item;
5. The data according to claim 3, further comprising: a display unit configured to calculate an achievement level of the management item by comparing the input data with the reference value and display the data on a display. Management system. The reference value includes at least a target value and a threshold value corresponding to the target value, and the display means compares the input data with a threshold value corresponding to the target value to calculate the achievement level of the management item. 6. The data management system according to claim 5, wherein:

Images