Skip to main content
SpringerLink
Log in

An Efficient Approach for Processing Skyline Queries in Incomplete Multidimensional Database

  • Research Article - Computer Engineering and Computer Science
  • Published:
Arabian Journal for Science and Engineering Aims and scope Submit manuscript

Abstract

In recent years, there has been great attention given to skyline queries that incorporate and provide more flexible query operators that return data items (skylines) which are not being dominated by other data items in all dimensions (attributes) of the database. Many variations in skyline techniques have been proposed in the literature. However, most of these techniques determine skylines by assuming that the values of all dimensions for every data item are available (complete). But this assumption is not always true particularly for large multidimensional database as some values may be missing (not applicable during the computation). In this paper, we proposed an efficient approach for processing skyline queries in incomplete database. The experimental results show that our proposed approach has significantly reduced the number of pairwise comparisons and the processing time in determining the skylines compared to the previous approaches.

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

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. Chee-Yong, C.; Jagadish, H.V.; Kian-Lee, T.; Tung, A.K.H.; Zhenjie, Z.: (2006) On high dimensional skylines. In: Proceedings of the 10th International Conference on Extending Database Technology (EDBT), pp. 478–495. Munich, Germany

  2. Chee-Yong, C.; Jagadish, H.V.; Kian-Lee, T.; Tung, A.K.H.; Zhenjie, Z.: Finding k-dominant skylines in high dimensional space. In: Proceedings of the 2006 ACM SIGMOD International Conference on Management of Data, pp. 503–514. Chicago, IL, USA (2006)

  3. Kian-Lee, T.; Pin-Kwang, E.; Beng C.O.: Efficient progressive skyline computation. In: Proceedings of the 27th International Conference on Very Large Data Bases (VLDB 27), pp. 301–310. Roma, Italy (2001)

  4. Kyriakos, M.; Spiridon, B.; Dimitris, P.: Continuous monitoring of top-k queries over sliding windows. In: Proceedings of the International Conference on Management of Data, pp. 635–646. Chicago, Illinois, USA (2006)

  5. Man, L.Y.; Nikos, M.: Efficient processing of top-k dominating queries on multi-dimensional data. In: Proceedings of the 33rd International conference on Very Large Data Bases (VLDB 33), pp. 483–494. Vienna, Austria (2007)

  6. Michael D.M., Jignesh M.P., William I.G.: Efficient continuous skyline computation. Int. J. Inf. Sci. 177(17), 3411–3437 (2007)

    MathSciNet  Google Scholar 

  7. Dana, Al.; Bouchra, S.; Erick, L.; Florence, S.: LA-GPS: a location-aware geographical pervasive system. In: Proceedings of the 24th International Conference on Data Engineering Works (ICDEW’08), pp. 160–163. Cancun, Mexico (2008)

  8. Justin, J.L.; Mohamed, F.M.; Mohamed, E.K.: FlexPref: a framework for extensible preference evaluation in database systems. In: Proceedings of the 26th International Conference on Data Engineering, (ICDE2010), pp. 828–839. Long Beach, California, USA (2010)

  9. Alwan, A.A.; Ibrahim, H.; Yip, T.C.; Sidi, F.; Udzir, N.I.: Preference evaluation of preference queries techniques over a high multidimensional database. In: Proceedings of the 3rd International Conference on Networked Digital Technologies (NDT11), pp. 212–223. Macau, China (2011)

  10. Jongwuk L., Gae-won Y., Seung-won H.: Personalized top-k skyline queries in high-dimensional space. Inf. Syst. 34(1), 45–61 (2009)

    Article  Google Scholar 

  11. Dimitris, P.; Yufei, T.; Greg, F.; Bernhard, S.: An optimal and progressive algorithm for skyline queries. In: Proceedings of the International Conference on Management of Data, pp. 467–478. San Diego, California, USA (2003)

  12. Donald, K.; Ramsak, F.; Rost, S.: Shooting stars in the sky: an online algorithm for skyline queries. In: Proceedings of the 28th International Conference on Very Large Data Bases (VLDB 28), pp. 275–286. Hong Kong, China, 20–23 August (2002)

  13. Haghani, P.; Michel, S.; Aberer, K.: Evaluating top-k queries over incomplete data streams. In: Proceedings of the 18th ACM conference on Information and Knowledge Management (CIKM’09), pp. 877–886. Hong Kong, China (2009)

  14. Ilyas, I.F.; Aref, W.G.; Ahmed, K.E.: Supporting top-k join queries in relational databases. In: Proceedings of the 29th International Conference on Very Large Data Bases (VLDB 29), pp. 754–765. Berlin, Germany (2003)

  15. Ilaria, B.; Paolo, C.; Marco, P.: SaLSa: computing the skyline without scanning the whole sky. In: Proceedings of the 15th International Conference on Information and Knowledge Management (CIKM’06), pp. 405–414. Arlington, Virginia, USA (2006)

  16. Jan, C.; Parke, G.; Jarek, G.; Dongming, L.: Skyline with presorting. In: Proceedings of the 19th International Conference on Data Engineering (ICDE03), pp. 717–816. Bangalore, India (2003)

  17. Jian, P.; Wen, J.; Martin, E.; Yufei, T.: Catching the best views of skyline: a semantic approach based on decisive subspaces. In: Proceedings of the 31st International Conference on Very Large Data Bases (VLDB 31), pp. 253–264. Trondheim, Norway (2005)

  18. Katerina, F.; Evaggelia, P.: BITPEER: continuous subspace skyline computation with distributed bitmap indexes. In: Proceedings of the International Workshop on Data Management in Peer-to-Peer Systems (DaMaP’08), pp. 35–42. Nantes, France (2008)

  19. Ken C.K.L., Wang-Chien L., Baihua Z., Huajing L., Yuan T.: Z-sky: an efficient skyline query processing framework based on Z-order. Very Large Data Base J. 19(3), 333–362 (2010)

    Article  Google Scholar 

  20. Martin, T.; Gerhard, W.; Ralf, S.: Top-k query evaluation with probabilistic guarantees. In: Proceedings of the 30th International Conference on Very Large Data Bases (VLDB 30), pp. 648–659. Toronto, Canada (2004)

  21. Stephan, B.; Donald, K.; Konrad, S.: The Skyline Operator. In: Proceedings of the 17th International Conference on Data Engineering (ICDE 2001), pp. 421–430. Heidelberg, Germany (2001)

  22. Surajit, C.; Luis, G.: Evaluating top-k selection queries. In: Proceedings of the 25th International Conference on Very Large Data Bases (VLDB 25), pp. 397–410. Edinburgh, Scotland (1999)

  23. Vagelis H., Yannis P.: Algorithms and applications for answering ranked queries using ranked views. Very Large Data Base J. 13(1), 49–70 (2004)

    Article  Google Scholar 

  24. Xuemin, L.; Yidong, Y.; Qing, Z.; Ying, Z.: Selecting stars: the k most representative skyline operator. In: Proceedings of the 23rd International Conference on Data Engineering, (ICDE 2007), pp. 86–95. Istanbul, Turkey (2007)

  25. Yidong, Y.; Xuemin, L.; Qing, L.; Wei, W.; Jeffrey X.Y.; Qing, Z.: Efficient computation of the skyline cube. In: Proceedings of the 31st International Conference on Very Large Data Bases (VLDB 31), pp. 267–278. Trondheim, Norway (2005)

  26. Yuan-Chi, C.; Lawrence, B.; Vittorio, C.; Chung-Sheng, L.; Ming-Ling, L.; Smith, J.R.: The onion technique: indexing for linear optimization queries. In: Proceedings of the International Conference on Management of Data, pp. 391–402. Dallas, Texas, USA (2000)

  27. Man L.Y., Nikos M.: Multi-dimensional top-k dominating queries. Very Large Data Base J. 18(3), 695–718 (2009)

    Article  Google Scholar 

  28. Mohamed E.K.; Mohamed F.M.; Justin J.L.: Skyline query processing for incomplete data. In: Proceedings of the 24th International Conference on Data Engineering (ICDE 2008), pp. 556–565. Cancun, Mexico (2008)

  29. Parke, G.; Ryan, S.; Jarek, G.: Maximal vector computation in large data sets. In: Proceedings of the 31st International Conference on Very Large Data Bases (VLDB31), pp. 229–240. Trondheim, Norway (2005)

  30. Raymond C.W.; Ada W.F.; Jian, P.; Yip S.H.; Tai, W.; Yubao, L.: Efficient skyline querying with variable user preferences on nominal attributes. In: Proceedings of the 34th International Conference on Very Large Data Bases (VLDB 34), pp. 1032–1043. Auckland, New Zealand (2008)

  31. Yufei, T.; Xiaokui, X.; Jian, P.: SUBSKY: efficient computation of skylines in subspaces. In: Proceedings of the 22nd International Conference on Data Engineering, (ICDE 2006), pp. 65–74. Atlanta, Georgia, USA (2006)

  32. Zhenhua, H.; Wei, W.: A novel incremental maintenance algorithm of skycube. In: Proceedings of the 17th International Conference of Database and Expert Systems Applications (DEXA 2006), pp. 781–790. Kraków, Poland (2006)

  33. Zhenhua H., Shengli S., Wei W.: Efficient mining of skyline objects in subspaces over data streams. Knowl. Inf. Syst. 22(2), 159–183 (2010)

    Article  Google Scholar 

  34. Rahul, B.; Sreenivasa, K.P.: Finding skylines for incomplete data. In: Proceedings of the Twenty-Fourth Australian Database Conference (ADC 2013), pp. 109–117. Adelaide, Australia (2013)

  35. http://www.basketball-reference.com/

  36. http://kdd.ics.uci.edu/

  37. http://movielens.umn.edu

Download references

Author information

Authors and Affiliations

  1. International Islamic University Malaysia, POB 10, 50728, Kuala Lumpur, Malaysia

    Ali A. Alwan

  2. Universiti Putra Malaysia, 43400, Serdang, Selangor, Malaysia

    Hamidah Ibrahim, Nur Izura Udzir & Fatima Sidi

Authors
  1. Ali A. Alwan
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Hamidah Ibrahim
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Nur Izura Udzir
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Fatima Sidi
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ali A. Alwan.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Alwan, A.A., Ibrahim, H., Udzir, N.I. et al. An Efficient Approach for Processing Skyline Queries in Incomplete Multidimensional Database. Arab J Sci Eng 41, 2927–2943 (2016). https://doi.org/10.1007/s13369-016-2048-z

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s13369-016-2048-z

Keywords

Search

Navigation