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

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. What follows is the process flow involved in this disclosure: Existing SQL statement ---> SQL Parser --> Model Representation of SQL Statement --> User Interface of Interactive Query Builder-->Display Query Graphically