Abstract
The traditional approach to relational database design starts with the conceptual design of an application based schema in a model like the Entity-relationship model, then mapping that to a logical design and eventually representing it as a set of related normalized tables. The project we present has been motivated by needs of healthcare-IT where small group practices are currently in need of systems that will cater to their dynamic requirements without depending on EMR (Electronic Medical Record) systems. It is also relevant for researchers for mining huge repositories of data such as social networks, etc. and create extracts of data on the fly for data analytics. Based on user characteristics and needs, the data is likely to vary and hence, a dynamic back-end database must be created. This paper addresses a form-based approach to schema creation and modification.
Chapter PDF
Similar content being viewed by others
References
Andany, J., Leonard, M., Palisser, C.: Management of Schema Evolution. In: VLDB, Barcelona, Spain (1991)
Brewer.E.A: Towards robust distributed systems (Invited Talk) Principles of Distributed Computing, Portland, Oregon (July 2000)
Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 6th edn. Addison Wesley (2011)
Ferrandina, F., Ferran, G.: Schema and Database Evolution in the O2 Object Database System. In: VLDB, Zurich, Switzerland (1995)
Kim, W., Ballou, N., Chou, H.T., Garza, J.F., Woelk, D.: Features of the ORION Object-Oriented Database System. In: Kim, W., Lochovsky, F.M. (eds.) Object-Oriented Concepts, Databases and Applications. ACM Press Frontier Series, New York (1989)
Kim, W., Chou, H.: Versions of schema for object oriented databases. In: VLDB, Los Angeles (1988)
Kolp, M., Zimanyi, E.: Enhanced ER to relational mapping and interrelational normalization. Informaton and Software Technology 42, 1057–1073 (2000)
Leavitt, N.: Will NoSQL Databases Live Up to Their Promise? Technology News (February 2010), http://www.leavcom.com/pdf/NoSQL.pdf (retrieved)
Miller, G.A.: WordNet: A Lexical Database for English. Communications of the ACM 38(11), 39–41 (1995)
Sasso, R.C., Reilly, T.M.: Anterior Lumbar Interbody Fusion: Threded Bone Dowels Versus Titanium Cages. In: Resnick, D.K., Haid Jr., R.W., Wang, J.C. (eds.) Surgical Management of Low Back Pain, 2nd edn. American Association of Neurosurgeons, Rolling Meadows (2008)
Skarra, A., Zdonik, S.B.: The Management of Changing Types in an Object-Oriented Database? In: OOPSLA, pp. 483–495 (1986)
Taylor, D.,Naguib, R. N. G., Boulton, S.: A Dynamic Clinical Dental Relational Database. IEEE Transactions on Information Technology in Biomedicine 8(3) (September 2004)
Zhou, L., Rundensteiner, E.A.,Shin, K.G: Schema Evolution for Real-Time Object-Oriented Databases IEEE TKDE 9(6) (November 1997)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Malhotra, K., Medhekar, S., Navathe, S.B., Laborde, M.D.D. (2014). Towards a Form Based Dynamic Database Schema Creation and Modification System. In: Jarke, M., et al. Advanced Information Systems Engineering. CAiSE 2014. Lecture Notes in Computer Science, vol 8484. Springer, Cham. https://doi.org/10.1007/978-3-319-07881-6_40
Download citation
DOI: https://doi.org/10.1007/978-3-319-07881-6_40
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-07880-9
Online ISBN: 978-3-319-07881-6
eBook Packages: Computer ScienceComputer Science (R0)