JP2007179105A - Control system for shared database and control method for shared database and computer program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To perform the update of a shared database and the notification of an update content to other members in a real time by input item units of data through a data input picture on a Web page displayed by a browser. <P>SOLUTION: When the user of user terminal equipment 1 tries to update the content of an input field G11 of data on a data input picture G1, server terminal equipment 2 accepts only the intention of the update, and when a preceding command to update the content of the input field G11 exists in the command queue of the server terminal equipment 2, the server terminal equipment 2 makes the update processing precede. During this time, update impossibility is displayed in the input field G11 of the data input picture G1 of the user terminal equipment 1, and a state that the update is not acceptable is set. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a shared database control system, a shared database control method, and a computer program. In particular, each member can update the storage contents of a shared database shared by the members of the group, and the update result is sent to the members. The present invention relates to a shared database control system, a shared database control method, and a computer program that can be browsed in real time.

  Conventionally, in a shared database control system realized by a computer, in order to allow a plurality of members (users) in a group to share and share a single database, a database is usually used in an OS (operating system). Exclusive access control is performed.

  Due to the existence of this exclusive control function, each of the plurality of members, when accessing the shared database and updating the recorded contents, once obtained the access right, is subsequently disturbed by other users. The database can be occupied until the update process is completed (see Patent Document 1).

  Normally, such an exclusive control function of the database is performed by the database management unit of the OS. However, in the exclusive control function by the conventional database management unit, the control unit on the database to be exclusively controlled is input to the storage device. It is an output unit, that is, a block unit. Therefore, if the file structure is 1 record / 1 block, an exclusive control function in units of records can be realized, but from the actual business aspect, the control unit for exclusive control is 1 record / 1 block. Even in this case, it still lacked the fine grain.

  Further, the conventional shared database control system does not have a function of notifying other members in real time of the update result (new contents) updated by a certain member in the group.

On the other hand, in recent years, the role expected of a computer-controlled database is increasing, and a shared database is required to have a fine-grained control function adapted to actual work.
However, in the past, only the exclusive control function in units of records described above could be used as a function for realizing database sharing. Therefore, in terms of actual work, it was not easy to use. Each member has its own database, separate from the database that is used jointly, and daily updates are based on this personal database, and if necessary, The use form in which each of the members lifts the update result for the database dedicated to the member to the shared database without permission has become normal.
In this case, even if the database is physically shared, there is a time difference in updating the stored contents, so it cannot be said that the information can be shared in real time among the members. there were.

In recent years, with the spread of Internet technology, information transmission / reception between a user terminal device and a server terminal device is often performed via a web page displayed by a browser.
Conventional web pages often have small data entry screens for commercial purposes such as trading companies for this purpose. Recently, however, the purpose of using web pages has been changed from the beginning to the user. The use form of the web page is limited to only the purpose of transmitting and receiving information (communication purpose) between the terminal device and the server terminal device, and thus the web page is provided only with a data input screen for inputting a large amount of information. Has appeared.

  However, a data input screen that allows a large amount of information to be input via a web page includes a function for operating the data input screen in addition to a communication setting function on the Internet network, and input data (characters and images). However, it is troublesome for the user to design a data input screen having such a function from scratch.

  Here, as the data input screen displayed by the browser, it is convenient if a screen provided by an application such as an existing word processor or spreadsheet software can be used, but an application such as an existing word processor or spreadsheet software, Although it has a function for operating the screen, a function for operating the input data, a browser-related function, etc., it is in units of screens (however, format conversion and compression are performed with the communication storage device provided in the user terminal device). Each time input data item data is input, the input data item data is written to the storage device and transmitted to the server terminal device. It was never done.

FIG. 12 is an explanatory diagram showing a screen configuration of a data input screen on a web page displayed by a conventional browser.
The data input screen G9A shown in the figure has input fields (G9A1 to G9An) corresponding to data input items-(1 to n) set on a web page provided by some server. The user can complete data input for the entire screen by pressing the send button G91 after inputting data only to the necessary input items among these input items. The entire information corresponding to this one screen is transmitted to the server via the storage device provided in the user terminal device.
JP 2005-135017 A

  However, in the conventional shared database control system described in the above background art, as described above, the control unit when exclusive control is performed on the shared database is the input / output unit to the storage device constituting the shared database. In other words, since it is a block unit of a file, there is a problem that it lacks the fineness of the grain to be applied to actual work.

  In addition, the update result of the shared database updated by a member in the group is not notified to other members in real time when the update is completed. As a matter of fact, each member in the group was in a state in which all members did not know, so there was a problem that the storage contents stored in such a shared database lacked transparency.

  For this reason, each member owns his / her own database separately from the shared database, and daily update work is performed on the basis of his / her own database, and lifting to the shared database is performed irregularly. As a result, the members of the group have a delay in viewing the latest information that has been updated, which may cause problems in their operations.

  In addition, even when a web page is used, data is only input / output in units of screens with the communication storage device provided in the user terminal device as described above. In order to view the latest update results updated, the screen had to be reloaded through the browser.

  Furthermore, in the control system of the conventional shared database system, any member in the group can arbitrarily access the shared database as needed, and therefore, in terms of access rights, There was a problem.

  The present invention has been made in view of the above-described conventional problems. The update of the shared database and the notification of the update contents to other members are made via a data input screen on a web page displayed by a browser. It is an object of the present invention to provide a shared database control system that allows data entry items to be performed in real-time processing, and can set appropriate access rights corresponding to members to the shared database. .

  Another object of the present invention is to update the shared database and notify the other members of the updated contents in units of data input items via a data input screen on a web page displayed by a browser. An object of the present invention is to provide a shared database control method capable of performing time processing and setting an appropriate access right for each member in the shared database.

  Another object of the present invention is to update the shared database and notify the other members of the updated contents in units of data input items via a data input screen on a web page displayed by a browser. Another object of the present invention is to provide a computer program that executes a shared database control method that can be performed by time processing and that can set an appropriate access right to the shared database.

  In order to solve the above-described problem, a shared database control system according to the present invention updates storage data of a shared database (hereinafter referred to as “shared database”) that is shared by a plurality of users and used jointly. A shared database control system for displaying data stored in the shared database on a display device visually recognized by a user who has called the data, and any one data item included in the data, When the user wants to update, the user designates the data item to input position information of the position where the data item exists, and when the position information is input, In addition to accepting the intention to update, it is checked whether there is a preceding update request for the data item. And means that when the preceding update request exists, the display device that the user visually recognizes that the update of the data item is not permitted is displayed and the update of the data item is disabled. Means for sequentially executing the preceding update requests in the order of acceptance, and each time the execution is performed, the update results are displayed on all display devices that each of the plurality of users is viewing. When all the updates by the preceding update request are completed, the data item can be updated, and the fact that the data item can be updated is displayed on the display device that the user is viewing. When update data for the data item is input by the means and the user indicating the intention to update by inputting the position information, the update data is based on the update data. Based on the updated data, the update process is executed, and the update result is displayed on all the display devices that each of the plurality of users is viewing. And a means for updating at a predetermined timing. A shared database control system is provided.

  With this configuration, the update of the shared database and the notification of the updated content to other members can be performed in units of data input items via the data input screen on the web page displayed by the browser. Realizes what can be done with time processing.

  The shared database control system according to claim 1, wherein the display device visually recognized by the user is a device attached to a user terminal device used by the user, and the shared database is the user. The database is managed by a server terminal device that is communicably connected to the terminal device.

The shared database control system according to claim 2, wherein the data stored in the shared database is provided as a web page on the Internet network by the server terminal device.
The shared database control system according to any one of claims 1 to 3, wherein the access right of the shared database is permitted according to a rank set in advance corresponding to the authentication information of the user. Features.

  5. The shared database control system according to claim 1, wherein the data item to be updated is a character or an image.

  6. The shared database control system according to claim 1, wherein the data item is a data item secured by a predetermined input format including a table format.

  In addition, the shared database control method according to the present invention controls the shared database for updating storage data of a shared database (hereinafter referred to as “shared database”) that is shared and shared by a plurality of users. A method of displaying data stored in the shared database on a display device that is visually recognized by a user who has called the data, and for any one data item included in the data, the user If the user wants to update, the step of inputting the position information of the position where the data item exists by causing the user to specify the data item, and the update of the user when the position information is input. And verify whether there is a previous update request for the data item. And when the preceding update request exists, displaying on the display device that the user is viewing that the update of the data item is not permitted, and disabling the update of the data item And sequentially executing the preceding update requests in the order of acceptance, and displaying the update results on all display devices that each of the plurality of users is viewing each time the execution is performed, and The step of displaying on the display device that the user visually recognizes that the update of the data item is enabled and the update of the data item is enabled when all the updates by the preceding update request are completed. And when the update data for the data item is input by the user who has indicated the intention to update by the input of the location information, The update process is performed, and the update result is displayed on all the display devices that each of the plurality of users is viewing, and the storage content of the shared database is stored in the updated data. And a method for controlling the shared database, characterized by comprising the step of updating at a predetermined timing.

  Furthermore, a computer program according to the present invention is a computer program for executing update processing in a system for updating storage data of a shared database shared and shared by a plurality of users, and stored in the shared database. The displayed data on a display device that is visually recognized by the user who called the data, and if the user wishes to update any one data item included in the data, the user Specifying the data item to input position information of the position where the data item exists, and when the position information is input, the user's intention to update is accepted, and the data item To verify whether there is a previous update request. And, when there is a preceding update request, displaying on the display device that the user is viewing that the update of the data item is not permitted, and making the update of the data item impossible And sequentially executing the preceding update requests in the order of acceptance, and displaying the update results on all display devices that each of the plurality of users is viewing each time the execution is performed. When the update according to the preceding update request is completed, the data item can be updated and the display device that the user is viewing is able to update the data item. The update data for the data item is input by the user who indicated the intention of the update by inputting the position information and the step of displaying The update process based on the update data is executed, and the update result is displayed on all the display devices that each of the plurality of users is viewing, and the storage content of the shared database is And a step of updating at a predetermined timing based on the updated data. A computer program is provided.

  As described above, according to the shared database control system of the present invention, the update of the shared database is performed in units of data input items and in real time via the data input screen on the web page displayed by the browser. Since it can be done by processing, it has the effect of being applicable to fine-grained work.

  In addition, since the shared database is easy to use, each member does not need to have a dedicated database, and the database can be unified.

  Moreover, since the update result which each member performed is notified also to other members in real time, it is suitable for the collaborative work in a group.

  In addition, since each member can always browse common materials, there is an effect of effectively functioning as a remote conference system.

  In addition, the shared database becomes more transparent, and it is also possible to record when, where, and who made what changes as log data. Has the effect of being effectively applicable.

  Furthermore, since the rank of the access right to the shared database to be set in advance for each member is determined from the password of each member, etc., there is an effect that it is possible to manage the strict access right of the shared database. .

The shared database control system of the present invention is a system that updates storage data of a shared database that is shared by a plurality of users and used jointly.
DESCRIPTION OF THE PREFERRED EMBODIMENTS The best mode of a shared database control system according to the present invention will be described below in detail with reference to the drawings.
In this embodiment, the shared database control system and shared database control method according to the present invention will be described in detail. However, the computer program according to the present invention executes the shared database control method according to the present invention. The description is included in the following description.

First, points to be noted of the present invention will be described.
As described in the background, the exclusive control (occupancy control) necessary for updating the recorded contents of the shared database is also performed in the data management section of the OS in the current computer system. The control unit of the control is a block unit, and the exclusive control of the data input item unit is not performed.
Further, the exclusive control is applied only when the computer system is a tightly coupled system, and is not applied to a computer system extending over a wide area via the Internet network.

Therefore, according to the present invention, it is possible to perform exclusive control in units of data input items and to enable exclusive control in a computer system over a wide area via the Internet network. The update processing is performed in strict adherence to the order in which update requests are received for each control unit (in the case of the present invention, data input item unit).
If this order is disrupted, the group members will collaborate and will not proceed smoothly.
However, for update requests from a plurality of user terminals over a wide area via the Internet network, an update command including update data cannot be transmitted from the user terminal at an arbitrary timing due to a time difference. .

  That is, if an update command including update data is transmitted at an arbitrary timing due to the presence of the time difference, there is a possibility that an update result by another person's update command may be transmitted immediately after the transmission. Depending on the situation, the self-update command sent immediately before becomes inconvenient, and it may not be preferable to inform other members.

  Therefore, in the present invention, only an intention to make an update request from an arbitrary user is accepted, and transmission of actual update data is performed by processing all other update requests for the same data input item. The user waits until the update result is notified, and after all other update requests for the same data input item are processed and the user is notified of the update result, the user is notified of the actual update result. Control to authorize the transmission of update data.

FIG. 1 is an explanatory diagram showing a flow of information in the shared database control system according to the embodiment of the present invention.
First, in the user terminal device 1 (generally a plurality), the user calls a data input screen G1 opened on a web page via a browser (described later).

  Next, this call is notified to the server terminal device 2, and after confirming that the exclusive control buffer B1 has a free area for one record, the server terminal device 2 stores the web page in the shared database 21. Then, the record R1 including the data input screen G1 is output to the exclusive control buffer B1 (step P1), and the web page including the data input screen G1 is transmitted to the user terminal device 1 (step P2).

However, at this time, if there is no free space for one record in the exclusive control buffer B1, the server terminal device 2 drives out the record with the least reference frequency from the exclusive control buffer B1.
At this time, the content of the corresponding record stored in the shared database 21 is updated with the content of the expelled record.

  Further, when the record R1 including the data input screen G1 already exists in the exclusive control buffer B1, the output from the shared database 21 to the exclusive control buffer B1 is not performed, and the portion corresponding to the record R1 of the web page As information, the information of the record R1 existing in the exclusive control buffer B1 is used.

In response to the transmission, in the user terminal device 1, the browser displays a web page including the data input screen G1 on the display device.
At this time, the already input “Irohaniho” is displayed in the input field G11 of the data input screen G1.

Next, the user indicates an intention to update the input field G11 in the data input screen G1 on which the above “Irohaniho” is displayed (for example, clicks on the input field G11), and tries to update the contents of the input field G11. .
As a result, the browser of the user terminal device 1 shows a sign (indicated by vertical stripes in FIG. 1) indicating that the user has recognized the intention to update the input field G11 in the input field G11 and Then, an inquiry command as to whether or not the input field G11 can be updated is transmitted (step P3).
However, at this stage, the input field G11 is not yet updatable (processed so as not to accept an update input by the browser).

In response to this, the server terminal device 2 registers the inquiry command in the command queue Q1, and other commands excluding the inquiry command in the command queue Q1 (that is, a preceding command, generally a plurality). It is verified whether or not exists.
Here, it is assumed that the preceding command exists in the command queue Q1, and that the preceding command includes a command requesting to update the record R1 including the data input screen G1.

  In this case, the server terminal device 2 sends a command for prohibiting the update of the input field G11 to the user terminal device 1 (step P4). In response to this, the user terminal device 1 displays the command in the input field G11. On the other hand, a display indicating that the update cannot be performed is performed, and the process of not accepting the update input is continued.

Next, the server terminal device 2 transmits this update result to all the user terminal devices 1 that have called the data input screen G1 every time one process of the preceding command that meets the condition is completed, When processing of all preceding commands that meet the conditions is completed, the user terminal device 1 is allowed to update the input field G11.
Here, the content of the input field G11 changes from “Irohaniho” to “Hanihoheto”, and the update result of the input field G11 received by the user terminal device 1 is data: “Hanihoheto” (step P5).

  In response to this, the browser of the user terminal device 1 displays this data: “Hanihoheto” in the input field G11 and displays that the input field G11 can be updated. Cancel processing that does not accept update input.

The user who confirmed this display inputs “Aiueo” in the input field G11.
When this input is completed, the browser transmits this data as an update command to the server terminal device 2 (step P6).

  Note that the browser can detect when the input is completed when the user presses the enter key or when a new input field other than the input field G11 is clicked.

  In response to this, the server terminal device 2 replaces the inquiry command with the transmitted update command and processes the update command (that is, the input of the data of the record R1 input to the exclusive control buffer B1). The area corresponding to the field G11 is updated with the received data: “Aiueo”.

  Although not shown, the update result (here, data: “Aiueo”) is transmitted to each of the user terminal devices 1.

Further, the contents of the exclusive control buffer B1 are used to update (overwrite) the shared database 21 at an appropriate time (for example, when a predetermined time has passed without access to the exclusive control buffer B1). However, at this point, the record established in the exclusive control buffer B1 is not erased.
However, the records established in the exclusive control buffer B1 are erased in order from the smallest reference count by another processing unit (not shown) that comprehensively evaluates the reference count.
Further, the commands registered in the command queue Q1 are deleted in order from the end of processing.

  Further, in the command, in the case of character data, information indicating the position of the input field in the data input screen, and in the case of an image, coordinate information of an image (here, still image) drawn in the data input screen (described later). ) Shall be added.

FIG. 2 is an explanatory diagram showing another flow of data in the shared database control system according to the embodiment of the present invention.
In FIG. 1, as described above, when the inquiry command is transmitted, there is already a preceding command corresponding to the above condition in the command queue Q1, and the preceding command includes a record including the data input screen G1. It is assumed that a command requesting to update R1 is included.
In the case shown in FIG. 2, even if there is no preceding command corresponding to the above condition in the command queue Q1, or even if there is a preceding command corresponding to the above condition in the command queue Q1, there is no data in this preceding command. This shows a case where a command requesting to update the record R1 including the input screen G1 is not included.
Therefore, the processes of steps P3, P4, and P5 shown in FIG. 1 are omitted, and only the processes of steps P1, P2, P6, and P7 are performed.

As described above, the browser of the user terminal device 1 displays a data input screen provided as a web page on a display device (described later) attached to the user terminal device 1.
Hereinafter, this data input screen will be described as an example.

FIG. 3 is an explanatory diagram showing an example of a data input screen displayed by the shared database control system according to the embodiment of the present invention.
In the data input screen G1A shown in FIG. 3, input fields (G1A1 to G1An) are provided corresponding to the input items − (1 to n), respectively.
The data input screen shown in FIG. 3 is the most commonly used data input screen.

FIG. 4 is an explanatory diagram showing another example of the data input screen displayed by the shared database control system according to the embodiment of the present invention.
In the data input screen G1B shown in FIG. 4, input fields (G1B1 to G1Bn) are provided corresponding to the items in the table format.
The data input screen shown in FIG. 4 is a data input screen simulating an application of spreadsheet software.

FIG. 5 is an explanatory diagram showing another example of the data input screen displayed by the shared database control system according to the embodiment of the present invention.
In the data input screen G1C shown in FIG. 5, still images-(1 to m) are displayed in the screen.
This still image has already existed or has been input by the current update process.

  When the still image is updated or newly input, the coordinate information of the still image is added to the update command. As the coordinate information, the center coordinates of the still image, the maximum length of the still image in the X-axis direction, and the maximum length of the still image in the Y-axis direction can be used.

When verifying the presence of the preceding command in the server terminal device 2, as a condition for determining the corresponding command, in the case of updating a still image, the coordinates between the still images intersect using the coordinate information. Or not (that is, whether or not graphics intersect).
The data input screen shown in FIG. 5 is a data input screen simulating a word processor application.

  FIG. 6 is an explanatory diagram showing a configuration example of a browser display screen displayed by the shared database control system according to the embodiment of the present invention.

  In the browser display screen 6 shown in the figure, a data input unit 60 on which a data input screen for inputting data is displayed, a file operation button unit 61 for operating a file, operations on the data input screen, , A screen operation button unit 62 for displaying menus, a web page operation button unit 63 for performing web page communication settings and operations, and a drawing tool for collecting tools used for drawing a still image. A tool 64 is displayed.

In addition, an input format specifying unit 65 for setting a format for inputting character data is displayed, and further, an address of the displayed web page, that is, a URL (Uniform Resource Locator) is displayed. The web page URL 66, which is a field for setting the URL of the web page to be displayed, is displayed.
Note that these display contents can be customized for a specific user or a specific group.
In addition, a screen for performing communication settings and a screen for applying for administrator or user authentication information (password, etc.) can be provided.

FIG. 7 is a configuration diagram showing the overall configuration of the shared database control system according to the embodiment of the present invention.
The shared database control system according to the present embodiment has a configuration in which a plurality of user terminal devices 1 and a server terminal device 2 are communicably connected via an Internet network 10. Here, it is assumed that there are a plurality of user terminal devices 1.

  The user terminal device 1 includes, as main components, a CPU 11 for overall control, a transmission / reception storage device 12 serving as a relay buffer for transmitting / receiving data displayed / input on the data input screen, and a data input screen The display device 16 is provided.

  The server terminal device 2 receives, as main components, a control unit 21 that controls the whole, a shared database 22 that is shared among group members and used jointly, and a command received from each of the user terminal devices 1. A command queue Q1 that is registered in order, and an exclusive control buffer B1 that is used to perform exclusive control in units of data input items. The server terminal device 2 provides a member with a web page including a data input screen.

  Each member inputs data via the data input screen. This input result is transmitted to the user terminal device 1 used by another member in real time, and is displayed at a corresponding position (input field or coordinate position) on the data input screen.

FIG. 8 is a configuration diagram illustrating a main configuration of the server terminal device included in the shared database control system according to the present embodiment.
In the figure, the server terminal device 2 authenticates, as main components, a control unit 21 that controls the whole, a shared DB (database) 22 that is shared and shared among group members, and group members. Authentication DB 23 for storing, customer information DB 24 for storing information on customers (users), business DB 25 used for business such as billing processing, input / output data, transmitted / received data and commands are displayed. A display device 26 for converting the analog data into digital data and an input device 27 for inputting manual input data and operation information.

  The input device 27 can be configured by an OCR or a scanner.

  The control unit 21 shares processing of other components and controls the other components, a program and data necessary for update processing, and a RAM 212 including an exclusive control buffer B1 and a queue buffer QB, and line connection A line control unit 213 that controls the communication, a communication control unit 214 that has a protocol with the Internet network 10 and communicates with other terminal devices, a DB management unit 215 that controls the database (22 to 25), and data input A web server 216 that manages web pages including screens and performs access control.

  The CPU 211 controls the entire apparatus, shares processing of other main components, and performs update processing with exclusive control in units of input data items in the shared DB 22.

  The RAM 212 stores programs and data necessary for update processing, and includes a storage area for the exclusive control buffer B1 and a storage area for the queue buffer Q1.

  The line control unit 213 is for connecting to the Internet network 10 and can be configured to include a digital termination connection unit (DSU), a router equipped with a firewall application for intrusion prevention, and the like.

The communication control unit 214 controls each server such as the web server 216 and executes control for selectively performing line connection with a plurality of user terminal devices.
The communication control unit 214 can include, for example, an NTP (Network Time Protocol) server for time synchronization on the Internet, an NFS (Network File System) server for a distributed file system, and the like.

  The communication control unit 214 can further hold an encrypted communication protocol for transferring encrypted data for maintaining confidentiality of personal information and the like, and can execute control of an SSL (Secure Sockets Layer) server.

The DB management unit 215 manages the shared DB 22, the authentication DB 23, the customer information DB 24, and the business DB 25 via the input / output bus 220.
This management content includes exclusive control (occupation control) in units of data input items for the shared DB 22, management of the record reference count, general buffering techniques, and the like.

  The web server 216 operates as a main computer for executing basic communication processing (browsing) on a connected Internet network (VPN). The web server 216 operates a homepage established on the Internet network (VPN), and a data input screen is installed on the homepage.

Further, the web server 216 authenticates a user who accesses the shared DB 22 via the data input screen of the homepage, and for an authenticated user (a user who has access rights to the shared DB 22) The access right for each rank given in advance is given to the user, and the access for each rank is granted.
The rank of this access right is given corresponding to the user authentication result (password or the like).

The authentication DB 23 stores authentication data necessary for user authentication.
The file stored in this database is referred to by the task for performing authentication during the authentication process.
Note that the access right to the shared DB 22 is provided with a rank as described above, and the user of the user terminal device 1 is given an access right with a rank corresponding to this authentication result (password or the like).

The customer information DB 24 stores information (including preference information in addition to personal data) related to customers (manufacturers, dealers, general users, etc.).
The file stored in this database is used as reference information for creating an advertisement that raises the customer's interest when creating a web page for advertising in addition to confirming the trust of the customer. Is done.

FIG. 9 is a configuration diagram illustrating a main configuration of the user terminal device included in the shared database control system according to the present embodiment.
The user terminal device 1 illustrated in FIG. 1 includes a CPU 11 that controls the entire device, a transmission / reception storage device 12 that functions as a relay buffer when transmitting / receiving information in units of data input items on a data input screen, and an Internet network. 10, a communication processing unit 13 that communicates with the server terminal device 2 (FIG. 8) with a communication protocol corresponding to 10, a storage device control unit 14 that controls the transmission / reception storage device 12, and data input via a data input screen An input device 15 for displaying data, a display device 16 for displaying a data input screen to be transmitted and received, and a printing device 17 for printing the data input screen.

  The CPU 11 controls the entire terminal device, has a browser function, and displays a data input screen provided as a web page on the display device 16.

  The transmission / reception storage device 12 serves as a relay buffer (a buffer for both communication and input / output) when information in the data input item unit of the data input screen is transmitted / received to / from the server terminal device 2. Function.

  The communication processing unit 13 and a communication protocol corresponding to the Internet network 10 are provided, and communicate with the server terminal device 2 (FIG. 8) via the Internet network 10 to transmit and receive data input screens and commands.

  The storage device control unit 14 controls the transmission / reception storage device 12 that functions as a relay buffer.

  The input device 15 has a function for a user to input data via the above-described data input screen. In addition to this, a recognition function for converting analog data into digital data and inputting the analog data, and operation information Can be input.

  The display device 16 displays the above-described data input screen transmitted and received on the screen.

  The printing device 17 is used for printing the data input screen and the like.

  The flow of information between the user terminal device 1 and the server terminal device 2 (FIG. 8) is as described above, and the processing procedure is shown below.

  FIG. 10 is a flowchart showing a processing flow of the server terminal device in the shared database control system according to the present embodiment.

Hereinafter, with reference to FIGS. 1, 2, and 10, a process after the data input screen G1 opened on the web page is called from the user terminal device 1 (generally a plurality) will be described.
Further, it is assumed that when the data input screen G1 is called, the record R1 including the data input screen G1 does not yet exist in the exclusive control buffer B1.

First, as step S1, the CPU 211 of the server terminal device 2 verifies whether or not there is an empty area for one record in the exclusive control buffer B1.
If the exclusive control buffer B1 has an empty area for one record, the process proceeds to step S2. If the exclusive control buffer B1 does not have an empty area for one record, the process proceeds to step S12.

  Next, as step S2, the CPU 211 reads the record R1 including the data input screen G1 from the shared database 21 storing the web page to the exclusive control buffer B1 via the DB management unit 215.

  Next, as step S <b> 3, the CPU 211 transmits a web page including the data input screen G <b> 1 to the user terminal device 1 via the communication control unit 214.

  In step S <b> 4, the CPU 211 receives an inquiry command as to whether the input field G <b> 11 transmitted from the user terminal device 1 can be updated.

  In step S5, the CPU 211 registers the inquiry command in the command queue Q1 via the DB management unit 215.

Next, as step S6, the CPU 211 verifies, via the DB management unit 215, whether another command (that is, a preceding command, generally a plurality) other than the inquiry command exists in the command queue Q1.
If the preceding command exists, the process proceeds to step S13, and if the preceding command does not exist, the process proceeds to step S7.

  Next, as step S <b> 7, the CPU 211 transmits an update permission command for the input field G <b> 11 to the user terminal device 1 via the communication control unit 214.

  Next, as step S <b> 8, the CPU 211 receives the update command for the input field G <b> 11 transmitted from the user terminal device 1 via the communication control unit 214.

  Next, as step S9, the CPU 211 processes an update command for the input field G11.

  Next, as step S10, the CPU 211 transmits the update result of the input field G11 to each of the user terminal devices 1 that called the data input screen G1.

  If the CPU 211 determines that the predetermined time has been reached while performing the above processing, the content of the exclusive control buffer B1 is written in the shared database 21 as step S11, and the series of processing ends. Accepts the next command.

If the CPU 211 determines in step S1 that there is no free space for one record in the exclusive control buffer B1, the process proceeds to step S12.
As step S12, the CPU 211 drives out the record with the lowest reference frequency from the exclusive control buffer B1, and then proceeds to step S2 of the next process.

Similarly, if the CPU 211 determines in step S6 that a preceding command exists, the process proceeds to step S13.
As step S13, the CPU 211 sends a command for prohibiting the update of the input field G11 to the user terminal device 1 via the communication control unit 214, and proceeds to step S14.

  In step S14, the CPU 211 processes one of the preceding commands remaining in the command queue Q1.

  Next, as step S15, the CPU 211 transmits the update result of the processed preceding command to each of the user terminal devices 1 that called the data input screen G1.

  Next, in step S16, the CPU 211 verifies whether or not the preceding command still remains in the command queue Q1, and if the preceding command remains in the command queue Q1, returns to step S14 again to return to the command queue Q1. If no preceding command remains, the process proceeds to step S7.

  FIG. 11 is a flowchart showing the flow of processing of the user terminal device in the shared database control system according to the present embodiment.

  First, in step S21, the CPU 11 receives a display request for the data input screen G1 via the browser (FIG. 6) by the user, and calls the data input screen G1 opened on the web page via the communication processing unit 13. .

  Next, as step S <b> 22, the CPU 11 receives a web page including the data input screen G <b> 1 transmitted from the server terminal device 2 via the communication processing unit 13.

  Next, as step S23, the CPU 11 displays a web page including the data input screen G1 on the display device 16 via the browser.

  Next, as step S24, the CPU 11 stands by until the user indicates an intention to input data into the input field G11 (for example, the user clicks on the input field G11). When the input field G11 is clicked, the process proceeds to step S25.

Next, as step S25, the CPU 11 displays a sign (indicated by vertical stripes in FIG. 1) that the user's intention has been recognized via the browser in the input field G11.
However, at this stage, the browser does not yet allow the input field G11 to be updated (hereinafter, this process is referred to as “non-update setting”).

  In step S <b> 26, the CPU 11 transmits an inquiry command as to whether or not the input field G <b> 11 can be updated to the server terminal device 2 via the communication processing unit 13.

  Next, as step S <b> 27, the CPU 11 receives a response to the inquiry command from the server terminal device 2 via the communication processing unit 13.

  Next, as step S28, the CPU 11 verifies whether or not the content of the response permits the update of the input field G11, and when the content of the response permits the update of the input field G11. The process moves to step S33, and if the content of the response does not permit the update of the input field G11, the process moves to step S29.

  Next, as step S29, the CPU 11 displays the non-updatable in the input field G11 via the browser, and continues the setting of non-updating.

  Next, as step S <b> 30, the CPU 11 receives the update result of the input field G <b> 11 by the preceding command transmitted from the server terminal device 2 via the communication processing unit 13.

  In step S31, the CPU 11 displays the update result in the input field G11 via a browser.

  Next, in step S32, the CPU 11 verifies whether or not the update permission for the input field G11 has been transmitted from the server terminal apparatus 2. If the update permission for the input field G11 has been transmitted, the process proceeds to step S33. If the update permission for the input field G11 is not transmitted, the process returns to step S30.

  Next, as step S33, the CPU 11 deletes the non-updatable display on the input field G11 and cancels the non-updating setting via the browser.

  In step S34, the CPU 11 receives an update to the input field G11 via the browser and acquires the input data.

  In step S35, the CPU 11 transmits an update result (input data) for the input field G11 to the server terminal device 2 via the browser and the communication processing unit 13, and ends the process (next update). Accept processing).

  In this embodiment, only one exclusive control buffer B1 is used. However, the stored contents of the exclusive control buffer B1 are always copied to a spare buffer, and this spare buffer is used for backup exclusive use when a failure occurs. It can be used as a control buffer.

  Further, in the present embodiment, the timing for updating the shared database 21 with the stored contents of the exclusive control buffer B1 is set at an appropriate time (for example, when a predetermined time has passed without access to the exclusive control buffer B1). However, in the present invention, in general, each time one input field in one record is updated, the stored contents of the record may be written back to the exclusive control buffer B1.

  In the server terminal device 2, the preceding command in the command queue Q1 is an inquiry command. Even if a predetermined time elapses from the time when the update permission of the input field is given to the inquiry command, the update command is not yet updated. If not transmitted, the inquiry command can be controlled to be canceled (erased from the command queue Q1).

  Further, it is possible to prepare a recording memory different from the command queue Q1, and to record recording data indicating when, where, and who changed what in this memory.

  The shared database control system according to the present invention can also be realized in a computer system not via the Internet network or a stand-alone computer system.

Note that the shared database control system according to the present invention executes at least a part of processing performed by each component by computer control.
A program that causes a computer to execute the above processing according to the procedure shown in the flowcharts of FIGS. 10 and 11 may be stored and distributed in a computer-readable recording medium such as a semiconductor memory, a CD-ROM, or a magnetic tape. Good.
A computer including at least a microcomputer, a personal computer, and a general-purpose computer may read the program from the recording medium and execute the program.

The present invention is applicable to the construction of a computer system used for members in a group to share the same database and collaborate.
It can also be applied to meetings between members with different locations in the group, joint design, and the like.

It is explanatory drawing which shows the flow of the information in the control system of the shared database which concerns on embodiment of this invention. It is explanatory drawing which shows the other flow of the data in the control system of the shared database which concerns on embodiment of this invention. It is explanatory drawing which shows an example of the data input screen displayed by the control system of the shared database which concerns on embodiment of this invention. It is explanatory drawing which shows another example of the data input screen displayed by the control system of a shared database which concerns on embodiment of this invention. It is explanatory drawing which shows another example of the data input screen displayed by the control system of a shared database which concerns on embodiment of this invention. It is explanatory drawing which shows one structural example of the browser display screen displayed by the control system of the shared database which concerns on embodiment of this invention. It is a block diagram which shows the whole structure of the control system of the shared database which concerns on embodiment of this invention. It is a block diagram which shows the main structures of the server terminal device with which the control system of the shared database which concerns on this embodiment is provided. It is a block diagram which shows the main structures of the user terminal device with which the control system of the shared database which concerns on this embodiment is provided. It is a flowchart which shows the flow of a process of the server terminal device in the control system of the shared database which concerns on this embodiment. It is a flowchart which shows the flow of a process of the user terminal device in the control system of the shared database which concerns on this embodiment. It is explanatory drawing which shows the screen structure of the data input screen on the web page displayed by the conventional browser.

Explanation of symbols

1 User terminal device 10 Internet network 11 CPU
DESCRIPTION OF SYMBOLS 12 Storage device for transmission / reception 13 Communication processing part 14 Storage device control part 15 Input device 16 Display apparatus 17 Printing device 2 Server terminal device 21 Control part 211 CPU
212 RAM
213 Line control unit 214 Communication control unit 215 DB management unit 216 Web server 22 Shared DB (database)
220 I / O bus 23 DB for authentication
24 Customer information DB
25 Business DB
26 Display device 27 Input device 6 Browser display screen 60 Data input unit 61 File operation button unit 62 Screen operation button unit 63 Web page operation button unit 64 Graphic drawing tool 65 Input format specification unit B1 Exclusive control buffer G1 Data input Screen G1A Data input screen G1A1 Input field G1A2 Input field G1An Input field G1B Data input screen G1B1 Input field G1B2 Input field G1Bn Input field G1C Data input screen G1C1 Still image-1
G1Cm Still image-m
G11 Input field G9A Input screen G9A1 Input field G9A2 Input field G9An Input field QB Queue buffer Q1 Command queue R1 Record

Claims (8)

A shared database control system that updates storage data of a shared database that is shared and shared by a plurality of users,
Means for displaying data stored in the shared database on a display device that is visually recognized by a user who has called the data;
Means for inputting position information of a position where the data item exists by allowing the user to designate the data item when the user wishes to update any one data item included in the data; ,
Means for accepting the user's intention to update when the location information is input and verifying whether there is a preceding update request for the data item;
Means for displaying on the display device that the user is visually recognizing that updating of the data item is not permitted if the preceding update request is present, and disabling updating of the data item;
Means for sequentially executing the preceding update requests in the order of acceptance, and displaying the update result on all display devices that each of the plurality of users is viewing each time of the execution;
When all the updates by the preceding update request are completed, the data item can be updated, and the fact that the data item can be updated is displayed on the display device that the user is viewing. Means,
When update data for the data item is input by the user who indicated the intention to update by inputting the location information, an update process based on the update data is executed, and the update result is sent to the plurality of users. Means for displaying on all the display devices each of which is visually recognized;
Means for updating the storage content of the shared database at a predetermined timing based on the updated data;
A shared database control system comprising:   The display device visually recognized by the user is a device attached to a user terminal device used by the user, and the shared database is managed by a server terminal device connected to be communicable with the user terminal device. 2. The shared database control system according to claim 1, wherein the shared database control system is a database.   3. The shared database control system according to claim 2, wherein the data stored in the shared database is provided as a web page on the Internet network by the server terminal device.   4. The shared database control system according to claim 1, wherein an access right to the shared database is permitted according to a rank set in advance corresponding to the authentication information of the user. 5.   5. The shared database control system according to claim 1, wherein the data item to be updated is text or an image.   6. The shared database control system according to claim 1, wherein the data item is a data item secured by a predetermined input format including a table format. A shared database control method for updating storage data of a shared database shared by a plurality of users and used jointly.
Displaying the data stored in the shared database on a display device being visually recognized by the user who called the data;
If the user wishes to update any one data item included in the data, the user inputs the position information of the position where the data item exists by causing the user to specify the data item; ,
Accepting the user's intention to update when the location information is input, and verifying whether there is a previous update request for the data item;
When the preceding update request exists, displaying on the display device that the user is viewing that the update of the data item is not permitted, and disabling the update of the data item;
Executing the preceding update requests sequentially in the order of acceptance, and displaying the update results on all display devices that each of the plurality of users is viewing each time of the execution;
When all the updates by the preceding update request are completed, the data item can be updated, and the fact that the data item can be updated is displayed on the display device that the user is viewing. Steps,
When update data for the data item is input by the user who indicated the intention to update by inputting the location information, an update process based on the update data is executed, and the update result is sent to the plurality of users. Displaying on all the display devices each of which is visually recognized;
Updating the storage content of the shared database at a predetermined timing based on the updated data;
A shared database control method characterized by comprising: A computer program for executing update processing in a system for updating storage data of a shared database shared by a plurality of users and used jointly,
Displaying the data stored in the shared database on a display device visually recognized by the user who called the data;
If the user wishes to update any one data item included in the data, the user is allowed to input the position information of the position where the data item exists by designating the data item; ,
Accepting the user's intention to update when the location information is input, and verifying whether there is a previous update request for the data item;
If the preceding update request exists, displaying on the display device that the user is viewing that the update of the data item is not permitted, and making the update of the data item impossible,
Causing the preceding update requests to be executed sequentially in the order of acceptance, and displaying the update results on all display devices that each of the plurality of users is viewing each time the execution is performed;
When all the updates by the preceding update request are completed, the data item can be updated, and the data item can be updated is displayed on the display device that the user is viewing. Step to
When update data for the data item is input by the user who indicated the intention to update by inputting the location information, an update process based on the update data is executed, and the update result is displayed on the plurality of users. Displaying on all the display devices each of which is visually recognized;
Updating the stored contents of the shared database at a predetermined timing based on the updated data;
A computer program comprising:

Images