Abstract
We propose a method and a modeling tool for the design of relational databases. This conceptual design technique incorporates, from the earliest design stages, both database behavior and the existence of multiple user views of the database. It utilizes the structure and capabilities of parameterized Petri nets (PPNs) described in [2]. Petri nets are traditionally found useful for describing conditions and events that constitute a dynamic system. Parameterized Petri nets are (non-strictly) heirarchical or multi-level, and have a parameterization capability which is used to develop differing useful system views (PPNviews) of the relational database structure and dynamics.
Using Petri nets in general and PPNs in particular, users may create models that describe the flow of work or the transformations that take place in the system at an intuitive, comfortable level of detail. This produces one view of the system (PPNview). Different users with detailed knowledge about particular segments or aspects of the system will be able to design PPNviews showing those sections in great detail while leaving the less familiar segments less detailed. A set of normalized relations produced by traditional methods is the basis (parameterization descriptor) for a different PPNview. This PPNview depicts the transactions that occur in the system connected to the normalized relations that participate in the transaction.
Preview
Unable to display preview. Download preview PDF.
References
S. Gatziu and K. R. Dittrich. Events in Active Object Oriented Database System. In Proceedings of the First International Workshop on Rules in Database Systems, Edinburgh, Great Britain, 1993.
D. Gračanin, P. Srinivasan, and K. P. Valavanis. Parameterized Petri Nets and Their Application to Planning and Coordination in Intelligent Systems. IEEE Transactions on Systems, Man and Cybernetics, 24(10):1483–1497, October 1994.
K. Keith, P. Srinivasan, and R. George. Modeling Behavior in Fuzzy Object-Oriented Databases. In Proceedings of the North American Fuzzy Information Processing Society Conference, 1993.
C.-H. Kung and A. Solvberg. Information System Engineering: An Introduction. Springer-Verlag, Berlin, New York, 1993.
J. L. Peterson. Petri net Theory and the Modeling of Systems. Prentice-Hall, Englewood Cliffs, NJ, 1981.
N. Pissinou, A. I. Kokkinaki, and D. Gračanin. On Modeling Active Databases using Parameterized Petri Nets. Technical Report TR-94-6-1, CACS, University of Southwestern Louisiana, Lafayette, LA, 1994.
A. K. Tanaka. On Conceptual Design of Active Databases. PhD thesis, Georgia Institute of Technology, 1992.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1995 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Hands, P.S., Srinivasan, A., Vignes, G.M. (1995). Database design with behavior and views using parameterized Petri nets. In: Papazoglou, M.P. (eds) OOER '95: Object-Oriented and Entity-Relationship Modeling. ER 1995. Lecture Notes in Computer Science, vol 1021. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0020529
Download citation
DOI: https://doi.org/10.1007/BFb0020529
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-60672-7
Online ISBN: 978-3-540-48527-8
eBook Packages: Springer Book Archive