Supporting database access in the Hermes programming language

ABSTRACT

The work reported in this paper is part of a project aimed at designing and prototyping an application development environment that allows easy development of platform-independent distributed applications. The main goals of the database subproject are to investigate methods for (1) providing (SQL) database access and (2) supporting transaction management within a distributed programming environment based on the paradigm of communicating sequential processes. This paper looks at how SQL database access can be provided in Hermes, a new language for distributed programming based on this paradigm. The paper compares the characteristics of Hermes and SQL tables, discusses potential ways of supporting database access in Hermes, and then defines an embedding of SQL in Hermes. Some implementation aspects are also discussed.

REFERENCES

• 1: ANSI-ISO, Database Language - SQL with Integrity Enhancement, ISO 9075-1989/ANSI X3.135-1989.
• 2: ANSI-ISO, Database Language SQL2, ANSI X3H2, ISO/IEC JTC1 SC21 WG3 N985 (DBL SLC-1/SEL-2), December 1989.
• 3: IBM, SQL/Data System: Application Programming for IBM VM Systems, Version 3 Release 2, 1991.
• 4: ISO, Information Technology - Open Systems Interconnection - Remote Database Access - Part 1: Generic, ISO/IEC DP 9579-1, October 1990.
• 5: ISO, Information Technology - Open Systems Interconnection - Remote Database Access - Part 2: SQL Specialization, ISO/IEC DP 9579-2, October 1990.
• 6: D. P. Bradshaw et al., Transaction Management in Hermes using Camelot, Technical Report (in preparation), Department of Computer Science, University of Waterloo, 1991.
• 7: P. Dadam , K. Kuespert , F. Andersen , H. Blanken , R. Erbe, A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchies, Proceedings of the 1986 ACM SIGMOD international conference on Management of data, p.356-367, May 28-30, 1986, Washington, D.C., United States
• 8: P. Larson, The data model and query language of LauRel, Data Engineering, v.11 n.3, p.23-30, September 1988
• 9: Mark A. Roth , Henry F. Korth , Don S. Batory, Sql/nf: a Query Language for ~1NF Relational Databases, University of Texas at Austin, Austin, TX, 1985
• 10: Robert E. Strom , David F. Bacon , Arthur P. Goldberg , Andy Lowry , Daniel M. Yellin , Shaula Alexander Yemini, Hermes: a language for distributed computing, Prentice-Hall, Inc., Upper Saddle River, NJ, 1991

INDEX TERMS

Keywords:
Hermes, SQL, database access, distributed applications