WO1999061968A2 - System method and computer program product to automate the management and analysis of heterogeneous data - Google Patents

System method and computer program product to automate the management and analysis of heterogeneous data Download PDF

Info

Publication number
WO1999061968A2
WO1999061968A2 PCT/US1999/011643 US9911643W WO9961968A2 WO 1999061968 A2 WO1999061968 A2 WO 1999061968A2 US 9911643 W US9911643 W US 9911643W WO 9961968 A2 WO9961968 A2 WO 9961968A2
Authority
WO
WIPO (PCT)
Prior art keywords
items
document
interest
computer
user
Prior art date
Application number
PCT/US1999/011643
Other languages
French (fr)
Inventor
Kenneth W. Kisiel
Original Assignee
Wisdombuilder, Llc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Family has litigation
First worldwide family litigation filed litigation Critical https://patents.darts-ip.com/?family=22189176&utm_source=google_patent&utm_medium=platform_link&utm_campaign=public_patent_search&patent=WO1999061968(A2) "Global patent litigation dataset” by Darts-ip is licensed under a Creative Commons Attribution 4.0 International License.
Application filed by Wisdombuilder, Llc filed Critical Wisdombuilder, Llc
Priority to AU42086/99A priority Critical patent/AU4208699A/en
Publication of WO1999061968A2 publication Critical patent/WO1999061968A2/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/93Document management systems
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99932Access augmentation or optimizing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • Y10S707/99934Query formulation, input preparation, or translation

Definitions

  • the present invention relates generally to data analysis, and specifically to a system, method and computer program product for automating the collection and analysis of data. More specifically, the present invention provides an automated tool for defining research requirements, collecting, managing and analyzing data, building relationships between data items, and for generating reports based on data from a variety of sources.
  • a major problem with these stand-alone tools is that the analyst is forced to manually manipulate the data between the use of each tool. Additionally, using the conventional method, the analyst is required to have a thorough understanding of Boolean logic and a database query language, such as Standard Query Language (SQL), to gain access to the stored data. It has been estimated that using these conventional methods, analysts can spend up to ninety percent of their time searching, collecting, and organizing information. This leaves a mere five to ten percent of an analyst's time for performing actual analysis of data.
  • SQL Standard Query Language
  • the present invention provides a complete end-to-end data management and analysis tool based on four phases of the intelligence process used to perform research on data.
  • the present invention increases research efficiency by providing automated data analysis that allows analysts to spend more time on data analysis and less time on data management.
  • the present invention accomplishes this by providing a single environment where users can perform knowledge management and knowledge production of data.
  • the knowledge management feature of the present invention allows users to quickly and efficiently cull through large quantities of data, so that items that are of interest, quickly and efficiently emerge to the surface. Once the items of interest are determined, only those data items associated with the items of interest are saved in a repository. These items are saved in the repository along with related tags so that users can leverage off their associative style of thinking and work more efficiently at retrieving data.
  • the knowledge production features of the present invention allow users not only to extract patterns from the data but also to visualize the data so that new patterns and relationships can easily be recorded.
  • the present invention provides a unique set of automation tools to assist the user in conducting research. This is accomplished using a methodology based on four phases for conducting research, namely, the
  • the Requirements phase is where the user records the objectives for the research project.
  • the requirements may be referred to by the user at any time during the remaining research phases to serve as a focal point for the collection and interpretation of data.
  • the requirements entered by the user can be used to automatically perform database searches to compile data for the research project.
  • users define items of interest in a Personal Dictionary.
  • the items of interest are organized by user-defined or predefined categories.
  • the Collection phase is used to filter out relevant data items from irrelevant data.
  • the relevant data is stored in a repository.
  • the present invention provides the user with a set of automation tools to assist in the collection process. Specifically, the present invention automatically searches for the items of interest and associated aliases stored in the Personal Dictionary.
  • automation tools are provided that allow the user to quickly and efficiently determine the relevancy of documents based on the occurrences of the items of interest. This is accomplished in part, by providing the user with interactive visualization displays that model document contents according to the defined items of interest.
  • the present invention provides an efficient means for quickly scanning large volumes of information to determine their relevancy with respect to the current research project.
  • the items that are determined to be relevant are automatically saved into a repository associated with the research project. These items are tagged with descriptive user created pointers to facilitate future retrieval of those items.
  • the Analysis phase is where the collected information from the Collection phase is analyzed, compared, related, and understood in terms of the items of interest from the Personal Dictionary.
  • the analyst reviews the collected items and extracts patterns and relationships. Relationships between data items are recorded and automatically maintained by the present invention.
  • knowledge is added to any item or relationship between items by written comments that are automatically associated with the corresponding data items and maintained by the present invention.
  • the present invention provides the user with relationship diagrams that graphically depict the relationships between any two items of interest. These relationship diagrams are selectable by the user in terms of their "degree of separation". That is, the present invention provides a mechanism that allows users to display direct relationships between two items of interest, as well as indirect, distant relationships. In this fashion, users are instantly presented with distant relationships between items of interest that may never have been known to exist.
  • the Dissemination or Reporting phase is used to assist the analyst in creating reports of a research project. Specifically, summaries and conclusions are captured to be included in the finished reports. Documents are "bookmarked" during the Analysis phase so that they are can be instantly retrieved and included in the final report(s). During the Reporting phase, analysts document their analyses, conclusions and recommendations.
  • FIG. 1 depicts an overview of the analysis process, according to a preferred embodiment of the present invention
  • FIG. 2 is a flowchart depicting the overall process that can be used to manage and analyze data, according to a preferred embodiment of the present invention
  • FIGs. 3-35 are representations of display screens, windows and dialog boxes that can be used in to implement a preferred embodiment of the present invention
  • FIG. 36 is a block diagram depicting database tables that can be used in a preferred embodiment of the present invention.
  • FIG. 37 is a chart that is useful for describing a method that can be used for searching the database and finding relationships between any two items of interest, according to a preferred embodiment of the present invention.
  • FIGs. 38-41 are flowcharts depicting methods that can be used to implement various features, according to a preferred embodiment of the present invention.
  • FIG. 42 is a block diagram of a computer useful for implementing components of the present invention.
  • the present invention is directed toward an automated system and method for defining research requirements, collecting data, analyzing data, visulizing data, building relationships between data items, and generating reports based on data from a variety of sources.
  • the present invention can be implemented in software on a general purpose computer system.
  • An example of a general purpose computer system is presented and described below with reference to FIG. 42.
  • the present invention runs on an operating system with a graphical user interface, such as Windows 95 ® , Windows 98 ® or Windows NT ® manufactured by Microsoft Corporation ® .
  • the example embodiment of the present invention is preferably implemented using a high level language, such as
  • Visual Basic ® , manufactured by Microsoft Corporation. Visual Basic is especially useful to implement the present invention due to its built-in database management capabilities, that are useful for implementing the database management features of the present invention.
  • operating systems include, but are not limited to, various flavors of the UNIX operating system, Macintosh operating systems, Lynx, OS/2, MVS, VM/CMS and the like.
  • FIG. 1 depicts an overview of the analysis process, according to a preferred embodiment of the present invention.
  • This methodology is based on a standard approach for conducting research, namely, collecting, analyzing, and reporting information.
  • the analysis process of the present invention comprises four phases referred to herein as; the Requirements phase 102; the Collection phase 104; the Analysis phaselO ⁇ ; and the Dissemination phase 108.
  • the Requirements phase 102 is used to capture and document initial questions to be answered, or issues to be followed, during a particular research project.
  • the Requirements phase 102 documents requirements that are the focal point for the collection and the interpretation of information.
  • the Requirements phase 102 accepts requirements from a user (also referred to herein as "analyst" and/or "researcher"), such as strategic company goals and specific manager requests. These requirements allow the analyst to focus during the Collection phase 104 and to determine how events are interpreted during the Analysis phase 106.
  • the Requirements phase 102 can also be used to define requirements for an automated search provided by an embodiment of the present invention.
  • the Collection phase 104 directs the searching of internal and external data sources and filters them to extract relevant information therefrom, according to the recorded requirements entered during the Requirements phase 102. Once information is retrieved, the analyst typically reviews the collected information to ensure that the retrieved items contain relevant pieces of information.
  • the retrieved items that are determined to be relevant are automatically saved into a repository associated with the research project.
  • the items that are saved in the repository are tagged with descriptive user created pointers to facilitate future retrieval of those items.
  • the Collection phase 104 processes text and other files from a variety of sources. These sources include the Internet, other databases, scanners, word processors, news services, research services and the like.
  • the files used with the present invention can be in any format including text, audio, video, and graphic file formats.
  • the text and other files are manually compiled by the user and stored on their computer system. Typically this is accomplished using one or more external tools such as scanners, word processors, Internet browsers, Internet search engines and the like.
  • the present invention filters them during the Collection phase 104, by separating relevant data from irrelevant data.
  • the present invention provides a means to compile data for the user based on the requirements entered during the Requirements phase 102. Once the requirements are entered, typically in a natural language format, the present invention communicates with one or more external or internal data sources, such as the Internet, database files, files in the users directories, etc. Once these results are compiled they are used in the Collection phase 102 and filtered for relevant data items, as described above.
  • external or internal data sources such as the Internet, database files, files in the users directories, etc.
  • the Analysis phase 106 is where the collected information from the Collection phase 104 is analyzed, compared, related, visualized, and understood in terms of the requirements entered during the Requirements phase 102.
  • the analyst typically reviews the collected items and extracts patterns and relationships therefrom. In this fashion, the analyst creates meaning to the data items as they relate back to the requirements entered during the Requirements phase 102. Relationships between data items are recorded for later analysis and/or insertion into a final report.
  • users can also add knowledge to any data item by adding written comments. These comments are automatically associated with the corresponding data items and are automatically maintained by the present invention.
  • the Dissemination or Reporting phase 108 is used to assist the analyst in creating reports of a research project. Specifically, summaries and conclusions are captured to be included in the finished reports. During the Reporting phase 108, analysts document their analyses, conclusions, and recommendations.
  • FIG. 2 is a flowchart depicting the overall process that can be used to define requirements, collect, manage and analyze data, according to a preferred embodiment of the present invention.
  • the process begins with step 202, where a user creates a requirement set that defines the basis for the research being conducted.
  • step 204 requirements are added to the requirement set created in step 204. This step continues until all of the requirements have been added into the requirement set.
  • step 206 the collection and filtering of data are performed.
  • the present invention provides several valuable tools that assist the user during the Collection phase 104 so that large quantities of data can be quickly and efficiently compiled, viewed and filtered according to the user specified requirements from steps 202 and 204.
  • step 208 data analysis is performed.
  • the present invention provides several valuable tools to assist the user in finding relationships between data items so that the Analysis phase 106 is performed efficiently.
  • step 210 where the user writes and disseminates reports.
  • the present invention provides the user with valuable tools that assist the user in quickly and efficiently retrieving the relevant information to include in a report, without having to re-read all of the collected data items.
  • FIGs. 3-35 are representations of display screens, windows and dialog boxes that can be used in a preferred embodiment of the present invention. These representations are used for exemplary purposes only to describe the features and functions of the present invention, which can be implemented in a variety of ways that are different from examples presented herein. As such, these examples should not be construed to limit the scope and breadth of the present invention. Furthermore, programming code to implement the features and functions described herein with reference to FIGs. 3-35 would be apparent to persons skilled in the relevant art(s), after reading the present disclosure.
  • a requirement set is created by the user. This can be accomplished by selecting the File/New option 304 from the menu bar 302. When this occurs, a new requirement set dialog box is presented, as shown by
  • FIG. 4 Next, the user enters a name for the new requirement set, such as
  • the requirement set template is named "default.wtp" 502. This a default template that preferably contains default or pre-defined categories that can be used by the user. Examples of such default categories include: People; Places; Organizations; Products; and Events.
  • the present invention creates a database structure (described below) for the requirement set.
  • the requirement set interface is presented to the user, as shown in FIG. 6.
  • users can add 602, edit 604 and delete 606 one or more requirements, such as the requirements 610.
  • users can print the entire list of requirements.
  • requirements can be added to the requirement set 610. Preferably, this is accomplished by selecting the requirement set 610 and then clicking the Add push button 602. This action causes the computer to display a new requirements dialog box 700, as shown in FIG. 7. This dialog box 700 is used to accept from the user, information about the requirement.
  • the user can give the requirement a name 702.
  • the user can specify the requestor, set status and priority, and record the owner of the requirement. These options are typically available through the details tab 704. Additionally the user can record any thoughts, ideas, or comments using the comments tab 706. Note that the requirement 702 is listed in the requirement set interface 600 at 612.
  • requirements can also have sub-requirements. These can be created by selecting the desired parent requirement, such as 612, and then clicking the Add button 602. Note that information pertaining to requirements can preferably be modified at any time by selecting the requirement 610 and by clicking on the Edit button 602. Collection & Filtering of Data
  • the user can begin collecting information pertaining to the requirement 610.
  • the requirement data entered by the user during the Requirements phase 102 is used to initiate a search on one or more external data sources, such as the Internet, database files, or files in the users directories.
  • the interface provided by the present invention preferably allows the user a enter plain text description of the requirement, for example, in the details 704 section of the requirements dialog box 700.
  • the present invention then extracts the concepts from the plain text description and initiates a search based on those concepts.
  • data items that match the concepts from the requirements are presented back to the user.
  • the user typically reviews the returned items, keeping only the relevant ones, and discarding the others.
  • the user can select portions of a single item (or multiple items), and request a new search based on the newly selected items.
  • the user asks the present invention to find additional items that are similar to the selected items (i.e. the user asks the system to "show more items like this").
  • the user is presented with highly relevant information in a quick and efficient manner.
  • the saved data items are used in the Collection phase 102, where they are filtered according to their relevancy.
  • the user uses external tools such as Internet search engines, browsers, word processors, scanners, and the like to compile data that is to be used as a basis for the research project.
  • external tools such as Internet search engines, browsers, word processors, scanners, and the like to compile data that is to be used as a basis for the research project.
  • this form of data compilation can be combined with the automated form of data compilation provided by the present invention, as described above.
  • the Collection phase 104 continues with a two-step process. First the user selects the files for review. Once the files have been selected, the user manually reviews the files, with the assistance of the provided tools (described below), and saves the files that have been determined to be relevant. In a preferred embodiment, the files are saved in a repository associated with the research project..
  • a preferred embodiment of the present invention accepts information from any data source in any format. This includes text, graphics, audio, video, etc.
  • Such file types include, but are not limited to, ASCII, various word processing data files, HTML, VRML, JPEG, MPEG, WAV, MID, BMP, TIF and the like.
  • a collection window 804 provides an interface to the folders that contain information stored on the users computer system. As stated, these files have been compiled by the user either manually, or with the searching capabilities of the present invention.
  • a directory window 804 and a files window 802 allow the user to traverse the storage device to find data items that are to be reviewed for the current research project.
  • These windows 802 and 804 preferably contain standard drive and folder navigation objects.
  • the present invention preferably provides shortcut buttons that the user can select to take them directly to a predefined folder.
  • These predefined folders are defined using the View/Preference option (see 806) from the main menu bar 302. This action displays the Preference window 900 as shown in FIG. 9.
  • the user selects the folders tab 902 and specifies a default directory for the repository 904 and download directories 906.
  • the repository directory is used to store the data collected during the Collection phase 104, that is determined to be relevant to the current research project, based on the recorded requirements.
  • the download directory or directories 906 is where the compiled data is stored.
  • Files can be selected in the files window 802. For example, one file 1002 is depicted as being selected. One or more selected files can be moved to the review list 1004 by clicking the Add button 1006. Alternatively, users can also preferably accomplish this task simply by dragging a selected file, such as 1002 from the files window 802, and dropping it onto the review list 1004. Files can also be removed from the review list by clicking the Remove All button 1008.
  • files in the review list 1004 are reviewed by clicking on the review tab 1008.
  • a review screen is displayed.
  • An example of a review screen is shown in FIG. 11. From the review screen 1100, the user can review the full text of any file listed in the review list 1004. The full text is displayed in the text window 1102. The name of the current file being viewed is shown in the field 1106. To view another file, the scroll button
  • the user can read the displayed text in the text window 1102, to determine if it contains any items of interest pertaining to the research project.
  • this method can be very tedious and time-consuming. For example, if a user is required to view hundreds of documents on a daily basis, it may be not be possible to actually read all of the documents in this fashion.
  • the present invention provides an efficient means for quickly scanning large volumes of information to determine their relevancy with respect to the current research project. Specifically, the present invention provides an automated means to determine whether or not, one or more "items of interest" are contained therein. Items of interest are defined by the user in a Personal Dictionary, according to a preferred embodiment of the present invention.
  • FIG. 12 depicts a display screen that can be used to specify items of interest for a Personal Dictionary according to preferred embodiment of the present invention.
  • the display windows 1202, 1204 and 1206 are empty because data for the Personal Dictionary has not yet been specified by a user.
  • the Structure window 1202 is used to display the structure of the Personal Dictionary.
  • the Structure is typically comprised of one or more categories, followed by one or more items of interest that falls within each category.
  • the Category window 1204 is used to display the category of the currently selected item of interest. Categories are defined by users. Alternatively, users can make use of pre-defined categories provided by the present invention. Examples of such predefined categories include: People; Places; Organizations; Products; and Events. This window 1204 can be pulled down to display a list of all categories defined.
  • the name window 1206 is used to display the name of the currently selected Personal Dictionary.
  • the aliases window is used to display the aliases defined for the currently selected item of interest.
  • the Personal Dictionary allows the user to record, by category, the names of those items that they are interested in tracking.
  • the item names are used to define a criteria for scanning the files. That is, the files are searched for the occurrences of the defined items of interest in the Personal Dictionary.
  • aliases 1208 are recognized in the text files and are treated as being equivalent to the associated item of interest by the present invention. For example, "District of Columbia” may be a defined alias for "Washington D.C.”
  • the present invention reports that two occurrences of the defined item of interest "Washington D.C.” are contained in the document. In this fashion, items of interest are recognized in the documents even though they are not referred to by their formal title.
  • Personal Dictionaries can be shared through the import and export feature of the present invention (see 1210 and 1212). Items can be entered into the Personal Dictionary directly from the Personal Dictionary screen 1200, by manually selecting a category in 1204, entering a name in 1206, and providing any aliases in 1208.
  • the present invention provides a convenient way to add items of interest to the Personal Dictionary while reviewing text in the text window 1102. This is accomplished by highlighting any word in the text window 1102 and clicking the Add button 1108 (see FIG. 11). When this occurs the user is presented with add item window shown in FIG. 13 , so that the user can add a new category or select a category from the Category pull-down 1304. The name of the newly added item of interest is automatically displayed in the Name field 1302, where it can be edited if necessary.
  • FIG. 14 shows a display of a Personal Dictionary.
  • four categories have been defined, namely: Organization 1412; Person 1414; Place
  • the Category window 1406, the Name window 1408 and the Aliases window 1410 are each associated with the particular item of interest that is highlighted (i.e. selected) in the Structure window 1202.
  • the item of interest named "CAPTAIN COOK" 1404 is selected.
  • FIG. 11 is depicted.
  • the user directs the present invention to automatically scan the document being reviewed in the text window 1102 by pressing the Scan button 1502.
  • the present invention scans the document for all items and their respective aliases, as defined in the Personal Dictionary 1400.
  • the results of the scan is presented in the display window 1504. That is, the display window 1504 displays a list of each item of interest found in the document. Further, in a preferred embodiment, when users select an item of interest in the display window 1504, the corresponding words are highlighted in the text window 1102. After a document has been scanned in this fashion, and items of interest have been found, the document is typically deemed to be relevant by the user, and is manually saved in a repository associated with the current research project.
  • the analysis task typically begins with the user reviewing the research documents that have been deemed relevant and saved into the repository as described above. These documents are preferably analyzed from the Analysis/Browse window 1700, shown in FIG. 17. In this example, a document 1706 is listed under the "RESEARCH" category 1708. To begin analysis of the document 1706, the user selects the desired document 1706 and drags it into the right hand display area 1704.
  • the present invention displays a visual representation 1710 depicting information about the contents of the document 1706, to assist the user in analysis.
  • the visual representation 1710 provides the researcher with a means to instantly comprehend the relevancy of the document 1706. This is accomplished by displaying which categories of items of interest are contained within the document 1706.
  • the visual representation 1710 displays the number of occurrences of items of interest within each category.
  • the visual representation 1710 comprises a document icon 1712, representing the document 1706 being analyzed.
  • the document icon 1712 is surrounded by four category icons 1714-1720, each representing a particular category of items of interest found within the document 1706.
  • the categories are: Organization 1714; Person 1716; Place 1718; and Product 1720.
  • the number of items of interest contained in the document 1706, that are within each category is displayed on the connecting line between the document icon 1710 and the corresponding category icon 1714-1720. Accordingly, in this example, the researcher instantly comprehends that the document 1706 contains: one item of interest in the Organization category 1714 ; one item of interest in the Person category 1716; two items of interest in the Place category 1718; and three items of interest in the Product category 1720.
  • the visual representation 1710 provided by the present invention is a quick and efficient means to rank the relevancy of the document 1706, without having to read a single word in the document.
  • the present invention provides a means for the user to instantly review the particular items of interest associated with any of the categories 1714-1720, by interacting directly with the visual representation 1710. This is accomplished by dragging any of the category icons 1714-1720 from the display window 1704, to the item list area 1710.
  • FIG. 18 shows the results of a user dragging the "PRODUCT" icon 1720 into the list item area 1702. Note that in a preferred embodiment, the background color of the item list area 1702 is changed to indicate that relationship data is now being viewed.
  • the list item area 1702 now displays the particular items of interest in the "PRODUCT" category found within the document 1702.
  • the present invention provides a means for users to navigate the entire repository and gain valuable knowledge about the relevancy of documents and the relationships between documents and items of interest, in an extremely fast and efficient manner. Note that this is accomplished without requiring the user to read a single document. In addition, this is accomplished without requiring the user to know anything about database management, SQL queries or the like. In this fashion, users can concentrate on the data being analyzed and not waste time being distracted by traditional data management techniques, such as database queries and the like.
  • FIG. 19 shows the results of a user dragging the "COFFEE” 1806 item of interest into the display area 1704.
  • the display area 1704 now shows the items related to "COFFEE” 1902.
  • the item of interest "COFFEE” is represented by the icon 1904.
  • the related items "RESEARCH” is represented by the icon 1906.
  • any item can be obtained at any time by double clicking on the icon representing the item, such as item 1904. This can also be accomplished by selecting the item 1806 in the item list area 1702 and selecting the View/Profile option 1906 from the menu bar 302. When this occurs, a dialog box, such as the one depicted in FIG. 20 is displayed. From the dialog box in FIG. 20, the user can view information for that item and if desired, modify that information.
  • the focus of the Analysis phase 106 is to provide the user with advanced data analysis tools that allow the user to obtain new and unique information about the data being analyzed by the various views of the data provided herein. In this fashion, users can easily record patterns and relationships found during the analysis process. Relationship links are preferably created when an item is dragged from the item list area 1702 and dropped on the central item in the display area 1704.
  • This action causes a Relationship window 2100 to be displayed, as shown in FIG. 21
  • This relationship window 2100 allows the user to record information about the relationship.
  • the relationship between "COFFEE” 2108 and "CAPTAIN COOK” 2110 is created.
  • the strength of the relationship 2102 and the type of relationship 2104 is recorded.
  • the user entered the keyword "DISCOVERED” 1204 to describe the relationship between "COFFEE” and "CAPTAIN COOK”. Further the word “fact” is used to describe the strength of this relationship, which for example, conveys a much stronger relationship then "speculation”.
  • any comments about the relationship can be recorded in window 2106.
  • the new relationship is displayed in the Analysis/Browse display area 1704, as shown in FIG. 22. If the relationship is associated with an item of interest from a category in which no relations were previously formed, that new category icon is displayed in the display area 1704. If there were already existing relationships between the category and the item of interest, then the count of the related items are updated. In the example shown in FIG. 22, a new relationship category, namely PRODUCT 2204 is shown as being related with the "CAPTAIN COOK" item of interest, represented by the icon 2202.
  • a direct relationship is created.
  • hidden relationships begin to form. That is, more distant relationships that may not be apparent to the analyst are formed.
  • the present invention provides the user with a means to instantly display all of the relationships that exist between items of interest.
  • the present invention provides a mechanism that allows users to display direct and/or distant relationships between any two items of interest.
  • the system and method of the present invention displays a relationship diagram that graphically depicts the relationship between two items of interest and any relationships in-between such items. In this fashion, users are instantly presented with distant relationships that may never have been known to exist.
  • a relationship diagram can be displayed by dragging any two items of interest from the Item List 2302 into the Relationship Between list 2304.
  • FIND button 2306 When the FIND button 2306 is pressed, a relationship diagram is displayed.
  • Relationship diagram 2402 depicts the relationship between two items of interest, namely: "RAINBOW PLANTATION" and "TEA.”
  • RAINBOW PLANTATION a direct relationship exists. This is referred to a relationship with a degree of separation of zero.
  • the degree of separation is displayed in window 2403.
  • the user can display more distant relationships by adjusting the degree of separation. This is accomplished by clicking the arrow 2401 to increase or decrease the degree of separation.
  • the relationship diagram 2410 is displayed.
  • relationships between RAINBOW 2404 and TEA 2406 with one (or less) degree of separation 2407 are depicted.
  • RAINBOW 2404 is related to COFFEE
  • RAINBOW 2404 is not only directly related to TEA 2406, (as shown by the relationship 2405), but is also indirectly related to TEA 2406, through its relationship with COFFEE 2408.
  • the relationship diagram 2416 is the result of the user increasing the degrees of separation 2413 to two.
  • RAINBOW 2404 and TEA 2406 with two (or less) degrees of separation 2413 are depicted.
  • a new relationship is discovered. That is, RAINBOW 2404 is related to TEA 2406, through CAPTAIN COOK 2412 and
  • the relationship diagram 2418 is the result of the user increasing the degrees of separation 2424 to three.
  • the relationship between RAINBOW 2404 and TEA 2406 with three (or less) degrees of separation 2424 are depicted. Several new relationships are depicted.
  • RAINBOW 2404 is related to TEA 2406, through KEALAKEKUA BAY 2420, CAPTAIN COOK 2421 and COFFEE 2422. More distant relationships are displayed (if they exist), by clicking the arrow 2401 to increase the degree of separation
  • the present invention provides a means for presenting the relationships between any two items of interest in a fast and efficient manner. Relationships that are difficult to discover, quickly emerge to the surface using the techniques provided by the present invention.
  • the present invention accomplishes this task by performing an exhaustive search of the repository to display all of the paths between any two items of interest. A method that can be used to implement this artificial intelligence aspect of the present invention is described below.
  • the Dissemination phase 108 typically begins in one of two ways.
  • the first way begins when the analysis is complete However, for lengthy research projects, this may not be the most efficient means.
  • the second and preferred method for creating reports is to establish a report shell at the beginning of the Analysis Phase 106. In this fashion, items are identified and bookmarked for inclusion in the final report as they are discovered during the Analysis phase 106.
  • the present invention provides this capability by allowing the user to create a report during the Analysis Phase 106. This is preferably accomplished by defining a title for the report using a dialog box such as the one shown in FIG.
  • a title screen is displayed in the Reports/Create window, as shown in FIG. 26.
  • the name of the report 2702 is shown on the Analysis/Browse window as shown in FIG. 27.
  • a bookmarking icon 2704 is displayed.
  • FIG.28 items that have been bookmarked are displayed on the Report/Create window 2600 in the Marked List 2802. These items can be used in several ways.
  • FIG. 29 shows the result of a user dragging the item 2904 into the report area 2804. Specifically, the name of the item 2902 is displayed in the report area 2804.
  • the original text is displayed in a text window, as shown by FIG. 30.
  • the display in FIG. 30 allows the user to search the text for items in the Personal Dictionary or on any other string. As indicated by FIG. 30, this is accomplished by using the Find What entry box 3002 and the Find button 3004. Text from this display can also be copied and pasted directly into the report using the copy button 3006. The results of copying a section from the text window in FIG. 30, to the report window 2902, is shown in FIG. 31.
  • the analyst needs to deliver it to a decision-maker.
  • the present invention provides tools that assist the user in formatting the report and delivering it to another user.
  • the user can select a report type that is to be used to generate the report.
  • the report type is provided by a report template, which defines a format for the report.
  • a typical implementation of the present invention provides many template reports that can be selected by the user. After the report type has been selected, the user selects a method in which to deliver the report.
  • the analyst can print the report, send it via E-Mail, or save it to disk in a variety of formats.
  • the screen in FIG. 33 shows a typical Report/Deliver screen that can be used to implement this feature of the present invention.
  • the present invention preferably provides several ways to customize and maintain the system.
  • a Category Manager is provided that allows the user to modify the requirement set structure.
  • Manager window is shown in FIG. 34. This allows the user to add 3404 or delete 3406 any of the categories 3412. In addition, the user can add 3408 or delete 3410, any fields 3402 associated with the categories 3412.
  • Another feature of the present invention allows the user to determine what has changed in the repository from a given date. This feature is described with reference to the "What's New" screen shown if FIG. 35. In this example, the user enters a date at 3502. Once the find button 3504 is depressed, new items that were added since the date entered in 3692 are displayed in the New Items list area 3506.
  • FIG. 36 depicts database tables that can be used to implement the present invention.
  • the Relation table 3602 is used to store relationships that are established between items of interest. Specifically, one entry is associated with each relationship between two items of interest.
  • the Requirements table 3604 is used to store the requirements entered during the Requirements Phase 102.
  • the Report table 3608 is used to store information pertaining to the Dissemination Phase 108.
  • the research table 3606 is used to store information pertaining to the data items saved in the repository during the Collection Phase 104.
  • the user defined category tables 3610 are used to store information about each category defined by the user. Note that in a typical implementation, users can define their own categories or use pre-defined categories provided by a preferred embodiment of the present invention.
  • the dictionary table 3612 is used to store information pertaining to the Personal Dictionary.
  • the Category table 3612 is used to store a list of valid categories defined for the current research project.
  • table 1 A list of fields that can be used to implement the database tables shown in FIG. 36 is presented in table 1 below. Note that the names of the fields listed below are generally descriptive of the type of information stored therein, according to a preferred embodiment of the present invention. Based on the description provided herein and the names of the fields below, the use of these fields should be apparent to persons skilled in the relevant art(s). As such, a detailed description of each of these fields is not provided herein.
  • the fields in table 1 and the associated data tables shown in FIG. 37 represent one example of a means to implement the database management features of the present invention. Many other variations are possible and would be apparent to persons skilled in the relevant art(s).
  • FIG. 37 is a chart that is useful for describing a method that can be used for searching the database and finding the paths between any two items of interest. This method can be used to implement the relationship diagrams shown in FIG. 24. It should be noted that an algorithm used to implement this feature of the present invention is preferably accomplished using a deterministic programming environment that employs automatic backtracking on failure of a pre-condition.
  • This method is preferably performed in response to user action. Specifically, this method is performed in response to a user selecting two items in which the present invention is directed to find the paths between. This can be accomplished, for example, with the screen presented in FIG. 23. Once the two items of interest have been selected, the present invention extracts all of the records in the Relation database table 3602 and writes the information into a flat text file. The flat text file is then read into an internal database structure that is specific to the deterministic programming environment. This table can be viewed as shown in FIG. 37.
  • the method selects a related record, for example, COFFEE 3704. This relationship is compared to the second selected item, TEA 2706 and found not to match. The method then selects a related record to COFFEE 3704. In this example, the related record is TEA 3706.
  • the related record is compared with TEA, which results in a match. Accordingly, the path "RAINBOW PLANTATION 3702 - COFFEE 3704 - TEA 3706" is written to a text file.
  • the method attempts to select another record related to COFFEE.
  • the method selects the next related record for RAINBOW PLANTATION 3703.
  • the next related record for RAINBOW PLANTATION 3703 is MACADAMIA 3708.
  • the method continues as described above, where the method compares the relationship with the second item, namely TEA. In this case, a match is not found.
  • the method attempts to select another related record to MACADAMIA 3708 and fails, because there are no related records to MACADAMIA 3708 in this example.
  • the method selects the next related record for RAINBOW PLANTATION 3702.
  • the next related record is CAPTAIN COOK 3710. Accordingly, this method continues until the entire relationship tree has been traversed and the found paths are written to a text file. At this point, control is passed back to the main method of the present invention.
  • the main method of the present invention then opens and reads the found paths file and creates a matrix of information for each path.
  • This information is preferably retrieved from the Relation 3602 and the User Defined Category tables 3610.
  • a database query is created to read the Relation table 3614 an extract the "ISA" field information.
  • the "ISA" field holds the relationship name between two items. For example, in FIG. 24, screen 2302, the relationship name between RAINBOW 2304 and TEA 2306 is "GROWS". This is the relationship name that is stored in the ISA field.
  • the method paints an icon representing the end nodes, writes a label for the node, paints a line connecting the nodes, and writes a label containing the ISA value.
  • An example of this initial view for a relationship diagram 2402 is shown in FIG. 24.
  • the flowchart in FIG. 38 depicts a process that can be used to implement the interactive data visualization display that is based on the movement of icons representing database records, according to a preferred embodiment of the present invention.
  • Step 3802 represents a step where a user selects an item from the Item List box, such as the TROPICAL ISLAND item 1706 in FIG. 17. This is typically accomplished by placing the mouse pointer over the item 1706 and depressing the left mouse button. The selected item 1706 is highlighted to indicate that it is selected.
  • the process determines the category identification number for the item that is to appear in the center of the display 1712. Specifically, the process reads the text of the highlighted item from the Item List box 1702, and constructs a database query to read from the table of the selected item 1706. In this example, a database query is directed to the Research table 3606, because the selected item 1702 is a research item.
  • SELECT ID FROM RESEARCH WHERE NAME 'A TROPICAL ISLAND'.
  • 'ID' of the selected item 1706 is returned.
  • this is then saved in a global variable, such as CENTER_ID.
  • step 3808 the process retrieves the names of the related items by joining the Relation table 3602 with the User Defined Category tables 3610. Specifically, using the retrieved ID from step 3806, two additional SQL queries are constructed for each user defined category listed in the Category table 3614 to read from the Relation table 3602.
  • the icon representing the category (such as 1714-1720) is displayed, along with the count and the connecting lines.
  • Step 3812 represents an action by the user, wherein the user selects one of the displayed category icons (1714-1720). This is typically accomplished by pointing the mouse to the category icon and depressing the left mouse button. In this example, the Product icon 1720 is selected. Next, the user drags the icon representing the Product category, back to the Item List box 1702.
  • step 3814 the process retrieves the names of the related items by joining the Relation table 3602 with the User Defined Category tables 3610.
  • This step can be implemented as follows. Using the CENTER ID global variable as described above, and the category name, another database query is constructed.
  • the database query is designed to retrieve all the related items from the Relation table 3607, organized in alphabetical order.
  • the list of retrieved names is then displayed in the Item List area 1706, as indicated by step 3816.
  • the process can repeat itself, depending on user action.
  • FIG. 39 is a flowchart depicting a process that can be used to implement a visual representation for modeling document contents, according to a preferred embodiment of the present invention. It is noted that this method is similar to the first 5 steps (3802-3810) of the method presented in FIG. 38.
  • Step 3902 represents a step where a user selects an item from the Item List box, such as the TROPICAL ISLAND item
  • FIG. 1706 in FIG. 17. This is typically accomplished by placing the mouse pointer over the item 1706 and depressing the left mouse button. The selected item 1706 is highlighted indicating that is selected.
  • the process determines the category identification number for the item that is to appear in the center of the display 1712. Specifically, the process reads the text of the highlighted item from the Item List box 1702 and constructs a database query to read from the table of the selected item 1706. In this example, a database query is directed to the Research table 3606, because the selected item 1702 is a research item.
  • the database query is executed and 'ID' of the selected item 1706 is returned.
  • step 3908 the process retrieves the names of the related items by joining the Relation table 3602 with the User defined Category tables 3610. Specifically, using the retrieved ID from step 3906, two additional SQL queries are constructed for each category in the Category table 3614 to read from the Relation table 3602.
  • the icon representing the category (such as 1714-1720) is displayed, along with the count and the connecting lines. The process then ends as indicated by FIG. 39.
  • FIG. 40 is a flowchart depicting a process that can be used for locating and identifying items of interest in documents based on a list of items of interest.
  • the items of interest include aliases for each item as described above.
  • the method performs a search through the document and locates and displays occurrences of the found items and any aliases.
  • this process begins with the creation of a personal dictionary, as described above.
  • the dictionary allows the user to enter aliases in addition to the proper name.
  • control passes to step 4004.
  • step 4004 the process extracts all of the aliases from the dictionary in response to a user request. This is typically implemented by the user clicking the
  • SCAN button 1502 as shown in FIG. 15.
  • the method extracts all of the aliases from the dictionary by for example, performing an SQL query as follows:
  • step 4006 indicates, for each alias (including the proper name of the item), a string search is performed in the target text. Accordingly, for each word in the extracted list from step 4004, a string match is performed. If a match is found, the alias that was found is temporarily stored in an internal variable list.
  • step 4008 the method displays the found matches in the item found list 1504. The process then ends as indicated by FIG. 40.
  • FIG. 41 is a flowchart depicting a process that can be used for marking database items used for reporting purposes. This process is launched by the user moving icons representing database items to a special marking icon, as described above.
  • step 4102 the user creates a new report shell in the Report/Create window shown in FIG. 28. This creates a record in the Reports table 3608.
  • step 4104 this also causes a BOOKMARKING icon to be displayed on the Analysis/Browse window, such as 2704 in FIG. 27.
  • control passes to step 4106.
  • Step 4106 represents a step where the user selects an item for book- marking from the Item List box, such as 2904 in FIG. 29.
  • the selected item 2904 is highlighted indicating its selection. The user then drags the selected item 2904 into the report area 2804.
  • step 4108 is processed.
  • the process reads the text of the highlighted item 2904 for the Item List box and constructs an database query to read from the selected items' table.
  • step 4110 the name and ID is saved in the Report table 3608.
  • an SQL insert query is constructed to write the item ID and the report name into the REPORT table
  • step 4112 the process retrieves the related item names for a report when the Report/Create window is displayed.
  • FIG. 28 shows an example of a Marked List 2802 that is displayed as a result of this step.
  • the process creates a database query to generate the list in 2802.
  • This query retrieves all the related items as a result of Bookmarking, that are to be read from the Report table 3608 and displayed in the Marked list box 2802. The process then ends as indicated by FIG. 41.
  • the present invention may be implemented using hardware, software or a combination thereof and may be implemented in a computer system or other processing system.
  • the invention is directed toward a computer system capable of carrying out the functionality described herein.
  • An example computer system 4201 is shown in FIG. 42.
  • the computer system 4201 includes one or more processors, such as processor 4204.
  • the processor 4204 is connected to a communication bus 4202.
  • Various software embodiments are described in terms of this example computer system. After reading this description, it will become apparent to a person skilled in the relevant art how to implement the invention using other computer systems and/or computer architectures.
  • Computer system 4202 also includes a main memory 4206, preferably random access memory (RAM), and can also include a secondary memory 4208.
  • the secondary memory 4208 can include, for example, a hard disk drive 4210 and/or a removable storage drive 1012, representing a floppy disk drive, a magnetic tape drive, an optical disk drive, etc.
  • the removable storage drive 4212 reads from and/or writes to a removable storage unit 4214 in a well known manner.
  • Removable storage unit 4214 represents a floppy disk, magnetic tape, optical disk, etc. which is read by and written to by removable storage drive 4212.
  • the removable storage unit 4214 includes a computer usable storage medium having stored therein computer software and/or data.
  • secondary memory 4208 may include other similar means for allowing computer programs or other instructions to be loaded into computer system 4201.
  • Such means can include, for example, a removable storage unit 4222 and an interface 4220. Examples of such can include a program cartridge and cartridge interface (such as that found in video game devices), a removable memory chip (such as an EPROM, or PROM) and associated socket, and other removable storage units 4222 and interfaces 4220 which allow software and data to be transferred from the removable storage unit 4222 to computer system 4201.
  • Computer system 4201 can also include a communications interface 4224.
  • Communications interface 4224 allows software and data to be transferred between computer system 4201 and external devices. Examples of communications interface 4224 can include a modem, a network interface (such as an Ethernet card), a communications port, a PCMCIA slot and card, etc.
  • Software and data transferred via communications interface 4224 are in the form of signals which can be electronic, electromagnetic, optical or other signals capable of being received by communications interface 4224.
  • These signals 4226 are provided to communications interface via a channel 4228. This channel 4228 carries signals 4226 and can be implemented using wire or cable, fiber optics, a phone line, a cellular phone link, an RF link and other communications channels.
  • computer program medium and “computer usable medium” are used to generally refer to media such as removable storage device 4212, a hard disk installed in hard disk drive 4210, and signals 4226.
  • Computer programs are stored in main memory and/or secondary memory 4208. Computer programs can also be received via communications interface 4224. Such computer programs, when executed, enable the computer system 4201 to perform the features of the present invention as discussed herein. In particular, the computer programs, when executed, enable the processor 4204 to perform the features of the present invention. Accordingly, such computer programs represent controllers of the computer system 4201.
  • the software may be stored in a computer program product and loaded into computer system 4201 using removable storage drive 4212, hard drive 4210 or communications interface 4224.
  • the control logic when executed by the processor 4204, causes the processor 4204 to perform the functions of the invention as described herein.
  • the invention is implemented primarily in hardware using, for example, hardware components such as application-specific integrated circuits (ASICs).
  • ASICs application-specific integrated circuits
  • the invention is implemented using a combination of both hardware and software. While various embodiments of the present invention have been described above, it should be understood that they have been presented by way of example only, and not limitation. Thus, the breadth and scope of the present invention should not be limited by any of the above-described exemplary embodiments, but should be defined only in accordance with the following claims and their equivalents.

Abstract

System, Method and Computer Program Product for automating the collection, management and analysis of data. Research is performed according to a methodology based on four phases: Requirements; Collection; Analysis; and Reporting. During the Requirements phase, users records objectives for the research project and items of interest in a Personal Dictionary. The items of interest are organized according to user defined or pre-defined categories. Data entered by the user during the Requirements phase is also used to automatically conduct database searches to compile information for the research project. During the Collection phase relevant data items are filtered and stored in a repository. Data files are automatically searched for items of interest from the Personal Dictionary. Automation tools are provided so users can quickly and efficiently determine the relevancy of documents based on the defined items of interest. Interactive visual displays are provided that model the contents of documents according to items of interest, so that the users can efficiently and quickly scan large volumes of information to determine their relevancy. During the Analysis phase data is analyzed, compared, related, visualized, and understood in terms of the items of interest. Relationships between data items are recorded and automatically maintained. Knowledge is added to the data items in terms of written comments and relationships between items. Relationship diagrams are provided that graphically depict relationships between any two items of interest. The relationship diagrams display relationships according to degrees of separation. Users are instantly presented with direct and distant relationships between items of interest. During the Dissemination phase users create reports that are automatically sent to other users. Documents and other data files are bookmarked during the Analysis phase so that they are instantly retrievable during the Dissemination phase and included in the final report.

Description

System Method and Computer Program Product to Automate the Management and Analysis of Heterogeneous
Data
Background of the Invention
Field of the Invention
The present invention relates generally to data analysis, and specifically to a system, method and computer program product for automating the collection and analysis of data. More specifically, the present invention provides an automated tool for defining research requirements, collecting, managing and analyzing data, building relationships between data items, and for generating reports based on data from a variety of sources.
Related Art
We live in an era of data overload where information continues to grow at an ever-spiraling rate. This presents a real challenge in doing effective research and analysis of data. Data analysts quickly become overwhelmed by the glut of raw data and consequently often miss securing critical information.
Currently, there are relatively few tools to assist the analyst in managing this information overload. Typically, these tools consist of stand-alone or independent tools that have been designed to serve a single purpose. Examples of such tools are: word processors; spreadsheets; search engines and browsers; database management systems; and data visualization systems.
A major problem with these stand-alone tools is that the analyst is forced to manually manipulate the data between the use of each tool. Additionally, using the conventional method, the analyst is required to have a thorough understanding of Boolean logic and a database query language, such as Standard Query Language (SQL), to gain access to the stored data. It has been estimated that using these conventional methods, analysts can spend up to ninety percent of their time searching, collecting, and organizing information. This leaves a mere five to ten percent of an analyst's time for performing actual analysis of data.
Accordingly, what is needed is an automated system and method for defining, collecting, organizing and analyzing data.
Summary of the Invention
Accordingly, the present invention provides a complete end-to-end data management and analysis tool based on four phases of the intelligence process used to perform research on data. The present invention increases research efficiency by providing automated data analysis that allows analysts to spend more time on data analysis and less time on data management.
The present invention accomplishes this by providing a single environment where users can perform knowledge management and knowledge production of data. The knowledge management feature of the present invention allows users to quickly and efficiently cull through large quantities of data, so that items that are of interest, quickly and efficiently emerge to the surface. Once the items of interest are determined, only those data items associated with the items of interest are saved in a repository. These items are saved in the repository along with related tags so that users can leverage off their associative style of thinking and work more efficiently at retrieving data. The knowledge production features of the present invention allow users not only to extract patterns from the data but also to visualize the data so that new patterns and relationships can easily be recorded.
Specifically, the present invention provides a unique set of automation tools to assist the user in conducting research. This is accomplished using a methodology based on four phases for conducting research, namely, the
Requirements phase, the Collection phase, the Analysis phase and the Reporting phase. The Requirements phase is where the user records the objectives for the research project. The requirements may be referred to by the user at any time during the remaining research phases to serve as a focal point for the collection and interpretation of data. In addition, the requirements entered by the user can be used to automatically perform database searches to compile data for the research project.
During the Requirements phase, users define items of interest in a Personal Dictionary. The items of interest are organized by user-defined or predefined categories.
The Collection phase is used to filter out relevant data items from irrelevant data. The relevant data is stored in a repository. The present invention provides the user with a set of automation tools to assist in the collection process. Specifically, the present invention automatically searches for the items of interest and associated aliases stored in the Personal Dictionary. In addition, automation tools are provided that allow the user to quickly and efficiently determine the relevancy of documents based on the occurrences of the items of interest. This is accomplished in part, by providing the user with interactive visualization displays that model document contents according to the defined items of interest.
Accordingly, the present invention provides an efficient means for quickly scanning large volumes of information to determine their relevancy with respect to the current research project. The items that are determined to be relevant are automatically saved into a repository associated with the research project. These items are tagged with descriptive user created pointers to facilitate future retrieval of those items.
The Analysis phase is where the collected information from the Collection phase is analyzed, compared, related, and understood in terms of the items of interest from the Personal Dictionary. During the Analysis phase, the analyst reviews the collected items and extracts patterns and relationships. Relationships between data items are recorded and automatically maintained by the present invention. In addition, knowledge is added to any item or relationship between items by written comments that are automatically associated with the corresponding data items and maintained by the present invention.
During the Analysis phase, the present invention provides the user with relationship diagrams that graphically depict the relationships between any two items of interest. These relationship diagrams are selectable by the user in terms of their "degree of separation". That is, the present invention provides a mechanism that allows users to display direct relationships between two items of interest, as well as indirect, distant relationships. In this fashion, users are instantly presented with distant relationships between items of interest that may never have been known to exist.
The Dissemination or Reporting phase is used to assist the analyst in creating reports of a research project. Specifically, summaries and conclusions are captured to be included in the finished reports. Documents are "bookmarked" during the Analysis phase so that they are can be instantly retrieved and included in the final report(s). During the Reporting phase, analysts document their analyses, conclusions and recommendations.
Brief Description of the Figures
The present invention is described with reference to the accompanying drawings, wherein:
FIG. 1 depicts an overview of the analysis process, according to a preferred embodiment of the present invention;
FIG. 2 is a flowchart depicting the overall process that can be used to manage and analyze data, according to a preferred embodiment of the present invention; FIGs. 3-35 are representations of display screens, windows and dialog boxes that can be used in to implement a preferred embodiment of the present invention;
FIG. 36 is a block diagram depicting database tables that can be used in a preferred embodiment of the present invention;
FIG. 37 is a chart that is useful for describing a method that can be used for searching the database and finding relationships between any two items of interest, according to a preferred embodiment of the present invention;
FIGs. 38-41 are flowcharts depicting methods that can be used to implement various features, according to a preferred embodiment of the present invention; and
FIG. 42 is a block diagram of a computer useful for implementing components of the present invention.
Detailed Description of the Preferred Embodiments
The present invention is directed toward an automated system and method for defining research requirements, collecting data, analyzing data, visulizing data, building relationships between data items, and generating reports based on data from a variety of sources.
The present invention can be implemented in software on a general purpose computer system. An example of a general purpose computer system is presented and described below with reference to FIG. 42. In a preferred embodiment, the present invention runs on an operating system with a graphical user interface, such as Windows 95®, Windows 98® or Windows NT® manufactured by Microsoft Corporation®. The example embodiment of the present invention is preferably implemented using a high level language, such as
Visual Basic®, manufactured by Microsoft Corporation. Visual Basic is especially useful to implement the present invention due to its built-in database management capabilities, that are useful for implementing the database management features of the present invention.
Note that the programming language, the operating system and the database management system used to implement a preferred embodiment of the present invention, are listed herein for exemplary purposes only. In other embodiments, different operating systems can be used to implement the present invention. Such operating systems include, but are not limited to, various flavors of the UNIX operating system, Macintosh operating systems, Lynx, OS/2, MVS, VM/CMS and the like.
Similarly, other high level languages may be used in various embodiments of the present invention. Such languages include, but are not limited to, C, C++, Java, COBOL, Pascal and the like. In addition, other database management systems, such as Oracle, Sybase, Access, Progress and the like, can be used to implement the database management features in alternate embodiments of the present invention. Accordingly, the example used herein should not be construed to limit the scope and breadth of the present invention.
FIG. 1 depicts an overview of the analysis process, according to a preferred embodiment of the present invention. This methodology is based on a standard approach for conducting research, namely, collecting, analyzing, and reporting information. Specifically, the analysis process of the present invention comprises four phases referred to herein as; the Requirements phase 102; the Collection phase 104; the Analysis phaselOό; and the Dissemination phase 108.
The Requirements phase 102 is used to capture and document initial questions to be answered, or issues to be followed, during a particular research project. The Requirements phase 102 documents requirements that are the focal point for the collection and the interpretation of information. For example, as shown in FIG. 1, the Requirements phase 102 accepts requirements from a user (also referred to herein as "analyst" and/or "researcher"), such as strategic company goals and specific manager requests. These requirements allow the analyst to focus during the Collection phase 104 and to determine how events are interpreted during the Analysis phase 106. As described below, the Requirements phase 102 can also be used to define requirements for an automated search provided by an embodiment of the present invention.
The Collection phase 104 directs the searching of internal and external data sources and filters them to extract relevant information therefrom, according to the recorded requirements entered during the Requirements phase 102. Once information is retrieved, the analyst typically reviews the collected information to ensure that the retrieved items contain relevant pieces of information.
The retrieved items that are determined to be relevant, are automatically saved into a repository associated with the research project. The items that are saved in the repository are tagged with descriptive user created pointers to facilitate future retrieval of those items.
As shown by the example in FIG. 1 , the Collection phase 104 processes text and other files from a variety of sources. These sources include the Internet, other databases, scanners, word processors, news services, research services and the like. The files used with the present invention can be in any format including text, audio, video, and graphic file formats.
It should be noted that according to one embodiment of the present invention, the text and other files are manually compiled by the user and stored on their computer system. Typically this is accomplished using one or more external tools such as scanners, word processors, Internet browsers, Internet search engines and the like. After these files are compiled and stored on the user's computer system, the present invention filters them during the Collection phase 104, by separating relevant data from irrelevant data.
In another embodiment, the present invention provides a means to compile data for the user based on the requirements entered during the Requirements phase 102. Once the requirements are entered, typically in a natural language format, the present invention communicates with one or more external or internal data sources, such as the Internet, database files, files in the users directories, etc. Once these results are compiled they are used in the Collection phase 102 and filtered for relevant data items, as described above.
The Analysis phase 106 is where the collected information from the Collection phase 104 is analyzed, compared, related, visualized, and understood in terms of the requirements entered during the Requirements phase 102. During the Analysis phase 106, the analyst typically reviews the collected items and extracts patterns and relationships therefrom. In this fashion, the analyst creates meaning to the data items as they relate back to the requirements entered during the Requirements phase 102. Relationships between data items are recorded for later analysis and/or insertion into a final report.
As indicated by FIG. 1 , users can also add knowledge to any data item by adding written comments. These comments are automatically associated with the corresponding data items and are automatically maintained by the present invention.
The Dissemination or Reporting phase 108 is used to assist the analyst in creating reports of a research project. Specifically, summaries and conclusions are captured to be included in the finished reports. During the Reporting phase 108, analysts document their analyses, conclusions, and recommendations.
FIG. 2 is a flowchart depicting the overall process that can be used to define requirements, collect, manage and analyze data, according to a preferred embodiment of the present invention. The process begins with step 202, where a user creates a requirement set that defines the basis for the research being conducted. Next, in step 204, requirements are added to the requirement set created in step 204. This step continues until all of the requirements have been added into the requirement set.
Next, as step 206 indicates, the collection and filtering of data are performed. As described below, the present invention provides several valuable tools that assist the user during the Collection phase 104 so that large quantities of data can be quickly and efficiently compiled, viewed and filtered according to the user specified requirements from steps 202 and 204.
Next, as step 208 indicates, data analysis is performed. As described below, the present invention provides several valuable tools to assist the user in finding relationships between data items so that the Analysis phase 106 is performed efficiently.
Finally, the process ends with step 210, where the user writes and disseminates reports. Again, the present invention provides the user with valuable tools that assist the user in quickly and efficiently retrieving the relevant information to include in a report, without having to re-read all of the collected data items.
Each of these activities is described in detail below. FIGs. 3-35 are representations of display screens, windows and dialog boxes that can be used in a preferred embodiment of the present invention. These representations are used for exemplary purposes only to describe the features and functions of the present invention, which can be implemented in a variety of ways that are different from examples presented herein. As such, these examples should not be construed to limit the scope and breadth of the present invention. Furthermore, programming code to implement the features and functions described herein with reference to FIGs. 3-35 would be apparent to persons skilled in the relevant art(s), after reading the present disclosure.
Creating a Requirement Set
Referring now to FIG. 3 , a requirement set is created by the user. This can be accomplished by selecting the File/New option 304 from the menu bar 302. When this occurs, a new requirement set dialog box is presented, as shown by
FIG. 4. Next, the user enters a name for the new requirement set, such as
"Coffee" 402.
Following the naming of the new requirement 402, the user is given the opportunity to select the requirement set template, as shown in FIG. 5. In this example, the requirement set template is named "default.wtp" 502. This a default template that preferably contains default or pre-defined categories that can be used by the user. Examples of such default categories include: People; Places; Organizations; Products; and Events.
At this point, the present invention creates a database structure (described below) for the requirement set. When this is completed, the requirement set interface is presented to the user, as shown in FIG. 6.
Accordingly, using the requirement set interface 600, users can add 602, edit 604 and delete 606 one or more requirements, such as the requirements 610. In addition, by clicking on the Print List push-button 608, users can print the entire list of requirements.
Adding Requirements
Once a requirement set has been created, requirements can be added to the requirement set 610. Preferably, this is accomplished by selecting the requirement set 610 and then clicking the Add push button 602. This action causes the computer to display a new requirements dialog box 700, as shown in FIG. 7. This dialog box 700 is used to accept from the user, information about the requirement.
For example the user can give the requirement a name 702. In addition the user can specify the requestor, set status and priority, and record the owner of the requirement. These options are typically available through the details tab 704. Additionally the user can record any thoughts, ideas, or comments using the comments tab 706. Note that the requirement 702 is listed in the requirement set interface 600 at 612.
Preferably, requirements can also have sub-requirements. These can be created by selecting the desired parent requirement, such as 612, and then clicking the Add button 602. Note that information pertaining to requirements can preferably be modified at any time by selecting the requirement 610 and by clicking on the Edit button 602. Collection & Filtering of Data
After the requirements have been recorded, using the above method, the user can begin collecting information pertaining to the requirement 610. As stated above, one embodiment of the present invention assists the user in data compilation. In this embodiment, the requirement data entered by the user during the Requirements phase 102, is used to initiate a search on one or more external data sources, such as the Internet, database files, or files in the users directories. The interface provided by the present invention preferably allows the user a enter plain text description of the requirement, for example, in the details 704 section of the requirements dialog box 700. The present invention then extracts the concepts from the plain text description and initiates a search based on those concepts.
Preferably, data items that match the concepts from the requirements are presented back to the user. At this point the user typically reviews the returned items, keeping only the relevant ones, and discarding the others. In addition, the user can select portions of a single item (or multiple items), and request a new search based on the newly selected items. In essence, the user asks the present invention to find additional items that are similar to the selected items (i.e. the user asks the system to "show more items like this"). In this fashion, the user is presented with highly relevant information in a quick and efficient manner. After all data has been compiled, the saved data items are used in the Collection phase 102, where they are filtered according to their relevancy.
In another embodiment of the present invention, the user uses external tools such as Internet search engines, browsers, word processors, scanners, and the like to compile data that is to be used as a basis for the research project. Of course, this form of data compilation can be combined with the automated form of data compilation provided by the present invention, as described above.
In any case, once the data is compiled and stored on the user's computer system, using one or both techniques described above, the Collection phase 104 continues with a two-step process. First the user selects the files for review. Once the files have been selected, the user manually reviews the files, with the assistance of the provided tools (described below), and saves the files that have been determined to be relevant. In a preferred embodiment, the files are saved in a repository associated with the research project..
As stated, a preferred embodiment of the present invention accepts information from any data source in any format. This includes text, graphics, audio, video, etc. Such file types include, but are not limited to, ASCII, various word processing data files, HTML, VRML, JPEG, MPEG, WAV, MID, BMP, TIF and the like.
Referring now to FIG. 8, a collection window 804 provides an interface to the folders that contain information stored on the users computer system. As stated, these files have been compiled by the user either manually, or with the searching capabilities of the present invention. In this example, a directory window 804, and a files window 802, allow the user to traverse the storage device to find data items that are to be reviewed for the current research project.
These windows 802 and 804 preferably contain standard drive and folder navigation objects. In addition the present invention preferably provides shortcut buttons that the user can select to take them directly to a predefined folder. These predefined folders are defined using the View/Preference option (see 806) from the main menu bar 302. This action displays the Preference window 900 as shown in FIG. 9. In this example, the user selects the folders tab 902 and specifies a default directory for the repository 904 and download directories 906. The repository directory is used to store the data collected during the Collection phase 104, that is determined to be relevant to the current research project, based on the recorded requirements. The download directory or directories 906 is where the compiled data is stored.
Referring now to FIG. 10, users can navigate through the folders and files
(using the windows 804 and 802, respectively) to select one or more files for review. Files can be selected in the files window 802. For example, one file 1002 is depicted as being selected. One or more selected files can be moved to the review list 1004 by clicking the Add button 1006. Alternatively, users can also preferably accomplish this task simply by dragging a selected file, such as 1002 from the files window 802, and dropping it onto the review list 1004. Files can also be removed from the review list by clicking the Remove All button 1008.
In a preferred embodiment, files in the review list 1004 are reviewed by clicking on the review tab 1008. When this occurs a review screen is displayed. An example of a review screen is shown in FIG. 11. From the review screen 1100, the user can review the full text of any file listed in the review list 1004. The full text is displayed in the text window 1102. The name of the current file being viewed is shown in the field 1106. To view another file, the scroll button
1104 is used.
Thus, the user can read the displayed text in the text window 1102, to determine if it contains any items of interest pertaining to the research project. However, if the user has multiple documents to review, this method can be very tedious and time-consuming. For example, if a user is required to view hundreds of documents on a daily basis, it may be not be possible to actually read all of the documents in this fashion.
Accordingly, the present invention provides an efficient means for quickly scanning large volumes of information to determine their relevancy with respect to the current research project. Specifically, the present invention provides an automated means to determine whether or not, one or more "items of interest" are contained therein. Items of interest are defined by the user in a Personal Dictionary, according to a preferred embodiment of the present invention.
FIG. 12 depicts a display screen that can be used to specify items of interest for a Personal Dictionary according to preferred embodiment of the present invention. In this example, the display windows 1202, 1204 and 1206 are empty because data for the Personal Dictionary has not yet been specified by a user. Accordingly, the Structure window 1202 is used to display the structure of the Personal Dictionary. The Structure is typically comprised of one or more categories, followed by one or more items of interest that falls within each category.
The Category window 1204 is used to display the category of the currently selected item of interest. Categories are defined by users. Alternatively, users can make use of pre-defined categories provided by the present invention. Examples of such predefined categories include: People; Places; Organizations; Products; and Events. This window 1204 can be pulled down to display a list of all categories defined. The name window 1206 is used to display the name of the currently selected Personal Dictionary. Finally, the aliases window is used to display the aliases defined for the currently selected item of interest.
Thus, the Personal Dictionary allows the user to record, by category, the names of those items that they are interested in tracking. The item names are used to define a criteria for scanning the files. That is, the files are searched for the occurrences of the defined items of interest in the Personal Dictionary.
In addition, the user can record one or more aliases 1208 for each item of interest. The aliases are recognized in the text files and are treated as being equivalent to the associated item of interest by the present invention. For example, "District of Columbia" may be a defined alias for "Washington D.C."
Accordingly, if both terms are found in a single document, for example, the present invention reports that two occurrences of the defined item of interest "Washington D.C." are contained in the document. In this fashion, items of interest are recognized in the documents even though they are not referred to by their formal title.
Preferably, Personal Dictionaries can be shared through the import and export feature of the present invention (see 1210 and 1212). Items can be entered into the Personal Dictionary directly from the Personal Dictionary screen 1200, by manually selecting a category in 1204, entering a name in 1206, and providing any aliases in 1208. In addition, the present invention provides a convenient way to add items of interest to the Personal Dictionary while reviewing text in the text window 1102. This is accomplished by highlighting any word in the text window 1102 and clicking the Add button 1108 (see FIG. 11). When this occurs the user is presented with add item window shown in FIG. 13 , so that the user can add a new category or select a category from the Category pull-down 1304. The name of the newly added item of interest is automatically displayed in the Name field 1302, where it can be edited if necessary.
FIG. 14 shows a display of a Personal Dictionary. In this example, four categories have been defined, namely: Organization 1412; Person 1414; Place
1418; and Product 1420. Note that the Category window 1406, the Name window 1408 and the Aliases window 1410 are each associated with the particular item of interest that is highlighted (i.e. selected) in the Structure window 1202. In this example the item of interest named "CAPTAIN COOK" 1404 is selected.
Once a Personal Dictionary has been created, the user can now request that the present invention automatically review the document. This is accomplished by scanning the content of text document for the occurrence(s) of items of interest and/or associated aliases.
Referring now to FIG. 15, a review screen, similar to that presented in
FIG. 11 is depicted. In this example the user directs the present invention to automatically scan the document being reviewed in the text window 1102 by pressing the Scan button 1502. In response to this request, the present invention scans the document for all items and their respective aliases, as defined in the Personal Dictionary 1400. The results of the scan is presented in the display window 1504. That is, the display window 1504 displays a list of each item of interest found in the document. Further, in a preferred embodiment, when users select an item of interest in the display window 1504, the corresponding words are highlighted in the text window 1102. After a document has been scanned in this fashion, and items of interest have been found, the document is typically deemed to be relevant by the user, and is manually saved in a repository associated with the current research project. This is accomplished by clicking this Save button 1506. Next, as shown by FIG. 16, the user enters a title for the research item in 1602. At this point, the present invention saves the document and the associated items of interest found therein 1504, as an associated link. This is accomplished by maintaining the associations in a database table. An example of database tables that can be used to implement the present invention is described below.
Analysis
The analysis task typically begins with the user reviewing the research documents that have been deemed relevant and saved into the repository as described above. These documents are preferably analyzed from the Analysis/Browse window 1700, shown in FIG. 17. In this example, a document 1706 is listed under the "RESEARCH" category 1708. To begin analysis of the document 1706, the user selects the desired document 1706 and drags it into the right hand display area 1704.
When this occurs, the present invention displays a visual representation 1710 depicting information about the contents of the document 1706, to assist the user in analysis. Specifically, the visual representation 1710 provides the researcher with a means to instantly comprehend the relevancy of the document 1706. This is accomplished by displaying which categories of items of interest are contained within the document 1706. In addition, the visual representation 1710 displays the number of occurrences of items of interest within each category.
In this example, the visual representation 1710 comprises a document icon 1712, representing the document 1706 being analyzed. The document icon 1712 is surrounded by four category icons 1714-1720, each representing a particular category of items of interest found within the document 1706. In this example, the categories are: Organization 1714; Person 1716; Place 1718; and Product 1720.
The number of items of interest contained in the document 1706, that are within each category is displayed on the connecting line between the document icon 1710 and the corresponding category icon 1714-1720. Accordingly, in this example, the researcher instantly comprehends that the document 1706 contains: one item of interest in the Organization category 1714 ; one item of interest in the Person category 1716; two items of interest in the Place category 1718; and three items of interest in the Product category 1720.
Thus, the visual representation 1710 provided by the present invention is a quick and efficient means to rank the relevancy of the document 1706, without having to read a single word in the document.
Note that the particular items of interest within each category are not depicted in the visual representation 1710. However, the present invention provides a means for the user to instantly review the particular items of interest associated with any of the categories 1714-1720, by interacting directly with the visual representation 1710. This is accomplished by dragging any of the category icons 1714-1720 from the display window 1704, to the item list area 1710.
This feature of the present invention is depicted in FIG. 18. In particular, FIG. 18 shows the results of a user dragging the "PRODUCT" icon 1720 into the list item area 1702. Note that in a preferred embodiment, the background color of the item list area 1702 is changed to indicate that relationship data is now being viewed.
Thus, in this example, the list item area 1702 now displays the particular items of interest in the "PRODUCT" category found within the document 1702.
In particular, the items of interest found contained in the document are"COFFEE"
1806," MACADAMIA" 1808 and "TEA" 1810. Note that the title of the document 1802 is also displayed in the display area 1704. Further, items from the item list area 1702 can now be dragged back into the display area 1704. In this fashion, users can obtain additional visual information about the in a quick and efficient manner by interacting directly with the visual displays.
Thus, the present invention provides a means for users to navigate the entire repository and gain valuable knowledge about the relevancy of documents and the relationships between documents and items of interest, in an extremely fast and efficient manner. Note that this is accomplished without requiring the user to read a single document. In addition, this is accomplished without requiring the user to know anything about database management, SQL queries or the like. In this fashion, users can concentrate on the data being analyzed and not waste time being distracted by traditional data management techniques, such as database queries and the like.
For example, FIG. 19 shows the results of a user dragging the "COFFEE" 1806 item of interest into the display area 1704. When this is performed, the display area 1704 now shows the items related to "COFFEE" 1902. In this example, the item of interest "COFFEE" is represented by the icon 1904. The related items "RESEARCH" is represented by the icon 1906.
Note that in a preferred embodiment, detailed information about any item can be obtained at any time by double clicking on the icon representing the item, such as item 1904. This can also be accomplished by selecting the item 1806 in the item list area 1702 and selecting the View/Profile option 1906 from the menu bar 302. When this occurs, a dialog box, such as the one depicted in FIG. 20 is displayed. From the dialog box in FIG. 20, the user can view information for that item and if desired, modify that information.
The focus of the Analysis phase 106 is to provide the user with advanced data analysis tools that allow the user to obtain new and unique information about the data being analyzed by the various views of the data provided herein. In this fashion, users can easily record patterns and relationships found during the analysis process. Relationship links are preferably created when an item is dragged from the item list area 1702 and dropped on the central item in the display area 1704.
This action causes a Relationship window 2100 to be displayed, as shown in FIG. 21 This relationship window 2100 allows the user to record information about the relationship. In this example the relationship between "COFFEE" 2108 and "CAPTAIN COOK" 2110 is created. In the Relationship window 2100, the strength of the relationship 2102 and the type of relationship 2104 is recorded. In this example, the user entered the keyword "DISCOVERED" 1204 to describe the relationship between "COFFEE" and "CAPTAIN COOK". Further the word "fact" is used to describe the strength of this relationship, which for example, conveys a much stronger relationship then "speculation". In addition, any comments about the relationship can be recorded in window 2106.
Once the relationship information is recorded in this fashion, the new relationship is displayed in the Analysis/Browse display area 1704, as shown in FIG. 22. If the relationship is associated with an item of interest from a category in which no relations were previously formed, that new category icon is displayed in the display area 1704. If there were already existing relationships between the category and the item of interest, then the count of the related items are updated. In the example shown in FIG. 22, a new relationship category, namely PRODUCT 2204 is shown as being related with the "CAPTAIN COOK" item of interest, represented by the icon 2202.
By creating a relationship between any two items, a direct relationship is created. However, after populating the repository with these direct relationships, hidden relationships begin to form. That is, more distant relationships that may not be apparent to the analyst are formed. The present invention provides the user with a means to instantly display all of the relationships that exist between items of interest.
For example, assuming a relationship is created by a user between item
A and item B. Further, assume that previously, the user established relationships between items C and D, and between items B and C. Accordingly, there is now a hidden relationship, which was not explicitly formed by the user. The hidden relationships are between A and C, A and D, and B and D.
The present invention provides a mechanism that allows users to display direct and/or distant relationships between any two items of interest. In response to a user request, the system and method of the present invention displays a relationship diagram that graphically depicts the relationship between two items of interest and any relationships in-between such items. In this fashion, users are instantly presented with distant relationships that may never have been known to exist.
Referring nowto FIG.23, the Analysis/Connections window is displayed.
Users can request that a relationship diagram be displayed by dragging any two items of interest from the Item List 2302 into the Relationship Between list 2304. When the FIND button 2306 is pressed, a relationship diagram is displayed.
An example of a series of relationship diagrams, according to a preferred embodiment of the present invention is presented in FIG. 24. Relationship diagram 2402 depicts the relationship between two items of interest, namely: "RAINBOW PLANTATION" and "TEA." In this example, a direct relationship exists. This is referred to a relationship with a degree of separation of zero. The degree of separation is displayed in window 2403. The user can display more distant relationships by adjusting the degree of separation. This is accomplished by clicking the arrow 2401 to increase or decrease the degree of separation.
For example, by clicking on the up arrow 2401, the relationship diagram 2410 is displayed. In the relationship diagram 2410, relationships between RAINBOW 2404 and TEA 2406 with one (or less) degree of separation 2407 are depicted. Specifically, it can be seen that RAINBOW 2404 is related to COFFEE
2408 (because coffee grows at the Rainbow Plantation), and that COFFEE 2408 is related to TEA 2406. Thus, RAINBOW 2404 is not only directly related to TEA 2406, (as shown by the relationship 2405), but is also indirectly related to TEA 2406, through its relationship with COFFEE 2408. The relationship diagram 2416 is the result of the user increasing the degrees of separation 2413 to two. Thus, in this example, the relationship between RAINBOW 2404 and TEA 2406 with two (or less) degrees of separation 2413 are depicted. In this example, a new relationship is discovered. That is, RAINBOW 2404 is related to TEA 2406, through CAPTAIN COOK 2412 and
COFFEE 2414.
The relationship diagram 2418 is the result of the user increasing the degrees of separation 2424 to three. Thus, in this example, the relationship between RAINBOW 2404 and TEA 2406 with three (or less) degrees of separation 2424 are depicted. Several new relationships are depicted.
Specifically, it is now known that RAINBOW 2404 is related to TEA 2406, through KEALAKEKUA BAY 2420, CAPTAIN COOK 2421 and COFFEE 2422. More distant relationships are displayed (if they exist), by clicking the arrow 2401 to increase the degree of separation
Thus, the present invention provides a means for presenting the relationships between any two items of interest in a fast and efficient manner. Relationships that are difficult to discover, quickly emerge to the surface using the techniques provided by the present invention. The present invention accomplishes this task by performing an exhaustive search of the repository to display all of the paths between any two items of interest. A method that can be used to implement this artificial intelligence aspect of the present invention is described below.
Reports
The Dissemination phase 108 typically begins in one of two ways. The first way begins when the analysis is complete However, for lengthy research projects, this may not be the most efficient means.
The second and preferred method for creating reports is to establish a report shell at the beginning of the Analysis Phase 106. In this fashion, items are identified and bookmarked for inclusion in the final report as they are discovered during the Analysis phase 106.
The present invention provides this capability by allowing the user to create a report during the Analysis Phase 106. This is preferably accomplished by defining a title for the report using a dialog box such as the one shown in FIG.
25. Once this is accomplished, a title screen is displayed in the Reports/Create window, as shown in FIG. 26. Note that once a report is defined in this manner, the name of the report 2702 is shown on the Analysis/Browse window as shown in FIG. 27. In addition, a bookmarking icon 2704 is displayed. Thus, when the analysts identifies an item that they would like to have included in a report, they simply drag the selected item to the bookmarking icon 2702.
Referring now to FIG.28, items that have been bookmarked are displayed on the Report/Create window 2600 in the Marked List 2802. These items can be used in several ways. First, if one or more items are dragged into the report area 2804, the present invention types the name of the item. For example, FIG. 29 shows the result of a user dragging the item 2904 into the report area 2804. Specifically, the name of the item 2902 is displayed in the report area 2804.
Preferably, by double-clicking on a research item, such as 2904, the original text is displayed in a text window, as shown by FIG. 30. The display in FIG. 30 allows the user to search the text for items in the Personal Dictionary or on any other string. As indicated by FIG. 30, this is accomplished by using the Find What entry box 3002 and the Find button 3004. Text from this display can also be copied and pasted directly into the report using the copy button 3006. The results of copying a section from the text window in FIG. 30, to the report window 2902, is shown in FIG. 31.
In this example embodiment, if the user double-clicks an item that is not a research item, such as CAPTAIN COOK (see 3102 in FIG. 31), comments associated with that item 3102 is displayed, as shown in FIG. 32. Typically, after a report is created, the analyst needs to deliver it to a decision-maker. The present invention provides tools that assist the user in formatting the report and delivering it to another user. For example, the user can select a report type that is to be used to generate the report. The report type is provided by a report template, which defines a format for the report. A typical implementation of the present invention provides many template reports that can be selected by the user. After the report type has been selected, the user selects a method in which to deliver the report. Typically, the analyst can print the report, send it via E-Mail, or save it to disk in a variety of formats. The screen in FIG. 33 shows a typical Report/Deliver screen that can be used to implement this feature of the present invention.
General Features
The present invention preferably provides several ways to customize and maintain the system. For example, a Category Manager is provided that allows the user to modify the requirement set structure. An example of a Category
Manager window is shown in FIG. 34. This allows the user to add 3404 or delete 3406 any of the categories 3412. In addition, the user can add 3408 or delete 3410, any fields 3402 associated with the categories 3412.
Another feature of the present invention allows the user to determine what has changed in the repository from a given date. This feature is described with reference to the "What's New" screen shown if FIG. 35. In this example, the user enters a date at 3502. Once the find button 3504 is depressed, new items that were added since the date entered in 3692 are displayed in the New Items list area 3506.
Database Tables
FIG. 36 depicts database tables that can be used to implement the present invention. The Relation table 3602 is used to store relationships that are established between items of interest. Specifically, one entry is associated with each relationship between two items of interest. The Requirements table 3604 is used to store the requirements entered during the Requirements Phase 102.
The Report table 3608 is used to store information pertaining to the Dissemination Phase 108. The research table 3606 is used to store information pertaining to the data items saved in the repository during the Collection Phase 104. The user defined category tables 3610 are used to store information about each category defined by the user. Note that in a typical implementation, users can define their own categories or use pre-defined categories provided by a preferred embodiment of the present invention.
The dictionary table 3612 is used to store information pertaining to the Personal Dictionary. The Category table 3612 is used to store a list of valid categories defined for the current research project.
A list of fields that can be used to implement the database tables shown in FIG. 36 is presented in table 1 below. Note that the names of the fields listed below are generally descriptive of the type of information stored therein, according to a preferred embodiment of the present invention. Based on the description provided herein and the names of the fields below, the use of these fields should be apparent to persons skilled in the relevant art(s). As such, a detailed description of each of these fields is not provided herein. In addition, the fields in table 1 and the associated data tables shown in FIG. 37, represent one example of a means to implement the database management features of the present invention. Many other variations are possible and would be apparent to persons skilled in the relevant art(s).
Table 1. Database Tables and Fields.
Figure imgf000026_0001
Figure imgf000027_0001
Figure imgf000028_0001
Method for Searching the Database to find All Relationships Between Two Items of Interest
FIG. 37 is a chart that is useful for describing a method that can be used for searching the database and finding the paths between any two items of interest. This method can be used to implement the relationship diagrams shown in FIG. 24. It should be noted that an algorithm used to implement this feature of the present invention is preferably accomplished using a deterministic programming environment that employs automatic backtracking on failure of a pre-condition.
This method is preferably performed in response to user action. Specifically, this method is performed in response to a user selecting two items in which the present invention is directed to find the paths between. This can be accomplished, for example, with the screen presented in FIG. 23. Once the two items of interest have been selected, the present invention extracts all of the records in the Relation database table 3602 and writes the information into a flat text file. The flat text file is then read into an internal database structure that is specific to the deterministic programming environment. This table can be viewed as shown in FIG. 37.
Accordingly, beginning with one of the two selected items (i.e., in this example, RAINBOW PLANTATION 3702), the method selects a related record, for example, COFFEE 3704. This relationship is compared to the second selected item, TEA 2706 and found not to match. The method then selects a related record to COFFEE 3704. In this example, the related record is TEA 3706.
Thus, the related record is compared with TEA, which results in a match. Accordingly, the path "RAINBOW PLANTATION 3702 - COFFEE 3704 - TEA 3706" is written to a text file.
Next, the method attempts to select another record related to COFFEE. In this example, there are no other items related to COFFEE 3704, and thus the method fails.
Accordingly, having exhausted the relationships for COFFEE 3704, the method selects the next related record for RAINBOW PLANTATION 3703. In this example, the next related record for RAINBOW PLANTATION 3703 is MACADAMIA 3708. Thus, the method continues as described above, where the method compares the relationship with the second item, namely TEA. In this case, a match is not found.
Thus, the method attempts to select another related record to MACADAMIA 3708 and fails, because there are no related records to MACADAMIA 3708 in this example.
Having exhausted the relationships for MACADAMIA 3708, the method selects the next related record for RAINBOW PLANTATION 3702. In this example the next related record is CAPTAIN COOK 3710. Accordingly, this method continues until the entire relationship tree has been traversed and the found paths are written to a text file. At this point, control is passed back to the main method of the present invention.
The main method of the present invention then opens and reads the found paths file and creates a matrix of information for each path. This information is preferably retrieved from the Relation 3602 and the User Defined Category tables 3610. For each link in a path, a database query is created to read the Relation table 3614 an extract the "ISA" field information. The "ISA" field holds the relationship name between two items. For example, in FIG. 24, screen 2302, the relationship name between RAINBOW 2304 and TEA 2306 is "GROWS". This is the relationship name that is stored in the ISA field.
In the example, an SQL query that can be used to implement this function is: "SELECT ISA FROM RELATION WHERE PRI D = 17 AND PRI TABLE = 'ORGANIZATION' AND SECJD = 38 AND SEC TABLE = 'PLACE'."
Next, for each entry in the matrix, the method paints an icon representing the end nodes, writes a label for the node, paints a line connecting the nodes, and writes a label containing the ISA value. An example of this initial view for a relationship diagram 2402 is shown in FIG. 24.
Method for Implementing Interactive Data Visualization Display
A method that can be used to implement the interactive data visualization display, such as described above with reference to FIGs. 17-19, will now be described with reference to the flowchart in FIG. 38.
The flowchart in FIG. 38 depicts a process that can be used to implement the interactive data visualization display that is based on the movement of icons representing database records, according to a preferred embodiment of the present invention.
The process starts with step 3800, where control immediately passes to step 3802. Step 3802 represents a step where a user selects an item from the Item List box, such as the TROPICAL ISLAND item 1706 in FIG. 17. This is typically accomplished by placing the mouse pointer over the item 1706 and depressing the left mouse button. The selected item 1706 is highlighted to indicate that it is selected.
Next, control passes to step 3804 which represents the user dragging and dropping the item 1706 into the display area 1704. This is typically accomplished by holding the left mouse button down, and moving the pointer into a blank area in the display area 1704. The user then releases the left mouse button thereby dropping the icon onto the display area 1704.
Next, as indicated by step 3806, the process determines the category identification number for the item that is to appear in the center of the display 1712. Specifically, the process reads the text of the highlighted item from the Item List box 1702, and constructs a database query to read from the table of the selected item 1706. In this example, a database query is directed to the Research table 3606, because the selected item 1702 is a research item.
For example, an SQL query that can be used is as follows: "SELECT ID FROM RESEARCH WHERE NAME = 'A TROPICAL ISLAND'." Thus, the database query is executed and 'ID' of the selected item 1706 is returned. Typically this is then saved in a global variable, such as CENTER_ID.
Next, control passes to step 3808. In step 3808, the process retrieves the names of the related items by joining the Relation table 3602 with the User Defined Category tables 3610. Specifically, using the retrieved ID from step 3806, two additional SQL queries are constructed for each user defined category listed in the Category table 3614 to read from the Relation table 3602.
An example of such an SQL query is: "SELECT DISTINCT SECJD
FROM RELATION WHERE PRI TABLE = 'RESEARCH' AND PRI ID = ID AND SECJTABLE = 'ORGANIZATION' and SELECT DISTINCT PRI ID FROM RELATION WHERE SECJTABLE = 'RESEARCH' AND SECJD = ID AND PRI_TABLE = 'ORGANIZATION'." This query results in retrieving a count of the relationships for the selected item 1706 organized by category 1714- 1720.
Next, control passes to step 3810, where the visual representation 1710 is displayed. For each category with a count greater than 0, the icon representing the category (such as 1714-1720) is displayed, along with the count and the connecting lines.
Step 3812 represents an action by the user, wherein the user selects one of the displayed category icons (1714-1720). This is typically accomplished by pointing the mouse to the category icon and depressing the left mouse button. In this example, the Product icon 1720 is selected. Next, the user drags the icon representing the Product category, back to the Item List box 1702.
When this occurs, control passes to step 3814. In step 3814, the process retrieves the names of the related items by joining the Relation table 3602 with the User Defined Category tables 3610.
This step can be implemented as follows. Using the CENTER ID global variable as described above, and the category name, another database query is constructed. The database query is designed to retrieve all the related items from the Relation table 3607, organized in alphabetical order. For example, an SQL query that can be used in the example embodiment is as follows: "SELECT PRODUCT.NAME FROM INNER JOIN ON RELATION. SEC ID =
PRODUCT.ID WHERE RELATION.PRI TABLE = 'RESEARCH' AND RELATION.PRI ID = CENTER JD AND RELATION.SECJTABLE = 'PRODUCT' SQLQ = SQLQ UNION ALL SELECT PRODUCT.NAME FROM PRODUCT INNER JOIN RELATION ON RELATION.PRI ID = PRODUCT.ID WHERE RELATION.SEC_TABLE = 'RESEARCH' AND RELATION. SECJD
= CENTER JD AND RELATION.PRIJABLE = 'PRODUCT' ORDER BY NAME."
The list of retrieved names is then displayed in the Item List area 1706, as indicated by step 3816. As indicated by the flowchart in FIG. 38, the process can repeat itself, depending on user action.
Method for Modeling Document Contents
FIG. 39 is a flowchart depicting a process that can be used to implement a visual representation for modeling document contents, according to a preferred embodiment of the present invention. It is noted that this method is similar to the first 5 steps (3802-3810) of the method presented in FIG. 38.
The process begins with 3902. Step 3902 represents a step where a user selects an item from the Item List box, such as the TROPICAL ISLAND item
1706 in FIG. 17. This is typically accomplished by placing the mouse pointer over the item 1706 and depressing the left mouse button. The selected item 1706 is highlighted indicating that is selected.
Next, control passes to step 3904 which represents the user dragging and dropping the item 1706 into the display area 1704. This is typically accomplished by holding the left mouse button down, and moving the pointer into a blank area in the display area 1704. The user then releases the left mouse button thereby dropping the icon onto the display area 1704.
Next, as indicated by step 3906 the process determines the category identification number for the item that is to appear in the center of the display 1712. Specifically, the process reads the text of the highlighted item from the Item List box 1702 and constructs a database query to read from the table of the selected item 1706. In this example, a database query is directed to the Research table 3606, because the selected item 1702 is a research item.
For example, an SQL query that can be used is as follows: "SELECT ID FROM RESEARCH WHERE NAME = 'A TROPICAL ISLAND'." Thus, the database query is executed and 'ID' of the selected item 1706 is returned.
Typically this is then saved in a global variable, such as CENTER JD.
Next, control passes to step 3908. In step 3908, the process retrieves the names of the related items by joining the Relation table 3602 with the User defined Category tables 3610. Specifically, using the retrieved ID from step 3906, two additional SQL queries are constructed for each category in the Category table 3614 to read from the Relation table 3602. An example of such an SQL query is: "SELECT DISTINCT SECJD FROM RELATION WHERE PRI TABLE = 'RESEARCH' AND PRIJD = ID AND SECJTABLE =
'ORGANIZATION' and SELECT DISTINCT PRI ID FROM RELATION WHERE SECJTABLE = 'RESEARCH' AND SECJD = ID AND PRI TABLE = 'ORGANIZATION'." This query results in retrieving a count of the relationships for the selected item 1706 organized by category 1714-1720.
Next, control passes to step 3910, where the visual representation 1710 is displayed. For each category with a count greater than 0, the icon representing the category (such as 1714-1720) is displayed, along with the count and the connecting lines. The process then ends as indicated by FIG. 39.
Method for Extracting Items of Interest from Documents
FIG. 40 is a flowchart depicting a process that can be used for locating and identifying items of interest in documents based on a list of items of interest. The items of interest include aliases for each item as described above. The method performs a search through the document and locates and displays occurrences of the found items and any aliases.
As indicated by step 4002, this process begins with the creation of a personal dictionary, as described above. In a preferred embodiment, the dictionary allows the user to enter aliases in addition to the proper name. Next control passes to step 4004.
In step 4004, the process extracts all of the aliases from the dictionary in response to a user request. This is typically implemented by the user clicking the
SCAN button 1502 as shown in FIG. 15. The method extracts all of the aliases from the dictionary by for example, performing an SQL query as follows:
"SELECT * FROM DICTIONARY ORDER BY NAME." Next, as step 4006 indicates, for each alias (including the proper name of the item), a string search is performed in the target text. Accordingly, for each word in the extracted list from step 4004, a string match is performed. If a match is found, the alias that was found is temporarily stored in an internal variable list.
Next control passes to step 4008. In step 4008 the method displays the found matches in the item found list 1504. The process then ends as indicated by FIG. 40.
Method Marking Database Items for Inclusion into Reports
FIG. 41 is a flowchart depicting a process that can be used for marking database items used for reporting purposes. This process is launched by the user moving icons representing database items to a special marking icon, as described above.
The process begins with step 4102 where the user creates a new report shell in the Report/Create window shown in FIG. 28. This creates a record in the Reports table 3608. An example of a command that can be used to create such a record is: "ADDNEW TO REPORT WHERE NAME = 'reporjname'."
Next, as step 4104 indicates, this also causes a BOOKMARKING icon to be displayed on the Analysis/Browse window, such as 2704 in FIG. 27. Next control passes to step 4106.
Step 4106 represents a step where the user selects an item for book- marking from the Item List box, such as 2904 in FIG. 29. The selected item 2904 is highlighted indicating its selection. The user then drags the selected item 2904 into the report area 2804.
In response to this user action, step 4108 is processed. In step 4108, the process reads the text of the highlighted item 2904 for the Item List box and constructs an database query to read from the selected items' table. In this case the table in the Research table 3606. An example of an SQL query that can be used is: "SELECT ID FROM RESEARCH WHERE NAME = A TROPICAL ISLAND HIDEAWAY'." The read is executed and the selected items' ID is returned.
Next, as step 4110 indicates, the name and ID is saved in the Report table 3608. For example, using the retrieved ID from step 4108, an SQL insert query is constructed to write the item ID and the report name into the REPORT table
3608. An example of an SQL insert query that can be used to implement this step is: "ADDNEW TO REPORT WHERE NAME = 'TODAYS REPORT' AND OBJECT ='A TROPICAL ISLAND HIDEAWAY IDEAL ACCESS' AND TYPE =2."
Next, control passes to step 4112. In step 4112 the process retrieves the related item names for a report when the Report/Create window is displayed. FIG. 28 shows an example of a Marked List 2802 that is displayed as a result of this step. In response to a request by a user to view the Report/Create window shown in FIG. 28, the process creates a database query to generate the list in 2802. An example of an SQL database query that can be used to implement this step is: "SELECT DISTINCT OBJECT FROM REPORT WHERE NAME = 'TODAYS REPORT' AND TYPE = '2' ORDER BY OBJECT." This query retrieves all the related items as a result of Bookmarking, that are to be read from the Report table 3608 and displayed in the Marked list box 2802. The process then ends as indicated by FIG. 41.
The present invention may be implemented using hardware, software or a combination thereof and may be implemented in a computer system or other processing system. In fact, in one embodiment, the invention is directed toward a computer system capable of carrying out the functionality described herein. An example computer system 4201 is shown in FIG. 42. The computer system 4201 includes one or more processors, such as processor 4204. The processor 4204 is connected to a communication bus 4202. Various software embodiments are described in terms of this example computer system. After reading this description, it will become apparent to a person skilled in the relevant art how to implement the invention using other computer systems and/or computer architectures.
Computer system 4202 also includes a main memory 4206, preferably random access memory (RAM), and can also include a secondary memory 4208. The secondary memory 4208 can include, for example, a hard disk drive 4210 and/or a removable storage drive 1012, representing a floppy disk drive, a magnetic tape drive, an optical disk drive, etc. The removable storage drive 4212 reads from and/or writes to a removable storage unit 4214 in a well known manner. Removable storage unit 4214, represents a floppy disk, magnetic tape, optical disk, etc. which is read by and written to by removable storage drive 4212.
As will be appreciated, the removable storage unit 4214 includes a computer usable storage medium having stored therein computer software and/or data.
In alternative embodiments, secondary memory 4208 may include other similar means for allowing computer programs or other instructions to be loaded into computer system 4201. Such means can include, for example, a removable storage unit 4222 and an interface 4220. Examples of such can include a program cartridge and cartridge interface (such as that found in video game devices), a removable memory chip (such as an EPROM, or PROM) and associated socket, and other removable storage units 4222 and interfaces 4220 which allow software and data to be transferred from the removable storage unit 4222 to computer system 4201.
Computer system 4201 can also include a communications interface 4224. Communications interface 4224 allows software and data to be transferred between computer system 4201 and external devices. Examples of communications interface 4224 can include a modem, a network interface (such as an Ethernet card), a communications port, a PCMCIA slot and card, etc. Software and data transferred via communications interface 4224 are in the form of signals which can be electronic, electromagnetic, optical or other signals capable of being received by communications interface 4224. These signals 4226 are provided to communications interface via a channel 4228. This channel 4228 carries signals 4226 and can be implemented using wire or cable, fiber optics, a phone line, a cellular phone link, an RF link and other communications channels.
In this document, the terms "computer program medium" and "computer usable medium" are used to generally refer to media such as removable storage device 4212, a hard disk installed in hard disk drive 4210, and signals 4226.
These computer program products are means for providing software to computer system 4201.
Computer programs (also called computer control logic) are stored in main memory and/or secondary memory 4208. Computer programs can also be received via communications interface 4224. Such computer programs, when executed, enable the computer system 4201 to perform the features of the present invention as discussed herein. In particular, the computer programs, when executed, enable the processor 4204 to perform the features of the present invention. Accordingly, such computer programs represent controllers of the computer system 4201.
In an embodiment where the invention is implemented using software, the software may be stored in a computer program product and loaded into computer system 4201 using removable storage drive 4212, hard drive 4210 or communications interface 4224. The control logic (software), when executed by the processor 4204, causes the processor 4204 to perform the functions of the invention as described herein.
In another embodiment, the invention is implemented primarily in hardware using, for example, hardware components such as application-specific integrated circuits (ASICs). Implementation of the hardware state machine so as to perform the functions described herein will be apparent to persons skilled in the relevant art(s).
In yet another embodiment, the invention is implemented using a combination of both hardware and software. While various embodiments of the present invention have been described above, it should be understood that they have been presented by way of example only, and not limitation. Thus, the breadth and scope of the present invention should not be limited by any of the above-described exemplary embodiments, but should be defined only in accordance with the following claims and their equivalents.

Claims

What Is Claimed Is:
1. A system for automating collection, management and analysis of data, comprising: means for storing documents and related information; means for compiling a plurality of documents; means for displaying said documents to a user; means for creating a personal dictionary, wherein a user defines one or more categories, each comprising one or more items of interest; means for analyzing a first document, including: means for searching said first document for one or more of said items of interest, and means for saving said first document and a list of said items of interest contained therein; and means for displaying a visual representation depicting the contents of said first document, wherein said visual representation includes a document icon representing said first document, and one or more category icons each representing a category that includes at least one of said items of interest in said list.
2. The system of claim 1 , further including means, connected to said means for analyzing, for generating a report
3. The system of claim 2, further comprising means for bookmarking said documents for use by said means for generating a report.
4. The system of claim 1 , wherein said means for displaying includes a representation of the number of items of interest contained in said first document that are within each category represented by one of said category icons, whereby said visual representation is used to rank the relevancy of said document.
5. The system of claim 1 , wherein said personal dictionary includes aliases for one or more of said items of interest, wherein said aliases are used by said means for searching.
6. The system of claim 1 , further comprising means for sharing said personal dictionary.
7. The system of claim 1, wherein said means for collecting documents includes accessing an external source to compile said documents.
8. The system of claim 1, wherein said first document is automatically associated with written comments provided by said user.
9. The system of claim 1 , further comprising a scanner for entering said first document.
10. The system of claim 1 , further comprising means for dragging one of said plurality of icons to an item list area.
11. The system of claim 1 , wherein each said category icons includes a numerical representation depicting the number of said items of interest within each said category represented by said category icon.
12. The system of claim 1, further comprising means for creating relationship links between said items of interest.
13. The system of claim 1, further comprising means for displaying all relationships between said items of interest.
14. A system for displaying a representation of a document having one or more items of interest contained therein, said system comprising: means for defining one or more categories by a user, wherein each category comprises one or more of the items of interest defined by said user; means for displaying a first visual representation depicting the contents of the document within a first window, wherein said visual representation includes a document icon representing the document and one or more category icons representing one or more of said categories that includes at least one of said items of interest.
15. The system of claim 14, further comprising a database that stores information about the document and means for interacting with said visual representation for navigating said database for gaining knowledge about the relevancy of the document and relationships between the document and other information stored in said database.
16. The system of claim 15, wherein said means for interacting with said first visual representation includes interacting with one of said category icons to display a list of said items of interest within said category represented by said one of said category icons.
17. The system of claim 16, wherein said means for interacting includes dragging said one of said category icons to a second window.
18. The system of claim 16, further including means for interacting with a selected item of interest from said list, and means for displaying a second visual representation of said selected item, wherein said second visual representation includes an item icon representing said selected item, and a research icon representing the number of documents that include said selected item.
19. A system for displaying a visual representation depicting relationships between objects stored in a database, said system comprising: a database having a plurality of records, wherein each said record represents a relationship between two objects; means for selecting two objects for determining the relationships therebetween; means, connected to said database, for determining relationships between said two objects, wherein said relationships include direct and indirect relationships; and means for displaying the visual representation, wherein the visual representation is adjustable by a user according to a desired degree of separation between said two objects.
20. The system of claim 19, wherein the visual representation includes a plurality of icons, each icon representing an object, and said icons are joined by connecting lines for depicting said relationships.
21. A method for automating management and analysis of data, the method comprising the steps of: compiling and storing a plurality of documents; creating a personal dictionary by defining one or more categories and defining one or more items of interest within each of said categories; analyzing a first document, comprising the steps of: searching said first document for one or more of said items of interest, and if said first document contains said one or more items of interest, saving said first document and a list of said items of interest contained therein; and displaying a visual representation depicting the contents of said first document, wherein said visual representation includes a document icon representing said first document, and one or more category icons each representing a category that includes at least one of said items of interest in said list.
22. A method for displaying a representation of a document having one or more items of interest contained therein, said method comprising the steps of: defining one or more categories by a user, wherein each category comprises one or more of the items of interest defined by said user; displaying a first visual representation depicting the contents of the document within a first window, wherein said visual representation includes a document icon representing the document and one or more category icons representing one or more of said categories that includes at least one of said items of interest.
23. The method of claim 22, further comprising the step of: navigating a database that stores information about the document by interacting with said visual representation to gain knowledge about the relevancy of the document and relationships between the document and other information stored in said database.
24. The method of 23, wherein said step of navigating step includes the step of interacting with one of said category icons to display a list of said items of interest within said category represented by said one of said category icons.
25. The method of claim 24, wherein said step of interacting is performed by a user dragging said one of said category icons to a second window.
26. The method of claim 23 , further comprising the steps of interacting with a selected item of interest from said list, and displaying a second visual representation of said selected item, wherein said second visual representation includes an item icon representing said selected item, and a research icon representing the number of documents that include said selected item.
27. A method for displaying a visual representation depicting relationships between objects stored in a database, said method comprising the steps of: creating a database having a plurality of records, wherein each said record represents a relationship between two objects; selecting two objects for determining the relationships therebetween; determining relationships between said two objects, wherein said relationships include direct and indirect relationships; and displaying the visual representation, wherein the visual representation is adjustable by a user according to a desired degree of separation between said two objects.
28. The method of claim 27, wherein the visual representation includes a plurality of icons, each icon representing an object, and said icons are joined by connecting lines for depicting said relationships.
29. A computer program product comprising a computer useable medium having computer program logic stored therein, said computer program logic for enabling a computer to automate management and analysis of data, wherein said computer program logic comprises: means for enabling the computer to store documents and related information; means for enabling the computer to compile a plurality of documents in said storing means; means for enabling the computer to display said documents to a user; means for enabling the computer to create a personal dictionary, wherein a user defines one or more categories, each comprising one or more items of interest; means for enabling the computer to analyze a first document, including: means for enabling the computer to search said first document for one or more of said items of interest, and if said first document contains said one or more items of interest, means for enabling the computer to save said first document and a list of said items of interest contained therein; and means for enabling the computer to display a visual representation depicting the contents of said first document, wherein said visual representation includes a document icon representing said first document, and one or more category icons each representing a category that includes at least one of said items of interest in said list.
30. The computer program product of claim system of claim 29, wherein said display means includes a representation of the number of items of interest contained in said first document that are within each category represented by one of said category icons, whereby said visual representation is used to rank the relevancy of said document.
31. The computer program product of claim 29, wherein said means for enabling the computer to compile documents includes means for enabling the computer to access internal and external databases.
32. The computer program product of claim 29, further comprising means for enabling the computer to allow a user to drag one of said plurality of icons to an item list area.
33. A computer program product comprising a computer useable medium having computer program logic stored therein, said computer program logic for enabling a computer to display a representation of a document having one or more items of interest contained therein, wherein said computer program logic comprises: means for enabling the computer to accept from a user, a specification for one or more categories and one or more items of interest within each of said categories; means for enabling the computer to display a first visual representation depicting the contents of the document within a first window, wherein said visual representation includes a document icon representing the document and one or more category icons representing one or more of said categories that includes at least one of said items of interest.
34. The computer program product of claim 33, further comprising a means for enabling the computer to create a database for storing information about the document; and means for enabling the computer to allow a user to interact with said visual representation for navigating said database for providing knowledge about the relevancy of the document and relationships between the document and other information stored in said database.
35. The computer program product of claim 34, wherein said means for enabling the computer to allow a user to interact with said first visual representation includes means for enabling the computer to allow a user to interact with one of said category icons to display a list of said items of interest within said category represented by said one of said category icons.
36. The computer program product of claim 35, wherein said means for enabling the computer to allow a user to interact further includes means for enabling the computer to allow a user to drag said one of said category icons to a second window.
37. The computer program product of claim 35, further including means for enabling the computer to allow a user to interact with a selected item of interest from said list; and means for enabling the computer to display a second visual representation of said selected item, wherein said second visual representation includes an item icon representing said selected item, and a research icon representing the number of documents that include said selected item.
38. A computer program product comprising a computer useable medium having computer program logic stored therein, said computer program logic for enabling a computer to display a visual representation depicting relationships between objects stored in a database, wherein said computer program logic comprises: means for enabling the computer to maintain database having a plurality of records, wherein each said record represents a relationship between two objects; means for enabling the computer to allow a user to select two objects for determining the relationships therebetween; means for enabling the computer to determine relationships between said two objects, wherein said relationships include direct and indirect relationships; and means for enabling the computer to display the visual representation, wherein the visual representation is adjustable by a user according to a desired degree of separation between said two objects.
39. The computer program product of claim 38, wherein the visual representation includes a plurality of icons, each icon representing an object, and said icons are joined by connecting lines for depicting said relationships.
PCT/US1999/011643 1998-05-27 1999-05-27 System method and computer program product to automate the management and analysis of heterogeneous data WO1999061968A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU42086/99A AU4208699A (en) 1998-05-27 1999-05-27 System method and computer program product to automate the management and analysis of heterogeneous data

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US09/085,055 1998-05-27
US09/085,055 US6327586B1 (en) 1998-05-27 1998-05-27 System method and computer program product to automate the management and analysis of heterogeneous data

Publications (1)

Publication Number Publication Date
WO1999061968A2 true WO1999061968A2 (en) 1999-12-02

Family

ID=22189176

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US1999/011643 WO1999061968A2 (en) 1998-05-27 1999-05-27 System method and computer program product to automate the management and analysis of heterogeneous data

Country Status (3)

Country Link
US (2) US6327586B1 (en)
AU (1) AU4208699A (en)
WO (1) WO1999061968A2 (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20010092858A (en) * 2000-03-27 2001-10-27 이근식 Knowledge Management System
EP1199645A1 (en) * 2000-10-16 2002-04-24 Helde Enterprises Limited A value based information system
EP1366449A2 (en) * 2001-02-07 2003-12-03 Biz360, Inc. System of analysing networked searches within business markets

Families Citing this family (163)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6898586B1 (en) * 1998-10-23 2005-05-24 Access Innovations, Inc. System and method for database design and maintenance
US7155715B1 (en) * 1999-03-31 2006-12-26 British Telecommunications Public Limited Company Distributed software system visualization
JP4273570B2 (en) * 1999-05-21 2009-06-03 ソニー株式会社 Information processing apparatus and method, medium
US7000182B1 (en) * 1999-08-20 2006-02-14 Sun Microsystems, Inc. assistant for creation of layouts or reports for databases
US6449611B1 (en) * 1999-09-30 2002-09-10 Fred Frankel Business model for recovery of missing goods, persons, or fugitive or disbursements of unclaimed goods using the internet
US7831494B2 (en) 1999-11-01 2010-11-09 Accenture Global Services Gmbh Automated financial portfolio coaching and risk management system
US7315837B2 (en) * 1999-11-01 2008-01-01 Accenture Llp Communication interface for a financial modeling and counseling system
US7401040B2 (en) * 1999-11-01 2008-07-15 Accenture Llp Financial modeling and counseling system
US7921048B2 (en) 1999-11-01 2011-04-05 Accenture Global Services Gmbh Financial planning and counseling system projecting user cash flow
US7783545B2 (en) 1999-11-01 2010-08-24 Accenture Global Services Gmbh Automated coaching for a financial modeling and counseling system
US7818233B1 (en) 1999-11-01 2010-10-19 Accenture, Llp User interface for a financial modeling system
US6754660B1 (en) * 1999-11-30 2004-06-22 International Business Machines Corp. Arrangement of information for display into a continuum ranging from closely related to distantly related to a reference piece of information
US6832245B1 (en) 1999-12-01 2004-12-14 At&T Corp. System and method for analyzing communications of user messages to rank users and contacts based on message content
US8024213B1 (en) 2000-03-08 2011-09-20 Accenture Global Services Limited System and method and article of manufacture for making financial decisions by balancing goals in a financial manager
US7624172B1 (en) 2000-03-17 2009-11-24 Aol Llc State change alerts mechanism
CA2403520C (en) 2000-03-17 2008-06-03 America Online, Inc. Voice instant messaging
US9736209B2 (en) 2000-03-17 2017-08-15 Facebook, Inc. State change alerts mechanism
US8122363B1 (en) 2000-05-04 2012-02-21 Aol Inc. Presence status indicator
US8132110B1 (en) 2000-05-04 2012-03-06 Aol Inc. Intelligently enabled menu choices based on online presence state in address book
US9356894B2 (en) 2000-05-04 2016-05-31 Facebook, Inc. Enabled and disabled menu choices based on presence state
US9043418B2 (en) 2000-05-04 2015-05-26 Facebook, Inc. Systems and methods for instant messaging persons referenced in an electronic message
US9100221B2 (en) 2000-05-04 2015-08-04 Facebook, Inc. Systems for messaging senders and recipients of an electronic message
US6912564B1 (en) 2000-05-04 2005-06-28 America Online, Inc. System for instant messaging the sender and recipients of an e-mail message
US7979802B1 (en) 2000-05-04 2011-07-12 Aol Inc. Providing supplemental contact information corresponding to a referenced individual
GB2363954A (en) * 2000-06-24 2002-01-09 Ncr Int Inc Displaying a visual decision tree and information buttons
US8001190B2 (en) 2001-06-25 2011-08-16 Aol Inc. Email integrated instant messaging
ATE502477T1 (en) 2000-07-25 2011-04-15 America Online Inc VIDEO MESSAGING
US6683626B1 (en) * 2000-10-04 2004-01-27 Sun Microsystems, Inc. Focus-based scrolling
US8041739B2 (en) * 2001-08-31 2011-10-18 Jinan Glasgow Automated system and method for patent drafting and technology assessment
US7774711B2 (en) * 2001-09-28 2010-08-10 Aol Inc. Automatic categorization of entries in a contact list
US7765484B2 (en) * 2001-09-28 2010-07-27 Aol Inc. Passive personalization of lists
US7512652B1 (en) 2001-09-28 2009-03-31 Aol Llc, A Delaware Limited Liability Company Passive personalization of buddy lists
JP4386732B2 (en) 2002-01-08 2009-12-16 セブン ネットワークス, インコーポレイテッド Mobile network connection architecture
JP3891909B2 (en) * 2002-09-03 2007-03-14 日本アイ・ビー・エム株式会社 Information search support system, application server, information search method, and program
US7640306B2 (en) 2002-11-18 2009-12-29 Aol Llc Reconfiguring an electronic message to effect an enhanced notification
US7899862B2 (en) 2002-11-18 2011-03-01 Aol Inc. Dynamic identification of other users to an online user
US8701014B1 (en) 2002-11-18 2014-04-15 Facebook, Inc. Account linking
US8965964B1 (en) 2002-11-18 2015-02-24 Facebook, Inc. Managing forwarded electronic messages
US8122137B2 (en) 2002-11-18 2012-02-21 Aol Inc. Dynamic location of a subordinate user
US7590696B1 (en) 2002-11-18 2009-09-15 Aol Llc Enhanced buddy list using mobile device identifiers
US7428580B2 (en) 2003-11-26 2008-09-23 Aol Llc Electronic message forwarding
US8005919B2 (en) 2002-11-18 2011-08-23 Aol Inc. Host-based intelligent results related to a character stream
CA2506585A1 (en) 2002-11-18 2004-06-03 Valerie Kucharewski People lists
US7636755B2 (en) 2002-11-21 2009-12-22 Aol Llc Multiple avatar personalities
US8037150B2 (en) 2002-11-21 2011-10-11 Aol Inc. System and methods for providing multiple personas in a communications environment
US8538895B2 (en) 2004-03-15 2013-09-17 Aol Inc. Sharing social network information
US9742615B1 (en) 2002-12-31 2017-08-22 Aol Inc. Popularity index
US7945674B2 (en) 2003-04-02 2011-05-17 Aol Inc. Degrees of separation for handling communications
US7949759B2 (en) * 2003-04-02 2011-05-24 AOL, Inc. Degrees of separation for handling communications
US7263614B2 (en) 2002-12-31 2007-08-28 Aol Llc Implicit access for communications pathway
US7853563B2 (en) 2005-08-01 2010-12-14 Seven Networks, Inc. Universal data aggregation
US7917468B2 (en) * 2005-08-01 2011-03-29 Seven Networks, Inc. Linking of personal information management data
US8468126B2 (en) 2005-08-01 2013-06-18 Seven Networks, Inc. Publishing data in an information community
US7913176B1 (en) 2003-03-03 2011-03-22 Aol Inc. Applying access controls to communications with avatars
US7908554B1 (en) 2003-03-03 2011-03-15 Aol Inc. Modifying avatar behavior based on user action or mood
US20040179037A1 (en) 2003-03-03 2004-09-16 Blattner Patrick D. Using avatars to communicate context out-of-band
US7613776B1 (en) 2003-03-26 2009-11-03 Aol Llc Identifying and using identities deemed to be known to a user
JP4189248B2 (en) * 2003-03-31 2008-12-03 日立ソフトウエアエンジニアリング株式会社 Database search path judgment method
US7653693B2 (en) 2003-09-05 2010-01-26 Aol Llc Method and system for capturing instant messages
US7383269B2 (en) * 2003-09-12 2008-06-03 Accenture Global Services Gmbh Navigating a software project repository
US7259763B2 (en) * 2003-11-13 2007-08-21 International Business Machines Corporation Embedded analytics in information visualization
US8898239B2 (en) * 2004-03-05 2014-11-25 Aol Inc. Passively populating a participant list with known contacts
US8595146B1 (en) 2004-03-15 2013-11-26 Aol Inc. Social networking permissions
US20050240456A1 (en) * 2004-04-27 2005-10-27 Ward Christian J Independent research analysis, aggregation and delivery system and method
US20060075181A1 (en) * 2004-09-30 2006-04-06 Perillon Software, Inc. User interface for system for environmental, health, and safety compliance
US7441271B2 (en) 2004-10-20 2008-10-21 Seven Networks Method and apparatus for intercepting events in a communication system
US8010082B2 (en) 2004-10-20 2011-08-30 Seven Networks, Inc. Flexible billing architecture
US7706781B2 (en) 2004-11-22 2010-04-27 Seven Networks International Oy Data security in a mobile e-mail service
US9002949B2 (en) 2004-12-01 2015-04-07 Google Inc. Automatically enabling the forwarding of instant messages
US8060566B2 (en) * 2004-12-01 2011-11-15 Aol Inc. Automatically enabling the forwarding of instant messages
US7730143B1 (en) 2004-12-01 2010-06-01 Aol Inc. Prohibiting mobile forwarding
FI117152B (en) 2004-12-03 2006-06-30 Seven Networks Internat Oy E-mail service provisioning method for mobile terminal, involves using domain part and further parameters to generate new parameter set in list of setting parameter sets, if provisioning of e-mail service is successful
US9652809B1 (en) 2004-12-21 2017-05-16 Aol Inc. Using user profile information to determine an avatar and/or avatar characteristics
US20060179069A1 (en) 2005-02-04 2006-08-10 Bechtel Michael E Knowledge discovery tool navigation
US20060179026A1 (en) * 2005-02-04 2006-08-10 Bechtel Michael E Knowledge discovery tool extraction and integration
US8660977B2 (en) * 2005-02-04 2014-02-25 Accenture Global Services Limited Knowledge discovery tool relationship generation
US7904411B2 (en) * 2005-02-04 2011-03-08 Accenture Global Services Limited Knowledge discovery tool relationship generation
US20060179067A1 (en) * 2005-02-04 2006-08-10 Bechtel Michael E Knowledge discovery tool navigation
US7752633B1 (en) 2005-03-14 2010-07-06 Seven Networks, Inc. Cross-platform event engine
DE102005013189A1 (en) * 2005-03-22 2006-10-05 Reinhard Boltin Computer-aided information management and provision method for handling project, involves including interactive changeable width and depth by set of terms, where width/depth establishes degree of freedom/accuracy of data, respectively
US8438633B1 (en) 2005-04-21 2013-05-07 Seven Networks, Inc. Flexible real-time inbox access
US7796742B1 (en) 2005-04-21 2010-09-14 Seven Networks, Inc. Systems and methods for simplified provisioning
US7606580B2 (en) * 2005-05-11 2009-10-20 Aol Llc Personalized location information for mobile devices
US7765265B1 (en) 2005-05-11 2010-07-27 Aol Inc. Identifying users sharing common characteristics
US7526473B2 (en) * 2005-06-21 2009-04-28 Microsoft Corporation Traversing a relational model with preferred paths
WO2006136660A1 (en) 2005-06-21 2006-12-28 Seven Networks International Oy Maintaining an ip connection in a mobile network
US8069166B2 (en) 2005-08-01 2011-11-29 Seven Networks, Inc. Managing user-to-user contact with inferred presence information
US7702753B2 (en) 2005-11-21 2010-04-20 Accenture Global Services Gmbh Unified directory and presence system for universal access to telecommunications services
US7769395B2 (en) 2006-06-20 2010-08-03 Seven Networks, Inc. Location-based operations and messaging
US7602471B2 (en) * 2006-05-17 2009-10-13 Taiwan Semiconductor Manufacturing Company, Ltd. Apparatus and method for particle monitoring in immersion lithography
JP4240096B2 (en) * 2006-09-21 2009-03-18 ソニー株式会社 Information processing apparatus and method, program, and recording medium
US7765176B2 (en) * 2006-11-13 2010-07-27 Accenture Global Services Gmbh Knowledge discovery system with user interactive analysis view for analyzing and generating relationships
US8201086B2 (en) * 2007-01-18 2012-06-12 International Business Machines Corporation Spellchecking electronic documents
US7912797B2 (en) * 2007-03-15 2011-03-22 Accenture Global Services Limited Monitoring and control of analytical effectiveness in an analyst network
EP1972994A1 (en) * 2007-03-20 2008-09-24 Seiko Epson Corporation Projector
US8805425B2 (en) 2007-06-01 2014-08-12 Seven Networks, Inc. Integrated messaging
US8693494B2 (en) 2007-06-01 2014-04-08 Seven Networks, Inc. Polling
US8296667B2 (en) * 2007-08-01 2012-10-23 Sap Ag User interface for displaying and navigating relationships between objects graphically
US8364181B2 (en) 2007-12-10 2013-01-29 Seven Networks, Inc. Electronic-mail filtering for mobile devices
US8793305B2 (en) 2007-12-13 2014-07-29 Seven Networks, Inc. Content delivery to a mobile device from a content service
US9002828B2 (en) 2007-12-13 2015-04-07 Seven Networks, Inc. Predictive content delivery
US8107921B2 (en) 2008-01-11 2012-01-31 Seven Networks, Inc. Mobile virtual network operator
US8862657B2 (en) 2008-01-25 2014-10-14 Seven Networks, Inc. Policy based content service
US20090193338A1 (en) 2008-01-28 2009-07-30 Trevor Fiatal Reducing network and battery consumption during content delivery and playback
US8620913B2 (en) * 2008-04-07 2013-12-31 Microsoft Corporation Information management through a single application
US8787947B2 (en) 2008-06-18 2014-07-22 Seven Networks, Inc. Application discovery on mobile devices
US8078158B2 (en) 2008-06-26 2011-12-13 Seven Networks, Inc. Provisioning applications for a mobile device
US8548503B2 (en) 2008-08-28 2013-10-01 Aol Inc. Methods and system for providing location-based communication services
US8909759B2 (en) 2008-10-10 2014-12-09 Seven Networks, Inc. Bandwidth measurement
US8458105B2 (en) * 2009-02-12 2013-06-04 Decisive Analytics Corporation Method and apparatus for analyzing and interrelating data
US20100235314A1 (en) * 2009-02-12 2010-09-16 Decisive Analytics Corporation Method and apparatus for analyzing and interrelating video data
US20100325101A1 (en) * 2009-06-19 2010-12-23 Beal Alexander M Marketing asset exchange
US20110004692A1 (en) 2009-07-01 2011-01-06 Tom Occhino Gathering Information about Connections in a Social Networking Service
TW201104462A (en) * 2009-07-24 2011-02-01 Inventec Corp System for generating customized dictionary and method thereof
EP2488960A4 (en) 2009-10-15 2016-08-03 Hewlett Packard Entpr Dev Lp Heterogeneous data source management
TW201209697A (en) 2010-03-30 2012-03-01 Michael Luna 3D mobile user interface with configurable workspace management
CA2857458A1 (en) 2010-07-26 2012-02-09 Michael Luna Mobile application traffic optimization
US9077630B2 (en) 2010-07-26 2015-07-07 Seven Networks, Inc. Distributed implementation of dynamic wireless traffic policy
US8838783B2 (en) 2010-07-26 2014-09-16 Seven Networks, Inc. Distributed caching for resource and mobile network traffic management
US9043433B2 (en) 2010-07-26 2015-05-26 Seven Networks, Inc. Mobile network traffic coordination across multiple applications
KR101735614B1 (en) * 2010-08-12 2017-05-15 엘지전자 주식회사 Mobile terminal and operation control method thereof
US8484314B2 (en) 2010-11-01 2013-07-09 Seven Networks, Inc. Distributed caching in a wireless network of content delivered for a mobile application over a long-held request
WO2012061430A2 (en) 2010-11-01 2012-05-10 Michael Luna Distributed management of keep-alive message signaling for mobile network resource conservation and optimization
US9330196B2 (en) 2010-11-01 2016-05-03 Seven Networks, Llc Wireless traffic management system cache optimization using http headers
US9060032B2 (en) 2010-11-01 2015-06-16 Seven Networks, Inc. Selective data compression by a distributed traffic management system to reduce mobile data traffic and signaling traffic
US8843153B2 (en) 2010-11-01 2014-09-23 Seven Networks, Inc. Mobile traffic categorization and policy for network use optimization while preserving user experience
US8190701B2 (en) 2010-11-01 2012-05-29 Seven Networks, Inc. Cache defeat detection and caching of content addressed by identifiers intended to defeat cache
WO2012060995A2 (en) 2010-11-01 2012-05-10 Michael Luna Distributed caching in a wireless network of content delivered for a mobile application over a long-held request
GB2499534B (en) 2010-11-01 2018-09-19 Seven Networks Llc Caching adapted for mobile application behavior and network conditions
US8166164B1 (en) 2010-11-01 2012-04-24 Seven Networks, Inc. Application and network-based long poll request detection and cacheability assessment therefor
GB2500327B (en) 2010-11-22 2019-11-06 Seven Networks Llc Optimization of resource polling intervals to satisfy mobile device requests
CN103404193B (en) 2010-11-22 2018-06-05 七网络有限责任公司 The connection that adjustment data transmission is established with the transmission being optimized for through wireless network
US8484191B2 (en) 2010-12-16 2013-07-09 Yahoo! Inc. On-line social search
US9325662B2 (en) 2011-01-07 2016-04-26 Seven Networks, Llc System and method for reduction of mobile network traffic used for domain name system (DNS) queries
WO2012145541A2 (en) 2011-04-19 2012-10-26 Seven Networks, Inc. Social caching for device resource sharing and management
CA2797631C (en) 2011-04-27 2013-11-19 Seven Networks, Inc. System and method for making requests on behalf of a mobile device based on atomic processes for mobile network traffic relief
GB2505585B (en) 2011-04-27 2015-08-12 Seven Networks Inc Detecting and preserving state for satisfying application requests in a distributed proxy and cache system
US8984581B2 (en) 2011-07-27 2015-03-17 Seven Networks, Inc. Monitoring mobile application activities for malicious traffic on a mobile device
US8934414B2 (en) 2011-12-06 2015-01-13 Seven Networks, Inc. Cellular or WiFi mobile traffic optimization based on public or private network destination
US8868753B2 (en) 2011-12-06 2014-10-21 Seven Networks, Inc. System of redundantly clustered machines to provide failover mechanisms for mobile traffic management and network resource conservation
WO2013086447A1 (en) 2011-12-07 2013-06-13 Seven Networks, Inc. Radio-awareness of mobile device for sending server-side control signals using a wireless network optimized transport protocol
US9009250B2 (en) 2011-12-07 2015-04-14 Seven Networks, Inc. Flexible and dynamic integration schemas of a traffic management system with various network operators for network traffic alleviation
US20130159511A1 (en) 2011-12-14 2013-06-20 Seven Networks, Inc. System and method for generating a report to a network operator by distributing aggregation of data
WO2013090821A1 (en) 2011-12-14 2013-06-20 Seven Networks, Inc. Hierarchies and categories for management and deployment of policies for distributed wireless traffic optimization
US9832095B2 (en) 2011-12-14 2017-11-28 Seven Networks, Llc Operation modes for mobile traffic optimization and concurrent management of optimized and non-optimized traffic
WO2013103988A1 (en) 2012-01-05 2013-07-11 Seven Networks, Inc. Detection and management of user interactions with foreground applications on a mobile device in distributed caching
US9203864B2 (en) 2012-02-02 2015-12-01 Seven Networks, Llc Dynamic categorization of applications for network access in a mobile network
WO2013116852A1 (en) 2012-02-03 2013-08-08 Seven Networks, Inc. User as an end point for profiling and optimizing the delivery of content and data in a wireless network
US9240970B2 (en) 2012-03-07 2016-01-19 Accenture Global Services Limited Communication collaboration
US8812695B2 (en) 2012-04-09 2014-08-19 Seven Networks, Inc. Method and system for management of a virtual network connection without heartbeat messages
US20130268656A1 (en) 2012-04-10 2013-10-10 Seven Networks, Inc. Intelligent customer service/call center services enhanced using real-time and historical mobile application and traffic-related statistics collected by a distributed caching system in a mobile network
US8775631B2 (en) 2012-07-13 2014-07-08 Seven Networks, Inc. Dynamic bandwidth adjustment for browsing or streaming activity in a wireless network based on prediction of user behavior when interacting with mobile applications
US9161258B2 (en) 2012-10-24 2015-10-13 Seven Networks, Llc Optimized and selective management of policy deployment to mobile clients in a congested network to prevent further aggravation of network congestion
US10733182B2 (en) * 2012-12-10 2020-08-04 Healthagen International Limited Method and system for aggregate banding
US9307493B2 (en) 2012-12-20 2016-04-05 Seven Networks, Llc Systems and methods for application management of mobile device radio state promotion and demotion
US9271238B2 (en) 2013-01-23 2016-02-23 Seven Networks, Llc Application or context aware fast dormancy
US8874761B2 (en) 2013-01-25 2014-10-28 Seven Networks, Inc. Signaling optimization in a wireless network for traffic utilizing proprietary and non-proprietary protocols
US8750123B1 (en) 2013-03-11 2014-06-10 Seven Networks, Inc. Mobile device equipped with mobile network congestion recognition to make intelligent decisions regarding connecting to an operator network
US9065765B2 (en) 2013-07-22 2015-06-23 Seven Networks, Inc. Proxy server associated with a mobile carrier for enhancing mobile traffic management in a mobile network
US9785316B1 (en) * 2014-01-22 2017-10-10 Google Inc. Methods, systems, and media for presenting messages
US9275037B2 (en) 2014-02-18 2016-03-01 International Business Machines Corporation Managing comments relating to work items
US20230153315A1 (en) * 2021-10-29 2023-05-18 Nasdaq, Inc. Connected data across data frameworks
EP4328764A1 (en) * 2022-08-26 2024-02-28 EVIDENCE PRIME Sp. z o.o. Artificial intelligence-based system and method for improving speed and quality of work on literature reviews

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5237651A (en) * 1987-08-21 1993-08-17 Eden Group Limited Electronic personal organizer
US5367623A (en) * 1990-09-25 1994-11-22 Sharp Kabushiki Kaisha Information processing apparatus capable of opening two or more windows on screen, one window containing a page and other windows containing supplemental information
US5283864A (en) * 1990-10-30 1994-02-01 Wang Laboratories, Inc. Computer apparatus and method for graphical flip book
US5202828A (en) * 1991-05-15 1993-04-13 Apple Computer, Inc. User interface system having programmable user interface elements
US5987474A (en) * 1995-08-04 1999-11-16 Aircraft Technical Publishers Computer aided maintenance and repair information system for equipment subject to regulatory compliance
US5528259A (en) * 1992-10-29 1996-06-18 International Business Machines Corporation Method and system for multi-dimensional scrolling of displayed data collections in a data processing system
US5392387A (en) * 1992-12-17 1995-02-21 International Business Machines Corporation Method and system for enhanced data access efficiency in an electronic book
US5526480A (en) * 1992-12-28 1996-06-11 International Business Machines Corporation Time domain scroll bar for multimedia presentations in a data processing system
US5506951A (en) * 1994-03-01 1996-04-09 Ishikawa; Hiroshi Scroll bar with jump tags
US5666964A (en) * 1995-06-06 1997-09-16 Meilus; Algis A. Muscle treatment devices
US5710897A (en) * 1995-08-15 1998-01-20 International Business Machines Corporation Manager for selecting a pointer graphics folder and customizing pointers
US5668964A (en) * 1995-08-24 1997-09-16 Wall Data Incorporated Graphical user interface for creating a new notebook with a dragged page
US5838973A (en) * 1996-05-03 1998-11-17 Andersen Consulting Llp System and method for interactively transforming a system or process into a visual representation

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20010092858A (en) * 2000-03-27 2001-10-27 이근식 Knowledge Management System
EP1199645A1 (en) * 2000-10-16 2002-04-24 Helde Enterprises Limited A value based information system
EP1366449A2 (en) * 2001-02-07 2003-12-03 Biz360, Inc. System of analysing networked searches within business markets
EP1366449A4 (en) * 2001-02-07 2007-06-20 Biz360 Inc System of analysing networked searches within business markets

Also Published As

Publication number Publication date
US6327586B1 (en) 2001-12-04
US20020065856A1 (en) 2002-05-30
AU4208699A (en) 1999-12-13

Similar Documents

Publication Publication Date Title
US6327586B1 (en) System method and computer program product to automate the management and analysis of heterogeneous data
US10185471B2 (en) Interface and method for displaying a collection of interrelated data
US9858255B1 (en) Computer-implemented method and system for automated claim construction charts with context associations
US20020049705A1 (en) Method for creating content oriented databases and content files
US8271563B1 (en) Computer-implemented method and system for managing attributes of intellectual property documents, optionally including organization thereof
Trippe Patinformatics: Tasks to tools
US7596558B2 (en) System and method for obtaining user feedback for relevance tuning
US20030061209A1 (en) Computer user interface tool for navigation of data stored in directed graphs
US20020055919A1 (en) Method and system for gathering, organizing, and displaying information from data searches
US20030120681A1 (en) Classification of information sources using graphic structures
US20050138056A1 (en) System and method for multi-dimensional foraging and retrieval of documents
US20020087579A1 (en) Object universe
JPH0991314A (en) Information search device
KR101007613B1 (en) Data registration/search support device using a keyword
EP1667034A2 (en) System and method for interactive multi-dimensional visual representation of information content and properties
JP3601675B2 (en) Information retrieval apparatus, information retrieval method, and recording medium
US20050060353A1 (en) Method and system for personalized information management
US20030033323A1 (en) System for utilizing audible, visual and textual data with alternative combinable multimedia forms of presenting information for real-time interactive use by multiple users in different remote environments
CA2528506A1 (en) System and method for interactive multi-dimensional visual representation of information content and properties
WO2001079957A2 (en) A method for creating content oriented databases and content files
O’Sullivan et al. Context-oriented image retrieval
Foo Enhancing E-Journal Access In A Digital Work Environment
Mothe Internet-based information discovery
Reffell et al. BreakingStory: An Interactive System for Visualizing Change in Online News
JP2000112986A (en) Method and system for data recognition and retrieval along purpose of operator, storage medium storing program for the same method and storage medium recording data group prepared by the same method

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW SD SL SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
NENP Non-entry into the national phase

Ref country code: KR

WA Withdrawal of international application
REG Reference to national code

Ref country code: DE

Ref legal event code: 8642