Intelligent Decision Making Technique for Marketing Using Hypothetical Database and Fuzzy Multi-Criteria Method


 Marketing Decision Making, What-If analysis, Hypothetical Database, Fuzzy Database, Multi-Criteria Decision Making.

How to Cite

A. Fareed, Ansar A. Khan, B. Mahmood, & H. Shamsul. (2013). Intelligent Decision Making Technique for Marketing Using Hypothetical Database and Fuzzy Multi-Criteria Method. Journal of Basic & Applied Sciences, 9, 44–51.


Marketing organizations use databases to locate potential customers and to generate sales lead. A number of software systems have been playing a key role in supporting the decision making activities in recent years but common problem in all that they cannot handle fuzzy data appropriately for "what-if" analysis. This paper proposes intelligent scenarios analysis system framework for marketing decision support which deals with crisp and fuzzy data like linguistic variable. Applying new approach "Hypothetical Database" for derived data that permits decision manager to manage views according to the need of organization and/or market environment. View in Hypothetical Database provides versatility in "What-If" analysis by using versions of "What-If" database and reduce data redundancy and data storage in updating. Using Fuzzy database will help to handle imprecise and uncertain information like "Linguistic variable" in a more human oriented process. Finally, the projected scenarios selected by decision manager will be aligned in a hierarchy according to the distance from "Ideal Vector" by using Fuzzy Multi-Criteria Decision Making method.


Brooksbank R, Kirby D, Tompson G, Taylor D. Marketing as a determinant of long-run competitive success in medium-sized UK manufacturing firms. Small Business Econom 2003; 20: 259-72.

Wind Y. An analytic hierarchy process based approach to the design and evaluation of a marketing business and corporate strategy. Mathematical Modelling 1987; 9(3-5): 285-91.

Stonebraker M, Keller K. Embedding Expert Knowledge and Hypothetical Databases into a Database System, Proceedings ACM-SIGMOD Conference on Management of Data. Santa Monoca, Ca 1980.

Klir GJ, Yuan B. Fuzzy Sets and Fuzzy Logic, Prentice-Hall, New Jersey 1995.

Serverance D, Lohman G. Differential Files: Their Application to the Maintenance of Large Databases. ACM Transactions on Database Systems, June 1976.

Woodfill J, Stonebraker M, An Implementation of hypothetical relational, Proceedings of the ninth International very large database Conference, Florence, Italy 1983.

Stonebraker M. Hypothetical Data Bases as Views, Proceedings of the 1981 ACM-SIGMOD conference on Management of Data, Ann Arbor, MI.

Ramirez RG, Kulkarni UR, Moser KA. The cost of Retrievals in What-If Databases, IEEE 1991.

Moser KA, Kulkarni UR, Ramirez RG. Scenario Management in Organizational DSS, IEEE 1994.

Ramirez RG, Kulkarni UR, Moser KA. Derived data for decision support system, Decision Support System 1996; 17: 119-40.

Kulkarni UR, Ramirez RG. Independently Updated Views, IEEE Transaction on Knowledge and Data Engineering 1997; vol. 9.

Baig MM, Khan AA, Efficient Testing of Database Applications, IJCSNS International Journal of Computer Science and Network Security 2009; 9(4).

Takahashi Y, Fuzzy database query languages and their relational completeness theorem, IEEE Transactions on Knowledge and Data Engineering 1993; 5(1): 122-25.

Buckles B, Petry F. A fuzzy representation of data for relational databases, Fuzzy Sets and Systems 1982; 7(3): 213-26.

Prade H, Testemale C. Fuzzy Relational Databases: Representational Issues and Reduction using Similarity Measures, Journal of the American Society for Information Science1987; 7(2): 118-26.<118::AID-ASI5>3.0.CO;2-L

Umano M, Fukami S. Fuzzy relational algebra for possibility-distribution-fuzzy relational model of Fuzzy data, Journal of Intelligent Information System 1994; 3: 7-27.

Medina JM, Pons O, Vila MA. GEFRED: A generalized model of fuzzy relational database, Information Sciences-Informatics and Computer Science 1994; 76(1-2): 87-109.

Galindo J, Urrutia A, Piattini M. Fuzzy Databases: Modeling Design and Implementation, IDEA Group Publishing, Hershey, USA 2006.

Srdjan Skrbic, Milos Rackovic, and Aleksandar Takaci, Prioritized fuzzy logic based information processing in relational databases, Knowledge-Based systems 2012.

Luo X, Lee J, Leung H, Jennings N. Prioritized Fuzzy Constraint Satisfaction Problems: Axioms, Instantiation and Validation, Fuzzy Sets and Systems 2003; 136(2): 151-88.

Ben Hassine MA, Ounelli HA, Grissa J, Galindo A. Migration Approach from Crisp Databases to Fuzzy Databases, Proceedings of the IEEE International Conference FUZZ-IEEE London, UK; 2007; pp. 1872-1879.

Figueira J, Greco S, Ehrgott M. Multiple Criteria Decision Analysis: State of the Art Surveys, Springer ed. 2005.

Edmundas KZ, Zenonas T. Multiple Criteria Decision Making (MCDM) methods in economics: An overview, Journal of Technological and Economic Development of Economy 2011; 17(2): 397-27.

Fatih Emre Boran, An integrated intuitionistic fuzzy multi-criteria decision making method for facility location selection, Journal of Mathematical and Computational Applications 2011; 16(2): 487-96.

Zhang W, Zhu J. Research on Multi-Attribute Decision-Making based on Fuzzy set theory, Second International Symposium on Intelligent Information Technology Application, IEEE 2008.

Yung-Lan W, Gwo-Hshiung T. Brand marketing for creating brand value based on a MCDM model combining DEMATEL with ANP and VIKOR methods, Journal of Expert Systems with Applications 2012; 39: 5600-15.

Fabio JJS, Heloisa AC. Fuzzy Systems for Multi-criteria Decision Making, Clei Electronic Journal 2010; 13(3): paper-4.

Hsu CY, Chen KT, Tzeng GH. FMCDM with Fuzzy DEMATEL Approach for Customers Choice Behavior Model, International Journal of Fuzzy Systems Dec 2007; 9(4).

Chen TC, Ping FP, Wei ZH. Handling fuzzy decision making problem based on linguistic information and intersection concept, Proceedings of the IEEE International conference on Fuzzy Systems, Taiwan, June 2011; pp. 27-30.

Mahmoud M, et al. A formal framework for scenario development in support of environmental decision-making, Environmental Modeling & Software 2009; 24: 798-808.

Bunn DW, Salo AA. Forecasting with scenarios, European Journal of Operational Research 1993; 68(3): 291-303.

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Copyright (c) 2013 A. Fareed, Ansar A. Khan, B. Mahmood , H. Shamsul