JP2019057103A - Information management device, information management method and information management program - Google Patents

Abstract

To provide an information management device, an information management method and an information management program which can maintain the consistency of information with the outside.SOLUTION: An information management device includes a reception part, a storage part, an execution part, and a restoration part. The reception part receives a processing request on data processing. When contents of the data processing corresponding to the processing request includes access to external data out of management, the storage part acquires and stores external data from at least an external device managing external data. The execution part executes the data processing on the basis of the processing request. When the processing result of the data processing by the execution part is abnormal, the restoration part makes the external device restore the external data to a state before execution of the data processing on the basis of the storage data stored by the storage part.SELECTED DRAWING: Figure 3

Description

  The present invention relates to an information management apparatus, an information management method, and an information management program.

  In recent years, with the rapid spread of the Internet, advertisement distribution via the Internet has been actively performed. In such advertisement distribution, for example, advertisement contents such as companies and products are displayed in an advertisement space set in an advertisement medium such as a web page, and when such advertisement contents are clicked by the user, the browser display is displayed to the advertiser. Transition to the web page.

  Originally, an advertisement distribution system that realizes such an advertisement distribution is one in which each of the media companies individually receives advertisements from the advertiser and distributes them individually to the advertisement media managed and operated by the respective media companies. However, with the dramatic increase in demand for advertisement distribution, the complexity of manuscript submission and advertisement effect measurement for each publisher has also increased rapidly.

  For this reason, recent advertisement distribution systems distribute advertisements through transactions between systems that bundle many advertisers and advertising media, such as so-called DSP (Demand-Side Platform), SSP (Supply-Side Platform), and ad networks. It is changing to a large-scale network system that aims to improve efficiency and maximize profits.

  As such a network system, for example, a 3rd party ad server (3PAS), which is a central management system for rich media distribution and measurement of effects across media, is also known ( For example, see Patent Document 1).

JP 2006-099886 A

  However, since the above-described conventional technology has changed to a large-scale network system, there is a problem that it is difficult to maintain the consistency of information with the outside. For example, even if an advertisement information management device managed and operated by a certain media company tries to link the above-mentioned third-party delivery ad server managed by an external vendor with data, the access procedure is usually performed for external information. Is limited by API (Application Programming Interface) and the like, and the degree of freedom of data processing does not work.

  The present application has been made in view of the above, and an object thereof is to provide an information management apparatus, an information management method, and an information management program capable of maintaining the consistency of information with the outside.

  An information management apparatus according to the present application includes a reception unit, a storage unit, an execution unit, and a restoration unit. The reception unit receives a processing request related to data processing. The storage unit acquires and stores the external data from at least an external device that manages the external data when the content of the data processing corresponding to the processing request includes access to unmanaged external data. The execution unit executes the data processing based on the processing request. The restoration unit is configured to transfer the external data to the external device based on the saved data saved by the saving unit when the processing result of the data processing by the executing unit is abnormal. To restore.

  According to one aspect of the embodiment, it is possible to provide an information management apparatus, an information management method, and an information management program that can maintain the consistency of information with the outside.

FIG. 1 is a diagram illustrating an example of advertisement information management processing according to the embodiment. FIG. 2 is a diagram illustrating a configuration example of the advertisement information management system according to the embodiment. FIG. 3 is a block diagram illustrating a configuration example of the advertisement information management device according to the embodiment. FIG. 4 is a diagram illustrating an example of a library management information table. FIG. 5A is a process sequence diagram illustrating an example of a registration process. FIG. 5B is a process sequence diagram illustrating an example of the update process. FIG. 5C is a process sequence diagram illustrating an example of the deletion process. FIG. 6 is a flowchart illustrating a processing procedure executed by the advertisement information management apparatus according to the embodiment. FIG. 7 is a hardware configuration diagram illustrating an example of a computer that realizes the function of the advertisement information management apparatus.

  Hereinafter, a mode for carrying out an information management device, an information management method, and an information management program according to the present application (hereinafter referred to as “embodiment”) will be described in detail with reference to the drawings. In addition, the information management apparatus, the information management method, and the information management program according to the present application are not limited by this embodiment. In addition, the embodiments can be appropriately combined within a range that does not contradict processing contents. In the following embodiments, the same portions are denoted by the same reference numerals, and redundant description is omitted.

[1. Example of advertising information management process)
First, an example of the advertisement information management process according to the embodiment will be described with reference to FIG. FIG. 1 is a diagram illustrating an example of advertisement information management processing according to the embodiment. In FIG. 1, the advertisement information management apparatus 100 (corresponding to an example of “information management apparatus”) according to the embodiment receives a processing request related to data processing, and the content of the data processing corresponding to the processing request is external data that is not managed. In the case of including access to the server, the external data is acquired and stored from at least an external device that manages the external data, the data processing is executed based on the processing request, and the processing result of the data processing is abnormal An example is shown in which data linkage is performed to execute processing for causing an external device to restore external data to a state before execution of data processing based on the stored data.

  In the following, a web page will be described as an example of an advertising medium, but the advertising medium may be an advertising medium other than a web page. For example, the advertisement medium may be a medium displayed by a game application, a book browsing application, a music distribution application, or a video distribution application.

  An advertisement information management device 100 included in the advertisement information management system 1 according to the embodiment shown in FIG. 1 is a database of internal data (hereinafter referred to as “DB”) related to advertisement information managed and operated by a publisher A, for example. This is a server device that manages the internal DB group 41.

  In addition, when the advertisement information management apparatus 100 receives an advertisement request that is a distribution request for advertisement content from the user U, the advertisement distribution apparatus 30-that is a distribution request destination for the advertisement content distribution request for the advertisement request. 1 and 30-2 can also serve as a server device related to advertisement distribution.

  First, in order to make the explanation of this embodiment easy to understand, from the aspect related to the advertisement distribution, more specifically, an example of processing executed by the advertisement information management system 1 including the advertisement information management apparatus 100 is followed along the flow. I will explain.

  As shown in FIG. 1, first, when the web server 20 receives a page request (step S <b> 1) transmitted from the terminal device 10 used by the user U, it transmits a web page WP corresponding to the page request to the terminal device 10. (Step S2).

  When the terminal device 10 receives the web page WP including the advertising space AF from the web server 20, the terminal device 10 transmits an advertisement request to the advertisement information management device 100 (step S3). The advertisement request is, for example, a request for distributing advertisement content to be displayed in the advertisement frame AF set on the web page WP.

  When the advertisement information management apparatus 100 receives an advertisement request from the terminal device 10, the advertisement information management apparatus 100 selects a distribution request destination as an extraction source of advertisement content corresponding to the advertisement request, and transmits the distribution request (step S4). The distribution request destination is selected from either one or both of the advertisement distribution devices 30-1 and 30-2 in the example of FIG. Further, in the example of FIG. 1, the advertisement distribution apparatus 30-1 is operated and managed by the media company A, and the advertisement distribution apparatus 30-2 is operated and managed by the advertisement distribution company B.

  The advertisement distribution apparatuses 30-1 and 30-2 that are the extraction sources of the advertisement content to be distributed to the distribution request destination, that is, the advertisement space AF, transmit the advertisement contents corresponding to the distribution request to the advertisement information management apparatus 100 (step S5). ).

  Then, the advertising information management device 100 transmits the advertising content received from the advertising distribution devices 30-1 and 30-2 to the terminal device 10 (step S6). Thereafter, the terminal device 10 displays, for example, the advertising content A01 transmitted from the advertising information management device 100 in the advertising space AF (step S7). Note that the advertisement distribution devices 30-1 and 30-2 may directly transmit the advertising content to the terminal device 10 without going through the advertising information management device 100.

  By the way, in recent years, the network system related to advertisement distribution has been further expanded. For example, a third-party distribution ad server (hereinafter referred to as “third-party server”) is used for rich media distribution and measurement of effects across media. 70 ”) may be used. The “third party” mentioned here refers to a so-called “third party”.

  For example, the third party server 70 functions as a back-end server of the advertisement distribution apparatus 30-1 of the publisher A, and, for example, in response to a distribution request (step S4-1) from the advertisement distribution apparatus 30-1. The advertising content is transmitted from the advertising content group whose source is the external DB group 71 of the external data managed and operated by the distributor C (step S4-2).

  However, in the example of FIG. 1, the third party distributor C manages each external data using “unique ID” which is identification information unique to the data. On the other hand, on the side of the media company A, internal data related to advertisement distribution is managed by “advertisement distribution tag” as shown in the figure.

  The “advertisement distribution tag” is information including various parameters included in the distribution request, and it is necessary to specify a “unique ID” for each corresponding data for the third party server 70. Therefore, for example, when there is a change in the setting contents of the “advertising distribution tag”, the “unique ID” associated with the “advertising distribution tag” is designated, and the change is also made on the third party distributor C side. Must be reflected.

  That is, as shown in FIG. 1, the internal DB group 41 on the publisher A side and the external DB group 71 on the third party distributor C side must always be “data linked” to maintain consistency. For access to external data in the external DB group 71, an API provided from the third party distributor C side is usually used. However, this means that access to external data in the external DB group 71 is restricted by the API.

  Therefore, the advertisement information management apparatus 100 according to the embodiment accepts a processing request related to data processing so that the consistency of information with the outside can be maintained even under the restriction by the API, and data corresponding to the processing request. If the content of the process includes access to external data that is not managed, acquire the external data from at least the external device that manages the external data, save it, execute the data processing based on the processing request, and perform data processing. When the processing result is abnormal, the external device is made to restore the external data to the state before the data processing based on the stored data.

  For example, the advertisement information management apparatus 100 updates the “update process” for updating both the internal data corresponding to the advertisement distribution tag and the external data corresponding to the unique ID, and the “deleting process” for deleting both. In such a case, external data is acquired and stored in advance using an API so that at least the state of existing external data can be restored even if data processing fails. Then, when the processing result of the data processing is abnormal, the advertising information management apparatus 100 restores the third party server 70 via the API based on the stored data.

  Thereby, the advertisement information management apparatus 100 can maintain the consistency of information between the internal DB group 41 and the external DB group 71. In the description of the present embodiment, as a specific example of data processing, in addition to the above-mentioned “update processing” and “deletion processing”, “registration processing” for newly registering both internal data and external data is taken as an example. I will give you. Specific examples thereof will be described later with reference to FIGS. 5A to 5C.

  Hereinafter, the configuration and the like of the advertisement information management apparatus 100 that performs such processing and the advertisement information management system 1 including the advertisement information management apparatus 100 will be described in detail.

[2. Configuration of Advertising Information Management System 1]
Next, the configuration of the advertisement information management system 1 including the advertisement information management apparatus 100 according to the embodiment will be described with reference to FIG. FIG. 2 is a diagram illustrating a configuration example of the advertisement information management system 1 according to the embodiment. As shown in FIG. 2, the advertisement information management system 1 according to the embodiment includes a terminal device 10, a web server 20, a plurality of advertisement distribution devices 30-1 and 30-2, a DB server 40, and an API server. 50, a third party server 70, an advertisement information management device 100, an internal DB group 41, and an external DB group 71 are included.

  As shown in FIG. 2, these various apparatuses are connected via a communication network N so that they can communicate with each other by wire or wirelessly. The advertisement information management system 1 includes a plurality of terminal devices 10, a plurality of advertisement information management devices 100, and, for example, three or more advertisement distribution devices 30-1, 30-2, 30-3,. May be. Further, the advertisement information management system 1 may include a plurality of API servers 50, third party servers 70, internal DB groups 41, and external DB groups 71.

  As illustrated in FIG. 2, the web server 20, the advertisement information management device 100, the advertisement distribution device 30-1, and the DB server 40 are managed and operated by a media company A, for example. The internal DB group 41 is connected to the DB server 40, for example. The DB server 40 and the advertisement information management apparatus 100 are seamlessly linked, and the advertisement information management apparatus 100 is similar to accessing the data of its own apparatus without using an API or the like. Can handle internal data.

  Further, the advertisement distribution device 30-2 is managed and operated by, for example, the advertisement distributor B. Further, the API server 50 and the third party server 70 are managed and operated by a third party distributor C, for example. The external DB group 71 is connected to, for example, the third party server 70.

  The terminal device 10 is an information processing device used by the user U. For example, a browser is installed in the terminal device 10. FIG. 2 illustrates a case where the terminal device 10 is a notebook PC. The terminal device 10 may be, for example, a tablet terminal, a desktop PC (Personal Computer), a notebook PC, a smartphone, a mobile phone other than a smartphone, or a PDA (Personal Digital Assistant).

  The web server 20 stores various web pages in which advertisement spaces are set. When the web server 20 is accessed from the browser of the terminal device 10, various web pages corresponding to a URL (Uniform Resource Locator) designated by the terminal device 10, for example, a portal site, news site, weather forecast site, shopping Various web pages related to websites, finance (stock price) sites, route search sites, map providing sites, travel sites, restaurant introduction sites, web blogs, etc.

  When the browser of the terminal device 10 receives the web page from the web server 20, an advertisement request corresponding to the advertisement space set in the web page (hereinafter sometimes simply referred to as “request”) is sent to the advertisement information management device 100. Send to. The request is a request for distribution of advertising content to be displayed in the advertising space. For example, the user U identification information (hereinafter referred to as “user ID”) of the terminal device 10 or the advertising space identification information (hereinafter referred to as “advertisement space”). ID ”). The user ID is, for example, an HTTP cookie (HyperText Transfer Protocol Cookie: hereinafter referred to as “cookie”). Since such cookie does not include user information such as the age and sex of the user U, the user information held on each server side is associated with the cookie ID from the terminal device 10 side and used for targeting and the like.

  The advertisement distribution devices 30-1 and 30-2 are “extraction sources” of advertisement content, and are, for example, predetermined ad networks. When the advertisement distribution device 30-1 or 30-2 receives the advertisement content distribution request from the advertisement information management device 100, the advertisement distribution device 30-1 or 30-2 receives the advertisement content from the advertisement content group stocked in the advertisement distribution device 30-1 or 30-2. Is distributed according to the content of the distribution request.

  The DB server 40 is a server device that manages and operates the internal DB group 41. The API server 50 receives a processing request for data processing with respect to the external DB group 71 through the API, interprets the processing request, executes data processing with respect to the external DB group 71, and returns the result to the transmission source of the processing request. It is. The third party server 70 is a server device that manages and operates the external DB group 71, and is, for example, 3PAS.

  As described above, the advertisement information management apparatus 100 receives a processing request related to data processing of advertisement distribution, and at least the external data when the content of the data processing corresponding to the processing request includes access to external data that is not managed. The external data is acquired and stored from the external device that manages the data, the data processing is executed based on the processing request, and if the processing result of the data processing is abnormal, the external data is stored in the external device based on the stored data. This is a server device that restores external data to a state before execution of data processing.

[3. Advertising Information Management Device 100]
Next, the configuration of the advertisement information management apparatus 100 will be described with reference to FIG. FIG. 3 is a block diagram illustrating a configuration example of the advertisement information management device 100 according to the embodiment. In FIG. 3, only components necessary for the description of the advertisement information management apparatus 100 are shown, and descriptions of general components are omitted.

  As illustrated in FIG. 3, the advertisement information management apparatus 100 includes a communication unit 110, a storage unit 120, and a control unit 130. The advertisement information management apparatus 100 includes an input unit (for example, a keyboard and a mouse) that receives various operations from an operator who uses the advertisement information management apparatus 100, and a display unit (for example, a liquid crystal display) for displaying various types of information. Etc.).

(About the communication unit 110)
The communication unit 110 is realized by, for example, a NIC (Network Interface Card). The communication unit 110 is connected to the communication network N by wire or wirelessly, and via the communication network N, the terminal device 10, the advertisement distribution devices 30-1 and 30-2, the DB server 40, the API server 50, a third party. Information is transmitted to and received from the server 70.

(About the storage unit 120)
The storage unit 120 is realized by, for example, a semiconductor memory device such as a RAM (Random Access Memory) or a flash memory, or a storage device such as a hard disk or an optical disk. As illustrated in FIG. , Library management information 121 and storage information 122 are stored.

(About library management information 121)
The library management information 121 includes internal data stored in the internal DB group 41 of the DB server 40 to be processed for each data process requested for processing to the advertisement information management apparatus 100, and a third party server. This is library information associated with external data stored in 70 external DB groups 71.

  Here, FIG. 4 shows an example of a library management information table included in the library management information 121. FIG. 4 is a diagram illustrating an example of a library management information table.

  In the example illustrated in FIG. 4, the library management information table includes items such as “transaction ID”, “target entity ID”, “target DBID”, and “management classification”.

  “Transaction ID” indicates identification information of each data process executed by the advertisement information management apparatus 100 for one or both of the internal DB group 41 and the external DB group 71. “Target entity” indicates identification information of an entity (for example, a data item) to be processed in each data process.

  “Target DBID” indicates identification information of a target DB related to an entity to be processed. “Management classification” indicates whether each target DB is “internal” or “external” when viewed from the advertisement information management apparatus 100 side. That is, key information indicating “inside” or “outside”. In the present embodiment, “internal” corresponds to the internal data of the internal DB group 41, and “external” corresponds to the external data of the external DB group 71.

  In the example of the data illustrated in FIG. 4, the transaction ID “TR001” is the target entity ID “E001”, “E002”,..., And the target entity ID “E001” is the target DBID “DB001”. ”And the management classification“ internal ”, that is, internal data of the internal DB group 41. On the other hand, the target entity ID “E002” is stored in the DB of the target DBID “DB002”, and indicates that the management classification is “external”, that is, external data of the external DB group 71.

(About saved information 122)
Returning to the description of FIG. The stored information 122 is at least prior to data processing when the content of data processing requested for the advertisement information management apparatus 100 includes access to external data stored in the external DB group 71 that is not managed. It is information acquired and stored from a third party server 70 that manages such external data. The storage information 122 is stored by the storage unit 134 described later.

(About the control unit 130)
The control unit 130 is a controller, for example, various programs (advertisement information management) stored in a storage device inside the advertisement information management device 100 by a CPU (Central Processing Unit), an MPU (Micro Processing Unit), or the like. (Corresponding to an example of a program) is implemented by executing the RAM as a work area. The control unit 130 is, for example, a controller, and is realized by an integrated circuit such as an application specific integrated circuit (ASIC) or a field programmable gate array (FPGA).

  As shown in FIG. 3, the control unit 130 includes a collection unit 131, a reception unit 132, a determination unit 133, a storage unit 134, an execution unit 135, and a restoration unit 136. Information described below Implement or execute a processing function or action. Note that the internal configuration of the control unit 130 is not limited to the configuration illustrated in FIG. 3, and may be other configurations as long as the information processing described below can be performed. Further, the connection relationship between the processing units included in the control unit 130 is not limited to the connection relationship illustrated in FIG. 3, and may be another connection relationship.

(About the collection unit 131)
The collection unit 131 accesses each DB of the internal DB group 41 and the external DB group 71 set in advance via the communication unit 110 and the communication network N, and periodically collects internal structure information. The collection unit 131 reflects the collected contents in the library management information 121.

(About the reception unit 132)
The accepting unit 132 accepts processing requests related to data processing such as “registration processing”, “update processing”, and “deletion processing” of internal data and external data via the communication unit 110 and the communication network N, for example. Such processing request includes, for example, the above-mentioned “transaction ID”. Note that the processing request may be received by an operation via an input unit such as a keyboard (not shown).

(About the discriminating unit 133)
The determination unit 133 checks the content of the data processing included in the processing request received by the receiving unit 132, for example, “transaction ID” against the library management information 121, and the requested data processing is performed by the third party server 70 that is not managed. It is determined whether or not access to external data managed by the server is included. In the case of including access to external data, the determination unit 133 causes the storage unit 134 to store the corresponding external data, and then causes the execution unit 135 to execute data processing corresponding to the processing request. On the other hand, when the access to the external data is not included, the determination unit 133 causes the execution unit 135 to execute the data processing corresponding to the processing request as it is.

(About the storage unit 134)
When the determination unit 133 determines that the requested data processing includes access to external data managed by the third-party server 70 that is not managed, the storage unit 134 determines whether the API (ie, , The corresponding external data is acquired from the third party server 70 via the API server 50) and stored in the storage information 122.

(About the execution unit 135)
The execution unit 135 executes data processing corresponding to the processing request while accessing the internal DB group 41 and the external DB group 71 as appropriate according to the processing content of the data processing via the communication unit 110 and the communication network N. As described above, the execution unit 135 can seamlessly access the internal DB group 41 through the communication network N. On the other hand, the execution unit 135 accesses the external DB group 71 by a predetermined access procedure via the API server 50. These points also apply to the restoration unit 136 described later.

  In addition, the execution unit 135 automatically deletes the storage information 122 when the processing result of the executed data processing is normal. Further, the execution unit 135 causes the restoration unit 136 to execute restoration processing when the processing result of the executed data processing is abnormal.

(About the restoration unit 136)
When the processing result of the data processing by the execution unit 135 is abnormal, the restoration unit 136 stores the corresponding external data in the external DB group 71 in the third party server 70 based on the storage information 122 stored by the storage unit 134. Is restored to the state before the data processing is executed.

  In addition, the restoration unit 136 automatically deletes the storage information 122 when the result of the executed restoration process is normal. Note that the restoration unit 136 does not have to delete the storage information 122 in order to identify the cause of the abnormal processing result of the data processing by the execution unit 135.

(Specific examples of registration processing)
Next, a specific example of the registration process executed by the advertisement information management system 1 according to the embodiment will be described with reference to FIG. 5A. FIG. 5A is a process sequence diagram illustrating an example of a registration process. In this processing sequence diagram, it is assumed that both internal data of the internal DB group 41 and external data of the external DB group 71 are to be processed. This also applies to the description using FIGS. 5B and 5C described later.

  The explanation starts from “normal”. As shown in FIG. 5A, in the “registration process”, first, the execution unit 135 of the advertisement information management apparatus 100 seamlessly converts the registration data based on the contents included in the data processing request to the internal DB group 41 of the DB server 40. (Step S101).

And the execution part 135 of the advertisement information management apparatus 100 calls API, and transmits the registration request of the same registration data (step S102). The registration request is transmitted to the third party server 70 via the API server 50 (step S103), and the third party server 70 registers data in response to the registration request. At this time, a unique ID is issued for new registration data. Here, it is assumed that the unique ID _A is issued.

Then, the third party server 70 transmits the unique ID _A to the API server 50 (step S104), and the API server 50 further transmits this to the advertisement information management apparatus 100 (step S105).

The execution unit 135 of the advertisement information management apparatus 100 adds the received unique ID _A to the internal data registered in step S101 of the internal DB group 41 of the DB server 40 (step S106). Thus, the execution unit 135 ends the registration process by associating the internal data and the external data registered this time.

Next, “abnormal time” will be described. Here, it is assumed that “addition” in step S106 has ended abnormally (step S107). In such a case, the restoration unit 136 of the advertisement information management apparatus 100 calls an API and transmits a request to delete external data corresponding to the unique ID _A (step S108). The deletion request is transmitted to the third party server 70 via the API server 50 (step S109), and the third party server 70 deletes the corresponding data in response to the deletion request.

Then, the third party server 70 transmits a deletion response indicating that the external data corresponding to the unique ID _A has been deleted to the API server 50 (step S110), and the API server 50 further transmits this to the advertisement information management device 100. (Step S111). As a result, the restoration process performed by the restoration unit 136 when the registration process is abnormal ends.

  As described above, the restoration unit 136 executes a registration process in which the execution unit 135 newly registers internal data and external data as data processing, and when the processing result of the registration process is abnormal, the new external data is stored. If the unique ID to be identified has been acquired from the third party server 70, a deletion request for deleting the unique ID and the external data corresponding to the unique ID is transmitted to the third party server 70.

  Thereby, even if the registration process is abnormally terminated, consistency between the internal data and the external data can be maintained.

(Specific examples of update processing)
Next, a specific example of the update process executed by the advertisement information management system 1 according to the embodiment will be described with reference to FIG. 5B. FIG. 5B is a process sequence diagram illustrating an example of the update process.

  The explanation starts from “normal”. As shown in FIG. 5B, in the “update process”, first, the storage unit 134 of the advertising information management apparatus 100 calls an API to acquire an external data to be processed and transmits it to the API server 50 (step S201). .

  The acquisition request is transmitted to the third party server 70 via the API server 50 (step S202), and the third party server 70 extracts and acquires external data from the external DB group 71 in response to the acquisition request.

  Then, the third party server 70 transmits the acquired acquisition data to the API server 50 (step S203), and the API server 50 further transmits this to the advertisement information management apparatus 100 (step S204).

  The storage unit 134 of the advertisement information management apparatus 100 stores the received acquired data as storage information 122 (step S205). Then, the execution unit 135 sets update data based on the contents included in the data processing request (step S206), calls the API, and transmits the update request including the update data to the API server 50 (step S207). ).

  The update request is transmitted to the third party server 70 via the API server 50 (step S208), and the third party server 70 updates the corresponding external data in the external DB group 71 in response to the update request.

  Then, the third party server 70 transmits an update response indicating that the corresponding external data has been updated to the API server 50 (step S209), and the API server 50 further transmits this to the advertisement information management device 100 (step S209). S210).

  After receiving the update response, the execution unit 135 of the advertisement information management apparatus 100 updates the content of the same update data by reflecting the corresponding internal data in the internal DB group 41 of the DB server 40 (step S211). Then, the execution unit 135 deletes the storage information 122 that is the storage (step S212), and ends the update process.

  Next, “abnormal time” will be described. Here, it is assumed that “update” in step S211 has ended abnormally (step S213). In such a case, the restoration unit 136 of the advertisement information management apparatus 100 reads out and acquires the saved information 122 that is the saved amount (step S214), calls the API, and transmits an update request for the saved amount (step S215).

  The update request is transmitted to the third party server 70 via the API server 50 (step S216), and the third party server 70 updates the corresponding external data in response to the update request.

  Then, the third party server 70 transmits an update response indicating that the corresponding external data has been updated to the API server 50 (step S217), and the API server 50 further transmits this to the advertisement information management apparatus 100 (step S217). S218). Then, the restoration unit 136 deletes the saved information 122 for saving (Step S219). As a result, the restoration process performed by the restoration unit 136 when the update process is abnormal ends.

  As described above, when the execution unit 135 executes update processing for updating internal data and external data as data processing, the storage unit 134 updates the external data to be processed before the update processing is executed. Obtain from the server 70 and save. In addition, when the processing result of the update process executed by the execution unit 135 is abnormal, the restoration unit 136 determines that the external data has been updated by the third party server 70. Then, an update request for updating the external data of the external DB group 71 with the content of the storage information 122 stored by the storage unit 134 is transmitted.

  As a result, even if the update process ends abnormally, consistency can be maintained between the internal data and the external data.

(Specific examples of deletion processing)
Next, a specific example of the deletion process executed by the advertisement information management system 1 according to the embodiment will be described with reference to FIG. 5C. FIG. 5C is a process sequence diagram illustrating an example of the deletion process.

The explanation starts from “normal”. As shown in FIG. 5C, in the “deleting process”, first, the storage unit 134 of the advertising information management apparatus 100 calls an API to acquire an external data to be processed and transmits it to the API server 50 (step S301). . At this time, for example, a unique ID associated with the advertisement distribution tag is designated. Here, for example, the unique ID _A is assumed.

The acquisition request is transmitted to the third party server 70 via the API server 50 (step S302), and the third party server 70 sends external data corresponding to the unique ID _A corresponding to the acquisition request from the external DB group 71. Extract and get.

  Then, the third party server 70 transmits the acquired acquisition data to the API server 50 (step S303), and the API server 50 further transmits this to the advertisement information management apparatus 100 (step S304).

The storage unit 134 of the advertisement information management apparatus 100 stores the received acquired data as storage information 122 (step S305). Then, the execution unit 135 calls the API and transmits a request to delete the external data corresponding to the unique ID _A (step S306). The deletion request is transmitted to the third party server 70 via the API server 50 (step S307), and the third party server 70 deletes the corresponding external data in response to the deletion request.

Then, the third party server 70 transmits a deletion response indicating that the external data corresponding to the unique ID _A has been deleted to the API server 50 (step S308), and the API server 50 further transmits this to the advertisement information management device 100. (Step S309).

Then, the execution unit 135 deletes the corresponding internal data in the internal DB group 41 of the DB server 40 that is associated with the unique ID _A (step S310). Then, the execution unit 135 deletes the storage information 122 that is the storage (step S311), and then ends the deletion process.

  Next, “abnormal time” will be described. Here, it is assumed that “deletion” in step S310 has ended abnormally (step S312). In such a case, the restoration unit 136 of the advertisement information management apparatus 100 reads and acquires the saved information 122 that is the saved amount (step S313), calls the API, and transmits a registration request for the saved amount (step S314).

The registration request is transmitted to the third party server 70 via the API server 50 (step S315), and the third party server 70 newly registers external data in response to the registration request. At this time, a unique ID is issued for new registration data. Here, it is assumed that the unique ID _B has been issued.

Then, the third party server 70 transmits the unique ID _B to the API server 50 (step S316), and the API server 50 further transmits this to the advertisement information management apparatus 100 (step S317).

The restoration unit 136 of the advertisement information management apparatus 100 updates the corresponding internal data of the internal DB group 41 of the DB server 40 with the received unique ID _B (step S318). Then, the restoration unit 136 deletes the saved information 122 that is saved (step S319). Thereby, the restoration process when the deletion process is abnormal by the restoration unit 136 ends.

  As described above, when the execution unit 135 executes a deletion process for deleting internal data and external data as a data process, the storage unit 134 removes the external data to be processed before the deletion process is executed. Obtain from the server 70 and save. In addition, when the processing result of the deletion process executed by the execution unit 135 is abnormal, the restoration unit 136 determines that the external data has been deleted by the third party server 70. The registration request for newly registering the external data of the external DB group 71 with the content of the storage information 122 stored by the storage unit 134 is transmitted, and the new unique ID issued in response to the registration request is deleted. It is related to the internal data of the internal DB group 41 before being processed.

  Thereby, even if the deletion process is abnormally terminated, consistency between the internal data and the external data can be maintained.

[4. Processing procedure of advertisement information management apparatus 100]
Next, a processing procedure executed by the advertisement information management apparatus 100 according to the embodiment will be described. FIG. 6 is a flowchart illustrating a processing procedure executed by the advertisement information management device 100 according to the embodiment.

  As illustrated in FIG. 6, first, the collection unit 131 collects information about the DB as needed (step S1001).

  And the reception part 132 receives the process request regarding data processing at any time. Here, when the reception unit 132 receives a processing request (step S1002, Yes), the determination unit 133 determines whether the data to be processed includes external DB data (step S1003). In addition, when the reception part 132 does not receive a process request (step S1002, No), step S1002 is repeated.

  If it is determined in step S1003 that the external DB data is included (step S1003, Yes), the storage unit 134 acquires and stores target data to be processed (step S1004). If it is determined in step S1003 that the external DB data is not included (step S1003, No), the control is transferred to step S1005.

  Subsequently, the processing type is determined based on the accepted processing request (step S1005). The processing type corresponds to the transaction ID described above. When the process type is “registration” (step S1005, registration), the execution unit 135 executes a registration process (step S1006).

  If the process type is “update” (step S1005, update), the execution unit 135 executes the update process (step S1007).

  If the process type is “delete” (step S1005, delete), the execution unit 135 executes the delete process (step S1008).

  Then, it is determined whether or not each process has ended abnormally (step S1009). If it is determined that the process has ended abnormally (step S1009, Yes), the restoration unit 136 executes a restoration process according to the process type (step S1010). When it is determined that the process has not ended abnormally (step S1009, No), the control is transferred to step S1011.

  If there is an end event (step S1011, Yes), the advertising information management apparatus 100 ends the process. The end event is an event such as power off, for example. If there is no end event (step S1011, No), the advertisement information management apparatus 100 repeatedly executes the processing from step S1002.

[5. Hardware configuration)
The advertisement information management device 100, the terminal device 10, the web server 20, the advertisement distribution devices 30-1, 30-2, 30-3, the DB server 40, and the like according to the embodiment described above are configured as shown in FIG. This is realized by the computer 60. Hereinafter, the advertisement information management apparatus 100 will be described as an example. FIG. 6 is a hardware configuration diagram illustrating an example of a computer that realizes the function of the advertisement information management apparatus 100. The computer 60 includes a central processing unit (CPU) 61, a random access memory (RAM) 62, a read only memory (ROM) 63, a hard disk drive (HDD) 64, a communication interface (I / F) 65, an input / output interface (I). / F) 66 and a media interface (I / F) 67.

  The CPU 61 operates based on a program stored in the ROM 63 or the HDD 64 and controls each unit. The ROM 63 stores a boot program executed by the CPU 61 when the computer 60 is activated, a program depending on the hardware of the computer 60, and the like.

  The HDD 64 stores a program executed by the CPU 61, data used by the program, and the like. The communication interface 65 corresponds to the communication unit 110, receives data from other devices via the communication network N, sends the data to the CPU 61, and transmits the data generated by the CPU 61 to other devices via the communication network N. .

  The CPU 61 controls an output device such as a display and a printer and an input device such as a keyboard and a mouse via the input / output interface 66. The CPU 61 acquires data from the input device via the input / output interface 66. Further, the CPU 61 outputs the generated data to the output device via the input / output interface 66.

  The media interface 67 reads a program or data stored in the recording medium 68 and provides it to the CPU 61 via the RAM 62. The CPU 61 loads the program from the recording medium 68 onto the RAM 62 via the media interface 67, and executes the loaded program. The recording medium 68 is, for example, an optical recording medium such as a DVD (Digital Versatile Disc) or PD (Phase change rewritable disk), a magneto-optical recording medium such as an MO (Magneto-Optical disk), a tape medium, a magnetic recording medium, or a semiconductor memory. Etc.

  For example, when the computer 60 functions as the advertisement information management apparatus 100 according to the embodiment, the CPU 61 of the computer 60 realizes the function of the control unit 130 by executing a program loaded on the RAM 62. The HDD 64 stores data in the storage unit 120.

  The CPU 61 of the computer 60 reads these programs from the recording medium 68 and executes them, but as another example, these programs may be acquired from other devices via the communication network N.

[6. Others]
In addition, among the processes described in the above embodiment, all or part of the processes described as being automatically performed can be performed manually, or the processes described as being performed manually can be performed. All or a part can be automatically performed by a known method. In addition, the processing procedures, specific names, and information including various data and parameters shown in the document and drawings can be arbitrarily changed unless otherwise specified. For example, the various types of information illustrated in each drawing is not limited to the illustrated information.

  Further, each component of each illustrated apparatus is functionally conceptual, and does not necessarily need to be physically configured as illustrated. In other words, the specific form of distribution / integration of each device is not limited to that shown in the figure, and all or a part thereof may be functionally or physically distributed or arbitrarily distributed in arbitrary units according to various loads or usage conditions. Can be integrated and configured.

  For example, the execution unit 135 and the restoration unit 136 illustrated in FIG. 3 may be integrated. Further, for example, information stored in the storage unit 120 may be stored in a predetermined storage device provided outside via the communication network N. Conversely, the internal DB group 41 managed by the DB server 40 may be stored in the storage unit 120. That is, the advertisement information management device 100 and the DB server 40 may be integrated.

  Further, in the above-described embodiment, the case where the information to be handled is mainly information related to the advertisement delivery has been described as an example. However, the type of information is not limited, and the information is not limited to the information related to the advertising industry. . The present application is also applicable to a network system having a large number of transaction DBs managed by a large number of business operators such as the financial industry.

  In addition, the above-described embodiments and modifications can be combined as appropriate within a range that does not contradict processing contents.

[7. effect〕
An advertisement information management apparatus 100 (corresponding to an example of “information management apparatus”) of the advertisement information management system 1 (corresponding to an example of “information management system”) according to the embodiment includes a receiving unit 132, a storage unit 134, and an execution Unit 135 and a restoration unit 136. The accepting unit 132 accepts a processing request related to data processing. When the content of the data processing corresponding to the processing request includes access to unmanaged external data, the storage unit 134 receives at least from the third party server 70 (corresponding to an example of “external device”) that manages the external data. Obtain and save external data. The execution unit 135 executes data processing based on the processing request. When the processing result of the data processing by the execution unit 135 is abnormal, the restoration unit 136 returns the external data to the third party server 70 based on the storage data stored by the storage unit 134 before the data processing is executed. Restore it. Thereby, consistency of information with the outside can be maintained.

  In addition, the storage unit 134 acquires external data from the third party server 70 based on the library information 121 associated with the external data and the internal data to be processed for the data processing corresponding to the processing request. And save. Thereby, it is possible to easily grasp the relevance between the data processing and each data and DB to be processed. Further, it is possible to instantaneously determine the case where the content of the data processing corresponding to the processing request includes access to unmanaged external data.

  Further, the restoration unit 136 executes registration processing in which the execution unit 135 newly registers internal data and external data as data processing, and identifies new external data when the processing result of the registration processing is abnormal. If a unique ID (corresponding to an example of “identification information”) has been acquired from the third party server 70, the deletion that causes the third party server 70 to delete the unique ID and external data corresponding to the unique ID Send a request. Thereby, even if the registration process is abnormally terminated, consistency between the internal data and the external data can be maintained.

  In addition, when the execution unit 135 executes update processing for updating internal data and external data as data processing, the storage unit 134 updates the external data to be processed before executing the update processing. Get from and save. In addition, when the processing result of the update process executed by the execution unit 135 is abnormal, the restoration unit 136 determines that the external data has been updated by the third party server 70. The update request for updating the external data with the content of the external data stored by the storage unit 134 is transmitted. As a result, even if the update process ends abnormally, consistency can be maintained between the internal data and the external data.

  In addition, when the execution unit 135 executes a deletion process that deletes internal data and external data as data processing, the storage unit 134 removes the external data to be processed before executing the deletion process. Get from and save. In addition, when the processing result of the deletion process executed by the execution unit 135 is abnormal, the restoration unit 136 determines that the external data has been deleted by the third party server 70. Before a registration request for newly registering external data with the content of the external data stored by the storage unit 134 is executed, and the unique ID of the new external data issued in response to the registration request is deleted. Associate with the internal data. Thereby, even if the deletion process is abnormally terminated, consistency between the internal data and the external data can be maintained.

  In addition, the execution unit 135 deletes the data stored by the storage unit 134 when the processing result of the executed data processing is normal. As a result, system resources such as storage area resources can be used repeatedly without wasting them. Therefore, a highly available system can be provided.

  The embodiment of the present application has been described in detail with reference to the drawings. However, this is an exemplification, and various modifications and improvements are made based on the knowledge of those skilled in the art including the aspects described in the column of the disclosure of the invention. The present invention can be implemented in other forms.

  In addition, the “section (module, unit)” described above can be read as “means” or “circuit”. For example, the acquisition unit can be read as acquisition means or an acquisition circuit.

DESCRIPTION OF SYMBOLS 1 Advertisement information management system 10 Terminal device 20 Web server 30-1, 30-2 Advertisement delivery apparatus 40 DB server 41 Internal DB group 50 API server 70 Third party server 71 External DB group 100 Advertisement information management apparatus 110 Communication part 120 Storage Unit 121 library management information 122 storage information 130 control unit 131 collection unit 132 reception unit 133 determination unit 134 storage unit 135 execution unit 136 restoration unit

Claims (8)

A reception unit for receiving processing requests regarding data processing;
When the content of the data processing corresponding to the processing request includes access to external data that is not managed, at least a storage unit that acquires and stores the external data from an external device that manages the external data;
An execution unit that executes the data processing based on the processing request;
A restoration unit that causes the external device to restore the external data to a state before the execution of the data processing based on the saved data saved by the saving unit when the processing result of the data processing by the execution unit is abnormal An information management device comprising: The storage unit is
For the data processing corresponding to the processing request, acquiring and storing the external data from the external device based on library information associated with the external data and internal data to be processed by the data processing. The information management apparatus according to claim 1, wherein The restoration unit
When the execution unit executes a registration process for newly registering the internal data and the external data as the data process, and the process result of the registration process is abnormal, identification information for identifying the new external data is provided. 3. The information according to claim 2, wherein if it has been acquired from the external device, a deletion request for deleting the identification information and the external data corresponding to the identification information is transmitted to the external device. Management device. The storage unit is
When the execution unit executes an update process for updating the internal data and the external data as the data process, the external data to be processed is acquired from the external device before the update process is executed. Save and
The restoration unit
If the external data has been updated by the external device when the processing result of the update processing executed by the execution unit is abnormal, the external device stored by the storage unit is stored in the external device. The information management apparatus according to claim 2, wherein an update request for updating the external data with data contents is transmitted. The storage unit is
When the execution unit executes a deletion process for deleting the internal data and the external data as the data process, the external data to be processed is acquired from the external device before the deletion process is executed. Save and
The restoration unit
If the external data has been deleted by the external device when the processing result of the deletion processing executed by the execution unit is abnormal, the external data stored by the storage unit is stored in the external device. A registration request for newly registering the external data with the content of the data is transmitted, and the identification information of the new external data issued in response to the registration request is associated with the internal data before the deletion process is executed. The information management apparatus according to claim 2, 3, or 4. The execution unit is
The information management apparatus according to any one of claims 1 to 5, wherein when the processing result of the executed data processing is normal, the storage data by the storage unit is deleted. A reception process for receiving a processing request related to data processing;
When the content of the data processing corresponding to the processing request includes access to external data that is not managed, a storage step of acquiring and storing the external data from at least an external device that manages the external data;
An execution step of executing the data processing based on the processing request;
A restoration step of causing the external device to restore the external data to a state before execution of the data processing based on the saved data saved by the saving step when the processing result of the data processing by the execution step is abnormal An information management method comprising: and. Acceptance procedure for accepting processing requests related to data processing,
When the content of the data processing corresponding to the processing request includes access to external data that is not managed, a storage procedure that acquires and stores the external data from at least an external device that manages the external data;
An execution procedure for executing the data processing based on the processing request;
A restoration procedure for causing the external device to restore the external data to the state before the execution of the data processing based on the saved data saved by the saving procedure when the processing result of the data processing by the execution procedure is abnormal And an information management program for causing a computer to execute.

Images