KR100830825B1 - Method for administering data in web environment - Google Patents

Abstract

The data processing method in the web environment according to the present invention, when a plurality of clients in the connectionless web environment to look up, modify or delete the same data existing in the database of the server through various forms, the collision between the clients between The present invention relates to a data processing method in a web environment that can efficiently manage data management by detecting and prioritizing the data sequentially and notifying the related processing clients.

Description

{Method for administering data in web environment}

1 is a conceptual diagram briefly showing the structure of a typical web environment.

2A is a conceptual diagram showing the structure of a data table included in a database of a web server.

2B is a conceptual diagram illustrating a structure of an accessible client information table included in a database of a web server.

2C is a conceptual diagram illustrating a structure of a deletion log table included in a database of a web server.

3A to 3C are flowcharts illustrating a data processing method in a web environment according to the present invention.

<Description of Symbols for Major Parts of Drawings>

30: Data table 31: Processing contents storage area

32: record field value storage area 33: processing time storage area

34: Process Client Unique Number 35: Process Type Storage Area

36: record identification number storage area

40: Accessible Client Information Table                 

41: Accessible Client Unique Number Storage Area

42: priority storage area

43: name storage area

44: contact storage area

50: delete log table

51: processing content storage area

52: Record field value storage area

53: Delete Time Storage Area

54: Processing Client Unique Number Storage Area

55: record identification number storage area

The present invention relates to a data management method of a database in a web environment, and particularly, in a case where a plurality of clients inquire in the connectionless web environment, look up, modify or delete the same data existing in the database of the server through various forms, The present invention relates to a data management method of a database in a web environment that can efficiently manage data management by detecting data priorities and assigning priorities to each other and processing the data sequentially.

1 is a conceptual diagram briefly illustrating a data management method in a web environment. The server 10 includes a web server 2, a CGI (Common Gateway Interface) program 4, and a database 6, a web browser, and the like. It consists of web clients 21-2N that connect to the server 10 using the connection program of to inquire, modify or delete the data.

The web clients 21-2N request the desired data to the server 10 through a web browser, and the server 10 receives the request to call the CGI program through the web server 2, and the CGI program is related. The database 6 is searched to return the inquiry details or to perform the database processing such as the requested modification or deletion, and to the client who requested the processing result.

After one client 21 inquires the data through a web browser, the other client 22 inquires the same data through the web browser, and then first revises the data inquired by the client 21 inquired, and later If the client 22 first revises the inquiry data without knowing whether the data has been modified by the client 21 who inquired the data of the web screen inquired first, the client 21 who inquired first displays the data modified by himself. It is not known if it has been modified again by the client 22 inquired later.

Similarly, after a client 21 inquires the data through a web browser, another client 22 inquires the same data through the web browser, and then revises the data inquired by the later-reviewed client 22, first. When the inquired client 21 revises the inquired data, the inquired client 22 does not know whether the revised material is revised by the inquired client 21 again.                         

In addition, after a client 21 inquires the data through a web browser, another client 22 inquires the same data through the web browser, deletes the data inquired by the client 21 inquired first, and later If the inquired client 22 attempts to delete the inquired data, the server 10 displays an error message that the data has already been deleted. In this case, there is no problem in the result, but confusion between clients may occur.

Similarly, after a client 21 inquires data through a web browser, another client 22 inquires the same data through a web browser, deletes the data inquired later by the client 22, and first If the inquired client 21 attempts to delete the inquired data, the server 10 displays an error message that the data has already been deleted. In this case, there is no problem in the result, but confusion between clients may occur.

On the other hand, after a client 21 inquires the data through a web browser and another client 22 inquires the same data through the web browser, the first client 21 inquires first deletes the data, and later retrieves the data. When the client 22 tries to correct the inquired data, the server 10 displays an error message that the modification failed because the data was deleted. In such a case, the later querying client 22 cannot know when and by which client the inquired data was deleted.

In addition, after a client 21 inquires data through a web browser, another client 22 inquires the same data through a web browser, and later revises the data inquired by a client 22, When the first querying client 21 deletes the inquired data, the first inquiring client 21 deletes the data without knowing whether the inquired data is modified by the inquiring client 22 later, and the inquiry later. One client 22 does not know whether the data he modified is deleted.

As such, when modifying a specific field for the data already viewed in the web environment and reflecting it in the database or deleting the searched data in the database, it is necessary to check whether multiple clients have modified or deleted the data after viewing the same data. The problem arises that there is a conflict between them.

An object of the present invention for solving the above problems, when a plurality of clients to query the data of the database in a web environment to modify specific fields or to delete the entire record corresponding to the data, to detect a conflict between them The data is processed by applying the priority given to the processing request client and the data is delivered to related processing clients to manage the data efficiently.

In the web environment of the present invention for achieving the above object, the data processing method, when any client inquires the data of the database to request processing according to the processing type, the final processing time and the time of the inquiry Compare the priorities, process the data according to the requested processing type according to the comparison result, or compare the priorities of the client with the priorities of the final clients and the high priority clients according to the comparison result. It is characterized by notifying the low priority client of the contents of the processing.

The above and other objects and features and advantages of the present invention will become more apparent from the following detailed description taken in conjunction with the accompanying drawings.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

In the web environment according to the present invention, the database data processing method simplifies the multiple clients and divides them into two clients (CL1 and CL2). In the whole flow, the server is continuously connected to the CGI program on the web server side. Access to the database can be prevented by the unique locking (locking) supported by the database.

On the other hand, after the server delivers the document to the client and is already viewed on the web screen, the connection to the database is lost. Therefore, the problem does not occur when database data is retrieved by one client and viewed on the web screen. However, when several clients call web CGI that searches and retrieves data from the database simultaneously, When a client attempts to arbitrarily modify, delete, or the like on the inquired data, a collision occurring can be solved by a database data processing method in a web environment according to the present invention.

2A to 2C are diagrams showing a table structure of a database for implementing a database data processing method in a web environment of the present invention.                     

FIG. 2A is a configuration diagram showing the structure of the data table 30, which includes a processing content storage area 31 for storing a record identification number (RID) and processing contents, and a data storage area for storing a record field value (ER) (FIG. 32), the processing storage area 31 includes a processing time storage area 33 for storing a processing time (ERT) of data, a unique number storage area 34 for storing a unique number (PID) of a processing client, A processing type storage area 35 for storing the processing type (modification or deletion) and a record identification number storage area 36 for storing the record identification number (RID).

The processing time storage area 33 stores the processing time ERT in the form of "year, month, hour, minute, and millisecond", and the processing type storage area 35 stores processing types such as data modification and deletion.

FIG. 2B is a block diagram showing the structure of the accessible client information table 40. The unique number storage area 41 stores the accessible client unique number (PMID) that can access the database, and the accessible client information. Priority storage area 42 for storing the priority (Pr), name storage area 43 for storing the name (NAME) of accessible clients, and contact storage area (44) for storing the contacts (CALL) of accessible clients ) And the like. Here, the contact storage area 44 stores a contact CALL such as an e-mail.

2C is a block diagram showing the structure of the deletion log table 50, which is a table for storing deleted records, and is configured for use after recovery.

The deletion log table 50 is composed of a processing contents storage area 51 for storing a record identification number (RID) and processing contents and a data storage area 52 for storing a record field value (ER). Here, the processing content storage area 51 is a deletion time storage area 51 for storing the deletion time ERT in the form of "year, month, date, minute, second, and millisecond", and a unique number for storing the unique number (PID) of the processing client. And an identification number storage area 55 for storing a storage area 54 and a record identification number RID.

3A to 3C are flowcharts illustrating a data processing method in a web environment in which a multi-client detects a collision according to a processing order and mediates it by priority when a multi-client inquires and processes the same data in a database. to be.

First, any client CL1 inquires the desired database data in its web browser (S1).

When the inquired client CL1 clicks a button for requesting processing (modification or deletion) of the inquired data on the current screen, the web browser of the inquired client CL1 displays a record identification number (RID) and a unique client identification number. (PID), data inquiry time (VT), processing type (modification or deletion) and detailed information to be processed (PREC) are sent to the web server (S2).

Subsequently, the CGI program determines whether the requested processing type is modification or deletion (S3).

First, if the requested processing type is modification, it is determined whether a record to be modified exists in the data table 30 (S4).

If there is a record to be corrected, the final processing time (ERT) of the material ER is compared with the web inquiry time (VT) of the material requested for correction (S5).                     

If the inquiry time VT is earlier than the final processing time ERT, the priority of the client CL2 that has searched the accessible client information table 40 and processed at the final processing time ERT of the currently queried data ( PrU) and the priority (PrC) of the client (CL1) requesting the current modification is compared (S6).

If the priority (PrC) of the client (CL1) that has requested modification is higher than the priority (PrU) of the client (CL2) processed at the last processing time (ERT) (S6), the modification request is made to the current data table (30). The material (ER) is corrected accordingly (S7), and the corresponding material (ER) is retrieved and processed by the contact CALL (for example, an email) of the client CL2 processed at the final processing time (ERT). In step S8, a success message indicating that the modification is completed is output on the web screen of the client CL1 that has requested the modification (S9).

If the priority (PrC) of the client (CL1) that has requested modification is lower than the priority (PrU) of the client (CL2) that has processed at the last processing time (ERT) (S6), the priority is given to the client (CL1) that has requested modification. Notifies that the data has already been modified by the high client CL2 (S10), and outputs an error message on the web screen (S11).

If the inquiry time (VT) is later than the final processing time (ERT) (S5), the data is corrected according to the current modification request in the data table 30 (S12), and the success indicating that the modification request is completed on the web screen. The message is output (S9).

On the other hand, if the record to be modified does not exist in the data table 30 (S4), it is determined by using the record identification number (RID) in the deletion log table 50 to determine whether the data exists (S13). Here, if the record to be modified does not exist in the deletion log table 50, an error message is output (S11).

If the record to be modified exists in the deletion log table 50 (S4), the accessible client unique number (PMID) of the accessible client information table 40 corresponding to the processing client unique number (PID) of the data table 30 is determined. The record DP having the priority DP PrD of the record DP and the accessible client identification number PMID of the client CL1 currently requested to modify in the accessible client information table 40 (CP) is searched and the priority (PrC) of the record CP is compared (S14).

If the priority PrD of the client CL2 that has already been deleted is lower than the priority PrC of the client CL1 that has requested modification, the deleted data is recovered in the data table 30 (S15). The contact CALL of the processing client CL2 deleted from the information table 40 is retrieved, and the deleted data is requested to the deleted processing client CL2 by the high-priority client CL1. Notify (S16), and revise the recovered data according to the correction request (S17).

Therefore, a success message indicating that the modification is completed is output to the client screen CL1 requesting the modification (S9).

If the priority PrD of the client CL2 that has already been deleted is higher than the priority PrC of the client CL1 that has requested modification, the data is requested by the client CL2 that has a higher priority to the client CL1 that has requested modification. Notify that the has been deleted (S18), and outputs an error message on the web screen (S11).

On the other hand, if the processing type is deletion, as shown in Fig. 3C, it is determined whether the record to be deleted exists in the data table 30 (S19).

If the record to be deleted does not exist in the data table 30, an error message indicating that the data has already been deleted is output to the web screen (S11).

If the record to be deleted exists in the data table 30, the final processing time (ERT) of the data is compared with the inquiry time (VT) of the data requested to be deleted (S20).

If the inquiry time (VT) of the requested deletion data is later than the final processing time (ERT), the corresponding data is deleted from the data table 30 (S21), and a success message is output to the web screen (S9).

If the inquiry time (VT) of the requested data to be deleted is earlier than the final processing time (ERT), the priority (PrU) of the client (CL2) processed at the final processing time (ERT) of the corresponding data and the client (CL1) currently requested to be deleted (CL1). ) Are compared (S22).

If the priority (PrU) of the client (CL2) processed at the last processing time (ERT) of the data is higher than the priority (PrC) of the client (CL1) that has requested the current deletion, the high priority client (CL2) An error message indicating that the data has been modified is output on the web screen (S11). At this time, the client CL1 requesting the deletion checks the data modified by the client CL2 having a high priority, and determines whether to delete or withdraw the deletion request.

If the priority (PrU) of the client (CL2) processed at the last processing time (ERT) of the corresponding material is lower than the priority (PrC) of the client (CL1) currently requested to be deleted, the corresponding data is deleted from the data table (30). In step S23, the contact CALL of the client CL2 that has been processed is searched and notified that the corresponding data has been deleted (S24), and a success message is output on the web screen (S9).

As described above, the database data processing method according to the present invention, when a plurality of clients inquiring the same data in a web browser to modify specific fields of the data or delete the entire record corresponding to the data Visually express various conflicting situations and apply the priorities assigned to each requesting client to process the data according to the priority and notify the processing clients of the data efficiently It can work.

In addition, a preferred embodiment of the present invention is for the purpose of illustration, those skilled in the art will be able to various modifications, changes, substitutions and additions through the spirit and scope of the appended claims, such modifications and changes are the following claims It should be seen as belonging to a range.

Claims (11)

delete In a method of processing data in a database in a web environment, If any client inquires the data of the database and requests the processing according to the processing type, Compare the final processing time of the inquired data with the inquired time, and according to the result of the comparison, process the data according to the requested processing type, or compare the priority of the client with the final processing and the priority of the inquiring client. By notifying the low priority client of the processing contents of the high priority client according to the comparison result, And wherein said arbitrary client transmits a unique number, an inquiry record identification number, an inquiry time, a processing type, and detailed information to be processed to said database. The method of claim 2, If any client inquires the data of the database and requests processing according to the processing type, And a process of determining whether the processing type is intended to modify or delete the inquired data. The method of claim 2, By comparing the final processing time of the inquired data with the inquired time, If the final processing time is earlier than the inquired time, the priority of the last processed client is compared with the priority of the inquired client, and if the priority of the last processed client is higher than the priority of the inquired client, an error is generated. Display a message, and if the priority of the last processed client is lower than the priority of the inquired client, the inquired data is processed according to the requested processing type, And if the final processing time is later than the inquired time, processing the inquired data according to the requested processing type. The method of claim 4, wherein If the final processing time is earlier than the inquired time and the priority of the last processed client is lower than the priority of the inquired client, the inquired data is processed according to the requested processing type, and the final processing And informing a client that the data has been processed by the arbitrary client. The method of claim 3, wherein If the determination result processing type is modification, If the inquired data has been deleted by the final processing client, the priority of the final processing client and the priority of the inquiring client are compared, If the priority of the final processing client is higher than that of the queried client, an error message is displayed, And when the priority of the final processing client is lower than the priority of the querying client, recovering the deleted data and modifying the data according to the processing request. The method of claim 6, If the processing type is modification and the priority of the last processed client is lower than the priority of the inquired client, the deleted data is recovered and the processing is performed according to the requested processing type, and to the last processed client. And notifying that the data has been recovered and modified by the arbitrary client. The method of claim 2, The database, Data table to store data, An accessible client information table for storing information of accessible clients; Method for processing data in a web environment comprising a delete log table for storing deleted data. delete delete The method of claim 8, In the deletion log table, A data processing method in a web environment comprising a deletion time, a processing client unique number, and a record identification number.

Images