Skip to main content

Table 2 Method performance

From: A comparison of approaches to accessing existing biological and chemical relational databases via SPARQL

Method

Queries not completed within the time limit (%)

System

Approach

Parallel

0.1 s

1 s

10 s

100 s

1000 s

Ontop/MariaDB

String

No

63.57

33.57

19.29

11.43

4.29

Ontop/MariaDB

Combined

No

62.14

32.14

18.57

7.86

0.71

Ontop/PostgreSQL

String

No

69.29

42.14

21.43

10.71

2.86

Ontop/PostgreSQL

Combined

No

65.71

35.71

22.86

11.43

4.29

Ontop/PostgreSQL

String

Yes

70.00

36.43

14.29

5.71

1.43

Ontop/PostgreSQL

Combined

Yes

67.86

32.86

16.43

7.14

2.86

IDSM SPARQL engine

String

No

64.29

31.43

15.00

5.71

2.14

IDSM SPARQL engine

Combined

No

64.29

30.71

17.14

4.29

2.14

IDSM SPARQL engine

Integer

No

59.29

30.71

12.86

4.29

2.86

IDSM SPARQL engine

String

Yes

64.29

27.14

11.43

3.57

1.43

IDSM SPARQL engine

Combined

Yes

64.29

28.57

13.57

3.57

2.14

IDSM SPARQL engine

Integer

Yes

57.14

25.00

11.43

3.57

2.14

Virtuoso

String

No

57.86

34.29

16.43

5.71

1.43

Virtuoso

Combined

No

65.71

35.00

15.71

8.57

3.57

Virtuoso

Integer

No

50.71

23.57

10.71

2.14

1.43

Virtuoso

Native

No

35.00

17.14

6.43

2.14

0.71

Virtuoso

String

Yes

55.00

33.57

14.29

2.86

0.71

Virtuoso

Combined

Yes

62.86

34.29

14.29

5.71

2.86

Virtuoso

Integer

Yes

48.57

23.57

9.29

2.86

1.43

Virtuoso

Native

Yes

34.29

15.71

6.43

1.43

0.71

Blazegraph

Native

No

65.00

36.43

20.71

11.43

6.43

GraphDB

Native

No

65.00

40.00

27.14

5.00

2.86

Jena TDB2

Native

No

83.57

46.43

38.57

16.43

4.29