Abstract
The database (DB) is one of the active communities dealing with the non-functional requirements (NFRs) when designing advanced applications. The fulfillment of the NFRs is usually performed along the phases of DB life cycle in an isolated way. The physical design phase took the lion’s share of these studies, because it is an important factor for a successful DB deployment in terms of performance metrics. By carefully analyzing these studies, we figure out that target DBs are assumed to be already deployed, meaning that their logical models are frozen. This assumption surely becomes questionable, since it ignores the chained aspect of the life cycle. Knowing that many variants of a logical schema may exist due to the presence of dependencies and hierarchies among attributes; it is worth studying the impact of this variation on the physical design. In this paper, we firstly identify the dimensions of the variability of a logical schema and their modeling. Secondly, we propose a methodology, by highlighting the efforts that designers have to make, to evaluate the impact of the logical schema variability on the physical design (by considering logical or physical optimization), where both energy consumption and query performance are considered. Finally, intensive experiments are conducted to evaluate our proposal and the obtained results show the real impact of variability on data warehouses (DW) eco-design.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
For the rest of the paper, we will use interchangeably the terms energy and power.
- 2.
- 3.
Java library for multi-objective evolutionary algorithms. www.moeaframework.org.
References
Ameller, D., Ayala, C.P., Cabot, J., Franch, X.: How do software architects consider non-functional requirements: an exploratory study. In: RE, pp. 41–50 (2012)
Apel, S., Batory, D., Kstner, C., Saake, G.: Feature-Oriented Software Product Lines: Concepts and Implementation. Springer Publishing Company, Berlin (2013)
Batory, D., Barnett, J., Garza, J., Smith, K., Tsukuda, K., Twichell, B., Wise, T.: Genesis: an extensible db management system. IEEE Softw. Eng. 14, 1711–1730 (1988)
Bouarar, S., Bellatreche, L., Jean, S., Baron, M.: Do rule-based approaches still make sense in logical data warehouse design? In: Manolopoulos, Y., Trajcevski, G., Kon-Popovska, M. (eds.) ADBIS 2014. LNCS, vol. 8716, pp. 83–96. Springer, Heidelberg (2014). doi:10.1007/978-3-319-10933-6_7
Bouarar, S., Jean, S., Siegmund, N.: SPL driven approach for variability in database design. In: Bellatreche, L., Manolopoulos, Y. (eds.) MEDI 2015. LNCS, vol. 9344, pp. 332–342. Springer, Heidelberg (2015). doi:10.1007/978-3-319-23781-7_27
Boukorca, A., Bellatreche, L., Senouci, S.B., Faget, Z.: Coupling materialized view selection to multi query optimization: hyper graph approach. IJDWM 11(2), 62–84 (2015)
Chaudhuri, S., Narasayya, V.: Self-tuning database systems: a decade of progress. In: VLDB 2007, pp. 3–14 (2007)
Garcia-Molina, H., Ullman, J.D., Widom, J.: Database Systems: The Complete Book, 2nd edn. Prentice Hall Press, Upper Saddle River (2008)
Geppert, A., Scherrer, S., Dittrich, K.R.: Kids: construction of database management systems based on reuse. Technical report (1997)
Jean, S., Bellatreche, L., Ordonez, C., Fokou, G., Baron, M.: OntoDBench: interactively benchmarking ontology storage in a database. In: Ng, W., Storey, V.C., Trujillo, J.C. (eds.) ER 2013. LNCS, vol. 8217, pp. 499–503. Springer, Heidelberg (2013). doi:10.1007/978-3-642-41924-9_44
Lang, W., Kandhan, R., Patel, J.M.: Rethinking query processing for energy efficiency: slowing down to win the race. IEEE Data Eng. Bull. 34(1), 12–23 (2011)
Maier, C., Dash, D., Alagiannis, I., Ailamaki, A., Heinis, T.: PARINDA: an interactive physical designer for postgresql. In: EDBT, pp. 701–704 (2010)
Mami, I., Bellahsene, Z.: A survey of view selection methods. SIGMOD Rec. 41(1), 20–29 (2012)
RosenmĂĽller, M., et al.: SQL Ă la Carte: toward tailor-made data management. In: BTW (2009)
Rosenmüller, M., et al.: Tailor-made data management for embedded systems: a case study on berkeley DB. DKE 68(12), 1493–1512 (2009)
Roukh, A., Bellatreche, L., Boukorca, A., Bouarar, S.: Eco-dmw: eco-design methodology for data warehouses. In: ACM DOLAP, pp. 1–10 (2015)
Roukh, A., Bellatreche, L., Ordonez, C.: Enerquery: energy-aware query processing. In: ACM CIKM (2016, to appear)
Soffner, M., Siegmund, N., Rosenmüller, M., Siegmund, J., Leich, T., Saake, G.: A variability model for query optimizers. In: DB&IS, pp. 15–28 (2012)
Tesanovic, A., Sheng, K., Hansson, J.: Application-tailored database systems: a case of aspects in an embedded database. In: IDEAS, pp. 291–301 (2004)
Voigt, H., Hanisch, A., Lehner, W.: Flexs – a logical model for physical data layout. In: Bassiliades, N., Ivanovic, M., Kon-Popovska, M., Manolopoulos, Y., Palpanas, T., Trajcevski, G., Vakali, A. (eds.) New Trends in Database and Information Systems II. AISC, vol. 312, pp. 85–95. Springer, Heidelberg (2015). doi:10.1007/978-3-319-10518-5_7
Zhou, A., Qu, B.-Y., Li, H., Zhao, S.-Z., Suganthan, P.N., Zhang, Q.: Multiobjective evolutionary algorithms: a survey of the state of the art. Swarm Evol. Comput. 1, 32–49 (2011)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Bouarar, S., Bellatreche, L., Roukh, A. (2017). Eco-Data Warehouse Design Through Logical Variability. In: Steffen, B., Baier, C., van den Brand, M., Eder, J., Hinchey, M., Margaria, T. (eds) SOFSEM 2017: Theory and Practice of Computer Science. SOFSEM 2017. Lecture Notes in Computer Science(), vol 10139. Springer, Cham. https://doi.org/10.1007/978-3-319-51963-0_34
Download citation
DOI: https://doi.org/10.1007/978-3-319-51963-0_34
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-51962-3
Online ISBN: 978-3-319-51963-0
eBook Packages: Computer ScienceComputer Science (R0)