A1: end-user programming for web-based system administration

ABSTRACT

System administrators work with many different tools to manage and fix complex hardware and software infrastructure in a rapidly paced work environment. Through extensive field studies, we observed that they often build and share custom tools for specific tasks that are not supported by vendor tools. Recent trends toward web-based management consoles offer many advantages but put an extra burden on system administrators, as customization requires web programming, which is beyond the skills of many system administrators. To meet their needs, we developed A1, a spreadsheet-based environment with a task-specific system-administration language for quickly creating small tools or migrating existing scripts to run as web portlets. Using A1, system administrators can build spreadsheets to access remote and heterogeneous systems, gather and integrate status data, and orchestrate control of disparate systems in a uniform way. A preliminary user study showed that in just a few hours, system administrators can learn to use A1 to build relatively complex tools from scratch.

REFERENCES

• 1: Ambler, A. Forms: Expanding the Visualness of Sheet Languages. Workshop on Visual Languages, (Linkoping, Sweden, 1987), 105--117.
• 2: Rob Barrett , Eser Kandogan , Paul P. Maglio , Eben M. Haber , Leila A. Takayama , Madhu Prabaker, Field studies of computer system administrators: analysis of system management tools and practices, Proceedings of the 2004 ACM conference on Computer supported cooperative work, November 06-10, 2004, Chicago, Illinois, USA [doi>10.1145/1031607.1031672]
• 3: Rob Barrett , Yen-Yang Michael Chen , Paul P. Maglio, System administrators are users, too: designing workspaces for managing internet-scale systems, CHI '03 extended abstracts on Human factors in computing systems, April 05-10, 2003, Ft. Lauderdale, Florida, USA [doi>10.1145/765891.766152]
• 4: Burgess, M. Cfengine: a site configuration engine, USENIX Computing systems 8, 3, (1995).
• 5: Margaret Burnett , John Atwood , Rebecca Walpole Djang , James Reichwein , Herkimer Gottfried , Sherry Yang, Forms/3: A first-order visual language to explore the boundaries of the spreadsheet paradigm, Journal of Functional Programming, v.11 n.2, p.155-206, March 2001
• 6: Rommert J. Casimir, Real programmers don't use spreadsheets, ACM SIGPLAN Notices, v.27 n.6, p.10-16, June 1992 [doi>10.1145/130981.130982]
• 7: Clack, C., Braine, L. Object-oriented functional spreadsheets. Proc. 10th Glasgow Workshop on Functional Programming (GlaFP'97), (September 1997).
• 8: Du, W., Wadge, E. An intentional language as a basis of a 3D spreadsheet design. Proc. ICCL '88, IEEE Press (1988), 2--9.
• 9: Scott E. Hudson, User interface specification using an enhanced spreadsheet model, ACM Transactions on Graphics (TOG), v.13 n.3, p.209-239, July 1994 [doi>10.1145/195784.195787]
• 10: Hughes, C., Moshell, J. Action Graphics: A Spreadsheet-based Language for Animated Simulation. Visual Languages and Applications (T. Ichikawa, E. Jungert, R., Korfhage, eds.) Plenum Publishing (1990), New York, NY, 203--235.
• 11: Joy, William. An introduction to C Shell.
• 12: Ko, A. J., and Myers B. A. Development and evaluation of a model of programming errors. IEEE Symposia on Human-Centric Computing Languages. (Auckland, New Zealand, 2003), 7--14.
• 13: Marc Levoy, Spreadsheets for images, Proceedings of the 21st annual conference on Computer graphics and interactive techniques, p.139-146, July 1994 [doi>10.1145/192161.192190]
• 14: Microsoft Corp, Microsoft Excel Users' Guide, Redmond, WA.
• 15: Brad A. Myers, Graphical techniques in a spreadsheet for specifying user interfaces, Proceedings of the SIGCHI conference on Human factors in computing systems: Reaching through technology, p.243-249, April 27-May 02, 1991, New Orleans, Louisiana, United States [doi>10.1145/108844.108903]
• 16: Brad A. Myers , John F. Pane , Andy Ko, Natural programming languages and environments, Communications of the ACM, v.47 n.9, September 2004 [doi>10.1145/1015864.1015888]
• 17: Bonnie A. Nardi, A small matter of programming: perspectives on end user computing, MIT Press, Cambridge, MA, 1993
• 18: Raymond R. Panko, What we know about spreadsheet errors, Journal of End User Computing, v.10 n.2, p.15-21, Spring 1998
• 19: PIKT, Problem Informant/Killer Tool, pikt.org
• 20: Trevor J. Smedley , Philip T. Cox , Shannon L. Byrne, Expanding the utility of spreadsheets through the integration of visual programming and user interface objects, Proceedings of the workshop on Advanced visual interfaces, May 27-29, 1996, Gubbio, Italy [doi>10.1145/948449.948473]
• 21: M. Spenke , C. Beilken, A spreadsheet interface for logic programming, Proceedings of the SIGCHI conference on Human factors in computing systems: Wings for the mind, p.75-80, March 1989
• 22: Marc Stadelmann, A spreadsheet based on constraints, Proceedings of the 6th annual ACM symposium on User interface software and technology, p.217-224, December 1993, Atlanta, Georgia, United States [doi>10.1145/168642.168664]
• 23: System Administrator Guild (SAGE) Salary Surveys. Available at http://www.sage.org/salsurv/ .
• 24: Andrew P. Wack, Partitioning dependency graphs for concurrent execution: a parallel spreadsheet on a realistically modeled message passing environment, University of Delaware, Newark, DE, 1996
• 25: Wagner, J., A One-stop Console for Administrators. http://www.internetnews.com/dev-news/article.php/3484246
• 26: Nicholas Wilde , Clayton Lewis, Spreadsheet-based interactive graphics: from prototype to tool, Proceedings of the SIGCHI conference on Human factors in computing systems: Empowering people, p.153-160, April 01-05, 1990, Seattle, Washington, United States [doi>10.1145/97243.97268]
• 27: Yoder, A. G., Cohn, D. L. Real spreadsheets for real programmers. Proc. ICCL '94, IEEE Press (1994), 20--30.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.5 INFORMATION INTERFACES AND PRESENTATION (I.7)
      H.5.2 User Interfaces (D.2.2, H.1.2, I.3.6)
          Subjects: Graphical user interfaces (GUI)

General Terms:
Management

Keywords:
end-user programming, spreadsheets, system management, web-portal user interfaces