Browse Prior Art Database

Initialize Visual Display of Interactive Query Builder From Existing SQL Statement

IP.com Disclosure Number: IPCOM000031983D
Original Publication Date: 2004-Oct-18
Included in the Prior Art Database: 2004-Oct-18
Document File: 2 page(s) / 45K

Publishing Venue

IBM

Abstract

Disclosed is a technique for the visual display of an existing SQL statement in an interactive query building tool. You provide the SQL statement to the query builder as a simple text string. The query builder passes the string to a parser, which in turn breaks up the string into its SQL subparts. Those subparts are stored into a programmatic model representation of the SQL statement. Once in this model form, the query builder can then display the statement's various parts on the GUI.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 52% of the total text.

Page 1 of 2

Initialize Visual Display of Interactive Query Builder From Existing SQL Statement

Visual Presentation of Existing SQL Statement In Interactive Query Builder

An interactive SQL query builder is a tool which guides you in creating a SQL statement. It often provides useful views and information such as a graphical view, context-sensitive assistance and a layout which allows you to focus on one part of the statement at a time. They are used if you want to create your SQL statement from scratch. In this way, the query builder can control the creation and validation, for example, by only giving you valid choices. However, they do not allow you to initialize the query builder with an existing SQL string. The technique described herein enables users to display and modify existing SQL statements in an interactive query builder.

What follows is an example of a SQL statement that you might want to start out with:

SELECT DEPARTMENT.DEPTNO, DEPARTMENT.DEPTNAME, DEPARTMENT.MGRNO

FROM SHOLARS.DEPARTMENT DEPARTMENT

WHERE DEPARTMENT.MGRNO = '000060'

You might have chosen this statement because it is similar to the statement you want to create. Once it is displayed in the query builder, you can modify it to suit your needs.

You provide this statement to the query builder. Before it can be displayed, the query builder must understand that it is a properly formed SQL statement, so it gives this string to a SQL-aware parser. The parser reads each term in the string, checking it for syntactical validity. For our example statement, it recognizes the first term, "SELECT", as a valid SQL statement type. Knowing that it is dealing with a SELECT statement type, it knows what terms are valid after the term "SELECT." The parser breaks up the entire string into its SQL subparts.

A specialized model exis...