A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
Filters
The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS
[article]
2020
arXiv
pre-print
Preserved Fulltext
Improvements in execution time of up to 28% can be obtained even with sequences of only two queries. ...
This paper presents optimizations based on query sequences, which reduces the impact of the reconfigurations. ...
The baseline (plan S) is simply executing the query operations in order and completely on the RPU, without considering the reconfigurations required for that. ...
arXiv:2005.01511v1
fatcat:4ipmqw5nkzfwbl3yhrvgs6izbq
Query-Sequence Optimization on a Reconfigurable Hardware-Accelerated System
[article]
2020
arXiv
pre-print
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
Improvements in execution time of up to 21% can be obtained even with sequences of only two queries ...
This paper presents optimizations based on query sequences, which reduces the impact of the reconfigurations. ...
From that, the optimizer generates the hints to the RPU in order to avoid reconfiguration and thus reduce the execution time of the pushed-down query plans. ...
arXiv:2001.10719v1
fatcat:p3ew4mjdr5gjfgkvofbacc2uda
Speculative Dynamic Reconfiguration and Table Prefetching Using Query Look-Ahead in the ReProVide Near-Data-Processing System
2021
Datenbank-Spektrum
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
Improvements in execution time can be "calculated" even if only being able to look one query ahead. ...
In particular, they are partially reconfigurable at runtime, which allows for the runtime adaptation to a variety of queries. ...
Open Access This article is licensed under a Creative Commons Attribution 4.0 International License, which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long ...
doi:10.1007/s13222-020-00363-7
fatcat:s7fwpazpavcerbl5jxuutv4uo4
Squall
2015
Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data - SIGMOD '15
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
In these situations, the DBMS needs to reconfigure how data is partitioned in real-time to maintain performance objectives. ...
An evaluation of our approach on a distributed DBMS shows that Squall can reconfigure a database with no downtime and minimal overhead on transaction latency. ...
But accomplishing this is easier when the DBMS does not support atomic operations on multiple objects. ...
doi:10.1145/2723372.2723726
dblp:conf/sigmod/ElmoreATPAA15
fatcat:hvkss4riwva63bnjdzb52lxalu
Optimizing queries in SQL Server 2008
2010
Buletin ştiinţific: Universitatea din Piteşti. Seria Ştiinţe Economice
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
We'll reflect on the objectives tobe considered in improving the performance of SQL Server instances, we will tackle themostly used techniques for analyzing and optimizing queries and we will describe ...
Microsoft technology, focusing on the latestversion of the proprietary DBMS, SQL Server 2008. ...
The reasons may be related to the application design, but in many cases the DBMS does not return the data quickly enough, due to the nonuse of indexes, deficient design of the queries and/or database schema ...
doaj:6f54edaf39a742679b91808c38691710
fatcat:k4b2rlntffhlhhwkletnhqfn4a
Index Self-tuning with Agent-based Databases
2018
CLEI Electronic Journal
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
We propose in this paper an agent-based database architecture to deal with automatic index creation. Implementation issues are also discussed, for a built-in agents and DBMS integration architecture. ...
We focus here with the self-tuning feature, which demands a somewhat intelligent behavior that agents could add to traditional DBMS modules. ...
For one given operation submitted to the DBMS, the query optimizer generates the best plan with the best real configuration (it only uses objects materialized in the database) and its execution cost. ...
doi:10.19153/cleiej.6.1.6
fatcat:monkgn47vbcj3luehktbo57mji
Approximating an Energy-Proportional DBMS by a Dynamic Cluster of Nodes
[chapter]
2014
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
In this work, we combine our previous findings on energy-proportional storage layers and query processing into a single, transactional DBMS. ...
The most energy-efficient configuration of a single-server DBMS is the highest performing one, if we exclusively focus on specific applications where the DBMS can steadily run in the peak-performance range ...
., workdays are similar to each other, workloads in December keep rising for e-commerce back-end DBMSs, and so on. Therefore, we will focus on forecasting workloads in future experiments. ...
doi:10.1007/978-3-319-05810-8_20
fatcat:u3cnerxgwzamhknf2nd5cuz2uq
STORM: An Approach to Database Storage Management in Clustered Storage Environments
2007
Seventh IEEE International Symposium on Cluster Computing and the Grid (CCGrid '07)
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
The reconfiguration process is guided by the primary optimization objective of minimizing the total data movement required for the reconfiguration, with the secondary constraints of space and balanced ...
Such management involves regular movement of database objects across nodes in the storage cluster so that storage utilization is maximized. ...
Database Object Access Patterns
DBMS Query
Q1 Oracle SELECT Table 2 . Object-usage monitoring queries. ...
doi:10.1109/ccgrid.2007.110
dblp:conf/ccgrid/DuttaR07
fatcat:bonkap6b5ngfpc6yh54n3qhx6i
A database management capability for Ada
1985
Proceedings of the second annual Washington Ada symposium on Ada Ada in the mainstream: applications and education - WADAS '85
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
No quiescence of on-going activities is needed for reconfiguration of the system. As in LDM, our main design objectives for DDM are transportability and performance. ...
in the global query language into a set of subqueries expressed in the different languages supported by the target systems, formulating an efficient plan for executing a sequence of subqueries and data ...
doi:10.1145/325612.325627
fatcat:qehjkhnim5g5bl7zbfgq5ankeu
Relaxed currency and consistency
2004
Proceedings of the 2004 ACM SIGMOD international conference on Management of data - SIGMOD '04
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2015; you can also visit the original URL.
The file type is application/pdf.
We propose to make this knowledge available to the DBMS through explicit currency and consistency (C&C) constraints in queries and develop techniques so the DBMS can guarantee that the constraints are ...
We explain how C&C constraints are enforced in MTCache, our prototype mid-tier database cache, including how constraints and replica update policies are elegantly integrated into the cost-based query optimizer ...
Each column corresponds to one of the main phases during execution of an already-optimized query: setup plan, run plan and shutdown plan. ...
doi:10.1145/1007568.1007661
dblp:conf/sigmod/GuoLRG04
fatcat:jfosto4lnrfxnafor4ns7zzn2u
Clay
2016
Proceedings of the VLDB Endowment
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
Many of these applications exceed the capabilities of a single server, and thus their database has to be deployed in a distributed DBMS. ...
To evaluate our approach, we integrate Clay in a distributed, main-memory DBMS and show that it can generate partitioning schemes that enable the system to achieve up to 15× better throughput and 99% lower ...
Reconfiguration plan Intercept SQL query processing Figure 3 : The Clay framework. ...
doi:10.14778/3025111.3025125
fatcat:avvjkvbxhbcx3go7mr3gl4cgdy
A comparison of data warehousing methodologies
2005
Communications of the ACM
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
In this article, we review and compare several prominent data warehousing methodologies based on a common set of attributes. ...
However, with so many methodologies to choose from, a major concern for many firms is which one to employ in a given data warehousing project. ...
Because query performance is an important issue, some vendors place a lot of emphasis on how queries are designed and processed. Some DBMS vendors allow parallel query generation and execution. ...
doi:10.1145/1047671.1047673
fatcat:jxvwnootlvbphlcziifan6fiai
Database Oriented Grid Middlewares
2009
2009 Fourth Balkan Conference in Informatics
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
generation and problem solving in dynamic, multi-institutional virtual organizations through a distributed, scalable, adaptive and autonomous infrastructure. ...
It focuses on several complementary aspects, such as dynamicity, autonomy, resilience to failures, and performance, and presents the characteristics, capabilities and limitations of existing solutions. ...
Similarly, in GRelC-DGS input queries are concurrently executed at multiple nodes. On the other hand, Open SkyQuery executes the partitioned query plan serially. ...
doi:10.1109/bci.2009.14
dblp:conf/bci/TsamouraG09
fatcat:tctyzmllyvduzcscsndjti5llm
Workload-based generation of administrator hints for optimizing database storage utilization
2008
ACM Transactions on Storage
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
objects residing in the storage devices. ...
STORM's primary objective is minimizing the volume of data movement required (to minimize potential down-time or reduction in performance) during the reconfiguration operation, with the secondary constraints ...
The storage management tasks required for such reconfiguration include information gathering, analysis, decision making, and execution, conforming to the monitor-analyze-plan-execute loop proposed in the ...
doi:10.1145/1326542.1326545
fatcat:h7urmjcblrczjkv5sw3thot2oy
Progressive optimization in a shared-nothing parallel database
2007
Proceedings of the 2007 ACM SIGMOD international conference on Management of data - SIGMOD '07
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
Queries used in such large data warehouses can contain complex predicates as well as multiple joins, and the resulting query execution plans generated by the optimizer may be suboptimal due to mis-estimates ...
This solution has been prototyped in a leading commercial parallel DBMS. We have performed extensive experiments using the TPC-H benchmark and a real-world database. ...
to significant errors in the estimation, resulting in a sub-optimal query execution plan (QEP or plan). ...
doi:10.1145/1247480.1247569
dblp:conf/sigmod/HanNMKK07
fatcat:rtweo2qkezhrbfym3dys3ik3de
« Previous
Showing results 1 — 15 out of 639 results