skip to main content
10.1145/1698790.1698817acmotherconferencesArticle/Chapter ViewAbstractPublication PagesedbtConference Proceedingsconference-collections
research-article

Towards an Algebraic foundation for business planning

Published:22 March 2009Publication History

ABSTRACT

Modern applications for business planning and performance management offer a broad range of functions for planning, forecasting, and optimising business processes. Often, they must be integrated in a planning process involving different users and objectives. However, due to the heterogeneity of their implementations and BI platform requirements, this integration becomes a tedious task. In this paper, we propose an algebra as the foundation of a common implementation and execution platform for business planning applications. We outline the major topics involved in the development of this algebra and give pointers to interesting research questions we want to address in future.

References

  1. A. Abelló, J. Samos, and F. Saltor. A Framework for the Classification and Description of Multidimensional Data Models. In DEXA '01: Proceedings of the 12th International Conference on Database and Expert Systems Applications, pages 668--677, London, UK, 2001. Springer-Verlag. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. P. Agrawal, O. Benjelloun, A. D. Sarma, C. Hayworth, S. Nabar, T. Sugihara, and J. Widom. Trio: A System for Data, Uncertainty, and Lineage. In VLDB '06: Proceedings of the 32nd International Conference on Very Large Data Bases, pages 1151--1154. VLDB Endowment, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. J. Dean and S. Ghemawat. MapReduce: Simplified Data Processing on Large Clusters. Communications of the ACM, 51(1):107--113, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. S. Goil and A. Choudhary. A Parallel Scalable Infrastructure for OLAP and Data Mining. In IDEAS '99: Proceedings of the 1999 International Symposium on Database Engineering & Applications, page 178, Washington, DC, USA, 1999. IEEE Computer Society. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. J. Gray, S. Chaudhuri, A. Bosworth, A. Layman, D. Reichart, M. Venkatrao, F. Pellow, and H. Pirahesh. Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals. J. Data Mining and Knowledge Discovery, 1(1):29--53, 1997. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. V. Harinarayan and A. Gupta. Generalized projections: A powerful query-optimization technique. Technical report, Stanford, CA, USA, 1994. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. T. Legler, W. Lehner, and A. Ross. Data Mining with the SAP NetWeaver BI Accelerator. In VLDB '06: Proceedings of the 32nd International Conference on Very Large Data Bases, pages 1059--1068. VLDB Endowment, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. B. Moole. A Probabilistic Multidimensional Data Model and Algebra for OLAP in Decision Support Systems. SoutheastCon, 2003. Proceedings. IEEE, pages 18--30, 2003.Google ScholarGoogle Scholar
  9. F. Ravat, O. Teste, R. Tournier, and G. Zurfluh. Algebraic and Graphic Languages for OLAP Manipulations. International Journal of Data Warehousing and Mining, 4(1):17--46, 2008.Google ScholarGoogle ScholarCross RefCross Ref
  10. O. Romero and A. Abelló. On the Need of a Reference Algebra for OLAP. In DaWaK 2007: Data Warehousing and Knowledge Discovery, 9th International Conference, Regensburg, Germany, pages 99--110, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. G. Spofford, S. Harinath, C. Webb, and F. Civardi. MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase. John Wiley & Sons, Inc., New York, NY, USA, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. The Apache Software Foundation. Hadoop. http://hadoop.apache.org/core/, 12/04/2008.Google ScholarGoogle Scholar
  13. A. A. Vaisman and A. O. Mendelzon. A Temporal Query Language for OLAP: Implementation and a Case Study. In DBPL '01: Revised Papers from the 8th International Workshop on Database Programming Languages, pages 78--96, London, UK, 2002. Springer-Verlag. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. P. Vassiliadis. Modeling Multidimensional Databases, Cubes and Cube Operations. In SSDBM '98: Proceedings of the 10th International Conference on Scientific and Statistical Database Management, pages 53--62, 1998. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Towards an Algebraic foundation for business planning

      Recommendations

      Comments

      Login options

      Check if you have access through your login credentials or your institution to get full access on this article.

      Sign in
      • Published in

        cover image ACM Other conferences
        EDBT/ICDT '09: Proceedings of the 2009 EDBT/ICDT Workshops
        March 2009
        218 pages

        Copyright © 2009 ACM

        Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

        Publisher

        Association for Computing Machinery

        New York, NY, United States

        Publication History

        • Published: 22 March 2009

        Permissions

        Request permissions about this article.

        Request Permissions

        Check for updates

        Qualifiers

        • research-article

        Acceptance Rates

        Overall Acceptance Rate7of10submissions,70%
      • Article Metrics

        • Downloads (Last 12 months)2
        • Downloads (Last 6 weeks)0

        Other Metrics

      PDF Format

      View or Download as a PDF file.

      PDF

      eReader

      View online with eReader.

      eReader