Webformulate: a web-based visual continual query system

ABSTRACT

Today there is a plethora of data accessible via the Internet. The Web has greatly simplified the process of searching for, accessing, and sharing information. However, a considerable amount of Internet-distributed data still goes unnoticed and unutilized, particularly in the case of frequently-updated, Internet-distributed databases. In this paper we give an overview of WebFormulate, a Web-based visual continual query system that addresses the problems associated with formulating temporal ad hoc analyses over networks of heterogeneous, frequently-updated data sources. The main distinction between this system and existing Internet facilities to retrieve information and assimilate it into computations is that WebFormulate provides the necessary facilities to perform continual queries, developing and maintaining dynamic links such that Web-based computations and reports automatically maintain themselves. A further distinction is that this system is specifically designed for users of spreadsheet-level ability, rather than professional programmers.

REFERENCES

• 1: T. Catarci and M. Costabile (eds.), "Special Issue on Visual Query Languages", Journal of Visual Languages and Computing, 6(1), 1995.
• 2: T. Catarci, M. Costabile, S. Levialdi, and C. Batini, "Visual Query Systems for Databases: A Survey", Technical Report SI/RR-95/17, Dipartimento di Scienze dell'Informazione, Universita' di Roma "La Sapienza", 1995.
• 3: T. Catarci , M. F. Costabile , A. Massari , L. Saladini , G. Santucci, A multiparadigmatic environment for interacting with databases, ACM SIGCHI Bulletin, v.28 n.3, p.89-96, July 1996 [doi>10.1145/231132.231151]
• 4: L. Liu, C. Pu, W. Tang, and W. Han, "CONQUER: A Continual Query System for Update Monitoring in the WWW", Special edition on Web Semantics, International Journal of Computer Systems, Science, and Engineering, 1999.
• 5: Douglas Terry , David Goldberg , David Nichols , Brian Oki, Continuous queries over append-only databases, Proceedings of the 1992 ACM SIGMOD international conference on Management of data, p.321-330, June 02-05, 1992, San Diego, California, United States
• 6: U. Dayal , B. Blaustein , A. Buchmann , U. Chakravarthy , M. Hsu , R. Ledin , D. McCarthy , A. Rosenthal , S. Sarin , M. J. Carey , M. Livny , R. Jauhari, The HiPAC project: combining active databases and timing constraints, ACM SIGMOD Record, v.17 n.1, p.51-70, March, 1988 [doi>10.1145/44203.44208]
• 7: Ulf Schreier , Hamid Pirahesh , Rakesh Agrawal , C. Mohan, Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS, Proceedings of the 17th International Conference on Very Large Data Bases, p.469-478, September 03-06, 1991
• 8: M. Hsu, R. Ladin, and D. McCarthy, "An Execution Model for Active Database Management Systems", in Proceedings of the 3rd International Conference on Data and Knowledge Bases - Improving Usability and Responsiveness, 1988.
• 9: J. Widom and S. Ceri, Active Database Systems, Morgan-Kaufman, 1996.
• 10: Dennis McCarthy , Umeshwar Dayal, The architecture of an active database management system, Proceedings of the 1989 ACM SIGMOD international conference on Management of data, p.215-224, June 1989, Portland, Oregon, United States
• 11: Informix Software, Inc., Informix Guide to SQL: Syntax (Version 6.0), 1994.
• 12: Ling Liu , Calton Pu , Wei Tang, Continual Queries for Internet Scale Event-Driven Information Delivery, IEEE Transactions on Knowledge and Data Engineering, v.11 n.4, p.610-628, July 1999 [doi>10.1109/69.790816]
• 13: Jianjun Chen , David J. DeWitt , Feng Tian , Yuan Wang, NiagaraCQ: a scalable continuous query system for Internet databases, Proceedings of the 2000 ACM SIGMOD international conference on Management of data, p.379-390, May 15-18, 2000, Dallas, Texas, United States
• 14: Y. Chen, K. Lwin, and S. Williams, "Continuous Query Processing and Dissemination", http://www.cs.berkeley.edu/~kubitron/courses/cs252-F99/projects/reports/project8 report.pdf.
• 15: T. Palmer and J. Leopold, "CQServer: An Example of Applying a Distributed Object Infrastructure for Heterogeneous Enterprise Computation of Continual Queries", (submitted in November 2001) ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, Madison, Wisconsin, June 2002.
• 16: A. Deutsch, M. Fernandez, D. Florescu, A. Levy, D. Suciu, "XML-QL: A Query Language for XML", http://ww.w3.org/TR/NOTE-xml.ql.
• 17: A. Ambler and A. Broman, "Formulate Solution to the Visual Programming Challenge," in Journal of Visual Languages and Computing, 9(2), April, 1998, pp. 171--209.
• 18: Jennifer L. Leopold , Allen L. Ambler, A User Interface for the Visualization and Manipulation of Arrays, Proceedings of the 1996 IEEE Symposium on Visual Languages, p.54, September 03-06, 1996
• 19: Jennifer Lynn Leopold , Allen Ambler, A multimodal user interface for a visual programming language, 1999
• 20: Guijun Wang , A. Ambler, Invocation polymorphism, Proceedings of the 11th International IEEE Symposium on Visual Languages, p.83, September 05-09, 1995
• 21: Guijun Wang , Allen Ambler, Solving Display-Based Problems, Proceedings of the 1996 IEEE Symposium on Visual Languages, p.122, September 03-06, 1996
• 22: G. Viehstaedt and A. Ambler, "Visual Representation and Manipulation of Matrices", in Journal of Visual Languages and Computing, Volume 3, 1992, pp. 273--298.
• 23: Carlo Batini , Tiziana Catarci , Maria Francesca Costabile , Stefano Levialdi, Visual Query Systems: A Taxonomy, Proceedings of the IFIP TC2/WG 2.6 Second Working Conference on Visual Database Systems II, p.153-168, September 30-October 03, 1991
• 24: Richard Monson-Haefel, Enterprise JavaBeans, O'Reilly & Associates, Inc., Sebastopol, CA, 1998

INDEX TERMS

Primary Classification:
  D. Software
  D.1 PROGRAMMING TECHNIQUES
      D.1.7 Visual Programming

General Terms:
Languages

Keywords:
continual query, visual programming language, visual query system