High-performance query processing of a real-world OLAP database with ParGRES

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 5336 LNCS, Issue , 2008, Pages 188-200

  Paes, Melissa ^a,b   Lima, Alexandre A B ^c   Valduriez, Patrick ^d   Mattoso, Marta ^a  

^a FEDERAL UNIVERSITY OF RIO DE JANEIRO   (Brazil)

^b INSTITUTO BRASILEIRO DE GEOGRAFIA E ESTATÍSTICA   (Brazil)

^c UNIGRANRIO ^*  (Brazil)

^d UNIVERSITÉ DE NANTES   (France)

Author keywords

[No Author keywords available]

Indexed keywords

HIGH PERFORMANCE LIQUID CHROMATOGRAPHY; MIDDLEWARE; QUERY PROCESSING;

DATABASE CLUSTERS; EFFECTIVE SOLUTIONS; EXCELLENT PERFORMANCES; LONG TIMES; OLAP QUERIES; PC CLUSTERS; QUERY PARALLELISMS; REAL SETTINGS; SINGLE QUERIES; SPEED-UP; VIRTUAL PARTITIONING;

DATABASE SYSTEMS;

EID: 58349110521     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/978-3-540-92859-1_18     Document Type: Conference Paper

References (22)

1. Akal, F., Böhm, K., Schek, H.J.: OLAP Query Evaluation in a Database Cluster: a Performance Study on Intra-Query Parallelism. In: Manolopoulos, Y., Návrat, P. (eds.) ADBIS 2002. LNCS, vol. 2435, pp. 218-231. Springer, Heidelberg (2002)
2. Brazilian Institute of Geography and Statistics - IBGE, http://www.ibge.gov.br
3. Cecchet, E., Marguerite, J., Zwaenepoel, W.: C-JDBC: Flexible Database Clustering Middleware. In: Proceedings of USENIX Annual Technical Conference, Freenix Track, Boston, EUA, pp. 9-18 (June 2004)
4. Grid5000 Projects Web Site - Grid5000, http://www.grid5000.fr
5. HSQL Database Engine, http://hsqldb.org/
6. Kotowski, N., Lima, A.A., Pacitti, E., Valduriez, P., Mattoso, M.L.Q.: Parallel Query Processing for OLAP in Grids. Concurrency and Computation. Practice & Experience (2008), http://dx.doi.org/10.1002/cpe.1303
7. Lima, A.A.B.: Intra-query parallelism in Database Clusters (in Portuguese). Ph.D. Thesis, COPPE/UFRJ, Rio de Janeiro (2004)
8. Lima, A.A.B., Mattoso, M., Valduriez, P.: Adaptive Virtual Partitioning for OLAP Query Processing in a Database Cluster. In: Proceedings of the 19th Brazilian Symposium on Database Systems (SBBD 2004), Brasilia, Brazil, October 18-20, pp. 92-105 (2004)
9. Mattoso, M., Zimbrão, G., Lima, A.A.B.: Baião. F., Braganholo, V., Aveleda, A., Miranda, B., Almentero, B., Costa, M.N.: ParGRES Middleware for Executing OLAP Queries in Parallel. Technical report (2005), http://pargres.nacad.ufrj.br/Documentos/ES-690.pdf
10. Miranda, B., Lima, A.A.B., Valduriez, P., Mattoso, M.: Apuama: Combining Intra-query and Inter-query Parallelism in a Database Cluster. In: Grust, T., Höpfner, H., Illarramendi, A., Jablonski, S., Mesiti, M., Müller, S., Patranjan, P.-L., Sattler, K.-U., Spiliopoulou, M., Wijsen, J. (eds.) EDBT 2006. LNCS, vol. 4254, pp. 649-661. Springer, Heidelberg (2006)
11. Multidimensional Statistics Database - BME, http://www.bme.ibge.gov.br
12. ParGRES, http://pargres.nacad.ufrj.br/
13. PostgreSQL, http://www.postgresql.org
14. POWERDB, http //www.dbs.ethz.ch/archive/index.html
15. Rohm, U., Bohm, K., Schek, H.-J.: OLAP Query Routing and Physical Design in a Database Cluster. In: Zaniolo, C., Grust, T., Scholl, M.H., Lockemann, P.C. (eds.) EDBT 2000. LNCS, vol, 1777, pp. 254-268. Springer, Heidelberg (2000)
16. Röhm, U., Bohm, K., Schek, H.-J.: Cache-Aware Query Routing in a Cluster of Databases. In: Proceedings of the 17th International Conference on Data Engineering (ICDE 2001), pp. 641-650. IEEE Computer Society, Los Alamitos (2001)
17. Röhm, U., Böhm, K., Scheck, H.-J., Schuldt, H.: FAS - A Freshness-Sensitive Coordination Middleware for a Cluster of OLAP Components. In: Proceedings of the 28th International Conference on Very Large Databases Conference (VLDB 2002), Hong Kong, China, August 20-23 (2002)
18. Sequoia Project, http://sequoia.continuent.org/HomePage
19. TPC Benchmark C, http://www.tpc.org/ tpcc/
20. TPC BenchmarkH, http://www.tpc.org/tpch/
21. TPC Benchmark W, http://www.tpc.org/tpcw/default.asp
22. Valduriez, P.: Parallel Database Systems: open problems and new issues. International Journal on Distributed and Parallel Databases 1(2), 137-165 (1993)