• Home
  • Search
  • SQL optimization in a parallel processing database system
  • Open Access IconOpen Access
  • Cite Icon3
  • https://doi.org/10.1109/ccece.2013.6567832Copy DOI Icon

SQL optimization in a parallel processing database system

  • May 1, 2013
  • Nayem Rahman
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
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.

Similar Papers
  • Research Article

Parallel Database Techniques

  • Jan 03, 2001
  • Scalable Computing Practice and Experience
  • Michelle Pal
  • Research Article

Structured Parallel Efficient Execution Database Management System Over Enormous Dataset with MapReduce using Matlab

  • Feb 01, 2017
  • Indian Journal of Science and Technology
  • Uma Mahesh Kumar Gandham +1
  • Book Chapter
  • Citations11

Distributed and Parallel Database Systems

  • Jun 28, 2004
  • M Tamer Özsu +1
  • Book Chapter
  • Citations11

Distributed and Parallel Database Systems

  • May 01, 2014
  • M Özsu +1
  • Conference Article
  • Citations32

Parallel processing and trusted database management systems

  • Jan 01, 1993
  • Bhavani Thuraisingham +1
  • Research Article
  • Citations1

Enhancing database performance through SQL optimization, parallel processing and GPU integration

  • Jan 01, 2024
  • BIO Web of Conferences
  • Marat Nuriev +4
  • Book Chapter
  • Citations12

Verification of Partitioning and Allocation Techniques on Teradata DBMS

  • Jan 01, 2011
  • Ladjel Bellatreche +4
  • Book Chapter
  • Citations4

A Scalable Randomized Algorithm for Triangle Enumeration on Graphs Based on SQL Queries

  • Jan 01, 2020
  • Abir Farouzi +4
  • Research Article
  • Citations2466

Bounds on Multiprocessing Timing Anomalies

  • Mar 01, 1969
  • SIAM Journal on Applied Mathematics
  • R L Graham
  • Conference Article

A parallel extension for existing relational database management systems

  • Jul 02, 1997
  • M Exbrayat +1
  • Book Chapter
  • Citations4

Offering parallelism to a sequential database management system on a network of workstations using PVM

  • Jan 01, 1997
  • Matthieu Exbrayat +1
  • Conference Article
  • Citations1156

A comparison of approaches to large-scale data analysis

  • Jun 29, 2009
  • Andrew Pavlo +6
  • Conference Article
  • Citations59

Analyzing massive astrophysical datasets: Can Pig/Hadoop or a relational DBMS help?

  • Jan 01, 2009
  • Sarah Loebman +5
  • Conference Article
  • Citations36

Supporting temporal multimedia operations in object-oriented database systems

  • Jan 01, 1994
  • Aberer +1
  • Book Chapter
  • Citations15

On transforming a sequential SQL-DBMS into a parallel one: First results and experiences of the MIDAS project

  • Jan 01, 1996
  • Giannis Bozas +5
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.