TABLE-DRIVEN PROGRAMMING IN SQL FOR ENTERPRISE INFORMATION SYSTEMS

Hung-chih Yang, D. Stott Parker

2005

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.

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