Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Order Dependency

  • Jaroslaw SzlichtaEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_80772




Order dependencies (ODs) describe the relationship among lexicographical orderings of sets of tuples. An order specification is a list of attributes marked as asc (ascending) or desc (descending). This is the notion of order used in SQL and within query optimization, as by the order-by operator (nested sort). Let X = [A |T] be a list of marked attributes, the marked attribute A is the head of the list, and the marked list T is the tail. For two tuples s and t, sXtiffX = [ ]; or X = [Aasc|T] and sA < tA; or X = [Adesc|T] and sA > tA; or X = [Aasc|T] or X = [Adesc|T], sA = tA, and sTt. Let r be a table over a relation R that contains the attributes that appear in X and Y. Given two order specifications X and Y a table r satisfies an OD XY, read as XordersY, iff for all s, tr, sXt implies sYt [8]. An OD is unidirectional when attributes within it are all marked as asc or desc [4, 6, 9, 7]. Unidirectional ODs are subsumed by ODs by definition.


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

Recommended Readings

  1. 1.
    Dong J, Hull R. Applying approximate order dependency to reduce indexing space. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1982. p. 119–27.Google Scholar
  2. 2.
    Ginsburg S, Hull R. Order dependency in the relational model. Theor Comput Sci. 1983;26(1):149–95.MathSciNetzbMATHCrossRefGoogle Scholar
  3. 3.
    Golab L, Karloff H, Korn F, Saha A, Srivastava D. Sequential dependencies. Proc VLDB Endow. 2009;2(1):547–85.CrossRefGoogle Scholar
  4. 4.
    Langer P, Naumann F. Efficient order dependency detection. VLDB J. 2016;25(2):223–41.CrossRefGoogle Scholar
  5. 5.
    Malkemus T, Padmanabhan S, Bhattacharjee B, Cranston L. Predicate derivation and monotonicity detection in DB2 UDB. In: Proceedings of the 21st International Conference on Data Engineering; 2005. p. 939–47.Google Scholar
  6. 6.
    Ng W. An extension of the relational data model to incorporate ordered domains. ACM Trans Database Syst. 2001;26(3):344–83.zbMATHCrossRefGoogle Scholar
  7. 7.
    Szlichta J, Godfrey P, Gryz J. Fundamentals of order dependencies. Proc VLDB Endow. 2012;5(11): 1220–31.CrossRefGoogle Scholar
  8. 8.
    Szlichta J, Godfrey P, Gryz J, Zuzarte C. Expressiveness and complexity of order dependencies. Proc VLDB Endow. 2013;5(11):1858–69.CrossRefGoogle Scholar
  9. 9.
    Szlichta J, Godfrey P, Golab L, Kargar M, Srivastava D. Effective and complete discovery of order dependencies via set-based axiomatization. Proc VLDB Endow. 2017;10(7):12.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.University of Ontario Institute of TechnologyOshawaCanada