KR100374871B1 - Separated management system and method For Changing Data between service server and test server On Electronic Commerce - Google Patents

Abstract

The present invention provides a separate management system and method of the service providing server 206 and the test server 204 in the Internet e-commerce, and data from the test server 204 to the service providing server 206 for realizing the above-described method. It relates to the data change reflection manager 205 to safely reflect.

In more detail, the present invention manages data by separating the service providing server 206 and the test server 204, thereby reducing the possibility of data loss that may occur in Internet commerce and the possibility of an interruption of the server in service. The service providing server 206 serving the data of the test server 204 that is already built when the data change request of the database established in the Internet e-commerce system is provided for the stable operation of the server and the customer. It is an object of the present invention to provide a separate management system of the service providing server 206 and the test server 204 and its method, and a data change reflection manager 205 for realizing the method.

The present invention for solving the above problems,

A test server 204 for managing change information received from an operator and testing whether normal operation is performed; A service providing server 206 for managing information provided by the operator and providing a service related to the information to a customer; And a change reflection manager 205 for storing the change information managed by the test server 204 in the service providing server 206 at a time reserved by the operator.

Description

Separated management system and method For Changing Data between service server and test server On Electronic Commerce}

The present invention relates to a system and a method for separating and managing a service providing server and a test server in Internet electronic commerce, and a data reflecting server for realizing the method.

The prior art related to the present invention will be described in detail with reference to the drawings.

1 is a block diagram of an embodiment of a conventional Internet e-commerce system.

As shown in the figure, a conventional Internet e-commerce company (including a shopping mall where several individual stores are gathered and each Internet store operated by opening a homepage independently) (hereinafter, simply referred to as "store") In this case, the operator 103 of the store is connected to the service providing server 104 through an information communication network such as the Internet 102 to directly modify and delete the data of the store he manages, and at the same time uses the service. The customer 101 who wishes to access the service providing server 104 may also use various data provided by the store.

However, such operating systems are always insecure in many ways.

For example, if the customer's operator 103 is accessing the service providing server 104 and deleting the A product on display, and the customer was ordering the product immediately, this is an error or incorrect data. Is likely to be. Similarly, there is a problem in that the contents of commerce pages such as events, product classifications, and news that are currently used by the customer 101 accessing the service providing server 104 are exposed to a situation that may be changed by the store operator 103 at any time.

However, the operator 103 has no choice but to modify, delete, and manage the above data as long as the shopping mall is operated.

In the case of existing stores, this situation is exposed as it is, or the service can be stopped and resolved. However, in most cases, service downtime lasts for a long time, so this situation can be fatal to the continuity of the store service or the brand image of the store.

One of the methods to overcome the above-mentioned problems in the prior art is database replication. Database replication means that when a local organization with multiple branch offices wants to always maintain the same database for each branch, if there is a change on one of the database servers, the log file for the data change is automatically recognized. The changed data is read immediately by a log reader, and the read data is transferred to another local network database server requiring synchronization and updated to maintain the same data. (Based on the replication process in MS SQL). However, in a typical e-commerce system, a test time for sufficient data change is required before data change, and as described above, data change occurs at any one database server. The data must not be changed. This is because, as described above, an error may occur during the performance of the electronic commerce. Therefore, the change of the data of the service providing server 206 in the e-commerce should be performed for as short a time as possible without interrupting the service of the e-commerce site.

Summarizing the problems of the prior art as described above are as follows.

First, there is a problem that can not guarantee the stability of the data.

As described above, if the operator 103 deletes the goods A at the moment when the customer 101 tries to purchase the goods A registered on the service providing server 104 on the Internet page, the customer cannot buy the goods A or Or you might get an error handling if you bought something you couldn't actually buy. In other words, when such a case occurs, it always appears as an error, which not only gives the customer distrust about the site and the service, but also has a problem in that it cannot guarantee the stability of the data.

Second, there is a problem in that service continuity cannot be guaranteed.

In order to solve the first problem, the store operator 103 needs to modify the shopping mall by using a time when the customer does not shop. In this case, the service must be stopped. However, as long as the service on the Internet, there is no time that the customer does not use, there is a problem that can not guarantee the continuity of the service.

That is, as long as the store is operated, the service database in the service providing server 104 is constantly modified, and the exhibition page outside the shopping mall linked thereto is also changed. However, the very "looking up" not only helps customers to buy at all, but also impairs the brand image of the store and can cause fatal errors.

The present invention is to solve the above problems, by managing the data through the service providing server and the test server, to reduce the possibility of data loss that can occur in the Internet commerce test server to provide a stable operation and complete services to customers Its purpose is to provide data change reflection manager to reflect data from server to service providing server.

1 is a block diagram of an embodiment of a conventional Internet e-commerce system.

2 is a block diagram of an embodiment of an internet e-commerce system to which the present invention is applied.

3 is a flowchart illustrating a separation management method of a service providing server and a test server for reflecting data according to the present invention;

* Description of the symbols for the main parts of the drawings *

204: test server 206: service providing server

205: Change reflection manager

The present invention for achieving the above object, relates to a separate management system of the service providing server 206 and the test server 204 in the Internet e-commerce, to manage the change information received from the operator and to test whether the normal operation Test server 204; A service providing server 206 for managing information provided by the operator and providing a service related to the information to a customer; And a change reflection manager 205 for storing the change information managed by the test server 204 in the service providing server 206 at a time reserved by the operator.

In addition, the present invention in the data update method applied to the separate management system of the service providing server 206 and the test server 204 for data reflection in the Internet e-commerce, the test server 204 to change information received from the operator The first step of managing in the normal operation; A second step of transmitting the change information from the test server 204 to a service providing server 206 at a time reserved by the operator; And a third step in which the service providing server 206 reflects the change information and provides a service to a customer.

The present invention also provides an information communication system having a large capacity processor for data change in Internet e-commerce, the first function of managing change information received from an operator in a test server 204 and testing normal operation; A second function of transmitting the change information from the test server 204 to a service providing server 206 at a time reserved by the operator; And a data change reflection manager 205 for realizing a third function of providing a service to a customer by reflecting the change information in the service providing server 206.

That is, the present invention applies a technique of separating the two, while the conventional technique does not distinguish between the service providing server 206 and the test server 204 (data change information recording server).

In addition, the database of the service providing server 206 and the test server 204 is separated, and the database changes of the test server 204 are reflected in the database of the service providing server 206 at a predetermined time with the scheduler. In order to achieve this, both conditions of data stability and service continuity are satisfied.

That is, by separating the database DB of the service providing server 206 and the test server 204, the operator modifies the test server 204, and at the same time, the customer purchases the goods at the service providing server 206, Error caused by the data to be corrected can be blocked at the source, and the scheduler can be used to reflect the changes made by the administrator at the time specified by the manager (product, product classification, design, news, advertisement). This not only solves the continuity of services and the stability of store data naturally, but also enables marketing strategies to deliver desired services on time.

Hereinafter, a preferred embodiment of the present invention will be described in detail with reference to FIGS. 2 and 3.

2 is a block diagram of an embodiment of an Internet e-commerce system to which the present invention is applied, and FIG. 3 is a flowchart illustrating a data change method in Internet e-commerce according to the present invention.

As shown in the figure, when the operator 203 wants to perform operations such as input, modification, and deletion on various data of a service provided by the operator, the operator 203 first establishes a necessary database in the test server 204. (S302).

At this time, if necessary, it may be possible to find problems that may occur in the actual service providing step by performing a test operation (S304).

At this time, the time for the data upgrade to the service providing server 206 is reserved in advance, and when the scheduled time is reached (S306), the change reflecting manager 205 provides various data in the test server 204 to the service providing server. After moving to 206 (S308), the service is continuously provided to the customer 201 (S310). At this time, the various data are transferred to the service providing server 206 in a short time by a computer program that is already built, and since the use of the customer is selected at a less time, there is no inconvenience in using the customer.

In addition, since the customer 201 always accesses the service providing server 206 through an information communication network such as the Internet, a continuous and stable service can be provided.

That is, when the operator 203 deletes or modifies a product through the test server 204 and works on the design of the entire shopping mall for two hours, the customer may shop at the service providing server 206 that is not actually being modified. Therefore, the service can be used without any change.

At this time, the change reflection manager 205 is linked with a scheduler (scheduler) that can proceed with the operation according to the time reserved by the operator 203, when the operator 203 is set to midnight at 12 o'clock, The service providing server 206 is changed to the appearance desired by the operator by the change reflection manager 205 at 12 o'clock.

Next, an embodiment of the change reflection manager 205 will be described.

Reflect Changes The administrator is controlled by the scheduler and controls at least two databases. One of the above-described databases is for data interworking at the serviced website, and another is a preliminary database for testing for changes in the database of the serviced website. It is preferable that the two databases have different names, but there is no problem if the tables configured in the databases have the same names.

The database described above may be configured in one database server, or may be configured in database servers independent of each other. The service providing server 206 and the test server 204 of the present invention can also achieve the object of the present invention by designating one as a data providing server and setting the other as a data receiving server. .

It should be noted that data replication should occur only at a fixed time by the scheduler, not real-time data changes, and if data changes are large, it should be possible to perform data replication manually.

Another method is to create a script file consisting of a general database query, input the data to be changed in the test server 204, perform sufficient tests to confirm the stability of the database, and then execute the script composed of the above query. For example, it should be possible to update the database without interrupting service on the e-commerce site. As an example of the script, a table to be updated in the database of the service providing server 206 is deleted (delete table), and then a database table updated and tested by the test server 204 is inserted (insert table). Will be possible. In another embodiment, only the change in the database table of the test server 204 may be updated in the database table of the service providing server 206 by using the update command. It is also possible to delete and insert multiple tables into a script file instead of just updating one table, and also to update tables.

The present invention described above is capable of various substitutions, modifications, and changes without departing from the spirit of the present invention for those skilled in the art to which the present invention pertains. It is not limited to the drawing.

The present invention as described above, has the excellent effect that can significantly reduce the possibility of data loss that can occur in Internet commerce can provide a stable operation and a more complete service to customers.

In addition, since the databases of the service providing server 206 and the test server 204 can be separated to reflect changes at a predetermined time with the scheduler, both conditions of data stability and service continuity can be satisfied. That has an excellent effect.

Claims (6)

In the system for data change in Internet e-commerce, A test server for managing change information received from an operator and testing whether it operates normally; A service providing server for managing information provided by the operator and providing a service related to the information to a customer; And A data change for collectively storing the change information managed by the test means in the service providing server in correspondence to the time reserved by the operator without interruption of the service for the e-commerce site by means of a computer program that is already built. Separation management system of a service providing server and a test server in the Internet e-commerce, characterized in that it comprises a reflection manager. delete In the data change method applied to the manager to reflect data changes in the Internet e-commerce, A first step of managing change information received from an operator in a test server and testing whether normal operation is performed; Transmitting the change information from the test server to a service providing server at a time reserved by the operator; And A third step of providing a service to a customer by reflecting the change information in the service providing server; Separation management method of the service providing server and the test server in the Internet e-commerce comprising a. The method of claim 3, wherein the data change reflection manager reflecting data to the service providing server in step 3, (4-1) deleting the database table to be updated at a service providing server (delete table), And (4-2) inserting the tables to be updated tested at the test server into a service providing server. The method of claim 3, wherein the data change reflection manager reflecting data to the service providing server in step 3, Internet e-commerce, characterized in that for updating only the data to be changed in the service providing server by extracting only the changed data tested in the test server, without deleting the database table to be updated in the service providing server To Separately Manage Serving Servers and Test Servers on Windows In order to change data in the Internet e-commerce, information communication system having a large capacity processor, A first function of managing change information received from an operator in a test server and testing whether normal operation is performed; A second function of transmitting the change information from the test server to a service providing server at a time reserved by the operator; And And a computer-readable recording medium having recorded thereon a computer program composed of database operation words for realizing a third function of providing a service to a customer by reflecting the change information in the service providing server.