TABLE-DRIVEN PROGRAMMING IN SQL FOR ENTERPRISE INFORMATION SYSTEMS

Hung-chih Yang, D. Stott Parker

Abstract

In database systems, business logic is usually implemented in the forms of external processes, stored procedures, user-defined functions, components, objects, constraints, triggers, etc. In this paper, we advocate the idea of storing business logic – in the form of functions – as data in tables. This idea gives a basis for applying the software-engineering methodology of table-driven programming in SQL. The query evaluation process then needs only to be extended with mechanical evaluation of “joined” data and functions. This approach can make understanding and maintenance of stored business logic transparent as relational data. In short, data and functions are integrated in a relational manner. Using a common enterprise application as an example, we demonstrate this methodology with an existing ORDBMS capable of storing polymorphic objects. We also discuss this approach’s shortcomings and alternatives.

References

  1. Gray, J. et al. (2003). The Lowell Report. In Halevy, A. Y., Ives, Z. G., and Doan, A., editors, SIGMOD 2003, page 680. ACM.
  2. IBM et al. (2002). IBM DB2 Universal Database SQL Reference Volume 1 Version 8. IBM.
  3. ORACLE et al. (2003). Oracle Database Application Developer's Guide - Object-Relational Features 10g Release 1 (10.1). Oracle.
  4. Stonebraker, M., Anderson, E., Hanson, E. N., and Rubenstein, W. B. (1984). Quel as a Data Type. In Yormark, B., editor, SIGMOD 1984, pages 208-214. ACM Press.
  5. Stonebraker, M., Anton, J., and Hanson, E. N. (1987). Extending a Database System with Procedures. TODS, 12(3):350-376.
  6. Witkowski, A. et al. (2003). Spreadsheets in RDBMS for OLAP. In Halevy, A. Y., Ives, Z. G., and Doan, A., editors, SIGMOD 2003, pages 52-63. ACM.
Download


Paper Citation


in Harvard Style

Yang H. and Stott Parker D. (2005). TABLE-DRIVEN PROGRAMMING IN SQL FOR ENTERPRISE INFORMATION SYSTEMS . In Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-19-8, pages 424-427. DOI: 10.5220/0002526004240427


in Bibtex Style

@conference{iceis05,
author={Hung-chih Yang and D. Stott Parker},
title={TABLE-DRIVEN PROGRAMMING IN SQL FOR ENTERPRISE INFORMATION SYSTEMS},
booktitle={Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2005},
pages={424-427},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002526004240427},
isbn={972-8865-19-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - TABLE-DRIVEN PROGRAMMING IN SQL FOR ENTERPRISE INFORMATION SYSTEMS
SN - 972-8865-19-8
AU - Yang H.
AU - Stott Parker D.
PY - 2005
SP - 424
EP - 427
DO - 10.5220/0002526004240427