JP2003196141A - Registration system, registration method and program for content to be disclosed on internet - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enhance the reliability by backing up a content, in the occurrence of alternation of the content in an AP server device provided with Web server function and the content, while minimizing the load to the database of a DB server device to restore the content. <P>SOLUTION: This system comprises a user terminal 11, the AP server device 20 connected to Internet 19 through a firewall 29, and the DB server device connected to the AP server device 20 through the firewall 39. When a content registration request is accepted from the user terminal 11, the content is transferred to the database 31 through the firewall 39 and registered therein, and the registered content is extracted from the database 31 in a time band having the less night load to form a HTML file, which is then transferred to a content file part 24 through the firewall 39 and registered therein, whereby the content to be disclosed on Internet 19 is registered. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a registration system, a registration method, and a program for contents published on the Internet, and more particularly to a device for mounting a database for holding a backup of contents files as a web server and contents files for the Internet. The present invention relates to a registration system, a registration method, and a program of a configuration arranged behind a device that implements.

[0002]

2. Description of the Related Art The technique of registering data in a database on a server or registering a content file using WWW (World Wide Web) and Internet technology has hitherto been known as a client device equipped with a web browser and a web server function. Application server (abbreviated as AP server)
An AP server device equipped with a function for registering content files and transferring registration data in a database (abbreviated as DB) to a DB server device, and a D holding the database
It is composed of a B server device and the Internet connecting the client device and the AP server device, and the user uses the web browser on the client device to register the data in the database or create the created content file in the A
It can be transmitted to the P server device and registered.
The content data is data such as HTML (Hyper Text Markup Language) including image information and audio information in addition to character information.

In data registration, if data is registered using a web browser, it is not necessary to distribute a dedicated program for data registration to each client, and when changing the data registration system, the server side The advantage is that you only have to modify the program.

On the other hand, data registration using a web browser is susceptible to unauthorized intrusion from the outside, and in particular, in order to protect the content data registered in the AP server device, the content data is stored in the database of the DB server device. There are measures such as backing up and installing a firewall to protect it from unauthorized access.

FIG. 3 is a diagram showing an example of a file registration system configuration using a conventional web browser. A conventional system will be described with reference to FIG. Although many user terminals are connected to the Internet 19 as clients, in FIG. 3, the user terminal 11 and the user terminal 1 are connected.
2 is shown, and a case where data is registered from the user terminal 11 and is referred to from the user terminal 12 will be described.

[0006] The AP server device 40 is connected to the Internet 19 via a firewall 49, and is further connected to the DB server device 50 via a firewall 59. The AP server device 40 includes a CGI unit 42, a DB access unit 43, a file registration unit 44, and a content file unit 45.

The web server unit 41 is the Internet 1
The CGI unit 42 has a function of receiving and processing a request from the device 9 and returning a required result.
ACE) function to process requests from the Internet 19 such as registration and access of content data. The file registration unit 44 controls registration and reading of the content file, and the content file unit 45 stores the registered content file. DB access unit 43
Sends the attribute information such as the storage location of the registered content data, the file name, the user name, etc. to the DB server device 50 and reads it out as necessary.

The DB server device 50 includes a database 51 that holds attribute information of content data, and a DB control unit 52 that controls registration and reading of the database 51 and a request from the DB access unit 43. The attribute information registered in the database 51 is referred to as information for recovering the content file unit 45 of the AP server device 40 in the event of damage or failure.

Next, two procedures for data registration will be described. One is a procedure for registering data in the database 51, and the other is a procedure for registering data in the content file section 45. First, in the procedure of data registration in the database 51, the user inputs data using a web browser on the user terminal 11. Input is performed on a web browser using a form created in HTML, for example.

The input data is stored on the Internet 19
And HTTP (Hyper Text
Transfer Protocol) Web server unit 4
Passed to 1. The firewall 49 operates to prohibit access other than HTTP in order to protect the AP server device 40 from unauthorized access.

The input data received by the web server unit 41 is passed to the CGI unit 42, and further the DB access unit 4
3 and the firewall 59 to the DB control unit 52. Here, the firewall 59 operates so as to pass only the transfer protocol determined between the DB access unit 43 and the DB control unit 52. The DB control unit 52 registers the received input data in the database 51. Data registration from the user to the database 51 is executed as described above.

Next, the procedure for registering content data will be described. When a user wants to publish a content file created by him / herself on the Internet 19 to general users, the user places the content file on the AP server device 40 and has a web server unit 41 having a publishing function on the Web, that is, on the Internet 19. Content files need to be placed so that they can be accessed from.

Therefore, the user uses the content file created by using the user terminal 11 or the like via the Internet 19 and the firewall 49 to access the AP server device 4.
0 to the web server unit 41. Web server unit 41
Sends the received content file to the file registration unit 44 via the CGI unit 42, and registers the content file received by the file registration unit 44 in the content file unit 45.

When the content file registered in this way is accessed from the user terminal 12, the CG is instructed by the web server unit 41 which has received the access.
The file registration unit 44 executes the reading via the I unit 42, and is sent from the web server unit 41 to the requesting user terminal 12. The web browser of the user terminal 12 displays the received content file on the user terminal 12 and the user can browse the content file.

[0015]

The conventional data registration technique described above has the following problems. The application server device has a problem in that there is an unspecified access from the outside and there is a risk of tampering with the content by an unauthorized intruder.

In order to prevent data tampering, the DB server device protected inside the firewall must be
It is desirable to keep the data centrally. Therefore, it is desirable to hold the content data also in the DB server device, but on the other hand, the content data needs to be arranged in a storage area that can be internally accessed by the web server unit.

An object of the present invention is to back up contents in a database of a DB server device and to improve reliability in order to recover the contents when the contents are tampered with in an AP server device which implements a web server function and contents. It is to provide a content registration system, a registration method, and a program for improving the content.

[0018]

A first content registration system of the present invention is an Internet including an AP server device connected to a user terminal via the Internet and a DB server device connected to the AP server device. A registration system for content to be published on the above, wherein the AP server device has a content file section that holds content files to be published on the Internet, and a Web that connects to the Internet and receives and processes requests from user terminals. The DB server device includes a server unit and an AP server unit that transfers the content to the DB server device in response to a content registration request from the web server unit and reads out and returns the content file from the content file unit in response to the content reference request. Is the above A
It has a database that holds the contents transferred from the P server unit, and a file extraction unit that transfers the contents file created by extracting the contents registered in the database to the contents file unit.

The second content registration system of the present invention is such that the Internet connecting to the user terminal and the connection A through the firewall A permitting only specific communication.
A registration system for content to be published on the Internet, which includes a P server device and a DB server device connected to the AP server device through a firewall B that permits only specific communication, the AP server device being the Internet. A content file section that holds the content file to be published above, a web server section that receives and processes a request from a user terminal via the firewall A and the Internet, and a content DB by a content registration request from the web server section. The AP server unit that instructs the transfer to the server device and reads out and returns the content file from the content file unit in response to the content reference request, and the content permitted to the firewall B when the content registration request is received from the AP server unit. And a DB connection unit for transferring content by the DB server device, and the DB server device stores a database for holding the content transferred from the DB connection unit and a content file created by extracting the content registered in the database. And a file extraction unit for transferring to the content file unit by communication permitted by the firewall B.

According to a third content registration system of the present invention, in the first or second content registration system, the file extraction unit starts extraction of the content at a predetermined time zone. Characterize.

In a fourth content registration system of the present invention, in the first or second content registration system, the AP server unit specifies a registration position in the content file unit for the content of the registration request. Control information including information is added, and the DB server device has a DB control unit that registers the content and control information transferred from the DB connection unit as a record in a database, and the file extraction unit extracts the content together with the content. It is characterized in that the registration position of the content file section is determined based on the control information.

A fifth content registration system according to the present invention is characterized in that, in the second content registration system, the firewall A permits only communication according to an HTTP protocol.

A sixth content registration system of the present invention is the second content registration system, wherein the firewall B uses a communication protocol used when transferring the content from the DB connection unit to the database, and Only the file transfer protocol used when transferring the content file from the file extracting unit to the content file unit is permitted.

The first content registration method of the present invention is as follows:
A method of registering a content to be published on the Internet, including an AP server device connected to a user terminal via the Internet and a DB server device connected to the AP server device, wherein a content registration request is issued from the user terminal. When accepted by the AP server device, the accepted content is transferred to and registered in a database provided in the DB server device, the content registered in the database is extracted to create a content file, and the internet provided in the AP server device is registered. It is characterized in that the content file to be disclosed above is transferred to and registered in the content file section that holds the content file.

The second content registration method of the present invention is as follows:
An AP server device connected to the Internet connected to a user terminal via a firewall A allowing only specific communication, and a DB server device connected to the AP server device via a firewall B allowing only specific communication. A method of registering content to be published on the Internet including, when a request for registering content from a user terminal is accepted by an AP server device by a communication protocol permitted by firewall A, the accepted content is permitted by firewall B. It is transferred to a database provided in the DB server device by a communication protocol and registered, the content registered in the database is extracted to create a content file, and the firewall B is used.
It is characterized in that it is transferred to and registered in the content file section that holds the content file to be published on the Internet provided in the AP server device by the communication protocol permitted in.

The third content registration method of the present invention is as follows:
In the first or second content registration method, extraction of the content from the database is started at a predetermined time zone.

The fourth content registration method of the present invention is as follows:
In the first or second content registration method, control information including information designating a registration position in the content file section is added to the received content, transferred to a database and registered, and the content is transferred from the database together with the content. It is characterized in that the registration position of the content file section is determined based on the extracted control information.

A first program of the present invention is a procedure for accepting a content registration request from a user terminal via the Internet in an AP server device having a function of publishing the content file registered in the content file section on the Internet, A procedure for transferring the received content to a database provided in the database server device and registering it, and a procedure for extracting the content registered in the database to create a content file, transferring it to the content file section and registering it, are stored in the computer. Let it run.

A second program of the present invention is an AP server device having a function of publishing a content file registered in a content file section on the Internet, and a firewall A for permitting specific communication with the Internet.
A procedure for accepting a content registration request from a user terminal via the, and transfer of the accepted content to a database provided in the database server device by a communication protocol that allows communication through a firewall that allows specific communication for registration. The computer is made to execute the procedure for performing the above procedure and the procedure for extracting the content registered in the database to create a content file, transferring the content file to the content file section using a communication protocol capable of communicating with the firewall, and registering the content file section.

[0030]

BEST MODE FOR CARRYING OUT THE INVENTION Next, embodiments of the present invention will be described in detail with reference to the drawings. FIG. 1 is a diagram showing a configuration of an embodiment of the present invention. In the configuration of FIG. 1, the user terminal 11 and the user terminal 12 are connected to the Internet 19, and the AP server device 20 is connected via the firewall 29. The DB server device 30 connects to the AP server device 20 via the firewall 39. The connections in FIG. 1 indicate logical connections, not physical communication paths or signal lines.

The user terminals 11 and 12 are terminal devices used by general users, and are, for example, personal computers or mobile terminals, and are equipped with a browser function for accessing a site on the Internet 19 to retrieve and display a document. . Although only two are shown in FIG. 1, many user terminals are connected.

The AP server device 20 is connected to the Internet 19 via the firewall 29, and is further connected to the DB server device 30 via the firewall 39. The AP server device 20 includes a web server unit 21 and A
The P server unit 22, the DB connection unit 23, and the content file unit 24 are included.

The firewall 29 operates so as to allow only HTTP protocol communication and prohibit other communication, and blocks unauthorized access to prevent access from the AP server device 2.
Protect 0. Although the HTTP protocol may be described here as an example, the present invention is not limited to the HTTP protocol.

The web server unit 21 is the Internet 1
It is a program for receiving an access request to the database 31 from 9 and an access request for a content file and returning a required result. AP server unit 22
Is a program that includes the functions of the CGI unit 42 of FIG. 3 and operates according to an instruction from the web server unit 21, and accesses the database 31 and the content file unit 24.
Handle access to.

The content file section 24 stores content files. The DB connection unit 23 is the AP server unit 2
In accordance with the instruction of No. 2, the normal access information to the database 31, the storage location of the content data registered in the database 31, the file name, the attribute information such as the user name are stored in the DB.
It is a program that transmits to the control unit 32 via the firewall 39 and receives data read from the database 31 via the firewall 39.

The DB server device 30 stores a database 31 that holds data including content data, a DB control unit 32 that controls registration and reading of the database 31 and a request from the DB connection unit 23, and a file extraction unit 3.
Including 3. The file extraction unit 33 extracts the content data from the database 31 and converts it into a content file as an HTML document, and registers the converted content file in the content file unit 24 of the AP server device 20 via the firewall 39.

The firewall 39 has a function of permitting communication according to a predetermined database communication protocol and file transfer protocol and prohibiting other communication. The DB connection unit 23 and the DB control unit 32 communicate with each other by the database communication protocol described above, and the file extraction unit 33 and the content file unit 24 communicate with each other by the file transfer protocol described above.

Next, the operation of the embodiment of the present invention will be described. In the present invention, there are normal access and content data registration access to the database 31. First,
A procedure for accessing the normal database 31 will be described. Access to the database 31 is performed in the same manner as in the conventional case, but the following description will be made assuming that the user terminal 11 makes a registration request and the user terminal 12 makes a read request.

First, a normal registration procedure will be described.
The user inputs data using a web browser on the user terminal 11. Input is performed on a web browser using a form created in HTML, for example. A request to register the input data in the database 31 is sent via the Internet 19 and the firewall 29 to the HT.
It is sent to the web server unit 21 of the AP server device 20 by the TP protocol.

The web server unit 21 receives the input data and instructs the AP server unit 22 to register the received input data in the database 31. The AP server unit 22 sends the received input data to the DB control unit 32 via the DB connection unit 23 and the firewall 39, and the DB control unit 32 receives the input data and registers it in the database 31.

Next, the procedure for reading the normal database 31 will be described. The user uses the web browser on the user terminal 12 to input a search condition and sends a read request using the HTTP protocol. The read request is sent via the firewall 29 to the web server unit 2
1, and the web server unit 21 instructs the AP server unit 22 to process the read request of the database 31. A
The P server unit 22 sends a read request to the DB control unit 32 via the DB connection unit 23 and the firewall 39.

The DB control unit 32 returns the data retrieved by searching the database 31 to the AP server unit 22 via the firewall 39 and the DB connection unit 23. The AP server unit 22 returns the read data to the web server unit 21,
The web server unit 21 sends the read data to the user terminal 12 via the firewall 29 and the Internet 19.
Send to. The browser of the user terminal 12 displays the read data on the display means of the user terminal 12, and the user can obtain the data of the database 31.

Next, the operation of registering the content data, which is a document created in HTML, in the AP server device 20 will be described with reference to the flowchart of FIG. First, the user uses the user terminal 11 or another computer to search for the content that he wants to publish on the Internet 19.
The file is created as a TML format file, and the content is transmitted from the user terminal 11 to the AP server device 20 by the HTTP protocol to request registration.

The web server unit 21 receives the content data through the firewall 29 (S71), and A
It is passed to the P server unit 22. The AP server unit 22 adds control information to the received content data, and the DB connection unit 23
To the DB control unit 32 via the firewall 39 according to a predetermined DB communication protocol (S72).
The control information added to the content data includes information for designating the registration position of the content file section 24, such as content classification code, and keyword information necessary for searching the database 31.

The DB control unit 32 receives the content data and the control information transmitted by the DB communication protocol via the firewall 39, and registers the content data and the control information in the database 31 according to the keyword information in the control information. . Content data is HTM
It is registered in the database 31 not as an L format file but as a record (S73).

Next, at a predetermined time scheduled in advance, the file extraction unit 33 extracts the unextracted content data registered in the database 31 and the control information record to create an HTML format file (S7).
5). The file extraction unit 33 transmits the created HTML-formatted content file to the content file unit 24 via the firewall 39 by a predetermined file transfer protocol (S76). At this time, the information of the transfer destination is extracted from the control information added to the content data. The AP server device 20 registers the content file transmitted by the predetermined file transfer protocol in the designated one in the content file section 24 (S77).

In this way, the content requested to be registered by the user terminal 11 is registered in the database 31 and the content file section 24. In the above example, it is described that the transfer of the content from the database 31 to the content file unit 24 is started at a predetermined time, but at that time, the load on the DB server device 30 and the AP server device 20 is reduced, for example. It is set in the time zone such as night.

Therefore, the load on the AP server device 20 and the DB server device 30 can be distributed, but the content is published on the Internet 19 after registration in the content file section 24. Then, it will be released from the day after the registration request. In order to open it on the same day, step S74 may be skipped and step S75 may be started. Alternatively,
The AP server unit 22 stores the content in the DB server device 30.
If the content is transferred to the content file section 24 and registered in the content file section 24, the content can be immediately published, but the load cannot be distributed.

The reading of the contents is the same as the conventional one. When the web server unit 21 receives the access request from the user terminal 12, the web server unit 21 instructs the AP server unit 22 to read the contents. , AP
The server unit 22 reads out the specified content file from the content file unit 24, and reads the content file from the web server unit 21.
Then, the web server unit 21 transmits the requested content file to the user terminal 12 via the firewall 29 and the Internet 19 using the HTTP protocol.

As described above, access to the AP server device 20 from the Internet 19 is controlled by the firewall 2
The content registered in the AP server device 20 is backed up in the database 31 in the highly secure DB server device 30, which is restricted by 9 and access is restricted by a predetermined DB communication protocol and file transfer protocol. Therefore, even if the registered content is tampered with on the AP server device 20, it is possible to recover with high reliability, and a highly reliable system can be realized.

In the configuration of FIG. 1, the web server unit 2
Although 1 and the AP server unit 22 are mounted on the same AP server device 20, the load may be distributed by dividing the Web server unit 21 into dedicated devices and mounting them. Further, the AP server devices 20 may be dispersed and arranged in multiple layers to improve the response. Furthermore, since the master content data is held in the database 31, synchronous distribution of the content is easy and reliability can be ensured even with a configuration in which the AP server device 20 is multiplexed.

[0052]

[Effects of the Invention] Even if a content file on the AP server device is tampered with by unauthorized access, the content can be restored, and the reliability of restoration is extremely high. The reason is that the backed up content data is held in the database of the DB server device with higher safety.

Further, there is an effect that the load generated for backup can be distributed. The reason is,
This is because the process of transferring the content from the database of the DB server device to the content file unit of the AP server device can be executed during a time zone when the load is low.

[Brief description of drawings]

FIG. 1 is a configuration diagram showing a system according to an embodiment of the present invention.

FIG. 2 is a flowchart showing the operation of the embodiment of the present invention.

FIG. 3 is a configuration diagram showing a system of a conventional embodiment.

[Explanation of symbols]

11 user terminals 12 User terminal 19 Internet 20 AP server device 21 Web server section 22 AP server section 23 DB connection 24 Content File Section 29 Firewall 30 DB server device 31 Database 32 DB control unit 33 File Extractor 39 Firewall 40 AP server device 41 Web server section 42 CGI Department 43 DB access department 44 File registration section 45 Content file section 49 firewall 50 DB server device 51 Database 52 DB controller 59 Firewall

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Keita Goto             5-7 Shiba 5-1, Minato-ku, Tokyo NEC Corporation             Inside the company F-term (reference) 5B017 AA08 CA16                 5B082 DE06 GA11 HA08                 5B089 GA21 KA17 ME09

Claims (12)

[Claims] 1. A registration system for contents to be published on the Internet, which includes an AP server device connected to a user terminal via the Internet and a DB server device connected to the AP server device. Is a content file section that holds content files to be published on the Internet, a web server section that connects to the Internet and accepts and processes requests from user terminals, and a content DB that stores content requests from the web server section. An AP server unit that transfers the content file to the server device and reads out and returns the content file from the content file unit in response to a content reference request, and the DB server device includes a database that holds the content transferred from the AP server unit. In the database A content registration system having a file extraction unit that transfers a content file created by extracting registered content to the content file unit. 2. An AP server device connected to the Internet for connecting to a user terminal via a firewall A permitting only specific communication, and a connection to the AP server device via a firewall B permitting only specific communication. A system for registering content to be published on the Internet, including a DB server device, wherein the AP server device uses a content file unit for holding a content file to be published on the Internet, the firewall A, and the Internet. Web server unit that receives and processes requests from the user terminal, and content DB by content registration request from the Web server unit
An AP server unit for instructing transfer to a server device and for reading out and returning a content file from the content file unit in response to a content reference request;
A DB connection unit that transfers content by communication permitted by the firewall B when a content registration request is received from the server unit;
The firewall holding the database holding the contents transferred from the connection part and the contents file created by extracting the contents registered in the database.
A content registration system having a file extraction unit for transferring to the content file unit by communication permitted by the above. 3. The content registration system according to claim 1, wherein the file extraction unit starts extraction of the content at a predetermined time zone. 4. The AP server unit adds control information including information designating a registration position in the content file unit to the content of the registration request, and the DB server device is transferred from the DB connection unit. 2. A DB control unit for registering content and control information as a record in a database, wherein the file extraction unit determines the registration position of the content file unit based on the control information extracted together with the content. 2 Content registration system. 5. The content registration system according to claim 2, wherein the firewall A permits only communication by the HTTP protocol. 6. The firewall B uses a communication protocol used when transferring contents from the DB connection unit to the database and a file transfer used when transferring content files from the file extracting unit to the content file unit. The content registration system according to claim 2, wherein only the protocol is permitted. 7. A method of registering content to be published on the Internet, which includes an AP server device connected to a user terminal via the Internet and a DB server device connected to the AP server device, the method comprising: When the AP server device receives a content registration request, the received content is transferred to a database provided in the DB server device and registered, and the content registered in the database is extracted to create a content file. A method of registering content, comprising transferring the content file to be published on the Internet to a content file section that holds the file and registering the content file section. 8. An AP server device connected to the Internet for connecting to a user terminal via a firewall A permitting only specific communication, and a connection to the AP server device via a firewall B permitting only specific communication. A method of registering content to be published on the Internet including a DB server device, wherein when a request for registering content from a user terminal is accepted by an AP server device by a communication protocol permitted by firewall A, the accepted content is firewalled. Transferred to the database provided in the DB server device by the communication protocol permitted by B and registered, the content registered in the database is extracted to create a content file, and the AP server device is transmitted by the communication protocol allowed by firewall B. Set inside Registration method of the content and registers was transferred to the content file unit that holds the content files to publish on the Internet. 9. The content registration method according to claim 7, wherein extraction of the content from the database is started at a predetermined time zone. 10. The received content is added with control information including information designating a registration position in the content file section, transferred to a database and registered, and the content is based on the control information extracted together with the content from the database. 9. The content registration method according to claim 7, wherein the registration position of the file portion is determined. 11. A procedure for accepting a content registration request from a user terminal via the Internet in an AP server apparatus having a function of publishing a content file registered in a content file section on the Internet, and a received content server in a database server apparatus. A program that causes a computer to execute a procedure of transferring and registering to a database provided in, and a procedure of extracting a content registered in the database to create a content file and transferring to a content file section and registering. 12. An AP server device having a function of publishing a content file registered in a content file section on the Internet, and accepting a content registration request from a user terminal via a firewall A that permits specific communication with the Internet. Procedures and procedures for transferring the received contents to a database provided in the database server device by a communication protocol that allows communication through a firewall that allows specific communication, and for registering the contents registered in the database. A program that causes a computer to execute a procedure of creating a content file, transferring the content file to the content file section using a communication protocol capable of communicating with the firewall, and registering the content file.