# US 2014/0208293 A1 · SQL Visualizer

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2014/0208293 A1
- Document ID: US20140208293A1
- Status: Published application
- Kind: A1
- Application number: 13/746,895
- Filed: 2013-01-22
- Published: 2014-07-24
- Earliest claimed: 2013-01-22
- Assignees: Microgen Aptitude Limited
- Inventors: Grzegorz Roman Pusz; Neil Thomson
- Web page: https://patentgrep.com/patent/US20140208293A1

## CPC

- G06F 8/34: Graphical or visual programming
- G06F 8/73: Program documentation
- G06F 16/2428: {Query predicate definition using graphical user interfaces, including menus and forms (G06F16/2423 takes precedence)}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A SQL Visualizer including means for transforming a textual SQL statement into a graphical diagram which represents the textual SQL statement.

## Claims

### Claim 1

A SQL Visualizer comprising means for transforming a textual SQL statement into a graphical diagram which represents said textual SQL statement.

### Claim 2 (depends on 1)

A SQL Visualizer as claimed in claim 1, wherein said graphical diagram which represents said textual SQL statement is an Aptitude SQL Rule.

### Claim 3 (depends on 1)

A SQL Visualizer as claimed in claim 1, which further comprises means for transforming a textual DML statement into a graphical diagram which represents said textual DML statement.

### Claim 4 (depends on 3)

A SQL Visualizer as claimed in claim 3, wherein said graphical diagram which represents said textual DML statement is an Aptitude SQL Rule.

### Claim 5 (depends on 1)

A SQL Visualizer as claimed claim 1, wherein said graphical diagram which represents said textual SQL statement and said graphical diagram which represents said textual DML statement are both contained in the same Aptitude SQL Rule.

### Claim 6 (depends on 1)

A SQL Visualizer as claimed in claim 1, which further comprises means for transforming a textual SQL procedure into a graphical diagram which represents said textual SQL procedure.

### Claim 7 (depends on 6)

A SQL Visualizer as claimed in claim 6, wherein said graphical diagram which represents said textual SQL procedure is an Aptitude SQL Procedure.

### Claim 8 (depends on 7)

A SQL Visualizer as claimed in claim 7, wherein if said textual SQL procedure contains embedded SQL statements, said means for transforming a textual SQL procedure into a graphical diagram automatically produces separate Aptitude SQL Rules corresponding with said embedded SQL statements, that are placed within the Aptitude SQL Procedure.

### Claim 9 (depends on 1)

A SQL Visualizer as claimed in claim 1, which further comprises means for transforming a textual DDL command into a graphical diagram which represents said textual DDL command.

### Claim 10 (depends on 9)

A SQL Visualizer as claimed in claim 9, wherein said graphical diagram which represents said textual DDL command is an Aptitude SQL Procedure.

### Claim 11 (depends on 7)

A SQL Visualizer as claimed in claim 7, wherein said graphical diagram which represents said textual DDL command is an Aptitude SQL Procedure and wherein said graphical diagram which represents said textual SQL procedure and said graphical diagram which represents said textual DDL command are both contained in the same Aptitude SQL Procedure.

### Claim 12 (depends on 1)

A SQL Visualizer as claimed in claim 1, which further comprises a user interface comprising an editor into which a user may place textual elements prior to their conversion graphical form.

### Claim 13 (depends on 12)

A SQL Visualizer as claimed in claim 12, wherein said editor is arranged to receive textual SQL statements, DML statements, SQL procedures and/or DDL commands.

### Claim 14 (depends on 12)

A SQL Visualizer as claimed in claim 12, wherein said user interface comprises a dictionary selection control which allows a user to select a database used in said textual SQL statement, and to thereby provide a definition for said database for use in transforming said textual SQL statement into said graphical diagram which represents said textual SQL statement.

### Claim 15 (depends on 14)

A SQL Visualizer as claimed in claim 14, wherein said dictionary selection control allows selection of at least one of the following: Project EDF (External Data Format), Data Schema, and Database Server.

### Claim 16 (depends on 1)

A SQL Visualizer as claimed in claim 1, which also allows a user to create textual SQL statements and SQL procedures from graphical Aptitude SQL Rules and SQL Procedures.

### Claim 17 (depends on 16)

A SQL Visualizer as claimed in claim 16, which allows a user to switch between textual and graphical representations of the same SQL statement or SQL procedure.

### Claim 18 (depends on 1)

A SQL Visualizer as claimed in claim 1, in which a user can make changes to either the graphical or the textual representation of a SQL statement or SQL procedure, and the SQL Visualizer can then automatically generate the other of the graphical or the textual representation such that the same change is incorporated in both the textual representation and the graphical representation.

### Claim 19 (depends on 18)

A SQL Visualizer as claimed in claim 18, wherein said graphical and textual representations are automatically synchronized.

### Claim 20

A SQL Visualizer comprising a transformer for transforming a textual SQL statement into a graphical diagram which represents said textual SQL statement.