Matches in SemOpenAlex for { <https://semopenalex.org/work/W2472291526> ?p ?o ?g. }
- W2472291526 endingPage "37" @default.
- W2472291526 startingPage "22" @default.
- W2472291526 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." @default.
- W2472291526 created "2016-07-22" @default.
- W2472291526 creator A5013073357 @default.
- W2472291526 date "2016-07-01" @default.
- W2472291526 modified "2023-09-24" @default.
- W2472291526 title "SQL Scorecard for Improved Stability and Performance of Data Warehouses" @default.
- W2472291526 cites W1016442203 @default.
- W2472291526 cites W114801410 @default.
- W2472291526 cites W137122467 @default.
- W2472291526 cites W1523227732 @default.
- W2472291526 cites W1558046248 @default.
- W2472291526 cites W1607115066 @default.
- W2472291526 cites W1613169654 @default.
- W2472291526 cites W1620335650 @default.
- W2472291526 cites W1819934925 @default.
- W2472291526 cites W1917819668 @default.
- W2472291526 cites W1971474040 @default.
- W2472291526 cites W1983036122 @default.
- W2472291526 cites W1983224729 @default.
- W2472291526 cites W1984074239 @default.
- W2472291526 cites W1997325740 @default.
- W2472291526 cites W1998415522 @default.
- W2472291526 cites W1999816862 @default.
- W2472291526 cites W2002963734 @default.
- W2472291526 cites W2003871181 @default.
- W2472291526 cites W2006565871 @default.
- W2472291526 cites W2008235117 @default.
- W2472291526 cites W2010485787 @default.
- W2472291526 cites W2025619570 @default.
- W2472291526 cites W2026021846 @default.
- W2472291526 cites W2037168816 @default.
- W2472291526 cites W2037680823 @default.
- W2472291526 cites W2039532968 @default.
- W2472291526 cites W2049586724 @default.
- W2472291526 cites W2058521804 @default.
- W2472291526 cites W2059918482 @default.
- W2472291526 cites W2060419519 @default.
- W2472291526 cites W2063091000 @default.
- W2472291526 cites W2063599951 @default.
- W2472291526 cites W2090529051 @default.
- W2472291526 cites W2098009409 @default.
- W2472291526 cites W2110710386 @default.
- W2472291526 cites W2115655618 @default.
- W2472291526 cites W2120049385 @default.
- W2472291526 cites W2128421187 @default.
- W2472291526 cites W2136451344 @default.
- W2472291526 cites W2143101325 @default.
- W2472291526 cites W2143759802 @default.
- W2472291526 cites W2146869661 @default.
- W2472291526 cites W2149308895 @default.
- W2472291526 cites W2149877754 @default.
- W2472291526 cites W2151020819 @default.
- W2472291526 cites W2151461605 @default.
- W2472291526 cites W2152845022 @default.
- W2472291526 cites W2158194116 @default.
- W2472291526 cites W2158951848 @default.
- W2472291526 cites W2167753650 @default.
- W2472291526 cites W2187395855 @default.
- W2472291526 cites W2217174568 @default.
- W2472291526 cites W2278797086 @default.
- W2472291526 cites W2295144739 @default.
- W2472291526 cites W2307354236 @default.
- W2472291526 cites W2410406898 @default.
- W2472291526 cites W2794029116 @default.
- W2472291526 cites W3151727758 @default.
- W2472291526 cites W822279801 @default.
- W2472291526 cites W1516261653 @default.
- W2472291526 cites W2362309580 @default.
- W2472291526 cites W2474077411 @default.
- W2472291526 doi "https://doi.org/10.4018/ijsi.2016070102" @default.
- W2472291526 hasPublicationYear "2016" @default.
- W2472291526 type Work @default.
- W2472291526 sameAs 2472291526 @default.
- W2472291526 citedByCount "8" @default.
- W2472291526 countsByYear W24722915262017 @default.
- W2472291526 countsByYear W24722915262018 @default.
- W2472291526 countsByYear W24722915262020 @default.
- W2472291526 countsByYear W24722915262022 @default.
- W2472291526 countsByYear W24722915262023 @default.
- W2472291526 crossrefType "journal-article" @default.
- W2472291526 hasAuthorship W2472291526A5013073357 @default.
- W2472291526 hasConcept C135572916 @default.
- W2472291526 hasConcept C144133560 @default.
- W2472291526 hasConcept C148840519 @default.
- W2472291526 hasConcept C164120249 @default.
- W2472291526 hasConcept C194222762 @default.
- W2472291526 hasConcept C195094911 @default.
- W2472291526 hasConcept C199004533 @default.
- W2472291526 hasConcept C23123220 @default.
- W2472291526 hasConcept C41008148 @default.
- W2472291526 hasConcept C510870499 @default.
- W2472291526 hasConcept C54239708 @default.
- W2472291526 hasConcept C77088390 @default.
- W2472291526 hasConcept C97854310 @default.
- W2472291526 hasConcept C98199447 @default.
- W2472291526 hasConceptScore W2472291526C135572916 @default.
- W2472291526 hasConceptScore W2472291526C144133560 @default.
- W2472291526 hasConceptScore W2472291526C148840519 @default.