System and method for providing access to databases via directories and other hierarchical structures and interfaces

• US 6,985,905 B2
• Filed: 03/02/2001
• Issued: 01/10/2006
• Est. Priority Date: 03/03/2000
• Status: Expired due to Term

• Current Assignee: Radiant Logic Incorporated
• Original Assignee: Radiant Logic Incorporated
• Inventors: Prompt, Michel, Samuelson, Claude Y.
• Primary Examiner(s): Kindred, Alford
• Assistant Examiner(s): Al-Hashemi, Sana
• Application Number:
  US09/798,003
• Publication Number:
  US 20010034733A1
• Time in Patent Office: 1,775 Days
• Field of Search: 707/104.1, 707/3, 707/102, 707/4, 707/103.Y
• US Class Current: 707/829
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/956 Hierarchical
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A hierarchical/relational translation system is provided for enabling information from unrelated heterogeneous relational computing systems to be accessed, navigated, searched, browsed, and shared over a hierarchical computing system. In one embodiment, the hierarchical/relational translation system includes a virtual directory server for capturing information in the nature of relational database schema and metadata. The captured schema and metadata are then translated into virtual directories that are universally compatible with standard communication protocols used with hierarchical computing systems. A virtual directory of information organizes an index of data records and a standard addressing schema is provided to enable customizable access to relevant views of relational computing systems. Several embodiments for presenting the virtual directory information tree are included. In one embodiment, the virtual directory is displayed using browser format. In another embodiment, the virtual directory is presented in electronic mail format. Still, in another embodiment the virtual directory is presented over a wireless medium and through portable devices.

Claims

1. A method for building standard-based hierarchical view definitions, comprising steps of:

capturing relationships and objects from a first data source and a second data source, each data source having a data model, the first data source having a data model different from the second data source;

mapping the relationships and objects captured into a set of hierarchical paths;

creating a virtual directory of the hierarchical paths; and

forming a combined presentation of the view definitions based on the hierarchical paths.

2. A method for building view definitions according to claim 1, further comprising the step of transferring the combined presentation for display and modification.

6. The method of claim 1 wherein each data source is selected from the group of:

a network operating system, a database, an application, a web service protocol, and a directory structure.

7. The method of claim 6 wherein the database is a relational database.

8. The method of claim 2 further comprises:

transferring the combined presentation in a form viewable on a device that is one from the group;

a browser, an electronic mail display device, and a wireless portable device.

3. A system for building view definitions, comprising:

a server for accessing a first data source and a second data source, each data source having a data model, the first data source having a relational data model, the second data source having a data model different from the first data source, in response to an instruction received from a client device communicatively coupled to the server;

coupled to the server, a database for providing the relational data of the first data source;

a module for capturing the relational data from the database;

a module for converting the relational data into a set of hierarchical paths;

a module for creating a virtual directory of the hierarchical paths; and

a module for navigating the hierarchical paths from the client device.

4. A computer program product for building standard-based hierarchical view definitions, the computer program product stored on a computer readable medium, and adapted to perform the operations of:

capturing relationships and objects from a first data source and a second data source, each data source having a data model, the first data source having a data model different from the second data source;

mapping the relationships and objects captured into a set of hierarchical paths;

creating a virtual directory of the hierarchical paths; and

forming a combined presentation of the view definitions based on the hierarchical paths.

5. A system for providing hierarchical representation of a first data source and a second data source, each data source having a data model, the first data source having a relational data model, the second data source having a data model different from the first data source, comprising:

a first server capturing the relational data of the first data source from a database coupled to the server;

coupled to the first server, a virtual server mapping the relational data captured into a virtual directory of hierarchical representations; and

an interface application coupled to the first server for forming a presentation of the virtual directory for display.

9. The system of claim 5 wherein the presentation display is selected from the group consisting of:

a browser, electronic mail display, and on a wireless portable device.