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

• US 20060173873A1
• Filed: 01/09/2006
• Published: 08/03/2006
• Est. Priority Date: 03/03/2000
• Status: Abandoned Application

• Current Assignee: Radiant Logic Incorporated
• Original Assignee: Radiant Logic Incorporated
• Inventors: Samuelson, Claude Yves Martin, Prompt, Michel
• Application Number:
  US11/328,664
• Publication Number:
  US 20060173873A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/284 Relational databases

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 computer-implemented method of searching hierarchical paths, the method comprising:

capturing relationships and objects from at least one data source;

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

creating a virtual directory based on the hierarchical paths; and

querying the virtual directory.

2. The method of claim 1, further comprising returning at least one result of the query, each result comprising a representation of the hierarchical path associated with the result.

3. The method of claim 1, wherein the at least one data source comprises 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.

4. The method of claim 1, wherein querying the virtual directory comprises searching the virtual directory for an attribute.

5. The method of claim 4 further comprising returning the attribute and a context associated with the attribute.

6. The method of claim 5, wherein the context associated with the attribute comprises one from the group consisting of a representation of a hierarchical path and a portion of the hierarchical path to the attribute.

7. The method of claim 1, wherein querying the virtual directory comprises searching the virtual directory for a keyword.

8. The method of claim 1, wherein querying the virtual directory comprises:

creating a text file corresponding to each object in the virtual directory;

creating an index of the text files;

querying the index; and

receiving query results.

9. The method of claim 8, wherein querying the index comprises querying by keyword.

10. The method of claim 8, wherein creating a text file corresponding to each object in the virtual directory comprises querying the virtual directory system and receiving a distinguished name and contents of each object in the virtual directory.

11. The method of claim 8, wherein the text file corresponding to each object has a distinguished name and comprises the contents of an object in the virtual directory.

12. The method of claim 11, wherein the query results comprise the distinguished name of the text file corresponding to each object in the virtual directory that matches the query.

13. The method of claim 8, wherein the steps of creating an index of the text files and querying the index are performed by a search engine.

14. The method of claim 1, further comprising displaying a subset of the results of the query.

15. The method of claim 1, further comprising displaying the results of the query in a hierarchical format.

16. A virtual directory server for searching hierarchical paths, comprising:

a first module for capturing relationships and objects from at least one data source, the first module coupled to the at least one data source;

a second module for mapping the relationships and objects captured into a set of hierarchical paths, the second module coupled to the first module;

a third module for creating a virtual directory based on the hierarchical paths, the third module coupled to the second module and coupled to a memory for storing the virtual directory; and

a fourth module for querying the virtual directory, the fourth module coupled to the memory to access the virtual directory.

17. The virtual directory server of claim 16, wherein the fourth module is for returning at least one result of the query, each result comprising a representation of the hierarchical path associated with the result.

18. The virtual directory server of claim 16, wherein the at least one data source comprises 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.

19. The virtual directory server of claim 16, wherein querying the virtual directory comprises searching the virtual directory for an attribute.

20. The virtual directory server of claim 19, wherein the fourth module is for returning the attribute and a context associated with the attribute.

21. The virtual directory sever of claim 20, wherein the context associated with the attribute comprises one from the group consisting of a representation of a hierarchical path and a portion of the hierarchical path to the attribute.

22. The virtual directory sever of claim 16, wherein querying the virtual directory comprises searching the virtual directory for a keyword.

23. The virtual directory server of claim 16, wherein querying the virtual directory comprises:

creating a text file corresponding to each object in the virtual directory;

creating an index of the text files;

querying the index; and

receiving query results.

24. The virtual directory server of claim 23, wherein querying the index comprises querying by keyword.

25. The virtual directory server of claim 23, wherein creating a text file corresponding to each object in the virtual directory comprises querying the virtual directory system and receiving a distinguished name and contents of each object in the virtual directory.

26. The virtual directory server of claim 23, wherein the text file corresponding to each object has a distinguished name and comprises the contents of an object in the virtual directory.

27. The virtual directory server of claim 26, wherein the query results comprise the distinguished name of the text file corresponding to each object in the virtual directory that matches the query.

28. The virtual directory server of claim 16, further comprising a module for formatting a subset of the results of the query for display.

29. The virtual directory server of claim 16, further comprising a module for formatting the results of the query in a hierarchical format for display.

30. A computer program product for searching hierarchical paths, the computer program product stored on a computer readable medium, and adapted to perform the operations of:

capturing relationships and objects from at least one data source;

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

creating a virtual directory based on the hierarchical paths; and

querying the virtual directory.