Filters








639 Hits in 3.7 sec

The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS [article]

Lekshmi B.G. and Andreas Becher and Klaus Meyer-Wegener
2020 arXiv   pre-print
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]

Lekshmi B.G., Andreas Becher, Klaus Meyer-Wegener
2020 arXiv   pre-print
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

Lekshmi Beena Gopalakrishnan, Andreas Becher, Stefan Wildermann, Klaus Meyer-Wegener, Jürgen Teich
2021 Datenbank-Spektrum  
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

Aaron J. Elmore, Vaibhav Arora, Rebecca Taft, Andrew Pavlo, Divyakant Agrawal, Amr El Abbadi
2015 Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data - SIGMOD '15  
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

Ion LUNGU, Nicolae MERCIOIU, Victor VLADUCU
2010 Buletin ştiinţific: Universitatea din Piteşti. Seria Ştiinţe Economice  
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

Rogerio Luıs De Carvalho Costa, Sergio Lifschitz, Marcos Antonio Vaz Salles
2018 CLEI Electronic Journal  
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]

Daniel Schall, Theo Härder
2014 Lecture Notes in Computer Science  
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

Kaushik Dutta, Raju Rangaswami
2007 Seventh IEEE International Symposium on Cluster Computing and the Grid (CCGrid '07)  
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

Aryola Chan, Sy Danberg, Terry Landers, Anil Nori, John M. Smith, Stephen Fox
1985 Proceedings of the second annual Washington Ada symposium on Ada Ada in the mainstream: applications and education - WADAS '85  
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

Hongfei Guo, Per-Åke Larson, Raghu Ramakrishnan, Jonathan Goldstein
2004 Proceedings of the 2004 ACM SIGMOD international conference on Management of data - SIGMOD '04  
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

Marco Serafini, Rebecca Taft, Aaron J. Elmore, Andrew Pavlo, Ashraf Aboulnaga, Michael Stonebraker
2016 Proceedings of the VLDB Endowment  
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

Arun Sen, Atish P. Sinha
2005 Communications of the ACM  
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

Efthymia Tsamoura, Anastasios Gounaris
2009 2009 Fourth Balkan Conference in Informatics  
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

Kaushik Dutta, Raju Rangaswami, Sajib Kundu
2008 ACM Transactions on Storage  
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

Wook-Shin Han, Jack Ng, Volker Markl, Holger Kache, Mokhtar Kandil
2007 Proceedings of the 2007 ACM SIGMOD international conference on Management of data - SIGMOD '07  
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