Information mart system and information mart browser

• US 6,604,108 B1
• Filed: 06/04/1999
• Issued: 08/05/2003
• Est. Priority Date: 06/05/1998
• Status: Expired due to Fees

• Current Assignee: Biotricity, Inc.
• Original Assignee: Biotricity, Inc.
• Inventors: Nitahara, Kim
• Primary Examiner(s): Metjahic, Safet
• Assistant Examiner(s): Chen, Te Y
• Application Number:
  US09/325,428
• Time in Patent Office: 1,523 Days
• Field of Search: 707/1-5, 707/10, 707/100-104, 707/501-513, 709/300, 382/103, 382/173, 345/700, 345/961, 705/2, 705/3, 435/7, 435/9
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/95 Retrieval from the web
• 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

The invention pertains to an information mart system and information mart browser. The information mart provides an automated mechanism for gathering data that is dispersed among the electronic data storage facilities of an enterprise, and for synthesizing and structuring the gathered data in accordance with the needs of user who require information to analyze the operation of the enterprise. The information mart generates content files that are organized in accordance with a predefined hierarchy of subjects, and a predefined set of relational attributes that are applied to all subjects of the subject hierarchy. The user is thereby provided with both hierarchical and relational access to the data. The user is enabled to browse the data in an intuitive manner through browser navigation tools provided in a graphical user interface that allow the user to provide input specifying a subject of interest and a relational attribute that characterizes the information desired about the subject. The browser further provides multiple simultaneous displays of content files containing related information. Multiple display of files provides juxtaposition of information that is derived from multiple sources and conveyed in multiple formats, thereby enhancing the user'"'"'s capacity for synthesizing and deriving further knowledge. The information mart system thus enables users to locate and browse the vast amount of disparate information that is used by an enterprise using an intuitive navigational metaphor that utilizes both a hierarchical and relational model.

Claims

1. A system for managing information in a pharmaceutical product testing enterprise, comprising:

a logical index associating system content file identifiers with predefined source data, with predefined source data processing rules, with subjects of a predefined subject hierarchy that includes a subject corresponding to each substance, product, protocol, and investigator of the pharmaceutical product testing enterprise, and with predefined relational attributes applied to all subjects of the hierarchy and selected from the group consisting of financial, project, and executive relational attributes;

a content file creation facility for generating system content files by obtaining source data associated with a content file identifier from remote electronic storage facilities and processing the source data in accordance with the predefined source data processing rules associated with the content file identifier to generate the content file;

a file server facility for providing content files in response to content file queries from a browser specifying a subject of the predefined subject hierarchy and relational attribute of the set of predefined relational attributes; and

a browser comprising;

a relational attribute navigation tool for receiving user input specifying a relational attribute of the set of predefined relational attributes that characterizes desired information;

a subject hierarchy navigation tool for receiving user input specifying a subject of the predefined subject hierarchy that characterizes desired information; and

multiple file display facilities for concurrently issuing content file queries to the server facility comprising a specified relational attribute and a specified subject, and for concurrently displaying content files provide by the server facility in a graphical user interface.

2. The system claimed in claim 1, wherein the content file creation facility comprises a control facility for updating information mart content files.

3. The system claimed in claim 2, wherein updating information mart content files comprises periodically creating each locally stored information mart content file from its associated source data in accordance with its associated source data processing rules.

4. The system claimed in claim 2, wherein updating information mart content files comprises, for each locally stored information mart content file, comparing a time/data stamp of the information mart content file with a time/date stamp of each file containing associated source data, and if the time/date stamp of the information mart content file is older than a time date stamp of a file containing associated source data, generating the information mart content file from its associated source data in accordance with its associated source data processing rules.

5. The system claimed in claim 1, wherein the server facility provides an information mart content file by determining a physical address of the information mart content file associated with the information mart content file in the logical index, and if the information mart content file is a locally stored file, retrieving the file from local storage, and if the information mart content file is a remotely stored file, acquiring the file from a remote electronic storage facility.

6. The system claimed in claim 1, wherein the server provides an information mart content file by specifying an information mart content file identifier to the content file creation facility, receiving a content file from the content file creation facility, and providing the content file.

7. The system claimed in claim 1, further comprising a content file storage facility for storage of information mart content files, the content file storage facility having a folder hierarchy corresponding to the predefined subject hierarchy, each folder of the folder hierarchy containing folders corresponding to each of the predefined relational attributes.

8. The system claimed in claim 1, wherein each association in the logical index of an information mart content file identifier to a relational attribute includes a further association with a file display facility of the browser, and wherein each query issued by a file display facility of the browser includes an identification of the file display facility.

9. The system claimed in claim 1, wherein the file server facility further provides, in response to an alternate content file list query specifying a relational attribute and subject, a list of alternate content files that are associated with a specified relational attribute and specified subject that are not provided by the file server facility in response to a content file query specifying the relational attribute and subject, and

wherein the browser further comprises multiple alternate content file list display facilities, each associated with a content file display facility, for concurrently issuing alternate content file list queries to the server in accordance with the specified relational attribute and specified subject, for providing a list of alternate content files associated with the specified relational attribute and specified subject that are not provided by the file server facility in response to a content file query specifying the relational attribute and specified subject, for receiving user input specifying a desired content file from a provided list of alternate content files, and for initiating a query for a content file specified by a user from list of alternate content files.

10. The system claimed in claim 1, wherein the relational attribute navigation tool comprises multiple buttons displayed in the graphical user interface, each button being associated with one of the predefined relational attributes.

11. The system claimed in claim 1, wherein the subject hierarchy navigation tool comprises:

multiple pull down lists displayed in the graphical user interface, each list being dynamically configured to display predefined subjects owned by a previously selected subject; and

a button displayed in the graphical user interface for providing input specifying a selected subject displayed in one of said multiple pull down lists as the predefined subject of desired information.

12. The system claimed in claim 1, wherein the subject navigation tool and the relational attribute navigation tool are displayed simultaneously in the user interface.

13. The system claimed in claim 1, wherein the subject navigation tool, the relational attribute navigation tool, and the multiple file display windows corresponding to the multiple file display facilities are displayed simultaneously in the graphical user interface.

14. A computer readable medium storing control programming for controlling a general purpose computer to function as an information mart browser of an information mart system for a pharmaceutical product testing enterprise, the browser comprising:

a relational attribute navigation tool for receiving user input through a graphical user interface specifying a predefined relational attribute of a set of predefined relational attributes that characterizes desired information, the relational attributes including financial, project, and executive relational attributes;

a subject hierarchy navigation tool for determining subjects of a predefined subject hierarchy of the information mart system, and for receiving user input through a graphical user interface specifying a subject of the predefined subject hierarchy that characterizes desired information, the subjects of the predefined-subject-hierarchy including a subject corresponding to each substance, product, protocol, and investigator of the pharmaceutical product testing enterprise; and

multiple file display facilities for concurrently issuing content file queries to an information mart server facility comprising a specified relational attribute and a specified subject, and for concurrently displaying content files provide by the server facility in a graphical user interface.

15. The computer readable medium claimed in claim 14, wherein the browser further comprises multiple alternate content file list display facilities, each associated with a content file display facility, for concurrently issuing alternate content file list queries to the server in accordance with a specified relational attribute and a specified subject, for providing a list of alternate content files associated with the specified relational attribute and specified subject that are not provided by the file server facility in response to a content file query specifying the relational attribute and specified subject, for receiving user input specifying a desired content file from a provided list of alternate content files, and for initiating a query for a content file specified by a user from list of alternate content files.

16. The computer readable medium claimed in claim 14, wherein the relational attribute navigation tool comprises multiple buttons displayed in the graphical user interface, each button being associated with one of the predefined relational attributes.

17. The computer readable medium claimed in claim 14, wherein the subject hierarchy navigation tool comprises:

multiple pull down lists displayed in the graphical user interface, each list being dynamically configured to display predefined subjects owned by a previously selected subject; and

a button displayed in the graphical user interface for providing input specifying a selected subject displayed in one of said multiple pull down lists as the predefined subject of desired information.

18. The computer readable medium claimed in claim 14, wherein the subject navigation tool and the relational attribute navigation tool are displayed simultaneously in the user interface.

19. The computer readable medium claimed in claim 14, wherein the subject navigation tool, the relational attribute navigation tool, and multiple file display windows corresponding to the multiple file display windows are displayed simultaneously in the graphical user interface.