C. Turbyfill, C. Orji, and D. Bitton. As3ap - a comparative relational database benchmark. In Proc. IEEE Compcon, February 1989.  Home/Search   Document Not in Database   Summary   Related Articles   Check

....provide for placing the set of ORB based objects in an endsystem context including background load and traffic. The ANSI SQL Standard Scalable and Portable Benchmark (AS3AP) models complex and mixed workloads, including single user and multi user tests, as well as operational and functional tests [25]. There are 39 single user queries consisting of utilities, selection, join, projection, aggregate, integrity, and bulk updates. The four multi user modules include a concurrent random read test and a pure information retrieval (IR) test[26] The concurrent random write test is used to evaluate ....

Turbyfill, C., Orji, C. and Bitton, D. AS3AP - A Comparative Relational Database Benchmark, In Proceedings of the IEEE COMPCON, 1989, pp. 560-564.

....database 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 ....

C. Turbyfill, C. Orji, and Dina Bitton. AS3AP - A Comparative Relational Database Benchmark. In Proc. IEEE Compcon Spring '89, February 1989.

....on 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 ....

C. Turbyfill, C. Orji, and D. Bitton. AS3AP - A Comparative Relational Database Benchmark. In IEEE Compcon 1989.

....for 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 ( 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 ....

C. Turbyfill, C. Orji, and Dina Bitton. AS3AP - A Comparative Relational Database Benchmark. In Proc. IEEE Compcon Spring '89, February 1989.

....for 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 ....

C. Turbyfill, C. Orji, and Dina Bitton. AS3AP - A Comparative Relational Database Benchmark. In Proc. IEEE Compcon Spring '89, February 1989.

....of workloads. Standard Macro Benchmarks: An influential person or committee can define a standard representative workload (data and queries) and different strategies can be compared on this workload. Examples of such benchmarks include the Wisconsin benchmark [Bitton et al. 1983] AS 3 AP [Turbyfill et al. 1989], and TPC D [Raab 1995] Such domain specific benchmarks [Gray 1991] are often based on models of real world workloads. Standard benchmarks typically expose whether or not a system implements solutions to important details exposed by the benchmark, e.g. use of indices and reordering of joins in ....

....then it does well, otherwise it does quite poorly. The evaluation of the optimizer in these benchmarks is binary, in the sense that typically the relative performance of the good and bad strategies is not interesting; what is important is that the optimizer choose the correct access plan [Turbyfill et al. 1989]. It is worth noting that these binary benchmarks have proven extremely influential, both in the commercial arena and in justifying new optimizer research (especially in the case of TPC D) An alternative to benchmarking is to run queries that expose the logic that makes one optimization strategy ....

Turbyfill, C., Orji, C., and Bitton, D. 1989. AS 3 AP - A Comparative Relational Database Benchmark. In Proc. IEEE Compcon Spring '89 (Feb. 1989).

No context found.

C. Turbyfill, C. Orji, and D. Bitton. As3ap - a comparative relational database benchmark. In Proc. IEEE Compcon, February 1989.

No context found.

C. Turbyfill, C. Orji, and D. Bitton. AS AP: A comparative relational database benchmark. In Proceedings, 34th IEEE Computer Society International Conference, pages 560--564, San Francisco, California, February 1989. IEEE Computer Society Press.

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