Thursday, June 11, 2009

Spreadsheets in Google

Google recently released beta version of the two products that brings a lot of justification for my ICDE work on spreadsheet interface for a database:

Fusion tables. Using a spreadsheet interface to manipulate and collaborate on tables. Different users can upload their tables or work on the same table. Users can discuss on the table about changes made to a row or cell. Fusion tables also provide simple search facility like filtering and aggregation.



Google Squared. Squared generates tables of facts from a search. For example, US presidents. The backend technology is of course information extraction.



For both products, my work can provide additional capability of search to the spreadsheets. To be exact, my work can support a core single-block SQL query on spreadsheets, using just mouse-clicks and simple keyboard input. This capability will make both Fusion tables and squared much more useful. I suspect that Google will roll out such changes soon. Here is a snapshot of how my work would query a table. For simple filters, just one-click away. The picture actually shows a complex query where we are comparing a column with another column of aggregation results (average car price). For more details, you may refer to the ICDE'09 paper.

No comments: