Standard database reporting tools only offer people pre-programmed queries, or expect users to know query languages. iQuery Touch is a visual system, where people can create queries by dragging tables, joining rows by dragging them both, erasing columns from a query result, order a column by dragging up or down, etc. People do not need to learn a query language such as SQL, but can intuitively do all operations offered by the database. The system is implemented on a dual-touch wall display.
To start with a new database, people should first pick out the right tables from the bottom bar. In this bar all the database tables are listed, and people can pick a new table from it at any time. After picking the right tables, the complete table and the corresponding columns are visible in the screen. Now, you can easily drag and drop a table to the result table. The result table is the main interface element in the center of the screen and contains the results of the last performed query. In the result table people can perform the database operations like ORDER BY, GROUP BY and removing single rows or columns by doing simple intuitive gestures. Undo and redo operations can be performed by doing respectively a left or right circle gesture. The undo and redo states are visible in the upper right corner of the screen.
The iQuery Touch project exist of 3204 lines of C++ code and is implemented with Microsoft Visual Studio 2008. The following external libraries were used: SQLite, Agar, SBSDK, Freetype and pthreads_w32.