Towards a Configurable Database Design: A Case of Semantic Data Warehouses

  • Selma Khouri
  • Ladjel Bellatreche
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8841)


Many modern software systems are designed to be highly configurable. The configuration contributes in managing evolving software and controls the cost involved in making changes to software. Several standards exist for software configuration management (IEEE 828 and IEEE 1042). Unfortunately, making database configurable did not have the same spring as for software even though it can be seen as a software product. Nowadays, we are assisting to an explosion of new deployment layouts and platforms. This situation pushed the database community to admit the slogan: “one size no longer fits all”. This motivates us to study the issue to make database design configurable. To satisfy this objective, we need to perform the following three tasks: (i) a deep understanding of the database design life-cycle, (ii) a formalization of each phase and (iii) an identification of the interactions between these phases. In this paper, we detail these tasks by considering the case of designing semantic data warehouses.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bellatreche, L., Khouri, S., Berkani, N.: Semantic data warehouse design: From ETL to deployment à la carte. In: Meng, W., Feng, L., Bressan, S., Winiwarter, W., Song, W. (eds.) DASFAA 2013, Part II. LNCS, vol. 7826, pp. 64–83. Springer, Heidelberg (2013)CrossRefGoogle Scholar
  2. 2.
    Berkani, N., Bellatreche, L., Khouri, S.: Towards a conceptualization of etl and physical storage of semantic data warehouses as a service. Cluster Computing 16(4), 915–931 (2013)CrossRefGoogle Scholar
  3. 3.
    Calvanese, D., Lenzerini, M., Nardi, D.: Description logics for conceptual data modeling. In: Logics for Databases and Information Systems, pp. 229–263 (1998)Google Scholar
  4. 4.
    Golfarelli, M.: From user requirements to conceptual design in data warehouse design a survey. In: Data Warehousing Design and Advanced Engineering Applications Methods for Complex Construction, pp. 1–16 (2010)Google Scholar
  5. 5.
    Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: a conceptual model for data warehouses. International Journal of Cooperative Information Systems 7(02n03), 215–247 (1998)CrossRefGoogle Scholar
  6. 6.
    Golfarelli, M., Rizzi, S., Turricchia, E.: Modern software engineering methodologies meet data warehouse design: 4WD. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2011. LNCS, vol. 6862, pp. 66–79. Springer, Heidelberg (2011)CrossRefGoogle Scholar
  7. 7.
    Khouri, S., Bellatreche, L., Boukhari, I., Bouarar, S.: More investment in conceptual designers: Think about it? In: CSE 2012, pp. 88–93 (2012)Google Scholar
  8. 8.
    Khouri, S., Boukhari, I., Bellatreche, L., Jean, S., Sardet, E., Baron, M.: Ontology-based structured web data warehouses for sustainable interoperability: requirement modeling, design methodology and tool. Computers in Industry, 799–812 (2012)Google Scholar
  9. 9.
    Mazón, J.-N., Trujillo, J.: An mda approach for the development of data warehouses. Decision Support Systems 45(1), 41–58 (2008)CrossRefGoogle Scholar
  10. 10.
    Nebot, V., Berlanga, R.: Building data warehouses with semantic web data. Decision Support Systems (2011)Google Scholar
  11. 11.
    Romero, O., Simitsis, A., Abelló, A.: GEM: Requirement-driven generation of ETL and multidimensional conceptual designs. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2011. LNCS, vol. 6862, pp. 80–95. Springer, Heidelberg (2011)CrossRefGoogle Scholar
  12. 12.
    Skoutas, D., Simitsis, A.: Ontology-based conceptual design of etl processes for both structured and semi-structured data. International Journal on Semantic Web and Information Systems (IJSWIS) 3(4), 1–24 (2007)CrossRefGoogle Scholar
  13. 13.
    Song, I.Y., Khare, R., Dai, B.: Samstar: a semi-automated lexical method for generating star schemas from an entity-relationship diagram. In: Proceedings of the ACM Tenth International Workshop on Data Warehousing and sLAP, pp. 9–16. ACM (2007)Google Scholar
  14. 14.
    Winter, R., Strauch, B.: A method for demand-driven information requirements analysis in data warehousing projects. In: Proceedings of the 36th Annual Hawaii International Conference on ystem Sciences, p. 9–19. IEEE (2003)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2014

Authors and Affiliations

  • Selma Khouri
    • 1
    • 2
  • Ladjel Bellatreche
    • 1
  1. 1.LIAS/ISAE-ENSMAUniversity of PoitiersFuturoscope CedexFrance
  2. 2.National High School for Computer Science (ESI)AlgiersAlgeria

Personalised recommendations