Research Output
Control of a large massively parallel database machine using SQL catalogue extensions, and a DSDL in preference to an operating system
  The IDIOMS parallel database machine supports large applications where integrated OLTP and MIS is required. It can be considered a relational engine, and SQL is used as the MIS query language. We make some comparisons between IDIOMS and other database machines. We justify why IDIOMS does not use an operating system, and why a Data Storage Description Language (DSDL) is used to control data placement. Our implementation extends the SQL2 information schema tables. These extensions, which are described in detail, can be used by a Data Dictionary process to control resource allocation and data access. General principles behind further extensions which can be used to improve data partitioning are discussed. By means of examples, we show how our extensions support multi-column partitioning, and how, with such a partitioning strategy, MIS query access time can be reduced.

  • Date:

    31 December 1992

  • Publication Status:

    Published

  • Publisher

    Springer Berlin Heidelberg

  • DOI:

    10.1007/3-540-55693-1_36

  • ISSN:

    0302-9743

  • Library of Congress:

    QA75 Electronic computers. Computer science

  • Dewey Decimal Classification:

    004 Data processing & computer science

  • Funders:

    Historic Funder (pre-Worktribe)

Citation

Unwalla, M., & Kerridge, J. (1992). Control of a large massively parallel database machine using SQL catalogue extensions, and a DSDL in preference to an operating system. In Advanced Database Systems: 10th British National Conference on Databases, BNCOD 10 Aberdeen, Scotland, July 6–8, 1992 Proceedings, 138-155. https://doi.org/10.1007/3-540-55693-1_36

Authors

Keywords

parallel database; SQL; IDIOMS; DSDL; data partitioning

Monthly Views:

Available Documents