Skip to main content
SpringerLink
Log in

A Volunteer Design Methodology of Data Warehouses

  • Conference paper
  • First Online:
Conceptual Modeling (ER 2018)

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

Included in the following conference series:

Abstract

In the context of Volunteered Geographic Information (VGI), volunteers are not involved in the decisional processes. Moreover, VGI systems do not offer advanced historical analysis tools. Therefore, in this work, we propose to use Data Warehouse (DW) and OLAP systems to analyze VGI data, and we define a new DW design methodology that allows involving volunteers in the definition of analysis needs over VGI data. We validate it using a real biodiversity case study.

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

Access this chapter

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

Institutional subscriptions

Notes

  1. 1.

    https://www.wikipedia.org.

  2. 2.

    https://www.openstreetmap.org.

  3. 3.

    www.vgi4bio.fr.

  4. 4.

    Farmland biodiversity observatory www.observatoire-agricole-biodiversite.fr.

References

  1. Bakillah, M., Mostafavi, M.A., Bédard, Y.: A semantic similarity model for mapping between evolving geospatial data cubes. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM 2006. LNCS, vol. 4278, pp. 1658–1669. Springer, Heidelberg (2006). https://doi.org/10.1007/11915072_72

    Chapter  Google Scholar 

  2. Bimonte, S., Boucelma, O., Machabert, O., Sellami, S.: A new Spatial OLAP approach for the analysis of volunteered geographic information. Comput. Environ. Urban Syst. 48, 111–123 (2014). https://doi.org/10.1016/j.compenvurbsys.2014.07.006

    Article  Google Scholar 

  3. Bimonte, S., Edoh-alove, E., Nazih, H., Kang, M.-A., Rizzi, S.: ProtOLAP: rapid OLAP prototyping with on-demand data supply. In: DOLAP 2013, pp. 61–66. ACM, New York (2013). https://doi.org/10.1145/2513190.2513199

  4. Brabham, D.C.: Crowdsourcing as a model for problem solving: an introduction and cases. Convergence. 14, 75–90 (2008). https://doi.org/10.1177/1354856507084420

    Article  Google Scholar 

  5. Chen, L., Soliman, K.S., Mao, E., Frolick, M.N.: Measuring user satisfaction with data warehouses: an exploratory study. Inf. Manage. 37, 103–110 (2000). https://doi.org/10.1016/S0378-7206(99)00042-7

    Article  Google Scholar 

  6. Corr, L., Stagnitto, J.: Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema. DecisionOne Consulting (2011)

    Google Scholar 

  7. Cravero, A., SepĂşlveda, S.: Multidimensional design paradigms for data warehouses: a systematic mapping study. J. Softw. Eng. Applications. 07, 53 (2013). https://doi.org/10.4236/jsea.2014.71006

    Article  Google Scholar 

  8. Driedger, S.M., Kothari, A., Morrison, J., Sawada, M., Crighton, E.J., Graham, I.D.: Correction: using participatory design to develop (public) health decision support systems through GIS. Int J Health Geogr. 6, 53 (2007). https://doi.org/10.1186/1476-072X-6-53

    Article  Google Scholar 

  9. Egyed, A., Grunbacher, P.: Identifying requirements conflicts and cooperation: how quality attributes and automated traceability can help. IEEE Softw. 21, 50–58 (2004). https://doi.org/10.1109/MS.2004.40

    Article  Google Scholar 

  10. Ehn, P.: Participation in design things. In: Proceedings of the Tenth Conference on Participatory Design 2008, Indianapolis, IN, USA, pp. 92–101 (2008)

    Google Scholar 

  11. Nabli, A., Feki, J., Gargouri, F.: Automatic construction of multidimensional schema from OLAP requirements. In: AICCSA (2005). https://doi.org/10.1109/aiccsa.2005.1387025

  12. Kimball, R., Ross, M.: The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence Remastered Collection. Wiley (2016)

    Google Scholar 

  13. Levrel, H., et al.: Balancing state and volunteer investment in biodiversity monitoring for the implementation of CBD indicators: a French example. Ecol. Econ. 69, 1580–1586 (2010). https://doi.org/10.1016/j.ecolecon.2010.03.001

    Article  Google Scholar 

  14. Nuseibeh, B., Easterbrook, S.: Requirements engineering: a roadmap. In: Conference on the Future of Software Engineering, pp. 35–46. ACM, New York (2000). https://doi.org/10.1145/336512.336523

  15. Romero, O., Abelló, A.: A survey of multidimensional modeling methodologies. IJDWM 5, 1–23 (2009). https://doi.org/10.4018/jdwm.2009040101

    Article  Google Scholar 

  16. Gavish, B., Gerdes, J.H.: Voting mechanisms and their implications in a GDSS environment. Ann. Oper. Res. 71, 41–74 (1997). https://doi.org/10.1023/A:1018931801461

    Article  MATH  Google Scholar 

  17. Stefanovic, N., Han, J., Koperski, K.: Object-based selective materialization for efficient implementation of spatial data cubes. IEEE Trans. Knowl. Data Eng. 12, 938–958 (2000). https://doi.org/10.1109/69.895803

    Article  Google Scholar 

  18. Sui, D.Z., Elwood, S., Goodchild, M. (eds.): Crowdsourcing Geographic Knowledge: Volunteered Geographic Information (VGI) in Theory and Practice. Springer, Dordrecht (2013). https://doi.org/10.1007/978-94-007-4587-2

    Book  Google Scholar 

  19. Zaraté, P.: Tools for Collaborative Decision-Making: Zaraté/Tools for Collaborative Decision-Making. Wiley, London (2013)

    Book  Google Scholar 

  20. Golfarelli, M., Rizzi, S.: Data warehouse testing: a prototype-based methodology. Inf. Softw. Technol. 53(11), 1183–1198 (2011). https://doi.org/10.1016/j.infsof.2011.04.002

    Article  Google Scholar 

  21. Pohl, K.: Requirements Engineering: Fundamentals, Principles, and Techniques. Springer, Heidelberg (2010)

    Book  Google Scholar 

  22. Naeem, M.Asif, Ullah, S., Bajwa, I.S.: Interacting with data warehouse by using a natural language interface. In: Bouma, G., Ittoo, A., Métais, E., Wortmann, H. (eds.) NLDB 2012. LNCS, vol. 7337, pp. 372–377. Springer, Heidelberg (2012). https://doi.org/10.1007/978-3-642-31178-9_50

    Chapter  Google Scholar 

  23. Torlone, R.: Two approaches to the integration of heterogeneous data warehouses. Distrib. Parallel Databases 23(1), 69–97 (2008). https://doi.org/10.1007/s10619-007-7022-z

    Article  Google Scholar 

Download references

Acknowledgment

This work is supported by the project ANR-17-CE04-0012. We thank Pr. Omar Boussaid and Stefano Rizzi for their precious advices.

Author information

Authors and Affiliations

  1. IRSTEA, UR TSCF, 9 Av. B. Pascal, 63178, Aubiere, France

    Amir Sakka & Sandro Bimonte

  2. IRIT, Toulouse University, Toulouse, France

    Amir Sakka, Guy Camilleri & Pascale Zaraté

  3. LPO Aquitaine, 433 Chemin de Leysotte, 33140, Villenave-d’Ornon, France

    Aurelien Besnard

  4. AgroParistech, UMR TETIS, Maison de la télédétection, Montpellier, France

    Lucile Sautot

Authors
  1. Amir Sakka
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Sandro Bimonte
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Lucile Sautot
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Guy Camilleri
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Pascale Zaraté
    View author publications

    You can also search for this author in PubMed Google Scholar

  6. Aurelien Besnard
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Amir Sakka .

Editor information

Editors and Affiliations

  1. Lucentia, University of Alicante, Alicante, Spain

    Juan C. Trujillo

  2. Miami University, Oxford, OH, USA

    Karen C. Davis

  3. Renmin University of China, Beijing, China

    Xiaoyong Du

  4. Northwestern Polytechnical University, Xian, China

    Zhanhuai Li

  5. Department of Computer Science, National University of Singapore, Singapore, Singapore

    Tok Wang Ling

  6. Department of Computer Science and Technology, Tsinghua University, Beijing, Beijing, China

    Guoliang Li

  7. National University of Singapore, Singapore, Singapore

    Mong Li Lee

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Sakka, A., Bimonte, S., Sautot, L., Camilleri, G., Zaraté, P., Besnard, A. (2018). A Volunteer Design Methodology of Data Warehouses. In: Trujillo, J., et al. Conceptual Modeling. ER 2018. Lecture Notes in Computer Science(), vol 11157. Springer, Cham. https://doi.org/10.1007/978-3-030-00847-5_21

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-00847-5_21

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-00846-8

  • Online ISBN: 978-3-030-00847-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation