Graphical modeling of database query statements

摘要

Example embodiments involve a system, computer-readable storage medium storing at least one program, and computer-implemented method for graphical modeling and editing of database query statements. The method may include accessing a database query statement, and generating an abstract syntax tree (AST) representing a syntactic structure of the database query statement. The method may further include generating a graphical model of the database query statement based on the AST, and rendering the graphical model.

主权项

1. A method comprising:
accessing a database query statement, the database query statement being an executable instruction expressing an action to be performed with respect to a database; generating, using one or more processors, an abstract syntax tree (AST) corresponding to the database query statement, the AST being a data structure representing a syntactic structure of the database query statement; generating a domain model using the AST, the domain model describing elements of the database query statement and roles and relationships of each element; generating a graphical model of the database query statement using the domain model, the graphical model being a graphical representation of the structure of the database query statement; and causing presentation of the graphical model of the database query statement on a client device.