Abstract
Skyline queries are a popular way to obtain preferred answers from the database by providing only the orderings of attribute values. The result of a skyline query consists of those input tuples for which there is no input tuple having better or equal values in all the attributes and a better value in at least one attribute. In this article, we summarize the basic notions and properties of skyline queries, and discuss their extensions and generalizations. In particular, we consider skyline algorithms and skyline cardinality issues.
- F. Afrati, P. Koutris, D. Suciu, and J.D. Ullman. Parallel Skyline Queries. In International Conference on Database Theory (ICDT), pages 274--284, 2012. Google ScholarDigital Library
- S. Antony, P. W, D. Agrawal, and A. El Abbadi. Aggregate Skyline: Analysis for Online Users. In Symposium on Applications and the Internet (SAINT), pages 50--56. IEEE, 2009. Google ScholarDigital Library
- W-T. Balke, U. Güntzer, and J. X. Zhang. Efficient Distributed Skylining for Web Information Systems. In International Conference on Extending Database Technology (EDBT), pages 256--273, 2004.Google Scholar
- I. Bartolini, P. Ciaccia, and M. Patella. Efficient Sort-Based Skyline Evaluation. ACM Transactions on Database Systems, 33(4), 2008. Google ScholarDigital Library
- I. Bartolini, P. Ciaccia, and M. Patella. The Skyline of a Probabilistic Relation. IEEE Transactions on Knowledge and Data Engineering, 25(7):1656--1669, 2013. Google ScholarDigital Library
- I. Bartolini, Z. Zhang, and D. Papadias. Collaborative Filtering with Personalized Skylines. IEEE Transactions on Knowledge and Data Engineering, 23(2):190--203, 2011. Google ScholarDigital Library
- J. L. Bentley, H. T. Kung, M. Schkolnick, andC. D. Thompson. On the Average Number of Maxima in a Set of Vectors and Applications. Journal of the ACM, 25(4):536--543, 1978. Google ScholarDigital Library
- S. Börzsönyi, D. Kossmann, and K. Stocker. The Skyline Operator. In IEEE International Conference on Data Engineering (ICDE), pages 421--430, 2001. Google ScholarDigital Library
- C. Buchta. On the Average Number of Maxima in a Set of Vectors. Information Processing Letters, 33:63--65, 1989. Google ScholarDigital Library
- J. Chomicki. Preference Formulas in Relational Queries. ACM Transactions on Database Systems, 28(4):427--466, December 2003. Google ScholarDigital Library
- J. Chomicki. Semantic Optimization Techniques for Preference Queries. Information Systems, 32(5):660--674, 2007. Google ScholarDigital Library
- J. Chomicki, P. Godfrey, J. Gryz, and D. Liang. Skyline with Presorting. In IEEE International Conference on Data Engineering m(ICDE), pages 717--719, 2003.Google Scholar
- J. Chomicki, P. Godfrey, J. Gryz, and D. Liang. Skyline with Presorting: Theory and Optimizations. In Intelligent Information Systems, pages 595--604. Springer, Advances in Soft Computing, 2005. Full version with proofs: Technical Report CS-2002-04, October 2002, Department of Computer Science, York University.Google Scholar
- W. W. Cohen, R. E. Schapire, and Y. Freund. Learning to Order Things. Journal of Artificial Intelligence Research, 10:243--270, 1999. Google ScholarCross Ref
- R. Dellis and B. Seeger. Efficient Computation of Reverse Skyline Queries. In International Conference on Very Large Data Bases (VLDB), pages 291--302, 2007. Google ScholarDigital Library
- M. Ehrgott. Multicriteria Optimization. Springer, 2nd edition, 2005. Google ScholarDigital Library
- J. Pei et al. Towards Multidimensional Subspace Skyline Analysis. ACM Transactions on Database Systems, 31(4):1335--1381, 2006. Google ScholarDigital Library
- R. Fagin. Combining Fuzzy Information from Multiple Systems. Journal of Computer and System Sciences, 58(1):83--99, 1999. Google ScholarDigital Library
- R. Fagin, A. Lotem, and M. Naor. Optimal Aggregation Algorithms for Middleware. Journal of Computer and System Sciences, 66(4):614--656, 2003. Google ScholarDigital Library
- P. C. Fishburn. Preference Structures and their Numerical Representations. Theoretical Computer Science, 217:359--383, 1999. Google ScholarDigital Library
- D. Fuhry, R. Jin, and D. Zhang. Efficient Skyline Computation in Metric Space. In International Conference on Extending Database Technology (EDBT), pages 1042--1051, 2009. Google ScholarDigital Library
- P. Godfrey. Skyline Cardinality for Relational Processing. In International Symposium on Foundations of Information and Knowledge Systems (FOIKS), pages 78--97. Springer-Verlag 2942, 2004.Google Scholar
- P. Godfrey, R. Shipley, and J. Gryz. Maximal Vector Computation in Large Data Sets. In International Conference on Very Large Data Bases (VLDB), pages 229--240, 2005. Google ScholarDigital Library
- P. Godfrey, R. Shipley, and J. Gryz. Algorithms and Analyses for Maximal Vector Computation. VLDB Journal, 16:5--28, 2007. Google ScholarDigital Library
- T. F. Gonzalez. Clustering to Minimize the Maximum Intercluster Distance. Theoretical Computer Science, 38:293--306, 1985.Google ScholarCross Ref
- B. Hafenrichter and W. Kiesling. Optimization of Relational Preference Queries. In Australasian Database Conference (ADC), pages 175--184, 2005. Google ScholarDigital Library
- K. Hose and A. Vlachou. A Survey of Skyline Processing in Highly Distributed Environments. The VLDB Journal, 21(3):359--384, 2012. Google ScholarDigital Library
- H. Im and S. Park. Group Skyline Computation . Information Sciences, 188(0):151--169, 2012. Google ScholarDigital Library
- B. Jiang, J. Pei, X. Lin, D. W. Cheung, and J. Han. Mining Preferences from Superior and Inferior Examples. In KDD, pages 390--398, 2008. Google ScholarDigital Library
- S. Kaci. Working with Preferences: Less is More. Springer, 2011. Google ScholarDigital Library
- W. Kiesling. Foundations of Preferences in Database Systems. In International Conference on Very Large Data Bases (VLDB), pages 311--322, 2002. Google ScholarDigital Library
- V. Koltun and C. H. Papadimitriou. Approximately Dominating Representatives. Theoretical Computer Science, 371(3):148--154, 2007. Google ScholarDigital Library
- H. T. Kung, F. Luccio, and F. P. Preparata. On Finding the Maxima of a Set of Vectors. Journal of the ACM, 22(4):469--476, 1975. Google ScholarDigital Library
- K.C.K. Lee, B. Zheng, H. Li, and W.-C. Lee. Approaching the Skyline in Z Order. In International Conference on Very Large Data Bases (VLDB), pages 279--290, 2007. Google ScholarDigital Library
- C. Li, N. Zhang, N. Hassan, S. Rajasekaran, and G. Das. On Skyline Groups. In International Conference on Information and Knowledge Management (CIKM), pages 2119--2123, 2012. Google ScholarDigital Library
- X. Lin, Y. Yuan, Q. Zhang, and Y. Zhang. Selecting Stars: the k Most Representative Skyline Operator. In IEEE International Conference on Data Engineering (ICDE), pages 86--95, 2007.Google ScholarCross Ref
- C. Lofi, U. Güntzer, and W-T. Balke. Efficient Computation of Trade-Off Skylines. In International Conference on Extending Database Technology (EDBT), pages 597--608, 2010. Google ScholarDigital Library
- D. Mindolin and J. Chomicki. Preference Elicitation in Prioritized Skyline Queries. VLDB Journal, 20(2):157--182, 2011. Special issue: selected papers from VLDB 2009. Google ScholarDigital Library
- M.D. Morse, J.M. Patel, and H.V. Jagadish. Efficient Skyline Computation over Low-Cardinality Domains. In International Conference on Very Large Data Bases (VLDB), pages 267--278, 2007. Google ScholarDigital Library
- D. Papadias, Y. Tao, G. Fu, and B. Seeger. An Optimal and Progressive Algorithm for Skyline Queries. In ACM SIGMOD International Conference on Management of Data, pages 467--478, 2003. Google ScholarDigital Library
- D. Papadias, Y. Tao, G. Fu, and B. Seeger. Progressive Skyline Computation in Database Systems. ACM Transactions on Database Systems, 30(1):41--82, 2005. Google ScholarDigital Library
- J. Pei, B. Jiang, X. Lin, and Y. Yuan. Probabilistic Skylines on Uncertain Data. In VLDB, pages 15--26, 2007. Google ScholarDigital Library
- A. Das Sarma, A. Lall, D. Nanongkai, R. J. Lipton, and J. Xu. Representative Skylines Using Threshold-Based Preference Distributions. In IEEE International Conference on Data Engineering (ICDE), pages 387--398, 2011. Google ScholarDigital Library
- M. Sharifzadeh and C. Shahabi. The Spatial Skyline Queries. In International Conference on Very Large Data Bases (VLDB), pages 751--762, 2006. Google ScholarDigital Library
- C. Sheng and Y. Tao. Finding Skylines in External Memory. In ACM Symposium on Principles of Database Systems (PODS), pages 107--116, 2011. Google ScholarDigital Library
- Y. Tao, L. Ding, X. Lin, and J. Pei. Distance-Based Representative Skyline. In IEEE International Conference on Data Engineering (ICDE), pages 892--903, 2009. Google ScholarDigital Library
- Y. Tao and D. Papadias. Maintaining Sliding Window Skylines on Data Streams. IEEE Transactions on Knowledge and Data Engineering, 18(3):377--391, 2006. Google ScholarDigital Library
- G. Trimponias, I. Bartolini, D. Papadias, and Y. Yang. Skyline Processing on Distributed Vertical Decompositions. IEEE Transactions on Knowledge and Data Engineering, 25(4):850--862, 2013. Google ScholarDigital Library
- A. Vlachou, Ch. Doulkeridis, and N. Polyzotis. Skyline Query Processing over Joins. In ACM SIGMOD International Conference on Management of Data, pages 73--84, 2011. Google ScholarDigital Library
- W. Zhang, X. Lin, Y. Zhang, M. A. Cheema, and Q. Zhang. Stochastic Skylines. ACM Transactions on Database Systems, 37(2), 2012. Google ScholarDigital Library
- X. Zhang and J. Chomicki. Semantics and Evaluation of Top-k Queries in Probabilistic Databases. Distributed and Parallel Databases, 26(1):67--126, 2009. Google ScholarDigital Library
- X. Zhang and J. Chomicki. Preference Queries over Sets. In IEEE International Conference on Data Engineering (ICDE), pages 1019--1030, April 2011. Google ScholarDigital Library
Recommendations
U-Skyline: A New Skyline Query for Uncertain Databases
The skyline query, aiming at identifying a set of skyline tuples that are not dominated by any other tuple, is particularly useful for multicriteria data analysis and decision making. For uncertain databases, a probabilistic skyline query, called P-...
Caching Dynamic Skyline Queries
SSDBM '08: Proceedings of the 20th international conference on Scientific and Statistical Database ManagementGiven a query tuple <em>q</em>, the dynamic skyline query retrieves the tuples that are not dynamically dominated by any other in the data set with respect to <em>q</em>. A tuple dynamically dominates another, w.r.t. <em>q</em>, if it has closer to <em>...
Top-k combinatorial skyline queries
DASFAA'10: Proceedings of the 15th international conference on Database Systems for Advanced Applications - Volume Part IIThe problem of top-k skyline computation has attracted considerable research attention in the past few years. Given a dataset, a top-k skyline returns k “most interesting” skyline tuples based on some kind of preference specified by the user. We extend ...
Comments