Distributed database management system

• US 20030028538A1
• Filed: 07/30/2002
• Published: 02/06/2003
• Est. Priority Date: 07/31/2001
• Status: Active Grant

• Current Assignee: IDEAL Scanners & Systems, Inc.
• Original Assignee: IDEAL Scanners & Systems, Inc.
• Inventors: Eikenbery, Sean A.
• Granted Patent: US 7,016,901 B2
• Time in Patent Office: Days
• US Class Current: 707/10
• 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 for managing a distributed database of electronic data files is provided. The subject distributed database management system (10) 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 from the first site, and one or more user platforms (300) disposed at third sites remote from the first and second sites. The storage facility (200) and each user platform (300) are computer network coupled to the host platform (100) for communication therewith. 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. The host platform (100) 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. It includes a plurality of application modules selectively executable responsive to actuation by a user platform (300). The host platform (100) is thereby operable 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 generating graphic images;

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 host platform being operable to automatically generate said file record in accordance with a preselected set of configurational parameters;

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.

2. The distributed database management system as recited in claim 1 wherein said application modules of said host platform are concurrently accessible to a plurality of said user platforms.

3. The distributed database management system as recited in claim 2 wherein said application modules are maintained as fully multi-threaded dynamically linked libraries (DLLs).

4. 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.

5. 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.

6. 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.

7. 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 a builder component for automatically generating said file records to be entered in said system index table.

8. The distributed database management system as recited in claim 7 wherein said workstation includes a scan component for transducing printed versions of archived A 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.

9. 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.

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

11. 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;

(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, 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 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.

12. The distributed database management system as recited in claim 11 wherein said application modules of said host platform are concurrently accessible to a plurality of said user platforms.

13. The distributed database management system as recited in claim 12 wherein said application modules are maintained as fully multi-threaded dynamically linked libraries (DLLs).

14. The distributed database management system as recited in claim 11 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.

15. 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.

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

(a) a server including a 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.

17. 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;

(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, 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; and

,

(f) 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.

18. The method as recited in claim 17 wherein step (f) includes the step of maintaining said application modules as fully multi-threaded dynamically linked libraries (DLLs) for concurrent accessibility to said user platforms.

20. The method as recited in claim 17 further comprising the steps of:

(a) establishing at said host platform a server including a 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.

21. The method as recited in claim 17 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.

22. The method as recited in claim 17 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.

19. The method as recited in Claiml7 wherein step (f) 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.