Patent Abstract:
A network database system wherein clients of subscribing entities are authorized network access to reliable documents that are identified by each entity as being relevant to clients of that entity. Features that can be included in the system are customization of the documents to reflect sourcing by particular subscribers, automated formatting of the documents for storing in a network database, client access facilitated by subscriber-maintained databases, and the avoidance of cookies remaining on clients&#39; computer hard drives following document access. Also disclosed is a method for processing repeated data requests on a distributed computer database.

Full Description:
[0001]    Appendix A is a hard copy printout of the assembly listing consisting of 37 pages, including the title page. This assembly listing is subject to copyright protection. The copyright owner has no objection to the reproduction of the patent disclosure as it appears in the Patent and Trademark Office patent files or records, but otherwise reserves all copyright rights whatsoever.  
         BACKGROUND  
         [0002]    The present invention relates to communication networks, and more particularly to networks providing document access to authorized subscribers.  
           [0003]    One application of information retrieval systems is to provide (by display, printing, or other appropriate means) a collection of documents that is directed to a particular field, so that a particular set of authorized users can select and retrieve a desired portion of the collection. One example of such a system for use in the office of a professional practice has a terminal connected to a memory device having the collection accessible to it (such a collection of video tapes or compact disk ROM being selectively inserted into a compatible drive unit), the terminal controlling the drive unit to access desired portions of particular ones of the media having documents of interest to clients of the practice. Unfortunately, such systems are expensive to provide, set up, and maintain in that all of the costs must be attributed to a single practice. Also, the set up and maintenance frequently requires skills that are not readily available on site.  
           [0004]    A recent development is the wide use of network communications over the Internet, on which a wide variety of information is available in massive volumes using local telephone connections and personal computers. The Internet is actually a collection of networks and gateways that use the Transport Control Protocol/Interface Program (TCP/IP) suite of protocols that was developed by the U.S. Department of Defense. The local telephone connections are typically to nearby network server computers (servers) that have connections to other servers. Documents and other information are commonly stored on the Internet using Hyper Text Transfer Protocol (HTTP) in HTML or ASP format in web sites that are implemented at associated servers, the sites being addressed and navigated by using “browser” software of user&#39;s computers. The HTTP version 1.1 (outilined in detail in RFC 2068 at http:www.csl.sony.co.jp/cgibin/hyperrfc?rfc2068.txt) specifies that upon transmission of each requested element, the browser disconnects from the server. Thus the protocol as defined is “connectionless” in that a single continuous connection is not maintained while browsing a website. A great advantage of this technology is that a large segment of the general population has access to the Internet from home. However, much of that information is of questionable validity, especially when provided free of charge, and the location of relevant information can be a daunting task that involves sifting through great volumes of extraneous records.  
           [0005]    Consequently, a number of Internet and other computer database services that are restricted to paying subscribers have been developed. These services are commercially viable for business applications; however, they are often excessively expensive and difficult to use in relation to their utility for infrequent personal use. Also, many such services that need to identify users cause authorization information to be transmitted and permanently stored on users&#39; computer hard disk drives. Traditionally Internet servers identify a user by transmitting the requested data along with a special plain text file called a “cookie” which is stored on the user&#39;s computer disk memory and can have values written thereto by the server. These cookies typically contain information like the user&#39;s name and miscellaneous data that is read back each time the user connects and makes a request, typically for each page or element thereof as indicated above. These cookies are objectionable in that it can contain “viruses” that are known to be harmful to the users&#39; computers. Accordingly, web browsers of the prior art pop up a dialog box that asks whether the user will accept the cookie, further creating an inconvenience to the user. If the user refuses the cookie, then continuity is effectively broken between the browser and the server.  
           [0006]    Thus there is a need for a reliable source of information that is relevant to clients of professional practices, that is easily accessed and selected by authorized users, that monitors or tracks user access sessions without requiring users to accept cookies, and that is inexpensive to set up and maintain without requiring high levels of specialized skill by employees of particular practices having clients that are authorized users.  
         SUMMARY  
         [0007]    The present invention meets this need by providing a network database system wherein clients of subscribing entities are authorized network access to reliable documents that are identified by each entity as being relevant to clients of that entity. Features that can be included in the system are customization of the documents to reflect sourcing by particular subscribers, automated formatting of the documents for storing in a network database, client access facilitated by subscriber-maintained databases, and the avoidance of cookies remaining on clients&#39; computer hard drives following document access. It will be understood that while the term “cookie” can include transmitted and stored codes that do not remain following network access and is therefore not considered harmful, as used herein the term is exclusive of transmitted access data that does not remain stored in the client&#39;s computer following termination of network access. 
       
    
    
     DRAWINGS  
       [0008]    These and other features, aspects, and advantages of the present invention will become better understood with reference to the following description, appended claims, and accompanying drawings, where:  
         [0009]    [0009]FIG. 1 is a plan view of a database system according to the present invention being connected to a computer database;  
         [0010]    [0010]FIG. 2 is a flow chart for a document conversion macro of the system of FIG. 1;  
         [0011]    [0011]FIG. 3 is a flow chart for an index preparation portion of the macro of FIG. 2  
         [0012]    [0012]FIG. 4 is a flow chart for an convert document portion of the macro of FIG. 2;  
         [0013]    [0013]FIG. 5 is a navigation path diagram for a subscriber entity portion of the system of FIG. 1; and  
         [0014]    [0014]FIG. 6 is a navigation path diagram for a client network access to the system of FIG. 1. 
     
    
     DESCRIPTION  
       [0015]    The present invention is directed to a document conversion and network database system that is particularly effective in-providing relevant document data to authorized clients of subscriber entities. With reference to FIGS.  1 - 6  of the drawings, a network database system  10  includes a primary computer  12  for receiving and processing data from a provider  13 , a subscriber computer  14 , and a client computer  16 , each of the computers  12 ,  14 , and  16  being connectable to a distributed computer network  18 . In an exemplary implementation, the computer network  18  includes a multiplicity of communication lines  20  and a plurality of server computers  22 . One such server, designated  22 A, is a primary server that is set up in a conventional manner for directing communications on the network  18  and having additional features in accordance with the present invention that are described below. Optionally, the primary server  22 A is principally associated with the primary computer  12  (by a local telephone connection); moreover, the primary computer  12  can be integrated with the primary server  22 A. Another server, designated  22 B, communicates with the subscriber computer  14 , and a further server, designated  22 C, communicates with the client computer  16 . It will be understood that a single server may communicate with more than one of the computers  12 ,  14 , and  16 . Further, it is contemplated that the system includes a plurality of the subscriber computers  14 , multiple counterparts of the client computers  16  for each of the subscriber computers  14  and, possibly, a plurality of the primary computers  12 . In the exemplary implementation described herein, the communication network  18  is the Internet, with at least some of the communication lines  20  being conventional telephone utility lines, each computer having a suitable modem or digital port (not shown) for interfacing with the telelphone utility lines. As used herein, each of the servers  22  other than the primary server  22 A is considered to be a part of a composite network, designated  18 ′.  
         [0016]    A principal feature of the present invention is that the primary computer  12  is implemented for automatically customizing selected documents of the provider to identify the subscriber, and optionally the client, and reformatting the selected documents to facilitate navigation therein by the subscriber&#39;s clients. The clients selectively access and navigate the documents using communications between the client computer  16  and the client server  22 C. The primary computer  12  includes a CD-ROM drive  24  for receiving and inputting source disks  25  that may be periodically received from the provider  13 . The computer  12  may also include a high-density disk drive  26  for writing processed counterparts of the received data on output disks  27  for delivery to the primary server  22 A. It will be understood that the CD-ROM drive  24  and the high-density drive  26  can be a single device, and further that the processed data can be transmitted to the primary server  22 A over the network  18  instead of being delivered on the high-density disks. A suitable primary server  22 A can be implemented with the server computer  22  running Windows NT 4.0, Microsoft Internet Information server 4.0, Microsoft Index server, Microsoft Site-server Express, Microsoft Active Server Pages, Microsoft SQL Server 6.5, and Microsoft Transaction Server that are commercially available programs of Microsoft Corp. of ______, WA. According to the present invention, the server  22 A is further programmed for authorizing and tracking client access as described below in connection with a subscriber and client database that can be implemented in the above-identified SQL Server program.  
       Document Conversion  
       [0017]    The source disk  25  preferably contains the data from the provider  13  in a plurality of document files, one or more index files, and one or more map files, illustrations, the map files defining links to related documents and images. In an exemplary implementation, the various files are stored as compressed text files in American Standard for Information Interchange (ASCII) format. Typically, certain text is delimited with special codes, such as by being enclosed in brackets, as “[ . . . ]”. Preferably, the text files have imbedded tags for delimiting titles, subtitles, sections, headers, footers, etc. However, HTML tags are appropriately locatable for aesthetically formatting the documents and facilitating navigation thereof based on the document structure alone, without reliance on imbedded tags being in the raw ASCII files. For example, titles and subtitles may be identified by having a length of only one line.  
         [0018]    As shown in FIG. 2, a document conversion process  50  is operable when the source disk  25  is mounted in the CD drive  24 . The process includes a conventional decompress step  52  wherein compressed file archives of the provider  13  on the disk  25  are decompressed and each of the resulting files is copied as ASCII text in a suitable hard disk memory working directory  53  of the primary computer  12 . Next, a suitable word processor program is entered in a start word process step  54  and a conversion macro  56  is invoked for processing the source text as described herein. Suitable word processor programs include Microsoft Word 7.0 and Mac Word, as appropriate for suitable IBM-compatible and McIntosh* implementations of the primary computer  12 , each program being available from Microsoft Corp. In each of these implementations, a the conversion macro  56  is appropriately coded in Visual Basic™, also available from Microsoft Corp.  
         [0019]    In the conversion macro  56 , the working directory  53  as well as a target directory are determined in an initialize step  58 , and linkmap and docmap files therein are opened in an open map step  60 . In the initialize step  58 , one of several possible modules of the files is selectable according to available categories of the information. For example in the case of medical documents, exemplary categories are Adult Health, Pediatric Health, Behavorial Health, Women&#39;s Health, etc. as further enumerated in the above-referenced listing of Appendix A. The working directory can be a particular subdirectory having the selected category of documents. Next, a file is read from the top of the directory  53  in a read first file step  62 , and a loop  63  is entered wherein a test index step  64  is performed. This test is firstly on the filename main part for bypassing signon and menu files, for example, and secondly on the extension, also bypassing “*.art” artholder files, the test branching to a prepare index step  66  that is described below in connection with FIG. 3 if the extension is “.idx”. If not, control advances to test article step  68  that for normal articles and similar files such as credits and menus branches to a convert article step  70  that is described below in connection with FIG. 4. Otherwise in each case of bypassing, the macro advances to a read next file step  72 , followed by a test done step  74  whereby the loop  63  is repeated unless there was no next file, in which the macro  56  ends, completing the process  50 .  
         [0020]    As shown in FIG. 3, the prepare index step  66  includes a strip step  76  for removing non-index lines from the current (index) file. A variable η is set to “A” in a set topic pointer step  78 , whereupon a loop  80  is entered in which a get section step  82  finds lines that begin with the letter η, with allowance for the absence of topics having that identification, and further allowance for the topic η having subheadings. Next, in a convert links step  84 , index links are converted to HTML links, and the section η is replaced in an insert section step  86 . Predefined top and bottom content is then added to the file in an add boilerplate step  88 , that content being next modified (by specifying a subindex name, etc.) to be consistent with the selected module in a specialize boilerplate step  90 , after which the current index portion is saved in a save subindex step  92 . The topic letter η is then incremented in an increment pointer step  94 , and a test loop step  96  is performed for repeating the loop  88  until done, in which case control is returned to the main portion of the macro  56 .  
         [0021]    As shown in FIG. 4, the convert article step  70  first finds and replaces embedded tags of the current raw article file with corresponding HTML commented tags in a convert tags step  98 . Text that is delimited with special characters is located, and corresponding HTML delimeters are substituted therefor in a special text step  100 . Particularly, bolded text in the raw ASCII files is delimited by brackets (“ . . . [bolded text] . . . ”), being changed by the special text step  100  to “. . . &lt;b&gt;bolded text&lt;/b&gt;. . . ”. A window title and a displayed article title are created in a create title step  102  that also adds top and bottom HTML tags to the file. Unused header information is then hidden by comment codes, and delimited with appropriate tags in a hide header step  104 .  
         [0022]    Typically, the raw ASCII file has a footer containing a copyright notice, there being a need for improving the form and content of the notice. Accordingly, the footer/copyright information is segregated with lines and italics being added in a convert footer step  106 . Also, if there are sets of tags delimiting reformatted text that should not be altered (such as lists, menus and tables), tags delimiting such text are changed to corresponding HTML tags in a convert preformat step  108 . For example “&lt;!--/btable --&gt; . . . table text . . . &lt;!--/btable --&gt;” is changed to “&lt;pre&gt;. . . &lt;/pre&gt;”. Next, a document anchor step  110  establishes a document target name at the top of the file in HTML format, and extracts external target articles and artwork using the linkmap and docmap files, and imbeds corresponding HTML links.  
         [0023]    Following the document anchor step  110 , a section links step  112  selects section headings and adds copies thereof at the top of the article, the copies being hot-linked into the article body. The section links step  112  makes use of imbedded tags (if present) and structural characteristics of the raw ASCII file to identify the section headings. Next, a paragraphs step  114  converts imbedded paragraph tags to HTML paragraph tags. In the case of indented paragraphs, that text is delimited by “&lt;bodyquote&gt; . . . indented text . . . &lt;/bodyquote&gt;” tags. Simple bulleted lists are then converted from reformatted text into properly formatted HTML lists in a make lists step  116 . More complex lists are also reformatted, if feasible; otherwise they are left as reformatted text.  
         [0024]    Finally, predefined top and bottom content is then added to the file in an add boilerplate step  118 , for providing a consistent appearance in all article files. That content is next modified in a specialized boilerplate step  120  using predefined markers having the actual module name, etc. as in the above-described specialize boilerplate step  90  of FIG. 3.  
         [0025]    Upon completion of the conversion macro  56 , the document and index files, stored in HTML/ASP format are transmitted by any suitable means to the primary server  22 A. As an alternative to using the high-density disk  27  as described above, the files can be uploaded by transmission over the network  18 .  
       Subscriber Navigation  
       [0026]    In the exemplary Internet implementation of the system  10 , the primary server  22 A has a default web page that is addressable from the subscriber computer  14  and any of the client computers  16 . As shown in FIG. 5, a subscriber navigation path  130  permits a subscriber to set up a practice-specific home page using a new site selection option  132  from the default page, designated  134 . In a practitioner registration process, after appropriate information concerning the site is entered using a series of screens, a username and and password for the site is generated at the primary server  22 A, and a virtual website is created as described below. As indicated in FIG. 5, this information is not immediately available to the subscriber, being subsequently e-mailed (following verification of financial arrangements if desired), the primary server  22 A being implemented in a conventional manner for communicating the username and password to the subscriber computer  14 . Alternatively, the subscriber&#39;s usernme and password can be passed over the network  18  to be displayed on the subscriber computer  14  and saved by the subscriber.  
         [0027]    The subscriber navigation path  130  also includes a practitioner login path  136  that is password protected according to the present invention. Once the subscriber has transmitted the username and password to the primary server  22 A, the server transmits corresponding codes directed to a username and password header portion of the web browser being run in the subscriber computer. Thus in subsequent browser requests directed to the family of web page locations, the same username and password is automatically passed to the server  22 A as a part of the request. This is an important feature of the present invention that avoids the risks and inconvenience of the subscriber computer  14  having to accept cookies from the server  22 A, which cookies might possibly contain harmful viruses. Appropriate coding for passing the username and password into the appropriate header field of the subscriber&#39;s or client&#39;s web browser is included in the ODBC program module of the primary server  22 A, the details of such code being within the skill of the web-server programing art.  
         [0028]    Following successful login, control passes to an administration page  138  from which the subscriber can generate and maintain client data/statistics using a stats window  140 , the client data being retained by the primary server  22 A in the above-identified SQL server. The subscriber can also authorize new users in an authorize window  142 , or amend the previously entered site data in an information window  144 . Additionally, the subscriber can access the above-described converted documents from a practioner home page  146 , from which an index window  148  facilitates identification of sought-for information. A new and completely different virtual website is created for each practitioner of the subscriber that completes the practitioner registration process. Thus another important feature of the present invention is that although the registration process of the new site path  132  process requires only five to ten minutes to complete, the resulting practice-specific website appears to have required hours of highly skilled labor to produce, just for the practitionsr&#39;s clients. The practitioners may efficiently promote themselves with these websites, extending the client educational materials of the converted documents to the clients with very little effort.  
       Client Navigation  
       [0029]    As shown in FIG. 6, clients of any of the subscribers can also access the default web page  134  from a client computer  16  as described above in connection with FIG. 5. As shown in FIG. 6, a client navigation path  150  permits a client to register using a new client selection option  152  from the default page  134 . After appropriate information concerning the client is entered using a series of screens, a username and password for the client is generated at the primary server  22 A. The information required from the client can include last name, first name, middle initial, mailing address, telephone number, a personal password, and an e-mail address. Of course some of this information can be omitted, particularly if it has already been provided to the SQL client database, a minimal requirement being that there be sufficient information transimited from the client to distinguish from other clients. As indicated in FIG. 5, the username and password information is not immediately available to the client as described above in connection with FIG. 5, being subsequently e-mailed (with instructions for using the site). It will be understood that the subscriber can communicate the subscriber&#39;s username or any other predetermined designation given to the patient for permitting the client to complete the registration process, which designation can serve as temporary authorization pending granting of the patient&#39;s username and password. Also, the client&#39;s permanent password can be either chosen by the client or generated by the server  22 A. Once registered, patients have access from the default page  134  and a client login window  154  to the subscriber&#39;s home page  146  and the index page  148 .  
         [0030]    Most preferably, the initial client authorization is unique to each practitioner of the subscriber, each of the practitioner virtual home pages having a respective address that is terminated by the corresponding authorization term, whereby the first screen that the client sees is his practitioner&#39;s virtual home page. This page then links to the document modules that the practitioner originally selected during the practitioner registration process.  
         [0031]    In a preferred form, each client education article begins as follows:  
         [0032]    “Welcome, &lt;client&#39;s first name&gt;&lt;Client&#39;s last name&gt; to [systemowner].net. This client education material has been provided to you by &lt;practitioner&#39;s practice name&gt;.” 
         [0033]    Of course, many variations of the above may be appropriate. Anything that is stored in the practitioner/client database(s) can be displayed on the document pages, so that they can br personalized messages.  
       Document Compilation  
       [0034]    The converted documents are dynamically compiled in a process that first reads the header field “WWW-Authenticate” for the username, that field reading “ . . . WWW-Authenticate username:password . . . .” An exemplary form of the corresponding record of the SQL database reads:  
         [0035]    Username|firstname|lastname|mi|lastlogin date|etc.  
         [0036]    A suitable select statement for extracting the client&#39;s name is:  
         [0037]    Select “fname” “mi” “lname” from table where username=“X”.  
         [0038]    An exemplary HTML coding for each web-page is:  
         [0039]    Welcome &lt;%fname%&gt; &lt;%lname%&gt; to Ssytemowner.net This web-site has been provided by &lt;%practicename%&gt; Here is the article text . . . text end.  
         [0040]    Basically, the primary server  22 A looks at each page before sending it out and replaces the placeholders or variables with the corresponding information from the database table. Any fields of the database can be inserted into the documents. The pre-processed pages are then sent to the client&#39;s browser to complete each of the client&#39;s requests. Suitable program code for directing this dynamic compilation is provided in the SMTP program module of the primary server  22 A, the details of such code being within the skill of the web-server programing art.  
         [0041]    Although the present invention has been described in considerable detail with reference to certain preferred versions thereof, other versions are possible. Therefore, the spirit and scope of the appended claims should not necessarily be limited to the description of the preferred versions contained herein.

Technology Classification (CPC): 8