L. Autrement-dit and . Noeud, Pour illustrer cette situation, nous considérons la requête Q01.2 exprimée en SQL: select sum(lo_extendedprice*lo_discount) as revenue from lineorder lo, DATE d} where l.lo_orderdate=d.d_datekey and d.d_year in ('1994') group by year Selon le schéma de fragmentation obtenu par l'approche séquentielle, cette requête nécessite le chargement de 36 fragments (03 CUSTOMER, 03 SUPPLIER et 04 PART ) Par contre, l'approche conjointe implique le chargement de tous les 96 fragments obtenus. D'après la figure 5.15 , nous remarquons que le temps d'exécution de Q01

I. Ahmad, K. Karlapalem, and R. A. Ghafoor, Evolutionary algorithms for allocating data in distributed database systems, Distributed Database Systems, Distributed and Parallel Databases, pp.5-32, 2002.

F. Akal, K. Böhm, and H. Schek, OLAP Query Evaluation in a Database Cluster: A Performance Study on Intra-Query Parallelism, Proceedings of the 6th East European Conference on Advances in Databases and Information Systems, ADBIS '02, pp.218-231, 2002.
DOI : 10.1007/3-540-45710-0_18

G. Alonso, Partial database replication and group communication primitives (extended abstract), Proceedings of the 2 nd European Research Seminar on Advances in Distributed Systems, pp.171-176, 1997.

A. C. Alvim, C. C. Ribeiro, F. Glover, and D. J. Aloise, A Hybrid Improvement Heuristic for the One-Dimensional Bin Packing Problem, Journal of Heuristics, vol.10, issue.2, 2004.
DOI : 10.1023/B:HEUR.0000026267.44673.ed

P. M. Apers, Data allocation in distributed database systems, ACM Transactions on Database Systems, vol.13, issue.3, pp.263-304, 1988.
DOI : 10.1145/44498.45063

L. Bellatreche, Utilisation des vues matérialisées, des index et de la fragmentation dans la conception logique et physique des entrepôts de données, 2000.

L. Bellatreche and S. Benkrid, A Joint Design Approach of Partitioning and Allocation in Parallel Data Warehouses, 11th International Conference on Data Warehousing and Knowledge Discovery (DAWAK), pp.99-110, 2009.
DOI : 10.1109/TPDS.2005.77

L. Bellatreche, S. Benkrid, A. Crolotte, A. Cuzzocrea, and A. Ghazal, The F&A Methodology and Its Experimental Validation on a Real-Life Parallel Processing Database System, 2012 Sixth International Conference on Complex, Intelligent, and Software Intensive Systems, pp.114-121, 2012.
DOI : 10.1109/CISIS.2012.95

L. Bellatreche, S. Benkrid, A. Ghazal, A. Crolotte, and A. Cuzzocrea, Verification of Partitioning and Allocation Techniques on Teradata DBMS, pp.158-169, 2011.
DOI : 10.1007/978-3-642-24650-0_14

L. Bellatreche and K. Boukhalfa, An evolutionary approach to schema partitioning selection in a data warehouse environment, 7th International Conference on Data Warehousing and Knowledge Discovery (DAWAK), pp.115-125, 2005.

L. Bellatreche, K. Boukhalfa, and P. Richard, Data Partitioning in Data Warehouses: Hardness Study, Heuristics and ORACLE Validation, International Conference on Data Warehousing and Knowledge Discovery (DaWaK'2008), pp.87-96, 2008.
DOI : 10.1007/978-3-540-85836-2_9

L. Bellatreche, K. Boukhalfa, and P. Richard, Referential Horizontal Partitioning Selection Problem in Data Warehouses, International Journal of Data Warehousing and Mining, vol.5, issue.4, pp.1-23, 2009.
DOI : 10.4018/jdwm.2009080701

L. Bellatreche, A. Cuzzocrea, and S. Benkrid, $\mathcal{F}$ & $\mathcal{A}$ : A Methodology for Effectively and Efficiently Designing Parallel Relational Data Warehouses on Heterogenous Database Clusters, DaWak, pp.89-104, 2010.
DOI : 10.1007/978-3-642-15105-7_8

L. Bellatreche, A. Cuzzocrea, and S. Benkrid, Query Optimization over Parallel Relational Data Warehouses in Distributed Environments by Simultaneous Fragmentation and Allocation, Proceedings of the 10th international conference on Algorithms and Architectures for Parallel Processing -Volume Part I, ICA3PP10, pp.124-135, 2010.
DOI : 10.1007/978-3-642-13119-6_11

L. Bellatreche, A. Cuzzocrea, and S. Benkrid, Effectively and Efficiently Designing and Querying Parallel Relational Data Warehouses on Heterogeneous Database Clusters, Journal of Database Management, vol.23, issue.4, pp.17-51, 2012.
DOI : 10.4018/jdm.2012100102

L. Bellatreche, K. Karlapalem, and Q. Li, Complex methods and class allocation in distributed object-oriented databases, the 5th International Conference on Object Oriented Information Systems (OOIS'98), pp.239-256, 1998.

L. Bellatreche, S. Khouri, and N. Berkani, Semantic Data Warehouse Design: From ETL to Deployment ?? la Carte, pp.64-83, 2013.
DOI : 10.1007/978-3-642-37450-0_5

L. Bellatreche, A. Simonet, and M. Simonet, An algorithm for vertical fragmentation in distributed object database systems with complex attributes and methods, International Workshop on Database and Expert Systems Applications (DEXA'96), pp.15-21, 1996.

S. Benkrid and L. Bellatreche, Une d??marche conjointe de fragmentation et de placement dans le cadre des entrep??ts de donn??es parall??les, EDA, pp.91-106, 2009.
DOI : 10.3166/tsi.30.953-973

S. Benkrid and L. Bellatreche, Une d??marche conjointe de fragmentation et de placement dans le cadre des entrep??ts de donn??es parall??les, Techniques et sciences informatiques, vol.30, issue.8, pp.953-973, 2011.
DOI : 10.3166/tsi.30.953-973

S. Benkrid, L. Bellatreche, A. Cuzzocrea, S. Benkrid, L. Bellatreche et al., Designing parallel relational data warehouses: A global, comprehensive approach A combined selection of fragmentation and allocation schemes in parallel data warehouses, DEXA Workshops, pp.141-150, 2008.

R. Bezdek, J. C. , and W. Full, Fcm: The fuzzy c-means clustering algorithm. Computers and Geo-sciences), pp.191-203, 1984.

J. A. Blakeley, P. A. Dyke, C. A. Galindo-legaria, N. James, C. Kleinerman et al., Microsoft SQL Server Parallel Data Warehouse: Architecture Overview, BIRTE, pp.53-64, 2011.
DOI : 10.1007/978-3-642-33500-6_4

M. Böhnlein and A. U. Vom-ende, Business Process Oriented Development of Data Warehouse Structures, DATA WAREHOUSING, pp.3-21, 2000.
DOI : 10.1007/978-3-642-57681-2_1

H. Boral, W. Alexander, L. Clay, G. Copeland, S. Danforth et al., Prototyping Bubba, a highly parallel database system, IEEE Transactions on Knowledge and Data Engineering, vol.2, issue.1, pp.4-24, 1990.
DOI : 10.1109/69.50903

A. J. Borr, Transaction monitoring in encompass: reliable distributed transaction processing, Proceedings of the seventh international conference on Very Large Data Bases, pp.155-165, 1981.

L. Bouganim, Equilibrage de charges lors de l'execution de requêtes sur des architectures multiprocesseurs hybrides, 1996.

L. Bouganim, B. Dageville, and P. Valduriez, Adaptive parallel query execution in DBS3, Proceedings of the 5th International Conference on Extending Database Technology: Advances in Database Technology, EDBT '96, pp.481-484, 1996.
DOI : 10.1007/BFb0014172

URL : https://hal.archives-ouvertes.fr/inria-00073943

K. Boukhalfa, de la conception physique aux outils d'adlinistration et de tuning des entrepôts de données, 2009.

L. Breslau, P. Cue, P. Cao, L. Fan, G. Phillips et al., Web caching and Zipf-like distributions: evidence and implications, IEEE INFOCOM '99. Conference on Computer Communications. Proceedings. Eighteenth Annual Joint Conference of the IEEE Computer and Communications Societies. The Future is Now (Cat. No.99CH36320), pp.126-134, 1999.
DOI : 10.1109/INFCOM.1999.749260

R. L. Cannon, J. V. Dave, and J. C. Bezdek, Efficient Implementation of the Fuzzy c-Means Clustering Algorithms, IEEE Transactions on Pattern Analysis and Machine Intelligence, vol.8, issue.2, pp.248-255, 1986.
DOI : 10.1109/TPAMI.1986.4767778

S. Ceri, M. Negri, and G. Pelagatti, Horizontal data partitioning in database design, Proceedings of the 1982 ACM SIGMOD international conference on Management of data , SIGMOD '82, pp.128-136, 1982.
DOI : 10.1145/582353.582376

R. Chang, H. Chang, and Y. Wang, A dynamic weighted data replication strategy in data grids, Proceedings of the 2008 IEEE/ACS International Conference on Computer Systems and Applications, AICCSA '08, pp.414-421, 2008.

S. Chaudhuri and U. Dayal, An overview of data warehousing and OLAP technology, ACM SIGMOD Record, vol.26, issue.1, pp.65-74, 1997.
DOI : 10.1145/248603.248616

S. Chaudhuri and V. Narasayya, Autoadmin 'what-if' index analysis utility, Proceedings of the ACM SIGMOD International Conference on Management of Data, pp.367-378, 1998.

S. Chaudhuri and V. Narasayya, Self-tuning database systems: A decade of progress, Proceedings of the International Conference on Very Large Databases (VLDB), pp.3-14, 2007.

C. H. Cheng, W. Lee, and K. Wong, A genetic algorithm-based clustering approach for database partitioning, IEEE Transactions on Systems, Man and Cybernetics, Part C (Applications and Reviews), vol.32, issue.3, pp.215-230, 2002.
DOI : 10.1109/TSMCC.2002.804444

H. Chou and D. J. Dewitt, An evaluation of buffer management strategies for relational database systems, Proceedings of the 11th International Conference on Very Large Data Bases, pp.127-141, 1985.
DOI : 10.1007/BF01840450

L. Chung, J. Cesar, and S. P. Leite, Non-functional requirements in software engineering, 1999.

B. Ciciani, D. M. Dias, and P. S. Yu, Analysis of replication in distributed database systems, IEEE Transactions on Knowledge and Data Engineering, vol.2, issue.2, pp.247-261, 1990.
DOI : 10.1109/69.54723

G. P. Copeland, W. Alexander, E. Boughter, and T. Keller, Data placement in bubba, ACM SIGMOD International Conference on Management of Data, pp.99-108, 1988.

A. L. Corcoran and J. Hale, A genetic algorithm for fragment allocation in a distributed database system, Proceedings of the 1994 ACM symposium on Applied computing , SAC '94, pp.247-250, 1994.
DOI : 10.1145/326619.326738

N. Corporation, Netezza database user guide, 2009.

N. Corporation, Greenplum database 4.1: Administrator guide, EMC Corporation, 2011.

J. P. Costa and P. Furtado, Poster session: Towards a QoS-aware DBMS, 2008 IEEE 24th International Conference on Data Engineering Workshop, pp.50-55, 2008.
DOI : 10.1109/ICDEW.2008.4498284

A. Cuzzocrea, J. Darmont, and H. Mahboubi, Fragmenting very large XML data warehouses via K-means clustering algorithm, International Journal of Business Intelligence and Data Mining, vol.4, issue.3/4, pp.4-7, 2009.
DOI : 10.1504/IJBIDM.2009.029076

URL : https://hal.archives-ouvertes.fr/hal-01429242

B. Dageville, D. Das, K. Dias, K. Yagoub, M. Zait et al., Automatic SQL Tuning in Oracle 10g, Proceedings of the Thirtieth International Conference on Very Large Data Bases, pp.1098-1109, 2004.
DOI : 10.1016/B978-012088469-8.50096-6

A. S. Darabant and A. Campan, Semi-supervised learning techniques: k-means clustering in OODB fragmentation, Second IEEE International Conference on Computational Cybernetics, 2004. ICCC 2004., pp.333-338, 2004.
DOI : 10.1109/ICCCYB.2004.1437742

A. S. Darabant, A. Campan, and O. Cret, Using fuzzy clustering for advanced oodb horizontal fragmentation with fine-grained replication, Databases and Applications, pp.116-121, 2005.

A. Datta, B. Moon, and H. Thomas, A case for parallelism in data warehousing and OLAP, Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130), pp.226-231, 1998.
DOI : 10.1109/DEXA.1998.707407

]. L. Davis, Bit-climbing, representational bias, and test suite design, 4th International Conference on Genetic Algorithms, pp.18-23, 1991.

D. Dewitt, R. H. Gerber, G. Graefe, M. L. Heytens, K. B. Kumar et al., Gamma -a high performance dataflow database machine, pp.228-237, 1986.

D. Dewitt, S. Madden, and M. Stonebraker, How to build a high-performance data warehouse

D. J. Dewitt, J. F. Naughton, D. A. Schneider, and S. Seshadri, Practical skew handling in parallel joins, Proceedings of the 18th International Conference on Very Large Data Bases, VLDB '92, pp.27-40, 1992.

N. Elgamal, A. Elbastawissy, and G. Galal-edeen, Data warehouse testing, Proceedings of the Joint EDBT/ICDT 2013 Workshops on, EDBT '13, pp.1-8, 2013.
DOI : 10.1145/2457317.2457319

C. I. Ezeife and K. Barker, Vertical fragmentation for advanced object models in a distributed object based system, Proc. 8th Int. Conf. on Computing and Information, 1995.

A. Forestiero, C. Mastroianni, and G. Spezzano, QoS-based dissemination of content in Grids, Future Generation Computer Systems, vol.24, issue.3, pp.235-244, 2008.
DOI : 10.1016/j.future.2007.05.003

I. Foster, C. Kesselman, and S. Tuecke, The Anatomy of the Grid: Enabling Scalable Virtual Organizations, International Journal of High Performance Computing Applications, vol.15, issue.3, pp.200-222, 2001.
DOI : 10.1177/109434200101500302

Y. Fu-huang and J. Her-chen, Fragment allocation in distributed database design, Journal of Information Science and Engineering, vol.17, pp.491-506, 2001.

P. Furtado, Experimental evidence on partitioning in parallel data warehouses, Proceedings of the 7th ACM international workshop on Data warehousing and OLAP , DOLAP '04, pp.23-30, 2004.
DOI : 10.1145/1031763.1031769

C. A. Galindo-legaria, A. Pellenkoft, and M. L. Kersten, Fast, randomized join-order selection -why use transformations?, Proceedings of the 20th International Conference on Very Large Data Bases, pp.85-95, 1994.

R. Gallersdörfer and M. Nicola, Improving performance in replicated databases through relaxed coherency, Proceedings of the 21th International Conference on Very Large Data Bases, VLDB '95, pp.445-456, 1995.

M. Golfarelli, Data warehouse life-cycle and design, Encyclopedia of Database Systems, pp.658-664, 2009.

M. Golfarelli, D. Maio, and S. Rizzi, THE DIMENSIONAL FACT MODEL: A CONCEPTUAL MODEL FOR DATA WAREHOUSES, International Journal of Cooperative Information Systems, vol.07, issue.02n03, pp.215-247, 1998.
DOI : 10.1142/S0218843098000118

N. Gorla, Subquery allocations in distributed databases using genetic algorithms, Journal of Computer Science & Technology, vol.1, 2010.

N. Gorla and B. P. Yan, Vertical fragmentation in databases using data-mining technique, Database Technologies: Concepts, Methodologies, Tools, and Applications, pp.2543-2563, 2009.
DOI : 10.4018/jdwm.2008070103

A. Gounaris, J. Smith, N. W. Paton, R. Sakellariou, A. A. Fernandes et al., Adaptive workload allocation in query processing in??autonomous heterogeneous environments, Distributed and Parallel Databases, vol.53, issue.3, pp.125-164, 2009.
DOI : 10.1007/s10619-008-7032-5

J. Gray, P. Helland, P. O. Neil, and D. Shasha, The dangers of replication and a solution, ACM SIGMOD Record, vol.25, issue.2, pp.173-182, 1996.
DOI : 10.1145/235968.233330

T. P. Group, A benchmark of nonstop sql on the debit credit transaction, SIGMOD Rec, vol.17, issue.3, pp.337-341, 1988.

J. R. Gruser, Modèle de coût pour l'optimisation de requête objet, Thèse de doctorat, 1996.

R. Gupta, O. Kumar, and A. Sharma, Article: Analytical study of various high performance computing paradigms, International Journal of Applied Information Systems, vol.1, issue.9, pp.16-21, 2012.

I. O. Hababeh, M. Ramachandran, and N. Bowring, A high-performance computing method for data allocation in distributed database systems, The Journal of Supercomputing, vol.28, issue.3, pp.3-18, 2007.
DOI : 10.1007/s11227-006-0001-8

W. Hasan, Open issues in parallel query optimization, ACM SIGMOD Record, vol.25, issue.3, 1996.
DOI : 10.1145/234889.234894

J. Holland, Adaptation in Natural and Artificial Systems, 1975.

H. I. Hsiao and D. J. Dewitt, Chained declustering: a new availability strategy for multiprocessor database machines, [1990] Proceedings. Sixth International Conference on Data Engineering, pp.456-465, 1990.
DOI : 10.1109/ICDE.1990.113499

T. Ibaraki and T. Kameda, On the optimal nesting order for computing N-relational joins, ACM Transactions on Database Systems, vol.9, issue.3, pp.482-502, 1984.
DOI : 10.1145/1270.1498

W. H. Inmon, Building the Data Warehouse, 2002.

Y. Ioannidis and Y. Kang, Randomized algorithms algorithms for optimizing large join queries, ACM SIGMOD International Conference on Management of Data, pp.9-22, 1990.
DOI : 10.1145/93605.98740

URL : http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.96.9069

Y. E. Ioannidis, Universality of serial histograms, Proceedings of the International Conference on Very Large Databases (VLDB), pp.256-267, 1993.

Y. E. Ioannidis and S. Christodoulakis, On the propagation of errors in the size of join results, Proceedings of the ACM SIGMOD International Conference on Management of Data, pp.268-277, 1991.

Y. E. Ioannidis and E. Wong, Query optimization by simulated annealing, Proceedings of the 1987 ACM SIGMOD International Conference on Management of Data, pp.9-22, 1987.
DOI : 10.1145/38714.38722

URL : https://minds.wisconsin.edu/bitstream/handle/1793/58824/TR693.pdf?sequence=1

M. R. Jensen, T. Holmgren, T. B. Pedersen, E. G. Jr, J. Y. Leung et al., Discovering multidimensional structure in relational data Bin packing: Maximizing the number of pieces packed, DaWaK, pp.138-148263, 1978.

K. Adl and S. M. Rankoohi, A new ant colony optimization based algorithm for data allocation problem in distributed databases, Knowl. Inf. Syst, vol.20, issue.3, pp.349-373, 2009.

K. Karlapalem and N. Pun, Query-driven data allocation algorithms for distributed database systems, 8th International Conference on Database and Expert Systems Applications, pp.347-356, 1997.
DOI : 10.1007/BFb0022044

R. Kimball, L. Reeves, W. Thornthwaite, M. Ross, and W. Thornwaite, The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom, 1998.

M. Kitsuregawa and Y. Ogawa, Bucket spreading parallel hash: A new, robust, parallel hash join method for data skew in the super database computer (sdc), Proceedings of the 16th International Conference on Very Large Data Bases, VLDB '90, pp.210-221, 1990.

W. Labio, D. Quass, and B. Adelberg, Physical database design for data warehouses, Proceedings 13th International Conference on Data Engineering, 1997.
DOI : 10.1109/ICDE.1997.581802

A. A. Lima, M. Mattoso, and P. Valduriez, Adaptive Virtual Partitioning for OLAP Query Processing in a Database Cluster, pp.92-105, 2004.
URL : https://hal.archives-ouvertes.fr/hal-00684957

A. A. Lima, M. Mattoso, and P. Valduriez, OLAP Query Processing in a Database Cluster, Euro-Par, pp.355-362, 2004.
DOI : 10.1007/978-3-540-27866-5_46

URL : https://hal.archives-ouvertes.fr/hal-00684957

A. B. Lima, C. Furtado, P. Valduriez, and M. Mattoso, Parallel olap query processing in database clusters with data replication. distributed and parallel databases. Distributed and Parallel Database Journal, pp.97-123, 2009.
URL : https://hal.archives-ouvertes.fr/inria-00473537

M. G. Lohman, D. Daniels, L. M. Haas, R. Kistler, and P. G. Selinger, Optimization of nested queries in a distributed relational database, Proceedings of the International Conference on Very Large Databases (VLDB), pp.403-415, 1984.

T. Loukopoulos and I. Ahmad, Static and adaptive distributed data replication using genetic algorithms, Journal of Parallel and Distributed Computing, vol.64, issue.11, pp.1270-1285, 2004.
DOI : 10.1016/j.jpdc.2004.04.005

URL : http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.137.8378

T. Mahapatra and S. Mishra, Oracle Parallel Processing, 2000.

H. Märtens, E. Rahm, and T. Stöhr, Dynamic query scheduling in parallel data warehouses: Concurrency computation practice and experience, International Conference on Parallel Processing (Euro-Par02, pp.11-12, 2003.

M. Mehta and D. J. Dewitt, Data placement in shared-nothing parallel database systems, The VLDB Journal The International Journal on Very Large Data Bases, vol.6, issue.1, pp.53-72, 1997.
DOI : 10.1007/s007780050033

S. Navathe, S. Ceri, G. Wiederhold, and J. Dou, Vertical partitioning algorithms for database design, ACM Transactions on Database Systems, vol.9, issue.4, pp.681-710, 1984.
DOI : 10.1145/1994.2209

S. Navathe, K. Karlapalem, and M. Ra, A mixed partitioning methodology for distributed database design, Journal of Computer and Software Engineering, vol.3, issue.4, pp.395-426, 1995.

S. Navathe and M. Ra, Vertical partitioning for database design : a graphical algorithm, ACM SIGMOD International Conference on Management of Data, pp.440-450, 1989.

R. V. Nehme and N. Bruno, Automated partitioning design in parallel database systems, Proceedings of the 2011 international conference on Management of data, SIGMOD '11, pp.1137-1148, 2011.
DOI : 10.1145/1989323.1989444

A. Y. Noaman and K. Barker, A horizontal fragmentation algorithm for the fact relation in a distributed data warehouse, Proceedings of the eighth international conference on Information and knowledge management , CIKM '99, pp.154-161, 1999.
DOI : 10.1145/319950.319972

B. Nuseibeh and S. Easterbrook, Requirements engineering, Proceedings of the conference on The future of Software engineering , ICSE '00, pp.35-46, 2000.
DOI : 10.1145/336512.336523

P. O. Neil, E. B. Neil, and X. Chen, The star schema benchmark, 2007.

M. Özsu and P. Valduriez, Principles of Distributed Database Systems, 1991.

M. T. Özsu and P. Valduriez, Distributed database systems: where are we now?, Computer, vol.24, issue.8, pp.68-78, 1991.
DOI : 10.1109/2.84879

M. T. Özsu and P. Valduriez, Principles of Distributed Database Systems : Second Edition, 1999.

M. T. Özsu and P. Valduriez, Principles of Distributed Database Systems, 2011.

T. M. Özsu and P. Valduriez, Principles of Distributed Database Systems, 2011.

A. Pavlo, C. Curino, and S. Zdonik, Skew-aware automatic database partitioning in shared-nothing, parallel OLTP systems, Proceedings of the 2012 international conference on Management of Data, SIGMOD '12, pp.61-72, 2012.
DOI : 10.1145/2213836.2213844

T. Phan and W. Li, Load distribution of analytical query workloads for database cluster architectures, Proceedings of the 11th international conference on Extending database technology Advances in database technology, EDBT '08, pp.169-180, 2008.
DOI : 10.1145/1353343.1353367

R. Ramakrishnan, Database Management Systems, 1998.

J. Rao, C. Zhang, G. Lohman, and N. Megiddo, Automating physical database design in a parallel database, Proceedings of the 2002 ACM SIGMOD international conference on Management of data , SIGMOD '02, pp.558-569, 2002.
DOI : 10.1145/564691.564757

U. Röhm, K. Böhm, and H. Schek, OLAP Query Routing and Physical Design in a Database Cluster, EDBT, pp.254-268, 2000.
DOI : 10.1007/3-540-46439-5_18

D. Saccà and G. Wiederhold, Database partitioning in a cluster of processors, ACM Transactions on Database Systems, vol.10, issue.1, pp.29-56, 1985.
DOI : 10.1145/3148.3161

R. Sarathy, B. Shetty, and A. Sen, A constrained nonlinear 0???1 program for data allocation, European Journal of Operational Research, vol.102, issue.3, pp.626-647, 1997.
DOI : 10.1016/S0377-2217(96)00234-2

T. K. Sellis, Multiple-query optimization, ACM Transactions on Database Systems, vol.13, issue.1, pp.23-52, 1988.
DOI : 10.1145/42201.42203

T. K. Sellis and A. Simitsis, ETL Workflows: From Formal Specification to Optimization, ADBIS, pp.1-11, 2007.
DOI : 10.1007/978-3-540-75185-4_1

K. Selma, Cycle de vie sémantique de conception de systèmes de stockage et de manipulation de données, 2007.

B. Soumia, B. Ladjel, and A. Cuzzocrea, Omniscience dans la conception des entrepôts de données parallèles sur un cluster, RNTI, editor, EDA, pp.43-52, 2009.

M. Steinbrunn, G. Moerkotte, and A. Kemper, Heuristic and randomized optimization for the join ordering problem, The VLDB Journal The International Journal on Very Large Data Bases, vol.6, issue.3, pp.191-208, 1997.
DOI : 10.1007/s007780050040

T. Stöhr, H. Märtens, and E. Rahm, Multi-dimensional database allocation for parallel data warehouses, Proceedings of the International Conference on Very Large Databases (VLDB), pp.273-284, 2000.

T. Stöhr and E. Rahm, Warlock: A data allocation tool for parallel warehouses, Proceedings of the International Conference on Very Large Databases (VLDB), pp.721-722, 2001.

D. Taniar, C. H. Leung, W. Rahayu, and S. Goel, High Performance Parallel Database Processing and Grid Databases, 2008.
DOI : 10.1002/9780470391365

URL : http://arrow.latrobe.edu.au:8080/vital/access/manager/Repository/latrobe:26501/SOURCE1

D. Taniar and J. W. Rahayu, A taxonomy of indexing schemes for parallel database systems. Distributed and Parallel Databases, pp.73-106, 2002.

. Teradata, Dbc/1012 database computer system manual release 2.0, 1985.

. Teradata, Database. database design. teradata. Release 13, 2010.

M. Thiele, A. Bader, and W. Lehner, Multi-objective scheduling for real-time data warehouses, Computer Science - Research and Development, vol.26, issue.1, pp.137-151, 2009.
DOI : 10.1007/s00450-009-0062-z

A. Tucker, J. Crampton, and S. Swift, RGFGA: An Efficient Representation and Crossover for Grouping Genetic Algorithms, Evolutionary Computation, vol.5, issue.4, pp.477-499, 2005.
DOI : 10.2307/2282967

J. D. Ullman, Principles of Database and Knowledge-Base Systems, 1989.

P. Valduriez, Parallel database systems: The case for shared-something, Proceedings of IEEE 9th International Conference on Data Engineering, pp.460-465, 1993.
DOI : 10.1109/ICDE.1993.344035

R. Vanderbei, Linear Programming: Foundations and Extensions, Second Edition, 2001.

C. B. Walton, A. G. Dale, and R. M. Jenevein, A taxonomy and performance model of data skew effects in parallel joins, Proceedings of the 17th International Conference on Very Large Data Bases, VLDB '91, pp.537-548, 1991.

R. Winter and B. Strauch, A method for demand-driven information requirements analysis in data warehousing projects, 36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the, pp.231-232, 2003.
DOI : 10.1109/HICSS.2003.1174602

J. L. Wolf, D. M. Dias, P. S. Yu, and J. Turek, New algorithms for parallelizing relational database joins in the presence of data skew, IEEE Transactions on Knowledge and Data Engineering, vol.6, issue.6, pp.990-997, 1994.
DOI : 10.1109/69.334888

O. Wolfson and A. Milo, The multicast policy and its relationship to replicated data placement, ACM Transactions on Database Systems, vol.16, issue.1, pp.181-205, 1991.
DOI : 10.1145/103140.103146

S. Yih-hwang, K. K. Lee, and Y. H. Chin, Data replication in a distributed system: A performance study, 7 th International Conference on Database and Expert Systems Applications, pp.708-717, 1996.
DOI : 10.1007/BFb0034724

J. X. Yu, X. Yao, C. Choi, and G. Gou, Materialized view selection as constrained evolutionary optimization, IEEE Transactions on Systems, Man and Cybernetics, Part C (Applications and Reviews), vol.33, issue.4, pp.458-467, 2003.
DOI : 10.1109/TSMCC.2003.818494

C. Zhang and J. Yang, Genetic Algorithm for Materialized View Selection in Data Warehouse Environments, 1st International Conference on Data Warehousing and Knowledge Discovery (DAWAK), pp.116-125, 1999.
DOI : 10.1007/3-540-48298-9_12

H. Zhu, P. Gu, and J. Wang, Shifted declustering, Proceedings of the 22nd annual international conference on Supercomputing , ICS '08, pp.134-144, 2008.
DOI : 10.1145/1375527.1375549

D. C. Zilio, A. Jhingran, and S. Padmanabhan, Partitioning key selection for a sharednothing parallel database system, In IBM Research Report RC, 1994.

D. C. Zilio, J. Rao, S. Lightstone, G. M. Lohman, A. Storm et al., DB2 Design Advisor, Proceedings of the International Conference on Very Large Databases (VLDB), pp.1087-1097, 2004.
DOI : 10.1016/B978-012088469-8.50095-4