Query interactions in database workloads

2008

Proceedings of the 2011 international conference on Management of data - SIGMOD '11, 2011

Proceedings of the Fifth International Workshop on Testing Database Systems, 2012

2015

TPC benchmarks are the most adopted benchmarks by academia and industry regarding database transactions performance. These benchmarks, together with the benchmark TATP, simulate a large range of the industry applications for databases. We use these benchmarks diversity to see how database behaves under different applications. In this work we investigate low-level characteristics of database systems when the benchmarks TPC-B, TPC-C, TPC-E, TPC-H, and TATP are executed, in order to understand how different applications properties impact the internal behavior of the system. The goal of such investigation is to understand typical application patterns and how they affect individual system components. This helps developers and administrators of database systems to improve performance and find optimal configuration parameters. We use in this work the storage manager Shore-MT to collect statistics of some internal components and detailed patterns of access to pages of the database. When we ...

22nd Digital Avionics Systems Conference. Proceedings (Cat. No.03CH37449)

2015 IEEE 17th International Conference on High Performance Computing and Communications, 2015 IEEE 7th International Symposium on Cyberspace Safety and Security, and 2015 IEEE 12th International Conference on Embedded Software and Systems, 2015

We propose a methodology to look at violence in particular, and other aspects of quantitative historiography in general in a way compatible with statistical inference, which needs to accommodate the fat-tailedness of the data and the unreliability of the reports of conflicts. We investigate the theses of " long peace " and drop in violence and find that these are statistically invalid and resulting from flawed and naive methodologies, incompatible with fat tails and non-robust to minor changes in data formatting and methodologies. There is no statistical basis to claim that " times are different " owing to the long inter-arrival times between conflicts; there is no basis to discuss any " trend " , and no scientific basis for narratives about change in risk. We describe naive empiricism under fat tails. We also establish that violence has a " true mean " that is underestimated in the track record. This is a historiographical adaptation of the results in Cirillo and Taleb (2016). PUBLISHED IN "PROCEEDINGS OF THE NOBEL SYMPOSIUM", NOBEL COMMISSION.