Transactions in ORM
Languages for specifying information systems should not only contain a data definition (sub)language (DDL), i.e., a part for specifying data structures, but also a data retrieval (sub)language (DRL), i.e., a part for specifying queries, and a data manipulation (sub)language (DML), i.e., a part for specifying transactions.
The language ORM contains a DDL and a DRL (ConQuer), but it does not contain a sufficient DML as yet. We therefore propose an extension of ORM with a DML, for specifying transactions to be easily validated by domain experts.
We introduce the following set of standard classes of specifiable transactions: add an instance, add a query result, remove a subset, and change a subset. We also treat compound transactions in ORM.
In ORM there are usually several ways to specify something. For all transactions we therefore propose syntaxes, verbalizations, and diagrams as well. They allow for type-checking and easy validation by domain experts.
KeywordsORM DML transaction add remove change syntax verbalization diagram compound transaction
Unable to display preview. Download preview PDF.
- 1.Halpin, T., Morgan, T.: Information Modeling and Relational Databases. Morgan Kaufmann, San Francisco (2008)Google Scholar
- 4.Balsters, H., Halpin, T.: Formal Semantics of Dynamic Rules in ORM. In: Meersman, R., et al. (eds.) OTM Workshops 2008. LNCS, vol. 5333, pp. 699–708. Springer, Heidelberg (2008)Google Scholar
- 5.de Brock, E.O.: Foundations of Semantic Databases. Prentice Hall International Series in Computer Science, Hemel Hempstead (1995)Google Scholar