Patent Document ID: 8375014
Application ID: 12488506

Base Claim:
1. A system comprising: one or more processors; a database schema including a plurality of data sources, each data source including one or more fields for storing data, and metadata defining relationships amongst the fields within or between data sources; a schema parser executed by at least one of the processors and configured to determine one or more datasets of data stored within or referenced from the database schema, wherein a dataset includes one or more fields from the database schema and represents the data stored in the one or more fields; an input handler executed by at least one of the processors and configured to receive a user's selection of one or more of the datasets via a graphical user interface, wherein the input handler is configured to determine that a first graphical icon representing a first dataset is graphically associated within the graphical user interface with a second graphical icon representing a second dataset; a translation engine executed by at least one of the processors and configured to provide, responsive to the graphical association of the first and second icons, operations for refining the data of the selected datasets into a result set via a query, wherein the translation engine is configured to determine which operations to provide based on the relationships of the selected datasets as stored or derived from the metadata, wherein the translation engine is configured to provide the operations to a user via the interface, wherein the operations are provided in a natural language expression corresponding to the relationships as determined from the metadata, wherein the input handler is configured to receive a selection of one of the operations provided by the translation engine; a query engine executed by at least one of the processors and configured to provide a graphical depiction of the query via the interface, the graphical query including operational flow indicators indicating a directional flow of the query from the selected datasets with the selected operation resulting in the result set; and a logic engine executed by at least one of the processors and configured to assemble a machine readable structured query language (SQL) query based on the graphical depiction of the query, wherein the logic engine comprises a plurality of different subroutines, each different subroutine being configured to process a different type of operation represented by a particular type of element in the graphical query to generate a SQL substatement of the elements's operation wherein the logic engine is further configured to incorporate the SQL substatements into a complete machine readable SQL query.

---

Claim 5:
5. The system of claim 1 , wherein, in response to the input handler receiving a selection of one of the provided operations, the query engine is configured to provide a graphical depiction of the query via the interface, the graphical query including a third icon representing a third dataset formed in response to the selected operation, the third icon being connected to the first and second icons by one or more operational flow indicators indicating a directional flow of the query from the first and second datasets to the third dataset.