Finding the TOP N values through the execution of a query
作者： Cetin Ozbutun , Angela Amor
DOI:
关键词:
摘要: A method and mechanism is provided for executing a query that includes subquery, where the subquery an ORDER BY clause. The results generated by are ordered as specified When of referenced outer query, satisfy restriction. For example, restriction may specify row number pseudo-column be less than threshold. In response, TOP N operation performed to return rows in order. order based on
lens.org 参考文章(12)
Kevin Loney, George B. Koch, Oracle 8: The Complete Reference Osborne/McGraw-Hill. ,(1997)
Surajit Chaudhuri, Luis Gravano, Evaluating Top-k Selection Queries very large data bases. pp. 397- 410 ,(1999)
Andrew Witkowski, Karl Dias, Incremental maintenance of materialized views containing one-to-one lossless joins ,(1998)
Hosagrahar Visvesvaraya Jagadish, Shaul Dar, Divesh Srivastava, Alon Yitzchak Levy, Method and system for using materialized views to evaluate queries involving aggregation ,(1997)
Nasi Jazayeri, David G. Wilhite, Lee E. Schumacher, Galt Johnson, Edward P. Haslam, William J. Mckenna, Richard L. Cole, Latha S. Colby, System and method for rewriting relational database queries ,(1999)
A. Segev, J. Park, Maintaining materialized views in distributed databases [1989] Proceedings. Fifth International Conference on Data Engineering. pp. 262- 270 ,(1989) , 10.1109/ICDE.1989.47225
Michael J. Carey, Donald Kossmann, Reducing the Braking Distance of an SQL Query Engine very large data bases. pp. 158- 169 ,(1998)
V. Gopalkrishnam, Qing Li, K. Karlapalem, Issues of object-relational view design in data warehousing environment systems man and cybernetics. ,vol. 3, pp. 2732- 2737 ,(1998) , 10.1109/ICSMC.1998.725074
H.A. Kuno, E.A. Rundensteiner, Augmented inherited multi-index structure for maintenance of materialized path query views international workshop on research issues in data engineering. pp. 128- 137 ,(1996) , 10.1109/RIDE.1996.492250
Michael J. Carey, Donald Kossmann, On saying “Enough already!” in SQL international conference on management of data. ,vol. 26, pp. 219- 230 ,(1997) , 10.1145/253260.253302