Abstract
Although conceptual data modelers can ”get creative” when designing entities and relationships to meet business requirements, they are highly constrained by the business rules which determine the details of how the entities and relationships combine. Typically, there is a delay in realising which business rules might be relevant and a further delay in obtaining an authoritative statement of these rules. We identify circumstances under which viable database designs can be constructed from conceptual data models which are incomplete in the sense that they lack this “infrastructural” detail normally obtained from the business rules. As such detail becomes available, our approach allows the conceptual model to be incrementally refined so that each refinements can be associated with standard database refactorings, minimising the impact on database operations. Our incremental approach facilitates the implementation of the database earlier in the development cycle.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Ambler, S., Sadalage, P.J.: Refactoring Databases: Evolutionary Database Design. Addison Wesley (2006)
Do Nascimento Fidalgo, R., De Souza, E.M., España, S., De Castro, J.B., Pastor, O.: EERMM: A Metamodel for the Enhanced Entity-Relationship Model. In: Atzeni, P., Cheung, D., Ram, S. (eds.) ER 2012 Main Conference 2012. LNCS, vol. 7532, pp. 515–524. Springer, Heidelberg (2012)
Galindo, J., Urrutia, A., Carrasco, R.A., Piattini, M.: Relaxing constraints in enhanced entity-relationship models using fuzzy quantifiers. IEEE T. Fuzzy Systems 12, 780–796 (2004)
Golfarelli, M., Rizzi, S., Turricchia, E.: Sprint planning optimization in agile data warehouse design. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2012. LNCS, vol. 7448, pp. 30–41. Springer, Heidelberg (2012)
Larman, C., Basili, V.R.: Iterative and Incremental Development A Brief History. Computer 36, 47–56 (2003)
Ma, Z.M., Yan, L.: A Literature overview of fuzzy conceptual data modeling. Journal of Information Science And Engineering 26, 427–441 (2010)
Salay, R., Chechik, M., Horkoff, J.: Managing Requirements Uncertainty with Partial Models. In: Proc. of Requirements Engineering, pp. 1–10 (2012)
Teorey, T., Lightstone, S., Nadeau, T.: Database Modeling and Design: Logical Design, 4th edn. Morgan Kaufmann, San Francisco (2006)
Thalheim, B.: The science and art of conceptual modelling. In: Hameurlain, A., Küng, J., Wagner, R., Liddle, S.W., Schewe, K.-D., Zhou, X. (eds.) Transactions on Large-Scale Data- and Knowledge-Centered Systems VI. LNCS, vol. 7600, pp. 76–105. Springer, Heidelberg (2012)
Thalheim, B., Wang, Q.: Towards a theory of refinement for data migration. In: Jeusfeld, M., Delcambre, L., Ling, T.-W. (eds.) ER 2011. LNCS, vol. 6998, pp. 318–331. Springer, Heidelberg (2011)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Thanisch, P., Niemi, T., Nummenmaa, J., Zhang, Z., Niinimäki, M., Saariluoma, P. (2013). Incompleteness in Conceptual Data Modelling. In: Skersys, T., Butleris, R., Butkiene, R. (eds) Information and Software Technologies. ICIST 2013. Communications in Computer and Information Science, vol 403. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-41947-8_15
Download citation
DOI: https://doi.org/10.1007/978-3-642-41947-8_15
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-41946-1
Online ISBN: 978-3-642-41947-8
eBook Packages: Computer ScienceComputer Science (R0)