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.

Monday, April 27, 2009

Recent update: ICDE trip and summer plan

I just came back from my ICDE trip in Shanghai, China. It's a great experience. Limited by time, I won't write too much about the whole thing. What I liked the most was the poster session - all full papers and shot papers were there. I had much fun talking to a lot of people about their work and my work. The direct interaction gave me much more useful information than listening to talks or giving a talk. I hope this can be carried over to SIGMOD and VLDB, too. My talk went smoothly and I had some nice discussions afterwards with a few people who were doing related work.

Re-union with old friends is always great fun. Meeting fellow graduates from U of M is always joyful. I haven't seen most of my friends from HKUST for quite some time. Many of them are now faculty or researchers. I am very happy for their accomplishments. Good luck to all of them who are about to start their new job!

In the summer, I will be interning at IBM Almaden Research Center in San Jose, California. Given the number of UM (especially dbgroup) graduates in IBM, I believe I will feel right home. From end of June to early July, I will be at SIGMOD conference in Rhode Island. It would be a nice break from the internship work.

Wednesday, December 10, 2008

Congratulations to our new PhD, Dr. Jayapandian!



Today my friend Magesh, or I should call, Dr. Jayapandian, successfully defended his thesis, "Automated Creation of Database Forms". Simply put, his work can automatically generate smart and usable search forms from a database schema (optionally data and queries) with little or no human intervention. This can either completely automate the process of form creation, or provide an initial design which humans can customize. For more details, I recommend reading his VLDB'08 paper.

Magesh is an amazing guy. Incredibly nice person, thoughtful, smart, funny, and hard-working. He is often the last to leave the lab at night and first to come in the morning. He is also the guy who brings a cake for almost everybody else's birthday or other special occasions.

I am very happy that he is finally on the other end of the tunnel, and I wish him the best for all future endeavors. I am going to miss you, my friend.

Thursday, December 4, 2008

Don't be a jerk - the takeway from the talk "how to get research funding"

Today I attended a very informative and entertaining talk given by Prof. John Laird. The theme is about how to get research funding from various government agencies and industry. I think I can summarize what I remembered here, beside the glaring title of this post:
  • be a low-maintenance, thoughtful, responsible, and useful team player, no matter it's to your program manager or collaborator (or the way John put it, "don't be a jerk")
  • do good research
  • make yourself known to the field

Saturday, November 15, 2008

"Minority-report" interface


Tom Cruise has a nice computer interface to play with in the movie "minority report". Today this has become a reality. Note that it's more than multi-touch. It recognizes spatial gestures. I can't help thinking, what does this imply for user interface and usability research?


g-speak overview 1828121108 from john underkoffler on Vimeo.

Wednesday, November 5, 2008

Election

Monday, October 27, 2008

Honor competition

Last Friday I participated the CSE graduate student honor competition, with a lot of help from my great advisor and fabulous labmates. My 2nd place in the competition really didn't do the justice to the help they gave me. If I have learned anything from this competition, they are: 1) I have a great advisor and wonderful lab-mates, 2) if you will present a talk to a general audience, practice with a general audience first, and 3) speakly clearly and slowly. The 2nd point is really what I missed. Many things I thought were easy were in fact not obvious to the audience, and I was too fast in speaking for some people to catch up.