Skip to main content
SpringerLink
Log in
Book cover

East European Conference on Advances in Databases and Information Systems

ADBIS 2016: Advances in Databases and Information Systems pp 166–180Cite as

A Recommender System for DBMS Selection Based on a Test Data Repository

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 9809))

Abstract

Nowadays, we see an explosion in the number of Database Management Systems (DBMS) in the market. Each one has its own characteristics. This spectacular development of DBMS is mainly motivated by the need for storing and exploiting the deluge of heterogeneous data for analytical purposes. As a consequence, companies and users are faced with huge range of choices and sometimes it is hard for them to find the relevant DBMS. Some Web sites such as DB-Engines (http://db-engines.com/en/) provide monthly a classification of hundreds of DBMS (303 in April 2016) using metrics related to usage and user feedbacks. These criteria are not always sufficient to help companies and users to make a good choice. Therefore, they have to be enhanced by qualitative measurements obtained by testing the activities of DBMS for a set of non-functional requirements. In this perspective, some council such as Transaction Processing Council publish non-functional requirement results of DBMS using their own benchmarks. Another serious producer of test data is the researchers via their scientific papers. Each year they publish a large amount of results of new solutions. To facilitate the exploitation of these test results by small companies and researchers from developing countries, the construction of a test data repository connected to recommender system is an asset for companies/users. In this paper, we first propose a repository for structuring and storing test data. Secondly, a recommender system is built on the top of this repository to advise companies to choose appropriate DBMS based on their requirements. Finally, a proof of concept of our recommender system is given to illustrate our proposal.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Notes

  1. 1.

    http://db-engines.com/en/.

  2. 2.

    www.tpc.org.

  3. 3.

    http://dblp.uni-trier.de/.

  4. 4.

    http://www.tpc.org/tpch/.

  5. 5.

    http://ctuning.org/index.html.

  6. 6.

    http://www.aiida.net/.

References

  1. Ahmad, M., Aboulnaga, A., Babu, S., Munagala, K.: Interaction-aware scheduling of report-generation workloads. VLDB J. 20(4), 589–615 (2011)

    Article  Google Scholar 

  2. Baralis, E., Meo, R., Psaila, G.: Data mining in data warehouses. In: SEBD, pp. 51–65 (1999)

    Google Scholar 

  3. Bouchakri, R., Bellatreche, L., Hidouci, K.-W.: Static and incremental selection of multi-table indexes for very large join queries. In: Morzy, T., Härder, T., Wrembel, R. (eds.) ADBIS 2012. LNCS, vol. 7503, pp. 43–56. Springer, Heidelberg (2012)

    Chapter  Google Scholar 

  4. Brahimi, L., Ouhammou, Y., Bellatreche, L., Ouared, A.: More transparency in testing results: towards an open collective knowledge base. In: 10th IEEE International Conference on Research Challenges in Information Science, pp. 315–320 (2016)

    Google Scholar 

  5. Chen, Q., Hsu, M., Dayal, U.: A data-warehouse/OLAP framework for scalable telecommunication tandem traffic analysis. In: ICDE, pp. 201–210 (2000)

    Google Scholar 

  6. Chung, L., do Prado Leite, J.C.S.: On non-functional requirements in software engineering. In: Borgida, A.T., Chaudhri, V.K., Giorgini, P., Yu, E.S. (eds.) Conceptual Modeling: Foundations and Applications. LNCS, vol. 5600, pp. 363–379. Springer, Heidelberg (2009)

    Chapter  Google Scholar 

  7. Cross, T.L., Lane, R.J., et al.: Selecting a database management system for agricultural record keeping. Technical report (1988)

    Google Scholar 

  8. Cross, V.V., Sudkamp, T.A.:Similarity and compatibility in fuzzy set theory: assessment and applications, vol. 93 (2002)

    Google Scholar 

  9. Dague, P., Travé-Massuyès, L.: Raisonnement causal en physique qualitative. Intellectica 38, 247–290 (2004)

    Google Scholar 

  10. Dede, E., Govindaraju, M., Gunter, D., Canon, R.S., Ramakrishnan, L.: Performance evaluation of a mongodb and hadoop platform for scientific data analysis. In: Proceedings of the 4th ACM Workshop on Scientific Cloud Computing, pp. 13–20 (2013)

    Google Scholar 

  11. Furtado, P., Nadal, S., Peralta, V., Djedaini, M., Labroche, N., Marcel, P.: Materializing baseline views for deviation detection exploratory OLAP. In: DAWAK, pp. 243–254 (2015)

    Google Scholar 

  12. Golfarelli, M., Rizzi, S.: Data warehouse testing: a prototype-based methodology. Inf. Softw. Technol. 53(11), 1183–1198 (2011)

    Article  Google Scholar 

  13. Gomez-Uribe, C.A., Hunt, N.: The netflix recommender system: algorithms, business value, and innovation. ACM Trans. Manage. Inf. Syst. 6(4), 13 (2016)

    Google Scholar 

  14. Gross, D., Yu, E.: From non-functional requirements to design through patterns. Require. Eng. 6(1), 18–36 (2001)

    Article  MATH  MathSciNet  Google Scholar 

  15. Haftmann, F., Kossmann, D., Lo, E.: A framework for efficient regression tests on database applications. VLDB J. 16(1), 145–164 (2007)

    Article  Google Scholar 

  16. Lauesen, S.: Task descriptions as functional requirements. Softw. IEEE 20(2), 58–65 (2003)

    Article  Google Scholar 

  17. Ordonez, C., Chen, Z., García-García, J.: Interactive exploration and visualization of OLAP cubes. In: ACM DOLAP, pp. 83–88 (2011)

    Google Scholar 

  18. Park, Y., Shankar, M., Park, B., Ghosh, J.: Graph databases for large-scale healthcare systems: a framework for efficient data management and data services. In: Workshops Proceedings of the ICDE, pp. 12–19 (2014)

    Google Scholar 

  19. Pezzè, M., Zhang, C.: Automated test oracles: a survey. Adv. Comput. 95, 1–48 (2015)

    Article  Google Scholar 

  20. Rosenmüller, M., Siegmund, N., Schirmeier, H., Sincero, J., Apel, S., Leich, T., Spinczyk, O., Saake, G.: Fame-DBMS: tailor-made data management solutions for embedded systems. In: Proceedings of the 2008 EDBT Workshop on Software Engineering for Tailor-Made Data Management, pp. 1–6 (2008)

    Google Scholar 

  21. Roukh, A., Bellatreche, L., Boukorca, A., Bouarar, S.: Eco-DMW: eco-design methodology for data warehouses. In: ACM DOLAP, pp. 1–10 (2015)

    Google Scholar 

  22. Siksnys, L., Thomsen, C., Pedersen, T.B.: MIRABEL DW: managing complex energy data in a smart grid. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2012. LNCS, vol. 7448, pp. 443–457. Springer, Heidelberg (2012)

    Chapter  Google Scholar 

  23. Tort, A., Olivé, A., Sancho, M.-R.: An approach to test-driven development of conceptual schemas. Data Knowl. Eng. 70(12), 1088–1111 (2011)

    Article  Google Scholar 

  24. Wagstaff, K.: Clustering with missing values: no imputation required. In: Banks, D., McMorris, F.R., Arabie, P., Gaul, W. (eds.) Classification, Clustering, and Data Mining Applications. Studies in Classification, Data Analysis, and Knowledge Organization, pp. 649–658. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. LIAS/ISAE-ENSMA, Poitiers University, Futuroscope, Poitiers, France

    Lahcène Brahimi, Ladjel Bellatreche & Yassine Ouhammou

Authors
  1. Lahcène Brahimi
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Ladjel Bellatreche
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Yassine Ouhammou
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Lahcène Brahimi .

Editor information

Editors and Affiliations

  1. MFF, Charles University MFF, Prague, Czech Republic

    Jaroslav Pokorný

  2. Faculty of Sciences, University of Novi Sad Faculty of Sciences, Novi Sad, Serbia

    Mirjana Ivanović

  3. Christian-Albrechts-Universität Kiel , Kiel, Germany

    Bernhard Thalheim

  4. VSB-Technical University Ostrava , Ostrava, Czech Republic

    Petr Šaloun

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this paper

Cite this paper

Brahimi, L., Bellatreche, L., Ouhammou, Y. (2016). A Recommender System for DBMS Selection Based on a Test Data Repository. In: Pokorný, J., Ivanović, M., Thalheim, B., Šaloun, P. (eds) Advances in Databases and Information Systems. ADBIS 2016. Lecture Notes in Computer Science(), vol 9809. Springer, Cham. https://doi.org/10.1007/978-3-319-44039-2_12

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-44039-2_12

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-44038-5

  • Online ISBN: 978-3-319-44039-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation