JP2009301442A - Information sharing system, method, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an information sharing system using a simple database, and also provide a method therefor. <P>SOLUTION: The information sharing system is composed of three servers, that is, a Web server, a supporting server and a database sever. The Web server has a mail hosting function which transmits an exclusive Web page to a client terminal, writes information input from the exclusive Web page in an electronic mail, and automatically transmits the electronic mail to a fixed electronic mail address, and holds information for browsing which is generated by the database server. The supporting server receives the electronic mail and converts a data format of information extracted from the electronic mail text in order to update the information stored in the storage part of the database server. The database server updates the information stored in the storage part with the converted information and generates the information for browsing on the basis of the information in the storage part. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to an information sharing system using a network.

  Conventionally, since information is often transmitted by exchanging documents, in order to share information, a method has been adopted in which documents are gathered manually and made known to the whole. This method has a problem that much labor and time are required and information cannot be shared in real time.

  Therefore, as a means for solving the above problems, there is a method of digitizing information and creating a database. Specifically, it is generally performed that electronic information is held in a database so that a client terminal can connect to a database connected to a server through a network line.

  However, a database that requires a database management system that is normally used when the information is limited or the data does not have a complicated configuration is unnecessary. Further, in a normally used relational database, data is acquired using SQL (Structured Query Language), and therefore an SQL statement must be created.

  In view of the above problems, an object of the present invention is to provide an information sharing system and method using a simple database that does not have a database management system and does not require SQL.

  One aspect of the present invention provides an information sharing system using a network to which a plurality of client terminals are connected. The information sharing system includes three servers: a Web server, a support server, and a database server having a storage unit (hereinafter, a database is referred to as a DB for simplification). The Web server is a server that accumulates information such as HTML documents and images and transmits the information through a network such as the Internet in response to a request from client software such as a Web browser.

  In the above, the Web server transmits a dedicated Web page (hereinafter referred to as a page for simplification) to the client terminal via the network, and the information input from the page is in a predetermined format in the body of the e-mail. The server has a mail hosting function for automatically transmitting the e-mail to a fixed e-mail address, and holds browsing information created by the database server. The support server is a server that receives the electronic mail and converts the data format of the information extracted from the text of the electronic mail in order to update the information held in the storage unit of the DB server. The DB server is a server that updates the information held in the storage unit with the converted information and creates the browsing information based on the information held in the storage unit.

  Here, the “mail hosting function” is to send a mail to a fixed mail address when making an inquiry on the page.

  Further, as another aspect, the present invention can be provided as an information sharing method using a computer or a computer program executed on the computer.

  According to the present invention, by using the mail hosting function, a DB capable of registering, updating, and deleting information without using SQL can be realized. Anyone can easily share information via the network using this simple DB. Since browsing files are created immediately from the input information, real-time information sharing can be performed.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a diagram showing a configuration of an embodiment of an information sharing system 1 to which the present invention is applied. Terminals 200-1, 200-2... 200-n (hereinafter simply referred to as client terminals when it is not necessary to distinguish between terminals 200-1 to 200-n) are client terminals on the user side, It is connected to a network 300 typified by the Internet or an intranet, and can perform transmission / reception with the Web server 100, the support server 110, and the DB server 120. A user can perform operations on the client terminal and perform processing on the Web server 100, the support server 110, the DB server 120, and the like via the network 300. However, the client terminal is connected to the support server 110 and the DB server 120 via the Web server 100. In addition, each server in this structure is not necessarily one unit, and may be composed of a plurality of units.

  FIG. 2 is a diagram showing a basic system configuration of the client terminal and server of the information sharing system 1. The Web server 100 includes a mail transmission unit 101, a page reception unit 102, a page transmission unit 103, an authentication unit 104, and a page DB 105. The support server 110 includes a mail receiving unit 111, a mail analyzing unit 112, and a data transmitting unit 113. Furthermore, the DB server 120 includes a DB update unit 121, a page creation unit 122, and an acceptance support DB 123. The acceptance support DB 123 is an example of a storage unit. The storage unit is not limited to a hard disk, but may be an external storage device such as a memory, a magnetic tape, or a flexible disk.

  The mail transmission unit 101 describes the information input on the page in the mail text and transmits it to a predetermined fixed mail address. The page receiving unit 102 receives a page created by the DB server 120 from the DB server 120 and stores it in the page DB 105. When a page display request is received from the client terminal, the page stored in the page DB 105 is provided to the user of the client terminal via the page transmission unit 103. When performing access control with a page ID and password, the authentication unit 104 checks whether the password for the ID is correct. The mail receiving unit 111 receives the mail transmitted by the mail transmitting unit 101. The received mail is converted into a format in which the information in the acceptance support DB 123 can be updated by the mail analysis unit 112, for example, CSV format in which data is separated by commas “,” and the information is converted from the data transmission unit 113 to the DB server 120. Sent to. The DB update unit 121 updates the acceptance support DB 123 with the information created by the support server 110. When the acceptance support DB 123 is updated, the page creation unit 122 creates a page for the updated information and transmits it to the Web server 100.

  The acceptance support DB 123 stores information in a table format for each page. A table has rows, columns, and fields for entering information. As an example of the table, there is Microsoft Excel (registered trademark, hereinafter referred to as Excel for simplification) of Microsoft Corporation. “Registration, update, deletion” of table information is realized by always overwriting information. Details will be described later.

  FIG. 3 is a diagram illustrating a processing flow of the information sharing system. Hereinafter, the processing flow of FIG. 3 will be described with reference to the screen examples of FIGS. 4 and 5. When information is input to the page sent from the Web server 100 to the client terminal and the send button is pressed, the process starts. FIG. 4 is a diagram illustrating a display example of a page for inputting information. On the page, the data currently registered in the table corresponding to the page is displayed in the acceptance support DB 123. To change the information on the page, press the send button after changing the information. Press the clear button to delete all the information displayed on the page.

  Information “registration, update, and deletion” will be described with reference to FIG. In the display example of this page, when adding new information, a registrant's name, a registrant's e-mail address, a company name, a title, a name, and the like are entered in predetermined columns. When updating, the content of the information displayed on the page is corrected. When deleting, delete the information to be deleted from the page or overwrite it with other information. The information input field on the page has position information. For example, the top of the company name is 1-1, the top of the title is 2-1, and the second of the title is 2-2. This position information matches the position information in the table of the acceptance support DB 123 corresponding to this page. After the send button is pressed, the mail sending unit 101 describes the information displayed on the page and the position information of the column in which the information is input in a predetermined format specified by the mail hosting function in the mail body, and fixed. To the e-mail address (step S1 in FIG. 3). The predetermined format will be described later. The email address may be set in the page or in the email transmission unit 101. The registrant mail address is notified that the information entered in the fixed address has been transmitted.

  FIG. 5 is a diagram illustrating an example of an email created by the email transmission unit 101. Here, the case where the information displayed on the page shown in FIG. 4 is transmitted will be described. As the destination, a fixed address set in the page or the mail transmission unit 101 is input. Be sure to identify the page to send information from the subject of the email and the sender of the email. Information input on the page is converted into a predetermined format. The predetermined format depends on the mail transmission program of the mail hosting function to be used. For example, there is a method of arranging information corresponding to items as shown in FIG. When describing in the mail, the company name is converted to an alphabetic name such as “COMPANY” and the title is “OFFICIALITLE”. As shown in “COMPANY = 1-1, XX company”, “OFFICIALITLE = 1-2, charge”, the alphabetic name of the item at the top of the page is connected to the input information and its position information by equals 1 Write line by line. As another example, there is a method of connecting all the lines from the company name to E-mail. In this case, “(1) = 1−1, ○ × company, 1-2, charge,..., 1-n, abc@xxxx.co.jp” is described in each line.

  The mail received by the support server 110 is transferred from the mail receiving unit 111 to the mail analyzing unit 112, and information is edited (step S2 in FIG. 3). Editing information means changing the information described in the mail text to a predetermined format in order to update the acceptance support DB 123. The predetermined format includes a CSV (Comma Separated Values) format and the like. The CSV format is text data and a text file in which several fields (items) are separated by a comma “,”. The CSV format may be extended to include not only “,” but also characters not used for input information such as “%” and “:”, text data and text files separated by white space.

  The following description will be made assuming that the information is converted into a CSV file by the mail analysis unit 112. The mail analysis unit 112 has a storage area for storing a CSV file for each page. The created CSV file determines a page in which information is input based on a mail title and a transmission source address, and stores the page in a corresponding storage area. The stored CSV file is transferred to the DB update unit 121 via the data transmission unit 113 (step S3 in FIG. 3). Although it is desirable that the timing when the CSV file is stored in the storage area of the mail analysis unit 112 as the timing to be passed to the DB update unit 121 via the data transmission unit 113, a predetermined number of CSV files are generated even at predetermined intervals. It may be stored. The predetermined time and the predetermined number are set by a system administrator or the like.

  The table of the reception support DB 123 corresponding to the storage area in which the CSV is stored, that is, the page in which the information is input is updated in the CSV file passed in step S3. For the information “registered, updated, deleted”, the information in the table is overwritten based on the position information (step S4 in FIG. 3). However, the information on the same position information in the CSV file and the table is compared, and only the information on the position with different contents is overwritten. After updating the table, the CSV file is deleted. A page is created from the table changed in step S4 (step S5 in FIG. 3). An existing method is used as a method for creating a page. If the table is created in Excel (registered trademark), it can be created by saving the table in the “.html” or “.html” format. Alternatively, the HTML file stored in the page DB 105 of the Web server 100 may be acquired, and the information updated in step S4 may be reflected in the acquired HTML file.

  The created page is sent to the Web server 100 (step S6 in FIG. 3) and stored in the page DB 105 (step S7 in FIG. 3). At this time, if a page with the same name exists, it is overwritten with a new page. FTP (File Transfer Protocol) is transferred to the Web server 100. FIG. 6 shows a diagram in which the pages stored in the page DB 105 are displayed on the client terminal. Information input on the page shown in FIG. 4 is displayed on the page.

  In this way, by sharing a site composed of a plurality of pages on the network, information can be easily shared between the parties concerned. However, there is a problem that information can be seen by anyone other than those involved in information sharing on the network. Therefore, an ID and a password are set in order to restrict access to pages on the site. If access is restricted to the top page with an ID and password, it is possible to control access to the entire site. Further, by setting an ID and password for each page, access control can be performed for each page. There are various types of access control such as changeable and browsing only.

  Hereinafter, as an embodiment of the present invention, an outline of an LNG reception support system and a tank level monitoring system for managing an LNG tank installed in a power plant or the like will be described with reference to the drawings.

  As one embodiment of the present invention, an LNG acceptance support system will be described. The LNG acceptance support system is a system that supports management of various information associated with acceptance from an LNG carrier to an LNG tank installed in a power plant or the like. The network configuration and system configuration of the LNG acceptance support system is the same as that of the information sharing system, and is an application system in which the information sharing system is applied to LNG tank support work.

  FIG. 7 is a diagram showing a top page of a dedicated Web site (hereinafter referred to as a site for simplification) of the LNG acceptance support system. When you click the contact information, boarding application, acceptance system, pre-acceptance meeting, pre-acceptance meeting (edit), attendees at the pre-acceptance meeting, ship visit application, acceptance process, distribution of related materials, explanation link at the top of this page A page is displayed where the information necessary for accepting can be viewed. For example, when the pre-acceptance conference material (edit) link is pressed, the page shown in FIG. 8 is displayed. FIG. 8 is a diagram showing a pre-acceptance meeting material (edit) page. Here, it is possible to create materials for a conference to be held before accepting LNG. You can enter the meeting time, venue, etc.

  The input information is transmitted to the support server 110 by the mail transmitting unit 101 with each piece of information and position information indicating the position of the column in which each piece of information is entered in the mail text. The transmitted mail is received by the mail receiving unit 111 and edited by the mail analyzing unit 112. The edited information is sent from the data transmission unit 113 to the DB update unit 121 to update the acceptance support DB 123. The table corresponding to the pre-acceptance meeting material (edit) page shown in FIG. 8 is updated, and only the part changed using the position information is changed. A new pre-acceptance conference material page is created from the updated table by the page creation unit 122, and the same page in the page DB 105 is updated via the page transmission unit 103. FIG. 9 is a diagram showing a pre-acceptance meeting material page. When the pre-accept conference link on the top page is pressed, the pre-accept conference page created above is displayed.

  In this way, since the input information is immediately reflected on the page, real-time information sharing can be performed. In addition, work efficiency is improved by automatically creating pages. By constructing a site that gathers all the information necessary for LNG acceptance, it is possible to centrally manage the information and smoothly accept LNG.

  As another embodiment of the present invention, an LNG tank level monitoring system will be described. The LNG tank level monitoring system is a system for facilitating the adjustment between the parties concerned by simulating the transition and performing the reliable LNG tank level management. If the tank level is insufficient, supply shortage is caused. Conversely, if the tank level is excessive, the contracted amount cannot be received in the tank, leading to a loss such as a cancellation fee for the LNG carrier.

  FIG. 10 is a diagram showing the top page of the site of the LNG tank level monitoring system. At the top of this page, press the Data display, base, GAS sales, liquid sales, medium pay (No. 3), medium pay (No. 1), power plant button, and the amount of LNG scheduled to be used at each relevant place. A page that can be viewed is displayed. Data display displays a page of numerical data of the page graph, and fuel displays a page defining constants used for calculation when creating the graph. For example, when the base button is pressed, the page shown in FIG. 11 is displayed. Here, the tank level of the base LNG tank is displayed. When the Data transmission button at the upper right of this screen is pressed, a page as shown in FIG. 12 for inputting the tank level is displayed.

  When the tank level is input on the page shown in FIG. 12, the mail transmission unit 101 describes the tank level input in the mail text and the position information indicating the position of the column in which the tank level is input, and supports it. It is transmitted to the server 110. The transmitted mail is received by the mail receiving unit 111 and edited by the mail analyzing unit 112. The edited information is sent from the data transmission unit 113 to the DB update unit 121 to update the acceptance support DB 123. The table corresponding to the base page shown in FIG. 11 is updated, and only the part changed using the position information is changed. A page of the base is newly created from the updated table by the page creation unit 122, and the same page of the page DB 105 is updated via the page transmission unit 103. When the base button on the top page is pressed again, the new base page created above is displayed.

  As in the above-described reception support system, the input information is immediately reflected on the page, so that real-time information sharing can be performed. In addition, work efficiency is improved by automatically creating pages. In addition, the LNG tank level can be monitored by inputting information to and sharing the information among the related parties using the tank.

    Although the present invention has been described based on the embodiment, the present invention is not limited to the above-described embodiment. The effects described in the embodiments of the present invention are only the most preferable effects resulting from the present invention, and the effects of the present invention are limited to those described in the embodiments or examples of the present invention. Is not to be done.

It is a figure which shows the structure of one Embodiment of the information sharing system to which this invention is applied. It is a figure which shows the basic system structure of the client terminal and server of an information sharing assistance system. It is a figure which shows the processing flow of an information sharing system. It is a figure which shows the example of a display of the page which inputs information. It is a figure which shows the example of an email produced in a mail transmission part. The figure by which the page stored in page DB was displayed on the client terminal is shown. It is a figure which shows the top page of the exclusive Web site of a LNG reception assistance system. It is a figure which shows the page of meeting material before reception (editing). It is a figure which shows the page of the meeting material before reception. It is a figure which shows the top page of the site of a LNG tank level monitoring system. It is a figure which shows the page which displays the tank level of the LNG tank of a base according to a day. It is a figure which shows the page for transmitting the tank level information.

Explanation of symbols

100 Web server 101 Mail transmission unit 102 Page reception unit 103 Page transmission unit 104 Authentication unit 105 Page DB
DESCRIPTION OF SYMBOLS 110 Support server 111 Mail receiving part 112 Mail analysis part 113 Data transmission part 120 DB server 121 DB update part 122 Page creation part 123 Acceptance support DB

Claims (7)

An information sharing system using a network to which a plurality of client terminals are connected,
A database server having a storage unit;
A dedicated Web page is transmitted to the client terminal via the network, information input from the dedicated Web page is described in a predetermined format in the body of the email, and the email is automatically transmitted to a fixed email address. A web server having a mail hosting function and holding browsing information created by the database server;
A support server that receives the electronic mail and converts the data format of the information extracted from the body of the electronic mail in order to update the information held in the storage unit of the database server;
With
The database server updates the information held in the storage unit with the converted information, and creates the browsing information based on the information held in the storage unit Shared system.   The information input to the dedicated Web page and the information stored in the storage unit are managed in a tabular format, so that the information input to the dedicated Web page and the information stored in the storage unit are position information. The system of claim 1.   The information sharing system according to claim 1, wherein the Web server includes an authentication unit that authenticates the dedicated Web page using an access ID and a password. An information sharing method using a network in which a plurality of client terminals are connected,
A client terminal accesses a dedicated Web page on a network resource, describes the information input from the dedicated Web page in a predetermined format in the body of the email, and automatically fixes the email by a mail hosting function. Sending to an email address;
Receiving the email and converting the information extracted from the body of the email into a predetermined format;
Holding the converted information as shared information;
Creating browsing information from the shared information;
Information sharing method.   By managing the information input to the dedicated Web page and the information held in the browsing information in a table format, the information input to the dedicated Web page and the information held in the browsing information are The method of claim 4, comprising location information.   The method according to claim 4, further comprising authenticating the dedicated Web page using an access ID and a password. A computer program for information sharing using a network to which a plurality of client terminals are connected,
A client terminal accesses a dedicated Web page on a network resource, describes the information input from the dedicated Web page in a predetermined format in the body of the email, and automatically fixes the email by a mail hosting function. Sending to an email address;
Receiving the email and converting the information extracted from the body of the email into a predetermined format;
Holding the converted information as shared information;
Creating browsing information from the shared information;
A computer program that causes a computer to execute.

Images