JP4881723B2 - Data input confirmation method, server device, client server system, and data input confirmation program - Google Patents

Description

  BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to data management using a database, and in particular, a data input confirmation method and server device for preferentially providing users with highly necessary data in consideration of the convenience of the user using the database The present invention relates to a client server system and a data input confirmation program.

  In recent years, data has been centrally managed using a database, and access authority according to the business in charge is given to users who use the database, so that data can be shared while being strictly managed. Increasing numbers of companies and organizations are trying to improve efficiency. On the other hand, specialized knowledge is required to set and manage access rights, and if the number of users increases, the load of access rights setting and management operations increases, which may interfere with database operations. .

  Therefore, for example, in the data management apparatus described in Patent Document 1 below, the access authority is efficiently and flexibly managed by grouping each user who uses the database based on a predetermined condition and giving the access authority for each group. I can do it.

Japanese Patent Laid-Open No. 2003-30029

  In data management using a database, setting and management of access authority are very important for system operation, but setting of access authority is very complicated and takes time and effort for management.

  As described above, the data management apparatus described in Patent Document 1 realizes efficient management of access authority. However, in the technique described in Patent Document 1 and other conventional data management techniques, there are many cases in which data of other users can be accessed between users who are given the same access authority. In this case, for example, when viewing or editing only the data that the user has registered or updated, data other than the target data can be accessed. It takes time and effort to search.

  Furthermore, in general, in accounting work in a company, usually, only a small number of persons in charge (users) enter and edit specific data, and a certain user is responsible for data that other users are in charge of. May be viewed, but not edited. However, in the above conventional data management technique, access to data registered by other users is permitted, so there is a risk that data will be rewritten or deleted intentionally or accidentally.

  The present invention has been made in view of the above, and when a client device (user) accesses a server device, the user wants to edit data that the user wants to edit without using a search tool or the like. A data input confirmation method, a server device, and a data input confirmation program that make it possible to easily acquire desired data such as data to be browsed, simplify the procedure until data editing work and browsing work are started, and improve work efficiency. The purpose is to obtain.

  It is another object of the present invention to provide a data input confirmation method, a server device, a client server system, and a data input confirmation program that can prevent data from being rewritten or deleted due to intention or error.

To solve the above problems and achieve the object, the present invention provides a server apparatus having a storage unit including a database for storing the accounting data received from the client device, the user from the client device when receiving an access request together with the notification of the user ID, accounting data that the client device requires a data input confirmation method of providing to the client device, the setting unit, is approved for the contents of the accounting data If done, set the approval flag associated with the accounting data on, and if the accounting data was used to close the settlement flag, turn on the settlement flag associated with the accounting data a setting step of, search unit, from the accounting data of the access request object, registering the notified user ID's Wherein as the user ID of the user ID or renewer, and the or accounting data that meet the search criteria storing unit is a search condition held corresponding to the notified user ID is stored into the database A first search process is performed to search whether or not , and the notification is made from among the accounting data in which the approval flag or the settlement flag associated with the access request target accounting data is set to ON. a search step of accounting data including the user ID to perform a second search process for searching whether stored into the database having the same authority as the user ID, before dangerous search unit, a search by the search step result, if desired accounting data is determined to be stored into the database, the database the accounting data A reading step of reading al, communication unit, characterized in that it comprises a data transmission step of transmitting the accounting data read to the access requesting client device at said reading step.

  In the data input confirmation method according to the present invention, the server computer has data registered by the user and the same access authority for each user (a user who accesses the server computer using any client computer). Since it is possible to access only data registered by other users and whose contents have been finalized (data that is not likely to be edited), it is related to the target data (for example, the work the user is in charge of) (Working data) can be reduced, and the user can prioritize and edit the data entered by the user, which can contribute to operational efficiency. There is an effect.

  In addition, it is possible to prevent the data handled by other users from being updated or deleted by mistake, and that the data handled by other users from being updated or deleted can be prevented. There is an effect.

  In addition, since the user can specify the search conditions used when the server computer searches for data, there is an effect that the data required by the user can be provided quickly.

  Furthermore, since the server manages the data necessary for the work, the user is not limited to the client computer used for the work. For example, several users share a plurality of computers. There is an effect that an efficient work can be realized in an environment where the work is performed.

  Embodiments of a data input confirmation method, a server device, a client server system, and a data input confirmation program according to the present invention will be described below in detail with reference to the drawings. Note that the present invention is not limited to the embodiments.

  FIG. 1 is a diagram showing a configuration example of a client server system to which a data input confirmation method according to the present invention is applied. This client server system includes a server computer 100 and a plurality of client computers 101, 102, 103, 104, 105, 106,... Connected to the server computer 100 via a network. In the following description, a server computer is simply called a server, and a client computer is simply called a client.

  FIG. 2 is a diagram showing a configuration example of a computer system that has a function as a server device for realizing the data input confirmation method according to the present invention and can execute the data input confirmation program according to the present invention. This computer system includes a control unit 1, a storage unit 2, a display unit 3, an input unit 4, and a communication unit 5.

  In FIG. 2, the control unit 1 executes a data input confirmation program according to the present invention. The storage unit 2 includes various memories such as a RAM and a ROM, and stores programs to be executed by the control unit 1 and necessary data obtained in the course of processing. The display unit 3 is composed of a CRT, LCD (liquid crystal display panel), etc., and displays various screens for the computer system user. The input unit 4 includes, for example, a keyboard 41 and a mouse 42, and is used by a computer system user to input various information. Also, this computer system exchanges various information with other computer systems connected to the network by connecting to the network via the communication unit 5.

  Here, an operation example of the computer system until the data input confirmation program according to the present invention becomes executable will be described. In the computer system having the above-described configuration, for example, a data input confirmation program is installed in a disk unit (not shown) from a CD-ROM set in a CD-ROM drive unit (not shown). When the data input confirmation program is executed, the data input confirmation program read from the disk unit is stored in a predetermined location in the storage unit 2. In this state, the control unit 1 executes data provision processing according to the program stored in the storage unit 2.

  In the present invention, a CD-ROM is used as a recording medium to provide a program that describes the data providing process. However, the present invention is not limited to this, depending on the configuration of the computer system, the capacity of the provided program, etc. For example, a recording medium such as a magnetic disk such as a floppy (registered trademark) disk, a magneto-optical disk, or a magnetic tape can be used. Moreover, it is good also as using the program provided by transmission media, such as an email and the internet.

  The client is also realized by the computer system having the configuration shown in FIG.

  FIG. 3 is a diagram illustrating a configuration example of a server and a client configuring the client server system illustrated in FIG. The client server system includes a server and a client connected to the server, but FIG. 3 shows a configuration example of the server 100 and the client 101. Further, the configuration of the clients 102, 103,... Is the same as that of the client 101. Hereinafter, internal configurations of the server 100 and the client 101 will be described.

  First, the internal configuration of the server 100 will be described. The server 100 includes a control unit 1 that executes various processes for realizing control of each unit constituting the server 100 and a data input confirmation method according to the present invention, a storage unit 2 that holds various types of information, and a network. And a communication unit 5 that transmits and receives various types of information to and from the client. Further, the control unit 1 checks whether the storage unit 2 holds data designated by the client (client computer user), and reads the data from the storage unit 2 if held. −1, a user recognition unit 1-2 that determines whether or not the user trying to connect using the client has access authority, and a record that is data in a specific format received from the client is stored in the storage unit 2 The storage unit 2 includes a database 2-1 for storing records that are data in a specific format received from each client.

  Next, the internal configuration of the client 101 will be described. The client 101 includes a control unit 1a that executes various processes in accordance with control of each unit constituting the client 101 and a user's instruction, a display unit 3a that displays various screens to the user in accordance with instructions from the control unit 1a, It includes an input unit 4a that acquires instruction information from the user and passes it to the control unit 1a, and a communication unit 5a that transmits and receives various types of information to and from a server or the like via a network. In addition, the control unit 1a notifies the server 100 of the user information and password received from the input unit 4a, and the access request unit 1a-1 requesting connection to the database 2-1 and the user through the input unit 4a. A search condition acquisition unit 1a-2 that acquires a search condition for the input data, and notifies the server 100 of the search condition received from the search condition acquisition unit 1a-2, and requests to transmit data that matches the search condition. Search request unit 1a-3 to be registered, and when there is data to be registered in server 100, registration request unit 1a-4 that requests registration of the data to server 100, and editing of data acquired from server 100 or An edit creation unit 1a-5 that creates data for new registration in the server 100, and a data that the registration request unit 1a-4 requests registration in the server 100. Is converted into a form for registering the server 100 also includes a data format conversion section 1a-6 to be converted to a format to be handled by the editing creation unit 1a-5 data received from the server 100.

  Here, the format of data registered in the database 2-1 constructed in the storage unit 2 of the server 100 will be described with reference to FIG. FIG. 4 is a diagram showing a configuration example of a record that is data stored in the database 2-1 of the server 100. As an example, accounting data (for example, by accounting application software) The structure of the record produced | generated based on the produced | generated data) is shown.

  As shown in FIG. 4, this record includes management information (approval flag, settlement flag, update date / time, updater user ID, registration date / time and registrant user ID) that is information for managing data, And actual accounting data (amount, account item, slip number, department, date,...).

  The approval flag is set to ON (usually ‘1’) when the superior of the user who created the accounting data approves the contents of the accounting data. The settlement flag is set to ON when settlement is performed using this accounting data. In either case, when the flag is set to ON, the accounting data can no longer be edited, and only the contents can be viewed. That is, editing of the accounting data is permitted only when both the approval flag and the settlement flag are OFF.

  The update date / time and the user ID of the updater are the date / time information at that time and the identification information of the user who performed the update when the data is updated. The registration date and the user ID of the registrant are date information when data is newly created and first stored (registered) in the database 2-1, and identification information of the user who has registered.

  Next, referring to FIGS. 3, 4, 5, 6-1 and 6-2, an operation for the client 101 to acquire necessary data from the server 100, and the acquired data after editing or new data The operation of storing the data in the server 100 after creating the file will be described. FIG. 5 is a diagram illustrating an example of a screen display (screen display content on the display unit 3a) that requests input of a user ID and a password necessary for the client 101 to connect to the server 100 with respect to the user. . FIGS. 6A and 6B are flowcharts illustrating an example of data transmission / reception processing performed between the client 101 and the server 100.

  Here, in the client server system of the present embodiment, it is assumed that only the creator of the data (the user who registered first) can edit the data stored in the database 2-1. And each user shall be able to browse the data created by other users who have the same access authority as himself / herself when the content of the data is confirmed and there is no possibility of updating. .

  Specific operations will be described below with reference to FIGS. 6-1 and 6-2. First, when the user inputs an instruction to start processing to acquire data from the server 100 using the client 101 from the input unit 4a, the display unit 3a displays a screen having the contents as shown in FIG. The user is requested to input a user name (ID) and password specified in advance.

  Thereafter, when the user inputs the user name and password using the input unit 4a and presses (clicks) the “OK” button shown in FIG. 5, the input user name and password are stored in the access request unit 1a-1. Passed to. The access request unit 1a-1 notifies the received user name and password to the server 100 via the communication unit 5a, and requests access using the user name (step S1).

  The user name and password notified from the client 101 in step S1 are passed to the user recognition unit 1-2 via the communication unit 5 of the server 100, and the user recognition unit 1-2 requests the user who requests access. It is determined whether or not the access is permitted (step S2). For example, the user ID indicating the user name notified from the client 101 is already registered in the user ID database (not shown) in the storage unit 2 and the corresponding password and the client 101 are registered. Allow access if the passwords notified by match.

  When the user recognition unit 1-2 permits access (step S2, Yes), the user ID that has received the notification is notified to the record search unit 1-1, and the record search unit 1-1 receives the notified user. A record (see FIG. 4) whose ID is included in the management information is searched from the records registered in the database 2-1 (step S3).

  In this step S3, a record including the notified user ID as an updater's user ID or a registrant's user ID is searched, and if there are a plurality of corresponding records, the user ID of the user ID is designated in advance. The highest priority record is determined as the search result according to the priority order or the default priority order.

  For this priority, for example, update date and time (registration date and time for records that do not include update date data) is used, and the newer one has a higher (or lower) priority. Note that the default priority is set higher for editable and newer update dates. In this way, for example, when data in the middle of work is temporarily registered in the server on the client side, and then the work is resumed, the data (record) that was in the middle of the previous work is preferentially searched. Thus, it is possible to reduce the work burden when resuming the work that has been interrupted (saving the search for data that was in the middle of work).

  An example of a method for specifying the priority order is as follows. First, in the client 101, a search condition input by the user using the input unit 4a (the update date period of the data to be searched, a new date and time) The search condition acquisition unit 1a-2 acquires which one of the old ones is to be given higher priority (financial status, approval status, slip number, slip type, etc.), and the acquired conditions are sent via the search request unit 1a-3. Send to server 100. In the server 100, the search condition received by the user recognition unit 1-2 is associated with the corresponding user ID and registered in the user data database described above. As a result, when an access request is received from a user, the server 100 can extract and provide only the data that the user needs. At this time, the user does not need to specify a search condition. Efficiency. Further, since the server holds the search condition, the user can obtain the same search result (access to the same data) when using any of a plurality of clients. Although it is impossible to obtain a desired search result only when a specific client is used, user data is stored when the client holds search conditions entered by the user and requests access to the server. A corresponding search condition may be transmitted to the server together with the password.

  On the other hand, if the user recognition unit 1-2 does not permit access in step S2 (step S2, No), information indicating that access with the user name requested as error processing cannot be accepted is transmitted to the client 101. (Step S4).

  Further, when a record (a user record corresponding to the notified user ID) including the notified user ID in the management information is registered in the database 2-1 in step S3 (step S5, Yes). The record search unit 1-1 reads the record with the highest priority from the database 2-1, and confirms whether or not the record is “finalized” or “approved” (step S6). ). Specifically, it is confirmed whether at least one of an approval flag or a settlement flag included in the record is set.

  When the read record is “finalized” or “approved” (step S6, Yes), the record search unit 1-1 determines that this record is not editable, and determines that record as a determination result. Along with (information indicating that the record cannot be edited), it is transmitted to the client 101 (step S7).

  On the other hand, if the read record is neither “finalized” nor “approved” (no approval flag and no finalization flag) (step S6, No), the record search unit 1-1 determines that this record is It is determined that the record can be edited, and only the record is transmitted to the client 101 (step S8).

  The information indicating the determination result is transmitted only in step S7. However, the determination result may be transmitted in step S8, and the determination result is not transmitted in step S7. The determination result may be notified only at.

  In the client 101 that has received the record from the server 100 in step S7 or S8, the received record (including the information of the determination result together with the information) is sent to the data format conversion unit via the communication unit 5a. 1 a-6, the data format conversion unit 1 a-6 converts the record that is the received data into data in a format (slip format) used when the user performs work, and edits the converted data. It is passed to 1a-5 (step S9). If the information indicating the determination result in step S6 has been received, the data format conversion unit 1a-6 passes the converted data together with the information to the edit creation unit 1a-5.

  Upon receiving the data from the data format conversion unit 1a-6, the edit creation unit 1a-5 stores the received data in a predetermined work area in the storage unit (not shown) and displays the contents based on the data. Is displayed on the display unit 3a to start editing or browsing the data (slip) (browsing as a read-only file) (step S10). FIG. 7 is a diagram illustrating an example of a screen display displayed on the result display unit 3a after executing Step S10. In this embodiment, the editing operation is started when only the data is received, and the browsing operation is started when the information indicating the determination result in step S6 is received together with the data. Further, instead of performing the determination process of step S6 on the server side, the determination may be made on the client side based on the states of the approval flag and the settlement flag. Thereby, processing on the server side can be reduced, and traffic on the network can be reduced because it is not necessary to transmit the determination result.

  If it is determined in step S5 that the user record corresponding to the notified user ID is not registered in the database 2-1 (step S5, No), the record created by the requested user is retained. The requesting client 101 is notified that the request has not been made (step S11). In the client 101 that has received the notification that the corresponding record is not held, the notification reaches the edit creating unit 1a-5 via the communication unit 5a and the data format converting unit 1a-6, and the edit creating unit 1a-5. Displays on the display unit 3a at the start of the new creation operation of the slip and starts the new creation operation (step S12).

  When the editing work is started in step S10 and when new creation is started by executing step S12, the registration request unit 1a-4 of the client 101 monitors whether the user has performed an editing or creating work end operation. (Step S13). When the user performs an operation for ending work (step S13, Yes), the registration request unit 1a-4 acquires data at the time when the ending operation is executed from the predetermined work area, and stores the data in the data format. The data is transferred to the conversion unit 1a-6. Then, the data format conversion unit 1a-6 converts the format into a record (see FIG. 4) when the received data is stored in the database 2-1 of the server 100 (step S14). Specifically, for the received data (accounting data), the approval state and the closing state at that time are reflected in the setting of the approval flag and the closing flag, and management information with updated update date / time information is added. . And it transmits to the server 100 via the communication part 5a (step S15).

  In the server 100, the user recognition unit 1-2 receives the record transmitted by the client 101, confirms the user ID (updater or registrant user ID) included in the management information, and uses a valid user ID. If there is, the received record is transferred to the record registration unit 1-3. On the other hand, if the user ID is not valid, the record is discarded (step S16). The determination method of whether the user ID is valid is determined to be valid if the user ID included in the management information has been registered in the user ID database, as in step S2.

  The record registration unit 1-3 determines whether or not the received record has been newly created. If the record has not been newly created (step S17, No), it is updated and registered in the database 2-1 (step S18). ). On the other hand, if it is newly created (step S17, Yes), it is newly registered in the database 2-1 (step S19).

  As described above, in this embodiment, the server is the data registered by the client and the data registered by the client having the same access authority with respect to each client (user), and the data whose contents are determined. (Only data that cannot be edited) can be accessed. As a result, it is possible to reduce the work load when searching for work target data, and to contribute to the efficiency of work. In addition, it is possible to prevent the data handled by other users from being updated or deleted by mistake, and to prevent other users from updating or deleting the data handled by the other users. it can.

  Furthermore, since the data to be accessed first is determined according to the predesignated condition (priority order), for example, the data that has been updated most recently and whose contents have not yet been determined (editable) If priority is given to access (data), it is possible to greatly reduce the procedure for searching for work target data when resuming work that has been interrupted, thereby improving work efficiency. Can do.

  In the above description, the data input confirmation method used in the client server system has been described. However, this data input confirmation method can also be applied to one computer. That is, the computer includes a record search unit 1-1, a user recognition unit 1-2, a record registration unit 1-3, and a storage unit 2 of the server 100, and an access request unit 1a-1 of the client 101, a search It is provided with a condition acquisition unit 1a-2, a search request unit 1a-3, a registration request unit 1a-4, an edit creation unit 1a-5, and a data format conversion unit 1a-6. If the data (data to be searched) is changed, the same effect as in the case where data management is performed in the client server system described above can be obtained.

  As described above, the data input confirmation method according to the present invention is suitable for a data input confirmation method for searching and providing desired data without requiring a search tool or a search operation for a user who uses a database. Yes.

It is a figure which shows the structural example of the client server system to which the data input confirmation method concerning this invention is applied. It is a figure which shows the structural example of the computer system which is provided with the function as a server apparatus for implement | achieving the data input confirmation method concerning this invention, and can execute the data input confirmation program concerning this invention. It is a figure which shows the structural example of the server which comprises a client server system, and a client. It is a figure which shows the example of a record structure of the data stored in the database of a server. It is a figure which shows an example of the input screen display of a user name and a password. It is a flowchart which shows an example of the transmission / reception process of the data performed between a client and a server. It is a flowchart which shows an example of the transmission / reception process of the data performed between a client and a server. It is a figure which shows an example of the screen display performed based on the data acquired from the server.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1, 1a Control part 1-1 Record search part 1-2 User recognition part 1-3 Record registration part 1a-1 Access request part 1a-2 Search condition acquisition part 1a-3 Search request part 1a-4 Registration request part 1a- DESCRIPTION OF SYMBOLS 5 Edit preparation part 1a-6 Data format conversion part 2 Storage part 2-1 Database 3, 3a Display part 4, 4a Input part 5, 5a Communication part 100 Server computer 101-106 Client computer

Claims (8)

The server device including a storage unit including a database for storing the accounting data received from the client device, together with notification of the user ID of the user from the client device when receiving an access request, require the client device accounting data to a data input confirmation method of providing to the client device,
When the setting section approves the contents of the accounting data, the approval flag associated with the accounting data is set to ON, and when the settlement is performed using the accounting data, the accounting data A setting step for turning on the settlement flag associated with the data;
Search unit, from the accounting data of the access requested, the includes the notified user ID as the user ID of the registrant of a user ID or renewer, and a search condition the storage unit holds The first search processing is performed to search whether accounting data satisfying the search condition corresponding to the notified user ID is stored in the database , while corresponding to the access request target accounting data. Whether accounting data including a user ID having authority equivalent to the notified user ID is stored in the database from among the accounting data for which the approval flag or the settlement flag is set to ON. A search step for performing a second search process for searching;
If the previous dangerous search unit, the searching step by the search results, it is determined that the desired accounting data is stored into the database, a reading step of reading the accounting data from the database,
A data transmission step in which the communication unit transmits the accounting data read in the reading step to the client device of the access request source;
The data input confirmation method characterized by including. Before the Ki読 heading step, when a plurality of accounting data in said retrieval step is determined to be stored into the database, reads the highest accounting data is priority determined based on the search condition from the database The data input confirmation method according to claim 1, wherein: Before or dangerous search unit, said authorization flag and the closing flag associated with the output has been accounting data read in said reading step among the accounting data retrieved by the first search process is set to ON In the case of accounting data for which none of the flags is set to ON, it is determined that the correction of the accounting data is permitted, while the approval flag or the settlement flag is set to ON. In the case of accounting data that has been corrected , a correction propriety determination step for determining that correction of the accounting data is not permitted ,
Including
The data input confirmation method according to claim 1 or 2, wherein, in the data transmission step, the determination result and the accounting data in the correction propriety determination step are transmitted. A server device that provides accounting data required by the client device to the client device when an access request is received together with the notification of the user ID of the user from the client device,
A storage unit including a database for storing accounting data received from the client device;
When approval is made for the contents of the accounting data, the approval flag associated with the accounting data is set to ON, and when settlement is performed using the accounting data, the accounting data is associated with the accounting data. A setting section for setting the set settlement flag to ON,
Among the access request target accounting data, the notified user ID is included as a registrant's user ID or an updater's user ID , and is a search condition held by the storage unit and notified. performing a first search process accounting data that meets the search condition corresponding to the user ID is searched whether stored into the database to read out the accounting data from the database, whereas, of the access request object Accounting data including a user ID having authority equivalent to the notified user ID is stored in the database from accounting data in which the approval flag or the settlement flag associated with accounting data is set to ON. Search for reading accounting data by performing a second search process for searching whether it is from the database And,
The last financial data dangerous search unit is read, a communication unit that transmits to the access requesting client device,
A server device comprising: Before dangerous search unit, when a plurality of accounting data is stored into the database, the highest accounting data priority determined based on the search condition to claim 4, characterized in that read from the database The server apparatus of description. Before dangerous search unit, said authorization flag and the closing flag associated with the retrieved account data by the first search process to determine if it is set to ON, also set on any of the flags In the case of accounting data that has not been processed, it is determined that correction of the accounting data is permitted. On the other hand, in the case of accounting data in which the approval flag or the settlement flag is set to ON, the accounting data Is determined not to be amended ,
The communication unit before the server device according to claim 4 or 5, characterized in that transmits the determination result and accounting data equivalent 該検 search section is read by the dangerous search unit. The server device according to any one of claims 4 to 6 ,
A client device that accesses the server device and receives provision of desired data;
A client-server system comprising: A data input confirmation program for causing a computer to execute the data input confirmation method according to any one of claims 1 to 3 .

Images