Abstract
We investigate the complexity of query processing in the logical data model (LDM). We use two measures: data complexity, which is complexity with respect to the size of the data, and expression complexity, which is complexity with respect to the size of the expressions denoting the queries. Our investigation shows that while the operations of product and union are essentially first-order operations, the power set operation is inherently a higher-order operation and is exponentially expensive. We define a hierarchy of queries based on the depth of nesting of power set operations and show that this hierarchy corresponds to a natural hierarchy of Turing machines that run in multiply exponential time.
Extended Abstract
Preview
Unable to display preview. Download preview PDF.
4 References
Abiteboul, S., Hull, R.: IFO, a formal semantic database model. ACM Trans. on Database Systems, Dec. 1987.
Bennet, J.H.: On Spectra, Ph.D. Dissertation, Princeton University, 1962.
Bancilhon, F., Khoshafian, S.: A calculus for complex objects. Proc. ACM Symp. on Principles of Database Systems, 1986.
Chandra, A., Harel, D.: Structure and Complexity of Relational Queries. J. Computer and Systems Sciences 25(1982), pp. 99–128.
Chandra, A.K., Kozen, D.C., Stockmeyer, L.J.: Alternation. J. ACM 28(1981), pp. 114–133.
Codd, E.F.: A relational model of data for large shared data banks. Comm. ACM 13(1970), pp. 377–387.
Codd, E.F.: Extending the database relational model to capture more meaning. ACM Trans. on Database Systems, 4(1979), pp. 397–434.
Fischer, P.C., Thomas, S.J.: Operators for non-first-normal-form relations. Proc. IEEE Computer Software Applications Conference, 1983, pp. 464–475.
Hammer, M., McLeod, D.: Database description with SDM: a semantic database model. ACM Trans. on Database Systems, 6(1981), pp. 351–386.
Hull, R., Su, J.: On the expressive power of database queries with intermediate types. Proc. ACM Symp. on Principles of Database Systems, 1988.
Hopcroft, J.E., Ullman, J.D.: Introduction to Automata Theory, Languages, and Computation, Addison-Wesley, 1979.
Hull, R., Yap, C.K.: The format model: a theory of database organization. Proc. ACM Symp. on Principles of Database Systems, 1982.
Jacobs, B.E.: On database logic. J. ACM 29(1982), pp. 310–322.
Jaeschke, B., Schek, H.J.: Remarks on the algebra of non-first-normal-form relations. Proc. ACM Symp. on Principles of Database Systems, 1982.
Kuper, G.M.: The logical data model: a new approach to database logic. Ph.D. Dissertation, Stanford University, 1985.
Kuper, G.M., Vardi, M.Y.: A new approach to database logic. Proc. ACM Symp. on Principles of Database Systems, 1984.
Kuper, G.M., Vardi, M.Y.: On the expressive power of the logical data model. Proc. SIGMOD, 1985.
Shipman, D.: The functional model and the data language DAPLEX. ACM Trans. on Database Systems, 6(1981), pp. 140–173.
Smith, J.M., Smith, D.C.P.: Database abstractions: aggregation. Comm. ACM 20(1977), pp. 405–413.
Stockmeyer, L.J.: The complexity of decision problems in automata theory and logic. Ph.D. Dissertation, MIT, 1974.
Stockmeyer, L.J.: The polynomial time hierarchy. Theoretical Computer Science 3(1977), pp. 1–22.
Vardi, M.Y.: The complexity of relational query language. Proc. ACM Symp. on Theory of Computing, 1982.
Volger, H.: Turing machines with bounded alternation. Theoretical Computer Science 23(1983), pp. 333–337.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1988 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Kuper, G.M., Vardi, M.Y. (1988). On the complexity of queries in the logical data model. In: Gyssens, M., Paredaens, J., Van Gucht, D. (eds) ICDT '88. ICDT 1988. Lecture Notes in Computer Science, vol 326. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-50171-1_17
Download citation
DOI: https://doi.org/10.1007/3-540-50171-1_17
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-50171-8
Online ISBN: 978-3-540-45943-9
eBook Packages: Springer Book Archive