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. Barrett, R., Kandogan, E., Maglio, P. P., Haber, E. M., Takayama, L. A., Prabaker, M. Field Studies of Computer System Administrators: Analysis of System Management Tools and Practices. Proc. CSCW 2004.
3. Barrett, R., Chen, M., & Maglio, P. P. System Administrators are Users, Too: Designing Workspaces for Managing Internet-scale Systems, Workshop held at CHI 2003, Ft Lauderdale, FL, 2003.
4. Burgess, M. Cfengine: a site configuration engine, USENIX Computing systems 8, 3, (1995).
5. Burnett, M., Atwood, J., Djang, R. W., Reichwein, J., Gottfried, H., Yang, S. Forms/3: A first-order visual language to explore the boundaries of the spreadsheet paradigm. Journal of functional programming 11, 2 (March 2001), 155--206.
6. Casimir, R. Real Programmers Don't Use Spreadsheets. ACM SIGPLAN Notices 27, (June 1992), 10--16.
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. Hudson, S. User Interface Specification Using an Enhanced Spreadsheet Model, ACM Trans. On Graphics, (July 1994), 209--239.
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. Levoy, M. Spreadsheets for Images, Computer Graphics 28, (1994), 139--146.
14. Microsoft Corp, Microsoft Excel Users' Guide, Redmond, WA.
15. Myers, B. A., Graphical Techniques in a Spreadsheet for Specifying User Interfaces. Proc. CHI '91, ACM Press (1991), 243--249.
16. Myers, B. A., Pane, J. F., Ko, A. Natural Programming Languages and Environments. Communications of the ACM 47, (September 2004), 47--52.
17. Nardi B. A Small Matter of Programming: Perspectives on End User Computing. MIT Press, Cambridge, MA, USA, 1993.
18. Panko, R. What We Know About Spreadsheet Errors. Journal of End User Computing 10, (1998), 15--21.
19. PIKT, Problem Informant/Killer Tool, pikt.org
20. Smedley, T., Cox, P., Byrne, S., (1996). Expanding the Utility of Spreadsheets Through the Integration of Visual Programming and User Interface Objects, Proc. AVI '96, Gubbio, Italy, May 27-29, 1996, 148--155.
21. Spenke, M. and Beilken, C. A Spreadsheet Interface for Logic Programming. Proc. CHI '89, ACM Press (1989), 75--80.
22. Stadelman, M., A spreadsheet based on constraints. In Proc. UIST '93, ACM Press (1993), 217--224.
23. System Administrator Guild (SAGE) Salary Surveys. Available at http://www.sage.org/salsurv/ .
24. Wack, A., Partitioning Dependency Graphs for Concurrent Execution: A Parallel Spreadsheet on a Realistically Modeled Message Passing Environment, Ph.D. Thesis, Department of Computer and Information Sciences, University of Delaware, 1995.
25. Wagner, J., A One-stop Console for Administrators. http://www.internetnews.com/dev-news/article.php/3484246
26. Wilde, N. Lewis, C., Spreadsheet-based Interactive Graphics: From Prototype to Tool, Proc. CHI '90, ACM Press (1990), 153--159.
27. Yoder, A. G., Cohn, D. L. Real spreadsheets for real programmers. Proc. ICCL '94, IEEE Press (1994), 20--30.

Index Terms

• Human-centered computing

  • Human computer interaction (HCI)

    • Interaction paradigms

      • Graphical user interfaces