Abstract
Database schemas are an integral part of many information systems (IS). New software-engineering methods, such as software product lines, allow engineers to create a high number of different programs tailored to the customer needs from a common code base. Unfortunately, these engineering methods usually do not take the database schema into account. Particularly, a tailored client program requires a tailored database schema as well to form a consistent IS. In this paper, we show the challenges of tailoring relational database schemas in software product lines. Furthermore, we present an approach to treat the client and database part of an IS in the same way using a variable database schema. Additionally, we show the benefits and discuss disadvantages of the approach during the evolution of an industrial case study, covering a time span of more than a year.
Chapter PDF
Similar content being viewed by others
References
Apel, S., Kästner, C., Lengauer, C.: Featurehouse: Language-independent, automated software composition. In: Proc. Int’l Conf. on Software Engineering, pp. 221–231. IEEE (2009)
Apel, S., Lengauer, C.: Superimposition: A Language-Independent Approach to Software Composition. In: Pautasso, C., Tanter, É. (eds.) SC 2008. LNCS, vol. 4954, pp. 20–35. Springer, Heidelberg (2008)
Batini, C., Lenzerini, M., Navathe, S.: A comparative analysis of methodologies for database schema integration. ACM Computing Surveys 18, 323–364 (1986)
Batory, D., Sarvela, J., Rauschmayer, A.: Scaling step-wise refinement. IEEE Transactions on Software Engineering 30(6), 355–371 (2004)
Bolchini, C., Quintarelli, E., Rossato, R.: Relational Data Tailoring Through View Composition. In: Parent, C., Schewe, K.-D., Storey, V.C., Thalheim, B. (eds.) ER 2007. LNCS, vol. 4801, pp. 149–164. Springer, Heidelberg (2007)
Clements, P., Northrop, L.: Software product lines. Addison-Wesley (2001)
Czarnecki, K., Eisenecker, U.: Generative programming: Methods, tools, and applications. Addison-Wesley (2000)
Kolovos, D.S., Paige, R.F., Polack, F.A.C.: Merging Models with the Epsilon Merging Language (EML). In: Wang, J., Whittle, J., Harel, D., Reggio, G. (eds.) MoDELS 2006. LNCS, vol. 4199, pp. 215–229. Springer, Heidelberg (2006)
Dyreson, C., Florez, O.: Data aspects in a relational database. In: Proc. Int’l Conf. on Information and Knowledge Management, pp. 1373–1376. ACM (2010)
Dyreson, C., Snodgrass, R., Currim, F., Currim, S., Joshi, S.: Weaving temporal and reliability aspects into a schema tapestry. Data Knowl. Eng. 63, 752–773 (2007)
Heidenreich, F., Kopcsek, J., Wende, C.: Featuremapper: Mapping features to models. In: Comp. Proc. Int’l. Conf. on Software Engineering, pp. 943–944. ACM (2008)
Jossic, A., et al.: Model integration with model weaving: a case study in system architecture. In: Proc. Int’l. Conf. Systems Engineering and Modeling, pp. 79–84. IEEE (2007)
Kästner, C., Apel, S., Kuhlemann, M.: Granularity in software product lines. In: Proc. Int’l Conf. on Software Engineering, pp. 311–320. ACM (2008)
Kästner, C.: Cide: Decomposing legacy applications into features. In: Demonstration at Proc. Int’l. Software Product Line Conf., pp. 149–150 (2007)
Liu, J., Batory, D., Lengauer, C.: Feature-oriented refactoring of legacy applications. In: Proc. Int’l Conf. on Software Engineering, pp. 112–121. ACM (2006)
Mahnke, W.: Towards a modular, object-relational schema design. In: Doctoral Consortium at Proc. Int’l. Advanced Information Systems Engineering, pp. 61–71. Springer (2002)
Rashid, A.: A framework for customisable schema evolution in object-oriented databases. In: Proc. Int’l. Symp. on Database Engineering and Applications, pp. 342–346. IEEE (2003)
Sabetzadeh, M., Easterbrook, S.: View merging in the presence of incompleteness and inconsistency. Requir. Eng. 11(3), 174–193 (2006)
Sabetzadeh, M., Nejati, S., Liaskos, S., Easterbrook, S., Chechik, M.: Consistency checking of conceptual models via model merging. In: Proc. Int’l Conf. on Requirements Engineering, pp. 221–230. Springer, Heidelberg (2007)
Schäler, M., Leich, T., Siegmund, N., Kästner, C., Saake, G.: Generierung maßgeschneiderter Relationenschemata in Softwareproduktlinien mittels Superimposition. In: Proc. GI-Fachtagung Datenbanksysteme für Business, Technologie und Web, pp. 414–534. GI (2011)
Siegmund, N., Kästner, C., Rosenmüller, M., Heidenreich, F., Apel, S., Saake, G.: Bridging the gap between variability in client application and database schema. In: Proc. GI-Fachtagung Datenbanksysteme für Business, Technologie und Web, pp. 297–306. GI (2009)
Spaccapietra, S., Parent, C.: View integration: A step forward in solving structural conflicts. IEEE Trans. on Knowl. and Data Eng. 6(2), 258–274 (1994)
Ye, P., Peng, X., Xue, Y., Jarzabek, S.: A case study of variation mechanism in an industrial product line. In: Proc. Int’l Conf. on Software Reuse, pp. 126–136. Springer (2009)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Schäler, M., Leich, T., Rosenmüller, M., Saake, G. (2012). Building Information System Variants with Tailored Database Schemas Using Features. In: Ralyté, J., Franch, X., Brinkkemper, S., Wrycza, S. (eds) Advanced Information Systems Engineering. CAiSE 2012. Lecture Notes in Computer Science, vol 7328. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-31095-9_39
Download citation
DOI: https://doi.org/10.1007/978-3-642-31095-9_39
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-31094-2
Online ISBN: 978-3-642-31095-9
eBook Packages: Computer ScienceComputer Science (R0)