Towards DW Support for Formulating Policies

  • Deepika PrakashEmail author
  • Naveen Prakash
Conference paper
Part of the Lecture Notes in Business Information Processing book series (LNBIP, volume 235)


Data warehousing is largely directed towards “what to do next” type of decisions that essentially address operational decision-making needs. We argue for developing data warehouse support for deciding on organizational policies: policies evolve and therefore need continual decision-making support. We propose an RE approach for discovering information contents of a data warehouse for policy decision-making. Each policy is represented in an extended first order logic that can be converted into a policy hierarchy. Each node in this hierarchy can be selected, rejected, or modified. In order to take this decision, the relevant information is determined by using Ends Information Elicitation and Critical Success Factor Elicitation techniques for information elicitation. The elicited information is converted into an ER diagram from which star schemas are obtained.


Policy Policy formulation Directive Requirements engineering 


  1. 1.
    Boehnlein, M., Ulbrich vom Ende, A.: Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems. In: Proceedings of Workshop on Data Warehousing and OLAP (DOPLAP), pp. 15–21, USA (1999)Google Scholar
  2. 2.
    Boehnlein, M., Ulbrich vom Ende, A.: Business process oriented development of data warehouse structures. In: Proceedings of Data Warehousing 2000. Physica Verlag (2000)Google Scholar
  3. 3.
    Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., Paraboschi, S.: Designing data marts for data warehouses. ACM Trans. Software. Eng. Methodol. 10(4), 452–483 (2001)CrossRefGoogle Scholar
  4. 4.
    Giorgini, P., Rizzi, S., Garzetti, M.: GRAnD: a goal-oriented approach to requirement analysis in data warehouses. Decis. Support Syst. 45(1), 4–21 (2008)CrossRefGoogle Scholar
  5. 5.
    Golfarelli, M., Maio, D., Rizzi, S.: Conceptual design of data warehouses from E/R schemes. In: Proceedings of HICSS-31, vol. VII, pp. 334–343 (1998)Google Scholar
  6. 6.
    GOI. Department of AYUSH, Ministry of Health and Family Welfare, Government of India, No. Z.20018/4/2000-ISM (Tech)/HD Cell, National Competitive Bidding (2000)Google Scholar
  7. 7.
    Imhoff C., White C.: DSS 2.0 -
  8. 8.
    Mazón, J.-N., Pardillo, J., Trujillo, J.: A model-driven goal-oriented requirement engineering approach for data warehouses. In: Hainaut, J.-L., Rundensteiner, E.A., Kirchberg, M., Bertolotto, M., Brochhausen, M., Chen, Y.-P.P., Cherfi, S.S.-S., Doerr, M., Han, H., Hartmann, S., Parsons, J., Poels, G., Rolland, C., Trujillo, J., Yu, E., Zimányie, E. (eds.) ER Workshops 2007. LNCS, vol. 4802, pp. 255–264. Springer, Heidelberg (2007)CrossRefGoogle Scholar
  9. 9.
    Moody, L.D., Kortink, M.A.R.: From enterprise models to dimensional models: a methodology for data warehouses and data mart design. In: Proceedings of the International Workshop on Design and Management of Data Warehouses, pp. 5.1–5.12, Stockholm, Sweden (2000)Google Scholar
  10. 10.
    OMG 14. Object Modeling Group, Business Motivation Model, release 1.3, OMG document number, dtc/14-11-07.
  11. 11.
    OMG-Semantics of Business Vocabulary and Business Rules (SBVR), vol. 1.0.
  12. 12.
    Prakash, N., Gosain, A.: Requirements driven data warehouse development. In: CAiSE Short Paper Proceedings, pp. 13–17 (2003)Google Scholar
  13. 13.
    Prakash, N., Gosain, A.: An approach to engineering the requirements of data warehouses. REJ 13(1), 49–72 (2008)Google Scholar
  14. 14.
    Prakash, N., Prakash, D., Gupta, D.: Decisions and decision requirements for data warehouse systems. In: Soffer, P., Proper, E. (eds.) CAiSE Forum 2010. LNBIP, vol. 72, pp. 92–107. Springer, Heidelberg (2011)CrossRefGoogle Scholar
  15. 15.
    Ross R.G.: Business Rules Manifesto, Business Rules Group, version 2.0 (2003)Google Scholar
  16. 16.
    Wetherbe, J.C.: Executive information requirements: getting it right. MIS Q. 15(1), 51–65 (1991)CrossRefGoogle Scholar

Copyright information

© IFIP International Federation for Information Processing 2015

Authors and Affiliations

  1. 1.Delhi Technological UniversityDelhiIndia
  2. 2.ITM UniversityGurgaonIndia

Personalised recommendations