• Keine Ergebnisse gefunden

Environment of the benchmark suite

N/A
N/A
Info
Herunterladen
Protected

Academic year: 2022

Aktie "Environment of the benchmark suite"

Copied!
9
0
0

Wird geladen.... (Jetzt Volltext ansehen)

Jetzt herunterladen ( 9 Seite )

Volltext

(1)

© 1998 FORWISS

FORWISS

Oracle Measurement Results

Prof. Bayer, PhD Dipl.-Inform. Volker Markl

Roland Pieringer

FORWISS

Contents

●Environment of the benchmark suite

●Results of the measurements

–Example measurement suite

–Comparison of the operating systems SUN Solaris and Windows NT –Variation of the sizes of the tuples

–Variation of the number of tuples

–Variation of the number of restricted dimensions

●Future Work

(2)

© 1998 FORWISS

FORWISS

Environment of the benchmark suite

●Measures on two machines:

–Compaq PC (4 Intel Processors, 200 MHz, 512 MB RAM) with Oracle 8.0.4.0.0

–SUN Ultra 2 (2 Ultra Sparc Processors, 200 MHz, 1 GB RAM) with Oracle 8.0.4.0.0

●Data uniformly distributed and created by a program

●Elimination of cache side effects by NOCACHE

FORWISS

Used indexes

●UB:

UB Tree (index that causes this meeting)

●COMPOUND:

concatenation of several indexes to get a multi dimensional index

in Oracle as index only tableimplemented

●MULT:

secondary indexes on all index attributes

●SCAN:

no index, relation scan, in Oracle as full table scan

(3)

© 1998 FORWISS

FORWISS

Kinds of benchmarks

●c% measurements:

Q = (I1,...,In) Ik= 1 % ..100 % I1, ..., Ik-1, Ik+1, In= c % random starting point

●Cube measurements:

Q=(I1,...,In) Ii= 0% .. 100%, for i = 1,...,n fix starting point

20%

40%

60%

80%

Q20%

Q40%

Q60%

Q80%

FORWISS

Results of the measurements

●Complete benchmarks suite

●Comparison of Windows NT and SUN Solaris

●Variation of the size of tuples

●Variation of the number of tuples

●Variation of the number of restricted dimensions

(4)

© 1998 FORWISS

FORWISS

0 50000 100000 150000 200000 250000 300000 350000 400000 450000

0 20 40 60 80 100

restriction in %

time in ms

UB, x1 var. Compound, x1 var. Relationenscan Sekundärindexe UB, x2 var. Compound, x2 var.

20% measure with 5 restricted dimensions

(250K tuples, tuple size 428 Byte)

FORWISS

0 50000 100000 150000 200000 250000 300000

0 10 20 30 40 50 60 70 80 90 100

restriction in %

time in ms

UB, x1 var. Compound, x1 var. Relationenscan Sekundärindex UB, x2 var. Compound, x2 var.

35% measure with 5 restricted dimensions

(250K tuples, tuple size 428 Byte)

(5)

© 1998 FORWISS

FORWISS

Cube measure

(250K tuples, tuple size 428 Byte)

0 50000 100000 150000 200000 250000 300000

0 10 20 30 40 50 60 70 80 90 100

restriction in %

time in ms

UB Compound Scan Sekundärindex

FORWISS

Solaris - NT:

35% measure (125K tuples, 428 Byte tuple size) with SUN

0,000 20000,000 40000,000 60000,000 80000,000 100000,000 120000,000 140000,000 160000,000 180000,000 200000,000

0 10 20 30 40 50 60 70 80 90 100

restriction in %

time in ms

UB, x1 var. Compound, x1 var. Relationenscan Sekundärindex UB, x2 var. Compound, x2 var.

(6)

© 1998 FORWISS

FORWISS

Solaris - NT:

35% measure (125K tuples, 428 Byte tuple size) with NT

0,000 50000,000 100000,000 150000,000 200000,000 250000,000 300000,000 350000,000

0 10 20 30 40 50 60 70 80 90 100

restriction in %

time in ms

UB, x1 var. Compound, x1 var. Relationenscan Sekundärindex UB, x2 var. Compound, x2 var.

FORWISS

Comparison of tuple size

●Intersection of compound and relation scan:

–small tuples: about 10%

–large tuples: about 8%

●Intersection UB Tree and relation scan:

–small tuples: about 65%

–large tuples: about 47%

●Decrease of performance of the relation scan:

–small tuples: factor 4 –large tuples: factor 1.4

(7)

© 1998 FORWISS

FORWISS Comparison of the number of tuples

Cube measure (1M tuples, 228 Byte tuple size)

0,000 100000,000 200000,000 300000,000 400000,000 500000,000 600000,000 700000,000

0 10 20 30 40 50 60 70 80 90 100

restriction in %

time in ms

Compound Scan UB

FORWISS Comparison of the number of tuples

Cube measure (2M tuples, 228 Byte tuple size)

0 200000 400000 600000 800000 1000000 1200000 1400000 1600000 1800000

0 10 20 30 40 50 60 70 80 90 100

restriction in %

time in ms

UB Compound Scan

(8)

© 1998 FORWISS

FORWISS Comparison of the number of tuples

Cube measure (4M tuples, 228 Byte tuple size)

0,000 100000,000 200000,000 300000,000 400000,000 500000,000 600000,000 700000,000 800000,000 900000,000 1000000,000

0 10 20 30 40 50 60 70 80 90 100

restriction in %

time in ms

UB Compound Scan

FORWISS Variation of the number of restricted dimensions

Cube measure (250K tuples, 428 Byte tuple size)

0,000 50000,000 100000,000 150000,000 200000,000 250000,000 300000,000

0 10 20 30 40 50 60 70 80 90 100

restriction in %

time in ms

UB, 2 Dimensionen Compound Scan UB, 3 Dimensionen UB, 4 Dimensionen

UB, 1 Dimension UB, 5 Dimensionen UB, 6 Dimensionen Compound x2 var.

(9)

© 1998 FORWISS

FORWISS Variation of the number of restricted dimensions

35% measure (250K tuples, 428 Byte tuple size)

0,000 50000,000 100000,000 150000,000 200000,000 250000,000 300000,000

0 10 20 30 40 50 60 70 80 90 100

restriction in %

time in ms

UB, 0 at 35% UB, 1 at 35% UB, 2 at 35% UB, 3 at 35% UB, 4 at 35%

UB, 5 at 35% Comp, 0 at 35% Comp, 1 at 35% Comp, 2 at 35% Comp, 3 at 35%

Comp, 4 at 35% Comp, 5 at 35% Compound, x2 var.

Referenzen

Jetzt herunterladen ( PDF - 9 Seite - 377.88 KB )

ÄHNLICHE DOKUMENTE

Genetic and morphological variation of the

fimbriatus by its larger size (snout-vent length up to 200 mm vs. 295 mm), hemipenis morphology, colouration of iris, head and back, and strong genetic differentiation (4.8 %

Evaluating the change in fingerprint directional patterns under variation of rotation and number of regions

This investigation focused on analysing the different DP layouts produced as the number of regions and rotation of the fingerprint was varied and which patterns represent the

Geographical Variation of the Furanocoumarin Composition of the Fruits of Icelandic Angelica archangelica

However, strong geographical impact was observed on the composition, with isoimperatorin and bergapten being more pronounced in South Ice- land, and oxypeucedanin and

Geographical Variation of the Furanocoumarin Composition of the Fruits of Icelandic Angelica archangelica

Locations with xanthotoxin representing more than the average percentage (7.2%) of the total furano- coumarin content are shown with fi lled circles and loca- tions with less than

Miscellaneum : Mast cells in the myocardium : pathophysiological result of the variation in the number of the mast-cells : a geographic pathological approach

An increase in the number of mast cells has also been observed in cases of serous myocarditis 20, 21.. In human coronary sclerosis, and more distinctly in coronary

3.3.4 Variation of the Potential Energy

from the principle of stationary energy, which is logically more satisfactory for many people, especially in view of the fact that maximum or minimum principles

The secret of the number 5

The number of spirals on a sunflower is always a Fibonacci number (or a number very close to a Fibonacci number), for instance in the large picture of on the previous slide there are

The Geometry of the Milnor Number

unfolding theorem whose proof requires some preparations about isochoric unfoldings and it requires a generalization of the classical Brieskorn module of a hypersurface singularity