Search engine for discovering works of Art, research articles, and books related to Art and Culture
Javascript must be enabled to continue!
A Variability Model for Query Optimizers
View through CrossRef
By adopting to more domains, database management systems (DBMSs) increase their functionality continously. This leads to DBMSs that often include unnecessary functionality, which decreases performance. A result of this trend is that new specialized systems arise that focus only on a certain application scenario but often reimplement already existing functionality. To avoid bloated DBMSs, we propose to introduce variability in DBMS implementations that allows users to select only needed functionality for a specific application scenario. In this paper, we focus on the query optimizer as it is a key component of DBMSs. We describe the potentials of tailoring query optimizers. Furthermore, we analyze common and differing functionality of three query optimizers of industrial DBMSs (SQLite, Oracle, and PostgreSQL) to create a variability model for query optimizers that can be used as a basis for future variability-aware implementations.
Title: A Variability Model for Query Optimizers
Description:
By adopting to more domains, database management systems (DBMSs) increase their functionality continously.
This leads to DBMSs that often include unnecessary functionality, which decreases performance.
A result of this trend is that new specialized systems arise that focus only on a certain application scenario but often reimplement already existing functionality.
To avoid bloated DBMSs, we propose to introduce variability in DBMS implementations that allows users to select only needed functionality for a specific application scenario.
In this paper, we focus on the query optimizer as it is a key component of DBMSs.
We describe the potentials of tailoring query optimizers.
Furthermore, we analyze common and differing functionality of three query optimizers of industrial DBMSs (SQLite, Oracle, and PostgreSQL) to create a variability model for query optimizers that can be used as a basis for future variability-aware implementations.
Related Results
Named Entity Recognition in Statistical Dataset Search Queries
Named Entity Recognition in Statistical Dataset Search Queries
Search engines must understand user queries to provide relevant search results. Search engines can enhance their understanding of user intent by employing named entity recognition ...
RaPID-Query for Fast Identity by Descent Search and Genealogical Analysis
RaPID-Query for Fast Identity by Descent Search and Genealogical Analysis
AbstractThe size of genetic databases has grown large enough such that, genetic genealogical search, a process of inferring familial relatedness by identifying DNA matches, has bec...
RDF Subgraph Matching by Means of Star Decomposition
RDF Subgraph Matching by Means of Star Decomposition
<p>With the continuous development of the network, the scale of RDF data is becoming larger and larger. In the face of large-scale RDF data processing, the traditional databa...
Some new fuzzy query processing methods based on similarity measurement and fuzzy data clustering
Some new fuzzy query processing methods based on similarity measurement and fuzzy data clustering
In relational and object-oriented database systems there is always data that is naturally fuzzy or uncertain. However, to deal with complex data types with fuzzy nature, these syst...
Forcing climate variability has large impacts on terrestrial carbon storage in a dynamic global vegetation model
Forcing climate variability has large impacts on terrestrial carbon storage in a dynamic global vegetation model
<p>Terrestrial carbon storage is largely driven by prevailing climate conditions. However, ecosystems are not only affected by mean climate conditions but also by day...
Neural Embedding-Based Metrics for Pre-retrieval Query Performance Prediction
Neural Embedding-Based Metrics for Pre-retrieval Query Performance Prediction
<p>Pre-retrieval Query Performance Prediction (QPP) methods are oblivious to the performance of the retrieval model as they predict query difficulty prior to observing the se...
Neural Embedding-Based Metrics for Pre-retrieval Query Performance Prediction
Neural Embedding-Based Metrics for Pre-retrieval Query Performance Prediction
<p>Pre-retrieval Query Performance Prediction (QPP) methods are oblivious to the performance of the retrieval model as they predict query difficulty prior to observing the se...
Probing AGN Accretion Physics through AGN Variability
Probing AGN Accretion Physics through AGN Variability
Active Galactic Nuclei (AGN) exhibit large luminosity variations over the entire electromagnetic spectrum on timescales ranging from hours to years. The variations in luminosity ar...