Spreadsheet user-interface for an internet-document change-detection tool

• US 5,983,268 A
• Filed: 03/25/1997
• Issued: 11/09/1999
• Est. Priority Date: 01/14/1997
• Status: Expired due to Term

• Current Assignee: NetMind Technologies, Inc. (Nokia Corporation)
• Original Assignee: NetMind Technologies, Inc. (Nokia Corporation)
• Inventors: Noble, Alan C., Freivald, Matthew P., Richards, Mark S.
• Primary Examiner(s): Matar, Ahmad F.
• Assistant Examiner(s): VU, THONG H
• Application Number:
  US08/823,761
• Time in Patent Office: 959 Days
• Field of Search: 395/600, 707/10, 707/9, 707/513, 709/201, 710/107, 434/350, 713/201
• US Class Current: 709/218
• CPC Class Codes: G06F 16/957 Browsing optimisation, e.g. caching or content distillation
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking

Abstract

A change-detection tool detects significant changes in numerical fields within internet web pages on the world-wide-web. A user identifies web-page web pages by specifying the web page'"'"'s URL. The user then highlights one or more numeric fields on the web-page web page. The numeric fields'"'"' values are extracted to cells on a spreadsheet displayed to the user. The user enters parameters and formulas into unused spreadsheet cells. The formulas operate on the numeric values extracted from the web page to the spreadsheet'"'"'s cells. The user also enters notification limits or conditions that are based on the results of the formulas. The notification conditions indicate when a change notification is to be e-mailed to the user. After the user finishes registering the web-page web page, the change-detection tool periodically retrieves the web-page web page at the specified URL and re-calculates the formulas and determines if the notification conditions have been met. The change-detection tool automatically retrieves web pages and re-calculates the formulas and conditions specified by the user in the spreadsheet. Arbitrary formulas can be used to perform arbitrary calculations on the web data and specify arbitrary conditions for user notification. Numeric data from multiple web pages can be extracted to the same spreadsheet, allowing numeric data from different, unrelated web pages to be combined in the calculations of the spreadsheet.

Claims

1. A change-detection web server for detecting numerically-significant changes in web pages comprising:

a network connection for transmitting and receiving packets from a remote client and a remote web-page server;

a responder, coupled to the network connection, for communicating with the remote client, the responder registering a web page for change detection by receiving from the remote client a uniform-resource-locator (URL) identifying the web page, the responder fetching the web page from the remote web-page server and generating markers for identifying locations of numeric data fields within the web page;

a spreadsheet user-interface, coupled to the responder, for displaying a spreadsheet on the remote client, the spreadsheet having rows and columns of cells, each cell for receiving a formula from a user, the formula specifying calculations performed on the numeric data fields from the web page;

a database, coupled to the responder, for receiving the URL and the markers from the responder and for receiving the formula from the spreadsheet user-interface when the web page is registered by the remote client, the database for storing a plurality of records each containing a URL, markers, and the formula for a registered web page; and

a periodic minder, coupled to the database and the network connection, for periodically re-fetching the web page from the remote web-page server by transmitting the URL from the database to the network connection, the periodic minder receiving a fresh copy of the web page from the remote web-page server, the periodic minder extracting fresh numeric values from the fresh copy of the web page from locations identified by the markers and recalculating a result of the formula using the fresh numeric values, the periodic minder signaling a detected change to the remote client when the result exceeds a predetermined notification condition,

whereby a numerically-significant change in the web page is detected by re-calculating a user-entered formula which operates on numeric data from the web page, wherein changes in the web page which do not cause a re-calculated result to exceed the predetermined notification condition do not signal the remote client.

2. The change-detection web server of claim 1 wherein the database does not store the web page, the database storing a formula for re-calculating the result using the fresh numeric values on the web page,

whereby storage requirements for the database are reduced by archiving the formula and not entire web pages.

3. The change-detection web server of claim 2 further comprising:

selection means, coupled to the responder, for receiving a selection from the remote client, the selection identifying the numeric data fields within the web page;

parsing means, coupled to the responder, for parsing the web page and generating the markers identifying the locations of the numeric data fields;

compare means, coupled to the periodic minder means, for comparing the result to the predetermined notification condition.

4. The change-detection web server of claim 3 wherein each record in the database further comprises:

a notification condition field for storing the predetermined notification condition, whereby the predetermined notification condition is stored in the database for each record.

5. The change-detection web server of claim 1 further comprising:

a calculation engine, receiving the formula from the database and the fresh numeric values extracted from the fresh copy of the web page, for re-calculating the result.

6. The change-detection web server of claim 1 wherein the web page is a hyper-text markup-language (HTML) web page containing HTML tags, the HTML tags for indicating formatting, layout, and hyper-links specifying URLs of other servers, the change-detection web server further comprising:

divider means, coupled to the responder, for dividing the web page into portions bound by the HTML tags;

marker means for generating the markers, the locations of the fresh numeric values being referenced by the markers to locations of the HTML tags; and

report means for signaling a change in the web page when one of the markers for the web page has no matching fresh numeric value in the fresh copy of the web page,

whereby the markers are generated and stored for the fresh numeric values located near the HTML tags.

7. The change-detection web server of claim 6 wherein the report means further comprises:

mailer means, coupled to the network connection, for sending a change notification message to the remote client when the change is signaled,

wherein the responder receives an electronic-mail address from the remote client, the responder storing the electronic-mail address of the remote client in the database, and the mailer means reading the electronic-mail address from the database, the change notification message being sent to the remote client as an electronic-mail message addressed to the electronic-mail address,

whereby the remote client is notified of the change by electronic mail.

8. The change-detection web server of claim 7 wherein the packets transmitted to the network connection are TCP/IP packets and wherein the remote client and the remote web-page server are on the Internet.

9. The change-detection web server of claim 1 further comprising:

second web-page means, coupled to the network connection, for fetching a second web page from a second remote web-page server, the responder generating second markers for identifying locations of second numeric values on the second web page in response to user selections,

wherein the formulas operate on the numeric values from the web page and on the second numeric values from the second web page,

whereby numeric values from two web pages are combined in formula to determine when the predetermined notification condition is met.

10. The change-detection web server of claim 9 wherein each record in the database further comprises parameters, the parameters being entered by the user into the spreadsheet user-interface, the parameters being constant numeric values independent of the web pages.

11. The change-detection web server of claim 10 wherein the formulas include a combination of operators selected from the group consisting of addition, subtraction, multiplication, division, root, minimum, and maximum.

12. A computer-implemented method for detecting a significant change in numeric fields on a web page and notifying a user of the significant change, the method comprising the steps of:

registering the web page by;

receiving an address of the user and a locator for the web page;

fetching the web page from a remote server by transmitting the locator to a network server;

extracting numeric values from selected numeric fields on the web page, the selected numeric fields selected by the user;

displaying a spreadsheet to the user, the spreadsheet having rows and columns of cells forming a grid;

displaying the numeric values in extracted-data cells of the spreadsheet;

accepting formulas input by the user in unused cells of the spreadsheet, the formulas operating on the numeric values by specifying in the formulas a row and a column of the extracted-data cells;

storing the formulas, the locator, the address of the user, and field locations on the web page of the numeric fields in a database;

after a period of time, periodically checking to determine if a significant change has occurred by;

reading the locator from the database and transmitting the locator to remote server to fetch a recent copy of the web page;

reading the field locations from the database and extracting new values of the numeric fields from the recent copy of the web page;

reading the formulas from the database and recalculating results of the formulas using the new values extracted from the recent copy of the web page;

signaling that a significant change is detected when the results from recalculation meet a notification condition;

whereby neither the web page nor the numeric values from the web page are stored in the database which stores the formulas.

13. The computer-implemented method of claim 12 wherein the step of signaling that the significant change is detected comprises:

reading the address of the user from the database and sending a message to the address of the user stating that a change has occurred,

whereby the user is notified by a message when the significant change is detected.

14. The computer-implemented method of claim 13 wherein the step of registering the web page further comprises:

registering a second web page by;

receiving a second locator for the second web page;

fetching the second web page from a remote server by transmitting the second locator to the network server;

extracting second numeric values from second numeric fields on the second web page, the second numeric fields selected by the user;

displaying the second numeric values in second extracted-data cells of the spreadsheet;

accepting formulas input by the user in unused cells of the spreadsheet, the formulas operating on the numeric values and the second numeric values by specifying in the formulas a row and a column for each of the extracted-data cells and a row and a column for each of the second extracted-data cells;

storing the second locator and second field locations on the second web page of the second numeric fields on the second web page;

whereby the formulas combine numeric values from the web page and the second web page.

15. The computer-implemented method of claim 14 wherein the web page and the second web page are web pages on the world-wide web and the locator and the second locator are uniform-resource locators (URLs).

16. The computer-implemented method of claim 12 wherein the period of time is a day.

17. A computer-program product comprising:

a computer-usable medium having computer-readable program code means embodied therein for detecting numerically-significant changes in a web page, the computer-readable program code means in the computer-program product comprising;

network connection means for transmitting and receiving packets from a remote client and a remote web page server;

responder means, coupled to the network connection means, for communicating with the remote client, the responder means registering web pages for change detection by receiving from the remote client a uniform-resource-locator (URL) identifying the web page, the responder means fetching the web page from the remote web page server and generating markers identifying locations of numeric values in the web page;

spreadsheet user-interface means, coupled to the responder means, for displaying a spreadsheet of cells on the remote client, the spreadsheet including cells displaying the numeric values from the web page, the spreadsheet user-interface means including means for entering formulas into cells from the remote client, the formulas referencing the cells containing the numeric values from the web page;

database means, coupled to the responder means, for receiving the URL and the markers from the responder means when the web page is registered by the remote client, the database means further for receiving the formulas from the spreadsheet user-interface means, the database means for storing a plurality of records each containing a URL, markers, and formulas for a registered web page, the database means not storing the web page or the registered web pages, the database means storing markers and formulas for the web page; and

periodic minder means, coupled to the database means and the network connection means, for periodically re-fetching the web page from the remote web page server by transmitting the URL from the database means to the network connection means, the periodic minder means receiving a fresh copy of the web page from the remote web page server, the periodic minder means extracting fresh numeric values from the fresh copy of the web page and re-calculating a fresh result of the formulas using the fresh numeric values, the periodic minder means signaling a numerically-significant detected change to the remote client when the fresh result meets a notification condition,

whereby the numerically-significant change in the web page is automatically detected by periodically re-fetching the web page and extracting the fresh numerical values and recalculating the fresh result of the formulas entered into the spreadsheet during registration.

18. The computer-program product of claim 17 wherein the database means does not store a copy of the document, and wherein the database means does not store the numeric values extracted from the document, the database means storing the formulas, whereby storage requirements for the database means are reduced by archiving the formulas and not entire web pages.

19. The computer-program product of claim 18 wherein the computer-readable program code means further comprises:

selection means, coupled to the responder means, for receiving a selection from the remote client, the selection identifying locations of the numeric values on the web page;

parsing means, coupled to the responder means, for parsing the web page and extracting the numeric values from the web page, the parsing means generating markers for identifying locations on the web page of the numeric values; and

second parsing means, coupled to the periodic minder means and receiving the markers from the database means, for parsing the fresh copy of the web page and extracting the fresh numeric values from the fresh copy using the markers for identifying the locations on the web page of the fresh numeric values;

wherein the database means further stores the markers with the record, whereby the parsing means generates the markers for identifying the locations of the numeric values.