Browse Prior Art Database

SQL Responsive Selective Filter Tree And Code Completion Mechanism

IP.com Disclosure Number: IPCOM000240279D
Publication Date: 2015-Jan-21
Document File: 5 page(s) / 152K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a method to improve current filter tree navigation by linking the tree to the code editor, so that it can be used in Structured Query Language (SQL) editing. The filter responds to only what is relevant, rather than every word the user types.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 46% of the total text.

Page 01 of 5

SQL Responsive Selective Filter Tree And Code Completion Mechanism

Structured Query Language (SQL) code assistance mechanisms can help a user fill in pieces of code, but do not preserve the structure of a database as a tree menu does. Existing mechanisms simply list elements matching the word that the user entered. Code assistance is often not discoverable (i.e. accessed only by hot key), or constantly pops up as the user types, which can be annoying and often obscures the editor. A tree navigation (or catalog navigation) does show the structure of a database, but can be overwhelming to navigate because it is static and can have many levels, as well as have many nodes open at once. This problem has been remedied by using a filter tree, in which the tree opens and closes/hides nodes based on the filter text typed by the user. However, a filter tree filters based on the entire string of characters typed into the filter box, which means that a filter tree cannot deal with multiple words typed into the filter box by ignoring some while acknowledging others. In addition, when performing multiple searches in a filter tree, the user must clear the previous search and start over to initiate a new search, which is not well suited for code editing where certain pieces of syntax need to be ignored and multiple statements can exist in the same editor.

Embodiments of the method disclosed herein provide easier and more discoverable code completion, the ability to build query syntax without typing, the ability to view relevant information in real-time while typing or building an SQL statement, and the ability to combine the tree navigation with code completion.

The method disclosed herein provides a filter tree for use in SQL editing that is linked to a code editor rather than a filter box. The tree responds only to what is relevant, rather than to every word the user types. The disclosed method provides code assistance that preserves the database structure when offering assistance and that allows the user to build SQL statements by clicking on nodes of the tree, which minimized typing. Simpler statements may be completely generated with mouse clicks. A side effect of the disclosed method is that simple SQL statements can be more easily created on a mobile device (when the technology warrants SQL editing on mobile) just by tapping on nodes.

Embodiments of the present invention give the user two ways of building SQL statements: by typing into the code editor and by clicking on objects in the tree (nodes). When a user clicks on the tree nodes, associated code is inserted into the code editor and the nodes simultaneously open and close, so the user can move up and down in the tree. If the user types the query into the editor rather than clicking on the tree, the tree responds as the user types by opening and closing/hiding nodes, ignoring pieces of the syntax that have no bearing on the nodes (e.g., keywords such as "select," "from," mathematical...