Information delivery system and method

• US 5,802,518 A
• Filed: 06/04/1996
• Issued: 09/01/1998
• Est. Priority Date: 06/04/1996
• Status: Expired due to Term

• Current Assignee: Thomson Reuters Global Resources Unlimited Company (The Woodbridge Co. Ltd.)
• Original Assignee: Multex Systems Incorporated
• Inventors: Zucknovich, Stephen, Leisy, Jacques, Blazek, Pavel, Karaev, Isaak, Urazov, Yuri, Baird, George, Kitain, Eduard, Prohorov, Dmitry
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/658,966
• Time in Patent Office: 819 Days
• Field of Search: 395/6, 395/200.59, 707/9, 707/2, 707/10, 707/5
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24534 Query rewriting; Transformation
• CPC Class Codes: G06F 16/24553 of query operations
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
• CPC Class Codes: G06F 21/31 User authentication
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: G06F 2221/2141 Access rights, e.g. capability lists, access control lists, access tables, access matrices
• CPC Class Codes: G06F 2221/2149 Restricted operating environment
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99939 Privileged access

Abstract

The secure electronic distribution of research documents over the world wide web to investors who are authorized to receive said research documents. A repository server receives research documents from contributors. Also received are corresponding document profiles with information relating to each research document including authorization information specifying who is permitted to access each research document. The repository server includes a first database for structured query searches and a second database for full text searches. A web server is coupled to the repository server and coupled to the world wide web. The web server receives requests from investors for research documents that satisfy a query. The web server determines whether the first database or the second database should be searched based upon the type of query. The repository server transmits to the web server a list of research documents that satisfy the query and which the investor is authorized to access according to the authorization information. The web server formats the list of documents according to a template form. Optionally, queries can be optimized. The system has a control mechanism to prevent concurrent unauthorized access by two people using the same ID/password combination.

Claims

1. A computer-implemented system for the secure electronic distribution of research documents over the world wide web to investors who are authorized to receive said research documents, comprising:

a repository server receiving from a plurality of contributors a plurality of research documents in electronic form and a plurality of corresponding document profiles comprising information relating to each research document including authorization information specifying who is permitted to access each research document, the repository server including a first database for structured query searches storing the information from the plurality of document profiles and a second database for full text searches storing searchable full text of the plurality of research reports; and

a web server coupled to the repository server and coupled to the world wide web, the web server receiving a request from an investor for research documents that satisfy a query, the web server determining whether the first database or the second database should be searched based upon the type of query and thereafter requesting that the repository server query said determined database and transmit to the web server a list of research documents that satisfy the query and which the investor is authorized to access according to the authorization information, the web server thereafter formatting the list of documents according to a template form and transmitting the formatted list of documents to the investor.

2. The system of claim 1 wherein the template form is selected by the investor.

3. The system of claim 1 wherein the template form is selected by the web server according to the identity of the investor.

4. The system of claim 1 further comprising a user computer used by the investor and executing a browser program, the user computer coupled to the world wide web.

5. The system of claim 4 wherein the query is formulated by the investor at the user computer.

6. The system of claim 1 further comprising a plurality of contributor workstations, each coupled to the repository server, for transmitting to the repository server the plurality of research documents and the plurality of corresponding document profiles.

7. A computer-based system for the secure electronic distribution of documents over the world wide web to users who are authorized to receive said documents, comprising:

a plurality of templates, each template specifying an output format;

means for receiving a plurality of documents in electronic form from a plurality of contributors;

means for receiving a plurality of document profiles from the plurality of contributors, each document profile corresponding to one of the plurality of documents and comprising information related to said one of the plurality of documents;

means for receiving authorization information for each one of the plurality of documents, the authorization information defining who is authorized to access said document;

means for converting the plurality of documents into a common format;

means for storing the plurality of documents in said common format;

a relational database for storing the plurality of document profiles and the authorization information;

means for extracting text from the plurality of documents;

a full text database for storing the extracted text;

means for receiving a user identification code from a browser program of remote user;

means for blocking simultaneous use of the user identification code with automatic re-enablement after a predetermined period of inactivity from the user identification code;

means for submitting an initial query to the relational database for all documents the remote user is authorized to access and that were received from contributors during a previous preset time period;

means for transmitting results of queries to the browser program for display according to the format specified in one of the plurality of templates;

means for enabling the remote user to submit queries;

means for determining if a submitted query includes a text search parameter, and if so, routing said query to the full text database, and if not, routing the query to the relational database; and

means for executing the submitted queries by selecting all documents the remote user is authorized to access and that satisfy the submitted query.

8. A computer-based system for the secure electronic distribution of research documents over the world wide web to investors who are authorized to receive said documents, comprising:

a plurality of templates, each template specifying an output format;

means for receiving a plurality of research documents in electronic form from a plurality of contributors;

means for receiving a plurality of research document profiles from the plurality of contributors, each research document profile corresponding to one of the plurality of research documents and comprising information related to said one of the plurality of research documents;

means for receiving authorization information for each one of the plurality of research documents, the authorization information defining who is authorized to access said research document;

a relational database for storing the plurality of research document profiles and the authorization information;

means for extracting text from the plurality of research documents;

a full text database for storing the extracted text;

means for receiving a user identification code from a browser program operated by a remote user;

means for submitting an initial query to the relational database for all research documents the remote user is authorized to access and that were received from contributors during a previous preset time period;

means for transmitting results of queries to the browser program for display according to the format specified in one of the plurality of templates;

means for enabling the remote user to submit queries;

means for determining if a submitted query includes a text search parameter, and if so, routing said query to the full text database, and if not, routing the query to the relational database;

means for optimizing predetermined queries;

means for executing the submitted queries by selecting all research documents the remote user is authorized to access and that satisfy the submitted query.

9. The system of claim 8 further comprising means for blocking simultaneous use of the user identification code with automatic re-enablement after a predetermined period of inactivity from the user identification code.

10. The system of claim 8 further comprising:

means for converting the plurality of research documents into a common format; and

means for storing the plurality of research documents in said common format.

11. The system of claim 8 further comprising:

means for enabling the remote user to select a research document from the results of queries; and

means for transmitting the selected document to the remote user'"'"'s browser program.

12. A computer-implemented system for the secure electronic distribution of research documents over the world wide web to investors who are authorized to receive said research documents, comprising:

a repository server receiving from a plurality of contributors a plurality of research documents in electronic form and a plurality of corresponding document profiles comprising information relating to each research document including authorization information specifying who is permitted to access each research document, the repository server including a first database for structured query searches storing the information from the plurality of document profiles and a second database for full text searches storing searchable full text of the plurality of research reports; and

a web server coupled to the repository server and coupled to the world wide web, the web server receiving a request from an investor for research documents that satisfy a query, the web server determining whether the first database or the second database should be searched based upon the type of query and thereafter requesting that the repository server query said determined database and transmit to the web server a list of research documents that satisfy the query and which the investor is authorized to access according to the authorization information, the web server thereafter transmitting the list of documents to the investor.

13. A method for optimizing search requests received from remote computers operated by users, comprising:

storing at a central server a plurality of document profiles, each document profile corresponding to a document and comprising information related to the document, including a set of one or more authorization groups for the document, each authorization group corresponding with a contributor of the document;

for each user, storing at the central server a set of accessible groups specifying which authorization groups of documents the user is permitted to access;

receiving, at a web server, a search request from a user at remote computer for documents, the search requesting including a limitation that the documents are from a specified contributor;

providing the search request to the central server;

at the central server, creating a first list of groups of documents stored at the central server listing the user'"'"'s accessible groups that correspond with the specified contributor;

at the central server, creating a second list of groups of documents stored at the central server listing the groups that are not accessible to the user and that correspond with the specified contributor;

if the first list is empty, denying the search request;

if the second list is empty, then constructing a search for all documents of the specified contributor that satisfy the search request; and

otherwise, determining selecting the shorter of the first list and the second list, and if the shorter list is the first list, then constructing a search restricted to groups in the first list, and if the shorter list is the second list, then constructing a search restricted to groups of the specified contributor not in the second list.

14. The method of claim 13 further comprising the steps of:

executing the search at the central server;

providing the search results to the web server;

formatting the search results at the web server; and

providing the formatted search results via the Internet to the remote computer.

15. The method of claim 14 wherein the search results comprises a list of documents that satisfy the constructed search.

16. A computer-implemented method for optimizing a query that requests a list of documents sorted by time, the documents stored in a database, comprising:

providing a first query requesting a list of documents sorted by time and a maximum number of documents;

determining a count of the number of documents that satisfy the first query;

if the count is less than or equal to a predetermined threshold, then execute the first query and return the results;

if the count is greater than a predetermined threshold, then determine if the first query is for documents that are dated within a time range;

if the first query is not for documents that are dated within a time range, then select a default time range as the time range;

create a second query comprising the first query with a restriction for documents dated within a predetermined first portion of the time range;

execute the second query and return the results;

if the number of results returned is less than the maximum number of documents, create a third query comprising the first query with a restriction for documents dated within a remaining portion of the time range; and

execute the second query and return the results.

17. The method of claim 16 wherein the maximum number of documents is set by the user.

18. The method of claim 16 wherein the step of providing a first query requesting a list of documents sorted by time further comprises the step of transmitting the first query over the Internet from a remote user.

19. The method of claim 18 wherein the step of determining a count further comprises the step of providing the count over the Internet to the remote user as soon as determined.

20. The method of claim 18 further comprising the step of providing results over the Internet to the remote user as soon as partial results are returned.

21. A method for the secure electronic distribution of documents over the world wide web to users who are authorized to receive said documents, comprising:

providing a plurality of templates, each template specifying an output format;

receiving a plurality of documents in electronic form from a plurality of contributors;

receiving a plurality of document profiles from the plurality of contributors, each document profile corresponding to one of the plurality of documents and comprising information related to said one of the plurality of documents;

receiving authorization information for each one of the plurality of documents, the authorization information defining who is authorized to access said document;

converting the plurality of documents into a common format;

storing the plurality of documents in said common format;

storing the plurality of document profiles in a relational database;

storing the authorization information for each document in the relational database;

extracting text from the plurality of documents;

storing the extracted text in a full text database;

receiving a user identification code from a browser program of remote user;

blocking simultaneous use of the user identification code;

automatically re-enabling use of the user identification code after a predetermined period of inactivity from the user identification code;

initially, executing a first query to the relational database for all documents the remote user is authorized to access and that were received from contributors during a previous preset time period;

outputting results of the first query according to the format specified in one of the plurality of templates;

enabling the remote user to submit queries;

for each submitted query, determining if the query includes a text search parameter, and if so, routing said query to the full text database, and if not, routing the query to the relational database;

executing the submitted queries by selecting all documents the remote user is authorized to access and that satisfy the submitted query; and

outputting the results of the submitted query according to the format specified in one of the plurality of templates.

22. A computer-based system for the secure electronic distribution of documents over the world wide web to users who are authorized to receive said documents, comprising:

a plurality of templates, each template specifying an output format;

means for receiving a plurality of documents in electronic form from a plurality of contributors;

means for receiving a plurality of document profiles from the plurality of contributors, each document profile corresponding to one of the plurality of documents and comprising information related to said one of the plurality of documents;

means for receiving authorization information for each one of the plurality of documents, the authorization information defining who is authorized to access said document;

means for converting the plurality of documents into a common format;

means for storing the plurality of documents in said common format;

a first database for storing the plurality of document profiles and the authorization information;

means for extracting text from the plurality of documents;

a second database for storing the extracted text;

means for receiving a user identification code from a browser program of remote user;

means for blocking simultaneous use of the user identification code with automatic re-enablement after a predetermined period of inactivity from the user identification code;

means for submitting an initial query to the relational database for all documents the remote user is authorized to access and that were received from contributors during a previous preset time period;

means for transmitting results of queries to the browser program for display according to the format specified in one of the plurality of templates;

means for enabling the remote user to submit queries;

means for determining if a submitted query includes a text search parameter, and if so, routing said query to the second database, and if not, routing the query to the first database; and

means for executing the submitted queries by selecting all documents the remote user is authorized to access and that satisfy the submitted query.