P. O'Neil. Revisiting DBMS Benchmarks. Datamation, pages 47--54, September 15, 1989.  Home/Search   Document Not in Database   Summary   Related Articles   Check

....and a set of queries for a particular workload. We focus on a complex query workload (involving subqueries, views, etc) rather than a transaction workload, where queries are relatively simple. There is no accepted standard complex query workload, although several have been proposed ( TOB89, O N89] To measure the performance effect of the rewrite rules, we employ a Table Tuple Size #Tuples #4K Pgs #Indices itm 34 170 000 1 850 1 itl 78 2 550 000 57 980 2 itp 43 339 440 4 250 3 pur 398 128 000 11 640 1 wor 119 120 000 4 000 1 Table 1: Benchmark Database version of the IBM DB2 ....

P. O'Neil. Revisiting DBMS Benchmarks. Datamation, pages 47--54, September 15, 1989.

....a complex query workload (with multiple predicates, joins, aggregations and subqueries) rather than a transaction workload, where queries are relatively simple. Although transaction benchmarks have been proposed, A 85, TPC89] complex query workloads are still at a preliminary stage ( TOB89, O N89] To measure the performance effect of the magic sets transformation, we employ a scaled up (by a factor of 10) version of the DB2 benchmark database described in [Loo86] Magic sets transformations have been studied in the context of recursive queries, and the usefulness of magicsets for ....

P. O'Neil. Revisiting DBMS Benchmarks. Datamation, Sep 1989.

....measurements. We focus on a complex query workload (involving subqueries, expensive user defined functions, etc) rather than a transaction workload, where queries are relatively simple. There is no accepted standard complex query workload, although several have been proposed ( SFGM93, TOB89, O N89] etc. To measure the performance effect of Predicate Migration, we have constructed our own benchmark database, based on a combined GIS and business application. Each tuple in maps contains a reference to a POSTGRES large object [Ols92] which is a map picture taken by a satellite. These map ....

P. O'Neil. Revisiting DBMS Benchmarks. Datamation, pages 47--54, September 15, 1989.

....these measurements. We focus on a complex query workload (involving subqueries, expensive user defined functions, etc) rather than a transaction workload, where queries are relatively simple. There is no accepted standard complex query workload, although several have been proposed ( SFG92, TOB89, O N89] etc. To measure the performance effect of Predicate Migration, we have constructed our own benchmark database, based on a combined GIS and business application. Each tuple in maps contains a reference to a POSTGRES large object [Ols92] which is a map picture taken by a satellite. These map ....

P. O'Neil. Revisiting DBMS Benchmarks. Datamation, pages 47--54, September 15, 1989.

....long range retrievals entailing reads of hundreds of pages in sequence are quite common in commercial applications. As an example, households in direct marketing databases are often clustered by zip code and street address to reduce processing time for mailings to prospects chosen by location (see [12]) Multi page block reads are currently supported in a number of commercial database products (INGRES [10] DB2 [14] with significant query performance enhancement, as shown for example in measurements of [13] With current B tree structures, however, the multi page read strategy for these ....

O'Neil, P.E.: Revisiting DBMS Benchmarks, Datamation, September 15, 1990, pp 47-53.

Online articles have much greater impact   More about CiteSeer.IST   Add search form to your site   Submit documents   Feedback  

CiteSeer.IST - Copyright Penn State and NEC