• Home
  • Search
  • SQL Scorecard for Improved Stability and Performance of Data Warehouses
  • Cite Icon10
  • https://doi.org/10.4018/ijsi.2016070102Copy DOI Icon

SQL Scorecard for Improved Stability and Performance of Data Warehouses

Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
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.

Similar Papers
  • Research Article
  • Citations3

Designing Compliance-Focused Financial Reporting Systems Using SQL, Tableau, and BI Tools

  • Jan 01, 2022
  • International Journal of Management and Organizational Research
  • Olasunbo Olajumoke Fagbore +5
  • PDF
  • Research Article
  • Citations8

A Natural Language Interface to Relational Databases Using an Online Analytic Processing Hypercube

  • Dec 18, 2021
  • AI
  • Fadi H Hazboun +2
  • Conference Article
  • Citations12

An Application of Data Mining to Identify Data Quality Problems

  • Oct 01, 2009
  • E Januzaj +1
  • Research Article

Distributed Database for Bookstore Application

  • Apr 30, 2017
  • International Journal of Advanced Research in Computer Science
  • Devender Singh +2
  • Research Article
  • Citations49

Future trends in database systems

  • Mar 01, 1989
  • IEEE Transactions on Knowledge and Data Engineering
  • M Stonebraker
  • Research Article
  • Citations10

A Web-Based Perioperative Dashboard as a Platform for Anesthesia Informatics Innovation.

  • Sep 16, 2020
  • Anesthesia & Analgesia
  • Thomas T Joseph +5
  • Research Article
  • Citations2

Algorithms for data warehouse design to enhance decision-making

  • Mar 01, 2008
  • WSEAS Transactions on Computers archive
  • Ziyati Elhoussaine +2
  • Book Chapter
  • Citations5

Fuzzy Spatio-Temporal Querying the PostgreSQL/PostGIS Database for Multiple Criteria Decision Making

  • Aug 24, 2017
  • Renata Ďuračiová +1
  • Research Article
  • Citations12

A fuzzy approach to build an intelligent data warehouse

  • Aug 11, 2001
  • Journal of Intelligent and Fuzzy Systems
  • P Radha Krishna +1
  • Research Article
  • Citations3

Web Services Based Integration Tool for Heterogeneous Databases

  • Jan 01, 2013
  • International Journal of Research in Engineering and Science
  • Amin Y Noaman +2
  • Book Chapter

On Index Structures for Star Query Processing in Data Warehouses

  • Jan 01, 2014
  • Artur Wojciechowski +1
  • PDF
  • Research Article

JoVE Video Dataset

  • Nov 19, 2021
  • Ricardo Sánchez-De-Madariaga +23
  • Front Matter
  • Citations1

Editorial

  • Mar 01, 1986
  • European Journal of Operational Research
  • Andrew Kusiak
  • Book Chapter

Chapter 7 - The basics of sql query code tuning

  • Jan 01, 2006
  • Oracle Data Warehouse Tuning for 10g
  • Gavin Powell
  • Research Article
  • Citations4

Efficient aggregation algorithms on very large compressed data warehouses

  • May 01, 2000
  • Journal of Computer Science and Technology
  • Jianzhong Li +2
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.