JP2002157162A - Method of reporting database renewal information - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method of reporting database renewal information capable of transmitting simply extracted differential data to a user and displaying it in a visually plain manner by comparing main database information to a differential database copied and preserved in each predetermined period. SOLUTION: An arrangement for implementing the method of reporting database renewal information, as shown in Figure 1, is constructed mainly of an application server 300 accessed from client software 110 on a client 100, and a database server 200 in which data is renewed and retrieved (displayed). The client 100, the data server 200 and the application server 300 are connected to a network 500.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method of notifying database information, and more particularly to a method of notifying database update information that specifies updated database information.

[0002]

2. Description of the Related Art Conventionally, in a system that handles database information and displays the content to a user, information stored in a database having only the latest information of registered data is displayed or notified to a client. I was

[0003] In addition, every time the database is updated, the update history is notified in response to a request from a client by adding the date and time to the update file and storing each updated file. I was

[0004] Japanese Patent No. 2863118 discloses that, when a request for map information display is received from a user by creating updated partial map data with a date and time relating to the map database, the updated partial map data is stored in the map database. A technology for synthesizing the latest map database added to the above and distributing this to users has been disclosed.

[0005]

However, the prior art has the following problems.

When the database is stored for each update process, it is difficult to clearly indicate the updated portion. When the history of the file of the updated portion is stored, the main database and the updated portion are not stored. The association required complicated processing.

Further, in order to notify a plurality of users of the information of the specified updated portion along with the information of the main database, complicated registration and processing are required. Was.

The present invention has been made in view of such a problem, and an object of the present invention is to compare main database information with a difference database copied and stored at predetermined intervals. Another object of the present invention is to provide a method of notifying database update information that can easily transmit difference data extracted to a user and display the difference data visually.

[0009]

The gist of the present invention described in claim 1 is a method of notifying database update information for notifying a user of the contents of a database via a network such as the Internet. A first step of performing, and a second step of transmitting the contents of the database to the user, wherein the first step is generated by copying the main database and the database by a difference detecting unit. A third step of comparing the difference with the difference database and adding an attribute meaning addition / update to the difference based on the comparison result, wherein the second step includes adding information corresponding to the difference to which the attribute is added. A step of displaying information indicating addition / update on the display means of the user by adding a predetermined code. It resides in the notification method of database update information to. The gist of the present invention described in claim 2 is characterized in that the first step includes a step of copying the main database at predetermined time intervals or at a predetermined time and generating the difference database. A method for notifying database update information according to claim 1. The gist of the present invention described in claim 3 is that, in the third step, when a search / display processing request for the database is received from the user, the main database is searched based on a search condition of the search / display processing request. A fourth step of searching to obtain a list of records as a search result, or a step of searching the main database at predetermined times to obtain a list of records.
Determining whether there is an unprocessed record in the searched record list, and if there is an unprocessed record, reads the corresponding record from the difference database; And a fifth step of extracting the difference by performing a comparison process with the database update information. Claim 4
The gist of the invention described is that the third step includes, for each user, adding an attribute indicating the difference to the data of the day from the record list, and the second step includes adding the attribute to the attribute. 4. The database updating method according to claim 1, further comprising a step of transmitting display data such as text data including the data of the day to which the corresponding code is added to the display means of the user. It lies in the method of notification of information. The gist of the present invention described in claim 5 is that the display data such as text data in the method for notifying database update information according to any one of claims 1 to 4 is used for a business daily report, The present invention relates to a business daily report distribution method characterized by distributing the display data in which the day data is specified as the latest information. The gist of the present invention described in claim 6 is to use display data such as text data in the method for notifying database update information according to any one of claims 1 to 4 for a product sales advertisement, for,
There is provided a product advertisement distribution method characterized by adding an attribute indicating the difference to data of the day, and distributing the display data specified as a target product. The gist of the present invention described in claim 7 is that, in the method for notifying database update information according to any one of claims 1 to 4, a predetermined font type, an underline addition, an enclosing frame, and the like are included in addition / update data to an attribute. The data display method is characterized in that the data is applied and displayed on the display means of the user to clearly indicate the added / updated data. The gist of the present invention described in claim 8 resides in a storage medium storing a program capable of executing the database update information notification method according to any one of claims 1 to 4.

[0010]

Embodiments of the present invention will be described below in detail with reference to the drawings.

FIG. 1 is a diagram showing a configuration for executing a method of notifying database update information according to the present embodiment.

As shown in FIG. 1, the configuration for executing the method for notifying database update information according to the present embodiment is composed of client software 110 on client 100.
An application server 300 accessed from
The outline of the database server 200 is used to update and search (display) data. The client 100, the database server 200, and the application server 300 are connected to a network 500.

The database server 200 includes an automatic task execution control unit 210, a database duplication processing unit 220, a master database 230, and a difference database 240.

The application server 300 includes an interface unit (CGI interface unit) 310, a data display screen generation unit 320, a data update unit 330, a data read processing unit 340, a difference detection processing unit (difference detection means) 350, Is provided.

When an update procedure is performed from the client software 110, the interface unit 310 calls the data update unit 330 and accesses the master database 230 on the database server 200. When a search (display) procedure is performed from the client software 110, the data display screen generation unit 320 and the data read processing unit 340 are read.

The data read processing unit 340 accesses the master database 230 and the difference database 240 on the database server 200.

The difference detection processor 350 is called by the data read processor 340 to compare the master database (main database) 230 with the difference database 240 and to mark the difference (meaning addition / update). Attribute).

The data display screen generating section 320 generates a display screen image based on the results of the data read processing section 340 and the difference detection processing section 350, and
0 to the client software 110.

The task automatic execution control section 210 on the database server 200 monitors the database replication processing section 220 and reads the database replication processing section 220 at predetermined time intervals or at preset times.

The database duplication processing unit 220 converts the contents of the master database 230
Copy to 0.

FIG. 2 is a diagram showing a configuration in which the network 500 of FIG.

Referring to FIG. 2, the operation of WWW browser (client software) 110, WWW server (application server) 300, CGI interface unit (interface unit) 310, and the method of visualizing the difference of update information on the WWW system will be described. explain in detail.

WWW browser 1 on client 100
10 accesses the WWW server 300 and updates or searches (displays) data via the CGI interface unit 310.

In the case of the update procedure, the CGI interface unit 310 calls the data update unit 330 and accesses the master database 230 on the database server 200.

In the case of a search (display) procedure, the CGI interface unit 310 reads the data display screen generation unit 320 and the data read processing unit 340.

The data read processing unit 340 accesses the master database 230 and the difference database 240 on the database server 200.

The difference detection processing unit 350 is the master database 23 called by the data read processing unit 340.
The comparison of 0 and the difference database 240 and the marking of the difference are performed.

The data display screen generation section 320 generates an HTML display screen image based on the results of the data read processing section 340 and the difference detection processing section 350,
This is transmitted to the WWW browser 110 on the client 100.

The task automatic execution control section 210 on the database server 200 monitors the database copy processing section 220, and reads out the database copy processing section 220 at predetermined intervals or at preset times.

The database replication processing unit 220 converts the contents of the master database 230 into the difference database 24
Copy to 0.

The WWW browser 110 is used by the WWW server 3
The HTML file is received from 00 and the contents of the file are visually displayed by a display means such as a CRT or a printer.

Since the client 100 and the WWW browser 110 are standard functions well known to those skilled in the art, the description of the configuration is omitted.

The database server 200 is accessed from the client 100 via the WWW server 300.

The master database 230 stores information provided to a user who operates the client 100.

The difference database 240 is a database necessary for the difference detection processing in the present embodiment, and its contents are not directly provided to the user.
Further, the data update content from the user is written only in the master database 230, and the difference database 240 is automatically associated with the master database 230 by the database replication processing unit 220 called from the task automatic execution control unit 210. Is generated.

The WWW server 300 is a client 10
It performs two-way communication with the WWW browser 110 in response to a request from the WWW browser 110 on 0. In the present embodiment, the CGI that the WWW server 300 is equipped with as standard
Called by the interface unit 310.

In the update procedure, the CGI interface unit 310 calls the data update unit 330, re-expresses the data input by the user into a database language that can be interpreted by the database server 200, and passes the data to the database server 200.

The database server 200 interprets a database language and stores data in the master database 230.

In the search (display) procedure, the CGI interface unit 310 reads the data read processing unit 340 through the data display screen generation unit 320.

The data read processing unit 340 generates a database language based on the search condition specified by the user, and transfers it to the database server 200.

The database server 200 interprets the database language, reads out data from the master database 230, and sends the data to the data read-out processing unit 340 in units of records (a group of one or a plurality of attributes). Notice.

The data read processing unit 340 reads the record from the difference database 240 using the ID (unique numerical value for identifying the record) included in the notified record. The exchange with the database server 200 in the procedure for reading the difference database 240 is the same as in the case of the master database 230 described above.

The data read processing unit 340 passes the two records obtained as described above to the difference detection processing unit 350.

The difference detection processing unit 350 compares the differences between the two records, performs marking on the difference data (at this point, only the attribute indicating the difference between the data, and does not include any visual expression). Is returned to the data read processing unit 340.

The data read processing unit 340 passes the processing result to the data display screen generating unit 320, and the data display screen generating unit 320 converts the difference data portion into a format that is easily visually recognized by the user based on the processing result.

The display screen is WWW for performing final display processing.
The output is performed in an HTML format that can be interpreted by the browser 110, and the visualization of the difference data is performed in accordance with a user request or an application characteristic such as enlarging a font size, using a font color such as red, adding an underline, and enclosing in a BOX. It can be changed freely.

The finally generated display image in the HTML format is sent to the WWW browser 1 by the WWW server 300.
Sent to 10. The display means of the WWW browser 110 displays the target information and visualizes the difference data for the user.

The task automatic execution control unit 210 on the database server 200 monitors the database duplication processing unit 220, and executes the database duplication processing at a predetermined period or at a predetermined time by a timer function installed in the OS or the like. The unit 220 is read. The database replication processing unit 220 copies the contents of the master database 230 to the difference database 240.

FIG. 3 is a flowchart showing an example of the operation of the method for notifying database update information according to the present embodiment.

Referring to FIG. 3, the operation of the search procedure in master database 230 of FIG. 2 will be described in detail.

The WWW browser 110 is operated by the user.
From the user (step A10)
1).

The master database 230 is searched based on the search conditions specified by the user, and a list of records of the search results is obtained (master database read processing) (step A102).

Next, the following processing is repeated by the number of IDs included in the record. That is, it is determined whether there is an unprocessed record (step A103).

There is an unprocessed record ((Yes) in the figure)
), A record corresponding to the ID is obtained from the difference database (difference database reading process) (step A104).

It is determined whether there is a record of the ID (step A105).

If there is a record corresponding to the ID ("YES" in the figure), a comparison process is performed with the record of the same ID in the master database 230, and the difference is marked (difference detection and marking) ( Step A10
6). It returns to step A103.

If there is no record with the corresponding ID ("No" in the figure), the record on the master database 230 is a newly registered record, so that the entire record is to be marked (step A107). Step A1
Return to 03.

In step A103, when there is no unprocessed record ((No) in the figure), a screen image to be displayed to the user based on the record acquired from the master database and the marking information of the difference and visualization of the difference data are provided. (Step A108), and the process ends.

FIG. 4 is a diagram showing a configuration of an example of an application example in the method for notifying database update information according to the present embodiment.

The task automatic execution control unit 360 on the application server 300
70, and calls the mail text generation unit 370 at predetermined intervals or at preset times.

The mail text generating section 370 calls the data read processing section 340. Data read processing unit 34
0 accesses the master database (daily report database) 230 and the difference database 240 on the database server 200.

The difference detection processing unit 350 is the master database 2 called by the data read processing unit 340.
30 and the difference database 240 are compared and the difference is marked.

The mail text generating section 370 generates display data such as text data serving as a mail text based on the results of the data read processing section 340 and the difference detection processing section 350. In the display data (daily report), a predetermined code is added to added / updated data such as data of the day corresponding to the difference.

Finally, the display data generated by the mail transmission processing section 380 is transmitted to the specified address via the mail server 400 by mail.

The user can read the generated mail text in the mail reader 120 on the client 100 that is the destination of the mail.

As described above, in a report automatic transmission system, such as a daily report, which automatically transmits the contents of a database to a designated address automatically by e-mail, it can be used for report transmission in which the difference in the mail text is specified.

FIG. 5 is a diagram showing an example of a mail transmitted from the mail server 400 of FIG.

The report B shows the difference between the report contents of the first automatic transmission mail A01 on the date A02 and the second automatic transmission mail B01 on the date B02.
03 and the report B04, it can be specified by adding a special symbol “に” to a predetermined place of display data such as a text output.

As described above, visualizing the difference between the text of the previous day and the text of the present day, which is the content of the daily report in the automatically transmitted report mail, can be used for the business daily report distributed by mail.

Further, this mail distribution method can be used for a product sales advertisement in a sales business including a supermarket.

In a system for periodically issuing product information or information posted by a member, such as monthly or quarterly, to a pre-registered member, the system is effective even when special extra information is distributed within the applicable period. Available to

The method of notifying database update information according to the embodiment is configured as described above, and has the following effects.

The first effect is that, in the information that is periodically referred to, the data that the user focuses on is only recently updated data. Therefore, when the search result is displayed, the change difference data is detected and visualized in real time. Is performed, the update status can be visually shown to the user, the trouble of finding the change data can be greatly reduced, and the update data can be prevented from being overlooked.

The second effect is that the data structure of the master database 230 can be simplified by separating the data change history required for specifying the data update location from the master database 230, and reusing data. It is easy to do. On the other hand, when the change history information is included in the master database, a special process is required to remove the change history information, and the database is difficult to reuse.

The third effect is that no change is made to the database itself other than the process of adding / updating information contents, so that the processing operation can be smoothly performed on a system already in operation.

The fourth effect is that, by separating the difference detection processing from the difference visualization processing such as display on a CRT or printout, the difference detection processing is easy to use (understand) in accordance with the final output format (display format). To be able to freely choose the expression method.

In the present embodiment, the present invention is not limited to this, and can be applied to a technique relating to a method of notifying database update information, which is suitable for applying the present invention.

Further, the number, position, shape, etc. of the above-mentioned constituent members are not limited to the above-described embodiment, but can be set to a suitable number, position, shape, etc. for implementing the present invention.

In each of the drawings, the same components are denoted by the same reference numerals.

[0080]

Since the present invention is configured as described above, the following effects can be obtained.

The detection and visualization of the change difference data clearly shows the update state to the user, so that the update data and additional data can be easily confirmed.

By separating the database for specifying the data update location as a difference from the master database, the structure of the data system can be simplified.

Since the database itself is not changed except for the process of adding / updating information contents, the operation can be smoothly performed even in the operating system.

By separating the difference detection processing from the display of the difference, it is possible to select a user's desired or effective display format.

By using the information in a business daily report distributed by e-mail, the difference between the text of the previous day and the present day, which is the content of the daily report in the automatically transmitted report mail, is visualized, so that the latest difference information that the user should pay attention to can be displayed. It can be displayed effectively.

[0086] By using the mail distribution for a product advertisement in a sales business including a supermarket, etc., the user can visualize the difference between the previous and current advertisement texts, which is the advertisement content in the automatically transmitted advertisement mail, to allow the user to view it. The latest difference information to be focused on can be displayed effectively.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration for executing a method for notifying database update information according to an embodiment of the present invention.

FIG. 2 is a diagram showing a configuration in which the network of FIG. 1 is applied to the Internet.

FIG. 3 is a flowchart illustrating an example of an operation in a method for notifying database update information according to the embodiment of the present invention.

FIG. 4 is a diagram illustrating a configuration of an example of an application example of the method for notifying database update information according to the embodiment of the present invention;

FIG. 5 is a diagram showing an example of a mail transmitted from the mail server of FIG. 4;

[Explanation of symbols]

A01 Automatic transmission mail A02, B02 Date B01 Automatic transmission mail B03, B04 Report 100 Client 110 WWW browser (client software) 120 Mail reader 200 Database server 210 Task automatic execution control unit 220 Database duplication processing unit 230 Master database (main database, daily report) Database) 240 difference database 300 WWW server (application server) 310 interface unit (CGI interface unit) 320 data display screen generation unit 330 data update unit 340 data read processing unit 350 difference detection processing unit (difference detection means) 360 task automatic execution Control section 370 mail body generation section 400 mail server 500 network 510 interface Tsu door

Claims (8)

[Claims] 1. A method of notifying database update information to a user via a network such as the Internet, comprising: a first step of monitoring the database; and providing the user with the content of the database. A first step of comparing the main database with a difference database generated by copying the database, and adding the difference to the difference based on the comparison result. A third step of adding an attribute meaning update, wherein the second step adds a predetermined code to information corresponding to the difference to which the attribute has been added, thereby displaying the display means of the user. Displaying information indicating addition / update to the database. 2. The method according to claim 1, wherein the first step includes:
2. The method according to claim 1, further comprising the step of copying the main database at a predetermined time and generating the difference database. 3. The method according to claim 3, wherein, when a search / display processing request for the database is received from the user, the main database is searched based on search conditions of the search / display processing request. A fourth step of acquiring a list of records, or acquiring the list of records by searching the main database at predetermined times, and determining whether there are any unprocessed records in the retrieved list of records. And if there is the unprocessed record,
5. The method according to claim 1, further comprising: reading a corresponding record from the difference database, performing a comparison process with the corresponding record in the main database, and extracting the difference. Notification method of database update information. 4. The method according to claim 1, wherein the third step includes, for each user, adding an attribute indicating the difference to the data of the day from the record list, and the second step includes a code corresponding to the attribute. The notification of database update information according to any one of claims 1 to 3, further comprising a step of transmitting display data such as text data including the data of the day to which the data is added to the display means of the user. Method. 5. The display data such as text data in the method of notifying database update information according to any one of claims 1 to 4 is used for a business daily report, and a user who has been registered in advance registers the data of the day as the latest information. A business daily report delivery method, wherein the specified display data is delivered. 6. A display data such as text data in the method for notifying database update information according to any one of claims 1 to 4 is used for a merchandise sales advertisement. A product advertisement distribution method, characterized by adding an attribute indicating the difference and distributing the display data specified as a product of interest. 7. A user's display by applying a predetermined font type, adding an underline, an enclosing frame, or the like to addition / update data to an attribute in the method for notifying database update information according to any one of claims 1 to 4. A data display method, wherein the data is displayed on a means to clearly indicate that the data is additional / updated data. 8. A storage medium on which a program capable of executing the method for notifying database update information according to claim 1 is recorded.