Grant Fritchey · Apress eBooks · 2018
Knowing how to identify performance issues and knowing how to fix them are great skills to have. The problem, though, is that you need to be able to demonstrate that the improvements you make are real improvements. While you can, and should, capture the performance metrics before and after you tune a query or add an index, the best way to be sure you’re looking at measurable improvement is to put the changes you make to work. Testing means more than simply running a query a few times and then putting it into your production system with your fingers crossed. You need to have a systematic way to validate performance improvements using the full panoply of queries that are run against your system in a realistic manner. Introduced with the 2012 version, SQL Server provides such a mechanism through its Distributed Replay tool.
Cited by 1
Bert Scalzo · Apress eBooks · 2018
In this final chapter, we’re going to discuss simple database stress testing, plus present a free scripting tool that I’ve written for people to utilize or alter to fit their specific needs. A stress test is much like an industry-standard benchmark in that it attempts to press the database. It’s quite different as it applies simple, atomic transactions to merely stress the underlying subsystems, especially the IO bandwidth. I think of stress testing as being more like “gunning the engine” of an automobile, where the car is in neutral and you just want to see how high the RPM’s can go before redlining. That does not mean that such testing is any less valuable, just that it basically serves a different testing purpose. For many people this is sufficient for what they might call database benchmarking.
Cited by 0
Jorge H Ramírez, Michael Langan · Figshare · 2014
<em>Dec 13, 2014. </em> <strong>Drug testing database:</strong> ClinicalTrials.gov ―24640 found for 'drug testing' (Search Date: Dec 13, 2014). More data will be added to this figshare article in the future. <em>Analysis will be disclosed in any or all of these sites:</em> fig<strong>share</strong>, disruptedphysician.com, chaoticpharmacology.com, or a peer-review medical journal. This database complies with terms and conditions of ClinicalTrials.gov: http://clinicaltrials.gov/ct2/about-site/terms-conditions
Cited by 0Open access
Jorge H Ramírez, Michael Langan · Figshare · 2014
<em>Dec 13, 2014. </em> <strong>Drug testing database:</strong> ClinicalTrials.gov ―24640 found for 'drug testing' (Search Date: Dec 13, 2014). More data will be added to this figshare article in the future. <em>Analysis will be disclosed in any or all of these sites:</em> fig<strong>share</strong>, disruptedphysician.com, chaoticpharmacology.com, or a peer-review medical journal. This database complies with terms and conditions of ClinicalTrials.gov: http://clinicaltrials.gov/ct2/about-site/terms-conditions
Cited by 0Open access
David Švamberk · Digital Repository (National Repository of Grey Literature) · 2010
This bachelor thesis deals with the testing of performance database platforms. The main objective is to create custom tools to generate test databases and tools for performance testing of various platforms. Testing or measuring tools are then applied to the selected database platforms and the results of these measurements display the graphs and tables generated from the assessed and then processed measured values.
Cited by 0
Prof S. Sudarshan · 2008
1.1 Issues in testing DB applications................................ 1 1.2 Organization of the Report................................... 1
Cited by 0
Edward Hung · 2001
Database systems are important in research as well as industry. However, few work were done for testing database applications. Based on the design of the framework and the state generator in Chays et al&apos;s paper[1], we have designed the input generator to generate inputs (test cases) for database applications. Part of the test cases are based on the state, and the other part are independent. We have implemented a more realistic database application, the state generator and the input generator. Our experiment shows that the two sets of test cases are complementary to each other. We also notice that it is not straight forward to generate an initial state so that the inputs generated can cover possible situations for the application as many as possible. We also suggest the need to automatically compute expected outputs and to enhance Chays et al.&apos;s design of the state generator, which cannot handle many important kinds of constraints that can be specified in a database schema. 1
Cited by 0
Peter Alvaro, Manuel Rigger · Queue · 2023
The automated testing of DBMS is an exciting, interdisciplinary effort that has seen many innovations in recent years. The examples addressed here represent different perspectives on this topic, reflecting strands of research from software engineering, (database) systems, and security angles. They give only a glimpse into these research strands, as many additional interesting and effective works have been proposed. Various approaches generate pairs of related tests to find both logic bugs and performance issues in a DBMS. Similarly, other isolation-level testing approaches have been proposed. Finally, various fuzzing approaches use different strategies to generate mostly valid and interesting test inputs that extract various kinds of feedback from the DBMS.
Cited by 2Open access
Robert Setiadi · Swinburne Research Bank (Swinburne University of Technology) · 2015
Most of modern applications use database to store data and retrieve them when necessary. This research proposes After-State Database Testing, a testing framework that aims to reveal data that are inconsistent with the business rules and system specifications of a database application. Inconsistent data can be used to reveal potential faults in the system. This framework defines a structured model to enable systematic extraction of consistency rules and an algorithm to automatically generate consistency rules based on existing data using data mining approach. Better testing will lead to better software quality.
Cited by 0Open access
Phyllis Frankl, Jiong Wang · 2004
Commercial, scientific, and social activities are increasingly becoming dependent on Web database applications. New testing techniques that handle the unique features of these systems are needed. To that end, we have extended AGENDA, a tool set for testing relational database applications, to test web database applications. Application source code is analyzed to extract relevant information about the URLs and their parameters. This information is used to construct and simplify a graph in which nodes represent URLs and edges represent links between URLs. A set of paths through the graph is selected and test cases are generated for each path. The extracted information about the parameters to each URL (e.g., values that an application user would enter into a form), is used to guide AGENDA to generate inputs for the URLs. The URLs on a path and their inputs are stored in an XML file, which is then automatically executed. The current implementation is targeted toward web applications written as Java Servlets and uses an algorithm based on cyclomatic complexity to generate paths. Preliminary empirically evaluation based on the TPC-W benchmark is presented.
Cited by 0
2008
Database application programs are often designed to be executed concurrently by many clients. By grouping related database queries into transactions, DBMS systems can guarantee that each transaction satisfies the well-known ACID properties: Atomicity, Consistency, Isolation, and Durability. However, if a database application is decomposed into transactions in an incorrect manner, the application may fail when executed concurrently due to potential offline concurrency problems. This paper presents a dataflow analysis technique for identifying schedules of transaction execution aimed at revealing concurrency faults of this nature, along with techniques for controlling the DBMS or the application to force execution to follow these transaction sequences. The techniques have been integrated into AGENDA, a tool set for testing relational database application programs. Preliminary empirical evaluation is presented. 1.
Cited by 0
Gee, M., National Physical Lab., Teddington (United Kingdom) · OpenGrey (Institut de l'Information Scientifique et Technique) · 2001
Cited by 0
Yuetang Deng, Phyllis Frankl · 2003
AGENDA is a tool set for testing relational database applications. In this paper we extend AGENDA to test transaction consistency. Two levels of checks are used to check both database state and state transition. The transition check validates the state transition performed by the transaction. The state check validates that the overall global consistency properties hold for the new database state. Our tool set can handle general SQL assertions that are defined in the SQL standard but are not supported by current DBMSs, such as constraints involving multiple tables and SQL aggregration functions. A test generation heuristic that takes account of certain constraints is also presented. A case study based on the TPC-C benchmark shows promising results. 1.
Cited by 0
Yuetang Deng, Phyllis G. Frankl, Jiong Wang · ACM SIGSOFT Software Engineering Notes · 2004
Commercial, scientific, and social activities are increasingly becoming dependent on Web database applications. New testing techniques that handle the unique features of these systems are needed. To that end, we have extended AGENDA, a tool set for testing relational database applications, to test web database applications. Application source code is analyzed to extract relevant information about the URLs and their parameters. This information is used to construct and simplify a graph in which nodes represent URLs and edges represent links between URLs. A set of paths through the graph is selected and test cases are generated for each path. The extracted information about the parameters to each URL (e.g., values that an application user would enter into a form), is used to guide AGENDA to generate inputs for the URLs. The URLs on a path and their inputs are stored in an XML file, which is then automatically executed. The current implementation is targeted toward web applications written as Java Servlets and uses an algorithm based on cyclomatic complexity to generate paths. Preliminary empirically evaluation based on the TPC-W benchmark is presented.
Cited by 45
PILECKI, Emil · CERN Document Server (European Organization for Nuclear Research) · 2014
<!--HTML-->Ensuring database stability and steady performance in the modern world of agile computing is a major challenge. Various changes happening at any level of the computing infrastructure: OS parameters & packages, kernel versions, database parameters & patches, or even schema changes, all can potentially harm production services. This presentation shows how an automatic and regular testing of Oracle databases can be achieved in such agile environment.
Cited by 0
Rana Farid Mikhail, Donald J. Berndt, Abraham Kandel · Series in machine perception and artificial intelligence · 2010
Cited by 0
Gabriel Dragomir, Iosif Ignat · 2006
In this paper we are going to discuss about a subject that although was treated for a long period of time, it still remains a challenging one. In distributed database, the fundamental architecture is client-server multi-tier. The efforts in distributed database environment domain consist in heterogeneous data sources inter-linking, new applications with new data models that have impact on their functionality. In our work we made a series of scenario tests of a distributed database environment implemented at external level, with active views. Two distributed databases were used, the first one simply referring to students and exams and the second one more complicated, like TPC-H benchmark model
Cited by 0
Vishwareddy Biradar, Y S Harshil, Mayank Somani et al. · 2025
This paper presents a comprehensive load testing framework for Aerospike DB implemented in the Go programming language. The framework is designed to assess the performance characteristics of Aerospike DB under synthetic read and write workloads. Leveraging Go's concurrency features, our load testing client achieves optimal throughput by maximizing CPU affinity. Key metrics, including successful read and write operations, P95 latency, and throughput, are continuously monitored and exposed through Prometheus. The synthetic data generation, parallelism, and monitoring capabilities contribute to the scalability and adaptability of the framework. Results from various test scenarios are analyzed, providing insights into the behavior of Aerospike DB under different conditions. Notably, the system achieved a write throughput of 42,000 operations per second with a latency of just 0.13 milliseconds. For read operations, the system achieved a remarkable throughput of 93,000 operations per second and a latency of 0.18 milliseconds. The findings aim to guide optimizations and deployments, enhancing the understanding of Aerospike DB's performance nuances.
Cited by 0
Attila Toth, Chip Holt · Computer · 1974
Developments in packaging reflect the fact that manufacturing economies are related to the level of integration achieved on electronic assemblies. Limiting the natural trend to build large, complex, highly-integrated assemblies is the corresponding drop in production yield. In recent years, however, yields for complex assemblies both in semiconductor chips and printed circuit boards have risen substantially. The effect has been to produce electronic assemblies whose complexities have placed new emphasis and new demands on testing. Traditional approaches to the problems of test and repair have, for the most part, been abandoned in favor of more manageable, cost-effective approaches. This paper describes the techniques and test system developed by Xerox for its large digital modules, beginning with a discussion of the issues peculiar to the test and repair of such modules.
Cited by 14
Juan C. Ramírez (4621705), Rudy Parrado (102074), Elena Sulleiro (814801) et al. · Figshare · 2017
Cited by 0Open access