|InfoVis.net>Magazine>message nş 148||Published 2004-06-21|
|También disponible en Espańol|
The digital magazine of InfoVis.net
Spotfire has its ancestors in a system that experimented with the concept of dynamic queries, a little more than a decade ago. Said concept, first reported by Christopher Williamson and Ben Shneiderman in 1992*, was applied at that time to the search for homes appropriate to the requirements of their potential buyers or tenants.Â
In the words of Bob Spence in his book â€śInformation Visualizationâ€ť the problem a dynamic query solves isÂ
â€śGiven a collection of objects, each described by the values associated with a set of attributes, find the most acceptable such object or, perhaps, a small number of candidate objects worthy of more detailed consideration.â€ť
In the initial example of Williamson and Shniderâ€™s article, the set of objects was the contents of a real estate database, with thousands of homes for sale or rent; the attributes were the features of every house, square feet, number of rooms, terrace, garden, price, location, etc.
At that time (like it still is today) the process of querying a database searching for a house with at least four bedrooms, two bathrooms for less than 120.000 euros could be done using SQL, more or less like this
SELECT house FROM real_estate_database WHERE price <= 120000 AND bath = 2 AND rooms >= 4
The answer could be 0 addresses (prices are skyrocketing) or a large number of results depending on the country or region considered. In any case the results were not a huge help and required an operator that knew the query language of the database, usually intolerant to syntax errors. Moreover the results (a list of addresses) hide context information that could be useful for the buyer.Â
The solution to this problem is to realise that in many cases the users formulate a problem while at the same time try to solve it. As we are dealing with the problem and receive more information we find new ideas for our house or we discover that we donâ€™t actually need 4 rooms. In order to take this into account the dynamic queries continuously update the queries, which are done visually by means of manipulating sliders and scroll bars (see the image in the graphical version of this article), applying the principles of direct manipulation to the database:
A further and more elaborated application of these principles led to an interesting application, FilmFinder, result of the work of Chris Ahlberg and several students, that showed more than 1500 films classified by their genre (drama, comedy, horrorâ€¦), popularity, duration, author, etc and allowed the user to select by means of sliders (called alphasliders) which films appeared or disappeared according to the ranges the alphasliders allowed him/her to define.
As Shneiderman explains in â€śDynamic queries, starfield displays, and the path to Spotfireâ€ť once Ahlberg finished his PhD and developed a more commercial version of the software, he gathered together some friends and venture funding to create a company that was called IVEE Development that launched the product in 1996 with the name of Spotfire. The company itself eventually changed its name to Spotfire
Iâ€™m interested in three aspects of Spotfire:
Spotfire has become one of the (still) few pioneering companies that make a living from information visualisation, which is specially meritorious in such an emergent field where thereâ€™s still little awareness about the potential of its use.
You still can see HomeFinder in action
At number 128 we also spoke about dynamic queries.
* â€śThe dynamic HomeFinder: evaluating dynamic queries in a real-estate information exploration systemâ€ť C. Williamson & B. Shneiderman, 1992 ACM, Preceedings SIGIR'92 pp 339-346
Links of this issue:
Subscribe to the free newsletter