JP2001052028A - Data management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a data management system where progress information is shared and is easily written simultaneously from plural terminals and processing data are perused in real time. SOLUTION: The data management system is provided with a server 1 which accesses a data base to input and output data and plural terminals 10 which can access the data base of the server 1 through a network 9. Since plural terminals 10 share the data base of the server 1 and the server 1 is provided with progress management software 3 which directly manages the progress level of data processing, a data writer only for the server 1 is unnecessary, and progress information is shared and easily written simultaneously from plural terminals, and the progress state of processing data are perused in real time.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention is applied to, for example, a data management system for accessing a database on a network.

[0002]

2. Description of the Related Art Conventionally, an API (Ap
application Programming Int
programming using Perl) or Perl
Language-based CGI (Common Gateway)
Management of the progress of program development has been performed by using an interface technology or by using commercially available web collaboration software.

[0003]

However, in the above-described conventional technology for managing the progress of program development, it takes time to develop the program, and there is a problem of a license fee for commercial software. There is a disadvantage that writing cannot be easily performed.

[0004] Further, when an Excel file for information management is simply placed on a server on a network without sharing the information on the Web and the file is accessed from each terminal, writing is not performed. In some cases, the terminal that has been executing writing for a while occupies the file, so that there has been an inconvenience that writing cannot be performed from a plurality of terminals at the same time.

In the above-mentioned method, when a data file in Excel format for progress management is loaded on a terminal and the file is opened, a large amount of file data must be transferred from a server on the network to the terminal at one time. Therefore, there is an inconvenience that it takes time to load data.

In addition, in the case of the above-mentioned method, since writing cannot be performed from a plurality of terminals at the same time, a writing staff is required to be dedicated, so that there is an inconvenience that a man-hour for writing is required.

In the case of the above-mentioned method, the data loaded by the viewer from the server is time-delayed until the person in charge of writing enters a state in which input of writing data from a plurality of evaluators is completed. There was no real-time processing data. For this reason, there was a problem that the processing data could not be browsed in real time, and the determination of the problem could be delayed.

[0008] The present invention has been made in view of the above points, and a data management system capable of sharing progress information, easily writing from a plurality of terminals at the same time, and browsing processed data in real time. It is intended to propose.

[0009]

In order to solve the above-mentioned problems, a data management system according to the present invention provides a data-accessible server by accessing a database and a database capable of inputting and outputting data via a network. In a data management system having a plurality of accessible terminals, the plurality of terminals share the database of the server, and the progress management unit capable of directly managing the progress level of data processing is provided on the server. It is provided in.

According to the present invention, the following operations are performed. From the browser on the terminal, input information from the terminal using the information input unit of the progress management unit, browse information input by the browsing unit of the progress management unit, and input information by the search unit of the progress management unit The keyword search and the graph display are performed, and the information searched by the analysis unit of the progress management unit is analyzed and the graph is displayed.

Further, the update information is transmitted by e-mail to a predetermined terminal at the time of updating by the mail delivery section of the progress management section, the change history is accumulated by the history accumulation section of the progress management section, and the table is changed by the specification change section of the progress management section. Various setting information and input / output data are changed for each destination according to various uses.

[0012]

Embodiments of the present invention will be described below in detail with reference to the drawings. The data management system according to the present embodiment uses a web browser from a terminal of each client to read, write, search, etc., the work progress information on the network when a joint work such as program development is advanced. Something to share.

The data management system according to the embodiment will be described below. FIG. 1 is a diagram showing characteristics of a progress system applied to the data management system of the present embodiment. In FIG. 1, the progress system according to the present embodiment includes:
It comprises a server 1 and a terminal 10 connected to the server 1 via a network 9. Network 9 is a document data file transfer protocol, HTTP.
(Hyper Text Transfer Prot
ocol).

The server 1 searches the distributed database on the network 9 from the terminal 10 and shares the database of the server from a plurality of terminals with the web server 2 which can access the data of the database. It comprises progress management software 3 capable of managing the progress level, an access file 7 for data access, and an Excel file 8 for progress management. The access file 7 and the Excel file 8 constitute a database (DB).

An ASP (ActiveServerPanel) of an optional module attached to the web server 2 is also provided.
ge) 4 and ADO (Active Da) module that can easily handle files that work on the server side
ta Object) 5 and an ODBC (Open Data Base Con) for interconnecting the database.
2) is provided.

The terminal 10, which is a personal computer (PC) of each client, is provided with a web browser 11 on the terminal 10, which can perform an operation for managing the progress of data processing of the server 1.

The operating system (OS) on the server 1 side and the terminal side is mainly an MS window developed by Microsoft Corporation, but other operating systems such as UNIX running on a personal computer (PC) also use the main software described above. If there is, a similar system can be configured.

The web server 2 is, for example, a web server software called IIS Web SERVER that runs on Windows NT SERVER OS, or Windows NT Worksst.
Peer Web Ser that runs on the OS
There is web server software called "vice".

The features of the progress system thus configured according to the present embodiment will be described below. Web Browser 1
In step 1, the operation of managing the progress of the data processing of the server 1 is performed on the terminal 10 of each client. From a plurality of terminals, the progress management software 3 can share the database of the server and directly manage the progress level of the data processing.

Specifically, first, the access file 7
To the Excel file 8 can be easily converted, so that the data can be easily processed on the terminal. Second, software is not required other than the above-described operation system (OS) on the server 1 side and the terminal side, and the system is inexpensive. Third, it can be easily diverted to various design tasks other than the above-mentioned use of progress management during software development. Fourth, the information of the server 1 can be shared from the terminal 10 in real time, and the work response is improved. Fifth, since data can be written from a plurality of terminals at the same time, a dedicated data input person is not required. Also,
Sixth, dedicated software other than the general browser 11 is not required on the terminal side. Seventh, for example, 2000
It is most suitable for the operation of the progress management of software development.

As described above, conventionally, the progress information is shared from the terminal using the Microsoft Excel file on the server on the LAN network, but by using the progress management software 3 of the present embodiment, It has the merit of meeting real-time requirements and eliminating the need for a dedicated worker to write progress information.
It is possible to configure a progress management system effective in progress management in the field.

FIG. 2 is a diagram showing an outline of the progress system of the present embodiment. In FIG. 2, a server 1 is provided with a web server 2 and progress management software 3, and the progress management software 3 browses information input from an information input unit 20 for inputting information from a terminal 10. Reading unit 21
A search unit 22 for searching the input information, an analysis unit 23 for analyzing the searched information, a mail delivery unit 24 for sending update information to a predetermined terminal by mail, and accumulating a change history. It is configured to include a history storage unit 25, a specification change unit 26 that tabulates various setting information and input / output data according to various uses, and a graph display unit 28.

The terminal 10 is connected to the destination 27 via the network 9 according to the destination 27, for example, the first department 27-1 and the second department 27-1.
Division 27-2, first to third group of third division 27-3, second to fourth group of fourth division 27-4
A plurality 10-1 to 10-7 are provided corresponding to the groups.

The progress system configured as described above operates as follows. From a web browser on the terminal 10, information is input from the terminal 10 by the information input unit 20, and the input information is viewed by the viewing unit 21.
The search unit 22 performs keyword search and graph display of the input information, the analysis unit 23 analyzes the searched information, and the graph display unit 28 displays a graph.

Further, at the time of updating, the mail delivery unit 24 sends update information to a predetermined terminal by mail,
The change history is accumulated by 5 and various setting information and input / output data are changed for each destination 27 according to various uses tabulated by the specification changing unit 26.

The specification changing unit 26 also tabulates display items and display data at once, and selects and uses different table data for each application so that the same progress management software 3 can cope with various applications. It has become.

That is, the specification change unit 26 is configured to prepare table data for different destinations by using the same software program so that the destination can be easily changed. Specifically, since the database name for each application set in the server 1 is different depending on the destination application, by changing the database name, it is possible to have a role as a switch flag for the data in the table, thereby enabling various applications. The management of the software for the customer can be simplified.

In this regard, the conventional general idea is to use a separate switch flag for the database name and the destination application, and to manage the source by managing two items, the destination by application and the database name. Was necessary, so there was a concern that the information would be complicated. But,
As described above, the specification change unit 26 of the present embodiment can simplify management of software for various uses. Thereby, work efficiency can be improved by sharing information of software evaluation.

However, the above-described specification change unit 26 of the present embodiment cannot use the same database name for the same purpose in the same server personal computer (PC), but the server personal computer (P
Considering the price of C) and operation management, if it is desired to use the same database name for different and similar applications, there is no particular problem if the same database name is used on another server personal computer (PC). Switching can be simplified by switching the computer (PC).

FIG. 3 is a diagram showing management of the web progress system according to the present embodiment. 3, a terminal 10 of a progress information writer and a viewer 35 is connected to a web server 2 and a server 1 having an access file 7 via a network 9, and further connected to the server 1 via the network 9. Manager of progress information
4 terminals 30 are connected.

The terminal 30 of the manager 34 includes a file backup unit 31 for backing up the access file 7 of the server 1 and an access ID management unit 3 for managing an access ID (identification number) for the access file 7.
2 and a data analysis unit 33 for analyzing the data of the access file 7.

Note that, on the network 9, Windows
PC / WS (workstation) using wsOS or TCPIP (Transmission Control)
rol Protocol / Internet Pro
LAN (Local A)
area is established between the terminal 30 and the terminal 10.

The management operation in the web progress system configured as described above will be described below. Network 9
Since the file holder of the access file 7 of the server 1 can be mounted on the terminal 30 above, that is, it can be used as a pseudo drive unit,
The specific administrator 34 can manage and operate the database access file 7 operated by the web server 2 by backing up, managing the access ID (identification number), analyzing the data, and the like. Network 9
On the terminal 30, management such as writing, appending, and deletion of management information to a management access file can also be performed.

Hereinafter, each function of the progress system according to the present embodiment will be described with reference to corresponding screen displays. First,
The table of contents page is displayed, and the user can jump to an item of each function screen, which will be described later, displayed on the table of contents table by clicking with the mouse.

FIG. 4 is a diagram showing a list screen according to the present embodiment. In FIG. 4, each column N
O. 1 to NO. For item 6, items such as progress, ranking, screen, trigger, phenomenon, discovery date, discoverer, version, correction date, countermeasure, countermeasure version, confirmation date, symptom, cause, countermeasure, etc. are displayed in a list. Here, a progress mark is displayed in the progress item. The meanings of the progress marks are as follows: □ is a discovered problem and its cause is still unknown, ○ is cause found / no action taken, ◎ is continued evaluation with action taken, ● is action taken, △ is action as it is,
? Represents not reproduced / examined but not understood, × represents the previous position, ★ represents OK without reproduction, and Δ represents suspension.

Also, "new registration", "search", "analysis", "operation explanation", "meaning of progress mark", "first page display", "next page", "previous page", "last page""Button is displayed. In particular, when the “new registration” button 41 is pressed, the screen shifts to a new entry screen shown in FIGS. 1 to NO. By clicking the numeral number at the head of No. 6 with a mouse, the screen shifts to the editing screen shown in FIG. The screen can be changed to a search condition setting screen, a new registration screen, an analysis screen, and a graph screen from this screen.

The browsing unit 22 of the progress management software 3 displays the background color of the item column or the progress column in a predetermined color according to the progress level so that the progress can be easily viewed. In other words, when the progress term is ●: countermeasures are completed, the background color of the countermeasure column is green, and when the progress term is ◆: as it is, the background color of the countermeasure column is blue, and the progress term is ×: previously described. At this time, the background color of the countermeasure column is set to yellow, and when the progress item is ★: not reproduced, the background color of the countermeasure column is set to magenta to indicate that progress has been made and no countermeasure is required.

When the progress item is □: found, the background color of the progress item is red, and when the progress item is ：: the cause is unknown,
The background color of the progress item is set to pink, and when the progress item is 保留: pending, the background color of the progress item is set to magenta to indicate that no progress is required and a countermeasure is required.

FIG. 5 is a diagram showing an editing screen according to the present embodiment. In FIG.
1 to NO. Regarding 5, items such as progress, ranking, screen, trigger, phenomenon, discovery date, discoverer, version, correction date, countermeasure, countermeasure version, confirmation date, symptom, cause, countermeasure, etc. are displayed in an editable manner. Here, a progress mark is displayed in the progress item. In addition, "search", "analysis", "operation description", "meaning of progress mark", "display first page", "next page", "previous page", "last page"
Each button is displayed.

FIGS. 6 and 7 are diagrams showing a new entry screen according to the present embodiment. In FIG. 6, a new entry screen 60 is displayed.
Then, the progress items are □: found, ○: unknown cause, ◎: continuous evaluation with measures taken, Δ: waiting for evaluation with measures taken, ●: measures taken,
◆: As it is? : Unknown, ×: See above, ★: O without reproduction
K, ◇: Scroll and select any of the pending selection items. The rank item is selected by scrolling any of the selection items A, B, and C. The screen item, the trigger item, and the phenomenon item are respectively recorded by selecting the entry selection item 61 of "written entry ⇒" and pressing the registration button 71 in the text input section on the right side. .

In FIG. 7, on the new entry screen 70, the words entered in the text input section for each item of symptoms (description of bug), cause, and countermeasures are recorded by pressing the registration button 71.

Each of the above-mentioned entry items can be selected and input by scrolling any of the selection items of the word entered in the past.

Such a method of selecting and inputting past entry words is to check all the values of this term in the server database, and to issue an SQL command to the database for displaying the same contents without displaying them. Is issued by the information input unit 20 of the progress management software 3, it is possible to delete the ridiculous values from the values of this item in the database and take them out in order, and to display the retrieved values.

In the following, an SQL instruction for taking out the data in the Gamen field (term) so as not to spill it is shown as follows: sql = “SELECT Gamen, Count (G
amen) as Gamen_count FROM
[DB name] Group by Gamen ”.

When the editing screen is displayed, it is natural that the data recorded so far is displayed in the entry column, and the selection items such as the progress items are replaced with the selection items previously recorded. The selected state is displayed by displaying the mark of the previously recorded selection item in the background so that the user can see at a glance which state the user was in. Thus, when the update button is pressed without performing any updating at the time of updating, the value is recorded in the database in the server in the same state as the previously recorded value.

As described above, when the "new registration" button 41 is pressed on the list display screen 40, the screen shifts to the new entry screens 60 and 70. On the new entry screens 60 and 70, the contents of the defect are described in the necessary item fields, and the new registration is performed by pressing the registration button 71 at the bottom.

When updating the registered contents,
In the list display screen 40, each column NO. 1 to NO. By clicking the numeral number at the beginning of the number 6 with the mouse, the screen shifts to the edit screen. By updating the contents of the necessary item fields on the edit screen and pressing the update button at the bottom, update registration is performed.

In the new entry screen 60, when the items of the screen, trigger, phenomenon, discoverer, countermeasure, etc. are newly entered, the words and phrases are inputted from the beginning in the text input section on the right side of each item and registered. Registration is performed by pressing the button 71, and from the next time, the word is displayed in the selection item as a word that can be selected in each item, so that the word can be selected or newly input. . After the registration processing on the new entry screen, the screen shifts to the list screen. After the update processing on the edit screen, the screen shifts to the list screen.

FIGS. 8 and 9 are diagrams showing a search input screen according to the present embodiment. In FIG. 8, a search input screen 80 is shown.
Then, the progress items are □: Discovery, ○: Unknown cause, ◎: Continued evaluation with measures taken, ●: Measured, △: As it is,? : Unknown, ×: Previous, ★: OK without reproduction, Δ: Scroll and select any of the reserved items. The rank item is selected by scrolling any of the selection items A, B, and C.

Screen item, trigger item, phenomenon item, discoverer item, and search input screen 9 in search input screen 80
For the version item and countermeasure item at 0, the user can scroll and select any one of the registered words 81 registered in advance. The selection and input functions at the time of this search are realized using the same software module as at the time of new entry and update at the time of the above-mentioned. I didn't have it because I didn't need it.

At this time, by pressing the graph button 91 on the search input screen 90, the search results under the conditions set in the search conditions can be displayed in a graph.

As described above, on the search input screens 80 and 90, a plurality of items such as screens, triggers, phenomena, and countermeasures can be selected. The selection method is the control key (CT
L) can be selected by clicking with the mouse while pressing.

At the time of retrieval, a plurality of words in each selected item can be specified at a time. To realize this processing, S
If the QL command is not a single word AND (AND) search, the search unit 22 of the progress management software 3 issues an SQL command to the database in such a manner that items specified by the plurality of words are treated as being ignored. . As a result, the selection in this section is ignored, and as a result, the AND condition with other terms is deviated, and all the target recorded words in this section are incorporated by the SQL instruction.

The following is an example of a specific processing outline of the processing program when the present search processing is executed.

[0055]

(Equation 1)

A specific description of the outline of the above-described search processing will be described below. Search condition input screen page (Kens
akuInput. asp) is retrieved by the search unit 22 of the progress management program 3 according to the present embodiment. First, the obtained search condition information is displayed at the top of the screen. (./Kensak
u / KensakuExec GETDisp. in the inc file)

Thereafter, the number of AND terms is grasped and it is determined whether there are a plurality of words in the AND terms. If there are a plurality of words, the words are cut out and put into a work, and a flag is set for each term. (./Ke
nsaku / KensakuExecGETETAND. i
Then, an SQL command is set based on the number of AND terms.
(./Kensaku/KensakuExecSQL
ANDSET. in the inc file)

Next, an SQL instruction is executed. Then, the head of the table is displayed. (HeadLine.inc
Next, in accordance with each JMP button, using the judgment of the search condition, the records matching the judgment of the search condition are counted, and the blank reading corresponding to each JMP button is performed, and the display start line counter is obtained. (./KensakuKensakuExec
Bool123. inc) (./ KensakuKen
sakuExecBoolCMP123. inc)

Next, records matching the line counter of the record to be displayed are displayed in a maximum of 50 lines. (./
Kensaku KensakuExecBool12
3. inc) (./ KensakuKensakuEx
ecBoolCMP123. inc) (MSBugLi
stMain. inc) After displaying, count the records that match the search condition,
Find the total number of records that match the search conditions. (./Ke
nsakuKensakuExecBool123. i
nc) (./ KensakuKensakuExecB
coolCMP123. inc) Then, a button display process is performed. (./Kensak
u / KensakuExecButtontonyouj
i. inc)

FIGS. 10 and 11 show search result screens according to the present embodiment. In FIGS. 10 and 11, search result screens 100 and 110 have respective column numbers. 23
2,245,249,264,268,281,34
9,358,391,392,398,403,40
For 6,408,421, items such as progress, ranking, screen, trigger, phenomenon, discovery date, discoverer, version, modification date, countermeasure, countermeasure version, confirmation date, symptom, cause, etc. are searched together with the search condition display. The result is displayed. Finally, the display total and the total number in the search result display are displayed. Here, a progress mark is displayed in the progress item.
The meanings of the progress marks are as follows: □ is a discovered problem and the cause is still unknown, ○ is the cause found and no measures are taken, ◎ is a continuation evaluation with measures taken, △
Waiting for evaluation, measures for ●, measures for ◆, Represents not reproduced / examined but not understood, × represents the previous position, ★ represents OK without reproduction, and Δ represents suspension.

FIG. 12 is a diagram showing an analysis table of contents according to the present embodiment. In FIG. 12, an analysis table of contents screen 120 is displayed.
Displays a table of contents such as progress item related analysis, countermeasure related analysis, by discoverer, and graph of the number of cases in time series. FIG.
FIG. 8 is a diagram showing a countermeasure screen of the present embodiment. FIG.
In the countermeasure screen 130, the number of cases for each progress item with respect to the countermeasure name is displayed in a table format. FIG. 14 is a diagram showing a time-series analysis graph screen of the present embodiment. In FIG. 14, the analysis graph screen 140 displays the total number of cases and the number of processed cases with respect to the date in the form of a bar graph.
When the cursor is moved to the bar graph, the value indicated by the bar graph is displayed.

FIG. 15 is a diagram showing a mail transmission update screen according to the present embodiment. In FIG. 15, an update screen 15
0 indicates that the content of the update process is transmitted to a predetermined client terminal during the update process. The update screen 150 is an example in which the transmitted mail is received by the terminal.

FIG. 16 is a diagram showing a change history screen according to the present embodiment. In FIG. 16, a change history screen 160
Indicates the date, date, writer,
Progress, ranking, symptom, cause, countermeasure, and date of each update, updater, progress, ranking, symptom, cause, countermeasure are recorded. Thus, at the time of registration and update, the change history is recorded in the database. When viewing the change history, pressing the [display only button] on the list display screen 40 brings up a browse mode screen, and the change history of a specific record can be viewed by selecting a number in the browse mode screen.

FIG. 17 is a diagram showing a USA version list screen according to the present embodiment. In FIG. 17, on the USA version list screen 170, each item of the list screen 40 shown in FIG. 4 is displayed in English characters. USA version list screen 17
0 is the specification change unit 26 of the progress management software 3 of the server 1
By simply preparing another table of display data and switching the table data, specifications can be easily changed.

FIG. 18 is a diagram showing an approval screen according to the present embodiment. In FIG. 18, on an approval screen 180, items of items approved from a terminal of a predetermined client to a server are displayed. All of the statuses in the progress column are "measured" and the like, and this progress status is approved.

FIG. 19 is a diagram showing a mail transmission update button according to the present embodiment. In FIG. 19, an edit screen 190
By pressing the [email transmission update button] 191 at the time of update, the e-mail with the contents of the update screen 150 shown in FIG. 15 can be transmitted. Further, by pressing an [update button] 192, the content is updated without mail.

The client IP (Intern)
(E. Protocol) address is described or input in a data table or DB (database) or program on the server side, thereby restricting access from the client to the server.

The data management system according to the present embodiment accesses the database 1 by accessing the database, and the access file 7 and the Excel file 8 serving as the database of the server 1 via the network 9. A plurality of accessible terminals 10
In a data management system having
Since the server 1 is provided with the progress management software 3 as a progress management unit capable of directly managing the progress level of data processing by sharing the database of the server 1 from the 0 side, a dedicated data entry person for the server 1 is provided. Is unnecessary, the progress information can be shared, writing can be easily performed from a plurality of terminals at the same time, and the progress status of the processing data in real time can be viewed.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit includes the search unit 22 as search means for displaying search results in a time-series graph at the time of data search. Therefore, the ratio of the number of completed cases and the number of uncompleted cases to the total number of cases can be determined at a glance in a time series.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit displays a list of data input at the time of data input for each item, and displays the list at the time of re-input. Has an information input unit 20 as an input means for selecting an arbitrary item from, so that the user does not need to input the same data again at the time of editing input,
Operability can be improved.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit includes the setting change means and the input / output data according to various uses. Specification change part 2
6 so that you can flexibly change the name of each item or the number, type and function of each item for each use.
By simply preparing another table of display data, the same software can be easily used, maintenance such as function update can be easily performed, and maintainability can be improved.

In the data management system according to the present embodiment, the progress management software 3 as the progress management section is configured to display any item of data processing in a specific background color according to the progress level. Since it has the browsing unit 21 as a means, when the progress level is advanced and the progress has been completed,
The specific item is displayed in the background color, and it can be determined at a glance that the progress has been made, and the visibility of the progress can be improved.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit displays the data processing progress level item in a specific background color according to the progress level. Since the browsing unit 21 is provided as a display unit, when the progress level is not progressing and the progress is not progressing, the progress level items are displayed in the background color to determine at a glance that the progress is not progressing. Can be improved.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit is configured such that when the data input at the time of data input is displayed in a list for each item, the data is input at the time of data input. Since there is a browsing unit 22 as a display means for displaying a list from the data obtained,
The state edited by inputting data can be confirmed on the list display screen, and operability can be improved.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit is different from the search unit as a selection means for selecting a plurality of search terms from search items at the time of data search. Since there are 22 search conditions, the search conditions can be arbitrarily set, and the number of search cases can be narrowed down and the range of the number of search cases can be set.

In the data management system according to the present embodiment, the progress management software 3 as a progress management unit is used as a display means for displaying search condition information when displaying a search result at the time of data search. , The search result can be analyzed according to the number of selected or unselected items of the search condition information.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit, when displaying the analysis result at the time of data analysis, displays the progress level of each countermeasure in a table. Since the analysis unit 23 is provided as a display means for displaying, it is possible to analyze the progress of each countermeasure in a table.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit performs the registration or update processing at the time of registration or update processing in a predetermined manner of the plurality of terminals 10. The provision of the mail delivery unit 24 as a transmission means for sending an e-mail to the terminal 10 makes it possible to provide an e-mail delivery service to a specific terminal 10 whose update information is predetermined.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit includes the history storage unit 25 as storage means for storing a change history at the time of data input or update processing. , The change history of the data processing can be browsed.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit includes the approval for performing the approval of the data processing progress level from the plurality of terminals 10 to the server 1. Since the information input unit 20 is provided as a means, when the progress level is advanced and progress has been completed, approval data can be recorded.

In the data management system according to the present embodiment, the progress management software 3 as the progress management unit is different from the browsing unit as a restricting means for restricting data access from a plurality of terminals 10 to the server 1. Since the terminal 21 is provided, it is possible to restrict data access and perform data communication within a specific permitted group at the time of simultaneous access from the unauthorized terminal 10.

In the above-described embodiment, an example is described in which the progress management of the program development is performed by the progress management software 3. However, the present invention is not limited to this. It may perform progress management of data processing. It should be noted that a system refers to a system in which a plurality of devices are logically assembled, and it does not matter whether or not the devices of each configuration are in the same housing (the same applies to the claims).

[0083]

The data management system of the present invention has a server capable of inputting / outputting data by accessing a database, and a plurality of terminals capable of accessing the database of the server via a network. In the data management system, since the plurality of terminals share the database of the server and a progress management unit capable of directly managing the progress level of data processing is provided in the server, dedicated data for the server is provided. This eliminates the necessity of a writer and allows the progress information to be shared so that writing can be easily performed from a plurality of terminals at the same time, so that the progress of the processing data in real time can be viewed.

Further, in the data management system of the present invention, the progress management section has a search means for displaying a search result in a time-series graph at the time of data search. In addition, it is possible to determine the ratio of the number of unfinished cases at a glance.

Further, in the data management system according to the present invention, in the above, the progress management section displays a list of data input at the time of data input for each item, and selects an arbitrary item from the list at the time of re-input. Since the input means is provided, the user does not need to input the same data again at the time of editing and inputting, so that operability can be improved.

In the data management system according to the present invention, the progress management section has a specification changing means for tabulating various kinds of setting information and input / output data according to various uses. You can flexibly change the name, number, type and function of each item, and even for English culture, simply preparing a separate table for display data,
The same software can be easily used, and maintenance such as function update can be easily and easily performed, so that maintainability can be improved.

Further, in the data management system according to the present invention, in the above, the progress management unit is configured to perform the following operations according to the progress level.
Since there is a display means for displaying any item of the data processing with a specific background color, when the progress level is advanced and progress has been made, the specific item is displayed in the background color and it is determined at a glance that the progress has been made. Thus, there is an effect that the visibility of the progress can be improved.

Further, in the data management system according to the present invention, in the above, the progress management unit includes:
Since there is a display means for displaying the progress level item of the data processing with a specific background color, when the progress level is not advanced and not progressed, the progress level item is displayed with the background color and the progress status is not progressed. This can be determined at a glance, and the effect of improving the visibility of the progress can be obtained.

Further, in the data management system according to the present invention, in the above, the progress management unit displays the data input at the time of data input in a list for each item, based on the data input at the time of data input. With the display means for displaying, it is possible to check the state of data input and edited on the list display screen, and it is possible to improve the operability.

Further, in the data management system according to the present invention, the progress management unit has a selection means for simultaneously selecting a plurality of search terms from within a search item at the time of data search. As a result, it is possible to narrow down the number of searches and set the width of the number of searches.

In the data management system of the present invention, the progress management unit has display means for displaying search condition information at the time of data search and when displaying search results. There is an effect that the search result can be analyzed in accordance with the number of selected or unselected items.

Further, in the data management system of the present invention, the progress management unit has display means for displaying the progress level of each countermeasure in a table when displaying the analysis result at the time of data analysis. In addition, there is an effect that the analysis can be performed by tabulating the progress of each countermeasure.

Further, in the data management system of the present invention, the progress management unit has a transmission means for transmitting update information to a predetermined terminal among the plurality of terminals by e-mail at the time of update processing. There is an effect that a service of mail distribution can be provided to a specific terminal which has predetermined update information.

Further, in the data management system of the present invention, the progress management section has a storage means for storing a change history at the time of data input or update processing.
There is an effect that the change history of the data processing can be browsed.

Further, in the data management system of the present invention, the progress management unit includes an approval unit for approving the progress level of data processing from the plurality of terminals to the server. When the process is advanced and has been completed, the effect is obtained that the approval data can be recorded.

Further, in the data management system of the present invention, in the above, the progress management unit has a restriction means for restricting data access to the server from the plurality of terminals, so that access from an unauthorized terminal is not possible. In this case, there is an effect that data access is restricted and data communication can be performed.

[Brief description of the drawings]

FIG. 1 is a diagram showing features of a progress system according to an embodiment of the present invention.

FIG. 2 is a diagram showing an outline of a progress system according to an embodiment of the present invention.

FIG. 3 is a diagram showing management of a progress system according to the embodiment of the present invention.

FIG. 4 is a diagram showing a list screen according to the embodiment of the present invention.

FIG. 5 is a diagram showing an editing screen according to the embodiment of the present invention.

FIG. 6 is a diagram showing a new entry screen according to the embodiment of the present invention.

FIG. 7 is a diagram showing a new entry screen according to the embodiment of the present invention.

FIG. 8 is a diagram showing a search input screen according to the embodiment of the present invention.

FIG. 9 is a diagram showing a search input screen according to the embodiment of the present invention.

FIG. 10 is a diagram showing a search result screen according to the embodiment of the present invention.

FIG. 11 is a diagram showing a search result screen according to the embodiment of the present invention.

FIG. 12 is a diagram showing an analysis table of contents according to the embodiment of the present invention.

FIG. 13 is a diagram showing a countermeasure screen according to the embodiment of the present invention.

FIG. 14 is a diagram illustrating a time-series analysis graph screen according to the embodiment of this invention.

FIG. 15 is a diagram showing a mail transmission update screen according to the embodiment of the present invention.

FIG. 16 is a diagram showing a change history screen according to the embodiment of the present invention.

FIG. 17 is a diagram showing a USA version list display screen according to the embodiment of the present invention.

FIG. 18 is a diagram showing an approval screen according to the embodiment of the present invention.

FIG. 19 is a diagram showing a mail transmission update button according to the embodiment of the present invention.

[Explanation of symbols]

1 ... Server 2 ... Web server 3 ... Progress management software 4 ... ASP 5 ... ADO 6 ... ODB
C, 7 ... access file, 8 ... Excel file, 9 ... network, 10 ... terminal, 11 ... browser, 20 ... information input unit, 21 ... browsing unit, 22 ...
Search unit, 23 Analysis unit, 24 Mail delivery unit, 25
... History storage unit, 26 ... Specification change unit, 27 ... Destination, 30 ... Terminal, 31 ... File backup unit,
32 access ID management unit 33 data analysis unit
34 ... administrator, 35 ... viewer and writer, 4
0 ... List display screen, 41 ... New registration button, 42 ... Number, 50 ... Edit screen, 60 ... New entry screen, 61 ...
... entry selection item, 70 ... new entry screen, 71 ... registration button, 80 ... search input screen, 81 ... already registered selection item, 9
0: search input screen, 91: button for graph, 100:
Search result screen, 110: Search result screen, 120: Analysis table screen, 130: Countermeasure screen, 140: Analysis graph screen, 150: Update screen, 160: Change history screen, 161: History item , 170 ... USA version list screen, 180 ... Approval screen, 190 ... Edit screen, 191
…… Update button for sending mail, 192 …… Update button

 ──────────────────────────────────────────────────続 き Continued on the front page F-term (reference)

Claims (14)

[Claims] 1. A data management system comprising: a server capable of inputting / outputting data by accessing a database; and a plurality of terminals capable of accessing the database of the server via a network. A data management system, wherein a progress management unit capable of directly managing the progress level of data processing by sharing the database of the server from a terminal side is provided in the server. 2. The data management system according to claim 1, wherein the progress management unit includes a search unit that displays a search result in a time-series graph when searching for data. 3. The data management system according to claim 1, wherein the progress management unit displays a list of data input at the time of data input for each item, and selects an arbitrary item from the list at the time of re-input. A data management system comprising means. 4. The data management system according to claim 1, wherein the progress management unit has a specification change unit that tabulates various setting information and input / output data according to various uses. . 5. The data management system according to claim 1, wherein the progress management unit has display means for displaying an arbitrary item of the data processing in a specific background color according to a progress level. Data management system. 6. The data management system according to claim 1, wherein the progress management unit includes a display unit that displays an item of the progress level of the data processing in a specific background color according to the progress level. And a data management system. 7. The data management system according to claim 1, wherein the progress management unit displays the list input from the data input at the time of data input when the data input at the time of data input is displayed as a list for each item. A data management system, comprising: a display unit that performs the operation. 8. The data management system according to claim 1, wherein said progress management unit has a selection means for selecting a plurality of search terms from among search items at the time of data search. 9. The data management system according to claim 1, wherein the progress management unit has display means for displaying search condition information when displaying a search result at the time of data search. system. 10. The data management system according to claim 1, wherein the progress management unit has display means for displaying a progress level for each countermeasure in a table when displaying the analysis result during data analysis. Characteristic data management system. 11. The data management system according to claim 1, wherein the progress management unit has a transmission unit that transmits update information to a predetermined terminal among the plurality of terminals by e-mail during an update process. And a data management system. 12. The data management system according to claim 1, wherein said progress management unit has a storage means for storing a change history at the time of data input or update processing. 13. The data management system according to claim 1, wherein the progress management unit includes an approval unit that approves a progress level of data processing from the plurality of terminals to the server. Data management system. 14. The data management system according to claim 1, wherein the progress management unit includes a restriction unit for restricting data access from the specific terminal to the server.