Skyline Computations with Partially Ordered Domains using Indexing Method

Authors

  • Y. Gopi  Assistent Professor, Department of MCA, St. Mary's Group of Institutions, Guntur, Andhra Pradesh, India
  • Nallagonda Anitha  PG Students, Department of MCA, St. Mary's Group of Institutions, Guntur, Andhra Pradesh, India

Keywords:

Indexing Methods, Query Processing, Multi-Dimensional Databases, Data Management.

Abstract

Efficient processing of skyline queries with partially ordered domains has been intensively addressed in recent years. To further reduce the query processing time to support high-responsive applications, the skyline queries that were previously processed with user preferences similar to those of the new query contribute useful candidate result points. Hence, the answered queries can be cached with both their results and the user preferences such that the query processor can rapidly retrieve the result for a new query only from the result sets of cached queries with compatible user preferences. When caching a significant number of queries accumulated over time, it is essential to adopt effective access methods to index the cached queries to retrieve a set of relevant cached queries for facilitating the cache-based skyline query computations. In this paper, we propose an extended depth-first search indexing method (e-DFS for short) for accessing user preference profiles represented by directed acyclic graphs (DAGs), and emphasize the design of the e-DFS encoding that effectively encodes a user preference profile into a low-dimensional feature point which is eventually indexed by an R-tree. We obtain one or more traversal orders for each node in a DAG by traversing it through a modified version of the depth-first search which is utilized to examine the topology structure and dominance relations to measure closeness or similarity. As a result, e-DFS which combines the criteria of similarity evaluation is able to greatly reduce the search space by filtering out most of the irrelevant cached queries such that the query processor can avoid accessing the entire data set to compute the query results. Extensive experiments are presented to demonstrate the performance and utility of our indexing method, which outperforms the baseline planning techniques by reducing 37% of the computational time on average.

References

  1. W. Balke, U. Guntzer, and C. Lofi. Eliciting matters controlling skyline sizes by incremental integration of user preferences. In DASFFA, pages 551-562, 2007.
  2. W. Balke, U. Guntzer, and W. Siberski. Exploiting indi erence for customization of partial order skylines. In IDEAS, pages 80-88, 2006.
  3. I. Bartolini, P. Ciacia, and M. Patella. E cient sort-based skyline evaluation. In TODS, volume 33(4), pages 1-49, 2008.
  4. S. Borzsonyi, D. Kossmann, and K. Stocker. The skyline operator. In ICDE, pages 421-430, 2001.
  5. C. Boutilier, R. I. Brafman, C. Domshlak, H. H. Hoos, and D. Poole. Cp-nets: A tool for representing and reasoning with conditional ceteris paribus preference statements. In JAIR, pages 135-191, 2004.
  6. C. Boutilier, R. I. Brafman, C. Domshlak, H. H. Hoos, and D. Poole. Preference-based constrained optimization with cp-nets. In Computational Intelligence, vol-ume 20, pages 137-157, 2004.
  7. C. Boutilier, R. I. Brafman, H. H. Hoos, and D. Poole. Reasoning with conditional ceteris paribus preference statements. In UAI, pages 71-80, 1999.
  8. R. I. Brafman and C. Domshlak. Introducing variable importance tradeo s into cp-nets. In In Proceedings of UAI-02, pages 69-76. Morgan Kaufmann, 2003.
  9. Y. Caseau. E cient handling of multiple inheritance hierarchies. In OOPSLA, pages 271-287, 1993.
  10. C. Y. Chan, P. K. Eng, and K. L. Tan. Stratified computation of skylines with partially-ordered domains. In SIGMOD, pages 203-214, 2005.
  11. C. Y. Chan, H. V. Jagadish, K. L. Tan, A. K. H. Tung, and Z. Zhang. On high dimensional skylines. In EDBT, pages 478-495, 2006.
  12. S. Chaudhuri, N. Dalvi, and R. Kaushik. Robust cardinality and cost estimation for skyline operator. In ICDE, page 64, 2006.

Downloads

Published

2018-02-28

Issue

Section

Research Articles

How to Cite

[1]
Y. Gopi, Nallagonda Anitha, " Skyline Computations with Partially Ordered Domains using Indexing Method , IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 3, Issue 1, pp.1676-1681, January-February-2018.