122 search results - page 2 / 25 » Compressing SQL workloads |
SIGMOD
2006
ACM
14 years 5 months ago
2006
ACM
The area of automatic selection of physical database design to optimize the performance of a relational database system based on a workload of SQL queries and updates has gained p...
ICDE
2010
IEEE
13 years 5 months ago
2010
IEEE
— This paper looks at the problem of automatically tuning the database server multiprogramming level to improve database server performance under varying workloads. We describe t...
DEBU
2008
13 years 5 months ago
2008
We present the SQL Performance Analyzer, a novel approach in Oracle Database 11g to testing database changes, such as upgrades, parameter changes, schema changes, and gathering op...
VLDB
1997
ACM
13 years 9 months ago
1997
ACM
In this paper we describe novel techniques that make it possible to build an industrial-strength tool for automating the choice of indexes in the physical design of a SQL database...
VLDB
2002
ACM
13 years 5 months ago
2002
ACM
Complex database queries require the use of memory-intensive operators like sort and hashjoin. Those operators need memory, also referred to as SQL memory, to process their input ...