Graphical Database Navigator with Relation Level Control

1. A method for graphically mapping objects in a database comprising the steps of: identifying an object of focus within the database; locating a set of related objects satisfying a maximum relation level and excluding from the set of related objects those objects that are related to the object of focus but that are beyond the maximum relation level; and graphically mapping the set of related objects, including generating a display of a database map in which the related objects in the set of related objects are included in the display while related objects that are beyond the maximum relation level are excluded from the display, wherein the object of focus is related to first and second related objects, wherein the first related object is within the maximum relation level relative to the object of focus, wherein the second related object is beyond the maximum relation level relative to the object of focus, and wherein generating the display of the database map includes including the first related object in the display but excluding the second related object from the display.

2. The method of claim 1 , wherein the maximum relation level is more than one.

3. The method of claim 1 , wherein the step of locating, further includes the steps of: locating an initial set of related objects within one relation level of the object of focus; and locating a secondary set of related objects within one relation level of the respective objects in the initial set.

4. The method of claim 3 , further comprising the steps of: locating an additional set of objects within one relation level of the respective objects in the secondary set; repeating the step of locating additional sets of objects without exceeding the set maximum relation level; and graphically mapping all the different sets of objects.

5. The method of claim 1 , wherein the database comprises objects that include one or more of: a key, a partition, a table, a trigger, a constraint, an index, a view, a query, a journal, and an alias.

6. The method according to claim 1 , further comprising the step of: setting a maximum relation level relative to the object of focus.

7. A method for graphically mapping objects in a database comprising the steps of: a) identifying an object of focus within the database; b) iteratively identifying a set of related objects which are within a relation level of one relative to one or more previously identified objects; c) repeating step b) for a predetermined number of times associated with a maximum number of relation levels; and d) graphically mapping the identified related objects in a database map, including generating a display of the database map in which the identified related objects are included in the display, wherein at least one related object that is beyond the maximum number of relation levels is excluded from the database map, wherein the one or more previously identified objects is related to first and second related objects, wherein the first related object is within the maximum number of relation levels relative to the one or more previously identified objects, wherein the second related object is beyond the maximum number of relation levels relative to the one or more previously identified objects, and wherein the at least one related object that is beyond the maximum number of relation levels includes the second related object.

8. The method of claim 7 , further comprising the step of: monitoring how many times step b) is performed.

9. The method of claim 7 , further comprising the step of: receiving as input the predetermined number of times.

10. The method of claim 7 , wherein the database comprises objects that include one or more of: a key, a partition, a table, a trigger, a constraint, an index, a view, a query, a journal, and an alias.

11. An apparatus for graphically displaying database objects, the apparatus comprising: at least one processor; a memory coupled with the at least one processor; and a program code residing in the memory and executed by the at least one processor, the program code configured to: identify an object of focus within the database; locate a set of related objects satisfying a maximum relation level and exclude from the set of related objects those objects that are related to the object of focus but that are beyond the maximum relation level; and graphically map the set of related objects, including generating a display of a database map in which the related objects in the set of related objects are included in the display while related objects that are beyond the maximum relation level are excluded from the display, wherein the object of focus is related to first and second related objects, wherein the first related object is within the maximum relation level relative to the object of focus, wherein the second related object is beyond the maximum relation level relative to the object of focus, and wherein generating the display of the database map includes including the first related object in the display but excluding the second related object from the display.

12. The apparatus of claim 11 , wherein the maximum relation level is more than one.

13. The apparatus of claim 11 , wherein the program code is further configured to: locate an initial set of related object within one relation level of the object of focus; and locate a secondary set of related objects within one relation level of the respective objects in the initial set.

14. The apparatus of claim 13 , wherein the program code is further configured to: locate an additional set of objects within one relation level of the respective objects in the secondary set; repeat the step of locating additional sets of objects without exceeding the set maximum relation level; and graphically map all the different sets of objects.

15. The apparatus of claim 11 , wherein the database comprises objects that include one or more of: a key, a partition, a table, a trigger, a constraint, an index, a view, a query, a journal, and an alias.

16. The apparatus of claim 11 , wherein the program code is further configured to: set a maximum relation level relative to the object of focus.

17. A program product for graphically mapping database objects, comprising: program code configured upon execution thereof to: identify an object of focus within the database; locate a set of related objects satisfying a maximum relation level and exclude from the set of related objects those objects that are related to the object of focus but that are beyond the maximum relation level; and graphically map the set of related objects, including generating a display of a database map in which the related objects in the set of related objects are included in the display while related objects that are beyond the maximum relation level are excluded from the display, wherein the object of focus is related to first and second related objects, wherein the first related object is within the maximum relation level relative to the object of focus, wherein the second related object is beyond the maximum relation level relative to the object of focus, and wherein generating the display of the database map includes including the first related object in the display but excluding the second related object from the display; and a recordable computer readable medium bearing the program code.

18. The program product of claim 17 , wherein the maximum relation level is more than one.

19. The program product of claim 17 , wherein the program code is further configured to: locate an initial set of related object within one relation level of the object of focus; and locate a secondary set of related objects within one relation level of the respective objects in the initial set.

20. The program product of claim 19 , wherein the program code is further configured to: locate an additional set of objects within one relation level of the respective objects in the secondary set; repeat the step of locating additional sets of objects without exceeding the set maximum relation level; and graphically map all the different sets of objects.

21. The program product of claim 17 , wherein the database comprises objects that include one or more of: a key, a partition, a table, a trigger, a constraint, an index, a view, a query, a journal, and an alias.

22. The program product of claim 17 , wherein the program code is further configured to: set a maximum relation level relative to the object of focus.