System and method for distributed database management of graphic information in electronic form

• US 7,016,901 B2
• Filed: 07/30/2002
• Issued: 03/21/2006
• Est. Priority Date: 07/31/2001
• Status: Expired due to Fees

• Current Assignee: IDEAL Scanners & Systems, Inc.
• Original Assignee: IDEAL Scanners & Systems, Inc.
• Inventors: Eikenbery, Sean A.
• Primary Examiner(s): Le, Debbie M.
• Application Number:
  US10/207,237
• Publication Number:
  US 20030028538A1
• Time in Patent Office: 1,330 Days
• Field of Search: 707 1- 10, 707100-102, 707/104.1, 715/500, 715/502, 715/530
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/50 of still image data
• CPC Class Codes: G06F 16/53 Querying
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A system (10) for managing a distributed database of electronic data files generally includes at least one host platform (100) disposed at a first site, at least one storage facility (200) disposed at a second site remote therefrom, and one or more user platforms (300) disposed at third sites remote from the first and second sites. The storage facility (200) retrievably stores a plurality of electronic data files for generating graphic images. The host platform (100) is configured to automatically control access by user platforms (300) to the electronic data files and maintains a system index table containing for each of the stored electronic data files at least one file record of identifying attributes corresponding thereto. The host platform (100) is operable to automatically generate the file record in accordance with a preselected set of configurational parameters and to selectively retrieve at least portions of the electronic data files for graphic reproduction at a user platform (300).

Claims

1. A distributed database management system comprising:

at least one host platform disposed at a first site, at least one storage facility disposed at a second site remote from said first site, and at least one user platform disposed at a third site remote from said first and second sites, said storage facility and said user platform being computer network coupled to said host platform for communication therewith;

said storage facility retrievably storing therein a plurality of electronic data files for respectively generating graphic images of different form;

said host platform being programmably configured to automatically control access to said electronic data files by said user platform, said host platform maintaining a system index table containing for each said electronic data file at least one file record of identifying attributes corresponding thereto, said attributes including an alphanumeric document identifier, a document sheet indicator, and a document revision indicator, said host platform being operable to automatically generate said file record in accordance with a preselected set of configurational parameters in a manner corresponding to the form of said electronic data file;

said host platform including first and second builder components selectively operable to generate said file records respectively for said electronic data files acquired from a printed medium and from an electronically stored medium, said file records being entered in said system index table;

said host platform including a plurality of application modules selectively executable responsive to actuation by said user platform, said host platform being operable thereby to selectively retrieve at least portions of said electronic data files for graphic reproduction at said user platform, said application modules including a module for searching said system index table responsive to a search query generated by said user platform pertaining to at least one said graphic image;

wherein said application modules of said host platform are concurrently accessible to a plurality of said user platforms, said application modules being maintained as fully multi-threaded dynamically linked libraries (DLLs).

2. The distributed database management system as recited in claim 1 wherein said application modules include a module executable to alternatively generate from selected ones of said electronic data files resampled images having partial and full resolution.

3. The distributed database management system as recited in claim 1 wherein said host platform is operable to generate responsive to said search query at least one of a plurality of predefined HTML control links for selection by said user platform.

4. The distributed database management system as recited in claim 1 wherein said host platform is operable to cumulatively generate responsive to actuation by said user platform a user set for retrieval of and subsequent action upon a plurality of selected electronic data files.

5. The distributed database management system as recited in claim 1 wherein said host platform includes a server and at least one workstation coupled thereto, said server including said second builder component for automatically generating said file records to be entered in said system index table.

6. The distributed database management system as recited in claim 5 wherein said workstation includes a scan component for transducing printed versions of archived documents to electronic data file form, and an indexing component for generating said file records to be entered in said system index table corresponding to said transduced documents.

7. The distributed database management system as recited in claim 1 comprising a plurality of said user platforms remotely disposed one from the other, each said user platform being operably coupled to said host platform by a publicly accessible computer network.

8. The distributed database management system as recited in claim 7 wherein said host platform is operably coupled to said storage facility by an access limited private computer network.

18. The distributed database management system as recited in claim 1 wherein a portion of said identifying attributes is read from said printed medium when said electronic data files are acquired from said printed medium.

9. A distributed database management system comprising:

(a) a plurality of storage facilities for retrievably storing therein a plurality of electronic data files for respective graphic display of a plurality of archived documents of different form;

(b) a plurality of user platforms each disposed remotely from said storage facility; and

,

(c) at least one host platform coupled by computer network to each of said storage facilities and said user platforms for communication therewith, said host platform being remotely disposed from said storage facilities and said user platforms,

said host platform being programmably configured to automatically control selective access to each of said electronic data files by each of said user platforms, said host platform being operable to generate and automatically populate a system index table in accordance with a plurality of predefined configurational parameter sets in a manner corresponding to the form of each said electronic data file, said index table containing for each said electronic data file at least one file record of identifying attributes uniquely corresponding thereto, said attributes including an alphanumeric document identifier, a document sheet indicator, and a document revision indicator;

said host platform including first and second builder components selectively operable to generate said file records respectively for said electronic data files acquired from a printed medium and from an electronically stored medium, said file records being entered in said system index table;

said host platform including a plurality of application modules selectively executable responsive to actuation by at least one said user platform, said host platform being operable thereby to selectively retrieve at least portions of said electronic data files for graphic reproduction at said user platform, said application modules including a module for searching said system index table responsive to a search query generated by said user platforms pertaining to at least one said archived document;

wherein said application modules of said host platform are concurrently accessible to a plurality of said user platforms, said application modules being maintained as fully multi-threaded dynamically linked libraries (DLLs).

10. The distributed database management system as recited in claim 9 wherein said application modules include:

(a) an intrashell module having a component for controlling access authentication of said user platforms;

(b) an intrafile module having a component for retrieving responsive to actuation by one said user platform selected ones of said electronic data files;

(c) an intradocs module having a component for receiving and processing a search query generated by one said user platform;

(d) an intraview module having a component for alternatively generating from selected ones of said electronic data file resampled images having partial resolution and full resolution;

(e) an intrauser module having a component for cumulatively generating responsive to actuation by one said user platform a user set for retrieval of and subsequent action upon a plurality of selected ones of said electronic data files;

(f) an intraprint module having a component for configuring and transmitting print jobs responsive to actuation by one said user platform; and

,

(g) at least one administrative module for setting a plurality of preference parameters and maintaining system access authorization information.

12. The distributed database management system as recited in claim 9 wherein said host platform includes:

(a) a server including said second builder component for automatically generating said file records to be entered in said system index table; and

,

(b) at least one workstation coupled to said server, said workstation including a scan component for transducing printed versions of archived documents to electronic data file form, and an indexing component for generating said file records to be entered in said system index table corresponding to said transduced documents.

11. The distributed database management system as recited in claim 11 wherein said host platform is operable to generate responsive to said search query at least one of a plurality of predefined HTML control links for selection by said user platform.

13. A method of managing distributed database of data intensive electronic files comprising the steps of:

(a) retrievably storing at a plurality of storage facilities a plurality of electronic data files for graphically reproducing a plurality of archived documents of different form;

(b) establishing a plurality of user platforms each disposed remotely from said storage facility;

(c) establishing at least one host platform at a site remotely disposed from said storage facilities and said user platforms;

(d) establishing a computer network link between said host platform and each said storage facility for communication therewith;

(e) establishing a computer network link between said host platform and each said user platform for communication therewith;

(f) establishing said host platform for centralized access to said electronic data files by said remotely disposed user platforms;

(g) programmably configuring said host platform to generate and automatically populate a system index table in accordance with a plurality of predefined configurational parameter sets in a manner corresponding to the form of each said electronic data file, said index table containing for each said electronic data file at least one file record of identifying attributes uniquely corresponding thereto, said attributes including an alphanumeric document identifier, a document sheet indicator, and a document revision indicator;

(h) providing in said host platform first and second builder components selectively operable to generate said file records respectively for said electronic data files acquired from a printed medium and from an electronically stored medium, said file records being entered in said system index table; and

,

(i) maintaining at said host platform a plurality of application modules selectively executable responsive to actuation by at least one said user platform, said host platform being operable thereby to selectively retrieve at least portions of said electronic data files for graphic reproduction at said user platform, said application modules including a module for searching said system index table responsive to a search query generated by said user platforms pertaining to at least one said archived document;

(j) maintaining said application modules of said host platform to be concurrently accessible to a plurality of said user platforms, said application modules being maintained as fully multi-threaded dynamically linked libraries (DLLs).

14. The method as recited in claim 13 wherein step (i) includes the step of generating responsive to said search query at least one of a plurality of predefined HTML control links for selection by said user platform.

15. The method as recited in claim 13 further comprising the steps of:

(a) establishing at said host platform a server including a said second builder component;

(b) establishing at least one workstation coupled to said server, said workstation including a scan component and an indexing component;

(c) periodically executing said builder component to automatically generate said file records for entry in said system index table;

(d) periodically executing said scan component to transduce printed versions of archived documents to electronic data file form; and

,

(e) executing said indexing component thereafter to generate said file records to be entered in said system index table corresponding to said transduced documents.

16. The method as recited in claim 13 further comprising the step of selectively generating responsive to actuation by said user platforms resampled images alternatively having partial and full resolution from retrieved ones of said electronic data files.

17. The method as recited in claim 13 further comprising the steps of operably coupling each said user platform to said host platform by a publicly accessible computer network, and operably coupling each said storage facility to said host platform by an access limited private computer network.