|
Archive@NYU >
Stern School of Business >
IOMS: Information Systems Working Papers >
Please use this identifier to cite or link to this item:
http://hdl.handle.net/2451/14260
|
| Title: | TOWARD A LOGICAL/PHYSICAL THEORY OF SPREADSHEET MODELING |
| Authors: | Isakowitz, Tomas
Schocken, Shimon
Lucas, Henry C. , Jr. |
| Keywords: | Model Management |
| Issue Date: | 28-Jul-1993 |
| Publisher: | Stern School of Business, New York University |
| Series/Report no.: | IS-93-24 |
| Abstract: | In spite of the increasing sophistication and power of commercial
spreadsheet packages, we still lack a formal theory or a methodology to
support the construction and maintenance of spreadsheet models. Using a
dual logical/physical perspective, we identify four principal components
that characterize any spreadsheet model: schema, data, editorial, and
binding. We present a factoring algorithm for identifying and extracting
these components from conventional spreadsheets with minimal user
intervention, and a synthesis algorithm that assists users in the
construction of executable spreadsheets from reusable model components.
This approach opens new possibilities for applying object-oriented and
model management techniques to support the construction, sharing, and
reuse, of spreadsheet models in organizations. Importantly, our approach
to model management and the Windows-based prototype that we have
developed are designed to coexist with, rather than replace, traditional
spreadsheet programs. In other words, the users are not required to
learn a new modeling language; instead, their logical models and data
sets are extracted from their spreadsheets transparently, as a
side-effect of using standard spreadsheet program. |
| URI: | http://hdl.handle.net/2451/14260 |
| Appears in Collections: | IOMS: Information Systems Working Papers
|
All items in Faculty Digital Archive are protected by copyright, with all rights reserved.
|
