Untitled

Dempster, Euan W.; Tomov, Neven; Williams, M. Howard; Taylor, Hamish; Burger, Albert; Trinder, Phil; Lu, Jianjiang; Broughton, Phil

doi:10.1023/a:1022875525392

Cited by 3 publications

(2 citation statements)

References 8 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Gelbard and Spiegler (2005) proposed a Temporal Branching technique to resolve conflicts in heterogeneous and distributed databases by integrating and extending temporal oriented databases and temporal versioning (Rahman, 2014). Dempster et al (2003) proposed a parallel query option model which provides the predictions against actual measurements obtained. Elnaffar et al (2008) and Yoon et al (2015) presented an approach to automatically identifying a DBMS workload as either OLTP or DSS via data mining techniques.…”

Section: Literature Review and Theoretical Frameworkmentioning

confidence: 99%

“…We conducted a study of industry white papers and articles published in IT journals to investigate if existing database management systems (Dempster et al, 2003;Elnaffar et al, 2008;Feinberg & Beyer, 2010;Tria et al, 2015;Yoon et al, 2015) provide any SQL scorecard tools. Apparently no such tools are available to perform detailed scorecard of SQL.…”

Section: Research Approachmentioning

confidence: 99%

See 1 more Smart Citation

SQL Scorecard for Improved Stability and Performance of Data Warehouses

Rahman

2016

International Journal of Software Innovation

View full text Add to dashboard Cite

Scorecard-based measurement techniques are used by organizations to measure the performance of their business operations. A scorecard approach could be applied to a database system to measure performance of SQL (Structured Query Language) being executed and the extent of resources being used by SQL. In a large data warehouse, thousands of jobs run daily via batch cycles to refresh different subject areas. Simultaneously, thousands of queries by business intelligence tools and ad-hoc queries are being executed twenty-four by seven. There needs to be a controlling mechanism to make sure these batch jobs and queries are efficient and do not consume database systems resources more than optimal. The authors propose measurement of SQL query performance via a scorecard tool. The motivation behind using a scorecard tool is to make sure that the resource consumption of SQL queries is predictable and the database system environment is stable. The experimental results show that queries that pass scorecard evaluation criteria tend to utilize optimal level of database systems computing resources. These queries also show improved parallel efficiency (PE) in using computing resources (CPU, I/O and spool space) that demonstrate the usefulness of SQL scorecard.

show abstract

Section: Literature Review and Theoretical Frameworkmentioning

confidence: 99%

Section: Research Approachmentioning

confidence: 99%

SQL Scorecard for Improved Stability and Performance of Data Warehouses

Rahman

2016

International Journal of Software Innovation

View full text Add to dashboard Cite

show abstract

Measuring and modelling the performance of a parallel ODMG compliant object database server

Sampaio

Paton

Smith

et al. 2005

Concurrency and Computation

View full text Add to dashboard Cite

SUMMARYObject database management systems (ODBMSs) are now established as the database management technology of choice for a range of challenging data intensive applications. Furthermore, the applications associated with object databases typically have stringent performance requirements, and some are associated with very large data sets. An important feature for the performance of object databases is the speed at which relationships can be explored. In queries, this depends on the effectiveness of different join algorithms into which queries that follow relationships can be compiled. This paper presents a performance evaluation of the Polar parallel object database system, focusing in particular on the performance of parallel join algorithms. Polar is a parallel, shared-nothing implementation of the Object Database Management Group (ODMG) standard for object databases. The paper presents an empirical evaluation of queries expressed in the ODMG Query Language (OQL), as well as a cost model for the parallel algebra that is used to evaluate OQL queries. The cost model is validated against the empirical results for a collection of queries using four different join algorithms, one that is value based and three that are pointer based.

show abstract

Database system performance evaluation models: A survey

Osman

Knottenbelt

2012

Performance Evaluation

View full text Add to dashboard Cite

Untitled

Cited by 3 publications

References 8 publications

SQL Scorecard for Improved Stability and Performance of Data Warehouses

SQL Scorecard for Improved Stability and Performance of Data Warehouses

Measuring and modelling the performance of a parallel ODMG compliant object database server

Database system performance evaluation models: A survey

Contact Info

Product

Resources

About