Back to results
US 11,960,380 B2Granted
Debugging SQL statements
AssigneeRed Hat, Inc.
InventorsDavid Sariel, Arie Bregman
Life of this patent
Estimating the term…
Abstract
A method and system for debugging SQL statements by computing and saving to memory metadata for each component part of the statement. The system includes a user interface, memory, and a processor, the processor configured to compute and save to memory metadata of SQL statements. The stored metadata may be used for later computation of modified SQL statements. The metadata may also be displayed through a user interface to assist a user in the process of debugging component portions of an SQL statement.
Claims20
A method comprising:
- receiving an SQL command into an SQL editing program, the SQL command composed of a plurality of composition components, wherein each composition component defines an interaction with a database queried by the SQL command;
- computing a first set of metadata, the first set of metadata comprising a first metadata associated with a first composition component and a second metadata associated with a second composition component;
- saving to a cache memory storage the first set of metadata;
- receiving a modification to the plurality of composition components of the SQL command;
- computing a second set of metadata, the second set of metadata comprising at least a third metadata associated with a first modified composition component;
- saving to the cache memory storage the second set of metadata;
- indicating, in a first view of the SQL editing program, the composition components or the modified composition components, wherein each composition component or modified composition component is displayed with different visual characteristics;
- and
- responsive to a user selecting a composition component in the first view, retrieving the metadata associated with that composition component from the cache memory storage and displaying that metadata in a second view of the SQL editing program.
6 more elements
A system comprising:
- a computer readable storage medium;
- a user interface;
- and
- a processor, the processor configured to:
- receive an SQL command, the SQL command composed of a plurality of composition components, wherein each composition component defines an interaction with a database queried by the SQL command;
- compute a first set of metadata, the first set of metadata comprising a first metadata associated with a first composition component and a second metadata associated with a second composition component;
- save to the computer readable storage medium the first set of metadata;
- receive a modification to at least one of the plurality of composition components of the SQL command;
- compute a second set of metadata, the second set of metadata comprising at least a third metadata associated with a first modified composition component;
- save to the computer readable storage medium the second set of metadata of each modified composition component;
- indicate, in a first view of the user interface, the composition components or the modified composition components wherein the user interface is configured to display each composition component or modified composition component with different visual characteristics;
- and
- responsive to a user selecting a composition component in the command on the first view of the user interface, retrieve the metadata associated with that composition component from a cache memory storage and display that metadata in a second view of the user interface.
10 more elements
A non-transitory, machine-readable medium storing code which, when executed by a computer system, cause the computer system to:
- receive an SQL command into an SQL editing program, the SQL command composed of a plurality of composition components, wherein each composition component defines an interaction with a database queried by the SQL command;
- compute a first set of metadata, the first set of metadata comprising a first metadata associated with a first composition component and a second metadata associated with a second composition component;
- save to a cache memory storage the first set of metadata;
- receive a modification to the plurality of composition components of the SQL command;
- compute a second set of metadata, the second set of metadata comprising at least a third metadata associated with a first modified composition component;
- save to the cache memory storage the second set of metadata of each modified composition component;
- indicate, in a first view of the SQL editing program, the composition components or the modified composition components, wherein each composition component or modified composition component is displayed with different visual characteristics;
- and
- responsive to a user selecting a composition component in the first view, retrieve the metadata associated with that composition component from the cache memory storage and display that metadata in a second view of the SQL editing program.
6 more elements
Dependencies are inferred from the claim text.