Skip to main content
SpringerLink
Log in

Integration of Goal Hierarchies Built Using Multiple OLAP Query Sessions

  • Conference paper
  • First Online:
Soft Computing in Data Analytics

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 758))

  • 825 Accesses

Abstract

A goal hierarchy consists of a strategic goal, decision goals, information goals and tasks. The goal hierarchy can provide a decision maker different ways in which the data can be analysed in order to achieve a strategic goal. In our earlier work, we built a goal hierarchy for a query session, using OLAP query recommendation technique. It is possible to build more than one goal hierarchy for a given strategic goal if multiple query sessions are used. In this paper, we propose an integration technique. It is a mixed approach where decision goals and information goals are integrated top-down and tasks are integrated bottom-up. The result of integration of multiple goal hierarchies is a new goal hierarchy with a unified view of analysis in order to identify the different perspectives of analysis in a single diagram.

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 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.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

References

  1. Inmon, W.H.: Building the Data Warehouse. Wiley (2005)

    Google Scholar 

  2. Mazón, J., Pardillo, J., Trujillo, J.: A model-driven goal-oriented requirement engineering approach for data warehouses. In: International Conference on Conceptual (2007)

    Google Scholar 

  3. Liu, X., Xu, X.: Requirement analysis for data warehouses based on the tropos. In: 2011 3rd International Workshop on Intelligent Systems and Applications (ISA), pp. 1–5 (2011)

    Google Scholar 

  4. Giorgini, P., Rizzi, S., Garzetti, M.: Goal-oriented requirement analysis for data warehouse design. In: Proceedings of the 8th ACM international workshop on Data warehousing and OLAP-DOLAP. p. 47 (2005)

    Google Scholar 

  5. Giorgini, P., Rizzi, S., Garzetti, M.: GRAnD: A goal-oriented approach to requirement analysis in data warehouses. Decis. Support Syst. 45, 4–21 (2008). https://doi.org/10.1016/j.dss.2006.12.001

    Article  Google Scholar 

  6. Salinesi, C., Gam, I.: A requirement-driven approach for designing data warehouses. In: 12th Working Conference on Requirements Engineering: Foundation for Software Quality, REFSQ. pp. 179–192 (2006)

    Google Scholar 

  7. Prakash, N., Gosain, A.: Requirements Driven Data Warehouse Development. In: CAiSE Short Paper Proceedings (2003)

    Google Scholar 

  8. Castro, J., Kolp, M., Mylopoulos, J.: Towards requirements-driven information systems engineering: the Tropos project. Inf. Syst. 27, 365–389 (2002)

    Article  Google Scholar 

  9. Golfarelli, M., Maio, D., Rizzi, S.: Conceptual design of data warehouses from E/R schemes. In: Proceedings of the Thirty-First Hawaii International Conference on System Sciences, pp. 334–343 (1998)

    Google Scholar 

  10. Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: a conceptual model for data warehouses. Int. J. Coop. Inf. Syst. 7, 215–247 (1998). https://doi.org/10.1142/S0218843098000118

    Article  Google Scholar 

  11. Guo, Y., Guo, Y., Tang, S., Tang, S., Tong, Y., Tong, Y., Yang, D., Yang, D.: Triple-driven data modeling methodology in data warehousing: a case study. In Proceedings of the 9th ACM International Workshop on Data Warehousing and OLAP, pp. 9–66 (2006). https://doi.org/10.1145/1183512.1183524

  12. Jukic, N., Nicholas, J.: A framework for requirement collection and definition process for data warehousing projects. In: 32nd International Conference on Information Technology Interfaces (ITI), pp. 187–192 (2010)

    Google Scholar 

  13. Ranjan, R.K., Parimala, N.: A bottom-up approach for creating goal hierarchy using olap query recommendation technique. Int. J. Bus. Inf. Syst. (2017)( In Press)

    Google Scholar 

  14. Eiter, T., Krennwallner, T., Redl, C.: Declarative merging of and reasoning about decision diagrams. In: Workshop on Constraint Based Methods for Bioinformatics (WCB 2011), Perugia, Italy. pp. 3–15 (2011)

    Google Scholar 

  15. Al-Mubaid, H., Bettayeb, S.: An Algorithm for Combining Graphs Based on Shared Knowledge. In: ISCA BICoB. pp. 137–142., Las Vegas, Nevada, USA (2012)

    Google Scholar 

  16. Yu, E.S.K.: Towards modelling and reasoning support for early-phase requirements engineering. In: Requirements Engineering, Proceedings of the Third IEEE International Symposium on. pp. 226–235 (1997)

    Google Scholar 

  17. Yu, E.: Modelling strategic relationships for process reengineering. Soc. Model. Requir. Eng. 11, (2011)

    Google Scholar 

  18. Microsoft SQL Server 2012 Analysis Services, https://www.microsoft.com/

  19. AdventureWorks: AdventureWorksDW Database, https://msftdbprodsamples.codeplex.com/

  20. Smith, B., Clay, C.: Microsoft SQL Server 2008 MDX Step by Step. Pearson Education (2009)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi, 110067, India

    N. Parimala & Ranjeet Kumar Ranjan

Authors
  1. N. Parimala
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Ranjeet Kumar Ranjan
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ranjeet Kumar Ranjan .

Editor information

Editors and Affiliations

  1. Department of Computer Science and Engineering, Sri Sivani College of Engineering, Srikakulam, Andhra Pradesh, India

    Janmenjoy Nayak

  2. Machine Intelligence Research Labs (MIR Labs), Scientific Network for Innovation and Research Excellence, Washington, USA

    Ajith Abraham

  3. Department of Mechanical Engineering, Sri Sivani College of Engineering, Srikakulam, Andhra Pradesh, India

    B. Murali Krishna

  4. Department of Electrical and Electronics Engineering, Sri Sivani College of Engineering, Srikakulam, Andhra Pradesh, India

    G. T. Chandra Sekhar

  5. Department of Computer Science and Technology, Indian Institute of Engineering Science and Technology (IIEST), Shibpur, Howrah, West Bengal, India

    Asit Kumar Das

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Singapore Pte Ltd.

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Parimala, N., Ranjan, R.K. (2019). Integration of Goal Hierarchies Built Using Multiple OLAP Query Sessions. In: Nayak, J., Abraham, A., Krishna, B., Chandra Sekhar, G., Das, A. (eds) Soft Computing in Data Analytics . Advances in Intelligent Systems and Computing, vol 758. Springer, Singapore. https://doi.org/10.1007/978-981-13-0514-6_43

Download citation

Publish with us

Policies and ethics

Search

Navigation