Filters








517 Hits in 6.0 sec

Yet Another Automated OLAP Workload Analyzer: Principles, and Experiences

Alfredo Cuzzocrea, Rim Moussa, Enzo Mumolo
2018 Proceedings of the 20th International Conference on Enterprise Information Systems  
As a case of study, we consider TPC-DS benchmark -the de-facto industry standard benchmark for measuring the performance of decision support solutions including.  ...  In order to tune a data warehouse workload, we need automated recommenders on when and how (i) to partition data and (ii) to deploy summary structures such as derived attributes, aggregate tables, and  ...  The TPC-DS benchmark is launched for next generation of decision support system benchmarking to replace the TPC-H benchmark. It is described in next Section.  ... 
doi:10.5220/0006812202930298 dblp:conf/iceis/CuzzocreaMM18 fatcat:jfcb6xhevzec5feszkvxilcsje

Variations of the star schema benchmark to test the effects of data skew on query performance

Tilmann Rabl, Meikel Poess, Hans-Arno Jacobsen, Patrick O'Neil, Elizabeth O'Neil
2013 Proceedings of the ACM/SPEC international conference on International conference on performance engineering - ICPE '13  
The Star Schema Benchmark (SSB), has been widely used to evaluate the performance of database management systems when executing star schema queries.  ...  This is also true for other database system parts, such as indices and operators, and ultimately holds for an end-to-end benchmark as well.  ...  While for the technology available at that time, TPC-D and TPC-H imposed many challenges, both on hardware and on database management systems (DBMS).  ... 
doi:10.1145/2479871.2479927 dblp:conf/wosp/RablPJOO13 fatcat:wh6sz6bekrhoviw6m4oqtaakqm

XBench - A Family of Benchmarks for XML DBMSs [chapter]

Benjamin B. Yao, M. Tamer Özsu, John Keenleyside
2003 Lecture Notes in Computer Science  
We discuss the general requirements for an XML DBMS benchmark, followed by a detailed explanation of the XBench, including the methodology of database generation, the workload, and the setup of test environment  ...  The range of XML application and the XML data that they manage are quite varied and no one database schema and workload can properly capture this variety.  ...  We thank Ning Zhang for his help in verifying the query workload.  ... 
doi:10.1007/3-540-36556-7_14 fatcat:wsq44b3ldbdxreoz5cjeafxx7i

PIQL

Michael Armbrust, Kristal Curtis, Tim Kraska, Armando Fox, Michael J. Franklin, David A. Patterson
2011 Proceedings of the VLDB Endowment  
In this paper, we present the PIQL query processing system and evaluate its scale independence on hundreds of machines using two benchmarks, TPC-W and SCADr.  ...  Unfortunately, the data independence provided by a traditional relational database system, while useful for agile development, only exacerbates the problem by hiding potentially expensive queries under  ...  ACKNOWLEDGMENTS We would like to thank the following people, along with the reviewers, for feedback that significantly improved the content of this paper: Bill Bolosky, Henry Cook, Michael Jordan, Kimberly  ... 
doi:10.14778/2078331.2078334 fatcat:hximwyzejbeh7ig4hp4g5id7ti

PIQL: Success-Tolerant Query Processing in the Cloud [article]

Michael Armbrust, Kristal Curtis, Tim Kraska, Armando Fox, Michael J. Franklin, David A. Patterson
2011 arXiv   pre-print
In this paper, we present the PIQL query processing system and evaluate its scale independence on hundreds of machines using two benchmarks, TPC-W and SCADr.  ...  Unfortunately, the data independence provided by a traditional relational database system, while useful for agile development, only exacerbates the problem by hiding potentially expensive queries under  ...  ACKNOWLEDGMENTS We would like to thank the following people, along with the reviewers, for feedback that significantly improved the content of this paper: Bill Bolosky, Henry Cook, Michael Jordan, Kimberly  ... 
arXiv:1111.7166v1 fatcat:uijb7rd7ffgalhj4cjgsfqkipe

JECB

Khai Q. Tran, Jeffrey F. Naughton, Bruhathi Sundarmurthy, Dimitris Tsirogiannis
2014 Proceedings of the 2014 ACM SIGMOD international conference on Management of data - SIGMOD '14  
JECB leverages partitioning by key-foreign key relationships to automatically identify the best way to partition tables using attributes from tables.  ...  In this paper, we present a low-overhead data partitioning approach, termed JECB, that can reduce the number of distributed transactions in complex database workloads such as TPC-E.  ...  Acknowledgement This work was supported by a grant from the Microsoft Gray Systems Lab.  ... 
doi:10.1145/2588555.2610532 dblp:conf/sigmod/TranNST14 fatcat:4r7d3o7obzh6nfwx5w37djn5ty

Characterization of TPC-H queries for a column-oriented database on a dual-core amd athlon processor

Pranav Vaidya, Jaehwan (John) Lee
2008 Proceeding of the 17th ACM conference on Information and knowledge mining - CIKM '08  
However, there have been few investigations on the detailed hardware characterization of DSS benchmarks namely TPC-H for column-oriented databases.  ...  In this paper, we characterize the performance of the TPC-H benchmark for a popular column-oriented database called MonetDB running on a dual-core AMD Athlon machine.  ...  Database Workload The TPC-H benchmark [8] is a Decision Support System (DSS) benchmark consisting of complex business-oriented queries against a database schema that models real world business databases  ... 
doi:10.1145/1458082.1458306 dblp:conf/cikm/VaidyaL08 fatcat:6lkdj6vfnrhdnnrqmfjbvp7zbe

Private Database Synthesis for Outsourced System Evaluation

Vani Gupta, Gerome Miklau, Neoklis Polyzotis
2011 Alberto Mendelzon Workshop on Foundations of Data Management  
These statistics are safe to release, so a third party can then use them to generate one or more synthetic databases to be used as a surrogate for the true database.  ...  The synthetic database and workload can be used by a third party to accurately carry out performance tuning, index selection, or other system evaluation tasks.  ...  In both cases we use the TPC-H benchmark database, scale factor 1, and Postgres 8.1. We focused on query result cardinality as a performance metric.  ... 
dblp:conf/amw/GuptaMP11 fatcat:4y3j43gmfbg77ll2hapmwg3dmy

How Achaeans Would Construct Columns in Troy

Alekh Jindal, Felix Martin Schuhknecht, Jens Dittrich, Karen Khachatryan, Alexander Bunte
2013 Conference on Innovative Data Systems Research  
We demonstrate Trojan Columns on a row-oriented commercial database DBMS-X, a closed source top notch database system. We show experimental results from TPC-H benchmarks.  ...  Trojan Columns does not need access to the source code of the database system. Instead, it uses UDFs as a pluggable storage layer to write and read data.  ...  To do so, we run unmodified TPC-H queries on Trojan Columns as well as on two other systems: (i) a top notch commercial row-oriented database system DBMS-Y, with vendor support for column store technology  ... 
dblp:conf/cidr/JindalSDKB13 fatcat:vqsersrvy5cezg7ebzbt4eqami

Multidimensional Database Design via Schema Transformation: Turning TPC-H into the TPC-H*d Multidimensional Benchmark

Alfredo Cuzzocrea, Rim Moussa
2013 International Conference on Management of Data  
We successfully used the framework to revolve the well known TPC-H benchmark to become a multidimensional benchmark -TPC-H*d benchmark, and translated into MDX language (MultiDimensional eXpressions) the  ...  In order to assess the effectiveness and the efficiency of our proposal, we benchmark the open source Mondrian ROLAP server and its OLAP4j driver with TPC-H*d benchmark.  ...  The database schema of TPC-H*d benchmark is illustrated in Fig. 2 .  ... 
dblp:conf/comad/CuzzocreaM13 fatcat:t6uijrlayrdf5ac3m3odcwid4i

Jackpine: A benchmark to evaluate spatial database performance

Suprio Ray, Bogdan Simion, Angela Demke Brown
2011 2011 IEEE 27th International Conference on Data Engineering  
In contrast to transaction processing, however, there is no standard, widely used benchmark for spatial database operations. In this paper, we present a spatial database benchmark called Jackpine.  ...  Benchmarks play a crucial role in evaluating the functionality and performance of a particular database, both for application users and developers, and for the database developers themselves.  ...  It is our hope that Jackpine will be useful on its own, and will serve as a basis for ongoing discussion and development of a standard spatial benchmark for the community.  ... 
doi:10.1109/icde.2011.5767929 dblp:conf/icde/RaySB11 fatcat:6kms4dgexna35jv23jsbol2vwu

A Benchmark for Online Non-blocking Schema Transformations

Lesley Wevers, Matthijs Hofstra, Menno Tammens, Marieke Huisman, Maurice van Keulen
2015 Proceedings of 4th International Conference on Data Management Technologies and Applications  
Based on these transformations and our criteria, we have developed a benchmark that extends the standard TPC-C benchmark with schema transformations, which can be used to analyze the blocking behavior  ...  This paper presents a benchmark for measuring the blocking behavior of schema transformations in relational database systems.  ...  BENCHMARK SPECIFICATION In this section, we describe a benchmark to investigate the behavior of online schema transformations in database systems.  ... 
doi:10.5220/0005500202880298 dblp:conf/data/WeversHTHK15 fatcat:ypowcfriofabbjqdjrl7sxuili

The Linked Data Benchmark Council Project

Peter Boncz, Irini Fundulaki, Andrey Gubichev, Josep Larriba-Pey, Thomas Neumann
2013 Datenbank-Spektrum  
Despite the fast growth and increasing popularity, the broad field of RDF and Graph database systems lacks an independent authority for developing benchmarks, and for neutrally assessing benchmark results  ...  Inspired by the impact of the Transaction Processing Performance Council (TPC) Benchmarks on relational databases, the LDBC consortium formed by University and Industry researchers and practitioners has  ...  Conclusions In this paper we presented the Linked Data Benchmarking Council, the initiative towards RDF/Graph benchmarking.  ... 
doi:10.1007/s13222-013-0125-y fatcat:qmqlsg23djf5dn24eavhffhuou

Data generation using declarative constraints

Arvind Arasu, Raghav Kaushik, Jian Li
2011 Proceedings of the 2011 international conference on Management of data - SIGMOD '11  
This problem is motivated by database system and application testing, data masking, and benchmarking.  ...  the generated database have a certain cardinality.  ...  Each intermediate cardinality maps to a cardinality constraint.  ... 
doi:10.1145/1989323.1989395 dblp:conf/sigmod/ArasuKL11 fatcat:n5coka3jbnfpjddmzi2gl52faa

TPC-H Analyzed: Hidden Messages and Lessons Learned from an Influential Benchmark [chapter]

Peter Boncz, Thomas Neumann, Orri Erling
2014 Lecture Notes in Computer Science  
The TPC-D benchmark was developed almost 20 years ago, and even though its current existence as TPC-H could be considered superseded by TPC-DS, one can still learn from it.  ...  On the meta-level, we make the point that the rich set of choke-points found in TPC-H sets an example on how to design future DBMS benchmarks. 4  ...  The original TPC-D benchmark did not allow the use of vertical partitioning.  ... 
doi:10.1007/978-3-319-04936-6_5 fatcat:dy5nfvl6avbfvgq5yt6adjrnva
« Previous Showing results 1 — 15 out of 517 results