Patent ID: 8726177

Claim:
A method for generating a database query, comprising: displaying, using one or more data processors, one or more selectable icons on an interface, wherein the one or more selectable icons correspond to tables and database operations; receiving a selection of an icon representing a database operation, wherein the selection of the icon causes a drill-down operation to be performed on the database operation, wherein the drill-down operation causes the representation of the selected icon to be replaced with a new representation of the selected icon in a new interface, and wherein the new representation of the selected icon includes one or more selectable sub-operation icons corresponding to sub-operations of the database operation; in response to receiving the selection of the icon, generating, using one or more data processors, a new interface corresponding to the drill-down operation, wherein the new interface includes a creation region, and wherein the creation region includes the one or more selectable sub-operation icons corresponding to sub-operations of the database operation; receiving a selection in the creation region corresponding to a sub-operation icon, wherein selecting the sub-operation icon causes a further drill-down operation to be performed on the corresponding sub-operation; generating an additional interface corresponding to the further drill-down operation, wherein the additional interface is configured to receive definition data for the corresponding sub-operation; receiving the definition data for the corresponding sub-operation; and transmitting a command to execute the database operation, wherein the database operation is executed using the definition data.