Back to Search
Start Over
On the Complexity of Database Queries
- Source :
- Journal of Computer and System Sciences. 58(3):407-427
- Publication Year :
- 1999
- Publisher :
- Elsevier BV, 1999.
-
Abstract
- We revisit the issue of the complexity of database queries, in the light of the recent parametric refinement of complexity theory. We show that, if the query size (or the number of variables in the query) is considered as a parameter, then the relational calculus and its fragments (conjunctive queries, positive queries) are classified at appropriate levels of the so-called W hierarchy of Downey and Fellows. These results strongly suggest that the query size is inherently in the exponent of the data complexity of any query evaluation algorithm, with the implication becoming stronger as the expressibility of the query language increases. On the positive side, we show that this exponential dependence can be avoided for the extension of acyclic queries with ≠ (but not
- Subjects :
- Theoretical computer science
Database
Computer Networks and Communications
Computer Science::Information Retrieval
Applied Mathematics
InformationSystems_INFORMATIONSTORAGEANDRETRIEVAL
InformationSystems_DATABASEMANAGEMENT
Online aggregation
Range query (database)
Query optimization
computer.software_genre
Query language
Theoretical Computer Science
Spatial query
Computational Theory and Mathematics
Web query classification
Sargable
Conjunctive query
computer
Computer Science::Databases
Mathematics
Subjects
Details
- ISSN :
- 00220000
- Volume :
- 58
- Issue :
- 3
- Database :
- OpenAIRE
- Journal :
- Journal of Computer and System Sciences
- Accession number :
- edsair.doi.dedup.....af3c5564c5c40c84d41392423285c07f
- Full Text :
- https://doi.org/10.1006/jcss.1999.1626