SQL Scorecard for Improved Stability and Performance of Data Warehouses

Abstract

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.

Exploring the Factors Influencing Big Data Technology Acceptance

“…Through this method, 32 factors have been identified. Later, these factors were presented to industry experts who have hands-on experience in both big data technologies (e.g., Hadoop) and traditional data management software, including Teradata, Oracle, and MS SQL Server [98], [99]. The qualitative studies consisting of the brainstorming sessions, expert panel, focus groups, and interviews were used to get the input in selecting the most important variables of big data technology adoption.…”

Competitive Strategies in the Computer Industry

“…For incumbents, they might want to develop a sustainability metrics (Rahman & Akhter, 2010) to monitor individual firm's performance. They also might want to measure the performance periodically using a balanced scorecard (BSC) approach (Rahman, 2013).…”

Techniques for Ensuring Index Usage Predictability in Microsoft SQL Server

“…Rahman in [12] proposes the usage of a scorecard tool that measures SQL query performance in order to make sure that the resource consumption of SQL queries is predictable and the database system environment is stable, in environments where hundreds of queries are run at any point in time.…”