# US 2013/0097193 A1 · Accessing data and functionality in database systems > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2013/0097193 A1 - Document ID: US20130097193A1 - Status: Published application - Kind: A1 - Application number: 13/275,941 - Filed: 2011-10-18 - Published: 2013-04-18 - Earliest claimed: 2011-10-18 - Assignees: International Business Machines Corporation - Inventors: Vinod P. Chirayath; Zackery M. Englang; Venkatesh S. Gopal; Salvador Ledezma - Web page: https://patentgrep.com/patent/US20130097193A1 ## CPC - G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract Some embodiments include a method for searching a hierarchical database structure of a database management system. In some embodiments, the method comprises detecting text input in a database search field, wherein the text input defines a search for data in the hierarchical database structure, wherein the hierarchical database structure includes items, and wherein the items include one or more of actions to be performed on data in the hierarchical database structure, indexes for looking up data in the hierarchical database structure, and database schemas defining databases in the hierarchical database structure. The method can also comprise selecting items in the hierarchical database structure based on the text input; presenting selectable options, wherein the selectable options are associated with the items in the hierarchical database structure; detecting selection of one of the selectable options, and presenting data associated with the one of the items. ## Claims ### Claim 1 A method for searching a hierarchical database structure of a database management system, the method comprising: detecting text input in a database search field, wherein the text input defines a search for data in the hierarchical database structure, wherein the hierarchical database structure includes items, and wherein the items include one or more of actions to be performed on data in the hierarchical database structure, indexes for looking up data in the hierarchical database structure, and database schemas defining databases in the hierarchical database structure; determining that the text input does not define a path in the hierarchical database structure; selecting items in the hierarchical database structure based on the text input; presenting selectable options in a graphical user interface, wherein the selectable options are associated with the items in the hierarchical database structure; detecting selection of one of the selectable options, wherein the one of the selectable options is associated with one of the items; and presenting, in the graphical user interface, data associated with the one of the items. ### Claim 2 (depends on 1) The method of claim 1, wherein the selectable options appear as text in the graphical user interface. ### Claim 3 (depends on 1) The method of claim 1 further comprising: detecting that the text input defines a path to another one of the items in the hierarchical database structure; accessing the other one of the items by traversing the path in the hierarchical database structure; presenting, in the graphical user interface, data associated with the one of the items. ### Claim 4 (depends on 1) The method of claim 1, wherein the actions include view data, query, alter, drop, view hierarchy. ### Claim 5 (depends on 1) The method of claim 1, wherein the data associated with the one of the items includes one or more of: at least a portion of the database schemas, and at least a portion of the indexes. ### Claim 6 A device for searching a hierarchical database structure of a database management system, the device comprising: a search unit configured to detect text input in a database search field, wherein the text input defines a search for data in the hierarchical database structure, wherein the hierarchical database structure includes items, and wherein the items include one or more of actions to be performed on data in the hierarchical database structure, indexes for looking up data in the hierarchical database structure, and database schemas defining databases in the hierarchical database structure; determine that the text input does not define a path in the hierarchical database structure; select items in the hierarchical database structure based on the text input; detect selection of one of a plurality of selectable options, wherein the one of the plurality of selectable options is associated with one of the items; and a presentation unit configured to present the plurality of selectable options in a graphical user interface on a display device, wherein the selectable options are associated with the items in the hierarchical database structure; present, in the graphical user interface, data associated with the one of the items. ### Claim 7 (depends on 6) The device of claim 6, wherein the selectable options appear as text in the graphical user interface. ### Claim 8 (depends on 6) The device of claim 6, wherein the search unit is further configured to: detect that the text input defines a path to another one of the items in the hierarchical database structure; access the other one of the items by traversing the path in the hierarchical database structure; and the presentation unit is further configured to present, in the graphical user interface, data associated with the one of the items. ### Claim 9 (depends on 6) The device of claim 6, wherein the actions include view data, query, alter, drop, view hierarchy. ### Claim 10 (depends on 6) The device of claim 6, wherein the data associated with the one of the items includes one or more of: at least a portion of the database schemas, and at least a portion of the indexes. ### Claim 11 A computer readable storage medium including instructions which when executed by a computer perform operations for searching a hierarchical database structure of a database management system, the operations comprising: detecting text input in a database search field, wherein the text input defines a search for data in the hierarchical database structure, wherein the hierarchical database structure includes items, and wherein the items include one or more of actions to be performed on data in the hierarchical database structure, indexes for looking up data in the hierarchical database structure, and database schemas defining databases in the hierarchical database structure; determining that the text input does not define a path in the hierarchical database structure; selecting items in the hierarchical database structure based on the text input; presenting selectable options in a graphical user interface, wherein the selectable options are associated with the items in the hierarchical database structure; detecting selection of one of the selectable options, wherein the one of the selectable options is associated with one of the items; and presenting, in the graphical user interface, data associated with the one of the items. ### Claim 12 (depends on 11) The computer readable storage medium of claim 11, wherein the selectable options appear as text in the graphical user interface. ### Claim 13 (depends on 11) The computer readable storage medium of claim 11 wherein the operations further comprise: detecting that the text input defines a path to another one of the items in the hierarchical database structure; accessing the other one of the items by traversing the path in the hierarchical database structure; presenting, in the graphical user interface, data associated with the one of the items. ### Claim 14 (depends on 11) The computer readable storage medium of claim 11, wherein the actions include view data, query, alter, drop, view hierarchy. ### Claim 15 (depends on 11) The computer readable storage medium of claim 11, wherein the data associated with the one of the items includes one or more of: at least a portion of the database schemas, and at least a portion of the indexes.