A spreadsheet algebra for a direct data manipulation query interface

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2009, Pages 417-428

  Liu, Bin ^a   Jagadish, H V ^a  

^a The Department of Civil and Environmental Engineering   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATA MANIPULATIONS; DIRECT MANIPULATION; DIRECT MANIPULATION INTERFACES; EXPRESSIVE POWER; INTERMEDIATE RESULTS; MULTI-SETS; ONE STEP; PROTOTYPE IMPLEMENTATIONS; QUERY EXPRESSION; QUERY INTERFACES; QUERY MODIFICATION; SQL QUERY; TECHNICAL DATABASE; TECHNICAL SUBJECTS; USER STUDY; VISUAL QUERY;

ALGEBRA; SOFTWARE PROTOTYPING;

SPREADSHEETS;

EID: 67649651679     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2009.34     Document Type: Conference Paper

References (30)

1. B. Shneiderman, "The future of interactive systems and the emergence of direct manipulation," Behaviour & Information Technology, vol. 1, no. 3, pp. 237-256, 1982.
2. -,"Direct manipulation: a step beyond programming languages," IEEE Computer, vol. 16, no. 8, pp. 57-69, 1983.
3. -,"A computer graphics system for polynomials," The Mathematics Teacher, vol. 67, no. 2, pp. 111-113, 1974.
4. J. Ullman, Principles of database and knowledge-base systems, Vol. 1. Computer Science Press, Inc. New York, NY, USA, 1988.
5. R. Ramakrishnan and J. Gehrke, Database management systems. McGraw-Hill Boston, 2003.
6. A. V. Aho and J. D. Ullman, "Universality of data retrieval languages," in ACM POPL, 1979.
7. A. Witkowski, S. Bellamkonda, T. Bozkaya, A. Naimat, L. Sheng, S. Subramanian, and A. Waingold, "Query by excel," in VLDB, 2005, pp. 1204-1215.
8. J. Ullman, Principles of database and knowledge-base systems, Vol. 2. Computer Science Press, Inc. New York, NY, USA, 1988.
9. "Database usability research at university of michigan," http://www.eecs.umich.edu/db/usable/.
10. "Navicat," http://pgsql.navicat.com/.
11. "Transaction processing performance council." TPC-H Benchmark Specification, Version 2.6.1.
12. M. Kuntz and R. Melchert, "Pasta-3's graphical query language: Direct manipulation, cooperative queries, full expressive power," in VLDB, 1989, pp. 97-105.
13. A. Aiken, J. Chen, M. Stonebraker, and A. Woodruff, "Tioga-2: A direct manipulation database visualization environment," in ICDE, 1996, pp. 208-217.
14. C. Olston, A. Woodruff, A. Aiken, M. Chu, V. Ercegovac, M. Lin, M. Spalding, and M. Stonebraker, "Datasplash," in SIGMOD, 1998, pp. 550-552.
15. M. Spenke, C. Beilken, and T. Berlage, "Focus: The interactive table for product comparison and selection," in UIST, 1996, pp. 41-50.
16. "Tableau software," http://www.tableausoftware.com/.
17. P. Hanrahan, "Vizql: a language for query, analysis and visualization," in SIGMOD, 2006, p. 721.
18. V. Raman and J. M. Hellerstein, "Potter's wheel: An interactive data cleaning system," in VLDB, 2001, pp. 381-390.
19. M. Spenke and C. Beilken, "A spreadsheet interface for logic programming," in CHI, 1989, pp. 75-80.
20. T. J. Jankun-Kelly and K.-L. Ma, "A spreadsheet interface for visualization exploration," in IEEE Visualization, 2000, pp. 69-76.
21. S. Kandel, A. Paepcke, M. Theobald, and H. Garcia-Molina, "The photospread query language," Stanford Univ., Tech. Rep., 2007.
22. A. Witkowski, S. Bellamkonda, T. Bozkaya, G. Dorman, N. Folkert, A. Gupta, L. Sheng, and S. Subramanian, "Spreadsheets in rdbms for olap," in SIGMOD, 2003.
23. "Zoho db & reports," http://db.zoho.com/.
24. "Dabble db - online database," http://dabbledb.com/.
25. M. M. Zloof, "Query-by-example: the invocation and definition of tables and forms," in VLDB, 1975, pp. 1-24.
26. T. Catarci and G. Santucci, "Query by diagram: A graphical environment for querying databases," in SIGMOD, 1994, p. 515.
27. T. Catarci, M. F. Costabile, S. Levialdi, and C. Batini, "Visual query systems for databases: A survey," J. Vis. Lang. Comput., vol. 8, no. 2, pp. 215-260, 1997.
28. T. Catarci, P. Dongilli, T. D. Mascio, E. Franconi, G. Santucci, and S. Tessaris, "An ontology based visual tool for query formulation support," in ECAI, 2004, pp. 308-312.
29. C. E. Scheidegger, H. T. Vo, D. Koop, J. Freire, and C. Silva, "Querying and re-using workflows with vistrails," in ACM SIGMOD, 2008.
30. C. Koch, "A visual query language for complex-value databases," ArXiv Computer Science e-prints, 2006.