Title :
SQL optimization in a parallel processing database system
Abstract :
A database management system (DBMS) with a parallel processing database system is different from conventional database systems. Accordingly, writing SQL for a parallel processing DBMS requires special attention to maintain parallel efficiency in DBMS resources usage such as CPU and I/O. This paper discusses the techniques in SQL writing, tuning, utilization of index, data distribution techniques in a parallel processing DBMS architecture. The resource savings statistics based on several experiments show significant reduction of computing resources usage and improvement of parallel efficiency (PE) can be achieved by using different optimization techniques.
Keywords :
SQL; optimisation; parallel processing; relational databases; resource allocation; CPU; I/O utilization; SQL index utilization; SQL optimization technique; SQL tuning technique; SQL writing technique; computing resource usage; data distribution techniques; database management system; parallel efficiency improvement; parallel processing DBMS architecture; parallel processing database system; resource saving statistics; Computer architecture; Data warehouses; Indexes; Parallel processing; Warehousing; CPU; Computing Resources; DBMS; Data Warehouse; Database System; I/O; Parallel Processing;
Conference_Titel :
Electrical and Computer Engineering (CCECE), 2013 26th Annual IEEE Canadian Conference on
Conference_Location :
Regina, SK
Print_ISBN :
978-1-4799-0031-2
Electronic_ISBN :
0840-7789
DOI :
10.1109/CCECE.2013.6567832
